PART 2
1-StartingPoint
| Start-up Expenses Year 1 (Starting Balance Sheet) | |||||||||
| Prepared By: | Company Name: | ||||||||
| ERROR:#REF! | ERROR:#REF! | ||||||||
| Fixed Assets | Amount | Depreciation (years) Heather Hendy: Years of depreciation must be 3 or more for the calculations in this workbook to work correctly. | Notes | ||||||
| Real Estate-Land | Not Depreciated | ||||||||
| Real Estate-Buildings | 20 | ||||||||
| Leasehold Improvements | 7 | ||||||||
| Equipment | 7 | ||||||||
| Furniture and Fixtures | 5 | ||||||||
| Vehicles | 5 | ||||||||
| Other | 5 | ||||||||
| Total Fixed Assets | $ - | ||||||||
| Operating Capital | Amount | Notes | |||||||
| Pre-Opening Salaries and Wages | |||||||||
| Prepaid Insurance Premiums | |||||||||
| Inventory | |||||||||
| Legal and Accounting Fees | |||||||||
| Rent Deposits | |||||||||
| Utility Deposits | |||||||||
| Supplies | |||||||||
| Advertising and Promotions | |||||||||
| Licenses | |||||||||
| Other Initial Start-Up Costs | |||||||||
| Working Capital (Cash On Hand) Heather Hendy: Existing businesses should use the calculator at the bottom of this page to determine the Working Capital amount. Calculate the number, then enter it here. |
|||||||||
| Total Operating Capital | $ - | ||||||||
| Total Required Funds | $ - | ||||||||
| Sources of Funding | Percentage | Totals | Loan Rate | Term in Months | Monthly Payments | Notes | |||
| Owner's Equity | 0.00% | ||||||||
| Outside Investors | 0.00% | ||||||||
| Additional Loans or Debt | |||||||||
| Commercial Loan | 0.00% | 9.00% | 84 | - | |||||
| Commercial Mortgage | 0.00% | 9.00% | 240 | - | See Loan Amortization & Depreciation Schedule | ||||
| Credit Card Debt | 0.00% | 7.00% | 60 | - | |||||
| Vehicle Loans | 0.00% | 6.00% | 48 | - | |||||
| Other Bank Debt | 0.00% | 5.00% | 36 | - | |||||
| Total Sources of Funding | 0.00% | $ - | Cell D 42 must equal cell C31 | $ - | |||||
| Total Funding Needed | $ - | You are fully funded (Balanced) | |||||||
| Existing Businesses ONLY -- Calculating Cash on Hand | |||||||||
| Cash | - | ||||||||
| + Accounts Receivable | - | ||||||||
| + Prepaid Expenses | - | ||||||||
| - Accounts Payable | - | ||||||||
| - Accrued Expenses | - | ||||||||
| Total Cash on Hand | $ - | ||||||||
&"Gill Sans MT,Regular"&12Start-Up Expenses Year 1 (Starting Balance Sheet)
&"Gill Sans MT,Regular"&12&F &"Gill Sans MT,Regular"&12&A &"Gill Sans MT,Regular"&12&D &T
Note: For existing businesses, this should be the "bucket" of cash plus receivables that will be turned into cash, minus payables that will be paid out in cash in the near term (i.e. in the first months of the plan)
3a-SalesForecastYear1
| Sales Forecast Year 1 | ||||||||||||||||
| Prepared By: | Company Name: | |||||||||||||||
| ERROR:#REF! | ERROR:#REF! | |||||||||||||||
| Complete This Chart First: | ||||||||||||||||
| Product Lines | Units Heather Hendy: TIP: Enter these in the plural form! Ex. projects, dresses, bikes, etc. | Sales Price Per Unit | COGS Per Unit Heather Hendy: TIP: Click here to access a calculator that can help you determine your COGS per unit. | Margin Per Unit | ||||||||||||
| $ - 0 | ||||||||||||||||
| $ - 0 | ||||||||||||||||
| $ - 0 | ||||||||||||||||
| $ - 0 | ||||||||||||||||
| $ - 0 | ||||||||||||||||
| $ - 0 | ||||||||||||||||
| Product Lines | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | Annual Totals | Category Breakdown | Category / Total | |
| Product 1 | ||||||||||||||||
| Units Sold | 0 | 0.0% | ||||||||||||||
| Total Sales | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Total COGS | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Total Margin | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Product 2 | ||||||||||||||||
| Units Sold | 0 | 0.0% | ||||||||||||||
| Total Sales | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Total COGS | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Margin | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Product 3 | ||||||||||||||||
| Units Sold | 0 | 0.0% | ||||||||||||||
| Total Sales | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Total COGS | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Margin | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Product 4 | ||||||||||||||||
| Units Sold | 0 | 0.0% | ||||||||||||||
| Total Sales | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Total COGS | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Margin | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Product 5 | ||||||||||||||||
| Units Sold | 0 | 0.0% | ||||||||||||||
| Total Sales | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Total COGS | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Margin | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Product 6 | ||||||||||||||||
| Units Sold | 0 | 0.0% | ||||||||||||||
| Total Sales | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Total COGS | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Margin | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | |
| Total Units Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| Total Sales | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | |||
| Total Cost of Goods Sold | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | |||
| Total Margin | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | |||
&"Gill Sans MT,Regular"&12Sales Forecst Year 1
&"Gill Sans MT,Regular"&12&F &"Gill Sans MT,Regular"&12&A &"Gill Sans MT,Regular"&12&D &T
3b-SalesForecastYrs1-3
| Sales Forecast Year 1-3 | |||||||||||||||||||||||||||||||
| Prepared by: | Company Name: | ||||||||||||||||||||||||||||||
| ERROR:#REF! | ERROR:#REF! | ||||||||||||||||||||||||||||||
| Growth Rate Year 1 to Year 2: | 10.00% | ||||||||||||||||||||||||||||||
| Growth Rate Year 2 to Year 3: | 10.00% | ||||||||||||||||||||||||||||||
| Product Lines | Year 1 Totals | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | Year 2 Totals | Category Breakdown | Category / Total | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | Year 3 Totals | Category Breakdown | Category / Total |
| Product 1 | |||||||||||||||||||||||||||||||
| Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | ||
| Total Sales | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Total COGS | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Total Margin | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Product 2 | |||||||||||||||||||||||||||||||
| Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | ||
| Total Sales | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Total COGS | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Margin | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Product 3 | |||||||||||||||||||||||||||||||
| Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | ||
| Total Sales | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Total COGS | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Margin | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Product 4 | |||||||||||||||||||||||||||||||
| Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | ||
| Total Sales | 0 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Total COGS | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Margin | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Product 5 | |||||||||||||||||||||||||||||||
| Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | ||
| Total Sales | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Total COGS | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Margin | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Product 6 | |||||||||||||||||||||||||||||||
| Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% | ||
| Total Sales | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Total COGS | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Margin | $ - | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% | - | - | - | - | - | - | - | - | - | - | - | - | $ - | 0.0% | 0.0% |
| Total Units Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| Total Sales | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||||
| Total Cost of Goods Sold | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||||
| Total Margin | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
&"Gill Sans MT,Regular"&12Sales Forecast Years 1-3
&"Gill Sans MT,Regular"&12Sales Forecast Years 1-3
&"Gill Sans MT,Regular"&12Sales Forecast Years 1-3
&"Gill Sans MT,Regular"&12&F &"Gill Sans MT,Regular"&12&A &"Gill Sans MT,Regular"&12&D &T
&F &A &D &T
This sheet will populate based on information in the year 1 Sales Forecast. The included growth rate is just a starting point, if you can provide a more accurate prediction for each month, unlock the sheet (see Directions) and change the value for that month. Please note that you will no longer have a formula in that cell once you change the value, so you may want to save a copy of this spreadsheet under a different name before doing so.
5b-OpExYrs1-3
| Operating Expenses Years 1-3 | ||||||
| Prepared By: | Company Name: | |||||
| ERROR:#REF! | ERROR:#REF! | |||||
| Line Item | ERROR:#REF! | Growth Rate 1 to 2 | ERROR:#REF! | Growth Rate 2 to 3 | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 5.0% | ERROR:#REF! | 5.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 5.0% | ERROR:#REF! | 5.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 5.0% | ERROR:#REF! | 5.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | 3.0% | ERROR:#REF! | 3.0% | ERROR:#REF! | |
| Total Expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Other Expenses | ||||||
| Depreciation | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Interest | ||||||
| Commercial Loan | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Commercial Mortgage | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Credit Card Debt | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Vehicle Loans | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Other Bank Debt | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Line of Credit | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Bad Debt Expense | ERROR:#REF! | |||||
| Total Other Expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Total Operating Expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
&"Gill Sans MT,Regular"&12Operating Expenses Years 1-3
&"Gill Sans MT,Regular"&12&F &"Gill Sans MT,Regular"&12&A &"Gill Sans MT,Regular"&12&D &T
6a-CashFlowYear1
| Cash Flow Forecast Year 1 | ||||||||||||||
| Prepared By: | Company Name: | |||||||||||||
| ERROR:#REF! | ERROR:#REF! | |||||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | Totals | ||
| Beginning Balance | $ - | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Cash Inflows | ||||||||||||||
| Cash Sales | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Accounts Receivable | - | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Total Cash Inflows | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Cash Outflows | ||||||||||||||
| Investing Activities | ||||||||||||||
| New Fixed Asset Purchases | - | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Additional Inventory | $ - | |||||||||||||
| Cost of Goods Sold | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Operating Activities | ||||||||||||||
| Operating Expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Payroll | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Taxes Heather Hendy: This line allows you to approximate the personal income tax of the owner(s). This is the tax on the profit for the business. | - | - | ERROR:#REF! | - | - | ERROR:#REF! | - | - | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | |
| Financing Activities | ||||||||||||||
| Loan Payments | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Owners Distribution Joe Clarke: Only record owner's draws above those already listed on the payroll tabs. | $ - | |||||||||||||
| Line of Credit Interest | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Line of Credit Repayments | $ - | |||||||||||||
| Dividends Paid | $ - | |||||||||||||
| Total Cash Outflows | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Net Cash Flows | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Operating Cash Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Line of Credit Drawdown | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Ending Cash Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Line of Credit Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
&"Gill Sans MT,Regular"&12Cash Flow Forecast Year 1
&"Gill Sans MT,Regular"&12&F &"Gill Sans MT,Regular"&12&A &"Gill Sans MT,Regular"&12&D &T
6b-CashFlowYrs1-3
| Cash Flow Forecast Years 1-3 | |||||||||||||||||||||||||||
| Prepared By: | Company Name: | ||||||||||||||||||||||||||
| ERROR:#REF! | ERROR:#REF! | ||||||||||||||||||||||||||
| Year 1 Totals | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | Year 2 Totals | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | Year 3 Totals | |
| Beginning Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Cash Inflows | |||||||||||||||||||||||||||
| Cash Sales | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Accounts Receivable | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Total Cash Inflows | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Cash Outflows | |||||||||||||||||||||||||||
| Investing Activities | |||||||||||||||||||||||||||
| New Fixed Asset Purchases | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Additional Inventory | $ - | $ - | $ - | ||||||||||||||||||||||||
| Cost of Goods Sold | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Operating Activities | |||||||||||||||||||||||||||
| Operating Expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Payroll | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Taxes | ERROR:#REF! | - | - | ERROR:#REF! | - | - | ERROR:#REF! | - | - | ERROR:#REF! | - | - | ERROR:#REF! | - | - | ERROR:#REF! | - | - | ERROR:#REF! | - | - | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | |
| Financing Activities | |||||||||||||||||||||||||||
| Loan Payments | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Owners Distribution Joe Clarke: Only record owner's draws above those already listed on the payroll tabs. | $ - | $ - | $ - | ||||||||||||||||||||||||
| Line of Credit Interest | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Line of Credit Repayments | $ - | $ - | $ - | ||||||||||||||||||||||||
| Dividends Paid | $ - | $ - | $ - | ||||||||||||||||||||||||
| Total Cash Outflows | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Net Cash Flows | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Operating Cash Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Line of Credit Drawdown | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Ending Cash Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Line of Credit Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
&"Gill Sans MT,Regular"&12Cash Flow Forecast Years 1-3
&"Gill Sans MT,Regular"Cash Flow Forecast Years 1-3
&"Gill Sans MT,Regular"&12Cash Flow Forecast Years 1-3
&F &A &D &T
&F &A &D &T
NOTE: To only view the annual total side-by-side, highlight columns C through N and right-click. Then select "Hide". Use the same procedure to Hide columns P through AA. To show them again, highlight columns B, O and AB, right-click and select "Unhide".
7a-IncomeStatementYear1
| Income Statement Year 1 | ||||||||||||||
| Prepared By: | Company Name: | |||||||||||||
| ERROR:#REF! | ERROR:#REF! | |||||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Revenue | ||||||||||||||
| Product 1 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Product 2 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Product 3 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Product 4 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Product 5 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Product 6 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Total Revenue | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | |
| Cost of Goods Sold | ||||||||||||||
| Product 1 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Product 2 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Product 3 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Product 4 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Product 5 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Product 6 | - | - | - | - | - | - | - | - | - | - | - | - | $ - | |
| Total Cost of Goods Sold | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | |
| Gross Margin | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | |
| Payroll | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Operating Expenses | ||||||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Other Expense 1 | ||||||||||||||
| Other Expense 2 | ||||||||||||||
| Total Operating Expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Income (Before Other Expenses) Heather Hendy: Also known as EBITDA (Earnings Before Interest, Taxes, Depreciation and Amortization). This metric allows for a comparison across different businesses, which might have different levels of taxes, depreciation, or interest. This number should be used in conjunction with other metrics, as it does not give a full picture of the health of the business. | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Other Expenses | ||||||||||||||
| Amortized Start-up Expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Depreciation | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Interest | ||||||||||||||
| Commercial Loan | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Commercial Mortgage | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Credit Card Debt | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Vehicle Loans | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Other Bank Debt | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Line of Credit | - | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Bad Debt Expense | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Total Other Expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Net Income Before Income Tax | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Income Tax | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Net Profit/Loss | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Income Tax Calculations | ||||||||||||||
| Monthly Taxable Income | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Cumulative Taxable Income | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
&"Gill Sans MT,Regular"&12Income Statement Year 1
&F &A &D &T
7b-IncomeStatementYrs1-3
| Income Statement Years 1-3 | ||||||||||||||
| Prepared By: | Company Name: | |||||||||||||
| ERROR:#REF! | ERROR:#REF! | |||||||||||||
| Revenue | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Product 1 | - | - | - | |||||||||||
| Product 2 | - | - | - | |||||||||||
| Product 3 | - | - | - | |||||||||||
| Product 4 | - | - | - | |||||||||||
| Product 5 | - | - | - | |||||||||||
| Product 6 | - | - | - | |||||||||||
| Total Revenue | $ - | 100% | $ - | 100% | $ - | 100% | ||||||||
| Cost of Goods Sold | ||||||||||||||
| Product 1 | - | - | - | |||||||||||
| Product 2 | - | - | - | |||||||||||
| Product 3 | - | - | - | |||||||||||
| Product 4 | - | - | - | |||||||||||
| Product 5 | - | - | - | |||||||||||
| Product 6 | - | - | - | |||||||||||
| Total Cost of Goods Sold | - | 0% | - | 0% | - | 0% | ||||||||
| Gross Margin | - | 0% | - | 0% | - | 0% | ||||||||
| Payroll | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Operating Expenses | ||||||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Other Expense 1 | ||||||||||||||
| Other Expense 2 | ||||||||||||||
| Total Operating Expenses | ERROR:#REF! | 0% | ERROR:#REF! | 0% | ERROR:#REF! | 0% | ||||||||
| Income (Before Other Expenses) Heather Hendy: Also known as EBITDA (Earnings Before Interest, Taxes, Depreciation and Amortization). This metric allows for a comparison across different businesses, which might have different levels of taxes, depreciation, or interest. This number should be used in conjunction with other metrics, as it does not give a full picture of the health of the business. | ERROR:#REF! | 0% | ERROR:#REF! | 0% | ERROR:#REF! | 0% | ||||||||
| Other Expenses | ||||||||||||||
| Amortized Start-up Expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Depreciation | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Interest | ||||||||||||||
| Commercial Loan | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Commercial Mortgage | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Credit Card Debt | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Vehicle Loans | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Other Bank Debt | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Line of Credit | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Bad Debt Expense | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Total Other Expenses | ERROR:#REF! | 0% | ERROR:#REF! | 0% | ERROR:#REF! | 0% | ||||||||
| Net Income Before Income Tax | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Income Tax | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||||||||
| Net Income/Loss | ERROR:#REF! | 0% | ERROR:#REF! | 0% | ERROR:#REF! | 0% | ||||||||
| Income Tax Calculations | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Total | |
| Taxable Amount Year 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Total | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Income Taxes | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Taxable Amount Year 3 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Total | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Income Taxes | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
&"Gill Sans MT,Regular"&12Income Statement Years 1-3
&"Gill Sans MT,Regular"&12&F &"Gill Sans MT,Regular"&12&A &"Gill Sans MT,Regular"&12&D &T
8-BalanceSheet
| Balance Sheet Years 1-3 | |||||
| Prepared By: | Company Name: | ||||
| ERROR:#REF! | ERROR:#REF! | ||||
| ASSETS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Current Assets | |||||
| Cash | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Accounts Receivable | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Inventory | - | - | - | ||
| Prepaid Expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Other Initial Costs | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Total Current Assets | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Fixed Assets | |||||
| Real Estate -- Land | - | - | - | ||
| Real Estate -- Buildings | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Leasehold Improvements | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Equipment | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Furniture and Fixtures | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Vehicles | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Other | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Total Fixed Assets | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| (Less Accumulated Depreciation) | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Total Assets | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| LIABILITIES & EQUITY | |||||
| Liabilities | |||||
| Accounts Payable | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Commercial Loan Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Commercial Mortgage Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Credit Card Debt Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Vehicle Loans Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Other Bank Debt Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Line of Credit Balance | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Total Liabilities | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Equity | |||||
| Common Stock | - | - | - | ||
| Retained Earnings | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Dividends Dispersed/Owners Draw | - | - | - | ||
| Total Equity | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Total Liabilities and Equity | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Balance sheet in or out of balance? | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
&"Gill Sans MT,Regular"&12Balance Sheet Years 1-3
&"Gill Sans MT,Regular"&12&F &"Gill Sans MT,Regular"&12&A &"Gill Sans MT,Regular"&12&D &T