| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Laser Car Wash Sales | 0% | £11,596 | £11,596 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 |
| Self-Serve Revenue | 0% | £3,000 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Vacuum / Vending Sales | 0% | £730 | £730 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 |
| ATM Revenue | 0% | £50 | £50 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £96 | £100 |
| RO Water Sales | 0% | £500 | £500 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Total Sales | £15,876 | £15,876 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,105 | £28,109 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Laser Car Wash Sales | £2,609 | £2,609 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | |
| Self-Serve Revenue | £333 | £333 | £667 | £667 | £667 | £667 | £667 | £667 | £667 | £667 | £667 | £667 | |
| Vacuum / Vending Sales | £146 | £146 | £260 | £260 | £260 | £206 | £260 | £260 | £260 | £260 | £260 | £260 | |
| ATM Revenue | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| RO Water Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £3,088 | £3,088 | £5,417 | £5,417 | £5,417 | £5,364 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 2 Attendants, 1st site | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Manager, 1st site (Owner) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| 2 Attentants, 2nd site | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Manager, 2nd site (Owner) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 30.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £15,876 | £15,876 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,105 | £28,109 | |
| Direct Cost of Sales | £3,088 | £3,088 | £5,417 | £5,417 | £5,417 | £5,364 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,088 | £3,088 | £5,417 | £5,417 | £5,417 | £5,364 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | |
| Gross Margin | £12,787 | £12,787 | £22,692 | £22,692 | £22,692 | £22,745 | £22,692 | £22,692 | £22,692 | £22,692 | £22,688 | £22,692 | |
| Gross Margin % | 80.55% | 80.55% | 80.73% | 80.73% | 80.73% | 80.92% | 80.73% | 80.73% | 80.73% | 80.73% | 80.72% | 80.73% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Sales and Marketing and Other Expenses | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | |
| Depreciation | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | |
| Accounting / Legal | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Dumpster / Telephone / Pager | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Repairs / Maintenance | £850 | £850 | £850 | £850 | £850 | £850 | £850 | £850 | £850 | £850 | £850 | £850 | |
| Payroll Taxes | 15% | £300 | £300 | £300 | £300 | £300 | £300 | £750 | £750 | £750 | £750 | £750 | £750 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £11,239 | £11,239 | £11,239 | £11,239 | £11,239 | £11,239 | £14,689 | £14,689 | £14,689 | £14,689 | £14,689 | £14,689 | |
| Profit Before Interest and Taxes | £1,548 | £1,548 | £11,453 | £11,453 | £11,453 | £11,506 | £8,003 | £8,003 | £8,003 | £8,003 | £7,999 | £8,003 | |
| EBITDA | £7,812 | £7,812 | £17,717 | £17,717 | £17,717 | £17,770 | £14,267 | £14,267 | £14,267 | £14,267 | £14,263 | £14,267 | |
| Interest Expense | £4,662 | £4,656 | £4,651 | £4,646 | £4,641 | £4,636 | £4,631 | £4,626 | £4,621 | £4,616 | £4,611 | £4,606 | |
| Taxes Incurred | (£934) | (£622) | £1,360 | £1,361 | £1,362 | £1,374 | £674 | £675 | £676 | £677 | £678 | £679 | |
| Net Profit | (£2,179) | (£2,486) | £5,441 | £5,445 | £5,449 | £5,496 | £2,697 | £2,701 | £2,705 | £2,710 | £2,710 | £2,718 | |
| Net Profit/Sales | -13.73% | -15.66% | 19.36% | 19.37% | 19.39% | 19.55% | 9.60% | 9.61% | 9.62% | 9.64% | 9.64% | 9.67% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £15,876 | £15,876 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,105 | £28,109 | |
| Subtotal Cash from Operations | £15,876 | £15,876 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,105 | £28,109 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £15,876 | £15,876 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,105 | £28,109 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Bill Payments | £326 | £9,801 | £10,242 | £14,404 | £14,400 | £14,394 | £14,342 | £14,148 | £14,144 | £14,139 | £14,135 | £14,131 | |
| Subtotal Spent on Operations | £2,326 | £11,801 | £12,242 | £16,404 | £16,400 | £16,394 | £19,342 | £19,148 | £19,144 | £19,139 | £19,135 | £19,131 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £764 | £764 | £764 | £764 | £764 | £764 | £764 | £764 | £764 | £764 | £764 | £764 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £65,000 | |
| Subtotal Cash Spent | £3,090 | £12,565 | £13,006 | £17,168 | £17,164 | £17,158 | £20,106 | £19,912 | £19,908 | £19,903 | £19,899 | £84,895 | |
| Net Cash Flow | £12,785 | £3,311 | £15,103 | £10,941 | £10,945 | £10,951 | £8,003 | £8,197 | £8,201 | £8,206 | £8,206 | (£56,786) | |
| Cash Balance | £107,285 | £110,596 | £125,699 | £136,640 | £147,586 | £158,536 | £166,539 | £174,737 | £182,938 | £191,144 | £199,349 | £142,564 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £94,500 | £107,285 | £110,596 | £125,699 | £136,640 | £147,586 | £158,536 | £166,539 | £174,737 | £182,938 | £191,144 | £199,349 | £142,564 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £94,500 | £107,285 | £110,596 | £125,699 | £136,640 | £147,586 | £158,536 | £166,539 | £174,737 | £182,938 | £191,144 | £199,349 | £142,564 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 |
| Accumulated Depreciation | £0 | £6,264 | £12,528 | £18,792 | £25,056 | £31,320 | £37,584 | £43,848 | £50,112 | £56,376 | £62,640 | £68,904 | £75,168 |
| Total Long-term Assets | £799,000 | £792,736 | £786,472 | £780,208 | £773,944 | £767,680 | £761,416 | £755,152 | £748,888 | £742,624 | £736,360 | £730,096 | £723,832 |
| Total Assets | £893,500 | £900,021 | £897,068 | £905,907 | £910,584 | £915,266 | £919,952 | £921,691 | £923,625 | £925,562 | £927,504 | £929,445 | £866,396 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £9,465 | £9,762 | £13,924 | £13,920 | £13,916 | £13,871 | £13,676 | £13,672 | £13,668 | £13,664 | £13,660 | £13,656 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £9,465 | £9,762 | £13,924 | £13,920 | £13,916 | £13,871 | £13,676 | £13,672 | £13,668 | £13,664 | £13,660 | £13,656 |
| Long-term Liabilities | £700,000 | £699,236 | £698,472 | £697,708 | £696,944 | £696,180 | £695,416 | £694,652 | £693,888 | £693,124 | £692,360 | £691,596 | £690,832 |
| Total Liabilities | £700,000 | £708,701 | £708,234 | £711,632 | £710,864 | £710,096 | £709,287 | £708,328 | £707,560 | £706,792 | £706,024 | £705,256 | £704,488 |
| Paid-in Capital | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 |
| Retained Earnings | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£105,500) |
| Earnings | £0 | (£2,179) | (£4,666) | £775 | £6,220 | £11,670 | £17,166 | £19,863 | £22,564 | £25,270 | £27,979 | £30,690 | £33,407 |
| Total Capital | £193,500 | £191,321 | £188,834 | £194,275 | £199,720 | £205,170 | £210,666 | £213,363 | £216,064 | £218,770 | £221,479 | £224,190 | £161,907 |
| Total Liabilities and Capital | £893,500 | £900,021 | £897,068 | £905,907 | £910,584 | £915,266 | £919,952 | £921,691 | £923,625 | £925,562 | £927,504 | £929,445 | £866,396 |
| Net Worth | £193,500 | £191,321 | £188,834 | £194,275 | £199,720 | £205,170 | £210,666 | £213,363 | £216,064 | £218,770 | £221,479 | £224,190 | £161,907 |
| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Laser Car Wash Sales | 0% | £11,596 | £11,596 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 | £19,961 |
| Self-Serve Revenue | 0% | £3,000 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Vacuum / Vending Sales | 0% | £730 | £730 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 | £1,298 |
| ATM Revenue | 0% | £50 | £50 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £96 | £100 |
| RO Water Sales | 0% | £500 | £500 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Total Sales | £15,876 | £15,876 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,105 | £28,109 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Laser Car Wash Sales | £2,609 | £2,609 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | £4,491 | |
| Self-Serve Revenue | £333 | £333 | £667 | £667 | £667 | £667 | £667 | £667 | £667 | £667 | £667 | £667 | |
| Vacuum / Vending Sales | £146 | £146 | £260 | £260 | £260 | £206 | £260 | £260 | £260 | £260 | £260 | £260 | |
| ATM Revenue | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| RO Water Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £3,088 | £3,088 | £5,417 | £5,417 | £5,417 | £5,364 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 2 Attendants, 1st site | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Manager, 1st site (Owner) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| 2 Attentants, 2nd site | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Manager, 2nd site (Owner) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 30.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £15,876 | £15,876 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,105 | £28,109 | |
| Direct Cost of Sales | £3,088 | £3,088 | £5,417 | £5,417 | £5,417 | £5,364 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,088 | £3,088 | £5,417 | £5,417 | £5,417 | £5,364 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | |
| Gross Margin | £12,787 | £12,787 | £22,692 | £22,692 | £22,692 | £22,745 | £22,692 | £22,692 | £22,692 | £22,692 | £22,688 | £22,692 | |
| Gross Margin % | 80.55% | 80.55% | 80.73% | 80.73% | 80.73% | 80.92% | 80.73% | 80.73% | 80.73% | 80.73% | 80.72% | 80.73% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Sales and Marketing and Other Expenses | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | |
| Depreciation | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | £6,264 | |
| Accounting / Legal | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Dumpster / Telephone / Pager | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Repairs / Maintenance | £850 | £850 | £850 | £850 | £850 | £850 | £850 | £850 | £850 | £850 | £850 | £850 | |
| Payroll Taxes | 15% | £300 | £300 | £300 | £300 | £300 | £300 | £750 | £750 | £750 | £750 | £750 | £750 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £11,239 | £11,239 | £11,239 | £11,239 | £11,239 | £11,239 | £14,689 | £14,689 | £14,689 | £14,689 | £14,689 | £14,689 | |
| Profit Before Interest and Taxes | £1,548 | £1,548 | £11,453 | £11,453 | £11,453 | £11,506 | £8,003 | £8,003 | £8,003 | £8,003 | £7,999 | £8,003 | |
| EBITDA | £7,812 | £7,812 | £17,717 | £17,717 | £17,717 | £17,770 | £14,267 | £14,267 | £14,267 | £14,267 | £14,263 | £14,267 | |
| Interest Expense | £4,662 | £4,656 | £4,651 | £4,646 | £4,641 | £4,636 | £4,631 | £4,626 | £4,621 | £4,616 | £4,611 | £4,606 | |
| Taxes Incurred | (£934) | (£622) | £1,360 | £1,361 | £1,362 | £1,374 | £674 | £675 | £676 | £677 | £678 | £679 | |
| Net Profit | (£2,179) | (£2,486) | £5,441 | £5,445 | £5,449 | £5,496 | £2,697 | £2,701 | £2,705 | £2,710 | £2,710 | £2,718 | |
| Net Profit/Sales | -13.73% | -15.66% | 19.36% | 19.37% | 19.39% | 19.55% | 9.60% | 9.61% | 9.62% | 9.64% | 9.64% | 9.67% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £15,876 | £15,876 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,105 | £28,109 | |
| Subtotal Cash from Operations | £15,876 | £15,876 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,105 | £28,109 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £15,876 | £15,876 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,109 | £28,105 | £28,109 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Bill Payments | £326 | £9,801 | £10,242 | £14,404 | £14,400 | £14,394 | £14,342 | £14,148 | £14,144 | £14,139 | £14,135 | £14,131 | |
| Subtotal Spent on Operations | £2,326 | £11,801 | £12,242 | £16,404 | £16,400 | £16,394 | £19,342 | £19,148 | £19,144 | £19,139 | £19,135 | £19,131 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £764 | £764 | £764 | £764 | £764 | £764 | £764 | £764 | £764 | £764 | £764 | £764 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £65,000 | |
| Subtotal Cash Spent | £3,090 | £12,565 | £13,006 | £17,168 | £17,164 | £17,158 | £20,106 | £19,912 | £19,908 | £19,903 | £19,899 | £84,895 | |
| Net Cash Flow | £12,785 | £3,311 | £15,103 | £10,941 | £10,945 | £10,951 | £8,003 | £8,197 | £8,201 | £8,206 | £8,206 | (£56,786) | |
| Cash Balance | £107,285 | £110,596 | £125,699 | £136,640 | £147,586 | £158,536 | £166,539 | £174,737 | £182,938 | £191,144 | £199,349 | £142,564 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £94,500 | £107,285 | £110,596 | £125,699 | £136,640 | £147,586 | £158,536 | £166,539 | £174,737 | £182,938 | £191,144 | £199,349 | £142,564 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £94,500 | £107,285 | £110,596 | £125,699 | £136,640 | £147,586 | £158,536 | £166,539 | £174,737 | £182,938 | £191,144 | £199,349 | £142,564 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 | £799,000 |
| Accumulated Depreciation | £0 | £6,264 | £12,528 | £18,792 | £25,056 | £31,320 | £37,584 | £43,848 | £50,112 | £56,376 | £62,640 | £68,904 | £75,168 |
| Total Long-term Assets | £799,000 | £792,736 | £786,472 | £780,208 | £773,944 | £767,680 | £761,416 | £755,152 | £748,888 | £742,624 | £736,360 | £730,096 | £723,832 |
| Total Assets | £893,500 | £900,021 | £897,068 | £905,907 | £910,584 | £915,266 | £919,952 | £921,691 | £923,625 | £925,562 | £927,504 | £929,445 | £866,396 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £9,465 | £9,762 | £13,924 | £13,920 | £13,916 | £13,871 | £13,676 | £13,672 | £13,668 | £13,664 | £13,660 | £13,656 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £9,465 | £9,762 | £13,924 | £13,920 | £13,916 | £13,871 | £13,676 | £13,672 | £13,668 | £13,664 | £13,660 | £13,656 |
| Long-term Liabilities | £700,000 | £699,236 | £698,472 | £697,708 | £696,944 | £696,180 | £695,416 | £694,652 | £693,888 | £693,124 | £692,360 | £691,596 | £690,832 |
| Total Liabilities | £700,000 | £708,701 | £708,234 | £711,632 | £710,864 | £710,096 | £709,287 | £708,328 | £707,560 | £706,792 | £706,024 | £705,256 | £704,488 |
| Paid-in Capital | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 | £234,000 |
| Retained Earnings | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£40,500) | (£105,500) |
| Earnings | £0 | (£2,179) | (£4,666) | £775 | £6,220 | £11,670 | £17,166 | £19,863 | £22,564 | £25,270 | £27,979 | £30,690 | £33,407 |
| Total Capital | £193,500 | £191,321 | £188,834 | £194,275 | £199,720 | £205,170 | £210,666 | £213,363 | £216,064 | £218,770 | £221,479 | £224,190 | £161,907 |
| Total Liabilities and Capital | £893,500 | £900,021 | £897,068 | £905,907 | £910,584 | £915,266 | £919,952 | £921,691 | £923,625 | £925,562 | £927,504 | £929,445 | £866,396 |
| Net Worth | £193,500 | £191,321 | £188,834 | £194,275 | £199,720 | £205,170 | £210,666 | £213,363 | £216,064 | £218,770 | £221,479 | £224,190 | £161,907 |