Learn to construct predictive financial models in Excel to inform better asset management and investment decisions.
8 weeks, excluding
8–10 hours per week,
self-paced learning online
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.1
1 QS Top Universities (2019).
Over the duration of this online short course, you’ll work through the following modules:
Module 1: Using Financial Modelling Effectively
Explore the fundamental skills and best practices required to become proficient in Excel-based financial modelling.
Module 2: Accounting Statements
Discover the various accounting statements, their purposes, and how they are related and interpreted.
Module 3: Building the Three Statement Model
Discover how to create a three statement model, comprising the balance sheet, income statement, and cash flow statement.
Module 4: Forecasting the Three Statement Model
Explore the various ways of forecasting and extending the three statement model, which is driven by underlying business assumptions.
Module 5: Sensitivity and Scenario Analysis
Discover the differing degrees to which varying inputs affect outputs in a model.
Module 6: Modelling Different Types of Businesses
Discover the differences within financial statements in relation to differences in industry.
Module 7: Using Financial Models for Decision-Making in Business
Explore how financial models are used in strategic business decisions.
Module 8: Using Financial Models for Valuation
Discover how a financial forecast is applied into a discounted cash flow valuation model.
Associate Professor, Department of Finance and Tax, UCT
Toerien lectures investment ethics, alternative investments, equity investments, and corporate finance at third- and fourth-year levels. In his study, “The Impact of Aid and Public Investment Volatility on Economic Growth in Sub-Saharan Africa”, Toerien investigated the effects of aid inflows and the volatility of public investment on economic growth in 26 sub-Saharan African countries over the period 1992 to 2011. Alongside supervising postgraduate research, his interests lie in public equities, private equity and entrepreneurial finance, carbon credits and environmentally driven markets, developing market investments, and entrepreneurial finance.
This UCT online short course is delivered in collaboration with online education provider GetSmarter. Join a growing community of global professionals, and benefit from the opportunity to:
Gain verifiable and relevant competencies and earn invaluable recognition from an international selection of universities, entirely online and in your own time
Enjoy a personalised, people-mediated online learning experience created to make you feel supported at every step
Experience a flexible but structured approach to online education as you plan your learning around your life to meet weekly milestones
Want to know more?
Enter your information below to learn more about the UCT Financial Modelling and Analysis online short course, including receiving the course prospectus, from GetSmarter.
* Required Field