| 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 | ||
| Unit Sales | |||||||||||||
| Psychotherapy | 0% | 482 | 482 | 482 | 482 | 482 | 482 | 482 | 482 | 482 | 482 | 482 | 482 |
| Psychopharmacology/MD | 0% | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 |
| Psychopharmacology/CNS | 0% | 86 | 86 | 86 | 86 | 86 | 86 | 146 | 146 | 146 | 146 | 146 | 146 |
| Addictions/3 hr IOP | 0% | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 |
| Addictions/1hr IOP | 0% | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 |
| Contracts | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 853 | 853 | 853 | 853 | 853 | 853 | 913 | 913 | 913 | 913 | 913 | 913 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Psychotherapy | £64.00 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 |
| Psychopharmacology/MD | £44.00 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 |
| Psychopharmacology/CNS | £35.00 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 |
| Addictions/3 hr IOP | £83.00 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 |
| Addictions/1hr IOP | £24.00 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 |
| Contracts | £64.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| Psychotherapy | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | |
| Psychopharmacology/MD | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | |
| Psychopharmacology/CNS | £2,794 | £2,794 | £2,794 | £2,794 | £2,794 | £2,794 | £4,752 | £4,752 | £4,752 | £4,752 | £4,752 | £4,752 | |
| Addictions/3 hr IOP | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | |
| Addictions/1hr IOP | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | |
| Contracts | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £43,163 | £43,163 | £43,163 | £43,163 | £43,163 | £43,163 | £45,122 | £45,122 | £45,122 | £45,122 | £45,122 | £45,122 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Psychotherapy | 60.00% | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 |
| Psychopharmacology/MD | 70.00% | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 |
| Psychopharmacology/CNS | 60.00% | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 |
| Addictions/3 hr IOP | 17.00% | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 |
| Addictions/1hr IOP | 22.00% | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 |
| Contracts | 60.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Psychotherapy | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | |
| Psychopharmacology/MD | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | |
| Psychopharmacology/CNS | £1,676 | £1,676 | £1,676 | £1,676 | £1,676 | £1,676 | £2,851 | £2,851 | £2,851 | £2,851 | £2,851 | £2,851 | |
| Addictions/3 hr IOP | £339 | £339 | £339 | £339 | £339 | £339 | £339 | £339 | £339 | £339 | £339 | £339 | |
| Addictions/1hr IOP | £241 | £241 | £241 | £241 | £241 | £241 | £241 | £241 | £241 | £241 | £241 | £241 | |
| Contracts | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | |
| 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 | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | |
| Long-term Interest Rate | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | |
| Tax Rate | 30.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.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 | £43,163 | £43,163 | £43,163 | £43,163 | £43,163 | £43,163 | £45,122 | £45,122 | £45,122 | £45,122 | £45,122 | £45,122 | |
| Direct Cost of Sales | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | |
| Gross Margin | £17,679 | £17,679 | £17,679 | £17,679 | £17,679 | £17,679 | £18,462 | £18,462 | £18,462 | £18,462 | £18,462 | £18,462 | |
| Gross Margin % | 40.96% | 40.96% | 40.96% | 40.96% | 40.96% | 40.96% | 40.92% | 40.92% | 40.92% | 40.92% | 40.92% | 40.92% | |
| Expenses | |||||||||||||
| Payroll | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | |
| Marketing/Promotion | £675 | £675 | £675 | £675 | £675 | £625 | £625 | £625 | £625 | £625 | £625 | £575 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Billing Fees (6% of billed plus 1.5% copays) | £53 | £665 | £1,685 | £2,093 | £2,096 | £2,104 | £2,131 | £2,174 | £2,217 | £2,385 | £2,628 | £2,720 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £200 | |
| Rent | £916 | £916 | £916 | £916 | £916 | £916 | £916 | £916 | £916 | £916 | £916 | £916 | |
| Human Resource/HR Logic | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Med Dir.,Multidisc.,RNCS Sup. | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Telephone | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Postage | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £50 | £50 | £50 | |
| Office Supplies | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £230 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Contract/Consultants | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £837 | |
| Total Operating Expenses | £13,602 | £14,214 | £15,234 | £15,642 | £15,645 | £15,603 | £15,630 | £15,673 | £15,716 | £15,834 | £16,077 | £15,923 | |
| Profit Before Interest and Taxes | £4,077 | £3,465 | £2,445 | £2,037 | £2,034 | £2,076 | £2,832 | £2,789 | £2,746 | £2,628 | £2,385 | £2,539 | |
| EBITDA | £4,077 | £3,465 | £2,445 | £2,037 | £2,034 | £2,076 | £2,832 | £2,789 | £2,746 | £2,628 | £2,385 | £2,539 | |
| Interest Expense | £400 | £394 | £388 | £382 | £376 | £370 | £364 | £358 | £351 | £345 | £339 | £333 | |
| Taxes Incurred | £1,103 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | £2,574 | £3,071 | £2,057 | £1,655 | £1,658 | £1,706 | £2,469 | £2,432 | £2,395 | £2,283 | £2,046 | £2,206 | |
| Net Profit/Sales | 5.96% | 7.11% | 4.77% | 3.83% | 3.84% | 3.95% | 5.47% | 5.39% | 5.31% | 5.06% | 4.53% | 4.89% | |
| 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 | £4,316 | £4,316 | £4,316 | £4,316 | £4,316 | £4,316 | £4,512 | £4,512 | £4,512 | £4,512 | £4,512 | £4,512 | |
| Cash from Receivables | £0 | £0 | £1,295 | £38,847 | £38,847 | £38,847 | £38,847 | £38,847 | £38,906 | £40,610 | £40,610 | £40,610 | |
| Subtotal Cash from Operations | £4,316 | £4,316 | £5,611 | £43,163 | £43,163 | £43,163 | £43,359 | £43,359 | £43,418 | £45,122 | £45,122 | £45,122 | |
| 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 | £4,316 | £4,316 | £5,611 | £43,163 | £43,163 | £43,163 | £43,359 | £43,359 | £43,418 | £45,122 | £45,122 | £45,122 | |
| 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 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | |
| Bill Payments | £1,076 | £32,261 | £31,815 | £32,808 | £33,196 | £33,192 | £33,185 | £34,343 | £34,379 | £34,419 | £34,535 | £34,759 | |
| Subtotal Spent on Operations | £9,388 | £40,573 | £40,127 | £41,120 | £41,508 | £41,504 | £41,497 | £42,655 | £42,691 | £42,731 | £42,847 | £43,071 | |
| 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 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| 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,138 | £41,323 | £40,877 | £41,870 | £42,258 | £42,254 | £42,247 | £43,405 | £43,441 | £43,481 | £43,597 | £43,821 | |
| Net Cash Flow | (£5,822) | (£37,007) | (£35,265) | £1,293 | £905 | £910 | £1,112 | (£45) | (£23) | £1,641 | £1,525 | £1,301 | |
| Cash Balance | £95,178 | £58,172 | £22,906 | £24,200 | £25,105 | £26,014 | £27,126 | £27,081 | £27,058 | £28,699 | £30,224 | £31,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 | £101,000 | £95,178 | £58,172 | £22,906 | £24,200 | £25,105 | £26,014 | £27,126 | £27,081 | £27,058 | £28,699 | £30,224 | £31,525 |
| Accounts Receivable | £0 | £38,847 | £77,694 | £115,246 | £115,246 | £115,246 | £115,246 | £117,009 | £118,772 | £120,475 | £120,475 | £120,475 | £120,475 |
| Other Current Assets | £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 |
| Total Current Assets | £106,000 | £139,026 | £140,866 | £143,153 | £144,446 | £145,351 | £146,261 | £149,135 | £150,853 | £152,533 | £154,174 | £155,699 | £157,000 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £106,000 | £139,026 | £140,866 | £143,153 | £144,446 | £145,351 | £146,261 | £149,135 | £150,853 | £152,533 | £154,174 | £155,699 | £157,000 |
| 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 | £31,202 | £30,721 | £31,701 | £32,090 | £32,087 | £32,041 | £33,197 | £33,232 | £33,268 | £33,376 | £33,605 | £33,450 |
| 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 | £31,202 | £30,721 | £31,701 | £32,090 | £32,087 | £32,041 | £33,197 | £33,232 | £33,268 | £33,376 | £33,605 | £33,450 |
| Long-term Liabilities | £50,000 | £49,250 | £48,500 | £47,750 | £47,000 | £46,250 | £45,500 | £44,750 | £44,000 | £43,250 | £42,500 | £41,750 | £41,000 |
| Total Liabilities | £50,000 | £80,452 | £79,221 | £79,451 | £79,090 | £78,337 | £77,541 | £77,947 | £77,232 | £76,518 | £75,876 | £75,355 | £74,450 |
| Paid-in Capital | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 |
| Retained Earnings | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) |
| Earnings | £0 | £2,574 | £5,644 | £7,701 | £9,356 | £11,014 | £12,720 | £15,189 | £17,620 | £20,015 | £22,298 | £24,344 | £26,550 |
| Total Capital | £56,000 | £58,574 | £61,644 | £63,701 | £65,356 | £67,014 | £68,720 | £71,189 | £73,620 | £76,015 | £78,298 | £80,344 | £82,550 |
| Total Liabilities and Capital | £106,000 | £139,026 | £140,866 | £143,153 | £144,446 | £145,351 | £146,261 | £149,135 | £150,853 | £152,533 | £154,174 | £155,699 | £157,000 |
| Net Worth | £56,000 | £58,574 | £61,644 | £63,701 | £65,356 | £67,014 | £68,720 | £71,189 | £73,620 | £76,015 | £78,298 | £80,344 | £82,550 |
| 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 | ||
| Unit Sales | |||||||||||||
| Psychotherapy | 0% | 482 | 482 | 482 | 482 | 482 | 482 | 482 | 482 | 482 | 482 | 482 | 482 |
| Psychopharmacology/MD | 0% | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 |
| Psychopharmacology/CNS | 0% | 86 | 86 | 86 | 86 | 86 | 86 | 146 | 146 | 146 | 146 | 146 | 146 |
| Addictions/3 hr IOP | 0% | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 |
| Addictions/1hr IOP | 0% | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 |
| Contracts | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 853 | 853 | 853 | 853 | 853 | 853 | 913 | 913 | 913 | 913 | 913 | 913 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Psychotherapy | £64.00 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 | £59.52 |
| Psychopharmacology/MD | £44.00 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 | £40.92 |
| Psychopharmacology/CNS | £35.00 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 | £32.55 |
| Addictions/3 hr IOP | £83.00 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 | £77.19 |
| Addictions/1hr IOP | £24.00 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 | £22.32 |
| Contracts | £64.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| Psychotherapy | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | £28,689 | |
| Psychopharmacology/MD | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | £8,593 | |
| Psychopharmacology/CNS | £2,794 | £2,794 | £2,794 | £2,794 | £2,794 | £2,794 | £4,752 | £4,752 | £4,752 | £4,752 | £4,752 | £4,752 | |
| Addictions/3 hr IOP | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | £1,994 | |
| Addictions/1hr IOP | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | £1,094 | |
| Contracts | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £43,163 | £43,163 | £43,163 | £43,163 | £43,163 | £43,163 | £45,122 | £45,122 | £45,122 | £45,122 | £45,122 | £45,122 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Psychotherapy | 60.00% | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 | £35.71 |
| Psychopharmacology/MD | 70.00% | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 | £28.64 |
| Psychopharmacology/CNS | 60.00% | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 | £19.53 |
| Addictions/3 hr IOP | 17.00% | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 | £13.12 |
| Addictions/1hr IOP | 22.00% | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 | £4.91 |
| Contracts | 60.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Psychotherapy | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | £17,213 | |
| Psychopharmacology/MD | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | £6,015 | |
| Psychopharmacology/CNS | £1,676 | £1,676 | £1,676 | £1,676 | £1,676 | £1,676 | £2,851 | £2,851 | £2,851 | £2,851 | £2,851 | £2,851 | |
| Addictions/3 hr IOP | £339 | £339 | £339 | £339 | £339 | £339 | £339 | £339 | £339 | £339 | £339 | £339 | |
| Addictions/1hr IOP | £241 | £241 | £241 | £241 | £241 | £241 | £241 | £241 | £241 | £241 | £241 | £241 | |
| Contracts | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | |
| 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 | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | |
| Long-term Interest Rate | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | 9.75% | |
| Tax Rate | 30.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.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 | £43,163 | £43,163 | £43,163 | £43,163 | £43,163 | £43,163 | £45,122 | £45,122 | £45,122 | £45,122 | £45,122 | £45,122 | |
| Direct Cost of Sales | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £25,484 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | £26,659 | |
| Gross Margin | £17,679 | £17,679 | £17,679 | £17,679 | £17,679 | £17,679 | £18,462 | £18,462 | £18,462 | £18,462 | £18,462 | £18,462 | |
| Gross Margin % | 40.96% | 40.96% | 40.96% | 40.96% | 40.96% | 40.96% | 40.92% | 40.92% | 40.92% | 40.92% | 40.92% | 40.92% | |
| Expenses | |||||||||||||
| Payroll | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | |
| Marketing/Promotion | £675 | £675 | £675 | £675 | £675 | £625 | £625 | £625 | £625 | £625 | £625 | £575 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Billing Fees (6% of billed plus 1.5% copays) | £53 | £665 | £1,685 | £2,093 | £2,096 | £2,104 | £2,131 | £2,174 | £2,217 | £2,385 | £2,628 | £2,720 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £200 | |
| Rent | £916 | £916 | £916 | £916 | £916 | £916 | £916 | £916 | £916 | £916 | £916 | £916 | |
| Human Resource/HR Logic | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Med Dir.,Multidisc.,RNCS Sup. | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Telephone | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Postage | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £50 | £50 | £50 | |
| Office Supplies | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £230 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Contract/Consultants | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £837 | |
| Total Operating Expenses | £13,602 | £14,214 | £15,234 | £15,642 | £15,645 | £15,603 | £15,630 | £15,673 | £15,716 | £15,834 | £16,077 | £15,923 | |
| Profit Before Interest and Taxes | £4,077 | £3,465 | £2,445 | £2,037 | £2,034 | £2,076 | £2,832 | £2,789 | £2,746 | £2,628 | £2,385 | £2,539 | |
| EBITDA | £4,077 | £3,465 | £2,445 | £2,037 | £2,034 | £2,076 | £2,832 | £2,789 | £2,746 | £2,628 | £2,385 | £2,539 | |
| Interest Expense | £400 | £394 | £388 | £382 | £376 | £370 | £364 | £358 | £351 | £345 | £339 | £333 | |
| Taxes Incurred | £1,103 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | £2,574 | £3,071 | £2,057 | £1,655 | £1,658 | £1,706 | £2,469 | £2,432 | £2,395 | £2,283 | £2,046 | £2,206 | |
| Net Profit/Sales | 5.96% | 7.11% | 4.77% | 3.83% | 3.84% | 3.95% | 5.47% | 5.39% | 5.31% | 5.06% | 4.53% | 4.89% | |
| 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 | £4,316 | £4,316 | £4,316 | £4,316 | £4,316 | £4,316 | £4,512 | £4,512 | £4,512 | £4,512 | £4,512 | £4,512 | |
| Cash from Receivables | £0 | £0 | £1,295 | £38,847 | £38,847 | £38,847 | £38,847 | £38,847 | £38,906 | £40,610 | £40,610 | £40,610 | |
| Subtotal Cash from Operations | £4,316 | £4,316 | £5,611 | £43,163 | £43,163 | £43,163 | £43,359 | £43,359 | £43,418 | £45,122 | £45,122 | £45,122 | |
| 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 | £4,316 | £4,316 | £5,611 | £43,163 | £43,163 | £43,163 | £43,359 | £43,359 | £43,418 | £45,122 | £45,122 | £45,122 | |
| 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 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | £8,312 | |
| Bill Payments | £1,076 | £32,261 | £31,815 | £32,808 | £33,196 | £33,192 | £33,185 | £34,343 | £34,379 | £34,419 | £34,535 | £34,759 | |
| Subtotal Spent on Operations | £9,388 | £40,573 | £40,127 | £41,120 | £41,508 | £41,504 | £41,497 | £42,655 | £42,691 | £42,731 | £42,847 | £43,071 | |
| 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 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| 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,138 | £41,323 | £40,877 | £41,870 | £42,258 | £42,254 | £42,247 | £43,405 | £43,441 | £43,481 | £43,597 | £43,821 | |
| Net Cash Flow | (£5,822) | (£37,007) | (£35,265) | £1,293 | £905 | £910 | £1,112 | (£45) | (£23) | £1,641 | £1,525 | £1,301 | |
| Cash Balance | £95,178 | £58,172 | £22,906 | £24,200 | £25,105 | £26,014 | £27,126 | £27,081 | £27,058 | £28,699 | £30,224 | £31,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 | £101,000 | £95,178 | £58,172 | £22,906 | £24,200 | £25,105 | £26,014 | £27,126 | £27,081 | £27,058 | £28,699 | £30,224 | £31,525 |
| Accounts Receivable | £0 | £38,847 | £77,694 | £115,246 | £115,246 | £115,246 | £115,246 | £117,009 | £118,772 | £120,475 | £120,475 | £120,475 | £120,475 |
| Other Current Assets | £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 |
| Total Current Assets | £106,000 | £139,026 | £140,866 | £143,153 | £144,446 | £145,351 | £146,261 | £149,135 | £150,853 | £152,533 | £154,174 | £155,699 | £157,000 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £106,000 | £139,026 | £140,866 | £143,153 | £144,446 | £145,351 | £146,261 | £149,135 | £150,853 | £152,533 | £154,174 | £155,699 | £157,000 |
| 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 | £31,202 | £30,721 | £31,701 | £32,090 | £32,087 | £32,041 | £33,197 | £33,232 | £33,268 | £33,376 | £33,605 | £33,450 |
| 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 | £31,202 | £30,721 | £31,701 | £32,090 | £32,087 | £32,041 | £33,197 | £33,232 | £33,268 | £33,376 | £33,605 | £33,450 |
| Long-term Liabilities | £50,000 | £49,250 | £48,500 | £47,750 | £47,000 | £46,250 | £45,500 | £44,750 | £44,000 | £43,250 | £42,500 | £41,750 | £41,000 |
| Total Liabilities | £50,000 | £80,452 | £79,221 | £79,451 | £79,090 | £78,337 | £77,541 | £77,947 | £77,232 | £76,518 | £75,876 | £75,355 | £74,450 |
| Paid-in Capital | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 |
| Retained Earnings | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) |
| Earnings | £0 | £2,574 | £5,644 | £7,701 | £9,356 | £11,014 | £12,720 | £15,189 | £17,620 | £20,015 | £22,298 | £24,344 | £26,550 |
| Total Capital | £56,000 | £58,574 | £61,644 | £63,701 | £65,356 | £67,014 | £68,720 | £71,189 | £73,620 | £76,015 | £78,298 | £80,344 | £82,550 |
| Total Liabilities and Capital | £106,000 | £139,026 | £140,866 | £143,153 | £144,446 | £145,351 | £146,261 | £149,135 | £150,853 | £152,533 | £154,174 | £155,699 | £157,000 |
| Net Worth | £56,000 | £58,574 | £61,644 | £63,701 | £65,356 | £67,014 | £68,720 | £71,189 | £73,620 | £76,015 | £78,298 | £80,344 | £82,550 |