Course Overview

Organizations cannot afford to make the wrong investments decisions because such decisions have a long-term impact on the business and could make or break the organization. That is why it is critical to master financial modeling techniques as they are the main basis for investment decisions. By helping you understand and build effective financial models, this course will have a significant impact on the effectiveness and feasibility of your investments decisions.
 

Course Methodology

This course uses hands-on application of financial modeling in Excel in addition to demonstrating theoretical core topics. The course also features real-life case studies and presentations by participants.
 

Course Objectives

By the end of the course, participants will be able to:
  • Prepare effective financial models utilizing powerful Excel functions
  • Use core financial modeling techniques
  • Forecast investments, valuations of projects and companies in an effective manner
  • Develop comprehensive financial models to support investments decisions
  • Recognize special modeling and valuation considerations and best practices

Target Audience

Corporate finance professionals, investment professionals, CFOs, financial controllers, finance managers, financial analysts, corporate bankers, and business development analysts.

Target Competencies

  • Advanced Excel
  • Capital budgeting
  • Forecasting cash flow
  • Calculating cost of capital
  • Financial modeling
  • Scenario analysis
  • Calculating free cash flow
Note
This is a hands-on training course using laptops, which will be made available by VIF for the duration of the training.

Course Outline

Advanced Excel for financial modeling
  • Excel tips and tricks that will help you speed up your spread sheeting
  • Logical tests
  • Protecting your data
  • Database activities
  • Pivot Tables
  • Grouping data
  • Vertical and horizontal lookup tables
  • The magical Choose function
  • Interactive formulas to extract data
  • String functions
  • Data tables
  • Interactive Graphs
Fundamentals of financial modeling
  • Time value of money:
    Present Value (PV) Future Value (FV) and Net Present Value(NPV)
    Internal Rate of Return (IRR) and Multiple IRR (MIRR)
    Equity IRR and project IRR
    Using 'XNPV' and 'XIRR'
    Contradicting NPV and IRR
  • Amortization of loan schedule
  • Enterprise value, market capitalization, firm value and equity value
  • Effective interest rate
  • Compound Annual Growth Rate (CAGR)
  • Investment assumptions and cash flows
    What needs to be included?
    Forecasting revenues
    Forecasting costs and expenses
    Focus on income statement or cash flow?
Valuation techniques
  • Analyze historical information and develop a projection basis
  • Using ratio analysis to prepare projected financial statements
  • Debt capacity and credit analysis for the acquisition
  • Sensitivity analysis on cash flows
  • Weighted Average Cost of Capital (WACC)
  • Adjusted Present Value (APV)
  • Using Capital Assets Pricing Model (CAPM) to determine cost of equity
  • Implied risk premium in the current Price Earnings (PE) multiple
  • Gordon model to determine cost of equity
  • Using PE multiple to determine cost of equity
  • Accrual accounting valuation
  • Valuation using multiples
  • Transaction multiples
Building real life models
  • How financial models work
  • Modeling income statement
  • Modeling balance sheet
  • Sensitivity analysis
  • Developing an integrated financial model
    Automotive
    Hospitality
    Real estate
    Education
Special modeling and valuation considerations
  • Structured valuations
  • Financial modeling best practices
  • Return on Investment (ROI) and Return on Equity (ROE)
  • Investment structures
    Direct ownership
    Partnership and joint venture
    Build, Operate and Transfer (BOT)

 

Location & Dates
Call us at +971 4 430 8394