| 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 | |||||||||||||
| Average Visits Per Month | 0% | 50 | 60 | 72 | 86 | 104 | 124 | 149 | 179 | 215 | 258 | 310 | 372 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 50 | 60 | 72 | 86 | 104 | 124 | 149 | 179 | 215 | 258 | 310 | 372 | |
| 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 | |
| Average Visits Per Month | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.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 | |||||||||||||
| Average Visits Per Month | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| 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 | |
| Average Visits Per Month | 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 |
| 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 | |||||||||||||
| Average Visits Per Month | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Dr. Azzato | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Receptionist/Clinician's Assistant | 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 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Sales and Marketing and Other Expenses | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Utilities & Phone | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Payroll Taxes | 15% | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Other (misc) | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | |
| Total Operating Expenses | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | |
| Profit Before Interest and Taxes | (£4,275) | (£3,775) | (£3,175) | (£2,475) | (£1,575) | (£575) | £675 | £2,175 | £3,975 | £6,125 | £8,725 | £11,825 | |
| EBITDA | (£4,275) | (£3,775) | (£3,175) | (£2,475) | (£1,575) | (£575) | £675 | £2,175 | £3,975 | £6,125 | £8,725 | £11,825 | |
| Interest Expense | £245 | £240 | £235 | £229 | £224 | £219 | £214 | £209 | £204 | £186 | £181 | £176 | |
| Taxes Incurred | (£1,356) | (£1,204) | (£1,023) | (£811) | (£540) | (£238) | £138 | £590 | £1,131 | £1,782 | £2,563 | £3,495 | |
| Net Profit | (£3,164) | (£2,810) | (£2,387) | (£1,893) | (£1,259) | (£556) | £323 | £1,376 | £2,640 | £4,157 | £5,981 | £8,155 | |
| Net Profit/Sales | -126.56% | -93.68% | -66.30% | -44.02% | -24.22% | -8.96% | 4.33% | 15.38% | 24.56% | 32.23% | 38.59% | 43.84% | |
| 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 | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| Subtotal Cash from Operations | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| 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 | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| 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 | £5,000 | £5,000 | £5,000 | |
| Bill Payments | £22 | £669 | £816 | £994 | £1,202 | £1,469 | £1,768 | £2,142 | £2,591 | £3,131 | £3,768 | £4,550 | |
| Subtotal Spent on Operations | £5,022 | £5,669 | £5,816 | £5,994 | £6,202 | £6,469 | £6,768 | £7,142 | £7,591 | £8,131 | £8,768 | £9,550 | |
| 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 | £620 | £620 | £620 | £620 | £620 | £620 | £620 | £620 | £620 | £2,120 | £620 | £620 | |
| 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,642 | £6,289 | £6,436 | £6,614 | £6,822 | £7,089 | £7,388 | £7,762 | £8,211 | £10,251 | £9,388 | £10,170 | |
| Net Cash Flow | (£3,142) | (£3,289) | (£2,836) | (£2,314) | (£1,622) | (£889) | £62 | £1,188 | £2,539 | £2,649 | £6,112 | £8,430 | |
| Cash Balance | £11,858 | £8,569 | £5,733 | £3,419 | £1,798 | £908 | £970 | £2,158 | £4,697 | £7,345 | £13,457 | £21,887 | |
| 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 | £15,000 | £11,858 | £8,569 | £5,733 | £3,419 | £1,798 | £908 | £970 | £2,158 | £4,697 | £7,345 | £13,457 | £21,887 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £15,000 | £11,858 | £8,569 | £5,733 | £3,419 | £1,798 | £908 | £970 | £2,158 | £4,697 | £7,345 | £13,457 | £21,887 |
| 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 | £15,000 | £11,858 | £8,569 | £5,733 | £3,419 | £1,798 | £908 | £970 | £2,158 | £4,697 | £7,345 | £13,457 | £21,887 |
| 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 | £642 | £783 | £954 | £1,153 | £1,411 | £1,697 | £2,056 | £2,488 | £3,006 | £3,618 | £4,368 | £5,264 |
| Current Borrowing | £30,000 | £29,380 | £28,760 | £28,140 | £27,520 | £26,900 | £26,280 | £25,660 | £25,040 | £24,420 | £22,300 | £21,680 | £21,060 |
| Other Current Liabilities | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Subtotal Current Liabilities | £45,000 | £45,022 | £44,543 | £44,094 | £43,673 | £43,311 | £42,977 | £42,716 | £42,528 | £42,426 | £40,918 | £41,048 | £41,324 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £45,000 | £45,022 | £44,543 | £44,094 | £43,673 | £43,311 | £42,977 | £42,716 | £42,528 | £42,426 | £40,918 | £41,048 | £41,324 |
| Paid-in Capital | £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 |
| Retained Earnings | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) |
| Earnings | £0 | (£3,164) | (£5,974) | (£8,361) | (£10,254) | (£11,513) | (£12,069) | (£11,746) | (£10,370) | (£7,730) | (£3,572) | £2,409 | £10,563 |
| Total Capital | (£30,000) | (£33,164) | (£35,974) | (£38,361) | (£40,254) | (£41,513) | (£42,069) | (£41,746) | (£40,370) | (£37,730) | (£33,572) | (£27,591) | (£19,437) |
| Total Liabilities and Capital | £15,000 | £11,858 | £8,569 | £5,733 | £3,419 | £1,798 | £908 | £970 | £2,158 | £4,697 | £7,345 | £13,457 | £21,887 |
| Net Worth | (£30,000) | (£33,164) | (£35,974) | (£38,361) | (£40,254) | (£41,513) | (£42,069) | (£41,746) | (£40,370) | (£37,730) | (£33,572) | (£27,591) | (£19,437) |
| 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 | |||||||||||||
| Average Visits Per Month | 0% | 50 | 60 | 72 | 86 | 104 | 124 | 149 | 179 | 215 | 258 | 310 | 372 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 50 | 60 | 72 | 86 | 104 | 124 | 149 | 179 | 215 | 258 | 310 | 372 | |
| 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 | |
| Average Visits Per Month | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.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 | |||||||||||||
| Average Visits Per Month | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| 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 | |
| Average Visits Per Month | 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 |
| 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 | |||||||||||||
| Average Visits Per Month | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Dr. Azzato | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Receptionist/Clinician's Assistant | 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 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Sales and Marketing and Other Expenses | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Utilities & Phone | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Payroll Taxes | 15% | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Other (misc) | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | |
| Total Operating Expenses | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | £6,775 | |
| Profit Before Interest and Taxes | (£4,275) | (£3,775) | (£3,175) | (£2,475) | (£1,575) | (£575) | £675 | £2,175 | £3,975 | £6,125 | £8,725 | £11,825 | |
| EBITDA | (£4,275) | (£3,775) | (£3,175) | (£2,475) | (£1,575) | (£575) | £675 | £2,175 | £3,975 | £6,125 | £8,725 | £11,825 | |
| Interest Expense | £245 | £240 | £235 | £229 | £224 | £219 | £214 | £209 | £204 | £186 | £181 | £176 | |
| Taxes Incurred | (£1,356) | (£1,204) | (£1,023) | (£811) | (£540) | (£238) | £138 | £590 | £1,131 | £1,782 | £2,563 | £3,495 | |
| Net Profit | (£3,164) | (£2,810) | (£2,387) | (£1,893) | (£1,259) | (£556) | £323 | £1,376 | £2,640 | £4,157 | £5,981 | £8,155 | |
| Net Profit/Sales | -126.56% | -93.68% | -66.30% | -44.02% | -24.22% | -8.96% | 4.33% | 15.38% | 24.56% | 32.23% | 38.59% | 43.84% | |
| 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 | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| Subtotal Cash from Operations | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| 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 | £2,500 | £3,000 | £3,600 | £4,300 | £5,200 | £6,200 | £7,450 | £8,950 | £10,750 | £12,900 | £15,500 | £18,600 | |
| 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 | £5,000 | £5,000 | £5,000 | |
| Bill Payments | £22 | £669 | £816 | £994 | £1,202 | £1,469 | £1,768 | £2,142 | £2,591 | £3,131 | £3,768 | £4,550 | |
| Subtotal Spent on Operations | £5,022 | £5,669 | £5,816 | £5,994 | £6,202 | £6,469 | £6,768 | £7,142 | £7,591 | £8,131 | £8,768 | £9,550 | |
| 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 | £620 | £620 | £620 | £620 | £620 | £620 | £620 | £620 | £620 | £2,120 | £620 | £620 | |
| 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,642 | £6,289 | £6,436 | £6,614 | £6,822 | £7,089 | £7,388 | £7,762 | £8,211 | £10,251 | £9,388 | £10,170 | |
| Net Cash Flow | (£3,142) | (£3,289) | (£2,836) | (£2,314) | (£1,622) | (£889) | £62 | £1,188 | £2,539 | £2,649 | £6,112 | £8,430 | |
| Cash Balance | £11,858 | £8,569 | £5,733 | £3,419 | £1,798 | £908 | £970 | £2,158 | £4,697 | £7,345 | £13,457 | £21,887 | |
| 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 | £15,000 | £11,858 | £8,569 | £5,733 | £3,419 | £1,798 | £908 | £970 | £2,158 | £4,697 | £7,345 | £13,457 | £21,887 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £15,000 | £11,858 | £8,569 | £5,733 | £3,419 | £1,798 | £908 | £970 | £2,158 | £4,697 | £7,345 | £13,457 | £21,887 |
| 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 | £15,000 | £11,858 | £8,569 | £5,733 | £3,419 | £1,798 | £908 | £970 | £2,158 | £4,697 | £7,345 | £13,457 | £21,887 |
| 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 | £642 | £783 | £954 | £1,153 | £1,411 | £1,697 | £2,056 | £2,488 | £3,006 | £3,618 | £4,368 | £5,264 |
| Current Borrowing | £30,000 | £29,380 | £28,760 | £28,140 | £27,520 | £26,900 | £26,280 | £25,660 | £25,040 | £24,420 | £22,300 | £21,680 | £21,060 |
| Other Current Liabilities | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Subtotal Current Liabilities | £45,000 | £45,022 | £44,543 | £44,094 | £43,673 | £43,311 | £42,977 | £42,716 | £42,528 | £42,426 | £40,918 | £41,048 | £41,324 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £45,000 | £45,022 | £44,543 | £44,094 | £43,673 | £43,311 | £42,977 | £42,716 | £42,528 | £42,426 | £40,918 | £41,048 | £41,324 |
| Paid-in Capital | £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 |
| Retained Earnings | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) | (£35,000) |
| Earnings | £0 | (£3,164) | (£5,974) | (£8,361) | (£10,254) | (£11,513) | (£12,069) | (£11,746) | (£10,370) | (£7,730) | (£3,572) | £2,409 | £10,563 |
| Total Capital | (£30,000) | (£33,164) | (£35,974) | (£38,361) | (£40,254) | (£41,513) | (£42,069) | (£41,746) | (£40,370) | (£37,730) | (£33,572) | (£27,591) | (£19,437) |
| Total Liabilities and Capital | £15,000 | £11,858 | £8,569 | £5,733 | £3,419 | £1,798 | £908 | £970 | £2,158 | £4,697 | £7,345 | £13,457 | £21,887 |
| Net Worth | (£30,000) | (£33,164) | (£35,974) | (£38,361) | (£40,254) | (£41,513) | (£42,069) | (£41,746) | (£40,370) | (£37,730) | (£33,572) | (£27,591) | (£19,437) |