Three Statement Projection Model in Excel
Originally published: 29/01/2018 09:18
Last version published: 06/04/2018 16:44
Publication number: ELQ-63720-2
View all versions & Certificate

Three Statement Projection Model in Excel

A simple fully integrated 5 year financial statement projection model in Excel

This model contains a 5 year fully integrated income statement, balance sheet, and cash flow statement projection model in Excel. Projection assumptions are housed on a single sheet, and any assumption changes flow through the whole model.

Line items have been kept as generic as possible to allow for wider use of the model. Users will need to build in their own details if further granularity is required.


3 years of historical results and a 5 year projection
User guide
Summary section
Dynamic graphs
Ratios for analysis
Currency selection
Cash sweep and Dividends options
Error checks

This Best Practice includes
1 x Excel model

Steven Harper offers you this Best Practice for free!

download for free

Add to bookmarks



keyboard_arrow_downShow all


Any questions on Three Statement Projection Model In Excel?

The user community and author are here to help. Go ahead!

4.6 / 5 (53 votes)

please wait...