| 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 | |||||||||||||
| Distributors | 0% | £0 | £0 | £0 | £0 | £9,500 | £14,500 | £18,500 | £21,000 | £23,500 | £28,000 | £30,050 | £31,050 |
| Health Clubs | 0% | £0 | £0 | £0 | £0 | £7,030 | £10,730 | £13,690 | £15,540 | £17,390 | £20,720 | £22,237 | £22,977 |
| Vertical Markets | 0% | £0 | £0 | £0 | £0 | £6,840 | £10,440 | £13,320 | £15,120 | £16,920 | £20,160 | £21,636 | £22,356 |
| Total Sales | £0 | £0 | £0 | £0 | £23,370 | £35,670 | £45,510 | £51,660 | £57,810 | £68,880 | £73,923 | £76,383 | |
| 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 | |
| Distributors | £0 | £0 | £0 | £0 | £6,080 | £9,280 | £11,840 | £13,440 | £15,040 | £17,920 | £19,232 | £19,872 | |
| Health Clubs | £0 | £0 | £0 | £0 | £4,780 | £7,296 | £9,309 | £10,567 | £11,825 | £14,090 | £15,121 | £15,624 | |
| Vertical Markets | £0 | £0 | £0 | £0 | £4,651 | £7,099 | £9,058 | £10,282 | £11,506 | £13,709 | £14,712 | £15,202 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £15,512 | £23,676 | £30,207 | £34,289 | £38,371 | £45,718 | £49,066 | £50,698 | |
| 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 | ||
| Max | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Support | 0% | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Support | 0% | £0 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Repair | 0% | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Sales | 0% | £0 | £0 | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Total People | 0 | 0 | 1 | 2 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £0 | £0 | £2,000 | £3,800 | £10,100 | £10,100 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| 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% | 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 | £0 | £0 | £0 | £0 | £23,370 | £35,670 | £45,510 | £51,660 | £57,810 | £68,880 | £73,923 | £76,383 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £15,512 | £23,676 | £30,207 | £34,289 | £38,371 | £45,718 | £49,066 | £50,698 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £15,512 | £23,676 | £30,207 | £34,289 | £38,371 | £45,718 | £49,066 | £50,698 | |
| Gross Margin | £0 | £0 | £0 | £0 | £7,858 | £11,994 | £15,303 | £17,371 | £19,439 | £23,162 | £24,857 | £25,685 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £2,000 | £3,800 | £10,100 | £10,100 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Depreciation | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Payroll Taxes | 15% | £0 | £0 | £300 | £570 | £1,515 | £1,515 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £1,650 | £1,650 | £3,950 | £9,520 | £16,765 | £16,765 | £19,640 | £19,640 | £19,640 | £19,640 | £19,640 | £19,640 | |
| Profit Before Interest and Taxes | (£1,650) | (£1,650) | (£3,950) | (£9,520) | (£8,907) | (£4,771) | (£4,337) | (£2,269) | (£201) | £3,522 | £5,217 | £6,045 | |
| EBITDA | (£1,400) | (£1,400) | (£3,700) | (£9,270) | (£8,657) | (£4,521) | (£4,087) | (£2,019) | £49 | £3,772 | £5,467 | £6,295 | |
| Interest Expense | £699 | £690 | £681 | £671 | £662 | £652 | £643 | £633 | £623 | £613 | £603 | £593 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£2,349) | (£2,340) | (£4,631) | (£10,191) | (£9,568) | (£5,423) | (£4,979) | (£2,902) | (£824) | £2,908 | £4,614 | £5,451 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | -40.94% | -15.20% | -10.94% | -5.62% | -1.43% | 4.22% | 6.24% | 7.14% | |
| 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 | £0 | £0 | £0 | £0 | £11,685 | £17,835 | £22,755 | £25,830 | £28,905 | £34,440 | £36,962 | £38,192 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £0 | £390 | £11,890 | £17,999 | £22,858 | £25,933 | £29,090 | £34,524 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £11,685 | £18,225 | £34,645 | £43,829 | £51,763 | £60,373 | £66,051 | £72,716 | |
| 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 | £0 | £0 | £0 | £0 | £11,685 | £18,225 | £34,645 | £43,829 | £51,763 | £60,373 | £66,051 | £72,716 | |
| 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 | £0 | £0 | £2,000 | £3,800 | £10,100 | £10,100 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| Bill Payments | £70 | £2,099 | £2,100 | £2,506 | £6,948 | £30,494 | £35,028 | £41,000 | £43,889 | £48,124 | £56,840 | £58,158 | |
| Subtotal Spent on Operations | £70 | £2,099 | £4,100 | £6,306 | £17,048 | £40,594 | £47,628 | £53,600 | £56,489 | £60,724 | £69,440 | £70,758 | |
| 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,098 | £1,107 | £1,116 | £1,125 | £1,135 | £1,144 | £1,154 | £1,163 | £1,173 | £1,183 | £1,193 | £1,203 | |
| 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 | £1,168 | £3,206 | £5,216 | £7,431 | £18,183 | £41,738 | £48,781 | £54,763 | £57,662 | £61,907 | £70,633 | £71,961 | |
| Net Cash Flow | (£1,168) | (£3,206) | (£5,216) | (£7,431) | (£6,498) | (£23,513) | (£14,136) | (£10,934) | (£5,899) | (£1,534) | (£4,582) | £755 | |
| Cash Balance | £165,932 | £162,727 | £157,511 | £150,080 | £143,582 | £120,069 | £105,932 | £94,998 | £89,099 | £87,565 | £82,983 | £83,738 | |
| 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 | £167,100 | £165,932 | £162,727 | £157,511 | £150,080 | £143,582 | £120,069 | £105,932 | £94,998 | £89,099 | £87,565 | £82,983 | £83,738 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £11,685 | £29,131 | £39,996 | £47,827 | £53,874 | £62,382 | £70,254 | £73,921 |
| Inventory | £0 | £0 | £0 | £0 | £0 | £7,756 | £11,838 | £15,103 | £17,144 | £19,185 | £22,859 | £24,533 | £25,349 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £167,100 | £165,932 | £162,727 | £157,511 | £150,080 | £163,023 | £161,037 | £161,031 | £159,969 | £162,158 | £172,805 | £177,769 | £183,008 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Accumulated Depreciation | £0 | £250 | £500 | £750 | £1,000 | £1,250 | £1,500 | £1,750 | £2,000 | £2,250 | £2,500 | £2,750 | £3,000 |
| Total Long-term Assets | £15,000 | £14,750 | £14,500 | £14,250 | £14,000 | £13,750 | £13,500 | £13,250 | £13,000 | £12,750 | £12,500 | £12,250 | £12,000 |
| Total Assets | £182,100 | £180,682 | £177,227 | £171,761 | £164,080 | £176,773 | £174,537 | £174,281 | £172,969 | £174,908 | £185,305 | £190,019 | £195,008 |
| 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,029 | £2,020 | £2,301 | £5,937 | £29,333 | £33,664 | £39,542 | £42,294 | £46,231 | £54,902 | £56,195 | £56,935 |
| 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,029 | £2,020 | £2,301 | £5,937 | £29,333 | £33,664 | £39,542 | £42,294 | £46,231 | £54,902 | £56,195 | £56,935 |
| Long-term Liabilities | £85,000 | £83,902 | £82,796 | £81,679 | £80,554 | £79,419 | £78,275 | £77,122 | £75,958 | £74,785 | £73,602 | £72,410 | £71,207 |
| Total Liabilities | £85,000 | £85,932 | £84,816 | £83,981 | £86,491 | £108,752 | £111,939 | £116,663 | £118,253 | £121,016 | £128,505 | £128,605 | £128,142 |
| Paid-in Capital | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 |
| Retained Earnings | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) |
| Earnings | £0 | (£2,349) | (£4,689) | (£9,320) | (£19,511) | (£29,080) | (£34,502) | (£39,482) | (£42,384) | (£43,208) | (£40,299) | (£35,686) | (£30,234) |
| Total Capital | £97,100 | £94,751 | £92,411 | £87,780 | £77,589 | £68,020 | £62,598 | £57,618 | £54,716 | £53,892 | £56,801 | £61,414 | £66,866 |
| Total Liabilities and Capital | £182,100 | £180,682 | £177,227 | £171,761 | £164,080 | £176,773 | £174,537 | £174,281 | £172,969 | £174,908 | £185,305 | £190,019 | £195,008 |
| Net Worth | £97,100 | £94,751 | £92,411 | £87,780 | £77,589 | £68,020 | £62,598 | £57,618 | £54,716 | £53,892 | £56,801 | £61,414 | £66,866 |
| 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 | |||||||||||||
| Distributors | 0% | £0 | £0 | £0 | £0 | £9,500 | £14,500 | £18,500 | £21,000 | £23,500 | £28,000 | £30,050 | £31,050 |
| Health Clubs | 0% | £0 | £0 | £0 | £0 | £7,030 | £10,730 | £13,690 | £15,540 | £17,390 | £20,720 | £22,237 | £22,977 |
| Vertical Markets | 0% | £0 | £0 | £0 | £0 | £6,840 | £10,440 | £13,320 | £15,120 | £16,920 | £20,160 | £21,636 | £22,356 |
| Total Sales | £0 | £0 | £0 | £0 | £23,370 | £35,670 | £45,510 | £51,660 | £57,810 | £68,880 | £73,923 | £76,383 | |
| 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 | |
| Distributors | £0 | £0 | £0 | £0 | £6,080 | £9,280 | £11,840 | £13,440 | £15,040 | £17,920 | £19,232 | £19,872 | |
| Health Clubs | £0 | £0 | £0 | £0 | £4,780 | £7,296 | £9,309 | £10,567 | £11,825 | £14,090 | £15,121 | £15,624 | |
| Vertical Markets | £0 | £0 | £0 | £0 | £4,651 | £7,099 | £9,058 | £10,282 | £11,506 | £13,709 | £14,712 | £15,202 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £15,512 | £23,676 | £30,207 | £34,289 | £38,371 | £45,718 | £49,066 | £50,698 | |
| 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 | ||
| Max | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Support | 0% | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Support | 0% | £0 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Repair | 0% | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Sales | 0% | £0 | £0 | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Total People | 0 | 0 | 1 | 2 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £0 | £0 | £2,000 | £3,800 | £10,100 | £10,100 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| 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% | 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 | £0 | £0 | £0 | £0 | £23,370 | £35,670 | £45,510 | £51,660 | £57,810 | £68,880 | £73,923 | £76,383 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £15,512 | £23,676 | £30,207 | £34,289 | £38,371 | £45,718 | £49,066 | £50,698 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £15,512 | £23,676 | £30,207 | £34,289 | £38,371 | £45,718 | £49,066 | £50,698 | |
| Gross Margin | £0 | £0 | £0 | £0 | £7,858 | £11,994 | £15,303 | £17,371 | £19,439 | £23,162 | £24,857 | £25,685 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £2,000 | £3,800 | £10,100 | £10,100 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Depreciation | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Payroll Taxes | 15% | £0 | £0 | £300 | £570 | £1,515 | £1,515 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £1,650 | £1,650 | £3,950 | £9,520 | £16,765 | £16,765 | £19,640 | £19,640 | £19,640 | £19,640 | £19,640 | £19,640 | |
| Profit Before Interest and Taxes | (£1,650) | (£1,650) | (£3,950) | (£9,520) | (£8,907) | (£4,771) | (£4,337) | (£2,269) | (£201) | £3,522 | £5,217 | £6,045 | |
| EBITDA | (£1,400) | (£1,400) | (£3,700) | (£9,270) | (£8,657) | (£4,521) | (£4,087) | (£2,019) | £49 | £3,772 | £5,467 | £6,295 | |
| Interest Expense | £699 | £690 | £681 | £671 | £662 | £652 | £643 | £633 | £623 | £613 | £603 | £593 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£2,349) | (£2,340) | (£4,631) | (£10,191) | (£9,568) | (£5,423) | (£4,979) | (£2,902) | (£824) | £2,908 | £4,614 | £5,451 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | -40.94% | -15.20% | -10.94% | -5.62% | -1.43% | 4.22% | 6.24% | 7.14% | |
| 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 | £0 | £0 | £0 | £0 | £11,685 | £17,835 | £22,755 | £25,830 | £28,905 | £34,440 | £36,962 | £38,192 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £0 | £390 | £11,890 | £17,999 | £22,858 | £25,933 | £29,090 | £34,524 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £11,685 | £18,225 | £34,645 | £43,829 | £51,763 | £60,373 | £66,051 | £72,716 | |
| 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 | £0 | £0 | £0 | £0 | £11,685 | £18,225 | £34,645 | £43,829 | £51,763 | £60,373 | £66,051 | £72,716 | |
| 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 | £0 | £0 | £2,000 | £3,800 | £10,100 | £10,100 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| Bill Payments | £70 | £2,099 | £2,100 | £2,506 | £6,948 | £30,494 | £35,028 | £41,000 | £43,889 | £48,124 | £56,840 | £58,158 | |
| Subtotal Spent on Operations | £70 | £2,099 | £4,100 | £6,306 | £17,048 | £40,594 | £47,628 | £53,600 | £56,489 | £60,724 | £69,440 | £70,758 | |
| 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,098 | £1,107 | £1,116 | £1,125 | £1,135 | £1,144 | £1,154 | £1,163 | £1,173 | £1,183 | £1,193 | £1,203 | |
| 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 | £1,168 | £3,206 | £5,216 | £7,431 | £18,183 | £41,738 | £48,781 | £54,763 | £57,662 | £61,907 | £70,633 | £71,961 | |
| Net Cash Flow | (£1,168) | (£3,206) | (£5,216) | (£7,431) | (£6,498) | (£23,513) | (£14,136) | (£10,934) | (£5,899) | (£1,534) | (£4,582) | £755 | |
| Cash Balance | £165,932 | £162,727 | £157,511 | £150,080 | £143,582 | £120,069 | £105,932 | £94,998 | £89,099 | £87,565 | £82,983 | £83,738 | |
| 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 | £167,100 | £165,932 | £162,727 | £157,511 | £150,080 | £143,582 | £120,069 | £105,932 | £94,998 | £89,099 | £87,565 | £82,983 | £83,738 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £11,685 | £29,131 | £39,996 | £47,827 | £53,874 | £62,382 | £70,254 | £73,921 |
| Inventory | £0 | £0 | £0 | £0 | £0 | £7,756 | £11,838 | £15,103 | £17,144 | £19,185 | £22,859 | £24,533 | £25,349 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £167,100 | £165,932 | £162,727 | £157,511 | £150,080 | £163,023 | £161,037 | £161,031 | £159,969 | £162,158 | £172,805 | £177,769 | £183,008 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Accumulated Depreciation | £0 | £250 | £500 | £750 | £1,000 | £1,250 | £1,500 | £1,750 | £2,000 | £2,250 | £2,500 | £2,750 | £3,000 |
| Total Long-term Assets | £15,000 | £14,750 | £14,500 | £14,250 | £14,000 | £13,750 | £13,500 | £13,250 | £13,000 | £12,750 | £12,500 | £12,250 | £12,000 |
| Total Assets | £182,100 | £180,682 | £177,227 | £171,761 | £164,080 | £176,773 | £174,537 | £174,281 | £172,969 | £174,908 | £185,305 | £190,019 | £195,008 |
| 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,029 | £2,020 | £2,301 | £5,937 | £29,333 | £33,664 | £39,542 | £42,294 | £46,231 | £54,902 | £56,195 | £56,935 |
| 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,029 | £2,020 | £2,301 | £5,937 | £29,333 | £33,664 | £39,542 | £42,294 | £46,231 | £54,902 | £56,195 | £56,935 |
| Long-term Liabilities | £85,000 | £83,902 | £82,796 | £81,679 | £80,554 | £79,419 | £78,275 | £77,122 | £75,958 | £74,785 | £73,602 | £72,410 | £71,207 |
| Total Liabilities | £85,000 | £85,932 | £84,816 | £83,981 | £86,491 | £108,752 | £111,939 | £116,663 | £118,253 | £121,016 | £128,505 | £128,605 | £128,142 |
| Paid-in Capital | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 |
| Retained Earnings | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) |
| Earnings | £0 | (£2,349) | (£4,689) | (£9,320) | (£19,511) | (£29,080) | (£34,502) | (£39,482) | (£42,384) | (£43,208) | (£40,299) | (£35,686) | (£30,234) |
| Total Capital | £97,100 | £94,751 | £92,411 | £87,780 | £77,589 | £68,020 | £62,598 | £57,618 | £54,716 | £53,892 | £56,801 | £61,414 | £66,866 |
| Total Liabilities and Capital | £182,100 | £180,682 | £177,227 | £171,761 | £164,080 | £176,773 | £174,537 | £174,281 | £172,969 | £174,908 | £185,305 | £190,019 | £195,008 |
| Net Worth | £97,100 | £94,751 | £92,411 | £87,780 | £77,589 | £68,020 | £62,598 | £57,618 | £54,716 | £53,892 | £56,801 | £61,414 | £66,866 |