| 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 | |||||||||||||
| General dentistry | 0% | £0 | £3,500 | £3,800 | £4,454 | £5,142 | £5,334 | £5,565 | £5,645 | £6,001 | £6,224 | £6,343 | £6,543 |
| Cosmetics | 0% | £0 | £0 | £0 | £4,500 | £5,232 | £8,876 | £9,876 | £11,746 | £14,545 | £17,656 | £21,345 | £24,545 |
| Total Sales | £0 | £3,500 | £3,800 | £8,954 | £10,374 | £14,210 | £15,441 | £17,391 | £20,546 | £23,880 | £27,688 | £31,088 | |
| 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 | |
| General dentistry | £0 | £2,100 | £2,280 | £2,672 | £3,085 | £3,200 | £3,339 | £3,387 | £3,601 | £3,734 | £3,806 | £3,926 | |
| Cosmetics | £0 | £0 | £0 | £855 | £994 | £1,686 | £1,876 | £2,232 | £2,764 | £3,355 | £4,056 | £4,664 | |
| Subtotal Direct Cost of Sales | £0 | £2,100 | £2,280 | £3,527 | £4,079 | £4,887 | £5,215 | £5,619 | £6,364 | £7,089 | £7,861 | £8,589 | |
| 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 | ||
| Steve | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Hygienist | 0% | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Assistant | 0% | £0 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Front desk person | 0% | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total People | 1 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £4,000 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | |
| 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 | £3,500 | £3,800 | £8,954 | £10,374 | £14,210 | £15,441 | £17,391 | £20,546 | £23,880 | £27,688 | £31,088 | |
| Direct Cost of Sales | £0 | £2,100 | £2,280 | £3,527 | £4,079 | £4,887 | £5,215 | £5,619 | £6,364 | £7,089 | £7,861 | £8,589 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £2,100 | £2,280 | £3,527 | £4,079 | £4,887 | £5,215 | £5,619 | £6,364 | £7,089 | £7,861 | £8,589 | |
| Gross Margin | £0 | £1,400 | £1,520 | £5,427 | £6,295 | £9,323 | £10,226 | £11,772 | £14,182 | £16,791 | £19,827 | £22,499 | |
| Gross Margin % | 0.00% | 40.00% | 40.00% | 60.61% | 60.68% | 65.61% | 66.22% | 67.69% | 69.02% | 70.31% | 71.61% | 72.37% | |
| Expenses | |||||||||||||
| Payroll | £4,000 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | |
| Sales and Marketing and Other Expenses | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | |
| Depreciation | £863 | £863 | £863 | £863 | £863 | £863 | £863 | £863 | £863 | £863 | £863 | £863 | |
| ADA dues | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance- office and malpractice | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Payroll Taxes | 15% | £600 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £7,788 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | |
| Profit Before Interest and Taxes | (£7,788) | (£14,093) | (£13,973) | (£10,066) | (£9,198) | (£6,170) | (£5,267) | (£3,721) | (£1,311) | £1,298 | £4,334 | £7,006 | |
| EBITDA | (£6,925) | (£13,230) | (£13,110) | (£9,203) | (£8,335) | (£5,307) | (£4,404) | (£2,858) | (£448) | £2,161 | £5,197 | £7,869 | |
| Interest Expense | £829 | £825 | £821 | £817 | £812 | £808 | £804 | £800 | £795 | £791 | £786 | £782 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£8,617) | (£14,918) | (£14,794) | (£10,883) | (£10,011) | (£6,978) | (£6,071) | (£4,520) | (£2,106) | £507 | £3,547 | £6,224 | |
| Net Profit/Sales | 0.00% | -426.23% | -389.31% | -121.54% | -96.50% | -49.11% | -39.32% | -25.99% | -10.25% | 2.12% | 12.81% | 20.02% | |
| 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 | £3,500 | £3,800 | £8,954 | £10,374 | £14,210 | £15,441 | £17,391 | £20,546 | £23,880 | £27,688 | £31,088 | |
| Subtotal Cash from Operations | £0 | £3,500 | £3,800 | £8,954 | £10,374 | £14,210 | £15,441 | £17,391 | £20,546 | £23,880 | £27,688 | £31,088 | |
| 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 | £3,500 | £3,800 | £8,954 | £10,374 | £14,210 | £15,441 | £17,391 | £20,546 | £23,880 | £27,688 | £31,088 | |
| 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,000 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | |
| Bill Payments | £125 | £3,858 | £6,861 | £7,072 | £8,292 | £8,849 | £9,636 | £9,963 | £10,373 | £11,113 | £11,835 | £12,602 | |
| Subtotal Spent on Operations | £4,125 | £14,558 | £17,561 | £17,772 | £18,992 | £19,549 | £20,336 | £20,663 | £21,073 | £21,813 | £22,535 | £23,302 | |
| 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 | £492 | £496 | £500 | £505 | £509 | £513 | £517 | £522 | £526 | £530 | £535 | £539 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £4,617 | £15,054 | £18,061 | £18,277 | £19,501 | £20,062 | £20,853 | £21,184 | £21,599 | £22,344 | £23,070 | £23,841 | |
| Net Cash Flow | (£4,617) | (£11,554) | (£14,261) | (£9,323) | (£9,127) | (£5,852) | (£5,412) | (£3,793) | (£1,053) | £1,536 | £4,618 | £7,247 | |
| Cash Balance | £63,483 | £51,929 | £37,667 | £28,344 | £19,217 | £13,365 | £7,953 | £4,160 | £3,107 | £4,643 | £9,261 | £16,508 | |
| 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 | £68,100 | £63,483 | £51,929 | £37,667 | £28,344 | £19,217 | £13,365 | £7,953 | £4,160 | £3,107 | £4,643 | £9,261 | £16,508 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £68,100 | £63,483 | £51,929 | £37,667 | £28,344 | £19,217 | £13,365 | £7,953 | £4,160 | £3,107 | £4,643 | £9,261 | £16,508 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 |
| Accumulated Depreciation | £0 | £863 | £1,726 | £2,589 | £3,452 | £4,315 | £5,178 | £6,041 | £6,904 | £7,767 | £8,630 | £9,493 | £10,356 |
| Total Long-term Assets | £51,800 | £50,937 | £50,074 | £49,211 | £48,348 | £47,485 | £46,622 | £45,759 | £44,896 | £44,033 | £43,170 | £42,307 | £41,444 |
| Total Assets | £119,900 | £114,420 | £102,003 | £86,878 | £76,692 | £66,702 | £59,987 | £53,712 | £49,056 | £47,140 | £47,813 | £51,568 | £57,952 |
| 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,629 | £6,627 | £6,797 | £7,998 | £8,528 | £9,304 | £9,618 | £10,003 | £10,720 | £11,416 | £12,158 | £12,858 |
| 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 | £3,629 | £6,627 | £6,797 | £7,998 | £8,528 | £9,304 | £9,618 | £10,003 | £10,720 | £11,416 | £12,158 | £12,858 |
| Long-term Liabilities | £100,000 | £99,508 | £99,011 | £98,511 | £98,006 | £97,497 | £96,984 | £96,467 | £95,945 | £95,419 | £94,889 | £94,354 | £93,815 |
| Total Liabilities | £100,000 | £103,137 | £105,638 | £105,307 | £106,005 | £106,025 | £106,289 | £106,085 | £105,949 | £106,139 | £106,305 | £106,512 | £106,672 |
| Paid-in Capital | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 |
| Retained Earnings | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) |
| Earnings | £0 | (£8,617) | (£23,535) | (£38,329) | (£49,212) | (£59,223) | (£66,201) | (£72,273) | (£76,793) | (£78,899) | (£78,392) | (£74,845) | (£68,621) |
| Total Capital | £19,900 | £11,283 | (£3,635) | (£18,429) | (£29,312) | (£39,323) | (£46,301) | (£52,373) | (£56,893) | (£58,999) | (£58,492) | (£54,945) | (£48,721) |
| Total Liabilities and Capital | £119,900 | £114,420 | £102,003 | £86,878 | £76,692 | £66,702 | £59,987 | £53,712 | £49,056 | £47,140 | £47,813 | £51,568 | £57,952 |
| Net Worth | £19,900 | £11,283 | (£3,635) | (£18,429) | (£29,312) | (£39,323) | (£46,301) | (£52,373) | (£56,893) | (£58,999) | (£58,492) | (£54,945) | (£48,721) |
| 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 | |||||||||||||
| General dentistry | 0% | £0 | £3,500 | £3,800 | £4,454 | £5,142 | £5,334 | £5,565 | £5,645 | £6,001 | £6,224 | £6,343 | £6,543 |
| Cosmetics | 0% | £0 | £0 | £0 | £4,500 | £5,232 | £8,876 | £9,876 | £11,746 | £14,545 | £17,656 | £21,345 | £24,545 |
| Total Sales | £0 | £3,500 | £3,800 | £8,954 | £10,374 | £14,210 | £15,441 | £17,391 | £20,546 | £23,880 | £27,688 | £31,088 | |
| 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 | |
| General dentistry | £0 | £2,100 | £2,280 | £2,672 | £3,085 | £3,200 | £3,339 | £3,387 | £3,601 | £3,734 | £3,806 | £3,926 | |
| Cosmetics | £0 | £0 | £0 | £855 | £994 | £1,686 | £1,876 | £2,232 | £2,764 | £3,355 | £4,056 | £4,664 | |
| Subtotal Direct Cost of Sales | £0 | £2,100 | £2,280 | £3,527 | £4,079 | £4,887 | £5,215 | £5,619 | £6,364 | £7,089 | £7,861 | £8,589 | |
| 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 | ||
| Steve | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Hygienist | 0% | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Assistant | 0% | £0 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Front desk person | 0% | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total People | 1 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £4,000 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | |
| 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 | £3,500 | £3,800 | £8,954 | £10,374 | £14,210 | £15,441 | £17,391 | £20,546 | £23,880 | £27,688 | £31,088 | |
| Direct Cost of Sales | £0 | £2,100 | £2,280 | £3,527 | £4,079 | £4,887 | £5,215 | £5,619 | £6,364 | £7,089 | £7,861 | £8,589 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £2,100 | £2,280 | £3,527 | £4,079 | £4,887 | £5,215 | £5,619 | £6,364 | £7,089 | £7,861 | £8,589 | |
| Gross Margin | £0 | £1,400 | £1,520 | £5,427 | £6,295 | £9,323 | £10,226 | £11,772 | £14,182 | £16,791 | £19,827 | £22,499 | |
| Gross Margin % | 0.00% | 40.00% | 40.00% | 60.61% | 60.68% | 65.61% | 66.22% | 67.69% | 69.02% | 70.31% | 71.61% | 72.37% | |
| Expenses | |||||||||||||
| Payroll | £4,000 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | |
| Sales and Marketing and Other Expenses | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | |
| Depreciation | £863 | £863 | £863 | £863 | £863 | £863 | £863 | £863 | £863 | £863 | £863 | £863 | |
| ADA dues | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance- office and malpractice | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Payroll Taxes | 15% | £600 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 | £1,605 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £7,788 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | £15,493 | |
| Profit Before Interest and Taxes | (£7,788) | (£14,093) | (£13,973) | (£10,066) | (£9,198) | (£6,170) | (£5,267) | (£3,721) | (£1,311) | £1,298 | £4,334 | £7,006 | |
| EBITDA | (£6,925) | (£13,230) | (£13,110) | (£9,203) | (£8,335) | (£5,307) | (£4,404) | (£2,858) | (£448) | £2,161 | £5,197 | £7,869 | |
| Interest Expense | £829 | £825 | £821 | £817 | £812 | £808 | £804 | £800 | £795 | £791 | £786 | £782 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£8,617) | (£14,918) | (£14,794) | (£10,883) | (£10,011) | (£6,978) | (£6,071) | (£4,520) | (£2,106) | £507 | £3,547 | £6,224 | |
| Net Profit/Sales | 0.00% | -426.23% | -389.31% | -121.54% | -96.50% | -49.11% | -39.32% | -25.99% | -10.25% | 2.12% | 12.81% | 20.02% | |
| 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 | £3,500 | £3,800 | £8,954 | £10,374 | £14,210 | £15,441 | £17,391 | £20,546 | £23,880 | £27,688 | £31,088 | |
| Subtotal Cash from Operations | £0 | £3,500 | £3,800 | £8,954 | £10,374 | £14,210 | £15,441 | £17,391 | £20,546 | £23,880 | £27,688 | £31,088 | |
| 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 | £3,500 | £3,800 | £8,954 | £10,374 | £14,210 | £15,441 | £17,391 | £20,546 | £23,880 | £27,688 | £31,088 | |
| 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,000 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | £10,700 | |
| Bill Payments | £125 | £3,858 | £6,861 | £7,072 | £8,292 | £8,849 | £9,636 | £9,963 | £10,373 | £11,113 | £11,835 | £12,602 | |
| Subtotal Spent on Operations | £4,125 | £14,558 | £17,561 | £17,772 | £18,992 | £19,549 | £20,336 | £20,663 | £21,073 | £21,813 | £22,535 | £23,302 | |
| 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 | £492 | £496 | £500 | £505 | £509 | £513 | £517 | £522 | £526 | £530 | £535 | £539 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £4,617 | £15,054 | £18,061 | £18,277 | £19,501 | £20,062 | £20,853 | £21,184 | £21,599 | £22,344 | £23,070 | £23,841 | |
| Net Cash Flow | (£4,617) | (£11,554) | (£14,261) | (£9,323) | (£9,127) | (£5,852) | (£5,412) | (£3,793) | (£1,053) | £1,536 | £4,618 | £7,247 | |
| Cash Balance | £63,483 | £51,929 | £37,667 | £28,344 | £19,217 | £13,365 | £7,953 | £4,160 | £3,107 | £4,643 | £9,261 | £16,508 | |
| 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 | £68,100 | £63,483 | £51,929 | £37,667 | £28,344 | £19,217 | £13,365 | £7,953 | £4,160 | £3,107 | £4,643 | £9,261 | £16,508 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £68,100 | £63,483 | £51,929 | £37,667 | £28,344 | £19,217 | £13,365 | £7,953 | £4,160 | £3,107 | £4,643 | £9,261 | £16,508 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 | £51,800 |
| Accumulated Depreciation | £0 | £863 | £1,726 | £2,589 | £3,452 | £4,315 | £5,178 | £6,041 | £6,904 | £7,767 | £8,630 | £9,493 | £10,356 |
| Total Long-term Assets | £51,800 | £50,937 | £50,074 | £49,211 | £48,348 | £47,485 | £46,622 | £45,759 | £44,896 | £44,033 | £43,170 | £42,307 | £41,444 |
| Total Assets | £119,900 | £114,420 | £102,003 | £86,878 | £76,692 | £66,702 | £59,987 | £53,712 | £49,056 | £47,140 | £47,813 | £51,568 | £57,952 |
| 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,629 | £6,627 | £6,797 | £7,998 | £8,528 | £9,304 | £9,618 | £10,003 | £10,720 | £11,416 | £12,158 | £12,858 |
| 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 | £3,629 | £6,627 | £6,797 | £7,998 | £8,528 | £9,304 | £9,618 | £10,003 | £10,720 | £11,416 | £12,158 | £12,858 |
| Long-term Liabilities | £100,000 | £99,508 | £99,011 | £98,511 | £98,006 | £97,497 | £96,984 | £96,467 | £95,945 | £95,419 | £94,889 | £94,354 | £93,815 |
| Total Liabilities | £100,000 | £103,137 | £105,638 | £105,307 | £106,005 | £106,025 | £106,289 | £106,085 | £105,949 | £106,139 | £106,305 | £106,512 | £106,672 |
| Paid-in Capital | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 | £51,000 |
| Retained Earnings | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) | (£31,100) |
| Earnings | £0 | (£8,617) | (£23,535) | (£38,329) | (£49,212) | (£59,223) | (£66,201) | (£72,273) | (£76,793) | (£78,899) | (£78,392) | (£74,845) | (£68,621) |
| Total Capital | £19,900 | £11,283 | (£3,635) | (£18,429) | (£29,312) | (£39,323) | (£46,301) | (£52,373) | (£56,893) | (£58,999) | (£58,492) | (£54,945) | (£48,721) |
| Total Liabilities and Capital | £119,900 | £114,420 | £102,003 | £86,878 | £76,692 | £66,702 | £59,987 | £53,712 | £49,056 | £47,140 | £47,813 | £51,568 | £57,952 |
| Net Worth | £19,900 | £11,283 | (£3,635) | (£18,429) | (£29,312) | (£39,323) | (£46,301) | (£52,373) | (£56,893) | (£58,999) | (£58,492) | (£54,945) | (£48,721) |