| 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 | |||||||||||||
| Chiropractic Cases | 0% | £0 | £6,250 | £12,500 | £18,725 | £25,000 | £31,250 | £37,500 | £43,750 | £50,000 | £56,250 | £62,500 | £68,750 |
| Corporate Clients | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Home Exercise Devices | 0% | £300 | £350 | £400 | £400 | £450 | £500 | £500 | £500 | £550 | £550 | £600 | £600 |
| Weight Loss System | 0% | £240 | £240 | £240 | £240 | £320 | £320 | £320 | £320 | £320 | £400 | £400 | £400 |
| Pillows | 0% | £180 | £210 | £240 | £240 | £270 | £270 | £300 | £330 | £330 | £360 | £360 | £390 |
| TENS Units | 0% | £360 | £360 | £360 | £360 | £360 | £480 | £480 | £480 | £600 | £600 | £600 | £600 |
| Total Sales | £2,580 | £8,910 | £15,240 | £21,465 | £27,900 | £34,320 | £40,600 | £46,880 | £53,300 | £59,660 | £65,960 | £72,240 | |
| 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 | |
| Chiropractic Cases | £0 | £63 | £125 | £187 | £250 | £313 | £375 | £438 | £500 | £563 | £625 | £688 | |
| Corporate Clients | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Home Exercise Devices | £138 | £161 | £184 | £184 | £207 | £230 | £230 | £230 | £253 | £253 | £276 | £276 | |
| Weight Loss System | £81 | £81 | £81 | £81 | £108 | £108 | £108 | £108 | £108 | £135 | £135 | £135 | |
| Pillows | £84 | £98 | £112 | £112 | £126 | £126 | £140 | £154 | £154 | £168 | £168 | £182 | |
| TENS Units | £87 | £87 | £87 | £87 | £87 | £116 | £116 | £116 | £145 | £145 | £145 | £145 | |
| Subtotal Direct Cost of Sales | £690 | £790 | £889 | £951 | £1,078 | £1,193 | £1,269 | £1,346 | £1,460 | £1,564 | £1,649 | £1,726 | |
| 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 | ||
| Angelo M. Rubano, Jr. D.C. | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £6,000 | £6,000 | £7,500 | £7,500 | £7,500 |
| Associate Dr. #1 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Associate Dr. #2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Insurance Staff | 0% | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,236 | £2,236 | £2,236 | £2,236 | £2,236 | £2,236 |
| Insurance Staff #2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Front Desk Staff | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,150 | £2,150 | £2,150 |
| Front Desk Staff #2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Chiropractic Assistant #1 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,580 | £2,580 | £2,580 | £2,580 | £2,580 |
| Chiropractic Assistant #2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Chiropractic Assistant #3 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | |
| Total Payroll | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £7,236 | £10,816 | £10,816 | £14,466 | £14,466 | £14,466 | |
| 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 | £2,580 | £8,910 | £15,240 | £21,465 | £27,900 | £34,320 | £40,600 | £46,880 | £53,300 | £59,660 | £65,960 | £72,240 | |
| Direct Cost of Sales | £690 | £790 | £889 | £951 | £1,078 | £1,193 | £1,269 | £1,346 | £1,460 | £1,564 | £1,649 | £1,726 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £690 | £790 | £889 | £951 | £1,078 | £1,193 | £1,269 | £1,346 | £1,460 | £1,564 | £1,649 | £1,726 | |
| Gross Margin | £1,890 | £8,121 | £14,351 | £20,514 | £26,822 | £33,128 | £39,331 | £45,535 | £51,840 | £58,097 | £64,311 | £70,515 | |
| Gross Margin % | 73.26% | 91.14% | 94.17% | 95.57% | 96.14% | 96.53% | 96.87% | 97.13% | 97.26% | 97.38% | 97.50% | 97.61% | |
| Expenses | |||||||||||||
| Payroll | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £7,236 | £10,816 | £10,816 | £14,466 | £14,466 | £14,466 | |
| Marketing/Promotion | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | |
| Depreciation | £0 | £386 | £386 | £386 | £386 | £386 | £386 | £386 | £386 | £386 | £386 | £386 | |
| Rent | £0 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | |
| Utilities | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £154 | £154 | £154 | £154 | £154 | £154 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Office Supplies | £0 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | |
| Legal Fees | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Accounting Fees | £0 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Computer Technical Support | £0 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | |
| XRay Film and Processor Maintenance | £0 | £175 | £175 | £175 | £175 | £175 | £175 | £175 | £175 | £175 | £175 | £175 | |
| Professional Organization Membership | 15% | £0 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 |
| Employee Benefits Package | £0 | £585 | £585 | £585 | £585 | £585 | £585 | £585 | £585 | £585 | £585 | £585 | |
| Total Operating Expenses | £7,817 | £11,499 | £11,499 | £11,499 | £11,499 | £11,499 | £12,739 | £16,319 | £16,319 | £19,969 | £19,969 | £19,969 | |
| Profit Before Interest and Taxes | (£5,927) | (£3,378) | £2,852 | £9,015 | £15,323 | £21,629 | £26,592 | £29,216 | £35,521 | £38,128 | £44,342 | £50,546 | |
| EBITDA | (£5,927) | (£2,992) | £3,239 | £9,401 | £15,710 | £22,015 | £26,978 | £29,602 | £35,907 | £38,514 | £44,728 | £50,932 | |
| Interest Expense | £1,348 | £1,328 | £1,309 | £1,290 | £1,271 | £1,252 | £1,233 | £1,214 | £1,195 | £1,176 | £1,157 | £1,137 | |
| Taxes Incurred | (£2,182) | (£1,412) | £463 | £2,317 | £4,216 | £6,113 | £7,608 | £8,401 | £10,298 | £11,086 | £12,956 | £14,822 | |
| Net Profit | (£5,092) | (£3,295) | £1,080 | £5,407 | £9,837 | £14,264 | £17,752 | £19,601 | £24,029 | £25,866 | £30,230 | £34,586 | |
| Net Profit/Sales | -197.36% | -36.98% | 7.09% | 25.19% | 35.26% | 41.56% | 43.72% | 41.81% | 45.08% | 43.36% | 45.83% | 47.88% | |
| 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 | £645 | £2,228 | £3,810 | £5,366 | £6,975 | £8,580 | £10,150 | £11,720 | £13,325 | £14,915 | £16,490 | £18,060 | |
| Cash from Receivables | £0 | £65 | £2,093 | £6,841 | £11,586 | £16,260 | £21,086 | £25,897 | £30,607 | £35,321 | £40,134 | £44,903 | |
| Subtotal Cash from Operations | £645 | £2,292 | £5,903 | £12,207 | £18,561 | £24,840 | £31,236 | £37,617 | £43,932 | £50,236 | £56,624 | £62,963 | |
| 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 | £645 | £2,292 | £5,903 | £12,207 | £18,561 | £24,840 | £31,236 | £37,617 | £43,932 | £50,236 | £56,624 | £62,963 | |
| 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 | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £7,236 | £10,816 | £10,816 | £14,466 | £14,466 | £14,466 | |
| Bill Payments | £51 | £1,660 | £5,734 | £7,687 | £9,588 | £11,594 | £13,577 | £15,255 | £16,143 | £18,098 | £19,006 | £20,942 | |
| Subtotal Spent on Operations | £6,201 | £7,810 | £11,884 | £13,837 | £15,738 | £17,744 | £20,813 | £26,071 | £26,959 | £32,564 | £33,472 | £35,408 | |
| 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 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | |
| 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 | £8,493 | £10,102 | £14,176 | £16,129 | £18,030 | £20,036 | £23,105 | £28,363 | £29,251 | £34,856 | £35,764 | £37,700 | |
| Net Cash Flow | (£7,848) | (£7,810) | (£8,272) | (£3,922) | £530 | £4,804 | £8,131 | £9,254 | £14,681 | £15,379 | £20,860 | £25,263 | |
| Cash Balance | £61,152 | £53,342 | £45,070 | £41,148 | £41,678 | £46,482 | £54,613 | £63,867 | £78,548 | £93,927 | £114,787 | £140,050 | |
| 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 | £69,000 | £61,152 | £53,342 | £45,070 | £41,148 | £41,678 | £46,482 | £54,613 | £63,867 | £78,548 | £93,927 | £114,787 | £140,050 |
| Accounts Receivable | £0 | £1,935 | £8,553 | £17,890 | £27,148 | £36,487 | £45,968 | £55,332 | £64,595 | £73,963 | £83,388 | £92,724 | £102,001 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £69,000 | £63,087 | £61,895 | £62,960 | £68,296 | £78,165 | £92,450 | £109,945 | £128,462 | £152,511 | £177,315 | £207,511 | £242,051 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 |
| Accumulated Depreciation | £0 | £0 | £386 | £772 | £1,158 | £1,545 | £1,931 | £2,317 | £2,703 | £3,089 | £3,475 | £3,862 | £4,248 |
| Total Long-term Assets | £104,000 | £104,000 | £103,614 | £103,228 | £102,842 | £102,455 | £102,069 | £101,683 | £101,297 | £100,911 | £100,525 | £100,138 | £99,752 |
| Total Assets | £173,000 | £167,087 | £165,509 | £166,187 | £171,137 | £180,621 | £194,519 | £211,628 | £229,759 | £253,422 | £277,839 | £307,649 | £341,803 |
| 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 | £1,471 | £5,479 | £7,370 | £9,204 | £11,143 | £13,069 | £14,719 | £15,541 | £17,467 | £18,310 | £20,182 | £22,042 |
| 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 | £1,471 | £5,479 | £7,370 | £9,204 | £11,143 | £13,069 | £14,719 | £15,541 | £17,467 | £18,310 | £20,182 | £22,042 |
| Long-term Liabilities | £164,000 | £161,708 | £159,416 | £157,124 | £154,832 | £152,540 | £150,248 | £147,956 | £145,664 | £143,372 | £141,080 | £138,788 | £136,496 |
| Total Liabilities | £164,000 | £163,179 | £164,895 | £164,494 | £164,036 | £163,683 | £163,317 | £162,675 | £161,205 | £160,839 | £159,390 | £158,970 | £158,538 |
| Paid-in Capital | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 |
| Retained Earnings | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) |
| Earnings | £0 | (£5,092) | (£8,387) | (£7,306) | (£1,899) | £7,938 | £22,201 | £39,953 | £59,554 | £83,583 | £109,449 | £139,679 | £174,265 |
| Total Capital | £9,000 | £3,908 | £613 | £1,694 | £7,101 | £16,938 | £31,201 | £48,953 | £68,554 | £92,583 | £118,449 | £148,679 | £183,265 |
| Total Liabilities and Capital | £173,000 | £167,087 | £165,509 | £166,187 | £171,137 | £180,621 | £194,519 | £211,628 | £229,759 | £253,422 | £277,839 | £307,649 | £341,803 |
| Net Worth | £9,000 | £3,908 | £613 | £1,694 | £7,101 | £16,938 | £31,201 | £48,953 | £68,554 | £92,583 | £118,449 | £148,679 | £183,265 |
| 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 | |||||||||||||
| Chiropractic Cases | 0% | £0 | £6,250 | £12,500 | £18,725 | £25,000 | £31,250 | £37,500 | £43,750 | £50,000 | £56,250 | £62,500 | £68,750 |
| Corporate Clients | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Home Exercise Devices | 0% | £300 | £350 | £400 | £400 | £450 | £500 | £500 | £500 | £550 | £550 | £600 | £600 |
| Weight Loss System | 0% | £240 | £240 | £240 | £240 | £320 | £320 | £320 | £320 | £320 | £400 | £400 | £400 |
| Pillows | 0% | £180 | £210 | £240 | £240 | £270 | £270 | £300 | £330 | £330 | £360 | £360 | £390 |
| TENS Units | 0% | £360 | £360 | £360 | £360 | £360 | £480 | £480 | £480 | £600 | £600 | £600 | £600 |
| Total Sales | £2,580 | £8,910 | £15,240 | £21,465 | £27,900 | £34,320 | £40,600 | £46,880 | £53,300 | £59,660 | £65,960 | £72,240 | |
| 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 | |
| Chiropractic Cases | £0 | £63 | £125 | £187 | £250 | £313 | £375 | £438 | £500 | £563 | £625 | £688 | |
| Corporate Clients | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Home Exercise Devices | £138 | £161 | £184 | £184 | £207 | £230 | £230 | £230 | £253 | £253 | £276 | £276 | |
| Weight Loss System | £81 | £81 | £81 | £81 | £108 | £108 | £108 | £108 | £108 | £135 | £135 | £135 | |
| Pillows | £84 | £98 | £112 | £112 | £126 | £126 | £140 | £154 | £154 | £168 | £168 | £182 | |
| TENS Units | £87 | £87 | £87 | £87 | £87 | £116 | £116 | £116 | £145 | £145 | £145 | £145 | |
| Subtotal Direct Cost of Sales | £690 | £790 | £889 | £951 | £1,078 | £1,193 | £1,269 | £1,346 | £1,460 | £1,564 | £1,649 | £1,726 | |
| 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 | ||
| Angelo M. Rubano, Jr. D.C. | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £6,000 | £6,000 | £7,500 | £7,500 | £7,500 |
| Associate Dr. #1 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Associate Dr. #2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Insurance Staff | 0% | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,236 | £2,236 | £2,236 | £2,236 | £2,236 | £2,236 |
| Insurance Staff #2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Front Desk Staff | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,150 | £2,150 | £2,150 |
| Front Desk Staff #2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Chiropractic Assistant #1 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,580 | £2,580 | £2,580 | £2,580 | £2,580 |
| Chiropractic Assistant #2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Chiropractic Assistant #3 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | |
| Total Payroll | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £7,236 | £10,816 | £10,816 | £14,466 | £14,466 | £14,466 | |
| 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 | £2,580 | £8,910 | £15,240 | £21,465 | £27,900 | £34,320 | £40,600 | £46,880 | £53,300 | £59,660 | £65,960 | £72,240 | |
| Direct Cost of Sales | £690 | £790 | £889 | £951 | £1,078 | £1,193 | £1,269 | £1,346 | £1,460 | £1,564 | £1,649 | £1,726 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £690 | £790 | £889 | £951 | £1,078 | £1,193 | £1,269 | £1,346 | £1,460 | £1,564 | £1,649 | £1,726 | |
| Gross Margin | £1,890 | £8,121 | £14,351 | £20,514 | £26,822 | £33,128 | £39,331 | £45,535 | £51,840 | £58,097 | £64,311 | £70,515 | |
| Gross Margin % | 73.26% | 91.14% | 94.17% | 95.57% | 96.14% | 96.53% | 96.87% | 97.13% | 97.26% | 97.38% | 97.50% | 97.61% | |
| Expenses | |||||||||||||
| Payroll | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £7,236 | £10,816 | £10,816 | £14,466 | £14,466 | £14,466 | |
| Marketing/Promotion | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | |
| Depreciation | £0 | £386 | £386 | £386 | £386 | £386 | £386 | £386 | £386 | £386 | £386 | £386 | |
| Rent | £0 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | £1,373 | |
| Utilities | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £154 | £154 | £154 | £154 | £154 | £154 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Office Supplies | £0 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | |
| Legal Fees | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Accounting Fees | £0 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Computer Technical Support | £0 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | |
| XRay Film and Processor Maintenance | £0 | £175 | £175 | £175 | £175 | £175 | £175 | £175 | £175 | £175 | £175 | £175 | |
| Professional Organization Membership | 15% | £0 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 |
| Employee Benefits Package | £0 | £585 | £585 | £585 | £585 | £585 | £585 | £585 | £585 | £585 | £585 | £585 | |
| Total Operating Expenses | £7,817 | £11,499 | £11,499 | £11,499 | £11,499 | £11,499 | £12,739 | £16,319 | £16,319 | £19,969 | £19,969 | £19,969 | |
| Profit Before Interest and Taxes | (£5,927) | (£3,378) | £2,852 | £9,015 | £15,323 | £21,629 | £26,592 | £29,216 | £35,521 | £38,128 | £44,342 | £50,546 | |
| EBITDA | (£5,927) | (£2,992) | £3,239 | £9,401 | £15,710 | £22,015 | £26,978 | £29,602 | £35,907 | £38,514 | £44,728 | £50,932 | |
| Interest Expense | £1,348 | £1,328 | £1,309 | £1,290 | £1,271 | £1,252 | £1,233 | £1,214 | £1,195 | £1,176 | £1,157 | £1,137 | |
| Taxes Incurred | (£2,182) | (£1,412) | £463 | £2,317 | £4,216 | £6,113 | £7,608 | £8,401 | £10,298 | £11,086 | £12,956 | £14,822 | |
| Net Profit | (£5,092) | (£3,295) | £1,080 | £5,407 | £9,837 | £14,264 | £17,752 | £19,601 | £24,029 | £25,866 | £30,230 | £34,586 | |
| Net Profit/Sales | -197.36% | -36.98% | 7.09% | 25.19% | 35.26% | 41.56% | 43.72% | 41.81% | 45.08% | 43.36% | 45.83% | 47.88% | |
| 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 | £645 | £2,228 | £3,810 | £5,366 | £6,975 | £8,580 | £10,150 | £11,720 | £13,325 | £14,915 | £16,490 | £18,060 | |
| Cash from Receivables | £0 | £65 | £2,093 | £6,841 | £11,586 | £16,260 | £21,086 | £25,897 | £30,607 | £35,321 | £40,134 | £44,903 | |
| Subtotal Cash from Operations | £645 | £2,292 | £5,903 | £12,207 | £18,561 | £24,840 | £31,236 | £37,617 | £43,932 | £50,236 | £56,624 | £62,963 | |
| 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 | £645 | £2,292 | £5,903 | £12,207 | £18,561 | £24,840 | £31,236 | £37,617 | £43,932 | £50,236 | £56,624 | £62,963 | |
| 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 | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £6,150 | £7,236 | £10,816 | £10,816 | £14,466 | £14,466 | £14,466 | |
| Bill Payments | £51 | £1,660 | £5,734 | £7,687 | £9,588 | £11,594 | £13,577 | £15,255 | £16,143 | £18,098 | £19,006 | £20,942 | |
| Subtotal Spent on Operations | £6,201 | £7,810 | £11,884 | £13,837 | £15,738 | £17,744 | £20,813 | £26,071 | £26,959 | £32,564 | £33,472 | £35,408 | |
| 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 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | £2,292 | |
| 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 | £8,493 | £10,102 | £14,176 | £16,129 | £18,030 | £20,036 | £23,105 | £28,363 | £29,251 | £34,856 | £35,764 | £37,700 | |
| Net Cash Flow | (£7,848) | (£7,810) | (£8,272) | (£3,922) | £530 | £4,804 | £8,131 | £9,254 | £14,681 | £15,379 | £20,860 | £25,263 | |
| Cash Balance | £61,152 | £53,342 | £45,070 | £41,148 | £41,678 | £46,482 | £54,613 | £63,867 | £78,548 | £93,927 | £114,787 | £140,050 | |
| 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 | £69,000 | £61,152 | £53,342 | £45,070 | £41,148 | £41,678 | £46,482 | £54,613 | £63,867 | £78,548 | £93,927 | £114,787 | £140,050 |
| Accounts Receivable | £0 | £1,935 | £8,553 | £17,890 | £27,148 | £36,487 | £45,968 | £55,332 | £64,595 | £73,963 | £83,388 | £92,724 | £102,001 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £69,000 | £63,087 | £61,895 | £62,960 | £68,296 | £78,165 | £92,450 | £109,945 | £128,462 | £152,511 | £177,315 | £207,511 | £242,051 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 | £104,000 |
| Accumulated Depreciation | £0 | £0 | £386 | £772 | £1,158 | £1,545 | £1,931 | £2,317 | £2,703 | £3,089 | £3,475 | £3,862 | £4,248 |
| Total Long-term Assets | £104,000 | £104,000 | £103,614 | £103,228 | £102,842 | £102,455 | £102,069 | £101,683 | £101,297 | £100,911 | £100,525 | £100,138 | £99,752 |
| Total Assets | £173,000 | £167,087 | £165,509 | £166,187 | £171,137 | £180,621 | £194,519 | £211,628 | £229,759 | £253,422 | £277,839 | £307,649 | £341,803 |
| 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 | £1,471 | £5,479 | £7,370 | £9,204 | £11,143 | £13,069 | £14,719 | £15,541 | £17,467 | £18,310 | £20,182 | £22,042 |
| 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 | £1,471 | £5,479 | £7,370 | £9,204 | £11,143 | £13,069 | £14,719 | £15,541 | £17,467 | £18,310 | £20,182 | £22,042 |
| Long-term Liabilities | £164,000 | £161,708 | £159,416 | £157,124 | £154,832 | £152,540 | £150,248 | £147,956 | £145,664 | £143,372 | £141,080 | £138,788 | £136,496 |
| Total Liabilities | £164,000 | £163,179 | £164,895 | £164,494 | £164,036 | £163,683 | £163,317 | £162,675 | £161,205 | £160,839 | £159,390 | £158,970 | £158,538 |
| Paid-in Capital | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 | £43,575 |
| Retained Earnings | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) | (£34,575) |
| Earnings | £0 | (£5,092) | (£8,387) | (£7,306) | (£1,899) | £7,938 | £22,201 | £39,953 | £59,554 | £83,583 | £109,449 | £139,679 | £174,265 |
| Total Capital | £9,000 | £3,908 | £613 | £1,694 | £7,101 | £16,938 | £31,201 | £48,953 | £68,554 | £92,583 | £118,449 | £148,679 | £183,265 |
| Total Liabilities and Capital | £173,000 | £167,087 | £165,509 | £166,187 | £171,137 | £180,621 | £194,519 | £211,628 | £229,759 | £253,422 | £277,839 | £307,649 | £341,803 |
| Net Worth | £9,000 | £3,908 | £613 | £1,694 | £7,101 | £16,938 | £31,201 | £48,953 | £68,554 | £92,583 | £118,449 | £148,679 | £183,265 |