| 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 | |||||||||||||
| Professional building physicians | 0% | £0 | £2,500 | £3,565 | £4,245 | £4,989 | £5,353 | £5,978 | £6,874 | £8,989 | £10,225 | £13,545 | £15,515 |
| Nearby physicians | 0% | £0 | £500 | £713 | £849 | £998 | £1,071 | £1,196 | £1,375 | £1,798 | £2,045 | £2,709 | £3,103 |
| Total Sales | £0 | £3,000 | £4,278 | £5,094 | £5,987 | £6,424 | £7,174 | £8,249 | £10,787 | £12,270 | £16,254 | £18,618 | |
| 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 | |
| Professional building physicians | £0 | £875 | £1,248 | £1,486 | £1,746 | £1,874 | £2,092 | £2,406 | £3,146 | £3,579 | £4,741 | £5,430 | |
| Nearby physicians | £0 | £175 | £250 | £297 | £349 | £375 | £418 | £481 | £629 | £716 | £948 | £1,086 | |
| Subtotal Direct Cost of Sales | £0 | £1,050 | £1,497 | £1,783 | £2,095 | £2,248 | £2,511 | £2,887 | £3,775 | £4,295 | £5,689 | £6,516 | |
| 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 | ||
| Dave | 0% | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Phlebotomist | 0% | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Phlebotomist | 0% | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Lab technician | 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 | 0 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £0 | £5,500 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| 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,000 | £4,278 | £5,094 | £5,987 | £6,424 | £7,174 | £8,249 | £10,787 | £12,270 | £16,254 | £18,618 | |
| Direct Cost of Sales | £0 | £1,050 | £1,497 | £1,783 | £2,095 | £2,248 | £2,511 | £2,887 | £3,775 | £4,295 | £5,689 | £6,516 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £1,050 | £1,497 | £1,783 | £2,095 | £2,248 | £2,511 | £2,887 | £3,775 | £4,295 | £5,689 | £6,516 | |
| Gross Margin | £0 | £1,950 | £2,781 | £3,311 | £3,891 | £4,175 | £4,663 | £5,362 | £7,011 | £7,976 | £10,565 | £12,102 | |
| Gross Margin % | 0.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £5,500 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Sales and Marketing and Other Expenses | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | |
| 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 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £0 | £825 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £2,767 | £9,092 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | |
| Profit Before Interest and Taxes | (£2,767) | (£7,142) | (£8,036) | (£7,506) | (£6,926) | (£6,642) | (£6,154) | (£5,455) | (£3,806) | (£2,842) | (£252) | £1,285 | |
| EBITDA | (£1,550) | (£5,925) | (£6,819) | (£6,289) | (£5,709) | (£5,425) | (£4,937) | (£4,238) | (£2,589) | (£1,625) | £965 | £2,502 | |
| Interest Expense | £1,408 | £1,400 | £1,392 | £1,383 | £1,375 | £1,367 | £1,358 | £1,350 | £1,342 | £1,333 | £1,325 | £1,317 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,175) | (£8,542) | (£9,428) | (£8,889) | (£8,301) | (£8,008) | (£7,512) | (£6,805) | (£5,147) | (£4,175) | (£1,577) | (£32) | |
| Net Profit/Sales | 0.00% | -284.73% | -220.38% | -174.50% | -138.65% | -124.67% | -104.72% | -82.50% | -47.72% | -34.02% | -9.70% | -0.17% | |
| 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 | £750 | £1,070 | £1,274 | £1,497 | £1,606 | £1,793 | £2,062 | £2,697 | £3,068 | £4,064 | £4,655 | |
| Cash from Receivables | £0 | £0 | £75 | £2,282 | £3,229 | £3,843 | £4,501 | £4,836 | £5,407 | £6,250 | £8,127 | £9,302 | |
| Subtotal Cash from Operations | £0 | £750 | £1,145 | £3,555 | £4,726 | £5,449 | £6,294 | £6,899 | £8,104 | £9,318 | £12,191 | £13,957 | |
| 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 | £750 | £1,145 | £3,555 | £4,726 | £5,449 | £6,294 | £6,899 | £8,104 | £9,318 | £12,191 | £13,957 | |
| 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 | £5,500 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Bill Payments | £99 | £3,021 | £4,847 | £5,498 | £5,776 | £6,075 | £6,223 | £6,481 | £6,866 | £7,734 | £8,274 | £9,641 | |
| Subtotal Spent on Operations | £99 | £8,521 | £11,847 | £12,498 | £12,776 | £13,075 | £13,223 | £13,481 | £13,866 | £14,734 | £15,274 | £16,641 | |
| 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,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| 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,099 | £9,521 | £12,847 | £13,498 | £13,776 | £14,075 | £14,223 | £14,481 | £14,866 | £15,734 | £16,274 | £17,641 | |
| Net Cash Flow | (£1,099) | (£8,771) | (£11,703) | (£9,943) | (£9,051) | (£8,626) | (£7,929) | (£7,583) | (£6,763) | (£6,417) | (£4,083) | (£3,685) | |
| Cash Balance | £90,901 | £82,131 | £70,428 | £60,485 | £51,435 | £42,808 | £34,879 | £27,297 | £20,534 | £14,117 | £10,034 | £6,349 | |
| 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 | £92,000 | £90,901 | £82,131 | £70,428 | £60,485 | £51,435 | £42,808 | £34,879 | £27,297 | £20,534 | £14,117 | £10,034 | £6,349 |
| Accounts Receivable | £0 | £0 | £2,250 | £5,384 | £6,922 | £8,183 | £9,158 | £10,037 | £11,387 | £14,070 | £17,023 | £21,086 | £25,748 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £92,000 | £90,901 | £84,381 | £75,812 | £67,407 | £59,618 | £51,966 | £44,917 | £38,684 | £34,604 | £31,140 | £31,120 | £32,097 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 |
| Accumulated Depreciation | £0 | £1,217 | £2,434 | £3,651 | £4,868 | £6,085 | £7,302 | £8,519 | £9,736 | £10,953 | £12,170 | £13,387 | £14,604 |
| Total Long-term Assets | £73,000 | £71,783 | £70,566 | £69,349 | £68,132 | £66,915 | £65,698 | £64,481 | £63,264 | £62,047 | £60,830 | £59,613 | £58,396 |
| Total Assets | £165,000 | £162,684 | £154,947 | £145,161 | £135,539 | £126,533 | £117,664 | £109,398 | £101,948 | £96,651 | £91,970 | £90,733 | £90,493 |
| 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,860 | £4,664 | £5,306 | £5,574 | £5,868 | £6,008 | £6,253 | £6,609 | £7,460 | £7,954 | £9,293 | £10,085 |
| 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,860 | £4,664 | £5,306 | £5,574 | £5,868 | £6,008 | £6,253 | £6,609 | £7,460 | £7,954 | £9,293 | £10,085 |
| Long-term Liabilities | £170,000 | £169,000 | £168,000 | £167,000 | £166,000 | £165,000 | £164,000 | £163,000 | £162,000 | £161,000 | £160,000 | £159,000 | £158,000 |
| Total Liabilities | £170,000 | £171,860 | £172,664 | £172,306 | £171,574 | £170,868 | £170,008 | £169,253 | £168,609 | £168,460 | £167,954 | £168,293 | £168,085 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) |
| Earnings | £0 | (£4,175) | (£12,717) | (£22,145) | (£31,035) | (£39,335) | (£47,343) | (£54,856) | (£61,661) | (£66,808) | (£70,983) | (£72,560) | (£72,592) |
| Total Capital | (£5,000) | (£9,175) | (£17,717) | (£27,145) | (£36,035) | (£44,335) | (£52,343) | (£59,856) | (£66,661) | (£71,808) | (£75,983) | (£77,560) | (£77,592) |
| Total Liabilities and Capital | £165,000 | £162,684 | £154,947 | £145,161 | £135,539 | £126,533 | £117,664 | £109,398 | £101,948 | £96,651 | £91,970 | £90,733 | £90,493 |
| Net Worth | (£5,000) | (£9,175) | (£17,717) | (£27,145) | (£36,035) | (£44,335) | (£52,343) | (£59,856) | (£66,661) | (£71,808) | (£75,983) | (£77,560) | (£77,592) |
| 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 | |||||||||||||
| Professional building physicians | 0% | £0 | £2,500 | £3,565 | £4,245 | £4,989 | £5,353 | £5,978 | £6,874 | £8,989 | £10,225 | £13,545 | £15,515 |
| Nearby physicians | 0% | £0 | £500 | £713 | £849 | £998 | £1,071 | £1,196 | £1,375 | £1,798 | £2,045 | £2,709 | £3,103 |
| Total Sales | £0 | £3,000 | £4,278 | £5,094 | £5,987 | £6,424 | £7,174 | £8,249 | £10,787 | £12,270 | £16,254 | £18,618 | |
| 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 | |
| Professional building physicians | £0 | £875 | £1,248 | £1,486 | £1,746 | £1,874 | £2,092 | £2,406 | £3,146 | £3,579 | £4,741 | £5,430 | |
| Nearby physicians | £0 | £175 | £250 | £297 | £349 | £375 | £418 | £481 | £629 | £716 | £948 | £1,086 | |
| Subtotal Direct Cost of Sales | £0 | £1,050 | £1,497 | £1,783 | £2,095 | £2,248 | £2,511 | £2,887 | £3,775 | £4,295 | £5,689 | £6,516 | |
| 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 | ||
| Dave | 0% | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Phlebotomist | 0% | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Phlebotomist | 0% | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Lab technician | 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 | 0 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £0 | £5,500 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| 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,000 | £4,278 | £5,094 | £5,987 | £6,424 | £7,174 | £8,249 | £10,787 | £12,270 | £16,254 | £18,618 | |
| Direct Cost of Sales | £0 | £1,050 | £1,497 | £1,783 | £2,095 | £2,248 | £2,511 | £2,887 | £3,775 | £4,295 | £5,689 | £6,516 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £1,050 | £1,497 | £1,783 | £2,095 | £2,248 | £2,511 | £2,887 | £3,775 | £4,295 | £5,689 | £6,516 | |
| Gross Margin | £0 | £1,950 | £2,781 | £3,311 | £3,891 | £4,175 | £4,663 | £5,362 | £7,011 | £7,976 | £10,565 | £12,102 | |
| Gross Margin % | 0.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £5,500 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Sales and Marketing and Other Expenses | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | £1,217 | |
| 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 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £0 | £825 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £2,767 | £9,092 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | £10,817 | |
| Profit Before Interest and Taxes | (£2,767) | (£7,142) | (£8,036) | (£7,506) | (£6,926) | (£6,642) | (£6,154) | (£5,455) | (£3,806) | (£2,842) | (£252) | £1,285 | |
| EBITDA | (£1,550) | (£5,925) | (£6,819) | (£6,289) | (£5,709) | (£5,425) | (£4,937) | (£4,238) | (£2,589) | (£1,625) | £965 | £2,502 | |
| Interest Expense | £1,408 | £1,400 | £1,392 | £1,383 | £1,375 | £1,367 | £1,358 | £1,350 | £1,342 | £1,333 | £1,325 | £1,317 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,175) | (£8,542) | (£9,428) | (£8,889) | (£8,301) | (£8,008) | (£7,512) | (£6,805) | (£5,147) | (£4,175) | (£1,577) | (£32) | |
| Net Profit/Sales | 0.00% | -284.73% | -220.38% | -174.50% | -138.65% | -124.67% | -104.72% | -82.50% | -47.72% | -34.02% | -9.70% | -0.17% | |
| 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 | £750 | £1,070 | £1,274 | £1,497 | £1,606 | £1,793 | £2,062 | £2,697 | £3,068 | £4,064 | £4,655 | |
| Cash from Receivables | £0 | £0 | £75 | £2,282 | £3,229 | £3,843 | £4,501 | £4,836 | £5,407 | £6,250 | £8,127 | £9,302 | |
| Subtotal Cash from Operations | £0 | £750 | £1,145 | £3,555 | £4,726 | £5,449 | £6,294 | £6,899 | £8,104 | £9,318 | £12,191 | £13,957 | |
| 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 | £750 | £1,145 | £3,555 | £4,726 | £5,449 | £6,294 | £6,899 | £8,104 | £9,318 | £12,191 | £13,957 | |
| 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 | £5,500 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Bill Payments | £99 | £3,021 | £4,847 | £5,498 | £5,776 | £6,075 | £6,223 | £6,481 | £6,866 | £7,734 | £8,274 | £9,641 | |
| Subtotal Spent on Operations | £99 | £8,521 | £11,847 | £12,498 | £12,776 | £13,075 | £13,223 | £13,481 | £13,866 | £14,734 | £15,274 | £16,641 | |
| 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,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| 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,099 | £9,521 | £12,847 | £13,498 | £13,776 | £14,075 | £14,223 | £14,481 | £14,866 | £15,734 | £16,274 | £17,641 | |
| Net Cash Flow | (£1,099) | (£8,771) | (£11,703) | (£9,943) | (£9,051) | (£8,626) | (£7,929) | (£7,583) | (£6,763) | (£6,417) | (£4,083) | (£3,685) | |
| Cash Balance | £90,901 | £82,131 | £70,428 | £60,485 | £51,435 | £42,808 | £34,879 | £27,297 | £20,534 | £14,117 | £10,034 | £6,349 | |
| 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 | £92,000 | £90,901 | £82,131 | £70,428 | £60,485 | £51,435 | £42,808 | £34,879 | £27,297 | £20,534 | £14,117 | £10,034 | £6,349 |
| Accounts Receivable | £0 | £0 | £2,250 | £5,384 | £6,922 | £8,183 | £9,158 | £10,037 | £11,387 | £14,070 | £17,023 | £21,086 | £25,748 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £92,000 | £90,901 | £84,381 | £75,812 | £67,407 | £59,618 | £51,966 | £44,917 | £38,684 | £34,604 | £31,140 | £31,120 | £32,097 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 | £73,000 |
| Accumulated Depreciation | £0 | £1,217 | £2,434 | £3,651 | £4,868 | £6,085 | £7,302 | £8,519 | £9,736 | £10,953 | £12,170 | £13,387 | £14,604 |
| Total Long-term Assets | £73,000 | £71,783 | £70,566 | £69,349 | £68,132 | £66,915 | £65,698 | £64,481 | £63,264 | £62,047 | £60,830 | £59,613 | £58,396 |
| Total Assets | £165,000 | £162,684 | £154,947 | £145,161 | £135,539 | £126,533 | £117,664 | £109,398 | £101,948 | £96,651 | £91,970 | £90,733 | £90,493 |
| 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,860 | £4,664 | £5,306 | £5,574 | £5,868 | £6,008 | £6,253 | £6,609 | £7,460 | £7,954 | £9,293 | £10,085 |
| 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,860 | £4,664 | £5,306 | £5,574 | £5,868 | £6,008 | £6,253 | £6,609 | £7,460 | £7,954 | £9,293 | £10,085 |
| Long-term Liabilities | £170,000 | £169,000 | £168,000 | £167,000 | £166,000 | £165,000 | £164,000 | £163,000 | £162,000 | £161,000 | £160,000 | £159,000 | £158,000 |
| Total Liabilities | £170,000 | £171,860 | £172,664 | £172,306 | £171,574 | £170,868 | £170,008 | £169,253 | £168,609 | £168,460 | £167,954 | £168,293 | £168,085 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) | (£5,000) |
| Earnings | £0 | (£4,175) | (£12,717) | (£22,145) | (£31,035) | (£39,335) | (£47,343) | (£54,856) | (£61,661) | (£66,808) | (£70,983) | (£72,560) | (£72,592) |
| Total Capital | (£5,000) | (£9,175) | (£17,717) | (£27,145) | (£36,035) | (£44,335) | (£52,343) | (£59,856) | (£66,661) | (£71,808) | (£75,983) | (£77,560) | (£77,592) |
| Total Liabilities and Capital | £165,000 | £162,684 | £154,947 | £145,161 | £135,539 | £126,533 | £117,664 | £109,398 | £101,948 | £96,651 | £91,970 | £90,733 | £90,493 |
| Net Worth | (£5,000) | (£9,175) | (£17,717) | (£27,145) | (£36,035) | (£44,335) | (£52,343) | (£59,856) | (£66,661) | (£71,808) | (£75,983) | (£77,560) | (£77,592) |