- Duration: 3 Days
Course Overview
A financial model is simply a tool that’s built-in spreadsheet software such as MS Excel to forecast a business’ financial performance into the future. The forecast is typically based on the company’s historical performance, assumptions about the future, and requires preparing an income statement, balance sheet, cash flow statement, and supporting schedules (known as a 3-statement model).
From there, more advanced types of models can be built such as discounted cash flow analysis (DCF model), leveraged-buyout (LBO), mergers and acquisitions (M&A), and sensitivity analysis. Below is an example of financial modeling in Excel.
On Completion of This Course, You’ll Walk Away With:
- Highly practical and in-demand financial modelling skills to augment your finance knowledge.
- The ability to think critically and build financial models to understand characteristics and interpretations of businesses.
- A certificate of completion from UCT, Africa’s leading university.
Course Outline
- Using Financial Modelling Effectively
- Accounting Statements
- Building the Three Statement Model
- Forecasting the Three Statement Model
- Sensitivity and Scenario Analysis
- Modelling Different Types of Businesses
- Using Financial Models for Decision-Making in Business
- Using Financial Models for Valuation.
Graduates possessing B.sc/B.Eng. in computer science, computer engineering, sciences or equivalent with a sound knowledge of relational design database, .Net Framework, Visual Studio, C# Programming and JAVA.
2-3 years of relevant work experience preferable in teaching.
Excellent communication skills and international certifications such as OCAJP, OCPJP and any other qualifications would be preferred.
Graduates possessing B.sc/B.Eng. in computer science, computer engineering, sciences or equivalent with a sound knowledge of relational design database, .Net Framework, Visual Studio, C# Programming and JAVA.
2-3 years of relevant work experience preferable in teaching.
Excellent communication skills and international certifications such as OCAJP, OCPJP and any other qualifications would be preferred.
