| 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 | |||||||||||||
| X-ray | 0% | £0 | £0 | £5,500 | £8,565 | £10,005 | £12,454 | £13,121 | £14,005 | £14,989 | £15,114 | £15,265 | £15,274 |
| Ultrasound | 0% | £0 | £0 | £3,245 | £5,053 | £5,903 | £7,348 | £7,741 | £8,263 | £8,844 | £8,917 | £9,006 | £9,012 |
| CAT scan | 0% | £0 | £0 | £6,050 | £9,422 | £11,006 | £13,699 | £14,433 | £15,406 | £16,488 | £16,625 | £16,792 | £16,801 |
| MRI | 0% | £0 | £0 | £3,894 | £6,064 | £7,084 | £8,817 | £9,290 | £9,916 | £10,612 | £10,701 | £10,808 | £10,814 |
| Total Sales | £0 | £0 | £18,689 | £29,104 | £33,997 | £42,319 | £44,585 | £47,589 | £50,933 | £51,357 | £51,870 | £51,901 | |
| 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 | |
| X-ray | £0 | £0 | £1,265 | £1,970 | £2,301 | £2,864 | £3,018 | £3,221 | £3,447 | £3,476 | £3,511 | £3,513 | |
| Ultrasound | £0 | £0 | £746 | £1,162 | £1,358 | £1,690 | £1,781 | £1,900 | £2,034 | £2,051 | £2,071 | £2,073 | |
| CAT scan | £0 | £0 | £1,392 | £2,167 | £2,531 | £3,151 | £3,320 | £3,543 | £3,792 | £3,824 | £3,862 | £3,864 | |
| MRI | £0 | £0 | £896 | £1,395 | £1,629 | £2,028 | £2,137 | £2,281 | £2,441 | £2,461 | £2,486 | £2,487 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £4,298 | £6,694 | £7,819 | £9,733 | £10,255 | £10,945 | £11,715 | £11,812 | £11,930 | £11,937 | |
| 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 | ||
| Dr. Jones | 0% | £0 | £0 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Technicians | 0% | £0 | £0 | £0 | £3,000 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Other | 0% | £0 | £0 | £0 | £1,200 | £1,200 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Total People | 0 | 0 | 0 | 3 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £0 | £0 | £6,000 | £10,200 | £10,200 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | |
| 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 | £18,689 | £29,104 | £33,997 | £42,319 | £44,585 | £47,589 | £50,933 | £51,357 | £51,870 | £51,901 | |
| Direct Cost of Sales | £0 | £0 | £4,298 | £6,694 | £7,819 | £9,733 | £10,255 | £10,945 | £11,715 | £11,812 | £11,930 | £11,937 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £4,298 | £6,694 | £7,819 | £9,733 | £10,255 | £10,945 | £11,715 | £11,812 | £11,930 | £11,937 | |
| Gross Margin | £0 | £0 | £14,391 | £22,410 | £26,178 | £32,585 | £34,331 | £36,644 | £39,218 | £39,545 | £39,940 | £39,964 | |
| Gross Margin % | 0.00% | 0.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £6,000 | £10,200 | £10,200 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £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% | £0 | £0 | £900 | £1,530 | £1,530 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £19,058 | £19,058 | £25,958 | £30,788 | £30,788 | £35,618 | £35,618 | £35,618 | £35,618 | £35,618 | £35,618 | £35,618 | |
| Profit Before Interest and Taxes | (£19,058) | (£19,058) | (£11,568) | (£8,378) | (£4,611) | (£3,033) | (£1,288) | £1,025 | £3,600 | £3,927 | £4,322 | £4,346 | |
| EBITDA | (£4,700) | (£4,700) | £2,791 | £5,980 | £9,748 | £11,325 | £13,071 | £15,384 | £17,958 | £18,285 | £18,680 | £18,704 | |
| Interest Expense | £7,083 | £7,000 | £6,917 | £6,833 | £6,750 | £6,667 | £6,583 | £6,500 | £6,417 | £6,333 | £6,250 | £6,167 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£26,142) | (£26,058) | (£18,484) | (£15,212) | (£11,361) | (£9,700) | (£7,871) | (£5,475) | (£2,817) | (£2,406) | (£1,928) | (£1,821) | |
| Net Profit/Sales | 0.00% | 0.00% | -98.91% | -52.27% | -33.42% | -22.92% | -17.65% | -11.50% | -5.53% | -4.69% | -3.72% | -3.51% | |
| 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 | £4,672 | £7,276 | £8,499 | £10,580 | £11,146 | £11,897 | £12,733 | £12,839 | £12,968 | £12,975 | |
| Cash from Receivables | £0 | £0 | £0 | £467 | £14,277 | £21,950 | £25,706 | £31,796 | £33,514 | £35,775 | £38,210 | £38,531 | |
| Subtotal Cash from Operations | £0 | £0 | £4,672 | £7,743 | £22,776 | £32,530 | £36,852 | £43,693 | £46,247 | £48,615 | £51,178 | £51,506 | |
| 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 | £4,672 | £7,743 | £22,776 | £32,530 | £36,852 | £43,693 | £46,247 | £48,615 | £51,178 | £51,506 | |
| 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 | £6,000 | £10,200 | £10,200 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | |
| Bill Payments | £393 | £11,781 | £11,871 | £16,913 | £19,792 | £20,881 | £23,275 | £23,718 | £24,328 | £24,992 | £25,007 | £25,038 | |
| Subtotal Spent on Operations | £393 | £11,781 | £17,871 | £27,113 | £29,992 | £35,281 | £37,675 | £38,118 | £38,728 | £39,392 | £39,407 | £39,438 | |
| 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 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,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 | £10,393 | £21,781 | £27,871 | £37,113 | £39,992 | £45,281 | £47,675 | £48,118 | £48,728 | £49,392 | £49,407 | £49,438 | |
| Net Cash Flow | (£10,393) | (£21,781) | (£23,198) | (£29,370) | (£17,216) | (£12,751) | (£10,822) | (£4,425) | (£2,481) | (£777) | £1,771 | £2,068 | |
| Cash Balance | £307,507 | £285,727 | £262,528 | £233,158 | £215,943 | £203,191 | £192,369 | £187,944 | £185,462 | £184,685 | £186,456 | £188,525 | |
| 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 | £317,900 | £307,507 | £285,727 | £262,528 | £233,158 | £215,943 | £203,191 | £192,369 | £187,944 | £185,462 | £184,685 | £186,456 | £188,525 |
| Accounts Receivable | £0 | £0 | £0 | £14,017 | £35,377 | £46,598 | £56,387 | £64,120 | £68,016 | £72,701 | £75,444 | £76,137 | £76,532 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £317,900 | £307,507 | £285,727 | £276,545 | £268,536 | £262,541 | £259,578 | £256,489 | £255,960 | £258,164 | £260,130 | £262,593 | £265,057 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 |
| Accumulated Depreciation | £0 | £14,358 | £28,717 | £43,075 | £57,433 | £71,792 | £86,150 | £100,508 | £114,866 | £129,225 | £143,583 | £157,941 | £172,300 |
| Total Long-term Assets | £861,500 | £847,142 | £832,783 | £818,425 | £804,067 | £789,709 | £775,350 | £760,992 | £746,634 | £732,275 | £717,917 | £703,559 | £689,200 |
| Total Assets | £1,179,400 | £1,154,649 | £1,118,510 | £1,094,970 | £1,072,603 | £1,052,249 | £1,034,928 | £1,017,481 | £1,002,593 | £990,439 | £978,047 | £966,152 | £954,257 |
| 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 | £11,391 | £11,310 | £16,255 | £19,099 | £20,106 | £22,485 | £22,908 | £23,495 | £24,158 | £24,172 | £24,206 | £24,132 |
| 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 | £11,391 | £11,310 | £16,255 | £19,099 | £20,106 | £22,485 | £22,908 | £23,495 | £24,158 | £24,172 | £24,206 | £24,132 |
| Long-term Liabilities | £860,000 | £850,000 | £840,000 | £830,000 | £820,000 | £810,000 | £800,000 | £790,000 | £780,000 | £770,000 | £760,000 | £750,000 | £740,000 |
| Total Liabilities | £860,000 | £861,391 | £851,310 | £846,255 | £839,099 | £830,106 | £822,485 | £812,908 | £803,495 | £794,158 | £784,172 | £774,206 | £764,132 |
| Paid-in Capital | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 |
| Retained Earnings | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) |
| Earnings | £0 | (£26,142) | (£52,200) | (£70,684) | (£85,896) | (£97,257) | (£106,956) | (£114,827) | (£120,302) | (£123,119) | (£125,525) | (£127,453) | (£129,275) |
| Total Capital | £319,400 | £293,258 | £267,200 | £248,716 | £233,504 | £222,143 | £212,444 | £204,573 | £199,098 | £196,281 | £193,875 | £191,947 | £190,125 |
| Total Liabilities and Capital | £1,179,400 | £1,154,649 | £1,118,510 | £1,094,970 | £1,072,603 | £1,052,249 | £1,034,928 | £1,017,481 | £1,002,593 | £990,439 | £978,047 | £966,152 | £954,257 |
| Net Worth | £319,400 | £293,258 | £267,200 | £248,716 | £233,504 | £222,143 | £212,444 | £204,573 | £199,098 | £196,281 | £193,875 | £191,947 | £190,125 |
| 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 | |||||||||||||
| X-ray | 0% | £0 | £0 | £5,500 | £8,565 | £10,005 | £12,454 | £13,121 | £14,005 | £14,989 | £15,114 | £15,265 | £15,274 |
| Ultrasound | 0% | £0 | £0 | £3,245 | £5,053 | £5,903 | £7,348 | £7,741 | £8,263 | £8,844 | £8,917 | £9,006 | £9,012 |
| CAT scan | 0% | £0 | £0 | £6,050 | £9,422 | £11,006 | £13,699 | £14,433 | £15,406 | £16,488 | £16,625 | £16,792 | £16,801 |
| MRI | 0% | £0 | £0 | £3,894 | £6,064 | £7,084 | £8,817 | £9,290 | £9,916 | £10,612 | £10,701 | £10,808 | £10,814 |
| Total Sales | £0 | £0 | £18,689 | £29,104 | £33,997 | £42,319 | £44,585 | £47,589 | £50,933 | £51,357 | £51,870 | £51,901 | |
| 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 | |
| X-ray | £0 | £0 | £1,265 | £1,970 | £2,301 | £2,864 | £3,018 | £3,221 | £3,447 | £3,476 | £3,511 | £3,513 | |
| Ultrasound | £0 | £0 | £746 | £1,162 | £1,358 | £1,690 | £1,781 | £1,900 | £2,034 | £2,051 | £2,071 | £2,073 | |
| CAT scan | £0 | £0 | £1,392 | £2,167 | £2,531 | £3,151 | £3,320 | £3,543 | £3,792 | £3,824 | £3,862 | £3,864 | |
| MRI | £0 | £0 | £896 | £1,395 | £1,629 | £2,028 | £2,137 | £2,281 | £2,441 | £2,461 | £2,486 | £2,487 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £4,298 | £6,694 | £7,819 | £9,733 | £10,255 | £10,945 | £11,715 | £11,812 | £11,930 | £11,937 | |
| 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 | ||
| Dr. Jones | 0% | £0 | £0 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Technicians | 0% | £0 | £0 | £0 | £3,000 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Other | 0% | £0 | £0 | £0 | £1,200 | £1,200 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Total People | 0 | 0 | 0 | 3 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £0 | £0 | £6,000 | £10,200 | £10,200 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | |
| 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 | £18,689 | £29,104 | £33,997 | £42,319 | £44,585 | £47,589 | £50,933 | £51,357 | £51,870 | £51,901 | |
| Direct Cost of Sales | £0 | £0 | £4,298 | £6,694 | £7,819 | £9,733 | £10,255 | £10,945 | £11,715 | £11,812 | £11,930 | £11,937 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £4,298 | £6,694 | £7,819 | £9,733 | £10,255 | £10,945 | £11,715 | £11,812 | £11,930 | £11,937 | |
| Gross Margin | £0 | £0 | £14,391 | £22,410 | £26,178 | £32,585 | £34,331 | £36,644 | £39,218 | £39,545 | £39,940 | £39,964 | |
| Gross Margin % | 0.00% | 0.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £6,000 | £10,200 | £10,200 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | £14,358 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £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% | £0 | £0 | £900 | £1,530 | £1,530 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £19,058 | £19,058 | £25,958 | £30,788 | £30,788 | £35,618 | £35,618 | £35,618 | £35,618 | £35,618 | £35,618 | £35,618 | |
| Profit Before Interest and Taxes | (£19,058) | (£19,058) | (£11,568) | (£8,378) | (£4,611) | (£3,033) | (£1,288) | £1,025 | £3,600 | £3,927 | £4,322 | £4,346 | |
| EBITDA | (£4,700) | (£4,700) | £2,791 | £5,980 | £9,748 | £11,325 | £13,071 | £15,384 | £17,958 | £18,285 | £18,680 | £18,704 | |
| Interest Expense | £7,083 | £7,000 | £6,917 | £6,833 | £6,750 | £6,667 | £6,583 | £6,500 | £6,417 | £6,333 | £6,250 | £6,167 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£26,142) | (£26,058) | (£18,484) | (£15,212) | (£11,361) | (£9,700) | (£7,871) | (£5,475) | (£2,817) | (£2,406) | (£1,928) | (£1,821) | |
| Net Profit/Sales | 0.00% | 0.00% | -98.91% | -52.27% | -33.42% | -22.92% | -17.65% | -11.50% | -5.53% | -4.69% | -3.72% | -3.51% | |
| 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 | £4,672 | £7,276 | £8,499 | £10,580 | £11,146 | £11,897 | £12,733 | £12,839 | £12,968 | £12,975 | |
| Cash from Receivables | £0 | £0 | £0 | £467 | £14,277 | £21,950 | £25,706 | £31,796 | £33,514 | £35,775 | £38,210 | £38,531 | |
| Subtotal Cash from Operations | £0 | £0 | £4,672 | £7,743 | £22,776 | £32,530 | £36,852 | £43,693 | £46,247 | £48,615 | £51,178 | £51,506 | |
| 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 | £4,672 | £7,743 | £22,776 | £32,530 | £36,852 | £43,693 | £46,247 | £48,615 | £51,178 | £51,506 | |
| 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 | £6,000 | £10,200 | £10,200 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | |
| Bill Payments | £393 | £11,781 | £11,871 | £16,913 | £19,792 | £20,881 | £23,275 | £23,718 | £24,328 | £24,992 | £25,007 | £25,038 | |
| Subtotal Spent on Operations | £393 | £11,781 | £17,871 | £27,113 | £29,992 | £35,281 | £37,675 | £38,118 | £38,728 | £39,392 | £39,407 | £39,438 | |
| 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 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,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 | £10,393 | £21,781 | £27,871 | £37,113 | £39,992 | £45,281 | £47,675 | £48,118 | £48,728 | £49,392 | £49,407 | £49,438 | |
| Net Cash Flow | (£10,393) | (£21,781) | (£23,198) | (£29,370) | (£17,216) | (£12,751) | (£10,822) | (£4,425) | (£2,481) | (£777) | £1,771 | £2,068 | |
| Cash Balance | £307,507 | £285,727 | £262,528 | £233,158 | £215,943 | £203,191 | £192,369 | £187,944 | £185,462 | £184,685 | £186,456 | £188,525 | |
| 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 | £317,900 | £307,507 | £285,727 | £262,528 | £233,158 | £215,943 | £203,191 | £192,369 | £187,944 | £185,462 | £184,685 | £186,456 | £188,525 |
| Accounts Receivable | £0 | £0 | £0 | £14,017 | £35,377 | £46,598 | £56,387 | £64,120 | £68,016 | £72,701 | £75,444 | £76,137 | £76,532 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £317,900 | £307,507 | £285,727 | £276,545 | £268,536 | £262,541 | £259,578 | £256,489 | £255,960 | £258,164 | £260,130 | £262,593 | £265,057 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 | £861,500 |
| Accumulated Depreciation | £0 | £14,358 | £28,717 | £43,075 | £57,433 | £71,792 | £86,150 | £100,508 | £114,866 | £129,225 | £143,583 | £157,941 | £172,300 |
| Total Long-term Assets | £861,500 | £847,142 | £832,783 | £818,425 | £804,067 | £789,709 | £775,350 | £760,992 | £746,634 | £732,275 | £717,917 | £703,559 | £689,200 |
| Total Assets | £1,179,400 | £1,154,649 | £1,118,510 | £1,094,970 | £1,072,603 | £1,052,249 | £1,034,928 | £1,017,481 | £1,002,593 | £990,439 | £978,047 | £966,152 | £954,257 |
| 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 | £11,391 | £11,310 | £16,255 | £19,099 | £20,106 | £22,485 | £22,908 | £23,495 | £24,158 | £24,172 | £24,206 | £24,132 |
| 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 | £11,391 | £11,310 | £16,255 | £19,099 | £20,106 | £22,485 | £22,908 | £23,495 | £24,158 | £24,172 | £24,206 | £24,132 |
| Long-term Liabilities | £860,000 | £850,000 | £840,000 | £830,000 | £820,000 | £810,000 | £800,000 | £790,000 | £780,000 | £770,000 | £760,000 | £750,000 | £740,000 |
| Total Liabilities | £860,000 | £861,391 | £851,310 | £846,255 | £839,099 | £830,106 | £822,485 | £812,908 | £803,495 | £794,158 | £784,172 | £774,206 | £764,132 |
| Paid-in Capital | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 | £330,000 |
| Retained Earnings | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) | (£10,600) |
| Earnings | £0 | (£26,142) | (£52,200) | (£70,684) | (£85,896) | (£97,257) | (£106,956) | (£114,827) | (£120,302) | (£123,119) | (£125,525) | (£127,453) | (£129,275) |
| Total Capital | £319,400 | £293,258 | £267,200 | £248,716 | £233,504 | £222,143 | £212,444 | £204,573 | £199,098 | £196,281 | £193,875 | £191,947 | £190,125 |
| Total Liabilities and Capital | £1,179,400 | £1,154,649 | £1,118,510 | £1,094,970 | £1,072,603 | £1,052,249 | £1,034,928 | £1,017,481 | £1,002,593 | £990,439 | £978,047 | £966,152 | £954,257 |
| Net Worth | £319,400 | £293,258 | £267,200 | £248,716 | £233,504 | £222,143 | £212,444 | £204,573 | £199,098 | £196,281 | £193,875 | £191,947 | £190,125 |