Financial Modeling for Investment Analysis
السعر: 1,183 درهم
  • مواعيد الدورة: استفسار

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

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? 
  تحديث بتاريخ 15 May, 2019

استفسر عن هذه الدورة

يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.

قيِم هذه الصفحة