Draft your Financial Plan and Financial Statements for 3 years that includes:
- Revenue forecasts
- Personnel plan
- Starting balances
- Cash flow assumptions
- Loans and investments
- Balance sheet
- Profit and loss statement
- Cash flow statement
Use the Financial Plan Template to complete the assignment.
Submit your assignment.
|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|
|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.|
|■||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.|
|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|
Apollo Group User: Revenue from products, services, or other sources
Apollo Group User: Cost of goods sold (ex: raw materials, wholesale purchases, sales commission)
Apollo Group User: Gross margin shows how much of your revenue is eaten up by the direct costs of what you sell.
|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.).
Apollo Group User: This will usually include electric, water, gas, etc.
Apollo Group User: Add additional expenses here
Apollo Group User: Revenue ($) – Direct Costs ($) – Operating Expenses ($)
|Gross profit margin|
Apollo Group User: % of profit after Direct Costs
|Net profit margin|
Apollo Group User: % of profit after Direct Costs and Operating Expenses (considered “the bottom line”)
Balance Sheet Forecast
|Balance sheet forecast|
Apollo Group User: Current assets are those that you can convert to cash within one year.
Apollo Group User: The businesses current cash on-hand
Apollo Group User: Accounts receivable is also sometimes known as incoming payments
Apollo Group User: Existing product that you can sell
Apollo Group User: Also known as Long-Term Assets
Apollo Group User: Current liabilities are items you owe that are due within one year.
Apollo Group User: Long-term liabilities are business obligations that are due outside of one year
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.
|Current year earnings||$0|
|Total equity (should equal net assets)||$0|
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|
|Collections from accounts receivable||$0.00|
|Other cash receipts||$0.00|
|Change during month|
|Closing cash position|