Business Plan Template 3.0 - 5 Year Financial Model
General Instructions:
1) When using this file with the Business Plan Template 3.0 Word file, be sure to have both it and this file open
when you save the files with new names. That way, the Financial Statements in the Word document, which are directly
linked to this file, will follow the link to the new file that you create by saving it with a new name.
2) The worksheets can each be accessed by clicking on the tabs at the bottom of the screen; each tab has the worksheet's name on it. You can also move among the sheets by holding down the "Ctrl" key and pressing "Page Up" or "Page Down."
3) Except as noted in the worksheet instructions, entries should only be made in the yellow boxes; all other numbers
calculates automatically.Input box
Worksheet Instructions:
The file includes 6 different worksheets - not counting this one - with the following titles:
IncomeStmt This is the Income Statement (P & L) that you will print out and/or copy and paste into your business plan. All amounts are linked to the Monthly Income Statement (MIncStmt); the only input required is
the Company name; all other sheets are linked to the Company name cell of the Income Statement.
To print, simply click the Printer icon.
MIncStmt Five years of Income Statements by month. Linked to the Income Statement, Sales Worksheet, Cost of Goods Sold, Staffing, Depreciation, and LoanPay sections of the "Input" worksheet. Input
will update automatically. Input numbers in the yellow cells.
BalSheet Five years of monthly Balance Sheets. Linked to the Balance Sheet section of the Input sheet.
Printing macro buttons are available to simplify printing.
CashFlow Five years of monthly cash flow statements with quarterly and annual summaries. All cells are linked and/or calculated. Print buttons for automatic printing are located at the top of column AW.
Linked Sheets This spreadsheet contains the Five Year Projected Income Statement, Balance Sheet, and Statement of Cash Flows. It is linked to the respective worksheets within the file. Its sole purpose is to provide
a preformatted link to the Business Plan Template 3.0 Word document. When updating the Word
document, make sure that the Business Plan Template 3.0 Excel file is open as well. That way the
numbers in the Word document will be updated automatically.
? 2000 - 2002 Business Plan Success, All Rights reserved
Page 1 of 1