Financial Projections
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
Why Build Financial Projections?
Why Build Financial Projections?
Why and how do companies build financial projections? Find out about this critical analysis tool in this introductory lesson.
Structuring Projections in Excel
Structuring Projections in Excel
Structuring financial projections in Excel is easier than you would think, particularly with this short, helpful lesson.
Creating Income Statement Assumptions
Creating Income Statement Assumptions
To build projections, we first need to identify assumptions for each line item. Let's start in this lesson with the income statement.
Building Projections for the Income Statement
Building Projections for the Income Statement
We are now ready to build our income statement projections, with some help from our knowledgeable supervisor!
Capital Expenditure and Depreciation
Capital Expenditure and Depreciation
Depreciation projections are ideally based on capital expenditure, which you will learn how to do in this lesson.
Initial Balance Sheet Assumptions
Initial Balance Sheet Assumptions
We begin building our balance sheet projections by creating input assumptions for current assets and liabilities.
Further Balance Sheet Assumptions
Further Balance Sheet Assumptions
In this lesson, we create additional balance sheet assumptions for both non-current assets and liabilities. I also discuss the reasoning behind each of my assumptions.
Building Projections for the Balance Sheet
Building Projections for the Balance Sheet
In this lesson, we complete our assumptions for the balance sheet, focusing on individual line items in non-current assets and liabilities.
Completing Balance Sheet Projections
Completing Balance Sheet Projections
In this lesson, we complete our balance sheet projections, creating future projections both long-term liabilities and shareholders' equity.
Projecting Operating Cashflows
Projecting Operating Cashflows
In this lesson, we project operating cashflows, relying not on assumptions but drawing from values already in the income statement and balance sheet.
Completing Our Financial Projections
Completing Our Financial Projections
We complete our financial projections in this lesson by connecting our cashflow statement to the cash figure in our balance sheet.
Keeping the Model Balanced
Keeping the Model Balanced
Each change to your projections should impact the balance sheet in two ways to keep it balanced. This is particularly helpful when debugging errors.
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
