Five Year Projections
This template projects the key financial figures for a company over five years. The projections include abbreviated income and cash flow statements, and a balance sheet. Enter the beginning year of the analysis into the cell provided. The other year headings will be calculated automatically. Please note that the entry cells for "Cash outflow" require negative numbers. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
Copyright © KMT Software, Inc. All Rights Reserved.
Five Year Projections
2000 Income Statement Net sales Cost of goods sold Net Operating Income Operating expenses Net Income 2001 2002 2003
Enter date
2004
Cash Flow Statement Beginning balance Cash inflow Cash outflow Ending Cash Balance
Balance Sheet Cash Accounts receivable Inventory Prepaid expenses Total Current Assets Fixed assets Total Assets
Accounts payable Short-term notes Accrued & other liabilities Total Current Liabilities Long-term debt Other long-term liabilities Total Long-term Liabilities Shareholders' equity Total Liabilities and Equity