Financial Modeling for Investment Analysis هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

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?