Duration: 4 hours
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.
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