| 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 | |||||||||||||
| COBRA/HIPAA | 0% | 0 | 0 | 0 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 |
| Flexible Spending | 0% | 0 | 0 | 0 | 10 | 10 | 10 | 10 | 10 | 10 | 40 | 40 | 40 |
| Basic Admin | 0% | 0 | 0 | 0 | 100 | 100 | 100 | 200 | 200 | 200 | 400 | 400 | 400 |
| All Inclusive | 0% | 0 | 0 | 0 | 100 | 100 | 100 | 200 | 200 | 200 | 400 | 400 | 400 |
| Start-up Fees | 0% | 0 | 0 | 0 | 65 | 5 | 5 | 45 | 5 | 5 | 100 | 5 | 5 |
| Total Unit Sales | 0 | 0 | 0 | 295 | 240 | 245 | 490 | 455 | 460 | 990 | 900 | 905 | |
| 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 | |
| COBRA/HIPAA | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | |
| Flexible Spending | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | |
| Basic Admin | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | |
| All Inclusive | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | |
| Start-up Fees | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | |
| Sales | |||||||||||||
| COBRA/HIPAA | £0 | £0 | £0 | £255 | £319 | £383 | £446 | £510 | £574 | £638 | £701 | £765 | |
| Flexible Spending | £0 | £0 | £0 | £75 | £75 | £75 | £75 | £75 | £75 | £300 | £300 | £300 | |
| Basic Admin | £0 | £0 | £0 | £1,200 | £1,200 | £1,200 | £2,400 | £2,400 | £2,400 | £4,800 | £4,800 | £4,800 | |
| All Inclusive | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £3,600 | £3,600 | £3,600 | £7,200 | £7,200 | £7,200 | |
| Start-up Fees | £0 | £0 | £0 | £6,500 | £500 | £500 | £4,500 | £500 | £500 | £10,000 | £500 | £500 | |
| Total Sales | £0 | £0 | £0 | £9,830 | £3,894 | £3,958 | £11,021 | £7,085 | £7,149 | £22,938 | £13,501 | £13,565 | |
| 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 | |
| COBRA/HIPAA | 0.00% | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 |
| Flexible Spending | 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 |
| Basic Admin | 0.00% | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 |
| All Inclusive | 0.00% | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 |
| Start-up Fees | 0.00% | £2.75 | £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 | |||||||||||||
| COBRA/HIPAA | £0 | £0 | £0 | £55 | £69 | £83 | £96 | £110 | £124 | £138 | £151 | £165 | |
| Flexible Spending | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Basic Admin | £0 | £0 | £0 | £275 | £275 | £275 | £550 | £550 | £550 | £1,100 | £1,100 | £1,100 | |
| All Inclusive | £0 | £0 | £0 | £275 | £275 | £275 | £550 | £550 | £550 | £1,100 | £1,100 | £1,100 | |
| Start-up Fees | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £605 | £619 | £633 | £1,196 | £1,210 | £1,224 | £2,338 | £2,351 | £2,365 | |
| 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 | ||
| Production Personnel | |||||||||||||
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales and Marketing Personnel | |||||||||||||
| Marketer Part Time | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| General and Administrative Personnel | |||||||||||||
| Cindy Wells | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Diane Davis | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Administrative Assistant Part Time | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,084 | £1,084 | £1,084 | |
| Benefits Administrator | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Receptionist Part Time | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Benefits Administrator | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £6,084 | £6,084 | £6,084 | |
| Other Personnel | |||||||||||||
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | |
| Total Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £6,084 | £6,084 | £6,084 | |
| 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.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £0 | £9,830 | £3,894 | £3,958 | £11,021 | £7,085 | £7,149 | £22,938 | £13,501 | £13,565 | |
| Direct Cost of Sales | £0 | £0 | £0 | £605 | £619 | £633 | £1,196 | £1,210 | £1,224 | £2,338 | £2,351 | £2,365 | |
| Production Payroll | £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 Cost of Sales | £0 | £0 | £0 | £605 | £619 | £633 | £1,196 | £1,210 | £1,224 | £2,338 | £2,351 | £2,365 | |
| Gross Margin | £0 | £0 | £0 | £9,225 | £3,275 | £3,325 | £9,825 | £5,875 | £5,925 | £20,600 | £11,150 | £11,200 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 93.85% | 84.11% | 84.02% | 89.15% | 82.92% | 82.88% | 89.81% | 82.58% | 82.57% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Advertising/Promotion | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Travel | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Miscellaneous | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Total Sales and Marketing Expenses | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Sales and Marketing % | 0.00% | 0.00% | 0.00% | 1.53% | 3.85% | 3.79% | 1.36% | 2.12% | 2.10% | 0.65% | 1.11% | 1.11% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £6,084 | £6,084 | £6,084 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £85 | £85 | £85 | £85 | £85 | £85 | £85 | £85 | £85 | £85 | £85 | £85 | |
| Dues and Subscriptions | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Professional Fees | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Rent | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Software Purchases | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Telephone and Internet Access | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Miscellaneous | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 8% | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £487 | £487 | £487 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £6,985 | £6,985 | £6,985 | £6,985 | £6,985 | £6,985 | £6,985 | £6,985 | £6,985 | £8,156 | £8,156 | £8,156 | |
| General and Administrative % | 0.00% | 0.00% | 0.00% | 71.06% | 179.39% | 176.50% | 63.38% | 98.59% | 97.71% | 35.56% | 60.41% | 60.12% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Contract/Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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% | |
| Total Operating Expenses | £7,135 | £7,135 | £7,135 | £7,135 | £7,135 | £7,135 | £7,135 | £7,135 | £7,135 | £8,306 | £8,306 | £8,306 | |
| Profit Before Interest and Taxes | (£7,135) | (£7,135) | (£7,135) | £2,090 | (£3,860) | (£3,810) | £2,690 | (£1,260) | (£1,210) | £12,294 | £2,844 | £2,894 | |
| EBITDA | (£7,050) | (£7,050) | (£7,050) | £2,175 | (£3,775) | (£3,725) | £2,775 | (£1,175) | (£1,125) | £12,379 | £2,929 | £2,979 | |
| Interest Expense | £0 | £375 | £375 | £370 | £365 | £360 | £355 | £350 | £345 | £339 | £334 | £329 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£7,135) | (£7,510) | (£7,510) | £1,720 | (£4,225) | (£4,170) | £2,335 | (£1,610) | (£1,555) | £11,955 | £2,510 | £2,565 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 17.50% | -108.51% | -105.37% | 21.19% | -22.72% | -21.75% | 52.12% | 18.59% | 18.91% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £328 | £9,632 | £3,896 | £4,193 | £10,890 | £7,087 | £7,675 | £22,623 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £328 | £9,632 | £3,896 | £4,193 | £10,890 | £7,087 | £7,675 | £22,623 | |
| 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 | £50,000 | £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 | £50,000 | £0 | £0 | £328 | £9,632 | £3,896 | £4,193 | £10,890 | £7,087 | £7,675 | £22,623 | |
| 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 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £6,084 | £6,084 | £6,084 | |
| Bill Payments | £68 | £2,063 | £2,425 | £2,445 | £3,025 | £3,034 | £3,061 | £3,601 | £3,610 | £3,658 | £4,814 | £4,822 | |
| Subtotal Spent on Operations | £5,068 | £7,063 | £7,425 | £7,445 | £8,025 | £8,034 | £8,061 | £8,601 | £8,610 | £9,742 | £10,898 | £10,906 | |
| 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 | £663 | £669 | £673 | £678 | £683 | £688 | £693 | £699 | £704 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £5,068 | £7,063 | £7,425 | £8,108 | £8,694 | £8,707 | £8,739 | £9,284 | £9,298 | £10,435 | £11,597 | £11,610 | |
| Net Cash Flow | (£5,068) | £42,938 | (£7,425) | (£8,108) | (£8,367) | £925 | (£4,843) | (£5,091) | £1,592 | (£3,348) | (£3,922) | £11,013 | |
| Cash Balance | £5,932 | £48,869 | £41,444 | £33,336 | £24,970 | £25,895 | £21,051 | £15,960 | £17,552 | £14,204 | £10,282 | £21,295 | |
| 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 | £11,000 | £5,932 | £48,869 | £41,444 | £33,336 | £24,970 | £25,895 | £21,051 | £15,960 | £17,552 | £14,204 | £10,282 | £21,295 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £9,830 | £13,396 | £7,721 | £14,847 | £17,739 | £13,998 | £29,848 | £35,674 | £26,616 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £11,000 | £5,932 | £48,869 | £41,444 | £43,166 | £38,366 | £33,616 | £35,898 | £33,699 | £31,550 | £44,052 | £45,956 | £47,911 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £85 | £170 | £255 | £340 | £425 | £510 | £595 | £680 | £765 | £850 | £935 | £1,020 |
| Total Long-term Assets | £0 | (£85) | (£170) | (£255) | (£340) | (£425) | (£510) | (£595) | (£680) | (£765) | (£850) | (£935) | (£1,020) |
| Total Assets | £11,000 | £5,847 | £48,699 | £41,189 | £42,826 | £37,941 | £33,106 | £35,303 | £33,019 | £30,785 | £43,202 | £45,021 | £46,891 |
| 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,982 | £2,344 | £2,344 | £2,924 | £2,933 | £2,941 | £3,481 | £3,489 | £3,498 | £4,653 | £4,661 | £4,670 |
| Current Borrowing | £0 | £0 | £50,000 | £50,000 | £49,337 | £48,668 | £47,995 | £47,317 | £46,634 | £45,946 | £45,253 | £44,554 | £43,850 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £1,982 | £52,344 | £52,344 | £52,261 | £51,601 | £50,936 | £50,798 | £50,123 | £49,444 | £49,906 | £49,215 | £48,520 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,982 | £52,344 | £52,344 | £52,261 | £51,601 | £50,936 | £50,798 | £50,123 | £49,444 | £49,906 | £49,215 | £48,520 |
| Paid-in Capital | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 |
| Retained Earnings | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) |
| Earnings | £0 | (£7,135) | (£14,645) | (£22,155) | (£20,435) | (£24,660) | (£28,830) | (£26,495) | (£28,105) | (£29,659) | (£17,704) | (£15,194) | (£12,629) |
| Total Capital | £11,000 | £3,865 | (£3,645) | (£11,155) | (£9,435) | (£13,660) | (£17,830) | (£15,495) | (£17,105) | (£18,659) | (£6,704) | (£4,194) | (£1,629) |
| Total Liabilities and Capital | £11,000 | £5,847 | £48,699 | £41,189 | £42,826 | £37,941 | £33,106 | £35,303 | £33,019 | £30,785 | £43,202 | £45,021 | £46,891 |
| Net Worth | £11,000 | £3,865 | (£3,645) | (£11,155) | (£9,435) | (£13,660) | (£17,830) | (£15,495) | (£17,105) | (£18,659) | (£6,704) | (£4,194) | (£1,629) |
| 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 | |||||||||||||
| COBRA/HIPAA | 0% | 0 | 0 | 0 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 |
| Flexible Spending | 0% | 0 | 0 | 0 | 10 | 10 | 10 | 10 | 10 | 10 | 40 | 40 | 40 |
| Basic Admin | 0% | 0 | 0 | 0 | 100 | 100 | 100 | 200 | 200 | 200 | 400 | 400 | 400 |
| All Inclusive | 0% | 0 | 0 | 0 | 100 | 100 | 100 | 200 | 200 | 200 | 400 | 400 | 400 |
| Start-up Fees | 0% | 0 | 0 | 0 | 65 | 5 | 5 | 45 | 5 | 5 | 100 | 5 | 5 |
| Total Unit Sales | 0 | 0 | 0 | 295 | 240 | 245 | 490 | 455 | 460 | 990 | 900 | 905 | |
| 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 | |
| COBRA/HIPAA | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | £12.75 | |
| Flexible Spending | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | £7.50 | |
| Basic Admin | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | |
| All Inclusive | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | £18.00 | |
| Start-up Fees | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | |
| Sales | |||||||||||||
| COBRA/HIPAA | £0 | £0 | £0 | £255 | £319 | £383 | £446 | £510 | £574 | £638 | £701 | £765 | |
| Flexible Spending | £0 | £0 | £0 | £75 | £75 | £75 | £75 | £75 | £75 | £300 | £300 | £300 | |
| Basic Admin | £0 | £0 | £0 | £1,200 | £1,200 | £1,200 | £2,400 | £2,400 | £2,400 | £4,800 | £4,800 | £4,800 | |
| All Inclusive | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £3,600 | £3,600 | £3,600 | £7,200 | £7,200 | £7,200 | |
| Start-up Fees | £0 | £0 | £0 | £6,500 | £500 | £500 | £4,500 | £500 | £500 | £10,000 | £500 | £500 | |
| Total Sales | £0 | £0 | £0 | £9,830 | £3,894 | £3,958 | £11,021 | £7,085 | £7,149 | £22,938 | £13,501 | £13,565 | |
| 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 | |
| COBRA/HIPAA | 0.00% | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 |
| Flexible Spending | 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 |
| Basic Admin | 0.00% | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 |
| All Inclusive | 0.00% | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 | £2.75 |
| Start-up Fees | 0.00% | £2.75 | £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 | |||||||||||||
| COBRA/HIPAA | £0 | £0 | £0 | £55 | £69 | £83 | £96 | £110 | £124 | £138 | £151 | £165 | |
| Flexible Spending | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Basic Admin | £0 | £0 | £0 | £275 | £275 | £275 | £550 | £550 | £550 | £1,100 | £1,100 | £1,100 | |
| All Inclusive | £0 | £0 | £0 | £275 | £275 | £275 | £550 | £550 | £550 | £1,100 | £1,100 | £1,100 | |
| Start-up Fees | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £605 | £619 | £633 | £1,196 | £1,210 | £1,224 | £2,338 | £2,351 | £2,365 | |
| 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 | ||
| Production Personnel | |||||||||||||
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales and Marketing Personnel | |||||||||||||
| Marketer Part Time | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| General and Administrative Personnel | |||||||||||||
| Cindy Wells | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Diane Davis | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Administrative Assistant Part Time | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,084 | £1,084 | £1,084 | |
| Benefits Administrator | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Receptionist Part Time | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Benefits Administrator | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £6,084 | £6,084 | £6,084 | |
| Other Personnel | |||||||||||||
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | |
| Total Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £6,084 | £6,084 | £6,084 | |
| 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.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £0 | £9,830 | £3,894 | £3,958 | £11,021 | £7,085 | £7,149 | £22,938 | £13,501 | £13,565 | |
| Direct Cost of Sales | £0 | £0 | £0 | £605 | £619 | £633 | £1,196 | £1,210 | £1,224 | £2,338 | £2,351 | £2,365 | |
| Production Payroll | £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 Cost of Sales | £0 | £0 | £0 | £605 | £619 | £633 | £1,196 | £1,210 | £1,224 | £2,338 | £2,351 | £2,365 | |
| Gross Margin | £0 | £0 | £0 | £9,225 | £3,275 | £3,325 | £9,825 | £5,875 | £5,925 | £20,600 | £11,150 | £11,200 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 93.85% | 84.11% | 84.02% | 89.15% | 82.92% | 82.88% | 89.81% | 82.58% | 82.57% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Advertising/Promotion | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Travel | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Miscellaneous | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Total Sales and Marketing Expenses | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Sales and Marketing % | 0.00% | 0.00% | 0.00% | 1.53% | 3.85% | 3.79% | 1.36% | 2.12% | 2.10% | 0.65% | 1.11% | 1.11% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £6,084 | £6,084 | £6,084 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £85 | £85 | £85 | £85 | £85 | £85 | £85 | £85 | £85 | £85 | £85 | £85 | |
| Dues and Subscriptions | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Professional Fees | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Rent | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Software Purchases | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Telephone and Internet Access | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Miscellaneous | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 8% | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £487 | £487 | £487 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £6,985 | £6,985 | £6,985 | £6,985 | £6,985 | £6,985 | £6,985 | £6,985 | £6,985 | £8,156 | £8,156 | £8,156 | |
| General and Administrative % | 0.00% | 0.00% | 0.00% | 71.06% | 179.39% | 176.50% | 63.38% | 98.59% | 97.71% | 35.56% | 60.41% | 60.12% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Contract/Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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% | |
| Total Operating Expenses | £7,135 | £7,135 | £7,135 | £7,135 | £7,135 | £7,135 | £7,135 | £7,135 | £7,135 | £8,306 | £8,306 | £8,306 | |
| Profit Before Interest and Taxes | (£7,135) | (£7,135) | (£7,135) | £2,090 | (£3,860) | (£3,810) | £2,690 | (£1,260) | (£1,210) | £12,294 | £2,844 | £2,894 | |
| EBITDA | (£7,050) | (£7,050) | (£7,050) | £2,175 | (£3,775) | (£3,725) | £2,775 | (£1,175) | (£1,125) | £12,379 | £2,929 | £2,979 | |
| Interest Expense | £0 | £375 | £375 | £370 | £365 | £360 | £355 | £350 | £345 | £339 | £334 | £329 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£7,135) | (£7,510) | (£7,510) | £1,720 | (£4,225) | (£4,170) | £2,335 | (£1,610) | (£1,555) | £11,955 | £2,510 | £2,565 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 17.50% | -108.51% | -105.37% | 21.19% | -22.72% | -21.75% | 52.12% | 18.59% | 18.91% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £328 | £9,632 | £3,896 | £4,193 | £10,890 | £7,087 | £7,675 | £22,623 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £328 | £9,632 | £3,896 | £4,193 | £10,890 | £7,087 | £7,675 | £22,623 | |
| 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 | £50,000 | £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 | £50,000 | £0 | £0 | £328 | £9,632 | £3,896 | £4,193 | £10,890 | £7,087 | £7,675 | £22,623 | |
| 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 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £6,084 | £6,084 | £6,084 | |
| Bill Payments | £68 | £2,063 | £2,425 | £2,445 | £3,025 | £3,034 | £3,061 | £3,601 | £3,610 | £3,658 | £4,814 | £4,822 | |
| Subtotal Spent on Operations | £5,068 | £7,063 | £7,425 | £7,445 | £8,025 | £8,034 | £8,061 | £8,601 | £8,610 | £9,742 | £10,898 | £10,906 | |
| 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 | £663 | £669 | £673 | £678 | £683 | £688 | £693 | £699 | £704 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £5,068 | £7,063 | £7,425 | £8,108 | £8,694 | £8,707 | £8,739 | £9,284 | £9,298 | £10,435 | £11,597 | £11,610 | |
| Net Cash Flow | (£5,068) | £42,938 | (£7,425) | (£8,108) | (£8,367) | £925 | (£4,843) | (£5,091) | £1,592 | (£3,348) | (£3,922) | £11,013 | |
| Cash Balance | £5,932 | £48,869 | £41,444 | £33,336 | £24,970 | £25,895 | £21,051 | £15,960 | £17,552 | £14,204 | £10,282 | £21,295 | |
| 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 | £11,000 | £5,932 | £48,869 | £41,444 | £33,336 | £24,970 | £25,895 | £21,051 | £15,960 | £17,552 | £14,204 | £10,282 | £21,295 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £9,830 | £13,396 | £7,721 | £14,847 | £17,739 | £13,998 | £29,848 | £35,674 | £26,616 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £11,000 | £5,932 | £48,869 | £41,444 | £43,166 | £38,366 | £33,616 | £35,898 | £33,699 | £31,550 | £44,052 | £45,956 | £47,911 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £85 | £170 | £255 | £340 | £425 | £510 | £595 | £680 | £765 | £850 | £935 | £1,020 |
| Total Long-term Assets | £0 | (£85) | (£170) | (£255) | (£340) | (£425) | (£510) | (£595) | (£680) | (£765) | (£850) | (£935) | (£1,020) |
| Total Assets | £11,000 | £5,847 | £48,699 | £41,189 | £42,826 | £37,941 | £33,106 | £35,303 | £33,019 | £30,785 | £43,202 | £45,021 | £46,891 |
| 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,982 | £2,344 | £2,344 | £2,924 | £2,933 | £2,941 | £3,481 | £3,489 | £3,498 | £4,653 | £4,661 | £4,670 |
| Current Borrowing | £0 | £0 | £50,000 | £50,000 | £49,337 | £48,668 | £47,995 | £47,317 | £46,634 | £45,946 | £45,253 | £44,554 | £43,850 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £1,982 | £52,344 | £52,344 | £52,261 | £51,601 | £50,936 | £50,798 | £50,123 | £49,444 | £49,906 | £49,215 | £48,520 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,982 | £52,344 | £52,344 | £52,261 | £51,601 | £50,936 | £50,798 | £50,123 | £49,444 | £49,906 | £49,215 | £48,520 |
| Paid-in Capital | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 | £31,428 |
| Retained Earnings | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) | (£20,428) |
| Earnings | £0 | (£7,135) | (£14,645) | (£22,155) | (£20,435) | (£24,660) | (£28,830) | (£26,495) | (£28,105) | (£29,659) | (£17,704) | (£15,194) | (£12,629) |
| Total Capital | £11,000 | £3,865 | (£3,645) | (£11,155) | (£9,435) | (£13,660) | (£17,830) | (£15,495) | (£17,105) | (£18,659) | (£6,704) | (£4,194) | (£1,629) |
| Total Liabilities and Capital | £11,000 | £5,847 | £48,699 | £41,189 | £42,826 | £37,941 | £33,106 | £35,303 | £33,019 | £30,785 | £43,202 | £45,021 | £46,891 |
| Net Worth | £11,000 | £3,865 | (£3,645) | (£11,155) | (£9,435) | (£13,660) | (£17,830) | (£15,495) | (£17,105) | (£18,659) | (£6,704) | (£4,194) | (£1,629) |