Building a Financial Model - eLearning
This activity is published by accountingcpd.
CA ANZ members are entitled to receive 10% off every purchase. Use code CAANZ101 at checkout to take advantage of this discount.
Save $180 and get 20 hours of CPD at your fingertips when you pick ANY 5 4-hr CPD courses for just $495 – use code CAANZ20 at checkout.
A financial model is simply a tool that’s built in Excel to forecast a business’ financial performance into the future. This course walks you through the steps to build a financial model.
Every financial model is built on the same foundations: an understanding of its purpose, who it is for, and its scope. This course explains how to set up the Excel spreadsheet and complete the initial steps of building a financial model, structuring calculations, and looking into costs and revenues, time periods, cash balances and reporting.
Upon satisfactory completion of this activity you will be able to:
• Set up and build a comprehensive financial model.
• Calculate costs and revenues.
• Decide which time periods you need to use and when and where to use flags.
• Create understandable and useful reports.
This course ensures you understand the fundamentals of financial models and are able to use a model building approach applicable for all your financial modelling requirements.
No materials distributed.
No assessments required.
Topic: Corporate Finance, Reporting
Sub-Topic: Financial Modelling, Financial Reporting
Proficiency Level: Intermediate
CPD: 4 hours