Financial projections


This course will give you step-by-step guide to creating a 5-year projection for all 3 financial statements in Microsoft Excel. Using the financial statements of a fictional company, you will learn how create assumptions that form the basis of financial projections.  Created & customized for Chartered Accountants Ireland by

Venue details:  
Online EU, ,
Start date & time:  
01 January 2021 00:00
End date & time:  
01 January 2022 00:00
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00 Training Tickets accepted
CPD hours:  
Speaker details
First nameLast name


Product type:  
CPD online course
Kubicle, Technology and data

Who Should Attend?

This course is suitable for advanced learners who are very familiar with writing formulas and performing analysis in Microsoft Excel. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 13 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • Why build financial projections?
  • Structuring projections in Excel
  • Creating income statement assumptions
  • Building projections for the income statement
  • Capital expenditure and depreciation
  • Creating balance sheet assumptions
  • Building projections for the balance sheet
  • Completing balance sheet projections
  • Projecting operating cash flows
  • Completing our financial projections
  • Keeping the model balanced
  • Reviewing financial projections

Key Outcomes

Once you have completed this course you will know how generate a set of assumptions that will drive a set of financial statement projections. You will learn how to connect your income statement projections to both the balance sheet and statement of cash flows projections. Lastly, you will know how to fix common errors that occur in projections, if need arises.