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. Five Year Projections Enter date 2000 2001 2002 2003 2004 Income Statement Net sales Cost of goods sold Net Operating Income Operating expenses Net Income 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