| 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 | |||||||||||||
| Auto Repair Jobs | 0% | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 |
| Auto Parts | 0% | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | |
| 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 | |
| Auto Repair Jobs | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | |
| Auto Parts | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | |
| Sales | |||||||||||||
| Auto Repair Jobs | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | |
| Auto Parts | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | |
| 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 | |
| Auto Repair Jobs | 0.00% | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 |
| Auto Parts | 0.00% | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Auto Repair Jobs | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | |
| Auto Parts | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | |
| 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 | ||
| Owners | 0% | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 |
| Managers | 0% | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 |
| Mechanics | 0% | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 |
| Customer Service Associates | 0% | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 |
| Sales & Administrative | 0% | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 |
| Total People | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | |
| Total Payroll | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | |
| 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 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | |
| Direct Cost of Sales | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | |
| Gross Margin | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | |
| Gross Margin % | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | |
| Expenses | |||||||||||||
| Payroll | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | |
| Sales and Marketing and Other Expenses | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | |
| Depreciation | 15% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Utilities | 5% | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Payroll Taxes | 15% | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | |
| Profit Before Interest and Taxes | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | |
| EBITDA | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | |
| Interest Expense | £2,495 | £2,448 | £2,401 | £2,353 | £2,305 | £2,256 | £2,207 | £2,157 | £2,108 | £2,057 | £2,007 | £1,956 | |
| Taxes Incurred | £11,740 | £9,795 | £9,807 | £9,819 | £9,831 | £9,843 | £9,856 | £9,868 | £9,880 | £9,893 | £9,906 | £9,918 | |
| Net Profit | £27,394 | £29,386 | £29,421 | £29,457 | £29,493 | £29,530 | £29,567 | £29,604 | £29,641 | £29,679 | £29,717 | £29,755 | |
| Net Profit/Sales | 3.45% | 3.70% | 3.70% | 3.71% | 3.71% | 3.71% | 3.72% | 3.72% | 3.73% | 3.73% | 3.74% | 3.74% | |
| 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 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | |
| Subtotal Cash from Operations | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | |
| 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 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | |
| 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 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | |
| Bill Payments | £23,609 | £697,865 | £396,030 | £395,994 | £395,958 | £395,922 | £395,885 | £395,849 | £395,812 | £395,774 | £395,737 | £395,699 | |
| Subtotal Spent on Operations | £383,192 | £1,057,448 | £755,613 | £755,577 | £755,541 | £755,505 | £755,469 | £755,432 | £755,395 | £755,358 | £755,320 | £755,282 | |
| 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 | £4,377 | £4,414 | £4,450 | £4,487 | £4,525 | £4,562 | £4,601 | £4,639 | £4,677 | £4,716 | £4,756 | £4,796 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £1,220 | £1,231 | £1,241 | £1,251 | £1,262 | £1,272 | £1,283 | £1,293 | £1,304 | £1,315 | £1,326 | £1,337 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £433,789 | £1,108,093 | £806,304 | £806,315 | £806,328 | £806,339 | £806,353 | £806,364 | £806,376 | £806,389 | £806,402 | £806,415 | |
| Net Cash Flow | £361,211 | (£313,093) | (£11,304) | (£11,315) | (£11,328) | (£11,339) | (£11,353) | (£11,364) | (£11,376) | (£11,389) | (£11,402) | (£11,415) | |
| Cash Balance | £461,211 | £148,118 | £136,814 | £125,498 | £114,170 | £102,830 | £91,478 | £80,114 | £68,738 | £57,349 | £45,947 | £34,532 | |
| 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 | £100,000 | £461,211 | £148,118 | £136,814 | £125,498 | £114,170 | £102,830 | £91,478 | £80,114 | £68,738 | £57,349 | £45,947 | £34,532 |
| Inventory | £50,000 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 |
| Other Current Assets | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Total Current Assets | £200,000 | £871,461 | £558,368 | £547,064 | £535,748 | £524,420 | £513,080 | £501,728 | £490,364 | £478,988 | £467,599 | £456,197 | £444,782 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £350,000 | £395,000 | £440,000 | £485,000 | £530,000 | £575,000 | £620,000 | £665,000 | £710,000 | £755,000 | £800,000 | £845,000 | £890,000 |
| Accumulated Depreciation | £0 | £10,000 | £20,000 | £30,000 | £40,000 | £50,000 | £60,000 | £70,000 | £80,000 | £90,000 | £100,000 | £110,000 | £120,000 |
| Total Long-term Assets | £350,000 | £385,000 | £420,000 | £455,000 | £490,000 | £525,000 | £560,000 | £595,000 | £630,000 | £665,000 | £700,000 | £735,000 | £770,000 |
| Total Assets | £550,000 | £1,256,461 | £978,368 | £1,002,064 | £1,025,748 | £1,049,420 | £1,073,080 | £1,096,728 | £1,120,364 | £1,143,988 | £1,167,599 | £1,191,197 | £1,214,782 |
| 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 | £684,664 | £382,830 | £382,795 | £382,761 | £382,726 | £382,690 | £382,655 | £382,619 | £382,583 | £382,547 | £382,510 | £382,473 |
| Current Borrowing | £55,000 | £50,623 | £46,209 | £41,759 | £37,272 | £32,747 | £28,185 | £23,584 | £18,945 | £14,268 | £9,552 | £4,796 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £55,000 | £735,287 | £429,039 | £424,554 | £420,033 | £415,473 | £410,875 | £406,239 | £401,564 | £396,851 | £392,099 | £387,306 | £382,473 |
| Long-term Liabilities | £250,000 | £248,780 | £247,549 | £246,308 | £245,057 | £243,795 | £242,523 | £241,240 | £239,947 | £238,643 | £237,328 | £236,002 | £234,665 |
| Total Liabilities | £305,000 | £984,067 | £676,588 | £670,862 | £665,090 | £659,268 | £653,398 | £647,479 | £641,511 | £635,494 | £629,427 | £623,308 | £617,138 |
| Paid-in Capital | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 |
| Retained Earnings | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) |
| Earnings | £0 | £27,394 | £56,780 | £86,201 | £115,659 | £145,152 | £174,682 | £204,249 | £233,853 | £263,494 | £293,173 | £322,889 | £352,645 |
| Total Capital | £245,000 | £272,394 | £301,780 | £331,201 | £360,659 | £390,152 | £419,682 | £449,249 | £478,853 | £508,494 | £538,173 | £567,889 | £597,645 |
| Total Liabilities and Capital | £550,000 | £1,256,461 | £978,368 | £1,002,064 | £1,025,748 | £1,049,420 | £1,073,080 | £1,096,728 | £1,120,364 | £1,143,988 | £1,167,599 | £1,191,197 | £1,214,782 |
| Net Worth | £245,000 | £272,394 | £301,780 | £331,201 | £360,659 | £390,152 | £419,682 | £449,249 | £478,853 | £508,494 | £538,173 | £567,889 | £597,645 |
| 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 | |||||||||||||
| Auto Repair Jobs | 0% | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 | 1,400 |
| Auto Parts | 0% | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 | 6,250 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | |
| 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 | |
| Auto Repair Jobs | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | |
| Auto Parts | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | |
| Sales | |||||||||||||
| Auto Repair Jobs | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | £420,000 | |
| Auto Parts | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | £375,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | |
| 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 | |
| Auto Repair Jobs | 0.00% | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 |
| Auto Parts | 0.00% | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 | £30.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Auto Repair Jobs | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | |
| Auto Parts | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | £187,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | |
| 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 | ||
| Owners | 0% | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 | £26,667 |
| Managers | 0% | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 |
| Mechanics | 0% | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 | £262,500 |
| Customer Service Associates | 0% | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 | £22,500 |
| Sales & Administrative | 0% | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 | £36,667 |
| Total People | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | |
| Total Payroll | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | |
| 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 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | |
| Direct Cost of Sales | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | £327,500 | |
| Gross Margin | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | £467,500 | |
| Gross Margin % | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | 58.81% | |
| Expenses | |||||||||||||
| Payroll | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | |
| Sales and Marketing and Other Expenses | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | |
| Depreciation | 15% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Utilities | 5% | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Payroll Taxes | 15% | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 | £53,938 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | £425,871 | |
| Profit Before Interest and Taxes | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | £41,629 | |
| EBITDA | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | £51,629 | |
| Interest Expense | £2,495 | £2,448 | £2,401 | £2,353 | £2,305 | £2,256 | £2,207 | £2,157 | £2,108 | £2,057 | £2,007 | £1,956 | |
| Taxes Incurred | £11,740 | £9,795 | £9,807 | £9,819 | £9,831 | £9,843 | £9,856 | £9,868 | £9,880 | £9,893 | £9,906 | £9,918 | |
| Net Profit | £27,394 | £29,386 | £29,421 | £29,457 | £29,493 | £29,530 | £29,567 | £29,604 | £29,641 | £29,679 | £29,717 | £29,755 | |
| Net Profit/Sales | 3.45% | 3.70% | 3.70% | 3.71% | 3.71% | 3.71% | 3.72% | 3.72% | 3.73% | 3.73% | 3.74% | 3.74% | |
| 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 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | |
| Subtotal Cash from Operations | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | |
| 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 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | £795,000 | |
| 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 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | £359,583 | |
| Bill Payments | £23,609 | £697,865 | £396,030 | £395,994 | £395,958 | £395,922 | £395,885 | £395,849 | £395,812 | £395,774 | £395,737 | £395,699 | |
| Subtotal Spent on Operations | £383,192 | £1,057,448 | £755,613 | £755,577 | £755,541 | £755,505 | £755,469 | £755,432 | £755,395 | £755,358 | £755,320 | £755,282 | |
| 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 | £4,377 | £4,414 | £4,450 | £4,487 | £4,525 | £4,562 | £4,601 | £4,639 | £4,677 | £4,716 | £4,756 | £4,796 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £1,220 | £1,231 | £1,241 | £1,251 | £1,262 | £1,272 | £1,283 | £1,293 | £1,304 | £1,315 | £1,326 | £1,337 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £433,789 | £1,108,093 | £806,304 | £806,315 | £806,328 | £806,339 | £806,353 | £806,364 | £806,376 | £806,389 | £806,402 | £806,415 | |
| Net Cash Flow | £361,211 | (£313,093) | (£11,304) | (£11,315) | (£11,328) | (£11,339) | (£11,353) | (£11,364) | (£11,376) | (£11,389) | (£11,402) | (£11,415) | |
| Cash Balance | £461,211 | £148,118 | £136,814 | £125,498 | £114,170 | £102,830 | £91,478 | £80,114 | £68,738 | £57,349 | £45,947 | £34,532 | |
| 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 | £100,000 | £461,211 | £148,118 | £136,814 | £125,498 | £114,170 | £102,830 | £91,478 | £80,114 | £68,738 | £57,349 | £45,947 | £34,532 |
| Inventory | £50,000 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 | £360,250 |
| Other Current Assets | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Total Current Assets | £200,000 | £871,461 | £558,368 | £547,064 | £535,748 | £524,420 | £513,080 | £501,728 | £490,364 | £478,988 | £467,599 | £456,197 | £444,782 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £350,000 | £395,000 | £440,000 | £485,000 | £530,000 | £575,000 | £620,000 | £665,000 | £710,000 | £755,000 | £800,000 | £845,000 | £890,000 |
| Accumulated Depreciation | £0 | £10,000 | £20,000 | £30,000 | £40,000 | £50,000 | £60,000 | £70,000 | £80,000 | £90,000 | £100,000 | £110,000 | £120,000 |
| Total Long-term Assets | £350,000 | £385,000 | £420,000 | £455,000 | £490,000 | £525,000 | £560,000 | £595,000 | £630,000 | £665,000 | £700,000 | £735,000 | £770,000 |
| Total Assets | £550,000 | £1,256,461 | £978,368 | £1,002,064 | £1,025,748 | £1,049,420 | £1,073,080 | £1,096,728 | £1,120,364 | £1,143,988 | £1,167,599 | £1,191,197 | £1,214,782 |
| 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 | £684,664 | £382,830 | £382,795 | £382,761 | £382,726 | £382,690 | £382,655 | £382,619 | £382,583 | £382,547 | £382,510 | £382,473 |
| Current Borrowing | £55,000 | £50,623 | £46,209 | £41,759 | £37,272 | £32,747 | £28,185 | £23,584 | £18,945 | £14,268 | £9,552 | £4,796 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £55,000 | £735,287 | £429,039 | £424,554 | £420,033 | £415,473 | £410,875 | £406,239 | £401,564 | £396,851 | £392,099 | £387,306 | £382,473 |
| Long-term Liabilities | £250,000 | £248,780 | £247,549 | £246,308 | £245,057 | £243,795 | £242,523 | £241,240 | £239,947 | £238,643 | £237,328 | £236,002 | £234,665 |
| Total Liabilities | £305,000 | £984,067 | £676,588 | £670,862 | £665,090 | £659,268 | £653,398 | £647,479 | £641,511 | £635,494 | £629,427 | £623,308 | £617,138 |
| Paid-in Capital | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 |
| Retained Earnings | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) |
| Earnings | £0 | £27,394 | £56,780 | £86,201 | £115,659 | £145,152 | £174,682 | £204,249 | £233,853 | £263,494 | £293,173 | £322,889 | £352,645 |
| Total Capital | £245,000 | £272,394 | £301,780 | £331,201 | £360,659 | £390,152 | £419,682 | £449,249 | £478,853 | £508,494 | £538,173 | £567,889 | £597,645 |
| Total Liabilities and Capital | £550,000 | £1,256,461 | £978,368 | £1,002,064 | £1,025,748 | £1,049,420 | £1,073,080 | £1,096,728 | £1,120,364 | £1,143,988 | £1,167,599 | £1,191,197 | £1,214,782 |
| Net Worth | £245,000 | £272,394 | £301,780 | £331,201 | £360,659 | £390,152 | £419,682 | £449,249 | £478,853 | £508,494 | £538,173 | £567,889 | £597,645 |