Financial Modelling in Excel
Build robust, flexible financial models for budgets, valuations and project appraisal.
- 5 days
- Classroom · Live virtual · In-house
- Afriskora Certificate of Completion
Course overview
Participants learn to build three-statement models, project finance and valuation models in Excel using best-practice structure and checks. The course emphasises clarity and error-proofing, so models can be trusted and reviewed by others.
Who should attend
- Financial analysts
- Corporate finance and investment staff
- Project finance and PPP teams
- Accountants who build models
What you will be able to do
- Structure models using best practice
- Build linked three-statement models
- Model project cash flows and returns
- Run scenarios and sensitivities
- Check and audit models
Course outline
Day 1Modelling best practice
- • Model design principles
- • Inputs, calculations, outputs
- • Useful Excel functions
- • Error checks
Day 2Three-statement models
- • Revenue and cost drivers
- • Linking the statements
- • Balancing the balance sheet
- • Debt schedules
Day 3Project and PPP models
- • Project cash flows
- • Financing structures
- • Debt service ratios
- • Returns to investors
Day 4Valuation
- • Discounted cash flow
- • WACC
- • Terminal value
- • Comparables
Day 5Scenarios and review
- • Scenario and sensitivity analysis
- • Data tables
- • Model audit
- • Presenting results
Frequently asked questions
How long is the Financial Modelling in Excel course?
The course runs for 5 days. Daily start and finish times are confirmed in your joining instructions. Live virtual sessions cover the same programme.
Do I receive a certificate?
Yes. Every participant who completes the course receives an Afriskora Certificate of Completion with a unique code that employers can verify online.
Can this course be delivered in-house for our team?
Yes. We can run it at your premises or online for your team, on dates that suit you, and adapt examples and case studies to your sector.
How do I book and pay?
Request dates and we'll send available sessions and a quote. Bookings are confirmed by invoice and paid by EFT. South African clients can include the course in their Workplace Skills Plan.
Related courses
Finance for Non-Financial Managers
Read financial statements, manage budgets and make financially sound decisions without an accounting background.
5 daysIFRS and IPSAS: Interpretation and Application
Apply current IFRS and IPSAS standards correctly in financial reporting for private and public entities.
5 daysBudgeting, Forecasting and Financial Planning
Build realistic budgets and forecasts that support strategy and keep spending under control.
5 days