Skip to main content
Financial Modeling Essentials

Financial Projections

If you want to know how to use your data to predict future financial outcomes, you must know how to ask the right questions of it. Financial projections are used by a variety of different stakeholders in a business to answer important questions about the company. In this course, you’ll discover how to use Excel to create them.

Intermediate        13 Lessons        150 Minutes        CPD Credits
TRY FOR FREEEXPLORE OUR LIBRARY

About This Course

You can use Excel to help build financial projections for your company’s future. In this course, you’ll learn what information you need to gather, and how to analyze it.

Across 13 lessons, you’ll see how working with your existing financial statements can help in building projections and how financial modelling can be applied.

By the end of the course, you should have a greater understanding of how to use Excel to mine your data for patterns that can help predict future outcomes.

GET STARTED

Learning Outcomes

  • Explain the purpose of creating financial projections
  • Create assumptions and projections for an Income Statement
  • Calculate projections for capital expenditure and depreciation
  • Create assumptions and projections for a Balance Sheet
  • Create assumptions and projections for a Statement of Cash Flows
  • Adjust projections and maintain a balanced model

Lessons

1. Why Build Financial Projections?
2. Structuring Projections in Excel
3. Creating Income Statement Assumptions
4. Building Projections for the Income Statement
5. Capital Expenditure and Depreciation
6. Creating Balance Sheet Assumptions Part 1

Read More

7. Creating Balance Sheet Assumptions Part 2
8. Building Projections for the Balance Sheet
9. Completing Balance Sheet Projections
10. Projecting Operating Cashflows
11. Completing Our Financial Projections
12. Keeping the Model Balanced
13. Reviewing Financial Projections
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world