Course Code:
fm1
Duration:
14 hours
Overview:
.
Course Outline:
Brushing up on Excel skills
Working with dates / time series analysis
Concept of “Best Practice” modelling
Laying out a financial model
Understanding the three financial statements – even if you’re an accountant (and even if you’re not)
Concept of three-way integrated modelling
Direct vs. indirect cashflow modelling
Introducing control accounts
Development of a financial model (case study)
o Revenue
o COGS
o Opex
o Capex / depreciation
o Debt
o Tax
o Equity
Key analysis:
o Scenario analysis
o Sensitivity analysis
o Ratio analysis