# Financial Modelling in Excel

> Build robust, flexible financial models for budgets, valuations and project appraisal.

- **Provider:** Afriskora Training Solutions
- **Category:** Finance, Accounting & Audit
- **Duration:** 5 days
- **Formats:** classroom (cities across Africa), live virtual (Zoom/Teams), in-house for teams
- **Certificate:** Afriskora Certificate of Completion, verifiable online
- **Booking:** request dates and a quote; invoice and EFT payment
- **Web page:** https://afriskora.co.za/courses/finance-accounting-audit/financial-modelling-in-excel
- **Request dates:** https://afriskora.co.za/request-training?course=financial-modelling-in-excel

## 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

## Learning outcomes

- 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 1: Modelling best practice

- Model design principles
- Inputs, calculations, outputs
- Useful Excel functions
- Error checks

### Day 2: Three-statement models

- Revenue and cost drivers
- Linking the statements
- Balancing the balance sheet
- Debt schedules

### Day 3: Project and PPP models

- Project cash flows
- Financing structures
- Debt service ratios
- Returns to investors

### Day 4: Valuation

- Discounted cash flow
- WACC
- Terminal value
- Comparables

### Day 5: Scenarios and review

- Scenario and sensitivity analysis
- Data tables
- Model audit
- Presenting results