industry overview
re.bertyh.elpsfuben.t
ENT588CashFlowAssumption.xlsxSTART HERE
| How to use this template | |
| Save the template (XLT file) to your computer. Double-click on it to create a new plan, then follow these steps: | |
| Step 1 | Set a starting point for your projections |
| Start date | |
| Step 2 | Profit and loss forecast |
| Forecast your month-by-month profit and loss for the first 12 months of operations. Enter sales in the month when they're invoiced, rather than the month when they're paid. | |
| Step 3 | Cash flow forecast |
| Forecast your month-by-month cash flow for the first 12 months of operations. Enter sales revenue in the month when it's received, rather than the month when it's invoiced. | |
| Step 4 | Balance sheet forecast |
| Forecast your balance sheet position at the end of the first 12 months of operation. The balance sheet draws on the figures you've entered in your profit and loss forecast. | |
| Tips | |
| ■ | Enter figures in any white field. The blue fields are locked & calculated for you. |
| ■ | By default, the sheets in this template are locked, so that the formulas cannot be changed. |
| Important information | |
| The figures shown in this Financial Forecast spreadsheet are intended as a guide only. It has been prepared without considering your objectives, financial situation or needs. Before acting on the calculations in this spreadsheet, you should consider its appropriateness to your circumstances. |
Profit and Loss Forecast
| Profit and loss forecast | |||||
| Year 1 | Year 2 | Year 3 | Totals | ||
| Sales | |||||
| Revenue Apollo Group User: Revenue from products, services, or other sources | $475,000.00 | $525,000.00 | $625,000.00 | $1,625,000.00 | |
| Direct Costs Apollo Group User: Cost of goods sold (ex: raw materials, wholesale purchases, sales commission) | $75,000.00 | $82,000.00 | $102,000.00 | $259,000.00 | |
| Gross Margin Apollo Group User: Gross margin shows how much of your revenue is eaten up by the direct costs of what you sell. | $400,000.00 | $443,000.00 | $523,000.00 | $1,366,000.00 | |
| Operating Expenses | |||||
| Payroll (Salary, Benefits, Taxes) Apollo Group User: Payroll includes salaries and wages for on-staff and contract employees plus employee-related expenses (benefits, taxes, etc.). | $65,000.00 | $149,000.00 | $175,000.00 | $389,000.00 | |
| Utilities Apollo Group User: This will usually include electric, water, gas, etc. | $4,800.00 | $4,917.00 | $5,103.00 | $14,820.00 | |
| Office Supplies | $12,500.00 | $16,400.00 | $18,700.00 | $47,600.00 | |
| Insurance | $1,500.00 | $1,500.00 | $1,500.00 | $4,500.00 | |
| Equipment (buy/lease) | $96,500.00 | $0.00 | $0.00 | $96,500.00 | |
| Rent | $10,200.00 | $10,200.00 | $10,200.00 | $30,600.00 | |
| Marketing/Advertising | $5,400.00 | $5,400.00 | $5,400.00 | $16,200.00 | |
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| Total | $195,900.00 | $187,417.00 | $215,903.00 | $599,220.00 | |
| Result | |||||
| Net profit Apollo Group User: Revenue ($) - Direct Costs ($) - Operating Expenses ($) | $204,100.00 | $255,583.00 | $307,097.00 | $766,780.00 | |
| Gross profit margin Apollo Group User: % of profit after Direct Costs | 84% | 84% | 84% | 84% | |
| Net profit margin Apollo Group User: % of profit after Direct Costs and Operating Expenses (considered "the bottom line") |
Apollo Group User: Add additional expenses here | 43% | 49% | 49% | 47% |
Balance Sheet Forecast
| Balance sheet forecast | |||||
| Assets | |||||
| Current assets Apollo Group User: Current assets are those that you can convert to cash within one year. | $689,500 | ||||
| Cash Apollo Group User: The businesses current cash on-hand | $330,000 | ||||
| Accounts receivable Apollo Group User: Accounts receivable is also sometimes known as incoming payments | $167,000 | ||||
| Inventory Apollo Group User: Existing product that you can sell | $192,500 | ||||
| Fixed assets Apollo Group User: Also known as Long-Term Assets | $208,000 | ||||
| Land | $0 | ||||
| Buildings | $0 | ||||
| Improvements | $0 | ||||
| Equipment | $89,000 | ||||
| Furniture | $50,000 | ||||
| Motor vehicles | $69,000 | ||||
| Total assets | $897,500 | ||||
| Liabilities | |||||
| Current liabilities Apollo Group User: Current liabilities are items you owe that are due within one year. | $130,720 | ||||
| Accounts payable | $50,000 | ||||
| Interest payable | $12,000 | ||||
| Taxes payable | $20,000 | ||||
| Income tax | $27,000 | ||||
| Sales tax | $21,720 | ||||
| Payroll accrual | |||||
| Long-term liabilities Apollo Group User: Long-term liabilities are business obligations that are due outside of one year |
Apollo Group User: Current liabilities are items you owe that are due within one year. |
Apollo Group User: Also known as Long-Term Assets | $0 | ||
| Loans | $0 | ||||
| Total liabilities | $130,720 | ||||
| Net assets | $766,780 | ||||
| Owner's equity Apollo Group User: Equity is a measure of your company's net worth. It's the result you get when you subtract your liabilities from your assets. | |||||
| Retained earnings | |||||
| Current year earnings | $766,780 | ||||
| Total equity (should equal net assets) | $766,780 |
Cash Flow Forecast
| Cash flow forecast | |||||||||||||
| Year 1 | Year 2 | Year 3 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | Totals | |
| Starting cash position | $475,000.00 | $555,800.00 | $716,566.00 | $935,360.00 | |||||||||
| Incoming | |||||||||||||
| Net Profit | $204,100.00 | $255,583.00 | $307,097.00 | $766,780.00 | |||||||||
| Collections from accounts receivable | $40,000.00 | $47,000.00 | $80,000.00 | $167,000.00 | |||||||||
| Other cash receipts | $52,000.00 | $75,000.00 | $85,000.00 | $212,000.00 | |||||||||
| Total | $296,100.00 | $377,583.00 | $472,097.00 | $1,145,780.00 | |||||||||
| Outgoing | |||||||||||||
| Fixed costs | $201,300.00 | $192,817.00 | $221,303.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $615,420.00 |
| Administration | |||||||||||||
| Marketing | $5,400.00 | $5,400.00 | $5,400.00 | ||||||||||
| Operations | $195,900.00 | $187,417.00 | $215,903.00 | ||||||||||
| Variable costs | $14,000.00 | $24,000.00 | $32,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $70,000.00 |
| Administration | $12,000.00 | $20,000.00 | $24,000.00 | ||||||||||
| Marketing | $2,000.00 | $4,000.00 | $8,000.00 | ||||||||||
| Operations | $0.00 | $0.00 | $0.00 | ||||||||||
| Total | $215,300.00 | $216,817.00 | $253,303.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $685,420.00 |
| Result | |||||||||||||
| Change during month | $80,800.00 | $160,766.00 | $218,794.00 | ||||||||||
| Closing cash position | $555,800.00 | $716,566.00 | $935,360.00 | ||||||||||
