UNIVERSITY OF CAPE TOWN

FINANCIAL MODELLING AND ANALYSIS

Learn to construct predictive financial models in Excel to inform better asset management and investment decisions.

Duration

8 weeks, excluding
orientation

Effort

8–10 hours per week,
self-paced learning online

Learning Format

Weekly modules,
flexible learning

ON COMPLETION OF THIS COURSE, YOU’LL WALK AWAY WITH:

1

Highly practical and in-demand financial modelling skills to augment your finance knowledge.

2

The ability to think critically and build financial models to understand characteristics and interpretations of businesses.

3

A certificate of completion from UCT, Africa’s leading university.1


1 QS Top Universities (2019).

COURSE CURRICULUM

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.

COURSE CONVENER

Francois Toerien

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.

AN ONLINE EDUCATION THAT SETS YOU APART

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:

usp-slot-one

Gain verifiable and relevant competencies and earn invaluable recognition from an international selection of universities, entirely online and in your own time

usp-slot-two

Enjoy a personalised, people-mediated online learning experience created to make you feel supported at every step

usp-slot-three

Experience a flexible but structured approach to online education as you plan your learning around your life to meet weekly milestones

GET MORE INFORMATION

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

Please enter your first name

Please enter your last name

Please enter a valid email address

Yes, I want to receive more information about the UCT Financial Modelling and Analysis online short course. Contact me by:

Email: *

Please select an option

Phone: *

Please select an option

Please provide a valid phone number

Please select highest level of education

Please select years of work experience

Email me about the educational programmes that GetSmarter (a brand of 2U, Inc.) and the 2U family of companies offer with multiple institutions.

Please select an option

By consenting to receive communications, you agree to the use of your data as described in our privacy policy. You may opt out of receiving communications at any time.