Booking Information
Once you have booked your course, the link to the recording will be available
in your "My Account" area.
Please be aware that you will have access to this course for 180 days from
the date of purchase
Online courses cannot be booked on behalf of someone else. Access will only
be granted to the person completing the online order.
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.