| 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 | |||||||||||||
| Moped Rentals | 0% | 25 | 285 | 354 | 414 | 436 | 356 | 454 | 376 | 324 | 300 | 161 | 48 |
| Moped Accessories | 0% | 50 | 570 | 708 | 828 | 872 | 712 | 908 | 752 | 648 | 600 | 322 | 96 |
| Other | 0% | 75 | 855 | 1,062 | 1,242 | 1,308 | 1,068 | 1,362 | 1,128 | 972 | 900 | 483 | 144 |
| Total Unit Sales | 150 | 1,710 | 2,124 | 2,484 | 2,616 | 2,136 | 2,724 | 2,256 | 1,944 | 1,800 | 966 | 288 | |
| 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 | |
| Moped Rentals | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | |
| Moped Accessories | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | |
| Other | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | |
| Sales | |||||||||||||
| Moped Rentals | £1,250 | £14,250 | £17,700 | £20,700 | £21,800 | £17,800 | £22,700 | £18,800 | £16,200 | £15,000 | £8,050 | £2,400 | |
| Moped Accessories | £1,750 | £19,950 | £24,780 | £28,980 | £30,520 | £24,920 | £31,780 | £26,320 | £22,680 | £21,000 | £11,270 | £3,360 | |
| Other | £375 | £4,275 | £5,310 | £6,210 | £6,540 | £5,340 | £6,810 | £5,640 | £4,860 | £4,500 | £2,415 | £720 | |
| Total Sales | £3,375 | £38,475 | £47,790 | £55,890 | £58,860 | £48,060 | £61,290 | £50,760 | £43,740 | £40,500 | £21,735 | £6,480 | |
| 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 | |
| Moped Rentals | 0.00% | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 |
| Moped Accessories | 0.00% | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 |
| Other | 0.00% | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 |
| Direct Cost of Sales | |||||||||||||
| Moped Rentals | £125 | £1,425 | £1,770 | £2,070 | £2,180 | £1,780 | £2,270 | £1,880 | £1,620 | £1,500 | £805 | £240 | |
| Moped Accessories | £550 | £6,270 | £7,788 | £9,108 | £9,592 | £7,832 | £9,988 | £8,272 | £7,128 | £6,600 | £3,542 | £1,056 | |
| Other | £150 | £1,710 | £2,124 | £2,484 | £2,616 | £2,136 | £2,724 | £2,256 | £1,944 | £1,800 | £966 | £288 | |
| Subtotal Direct Cost of Sales | £825 | £9,405 | £11,682 | £13,662 | £14,388 | £11,748 | £14,982 | £12,408 | £10,692 | £9,900 | £5,313 | £1,584 | |
| 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 | ||
| Shop Help | 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 |
| Mechanics | 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 |
| Management | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Other | 0% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | |
| 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 | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | |
| Tax Rate | 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 | 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 | £3,375 | £38,475 | £47,790 | £55,890 | £58,860 | £48,060 | £61,290 | £50,760 | £43,740 | £40,500 | £21,735 | £6,480 | |
| Direct Cost of Sales | £825 | £9,405 | £11,682 | £13,662 | £14,388 | £11,748 | £14,982 | £12,408 | £10,692 | £9,900 | £5,313 | £1,584 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £825 | £9,405 | £11,682 | £13,662 | £14,388 | £11,748 | £14,982 | £12,408 | £10,692 | £9,900 | £5,313 | £1,584 | |
| Gross Margin | £2,550 | £29,070 | £36,108 | £42,228 | £44,472 | £36,312 | £46,308 | £38,352 | £33,048 | £30,600 | £16,422 | £4,896 | |
| Gross Margin % | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | |
| Expenses | |||||||||||||
| Payroll | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | |
| Sales and Marketing and Other Expenses | £500 | £200 | £200 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £100,000 | |
| Leased Equipment | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Utilities | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Payroll Taxes | 15% | £938 | £938 | £938 | £938 | £938 | £938 | £938 | £938 | £938 | £938 | £938 | £938 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £9,988 | £9,688 | £9,688 | £9,488 | £9,488 | £9,488 | £9,488 | £9,488 | £9,488 | £9,488 | £9,488 | £109,488 | |
| Profit Before Interest and Taxes | (£7,438) | £19,383 | £26,421 | £32,741 | £34,985 | £26,825 | £36,821 | £28,865 | £23,561 | £21,113 | £6,935 | (£104,592) | |
| EBITDA | (£7,438) | £19,383 | £26,421 | £32,741 | £34,985 | £26,825 | £36,821 | £28,865 | £23,561 | £21,113 | £6,935 | (£4,592) | |
| Interest Expense | £2,447 | £2,436 | £2,424 | £2,413 | £2,401 | £2,389 | £2,378 | £2,366 | £2,354 | £2,342 | £2,330 | £2,317 | |
| Taxes Incurred | (£2,965) | £5,084 | £7,199 | £9,098 | £9,775 | £7,331 | £10,333 | £7,950 | £6,362 | £5,631 | £1,381 | (£32,073) | |
| Net Profit | (£6,919) | £11,863 | £16,797 | £21,229 | £22,808 | £17,105 | £24,110 | £18,549 | £14,845 | £13,140 | £3,223 | (£74,836) | |
| Net Profit/Sales | -205.01% | 30.83% | 35.15% | 37.98% | 38.75% | 35.59% | 39.34% | 36.54% | 33.94% | 32.44% | 14.83% | -1154.88% | |
| 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,375 | £38,475 | £47,790 | £55,890 | £58,860 | £48,060 | £61,290 | £50,760 | £43,740 | £40,500 | £21,735 | £6,480 | |
| Subtotal Cash from Operations | £3,375 | £38,475 | £47,790 | £55,890 | £58,860 | £48,060 | £61,290 | £50,760 | £43,740 | £40,500 | £21,735 | £6,480 | |
| 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,375 | £38,475 | £47,790 | £55,890 | £58,860 | £48,060 | £61,290 | £50,760 | £43,740 | £40,500 | £21,735 | £6,480 | |
| 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 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | |
| Bill Payments | £107 | £3,477 | £11,027 | £13,117 | £14,771 | £15,332 | £13,413 | £26,504 | £23,050 | £20,740 | £19,830 | (£18,834) | |
| Subtotal Spent on Operations | £6,357 | £9,727 | £17,277 | £19,367 | £21,021 | £21,582 | £19,663 | £32,754 | £29,300 | £26,990 | £26,080 | (£12,584) | |
| 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 | £1,595 | £1,606 | £1,617 | £1,629 | £1,640 | £1,652 | £1,664 | £1,675 | £1,687 | £1,699 | £1,711 | £1,723 | |
| 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 | £7,952 | £11,333 | £18,895 | £20,996 | £22,661 | £23,234 | £21,326 | £34,429 | £30,988 | £28,690 | £27,791 | (£10,861) | |
| Net Cash Flow | (£4,577) | £27,142 | £28,895 | £34,894 | £36,199 | £24,826 | £39,964 | £16,331 | £12,752 | £11,810 | (£6,056) | £17,341 | |
| Cash Balance | £28,523 | £55,665 | £84,561 | £119,455 | £155,654 | £180,481 | £220,444 | £236,775 | £249,527 | £261,338 | £255,282 | £272,623 | |
| 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 | £33,100 | £28,523 | £55,665 | £84,561 | £119,455 | £155,654 | £180,481 | £220,444 | £236,775 | £249,527 | £261,338 | £255,282 | £272,623 |
| Inventory | £82,500 | £81,675 | £72,270 | £60,588 | £46,926 | £32,538 | £20,790 | £16,480 | £13,649 | £11,761 | £10,890 | £6,577 | £4,993 |
| 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 | £165,600 | £160,198 | £177,935 | £195,149 | £216,381 | £238,192 | £251,271 | £286,924 | £300,424 | £311,289 | £322,228 | £311,859 | £327,616 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £100,000 |
| Total Long-term Assets | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £200,000 |
| Total Assets | £465,600 | £460,198 | £477,935 | £495,149 | £516,381 | £538,192 | £551,271 | £586,924 | £600,424 | £611,289 | £622,228 | £611,859 | £527,616 |
| 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 | £3,112 | £10,592 | £12,625 | £14,257 | £14,900 | £12,525 | £25,733 | £22,358 | £20,066 | £19,565 | £7,684 | £0 |
| Current Borrowing | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £40,000 | £43,112 | £50,592 | £52,625 | £54,257 | £54,900 | £52,525 | £65,733 | £62,358 | £60,066 | £59,565 | £47,684 | £40,000 |
| Long-term Liabilities | £300,000 | £298,405 | £296,800 | £295,182 | £293,554 | £291,913 | £290,262 | £288,598 | £286,923 | £285,235 | £283,536 | £281,825 | £280,102 |
| Total Liabilities | £340,000 | £341,517 | £347,392 | £347,808 | £347,811 | £346,813 | £342,787 | £354,331 | £349,281 | £345,301 | £343,101 | £329,509 | £320,102 |
| Paid-in Capital | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 |
| Retained Earnings | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) |
| Earnings | £0 | (£6,919) | £4,944 | £21,741 | £42,970 | £65,779 | £82,884 | £106,994 | £125,543 | £140,387 | £153,527 | £156,750 | £81,914 |
| Total Capital | £125,600 | £118,681 | £130,544 | £147,341 | £168,570 | £191,379 | £208,484 | £232,594 | £251,143 | £265,987 | £279,127 | £282,350 | £207,514 |
| Total Liabilities and Capital | £465,600 | £460,198 | £477,935 | £495,149 | £516,381 | £538,192 | £551,271 | £586,924 | £600,424 | £611,289 | £622,228 | £611,859 | £527,616 |
| Net Worth | £125,600 | £118,681 | £130,544 | £147,341 | £168,570 | £191,379 | £208,484 | £232,594 | £251,143 | £265,987 | £279,127 | £282,350 | £207,514 |
| 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 | |||||||||||||
| Moped Rentals | 0% | 25 | 285 | 354 | 414 | 436 | 356 | 454 | 376 | 324 | 300 | 161 | 48 |
| Moped Accessories | 0% | 50 | 570 | 708 | 828 | 872 | 712 | 908 | 752 | 648 | 600 | 322 | 96 |
| Other | 0% | 75 | 855 | 1,062 | 1,242 | 1,308 | 1,068 | 1,362 | 1,128 | 972 | 900 | 483 | 144 |
| Total Unit Sales | 150 | 1,710 | 2,124 | 2,484 | 2,616 | 2,136 | 2,724 | 2,256 | 1,944 | 1,800 | 966 | 288 | |
| 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 | |
| Moped Rentals | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | |
| Moped Accessories | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | |
| Other | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | |
| Sales | |||||||||||||
| Moped Rentals | £1,250 | £14,250 | £17,700 | £20,700 | £21,800 | £17,800 | £22,700 | £18,800 | £16,200 | £15,000 | £8,050 | £2,400 | |
| Moped Accessories | £1,750 | £19,950 | £24,780 | £28,980 | £30,520 | £24,920 | £31,780 | £26,320 | £22,680 | £21,000 | £11,270 | £3,360 | |
| Other | £375 | £4,275 | £5,310 | £6,210 | £6,540 | £5,340 | £6,810 | £5,640 | £4,860 | £4,500 | £2,415 | £720 | |
| Total Sales | £3,375 | £38,475 | £47,790 | £55,890 | £58,860 | £48,060 | £61,290 | £50,760 | £43,740 | £40,500 | £21,735 | £6,480 | |
| 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 | |
| Moped Rentals | 0.00% | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 |
| Moped Accessories | 0.00% | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 | £11.00 |
| Other | 0.00% | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 |
| Direct Cost of Sales | |||||||||||||
| Moped Rentals | £125 | £1,425 | £1,770 | £2,070 | £2,180 | £1,780 | £2,270 | £1,880 | £1,620 | £1,500 | £805 | £240 | |
| Moped Accessories | £550 | £6,270 | £7,788 | £9,108 | £9,592 | £7,832 | £9,988 | £8,272 | £7,128 | £6,600 | £3,542 | £1,056 | |
| Other | £150 | £1,710 | £2,124 | £2,484 | £2,616 | £2,136 | £2,724 | £2,256 | £1,944 | £1,800 | £966 | £288 | |
| Subtotal Direct Cost of Sales | £825 | £9,405 | £11,682 | £13,662 | £14,388 | £11,748 | £14,982 | £12,408 | £10,692 | £9,900 | £5,313 | £1,584 | |
| 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 | ||
| Shop Help | 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 |
| Mechanics | 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 |
| Management | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Other | 0% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | |
| 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 | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | |
| Tax Rate | 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 | 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 | £3,375 | £38,475 | £47,790 | £55,890 | £58,860 | £48,060 | £61,290 | £50,760 | £43,740 | £40,500 | £21,735 | £6,480 | |
| Direct Cost of Sales | £825 | £9,405 | £11,682 | £13,662 | £14,388 | £11,748 | £14,982 | £12,408 | £10,692 | £9,900 | £5,313 | £1,584 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £825 | £9,405 | £11,682 | £13,662 | £14,388 | £11,748 | £14,982 | £12,408 | £10,692 | £9,900 | £5,313 | £1,584 | |
| Gross Margin | £2,550 | £29,070 | £36,108 | £42,228 | £44,472 | £36,312 | £46,308 | £38,352 | £33,048 | £30,600 | £16,422 | £4,896 | |
| Gross Margin % | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | 75.56% | |
| Expenses | |||||||||||||
| Payroll | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | |
| Sales and Marketing and Other Expenses | £500 | £200 | £200 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £100,000 | |
| Leased Equipment | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Utilities | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Payroll Taxes | 15% | £938 | £938 | £938 | £938 | £938 | £938 | £938 | £938 | £938 | £938 | £938 | £938 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £9,988 | £9,688 | £9,688 | £9,488 | £9,488 | £9,488 | £9,488 | £9,488 | £9,488 | £9,488 | £9,488 | £109,488 | |
| Profit Before Interest and Taxes | (£7,438) | £19,383 | £26,421 | £32,741 | £34,985 | £26,825 | £36,821 | £28,865 | £23,561 | £21,113 | £6,935 | (£104,592) | |
| EBITDA | (£7,438) | £19,383 | £26,421 | £32,741 | £34,985 | £26,825 | £36,821 | £28,865 | £23,561 | £21,113 | £6,935 | (£4,592) | |
| Interest Expense | £2,447 | £2,436 | £2,424 | £2,413 | £2,401 | £2,389 | £2,378 | £2,366 | £2,354 | £2,342 | £2,330 | £2,317 | |
| Taxes Incurred | (£2,965) | £5,084 | £7,199 | £9,098 | £9,775 | £7,331 | £10,333 | £7,950 | £6,362 | £5,631 | £1,381 | (£32,073) | |
| Net Profit | (£6,919) | £11,863 | £16,797 | £21,229 | £22,808 | £17,105 | £24,110 | £18,549 | £14,845 | £13,140 | £3,223 | (£74,836) | |
| Net Profit/Sales | -205.01% | 30.83% | 35.15% | 37.98% | 38.75% | 35.59% | 39.34% | 36.54% | 33.94% | 32.44% | 14.83% | -1154.88% | |
| 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,375 | £38,475 | £47,790 | £55,890 | £58,860 | £48,060 | £61,290 | £50,760 | £43,740 | £40,500 | £21,735 | £6,480 | |
| Subtotal Cash from Operations | £3,375 | £38,475 | £47,790 | £55,890 | £58,860 | £48,060 | £61,290 | £50,760 | £43,740 | £40,500 | £21,735 | £6,480 | |
| 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,375 | £38,475 | £47,790 | £55,890 | £58,860 | £48,060 | £61,290 | £50,760 | £43,740 | £40,500 | £21,735 | £6,480 | |
| 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 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | |
| Bill Payments | £107 | £3,477 | £11,027 | £13,117 | £14,771 | £15,332 | £13,413 | £26,504 | £23,050 | £20,740 | £19,830 | (£18,834) | |
| Subtotal Spent on Operations | £6,357 | £9,727 | £17,277 | £19,367 | £21,021 | £21,582 | £19,663 | £32,754 | £29,300 | £26,990 | £26,080 | (£12,584) | |
| 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 | £1,595 | £1,606 | £1,617 | £1,629 | £1,640 | £1,652 | £1,664 | £1,675 | £1,687 | £1,699 | £1,711 | £1,723 | |
| 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 | £7,952 | £11,333 | £18,895 | £20,996 | £22,661 | £23,234 | £21,326 | £34,429 | £30,988 | £28,690 | £27,791 | (£10,861) | |
| Net Cash Flow | (£4,577) | £27,142 | £28,895 | £34,894 | £36,199 | £24,826 | £39,964 | £16,331 | £12,752 | £11,810 | (£6,056) | £17,341 | |
| Cash Balance | £28,523 | £55,665 | £84,561 | £119,455 | £155,654 | £180,481 | £220,444 | £236,775 | £249,527 | £261,338 | £255,282 | £272,623 | |
| 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 | £33,100 | £28,523 | £55,665 | £84,561 | £119,455 | £155,654 | £180,481 | £220,444 | £236,775 | £249,527 | £261,338 | £255,282 | £272,623 |
| Inventory | £82,500 | £81,675 | £72,270 | £60,588 | £46,926 | £32,538 | £20,790 | £16,480 | £13,649 | £11,761 | £10,890 | £6,577 | £4,993 |
| 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 | £165,600 | £160,198 | £177,935 | £195,149 | £216,381 | £238,192 | £251,271 | £286,924 | £300,424 | £311,289 | £322,228 | £311,859 | £327,616 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £100,000 |
| Total Long-term Assets | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £200,000 |
| Total Assets | £465,600 | £460,198 | £477,935 | £495,149 | £516,381 | £538,192 | £551,271 | £586,924 | £600,424 | £611,289 | £622,228 | £611,859 | £527,616 |
| 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 | £3,112 | £10,592 | £12,625 | £14,257 | £14,900 | £12,525 | £25,733 | £22,358 | £20,066 | £19,565 | £7,684 | £0 |
| Current Borrowing | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £40,000 | £43,112 | £50,592 | £52,625 | £54,257 | £54,900 | £52,525 | £65,733 | £62,358 | £60,066 | £59,565 | £47,684 | £40,000 |
| Long-term Liabilities | £300,000 | £298,405 | £296,800 | £295,182 | £293,554 | £291,913 | £290,262 | £288,598 | £286,923 | £285,235 | £283,536 | £281,825 | £280,102 |
| Total Liabilities | £340,000 | £341,517 | £347,392 | £347,808 | £347,811 | £346,813 | £342,787 | £354,331 | £349,281 | £345,301 | £343,101 | £329,509 | £320,102 |
| Paid-in Capital | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 |
| Retained Earnings | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) | (£4,400) |
| Earnings | £0 | (£6,919) | £4,944 | £21,741 | £42,970 | £65,779 | £82,884 | £106,994 | £125,543 | £140,387 | £153,527 | £156,750 | £81,914 |
| Total Capital | £125,600 | £118,681 | £130,544 | £147,341 | £168,570 | £191,379 | £208,484 | £232,594 | £251,143 | £265,987 | £279,127 | £282,350 | £207,514 |
| Total Liabilities and Capital | £465,600 | £460,198 | £477,935 | £495,149 | £516,381 | £538,192 | £551,271 | £586,924 | £600,424 | £611,289 | £622,228 | £611,859 | £527,616 |
| Net Worth | £125,600 | £118,681 | £130,544 | £147,341 | £168,570 | £191,379 | £208,484 | £232,594 | £251,143 | £265,987 | £279,127 | £282,350 | £207,514 |