Course

Financial Modelling & Analysis

The Financial Modelling and Analysis online short course introduces you to the fundamental concepts required for Excel-based modelling 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 an expert facilitator, you’ll learn to recommend strategic business decisions with the use of financial modelling, and create a discounted cash flow analysis using financial forecasts.

0 Lessons

Financial Modelling & Analysis

The Financial Modelling and Analysis online short course introduces you to the fundamental concepts required for Excel-based modelling 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 an expert facilitator, you’ll learn to recommend strategic business decisions with the use of financial modelling, and create a discounted cash flow analysis using financial forecasts.

Mzoxolo Gulwa · October 20, 2020

Short Course

Duration: 4 hours

Price: R499

Overview

Financial modelling 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 introduces you to the fundamental concepts required for Excel-based modelling 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 an expert facilitator, you’ll learn to recommend strategic business decisions with the use of financial modelling, and create a discounted cash flow analysis using financial forecasts.

Learning Outcomes

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.

Key topics to be covered

  • 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

Who is this course for?

The course is 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.

This course includes:

  • 4 hours on-demand video
  • 3 articles
  • 6 editable templates
  • Full lifetime access
  • Access on mobile  

To enquire about this course:

  • This field is for validation purposes and should be left unchanged.

About Instructor

Not Enrolled
Course content coming soonR499

Responses