Financial Modeling, Analysis and Forecasting Executive Forum

Add to Wishlist

About the Course:

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


Target Outcomes:

By the end of the course, participants will be able to:

  • Prepare effective financial models utilizing powerful Excel functions
  • Use core financial modelling techniques
  • Forecast investments and calculate valuations of projects and companies in an effective manner
  • Develop comprehensive financial models to support investments decisions
  • Recognize special modelling 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. All accountants and finance staff members.


Target Competencies:

  • Using advanced Excel
  • Performing capital budgeting analysis
  • Forecasting cash flow
  • Calculating the cost of capital
  • Practising financial modelling
  • Understanding scenario analysis
  • Calculating free cash flow


Advanced Excel for financial modelling

  • Excel tips and tricks that will help you speed up your spreadsheet
  • 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 modelling

  • 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
  • Focusing on income statement or cash flow?


Valuation techniques

  • Analyzing historical information and developing 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 multiple

Building real-life models

  • How financial models work
  •  Modelling income statements
  • Modelling balance sheets
  • Sensitivity analysis
  • Developing an integrated financial model
    • Automotive
    • Hospitality
    • Real estate
    • Education


Special modelling and valuation considerations

  • Structured valuations
  • Financial modelling best practices
  • Return on Investment (ROI) and Return on Equity (ROE)
  • Investment structures
    • Direct ownership
    • Partnership and joint venture
    • Build, Operate and Transfer (BOT)