| 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 | ||
| Unit Sales | |||||||||||||
| Full Wash | 0% | 90 | 130 | 170 | 190 | 190 | 185 | 135 | 135 | 120 | 120 | 140 | 155 |
| Exterior Wash | 0% | 90 | 130 | 185 | 220 | 230 | 220 | 180 | 170 | 150 | 150 | 160 | 165 |
| Interior Clean | 0% | 40 | 50 | 50 | 55 | 60 | 65 | 70 | 80 | 80 | 85 | 75 | 60 |
| End User Detail | 0% | 3 | 5 | 7 | 10 | 12 | 12 | 14 | 9 | 11 | 14 | 15 | 17 |
| Business Fleet Washes | 0% | 25 | 40 | 55 | 60 | 60 | 55 | 55 | 55 | 55 | 50 | 50 | 55 |
| Car Dealership Details | 0% | 15 | 17 | 20 | 26 | 32 | 40 | 56 | 45 | 56 | 60 | 60 | 67 |
| Total Unit Sales | 263 | 372 | 487 | 561 | 584 | 577 | 510 | 494 | 472 | 479 | 500 | 519 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Full Wash | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | |
| Exterior Wash | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | |
| Interior Clean | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | |
| End User Detail | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | |
| Business Fleet Washes | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | |
| Car Dealership Details | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | |
| Sales | |||||||||||||
| Full Wash | £1,350 | £1,950 | £2,550 | £2,850 | £2,850 | £2,775 | £2,025 | £2,025 | £1,800 | £1,800 | £2,100 | £2,325 | |
| Exterior Wash | £810 | £1,170 | £1,665 | £1,980 | £2,070 | £1,980 | £1,620 | £1,530 | £1,350 | £1,350 | £1,440 | £1,485 | |
| Interior Clean | £320 | £400 | £400 | £440 | £480 | £520 | £560 | £640 | £640 | £680 | £600 | £480 | |
| End User Detail | £420 | £700 | £980 | £1,400 | £1,680 | £1,680 | £1,960 | £1,260 | £1,540 | £1,960 | £2,100 | £2,380 | |
| Business Fleet Washes | £250 | £400 | £550 | £600 | £600 | £550 | £550 | £550 | £550 | £500 | £500 | £550 | |
| Car Dealership Details | £1,050 | £1,190 | £1,400 | £1,820 | £2,240 | £2,800 | £3,920 | £3,150 | £3,920 | £4,200 | £4,200 | £4,690 | |
| Total Sales | £4,200 | £5,810 | £7,545 | £9,090 | £9,920 | £10,305 | £10,635 | £9,155 | £9,800 | £10,490 | £10,940 | £11,910 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Full Wash | 0.00% | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 |
| Exterior Wash | 0.00% | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 |
| Interior Clean | 0.00% | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 |
| End User Detail | 0.00% | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| Business Fleet Washes | 0.00% | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 |
| Car Dealership Details | 0.00% | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| Direct Cost of Sales | |||||||||||||
| Full Wash | £63 | £91 | £119 | £133 | £133 | £130 | £95 | £95 | £84 | £84 | £98 | £109 | |
| Exterior Wash | £36 | £52 | £74 | £88 | £92 | £88 | £72 | £68 | £60 | £60 | £64 | £66 | |
| Interior Clean | £12 | £15 | £15 | £17 | £18 | £20 | £21 | £24 | £24 | £26 | £23 | £18 | |
| End User Detail | £9 | £15 | £21 | £30 | £36 | £36 | £42 | £27 | £33 | £42 | £45 | £51 | |
| Business Fleet Washes | £18 | £28 | £39 | £42 | £42 | £39 | £39 | £39 | £39 | £35 | £35 | £39 | |
| Car Dealership Details | £45 | £51 | £60 | £78 | £96 | £120 | £168 | £135 | £168 | £180 | £180 | £201 | |
| Subtotal Direct Cost of Sales | £183 | £252 | £328 | £388 | £417 | £432 | £436 | £387 | £408 | £427 | £445 | £483 | |
| 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 | ||
| Owner | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Car Washers | 0% | £2,240 | £2,240 | £3,360 | £3,360 | £3,360 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Admin/Sales | 0% | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £4,860 | £4,860 | £5,980 | £5,980 | £5,980 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | |
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £4,200 | £5,810 | £7,545 | £9,090 | £9,920 | £10,305 | £10,635 | £9,155 | £9,800 | £10,490 | £10,940 | £11,910 | |
| Direct Cost of Sales | £183 | £252 | £328 | £388 | £417 | £432 | £436 | £387 | £408 | £427 | £445 | £483 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £183 | £252 | £328 | £388 | £417 | £432 | £436 | £387 | £408 | £427 | £445 | £483 | |
| Gross Margin | £4,018 | £5,558 | £7,218 | £8,703 | £9,503 | £9,874 | £10,199 | £8,768 | £9,393 | £10,064 | £10,496 | £11,427 | |
| Gross Margin % | 95.65% | 95.66% | 95.66% | 95.74% | 95.80% | 95.81% | 95.90% | 95.77% | 95.84% | 95.93% | 95.94% | 95.94% | |
| Expenses | |||||||||||||
| Payroll | £4,860 | £4,860 | £5,980 | £5,980 | £5,980 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | |
| Sales and Marketing and Other Expenses | £500 | £300 | £300 | £300 | £300 | £100 | £100 | £100 | £300 | £100 | £100 | £100 | |
| Depreciation | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £250 | £275 | £300 | £300 | £300 | £275 | £275 | £275 | £275 | £275 | £250 | £275 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Payroll Taxes | 25% | £1,215 | £1,215 | £1,495 | £1,495 | £1,495 | £1,215 | £1,215 | £1,215 | £1,215 | £1,215 | £1,215 | £1,215 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £7,547 | £7,372 | £8,797 | £8,797 | £8,797 | £7,172 | £7,172 | £7,172 | £7,372 | £7,172 | £7,147 | £7,172 | |
| Profit Before Interest and Taxes | (£3,530) | (£1,814) | (£1,580) | (£95) | £706 | £2,701 | £3,027 | £1,596 | £2,020 | £2,891 | £3,348 | £4,255 | |
| EBITDA | (£3,358) | (£1,642) | (£1,407) | £78 | £878 | £2,874 | £3,199 | £1,768 | £2,193 | £3,064 | £3,521 | £4,427 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,059) | (£454) | (£395) | (£24) | £176 | £675 | £757 | £399 | £505 | £723 | £837 | £1,064 | |
| Net Profit | (£2,471) | (£1,361) | (£1,185) | (£71) | £529 | £2,026 | £2,270 | £1,197 | £1,515 | £2,168 | £2,511 | £3,191 | |
| Net Profit/Sales | -58.83% | -23.42% | -15.71% | -0.78% | 5.33% | 19.66% | 21.34% | 13.07% | 15.46% | 20.67% | 22.95% | 26.79% | |
| 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 | £3,570 | £4,939 | £6,413 | £7,727 | £8,432 | £8,759 | £9,040 | £7,782 | £8,330 | £8,917 | £9,299 | £10,124 | |
| Cash from Receivables | £0 | £21 | £638 | £880 | £1,139 | £1,368 | £1,490 | £1,547 | £1,588 | £1,376 | £1,473 | £1,576 | |
| Subtotal Cash from Operations | £3,570 | £4,960 | £7,051 | £8,607 | £9,571 | £10,127 | £10,530 | £9,329 | £9,918 | £10,293 | £10,772 | £11,699 | |
| 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 | £3,570 | £4,960 | £7,051 | £8,607 | £9,571 | £10,127 | £10,530 | £9,329 | £9,918 | £10,293 | £10,772 | £11,699 | |
| 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 | £4,860 | £4,860 | £5,980 | £5,980 | £5,980 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | |
| Bill Payments | £82 | £2,437 | £1,898 | £2,296 | £3,595 | £2,855 | £3,785 | £2,885 | £2,582 | £3,812 | £2,899 | £3,927 | |
| Subtotal Spent on Operations | £4,942 | £7,297 | £7,878 | £8,276 | £9,575 | £7,715 | £8,645 | £7,745 | £7,442 | £8,672 | £7,759 | £8,787 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £0 | |
| Subtotal Cash Spent | £4,942 | £7,297 | £7,878 | £8,276 | £9,575 | £7,715 | £8,645 | £7,745 | £7,442 | £8,672 | £7,759 | £8,787 | |
| Net Cash Flow | (£1,372) | (£2,338) | (£827) | £331 | (£3) | £2,412 | £1,885 | £1,584 | £2,475 | £1,621 | £3,013 | £2,912 | |
| Cash Balance | £7,328 | £4,991 | £4,163 | £4,494 | £4,491 | £6,904 | £8,789 | £10,373 | £12,849 | £14,469 | £17,483 | £20,395 | |
| 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 | £8,700 | £7,328 | £4,991 | £4,163 | £4,494 | £4,491 | £6,904 | £8,789 | £10,373 | £12,849 | £14,469 | £17,483 | £20,395 |
| Accounts Receivable | £0 | £630 | £1,481 | £1,974 | £2,458 | £2,806 | £2,984 | £3,089 | £2,915 | £2,797 | £2,994 | £3,162 | £3,373 |
| Inventory | £250 | £1,068 | £816 | £488 | £1,101 | £684 | £1,252 | £816 | £429 | £1,022 | £595 | £1,151 | £668 |
| Other Current Assets | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total Current Assets | £9,950 | £10,026 | £8,287 | £7,626 | £9,052 | £8,981 | £12,140 | £13,694 | £14,717 | £17,668 | £19,059 | £22,795 | £25,435 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Accumulated Depreciation | £0 | £172 | £345 | £517 | £690 | £862 | £1,035 | £1,207 | £1,380 | £1,552 | £1,725 | £1,897 | £2,070 |
| Total Long-term Assets | £10,000 | £9,828 | £9,655 | £9,483 | £9,310 | £9,138 | £8,965 | £8,793 | £8,620 | £8,448 | £8,275 | £8,103 | £7,930 |
| Total Assets | £19,950 | £19,853 | £17,942 | £17,108 | £18,362 | £18,118 | £21,105 | £22,487 | £23,338 | £26,115 | £27,334 | £30,898 | £33,365 |
| 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 | £2,374 | £1,823 | £2,175 | £3,501 | £2,727 | £3,688 | £2,800 | £2,454 | £3,717 | £2,767 | £3,820 | £3,097 |
| 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 | £2,374 | £1,823 | £2,175 | £3,501 | £2,727 | £3,688 | £2,800 | £2,454 | £3,717 | £2,767 | £3,820 | £3,097 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £2,374 | £1,823 | £2,175 | £3,501 | £2,727 | £3,688 | £2,800 | £2,454 | £3,717 | £2,767 | £3,820 | £3,097 |
| Paid-in Capital | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Retained Earnings | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) |
| Earnings | £0 | (£2,471) | (£3,832) | (£5,017) | (£5,088) | (£4,559) | (£2,533) | (£263) | £933 | £2,448 | £4,617 | £7,128 | £10,318 |
| Total Capital | £19,950 | £17,479 | £16,118 | £14,933 | £14,862 | £15,391 | £17,417 | £19,687 | £20,883 | £22,398 | £24,567 | £27,078 | £30,268 |
| Total Liabilities and Capital | £19,950 | £19,853 | £17,942 | £17,108 | £18,362 | £18,118 | £21,105 | £22,487 | £23,338 | £26,115 | £27,334 | £30,898 | £33,365 |
| Net Worth | £19,950 | £17,479 | £16,118 | £14,933 | £14,862 | £15,391 | £17,417 | £19,687 | £20,883 | £22,398 | £24,567 | £27,078 | £30,268 |
| 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 | ||
| Unit Sales | |||||||||||||
| Full Wash | 0% | 90 | 130 | 170 | 190 | 190 | 185 | 135 | 135 | 120 | 120 | 140 | 155 |
| Exterior Wash | 0% | 90 | 130 | 185 | 220 | 230 | 220 | 180 | 170 | 150 | 150 | 160 | 165 |
| Interior Clean | 0% | 40 | 50 | 50 | 55 | 60 | 65 | 70 | 80 | 80 | 85 | 75 | 60 |
| End User Detail | 0% | 3 | 5 | 7 | 10 | 12 | 12 | 14 | 9 | 11 | 14 | 15 | 17 |
| Business Fleet Washes | 0% | 25 | 40 | 55 | 60 | 60 | 55 | 55 | 55 | 55 | 50 | 50 | 55 |
| Car Dealership Details | 0% | 15 | 17 | 20 | 26 | 32 | 40 | 56 | 45 | 56 | 60 | 60 | 67 |
| Total Unit Sales | 263 | 372 | 487 | 561 | 584 | 577 | 510 | 494 | 472 | 479 | 500 | 519 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Full Wash | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | |
| Exterior Wash | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | |
| Interior Clean | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | |
| End User Detail | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | £140.00 | |
| Business Fleet Washes | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | |
| Car Dealership Details | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | £70.00 | |
| Sales | |||||||||||||
| Full Wash | £1,350 | £1,950 | £2,550 | £2,850 | £2,850 | £2,775 | £2,025 | £2,025 | £1,800 | £1,800 | £2,100 | £2,325 | |
| Exterior Wash | £810 | £1,170 | £1,665 | £1,980 | £2,070 | £1,980 | £1,620 | £1,530 | £1,350 | £1,350 | £1,440 | £1,485 | |
| Interior Clean | £320 | £400 | £400 | £440 | £480 | £520 | £560 | £640 | £640 | £680 | £600 | £480 | |
| End User Detail | £420 | £700 | £980 | £1,400 | £1,680 | £1,680 | £1,960 | £1,260 | £1,540 | £1,960 | £2,100 | £2,380 | |
| Business Fleet Washes | £250 | £400 | £550 | £600 | £600 | £550 | £550 | £550 | £550 | £500 | £500 | £550 | |
| Car Dealership Details | £1,050 | £1,190 | £1,400 | £1,820 | £2,240 | £2,800 | £3,920 | £3,150 | £3,920 | £4,200 | £4,200 | £4,690 | |
| Total Sales | £4,200 | £5,810 | £7,545 | £9,090 | £9,920 | £10,305 | £10,635 | £9,155 | £9,800 | £10,490 | £10,940 | £11,910 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Full Wash | 0.00% | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 |
| Exterior Wash | 0.00% | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 |
| Interior Clean | 0.00% | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 |
| End User Detail | 0.00% | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| Business Fleet Washes | 0.00% | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 | £0.70 |
| Car Dealership Details | 0.00% | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| Direct Cost of Sales | |||||||||||||
| Full Wash | £63 | £91 | £119 | £133 | £133 | £130 | £95 | £95 | £84 | £84 | £98 | £109 | |
| Exterior Wash | £36 | £52 | £74 | £88 | £92 | £88 | £72 | £68 | £60 | £60 | £64 | £66 | |
| Interior Clean | £12 | £15 | £15 | £17 | £18 | £20 | £21 | £24 | £24 | £26 | £23 | £18 | |
| End User Detail | £9 | £15 | £21 | £30 | £36 | £36 | £42 | £27 | £33 | £42 | £45 | £51 | |
| Business Fleet Washes | £18 | £28 | £39 | £42 | £42 | £39 | £39 | £39 | £39 | £35 | £35 | £39 | |
| Car Dealership Details | £45 | £51 | £60 | £78 | £96 | £120 | £168 | £135 | £168 | £180 | £180 | £201 | |
| Subtotal Direct Cost of Sales | £183 | £252 | £328 | £388 | £417 | £432 | £436 | £387 | £408 | £427 | £445 | £483 | |
| 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 | ||
| Owner | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Car Washers | 0% | £2,240 | £2,240 | £3,360 | £3,360 | £3,360 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Admin/Sales | 0% | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 | £1,120 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £4,860 | £4,860 | £5,980 | £5,980 | £5,980 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | |
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £4,200 | £5,810 | £7,545 | £9,090 | £9,920 | £10,305 | £10,635 | £9,155 | £9,800 | £10,490 | £10,940 | £11,910 | |
| Direct Cost of Sales | £183 | £252 | £328 | £388 | £417 | £432 | £436 | £387 | £408 | £427 | £445 | £483 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £183 | £252 | £328 | £388 | £417 | £432 | £436 | £387 | £408 | £427 | £445 | £483 | |
| Gross Margin | £4,018 | £5,558 | £7,218 | £8,703 | £9,503 | £9,874 | £10,199 | £8,768 | £9,393 | £10,064 | £10,496 | £11,427 | |
| Gross Margin % | 95.65% | 95.66% | 95.66% | 95.74% | 95.80% | 95.81% | 95.90% | 95.77% | 95.84% | 95.93% | 95.94% | 95.94% | |
| Expenses | |||||||||||||
| Payroll | £4,860 | £4,860 | £5,980 | £5,980 | £5,980 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | |
| Sales and Marketing and Other Expenses | £500 | £300 | £300 | £300 | £300 | £100 | £100 | £100 | £300 | £100 | £100 | £100 | |
| Depreciation | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £250 | £275 | £300 | £300 | £300 | £275 | £275 | £275 | £275 | £275 | £250 | £275 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Payroll Taxes | 25% | £1,215 | £1,215 | £1,495 | £1,495 | £1,495 | £1,215 | £1,215 | £1,215 | £1,215 | £1,215 | £1,215 | £1,215 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £7,547 | £7,372 | £8,797 | £8,797 | £8,797 | £7,172 | £7,172 | £7,172 | £7,372 | £7,172 | £7,147 | £7,172 | |
| Profit Before Interest and Taxes | (£3,530) | (£1,814) | (£1,580) | (£95) | £706 | £2,701 | £3,027 | £1,596 | £2,020 | £2,891 | £3,348 | £4,255 | |
| EBITDA | (£3,358) | (£1,642) | (£1,407) | £78 | £878 | £2,874 | £3,199 | £1,768 | £2,193 | £3,064 | £3,521 | £4,427 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,059) | (£454) | (£395) | (£24) | £176 | £675 | £757 | £399 | £505 | £723 | £837 | £1,064 | |
| Net Profit | (£2,471) | (£1,361) | (£1,185) | (£71) | £529 | £2,026 | £2,270 | £1,197 | £1,515 | £2,168 | £2,511 | £3,191 | |
| Net Profit/Sales | -58.83% | -23.42% | -15.71% | -0.78% | 5.33% | 19.66% | 21.34% | 13.07% | 15.46% | 20.67% | 22.95% | 26.79% | |
| 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 | £3,570 | £4,939 | £6,413 | £7,727 | £8,432 | £8,759 | £9,040 | £7,782 | £8,330 | £8,917 | £9,299 | £10,124 | |
| Cash from Receivables | £0 | £21 | £638 | £880 | £1,139 | £1,368 | £1,490 | £1,547 | £1,588 | £1,376 | £1,473 | £1,576 | |
| Subtotal Cash from Operations | £3,570 | £4,960 | £7,051 | £8,607 | £9,571 | £10,127 | £10,530 | £9,329 | £9,918 | £10,293 | £10,772 | £11,699 | |
| 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 | £3,570 | £4,960 | £7,051 | £8,607 | £9,571 | £10,127 | £10,530 | £9,329 | £9,918 | £10,293 | £10,772 | £11,699 | |
| 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 | £4,860 | £4,860 | £5,980 | £5,980 | £5,980 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | £4,860 | |
| Bill Payments | £82 | £2,437 | £1,898 | £2,296 | £3,595 | £2,855 | £3,785 | £2,885 | £2,582 | £3,812 | £2,899 | £3,927 | |
| Subtotal Spent on Operations | £4,942 | £7,297 | £7,878 | £8,276 | £9,575 | £7,715 | £8,645 | £7,745 | £7,442 | £8,672 | £7,759 | £8,787 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £0 | |
| Subtotal Cash Spent | £4,942 | £7,297 | £7,878 | £8,276 | £9,575 | £7,715 | £8,645 | £7,745 | £7,442 | £8,672 | £7,759 | £8,787 | |
| Net Cash Flow | (£1,372) | (£2,338) | (£827) | £331 | (£3) | £2,412 | £1,885 | £1,584 | £2,475 | £1,621 | £3,013 | £2,912 | |
| Cash Balance | £7,328 | £4,991 | £4,163 | £4,494 | £4,491 | £6,904 | £8,789 | £10,373 | £12,849 | £14,469 | £17,483 | £20,395 | |
| 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 | £8,700 | £7,328 | £4,991 | £4,163 | £4,494 | £4,491 | £6,904 | £8,789 | £10,373 | £12,849 | £14,469 | £17,483 | £20,395 |
| Accounts Receivable | £0 | £630 | £1,481 | £1,974 | £2,458 | £2,806 | £2,984 | £3,089 | £2,915 | £2,797 | £2,994 | £3,162 | £3,373 |
| Inventory | £250 | £1,068 | £816 | £488 | £1,101 | £684 | £1,252 | £816 | £429 | £1,022 | £595 | £1,151 | £668 |
| Other Current Assets | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total Current Assets | £9,950 | £10,026 | £8,287 | £7,626 | £9,052 | £8,981 | £12,140 | £13,694 | £14,717 | £17,668 | £19,059 | £22,795 | £25,435 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Accumulated Depreciation | £0 | £172 | £345 | £517 | £690 | £862 | £1,035 | £1,207 | £1,380 | £1,552 | £1,725 | £1,897 | £2,070 |
| Total Long-term Assets | £10,000 | £9,828 | £9,655 | £9,483 | £9,310 | £9,138 | £8,965 | £8,793 | £8,620 | £8,448 | £8,275 | £8,103 | £7,930 |
| Total Assets | £19,950 | £19,853 | £17,942 | £17,108 | £18,362 | £18,118 | £21,105 | £22,487 | £23,338 | £26,115 | £27,334 | £30,898 | £33,365 |
| 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 | £2,374 | £1,823 | £2,175 | £3,501 | £2,727 | £3,688 | £2,800 | £2,454 | £3,717 | £2,767 | £3,820 | £3,097 |
| 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 | £2,374 | £1,823 | £2,175 | £3,501 | £2,727 | £3,688 | £2,800 | £2,454 | £3,717 | £2,767 | £3,820 | £3,097 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £2,374 | £1,823 | £2,175 | £3,501 | £2,727 | £3,688 | £2,800 | £2,454 | £3,717 | £2,767 | £3,820 | £3,097 |
| Paid-in Capital | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Retained Earnings | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) | (£10,050) |
| Earnings | £0 | (£2,471) | (£3,832) | (£5,017) | (£5,088) | (£4,559) | (£2,533) | (£263) | £933 | £2,448 | £4,617 | £7,128 | £10,318 |
| Total Capital | £19,950 | £17,479 | £16,118 | £14,933 | £14,862 | £15,391 | £17,417 | £19,687 | £20,883 | £22,398 | £24,567 | £27,078 | £30,268 |
| Total Liabilities and Capital | £19,950 | £19,853 | £17,942 | £17,108 | £18,362 | £18,118 | £21,105 | £22,487 | £23,338 | £26,115 | £27,334 | £30,898 | £33,365 |
| Net Worth | £19,950 | £17,479 | £16,118 | £14,933 | £14,862 | £15,391 | £17,417 | £19,687 | £20,883 | £22,398 | £24,567 | £27,078 | £30,268 |