Originally published: 27/07/2016 12:43
Publication number: ELQ-24061-1

Financial Projections Model for Business Plans

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

by Prof. Stephen Lawrence
Professor & Director at University of Colorado

by Frank Moyes

by Leeds School of Business - CU Boulder
The World at Your Doorstep

60 reviews2,151 views|Start the discussion!|download for free

business plan finance forecasting prediction

Description
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 Best Practice includes
1 Excel Model

Prof. Stephen Lawrence offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Objectives

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

Financial Projections Model for Business Plans

Further information

Objectives

%product_add_cart_title%

Login

Create an account

Are you using this Best Practice for...

Message

Certificate of publication date

Add to your library to review

Add to cart to continue reading

Add to cart to view the video

Please sign-up to download this free Best Practice