| 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 | |||||||||||||
| Miniature Golf | 0% | £1,800 | £9,300 | £36,000 | £37,200 | £37,200 | £18,000 | £13,020 | £8,400 | £5,040 | £0 | £0 | £4,800 |
| Climbing Wall | 0% | £270 | £1,395 | £5,400 | £5,580 | £5,580 | £2,700 | £1,953 | £1,260 | £756 | £0 | £0 | £720 |
| Outside Concessions | 0% | £72 | £372 | £1,440 | £1,488 | £1,488 | £720 | £521 | £336 | £202 | £0 | £0 | £192 |
| Inside Concessions | 0% | £189 | £977 | £3,780 | £3,906 | £3,906 | £1,890 | £1,367 | £882 | £529 | £0 | £0 | £504 |
| Arcade Transactions | 0% | £288 | £1,488 | £5,760 | £5,952 | £5,952 | £2,880 | £2,083 | £1,344 | £806 | £0 | £0 | £768 |
| Fish Feeder | 0% | £27 | £140 | £540 | £558 | £558 | £270 | £195 | £126 | £76 | £0 | £0 | £72 |
| Total Sales | £2,646 | £13,672 | £52,920 | £54,684 | £54,684 | £26,460 | £19,139 | £12,348 | £7,409 | £0 | £0 | £7,056 | |
| 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 | |
| Outside Concessions | £18 | £93 | £360 | £372 | £372 | £180 | £130 | £84 | £50 | £0 | £0 | £48 | |
| Inside Concessions | £66 | £342 | £1,323 | £1,367 | £1,367 | £662 | £478 | £309 | £185 | £0 | £0 | £176 | |
| Arcade Transactions | £144 | £744 | £2,880 | £2,976 | £2,976 | £1,440 | £1,042 | £672 | £403 | £0 | £0 | £384 | |
| Fish Feeder | £5 | £28 | £108 | £112 | £112 | £54 | £39 | £25 | £15 | £0 | £0 | £14 | |
| Subtotal Direct Cost of Sales | £233 | £1,207 | £4,671 | £4,827 | £4,827 | £2,336 | £1,689 | £1,090 | £653 | £0 | £0 | £622 | |
| 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 | ||
| Manager | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £0 | £0 | £2,500 |
| Asst. Manager | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £0 | £0 | £1,500 |
| Part time staff (1.5 FTE) | 0% | £700 | £1,500 | £3,000 | £3,000 | £3,000 | £1,500 | £1,000 | £750 | £500 | £0 | £0 | £500 |
| Owners (1 FTE) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 0 | 5 | |
| Total Payroll | £4,700 | £5,500 | £7,000 | £7,000 | £7,000 | £5,500 | £5,000 | £4,750 | £4,500 | £0 | £0 | £4,500 | |
| 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 | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| 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 | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | |
| 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 | £2,646 | £13,672 | £52,920 | £54,684 | £54,684 | £26,460 | £19,139 | £12,348 | £7,409 | £0 | £0 | £7,056 | |
| Direct Cost of Sales | £233 | £1,207 | £4,671 | £4,827 | £4,827 | £2,336 | £1,689 | £1,090 | £653 | £0 | £0 | £622 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £233 | £1,207 | £4,671 | £4,827 | £4,827 | £2,336 | £1,689 | £1,090 | £653 | £0 | £0 | £622 | |
| Gross Margin | £2,413 | £12,465 | £48,249 | £49,857 | £49,857 | £24,124 | £17,450 | £11,258 | £6,756 | £0 | £0 | £6,434 | |
| Gross Margin % | 91.19% | 91.17% | 91.17% | 91.17% | 91.17% | 91.17% | 91.18% | 91.17% | 91.19% | 0.00% | 0.00% | 91.18% | |
| Expenses | |||||||||||||
| Payroll | £4,700 | £5,500 | £7,000 | £7,000 | £7,000 | £5,500 | £5,000 | £4,750 | £4,500 | £0 | £0 | £4,500 | |
| Sales and Marketing and Other Expenses | £1,200 | £1,200 | £3,150 | £650 | £650 | £650 | £150 | £150 | £150 | £150 | £150 | £1,000 | |
| Depreciation | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | |
| Land Lease | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | |
| Utilities | £1,000 | £1,250 | £1,500 | £1,500 | £1,500 | £1,500 | £1,250 | £1,750 | £2,250 | £150 | £150 | £1,750 | |
| Insurance | £2,500 | £0 | £0 | £2,500 | £0 | £0 | £2,500 | £0 | £0 | £2,500 | £0 | £0 | |
| Payroll Taxes | 12% | £564 | £660 | £840 | £840 | £840 | £660 | £600 | £570 | £540 | £0 | £0 | £540 |
| Acctg & Legal | £500 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £0 | £0 | £250 | |
| Operating Supplies | £26 | £137 | £529 | £547 | £547 | £265 | £191 | £123 | £74 | £0 | £0 | £71 | |
| Telephone | 15% | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 |
| Continuing Education | £0 | £0 | £0 | £0 | £0 | £8,500 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £16,110 | £14,617 | £18,889 | £18,907 | £16,407 | £22,945 | £15,561 | £13,213 | £13,384 | £8,420 | £5,920 | £13,731 | |
| Profit Before Interest and Taxes | (£13,697) | (£2,152) | £29,360 | £30,950 | £33,450 | £1,179 | £1,889 | (£1,955) | (£6,628) | (£8,420) | (£5,920) | (£7,297) | |
| EBITDA | (£10,977) | £568 | £32,080 | £33,670 | £36,170 | £3,899 | £4,609 | £765 | (£3,908) | (£5,700) | (£3,200) | (£4,577) | |
| Interest Expense | £3,727 | £3,721 | £3,714 | £3,708 | £3,701 | £3,695 | £3,688 | £3,681 | £3,675 | £3,668 | £3,661 | £3,654 | |
| Taxes Incurred | (£6,186) | (£2,085) | £9,104 | £9,671 | £10,561 | (£893) | (£639) | (£2,001) | (£3,658) | (£4,291) | (£3,401) | (£3,888) | |
| Net Profit | (£11,239) | (£3,788) | £16,541 | £17,571 | £19,188 | (£1,622) | (£1,161) | (£3,636) | (£6,645) | (£7,797) | (£6,180) | (£7,063) | |
| Net Profit/Sales | -424.75% | -27.70% | 31.26% | 32.13% | 35.09% | -6.13% | -6.06% | -29.44% | -89.69% | 0.00% | 0.00% | -100.10% | |
| 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 | £2,646 | £13,672 | £52,920 | £54,684 | £54,684 | £26,460 | £19,139 | £12,348 | £7,409 | £0 | £0 | £7,056 | |
| Subtotal Cash from Operations | £2,646 | £13,672 | £52,920 | £54,684 | £54,684 | £26,460 | £19,139 | £12,348 | £7,409 | £0 | £0 | £7,056 | |
| 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 | £2,646 | £13,672 | £52,920 | £54,684 | £54,684 | £26,460 | £19,139 | £12,348 | £7,409 | £0 | £0 | £7,056 | |
| 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,700 | £5,500 | £7,000 | £7,000 | £7,000 | £5,500 | £5,000 | £4,750 | £4,500 | £0 | £0 | £4,500 | |
| Bill Payments | £215 | £6,557 | £9,820 | £26,683 | £27,339 | £25,579 | £19,620 | £12,444 | £8,458 | £6,776 | £5,023 | £3,575 | |
| Subtotal Spent on Operations | £4,915 | £12,057 | £16,820 | £33,683 | £34,339 | £31,079 | £24,620 | £17,194 | £12,958 | £6,776 | £5,023 | £8,075 | |
| 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 | £951 | £957 | £963 | £970 | £976 | £983 | £989 | £996 | £1,003 | £1,009 | £1,016 | £1,023 | |
| 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 | £5,866 | £13,014 | £17,784 | £34,653 | £35,315 | £32,062 | £25,609 | £18,190 | £13,960 | £7,785 | £6,039 | £9,097 | |
| Net Cash Flow | (£3,220) | £658 | £35,136 | £20,031 | £19,369 | (£5,602) | (£6,470) | (£5,842) | (£6,551) | (£7,785) | (£6,039) | (£2,041) | |
| Cash Balance | £10,549 | £11,206 | £46,343 | £66,374 | £85,743 | £80,141 | £73,671 | £67,829 | £61,277 | £53,492 | £47,453 | £45,412 | |
| 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 | £13,769 | £10,549 | £11,206 | £46,343 | £66,374 | £85,743 | £80,141 | £73,671 | £67,829 | £61,277 | £53,492 | £47,453 | £45,412 |
| Other Current Assets | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 |
| Total Current Assets | £36,999 | £33,779 | £34,436 | £69,573 | £89,604 | £108,973 | £103,371 | £96,901 | £91,059 | £84,507 | £76,722 | £70,683 | £68,642 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 |
| Accumulated Depreciation | £0 | £2,720 | £5,440 | £8,160 | £10,880 | £13,600 | £16,320 | £19,040 | £21,760 | £24,480 | £27,200 | £29,920 | £32,640 |
| Total Long-term Assets | £649,500 | £646,780 | £644,060 | £641,340 | £638,620 | £635,900 | £633,180 | £630,460 | £627,740 | £625,020 | £622,300 | £619,580 | £616,860 |
| Total Assets | £686,499 | £680,559 | £678,496 | £710,913 | £728,224 | £744,873 | £736,551 | £727,361 | £718,799 | £709,527 | £699,022 | £690,263 | £685,502 |
| 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 | £6,249 | £8,932 | £25,770 | £26,480 | £24,917 | £19,200 | £12,160 | £8,230 | £6,607 | £4,908 | £3,345 | £6,669 |
| 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 | £6,249 | £8,932 | £25,770 | £26,480 | £24,917 | £19,200 | £12,160 | £8,230 | £6,607 | £4,908 | £3,345 | £6,669 |
| Long-term Liabilities | £560,000 | £559,049 | £558,092 | £557,129 | £556,159 | £555,183 | £554,200 | £553,210 | £552,214 | £551,212 | £550,202 | £549,186 | £548,163 |
| Total Liabilities | £560,000 | £565,299 | £567,024 | £582,899 | £582,638 | £580,099 | £573,400 | £565,371 | £560,444 | £557,818 | £555,110 | £552,531 | £554,833 |
| Paid-in Capital | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 |
| Retained Earnings | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) |
| Earnings | £0 | (£11,239) | (£15,026) | £1,515 | £19,086 | £38,274 | £36,652 | £35,491 | £31,856 | £25,210 | £17,414 | £11,234 | £4,170 |
| Total Capital | £126,499 | £115,260 | £111,473 | £128,014 | £145,585 | £164,773 | £163,151 | £161,990 | £158,355 | £151,709 | £143,913 | £137,733 | £130,669 |
| Total Liabilities and Capital | £686,499 | £680,559 | £678,496 | £710,913 | £728,224 | £744,873 | £736,551 | £727,361 | £718,799 | £709,527 | £699,022 | £690,263 | £685,502 |
| Net Worth | £126,499 | £115,260 | £111,473 | £128,014 | £145,585 | £164,773 | £163,151 | £161,990 | £158,355 | £151,709 | £143,913 | £137,733 | £130,669 |
| 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 | |||||||||||||
| Miniature Golf | 0% | £1,800 | £9,300 | £36,000 | £37,200 | £37,200 | £18,000 | £13,020 | £8,400 | £5,040 | £0 | £0 | £4,800 |
| Climbing Wall | 0% | £270 | £1,395 | £5,400 | £5,580 | £5,580 | £2,700 | £1,953 | £1,260 | £756 | £0 | £0 | £720 |
| Outside Concessions | 0% | £72 | £372 | £1,440 | £1,488 | £1,488 | £720 | £521 | £336 | £202 | £0 | £0 | £192 |
| Inside Concessions | 0% | £189 | £977 | £3,780 | £3,906 | £3,906 | £1,890 | £1,367 | £882 | £529 | £0 | £0 | £504 |
| Arcade Transactions | 0% | £288 | £1,488 | £5,760 | £5,952 | £5,952 | £2,880 | £2,083 | £1,344 | £806 | £0 | £0 | £768 |
| Fish Feeder | 0% | £27 | £140 | £540 | £558 | £558 | £270 | £195 | £126 | £76 | £0 | £0 | £72 |
| Total Sales | £2,646 | £13,672 | £52,920 | £54,684 | £54,684 | £26,460 | £19,139 | £12,348 | £7,409 | £0 | £0 | £7,056 | |
| 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 | |
| Outside Concessions | £18 | £93 | £360 | £372 | £372 | £180 | £130 | £84 | £50 | £0 | £0 | £48 | |
| Inside Concessions | £66 | £342 | £1,323 | £1,367 | £1,367 | £662 | £478 | £309 | £185 | £0 | £0 | £176 | |
| Arcade Transactions | £144 | £744 | £2,880 | £2,976 | £2,976 | £1,440 | £1,042 | £672 | £403 | £0 | £0 | £384 | |
| Fish Feeder | £5 | £28 | £108 | £112 | £112 | £54 | £39 | £25 | £15 | £0 | £0 | £14 | |
| Subtotal Direct Cost of Sales | £233 | £1,207 | £4,671 | £4,827 | £4,827 | £2,336 | £1,689 | £1,090 | £653 | £0 | £0 | £622 | |
| 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 | ||
| Manager | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £0 | £0 | £2,500 |
| Asst. Manager | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £0 | £0 | £1,500 |
| Part time staff (1.5 FTE) | 0% | £700 | £1,500 | £3,000 | £3,000 | £3,000 | £1,500 | £1,000 | £750 | £500 | £0 | £0 | £500 |
| Owners (1 FTE) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 0 | 5 | |
| Total Payroll | £4,700 | £5,500 | £7,000 | £7,000 | £7,000 | £5,500 | £5,000 | £4,750 | £4,500 | £0 | £0 | £4,500 | |
| 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 | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| 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 | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | |
| 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 | £2,646 | £13,672 | £52,920 | £54,684 | £54,684 | £26,460 | £19,139 | £12,348 | £7,409 | £0 | £0 | £7,056 | |
| Direct Cost of Sales | £233 | £1,207 | £4,671 | £4,827 | £4,827 | £2,336 | £1,689 | £1,090 | £653 | £0 | £0 | £622 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £233 | £1,207 | £4,671 | £4,827 | £4,827 | £2,336 | £1,689 | £1,090 | £653 | £0 | £0 | £622 | |
| Gross Margin | £2,413 | £12,465 | £48,249 | £49,857 | £49,857 | £24,124 | £17,450 | £11,258 | £6,756 | £0 | £0 | £6,434 | |
| Gross Margin % | 91.19% | 91.17% | 91.17% | 91.17% | 91.17% | 91.17% | 91.18% | 91.17% | 91.19% | 0.00% | 0.00% | 91.18% | |
| Expenses | |||||||||||||
| Payroll | £4,700 | £5,500 | £7,000 | £7,000 | £7,000 | £5,500 | £5,000 | £4,750 | £4,500 | £0 | £0 | £4,500 | |
| Sales and Marketing and Other Expenses | £1,200 | £1,200 | £3,150 | £650 | £650 | £650 | £150 | £150 | £150 | £150 | £150 | £1,000 | |
| Depreciation | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | £2,720 | |
| Land Lease | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | |
| Utilities | £1,000 | £1,250 | £1,500 | £1,500 | £1,500 | £1,500 | £1,250 | £1,750 | £2,250 | £150 | £150 | £1,750 | |
| Insurance | £2,500 | £0 | £0 | £2,500 | £0 | £0 | £2,500 | £0 | £0 | £2,500 | £0 | £0 | |
| Payroll Taxes | 12% | £564 | £660 | £840 | £840 | £840 | £660 | £600 | £570 | £540 | £0 | £0 | £540 |
| Acctg & Legal | £500 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £0 | £0 | £250 | |
| Operating Supplies | £26 | £137 | £529 | £547 | £547 | £265 | £191 | £123 | £74 | £0 | £0 | £71 | |
| Telephone | 15% | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 |
| Continuing Education | £0 | £0 | £0 | £0 | £0 | £8,500 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £16,110 | £14,617 | £18,889 | £18,907 | £16,407 | £22,945 | £15,561 | £13,213 | £13,384 | £8,420 | £5,920 | £13,731 | |
| Profit Before Interest and Taxes | (£13,697) | (£2,152) | £29,360 | £30,950 | £33,450 | £1,179 | £1,889 | (£1,955) | (£6,628) | (£8,420) | (£5,920) | (£7,297) | |
| EBITDA | (£10,977) | £568 | £32,080 | £33,670 | £36,170 | £3,899 | £4,609 | £765 | (£3,908) | (£5,700) | (£3,200) | (£4,577) | |
| Interest Expense | £3,727 | £3,721 | £3,714 | £3,708 | £3,701 | £3,695 | £3,688 | £3,681 | £3,675 | £3,668 | £3,661 | £3,654 | |
| Taxes Incurred | (£6,186) | (£2,085) | £9,104 | £9,671 | £10,561 | (£893) | (£639) | (£2,001) | (£3,658) | (£4,291) | (£3,401) | (£3,888) | |
| Net Profit | (£11,239) | (£3,788) | £16,541 | £17,571 | £19,188 | (£1,622) | (£1,161) | (£3,636) | (£6,645) | (£7,797) | (£6,180) | (£7,063) | |
| Net Profit/Sales | -424.75% | -27.70% | 31.26% | 32.13% | 35.09% | -6.13% | -6.06% | -29.44% | -89.69% | 0.00% | 0.00% | -100.10% | |
| 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 | £2,646 | £13,672 | £52,920 | £54,684 | £54,684 | £26,460 | £19,139 | £12,348 | £7,409 | £0 | £0 | £7,056 | |
| Subtotal Cash from Operations | £2,646 | £13,672 | £52,920 | £54,684 | £54,684 | £26,460 | £19,139 | £12,348 | £7,409 | £0 | £0 | £7,056 | |
| 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 | £2,646 | £13,672 | £52,920 | £54,684 | £54,684 | £26,460 | £19,139 | £12,348 | £7,409 | £0 | £0 | £7,056 | |
| 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,700 | £5,500 | £7,000 | £7,000 | £7,000 | £5,500 | £5,000 | £4,750 | £4,500 | £0 | £0 | £4,500 | |
| Bill Payments | £215 | £6,557 | £9,820 | £26,683 | £27,339 | £25,579 | £19,620 | £12,444 | £8,458 | £6,776 | £5,023 | £3,575 | |
| Subtotal Spent on Operations | £4,915 | £12,057 | £16,820 | £33,683 | £34,339 | £31,079 | £24,620 | £17,194 | £12,958 | £6,776 | £5,023 | £8,075 | |
| 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 | £951 | £957 | £963 | £970 | £976 | £983 | £989 | £996 | £1,003 | £1,009 | £1,016 | £1,023 | |
| 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 | £5,866 | £13,014 | £17,784 | £34,653 | £35,315 | £32,062 | £25,609 | £18,190 | £13,960 | £7,785 | £6,039 | £9,097 | |
| Net Cash Flow | (£3,220) | £658 | £35,136 | £20,031 | £19,369 | (£5,602) | (£6,470) | (£5,842) | (£6,551) | (£7,785) | (£6,039) | (£2,041) | |
| Cash Balance | £10,549 | £11,206 | £46,343 | £66,374 | £85,743 | £80,141 | £73,671 | £67,829 | £61,277 | £53,492 | £47,453 | £45,412 | |
| 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 | £13,769 | £10,549 | £11,206 | £46,343 | £66,374 | £85,743 | £80,141 | £73,671 | £67,829 | £61,277 | £53,492 | £47,453 | £45,412 |
| Other Current Assets | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 | £23,230 |
| Total Current Assets | £36,999 | £33,779 | £34,436 | £69,573 | £89,604 | £108,973 | £103,371 | £96,901 | £91,059 | £84,507 | £76,722 | £70,683 | £68,642 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 | £649,500 |
| Accumulated Depreciation | £0 | £2,720 | £5,440 | £8,160 | £10,880 | £13,600 | £16,320 | £19,040 | £21,760 | £24,480 | £27,200 | £29,920 | £32,640 |
| Total Long-term Assets | £649,500 | £646,780 | £644,060 | £641,340 | £638,620 | £635,900 | £633,180 | £630,460 | £627,740 | £625,020 | £622,300 | £619,580 | £616,860 |
| Total Assets | £686,499 | £680,559 | £678,496 | £710,913 | £728,224 | £744,873 | £736,551 | £727,361 | £718,799 | £709,527 | £699,022 | £690,263 | £685,502 |
| 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 | £6,249 | £8,932 | £25,770 | £26,480 | £24,917 | £19,200 | £12,160 | £8,230 | £6,607 | £4,908 | £3,345 | £6,669 |
| 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 | £6,249 | £8,932 | £25,770 | £26,480 | £24,917 | £19,200 | £12,160 | £8,230 | £6,607 | £4,908 | £3,345 | £6,669 |
| Long-term Liabilities | £560,000 | £559,049 | £558,092 | £557,129 | £556,159 | £555,183 | £554,200 | £553,210 | £552,214 | £551,212 | £550,202 | £549,186 | £548,163 |
| Total Liabilities | £560,000 | £565,299 | £567,024 | £582,899 | £582,638 | £580,099 | £573,400 | £565,371 | £560,444 | £557,818 | £555,110 | £552,531 | £554,833 |
| Paid-in Capital | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 |
| Retained Earnings | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) | (£13,501) |
| Earnings | £0 | (£11,239) | (£15,026) | £1,515 | £19,086 | £38,274 | £36,652 | £35,491 | £31,856 | £25,210 | £17,414 | £11,234 | £4,170 |
| Total Capital | £126,499 | £115,260 | £111,473 | £128,014 | £145,585 | £164,773 | £163,151 | £161,990 | £158,355 | £151,709 | £143,913 | £137,733 | £130,669 |
| Total Liabilities and Capital | £686,499 | £680,559 | £678,496 | £710,913 | £728,224 | £744,873 | £736,551 | £727,361 | £718,799 | £709,527 | £699,022 | £690,263 | £685,502 |
| Net Worth | £126,499 | £115,260 | £111,473 | £128,014 | £145,585 | £164,773 | £163,151 | £161,990 | £158,355 | £151,709 | £143,913 | £137,733 | £130,669 |