Financial projections

Summary

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 kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €75.00  (€75.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00
CPD hours:  
3.00
Speaker details
First nameLast name
Kubicle

Description

Product type:  
CPD online course
Category:  
Information technology

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.