Financial Projections Model for Business Plans

A financial model for projecting financial results for a 5 year period. Co-authored by Frank Moyes

business planfinanceforecastingprediction

This financial model is designed to enable entrepreneurs and students project the financial results of their ventures for a five-year period. As with all models there are certain simplifying assumptions that have been made. Each of the assumption spreadsheets has an accompanying Comments box (denoted by a cell with small red triangle in the upper right corner) that provides suggestions on how to complete the spreadsheet and the underlying assumptions to the model.

This business tool includes
1 Excel Model

Prof. Stephen Lawrence offers you this business tool for free!

Download for free

Ask a question

Further information

There are 7 principal spreadsheet outputs of this model:
INCOME: Income Statement
BALANCE: Balance Sheet
CASHFLOW: Cash Flow Statement
BREAKEVEN: Break-even analysis
SUMMARY: Analysis of key measures
INCOME-MOS: Income Statements by months for Years 1 to 5
CASHFLOW-MOS: Cash flow Statements by months for Years 1 and 2, and
by quarters for Years 3 to 5
VAL-1 & VAL-2: Venture capital method for valuing companies


Any questions on Financial Projections Model For Business Plans?

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

please wait...