University of Cape Town: Financial Modelling and Analysis
Develop your understanding of financial forecasting, corporate valuation, and market analysis in preparation for a career in asset management.
Develop your understanding of financial forecasting, corporate valuation, and market analysis in preparation for a career in asset management.
Get more information
Want to know more? Enter your information to learn more about this course from GetSmarter (an edX partner).
Get more information
Want to know more? Enter your information to learn more about this course from GetSmarter (an edX partner).
Financial Modelling and Analysis
About this Course
Financial modeling skills are used to forecast the financial performance of a business, or to compare it to its industry competitors. The Financial Modelling and Analysis online short course from the University of Cape Town (UCT) introduces you to the fundamental concepts required for Excel-based modeling and forecasting. On it, you’ll develop the skills to create a mathematical model in Microsoft Excel that reflects the historical, current, or projected value or financial performance of an asset, stock, or investment. Guided by expert faculty, you’ll learn to recommend strategic business decisions with the use of financial modeling, and create a discounted cash flow analysis using financial forecasts.
By the end of this course, you’ll have explored how to build revenue models, determine realistic forecast assumptions, and learned how historic data is forecast into the future.
Aimed at existing and aspiring financial analysts, this course offers critical thinking opportunities and an objective lens for which to understand the financial characteristics and interpretations of businesses. With the ability to calculate, forecast, or estimate financial numbers, you’ll hone the quantitative skills needed to excel in this field.
Learn about financial modelling and valuation analysis, and earn an official certificate of completion from the University of Cape Town.
Assessment is continuous and based on a series of practical assignments completed online. In order to be issued with a digital certificate, you’ll need to meet the requirements outlined in the course handbook. The handbook will be made available to you as soon as you begin the course.
Some facts about the subject
A career door opener
Irrespective of your level, financial modeling skills have become one of the most highly sought-after skills for finance professionals today.*
*Supercharged Finance (Sept, 2018).
Three outcomes of a financial model
“Every sector, company, business owner and investor is different, but a good financial model usually contains at least the three outputs: the financial statements, an operational cash flow forecast, and a KPI overview.”
EY (Oct, 2019).