تفاصيل الدورة
This program offers the opportunity to learn how to develop a unique blend of practical skills in Financial Modeling using Excel to improve your financial projections, analysis, and financial reporting skills in addition to learning how to build a risk analysis model and modeling for business valuations along with relevant simulation and sensitivity analysis techniques.
Who should attend?
This hands-on course is designed for Bankers; Credit Officers; Investment Bankers; Business Valuation consultants; Financial and Risk Analysts; Security and Investment Analysts; Financial Advisors, Corporate Analysts and; Treasury Analysts; Finance Managers and Controllers; Strategy Directors and Managers; Financial Planning and Budgeting Managers; and Project Managers.
Pre-requisites
- Financial Background
- Basic EXCEL Skills
Program Outline
Introduction to Financial Modelling
EXCEL modelling - Basics
Essential EXCEL Methods
Building the Financial Statements; Income Statement (IS), Balance Sheet (BS) and Statement of Cash Flows (SCF)
- Ratio analysis – IS, BS and SCF
- Financial Projections – building up a viable model
- Sensitivity and Scenario Analysis – How to develop?
- Time Value of Money concepts
- Discount rate – How to calculate? What to consider?
- How to build financial models for fixed income products such as Treasury bills, Treasury bonds.)
- Statistical Probability models (Monte Carlo) – what is there?
- Valuation Models: Discounted Cash Flow (DCF) model & Dividends Discount Model (DDM)
- Terminal (residual) value and application of multiples
- What are the most common multiples to rely on?
الموقع
استفسر عن هذه الدورة
يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.
