Financial Projections Excel Template
Originally published: 24/09/2018 09:20
Last version published: 28/05/2019 12:21
Publication number: ELQ-75067-4
View all versions & Certificate
certified

Financial Projections Excel Template

Our financial projections template provides everything needed to create 5 year startup financial projections.

Description
This free 4 page Excel startup business plan financial projections template can be used by any business to produce income statements, balance sheets and cash flow projections for the full five year period.

What’s Included in the Financial Projection Template?

There are four pages to the financial projection template, supplying everything you need to test out your business idea.

1. The first page of the financial projections template shows income statements for the business for 5 years.
2. The second page of the financial projections template shows the opening balance sheet and the balance sheets for 5 years.
3. The third page provides the cash flow statements for 5 years.
4. The final page of the financial projections template contains a selection of useful financial ratios for comparison purposes, together with revenue, net income, cash balance, and cumulative free cash flow by year in graph form for easy reference.

How to use the Financial Projections Template

If you want to know how to use the financial projections template, then we recommend reading our How to Make Financial Projections post, which explains each step in detail.

Additional templates and calculators are available to help you calculate revenue, weighted average gross margin, and activity ratios such as accounts receivable, inventory and accounts payable days, for use in the financial projections template.

This Best Practice includes
1 Excel File

Plan Projections offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Everything you need to create perfect business financial projections for startups. The Plan Projections template produces the three main financial statements, income statements, balance sheets, and cash flow statements for the next five years.

The core template is built using Excel


4.5 / 5 (53 votes)

please wait...