| 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 | |||||||||||||
| Centers for Independent Living | 0% | £0 | £0 | £0 | £0 | £540 | £1,350 | £1,944 | £2,970 | £3,918 | £4,023 | £4,266 | £4,428 |
| School Districts | 0% | £0 | £0 | £0 | £0 | £1,000 | £2,500 | £3,600 | £5,500 | £7,255 | £7,450 | £7,900 | £8,200 |
| Proactive Parents | 0% | £0 | £0 | £0 | £0 | £230 | £575 | £828 | £1,265 | £1,669 | £1,714 | £1,817 | £1,886 |
| Agencies | 0% | £0 | £0 | £0 | £0 | £460 | £1,150 | £1,656 | £2,530 | £3,337 | £3,427 | £3,634 | £3,772 |
| Total Sales | £0 | £0 | £0 | £0 | £2,230 | £5,575 | £8,028 | £12,265 | £16,179 | £16,614 | £17,617 | £18,286 | |
| 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 | |
| Centers for Independent Living | £0 | £0 | £0 | £0 | £38 | £95 | £136 | £208 | £274 | £282 | £299 | £310 | |
| School Districts | £0 | £0 | £0 | £0 | £70 | £175 | £252 | £385 | £508 | £522 | £553 | £574 | |
| Proactive Parents | £0 | £0 | £0 | £0 | £16 | £40 | £58 | £89 | £117 | £120 | £127 | £132 | |
| Agencies | £0 | £0 | £0 | £0 | £32 | £81 | £116 | £177 | £234 | £240 | £254 | £264 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £156 | £390 | £562 | £859 | £1,133 | £1,163 | £1,233 | £1,280 | |
| 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 | ||
| Sue | 0% | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Accounting | 0% | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Software Documentation | 0% | £0 | £0 | £0 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Product Development | 0% | £0 | £0 | £0 | £0 | £0 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Customer Service/ Tech Support | 0% | £0 | £0 | £0 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Customer Service/ Tech Support | 0% | £0 | £0 | £0 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Marketing/ Sales | 0% | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Marketing/ Sales | 0% | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Total People | 0 | 1 | 1 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £0 | £2,000 | £2,000 | £16,400 | £16,400 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £0 | £0 | £0 | £0 | £2,230 | £5,575 | £8,028 | £12,265 | £16,179 | £16,614 | £17,617 | £18,286 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £156 | £390 | £562 | £859 | £1,133 | £1,163 | £1,233 | £1,280 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £156 | £390 | £562 | £859 | £1,133 | £1,163 | £1,233 | £1,280 | |
| Gross Margin | £0 | £0 | £0 | £0 | £2,074 | £5,185 | £7,466 | £11,406 | £15,046 | £15,451 | £16,384 | £17,006 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £2,000 | £2,000 | £16,400 | £16,400 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | |
| Sales and Marketing and Other Expenses | £0 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Depreciation | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £0 | £950 | £950 | £950 | £950 | £950 | £950 | £950 | £950 | £950 | £950 | £950 | |
| Utilities | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 15% | £0 | £300 | £300 | £2,460 | £2,460 | £2,790 | £2,790 | £2,790 | £2,790 | £2,790 | £2,790 | £2,790 |
| Programming | £3,000 | £3,000 | £3,000 | £3,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,150 | £8,000 | £8,000 | £24,560 | £21,560 | £24,090 | £24,090 | £24,090 | £24,090 | £24,090 | £24,090 | £24,090 | |
| Profit Before Interest and Taxes | (£3,150) | (£8,000) | (£8,000) | (£24,560) | (£19,486) | (£18,905) | (£16,624) | (£12,684) | (£9,044) | (£8,639) | (£7,706) | (£7,084) | |
| EBITDA | (£3,000) | (£7,850) | (£7,850) | (£24,410) | (£19,336) | (£18,755) | (£16,474) | (£12,534) | (£8,894) | (£8,489) | (£7,556) | (£6,934) | |
| Interest Expense | £823 | £812 | £801 | £790 | £779 | £767 | £756 | £745 | £733 | £722 | £710 | £698 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£3,973) | (£8,812) | (£8,801) | (£25,350) | (£20,265) | (£19,673) | (£17,380) | (£13,428) | (£9,777) | (£9,361) | (£8,416) | (£7,782) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | -908.73% | -352.87% | -216.49% | -109.48% | -60.43% | -56.35% | -47.77% | -42.56% | |
| 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 | £558 | £1,394 | £2,007 | £3,066 | £4,045 | £4,153 | £4,404 | £4,572 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £0 | £56 | £1,756 | £4,243 | £6,127 | £9,297 | £12,145 | £12,485 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £558 | £1,450 | £3,763 | £7,309 | £10,172 | £13,450 | £16,549 | £17,057 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £0 | £0 | £558 | £1,450 | £3,763 | £7,309 | £10,172 | £13,450 | £16,549 | £17,057 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £0 | £2,000 | £2,000 | £16,400 | £16,400 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | |
| Bill Payments | £127 | £3,917 | £6,661 | £6,722 | £8,733 | £6,766 | £6,140 | £7,096 | £7,096 | £7,413 | £7,261 | £7,361 | |
| Subtotal Spent on Operations | £127 | £5,917 | £8,661 | £23,122 | £25,133 | £25,366 | £24,740 | £25,696 | £25,696 | £26,013 | £25,861 | £25,961 | |
| 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 | £1,291 | £1,302 | £1,313 | £1,324 | £1,335 | £1,346 | £1,357 | £1,369 | £1,380 | £1,392 | £1,403 | £1,415 | |
| 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 | £1,419 | £7,219 | £9,974 | £24,446 | £26,468 | £26,712 | £26,098 | £27,064 | £27,076 | £27,404 | £27,265 | £27,375 | |
| Net Cash Flow | (£1,419) | (£7,219) | (£9,974) | (£24,446) | (£25,910) | (£25,262) | (£22,335) | (£19,755) | (£16,904) | (£13,955) | (£10,715) | (£10,319) | |
| Cash Balance | £212,081 | £204,862 | £194,888 | £170,441 | £144,531 | £119,269 | £96,934 | £77,178 | £60,274 | £46,320 | £35,604 | £25,286 | |
| 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 | £213,500 | £212,081 | £204,862 | £194,888 | £170,441 | £144,531 | £119,269 | £96,934 | £77,178 | £60,274 | £46,320 | £35,604 | £25,286 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £1,673 | £5,798 | £10,063 | £15,019 | £21,026 | £24,190 | £25,258 | £26,487 |
| Inventory | £0 | £0 | £0 | £0 | £0 | £844 | £454 | £892 | £1,033 | £1,246 | £1,279 | £1,357 | £1,408 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £213,500 | £212,081 | £204,862 | £194,888 | £170,441 | £147,047 | £125,520 | £107,889 | £93,231 | £82,546 | £71,789 | £62,218 | £53,180 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £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 |
| Accumulated Depreciation | £0 | £150 | £300 | £450 | £600 | £750 | £900 | £1,050 | £1,200 | £1,350 | £1,500 | £1,650 | £1,800 |
| Total Long-term Assets | £9,000 | £8,850 | £8,700 | £8,550 | £8,400 | £8,250 | £8,100 | £7,950 | £7,800 | £7,650 | £7,500 | £7,350 | £7,200 |
| Total Assets | £222,500 | £220,931 | £213,562 | £203,438 | £178,841 | £155,297 | £133,620 | £115,839 | £101,031 | £90,196 | £79,289 | £69,568 | £60,380 |
| 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 | £3,695 | £6,440 | £6,429 | £8,506 | £6,562 | £5,904 | £6,860 | £6,849 | £7,171 | £7,016 | £7,115 | £7,124 |
| 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 | £3,695 | £6,440 | £6,429 | £8,506 | £6,562 | £5,904 | £6,860 | £6,849 | £7,171 | £7,016 | £7,115 | £7,124 |
| Long-term Liabilities | £100,000 | £98,709 | £97,406 | £96,094 | £94,770 | £93,435 | £92,089 | £90,731 | £89,363 | £87,983 | £86,591 | £85,188 | £83,773 |
| Total Liabilities | £100,000 | £102,404 | £103,846 | £102,523 | £103,276 | £99,997 | £97,992 | £97,591 | £96,211 | £95,154 | £93,607 | £92,303 | £90,897 |
| Paid-in Capital | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 |
| Retained Earnings | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) |
| Earnings | £0 | (£3,973) | (£12,784) | (£21,585) | (£46,935) | (£67,200) | (£86,872) | (£104,252) | (£117,680) | (£127,458) | (£136,819) | (£145,235) | (£153,017) |
| Total Capital | £122,500 | £118,527 | £109,716 | £100,915 | £75,565 | £55,300 | £35,628 | £18,248 | £4,820 | (£4,958) | (£14,319) | (£22,735) | (£30,517) |
| Total Liabilities and Capital | £222,500 | £220,931 | £213,562 | £203,438 | £178,841 | £155,297 | £133,620 | £115,839 | £101,031 | £90,196 | £79,289 | £69,568 | £60,380 |
| Net Worth | £122,500 | £118,527 | £109,716 | £100,915 | £75,565 | £55,300 | £35,628 | £18,248 | £4,820 | (£4,958) | (£14,319) | (£22,735) | (£30,517) |
| 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 | |||||||||||||
| Centers for Independent Living | 0% | £0 | £0 | £0 | £0 | £540 | £1,350 | £1,944 | £2,970 | £3,918 | £4,023 | £4,266 | £4,428 |
| School Districts | 0% | £0 | £0 | £0 | £0 | £1,000 | £2,500 | £3,600 | £5,500 | £7,255 | £7,450 | £7,900 | £8,200 |
| Proactive Parents | 0% | £0 | £0 | £0 | £0 | £230 | £575 | £828 | £1,265 | £1,669 | £1,714 | £1,817 | £1,886 |
| Agencies | 0% | £0 | £0 | £0 | £0 | £460 | £1,150 | £1,656 | £2,530 | £3,337 | £3,427 | £3,634 | £3,772 |
| Total Sales | £0 | £0 | £0 | £0 | £2,230 | £5,575 | £8,028 | £12,265 | £16,179 | £16,614 | £17,617 | £18,286 | |
| 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 | |
| Centers for Independent Living | £0 | £0 | £0 | £0 | £38 | £95 | £136 | £208 | £274 | £282 | £299 | £310 | |
| School Districts | £0 | £0 | £0 | £0 | £70 | £175 | £252 | £385 | £508 | £522 | £553 | £574 | |
| Proactive Parents | £0 | £0 | £0 | £0 | £16 | £40 | £58 | £89 | £117 | £120 | £127 | £132 | |
| Agencies | £0 | £0 | £0 | £0 | £32 | £81 | £116 | £177 | £234 | £240 | £254 | £264 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £156 | £390 | £562 | £859 | £1,133 | £1,163 | £1,233 | £1,280 | |
| 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 | ||
| Sue | 0% | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Accounting | 0% | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Software Documentation | 0% | £0 | £0 | £0 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Product Development | 0% | £0 | £0 | £0 | £0 | £0 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Customer Service/ Tech Support | 0% | £0 | £0 | £0 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Customer Service/ Tech Support | 0% | £0 | £0 | £0 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Marketing/ Sales | 0% | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Marketing/ Sales | 0% | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Total People | 0 | 1 | 1 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £0 | £2,000 | £2,000 | £16,400 | £16,400 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £0 | £0 | £0 | £0 | £2,230 | £5,575 | £8,028 | £12,265 | £16,179 | £16,614 | £17,617 | £18,286 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £156 | £390 | £562 | £859 | £1,133 | £1,163 | £1,233 | £1,280 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £156 | £390 | £562 | £859 | £1,133 | £1,163 | £1,233 | £1,280 | |
| Gross Margin | £0 | £0 | £0 | £0 | £2,074 | £5,185 | £7,466 | £11,406 | £15,046 | £15,451 | £16,384 | £17,006 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £2,000 | £2,000 | £16,400 | £16,400 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | |
| Sales and Marketing and Other Expenses | £0 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Depreciation | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £0 | £950 | £950 | £950 | £950 | £950 | £950 | £950 | £950 | £950 | £950 | £950 | |
| Utilities | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 15% | £0 | £300 | £300 | £2,460 | £2,460 | £2,790 | £2,790 | £2,790 | £2,790 | £2,790 | £2,790 | £2,790 |
| Programming | £3,000 | £3,000 | £3,000 | £3,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,150 | £8,000 | £8,000 | £24,560 | £21,560 | £24,090 | £24,090 | £24,090 | £24,090 | £24,090 | £24,090 | £24,090 | |
| Profit Before Interest and Taxes | (£3,150) | (£8,000) | (£8,000) | (£24,560) | (£19,486) | (£18,905) | (£16,624) | (£12,684) | (£9,044) | (£8,639) | (£7,706) | (£7,084) | |
| EBITDA | (£3,000) | (£7,850) | (£7,850) | (£24,410) | (£19,336) | (£18,755) | (£16,474) | (£12,534) | (£8,894) | (£8,489) | (£7,556) | (£6,934) | |
| Interest Expense | £823 | £812 | £801 | £790 | £779 | £767 | £756 | £745 | £733 | £722 | £710 | £698 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£3,973) | (£8,812) | (£8,801) | (£25,350) | (£20,265) | (£19,673) | (£17,380) | (£13,428) | (£9,777) | (£9,361) | (£8,416) | (£7,782) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | -908.73% | -352.87% | -216.49% | -109.48% | -60.43% | -56.35% | -47.77% | -42.56% | |
| 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 | £558 | £1,394 | £2,007 | £3,066 | £4,045 | £4,153 | £4,404 | £4,572 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £0 | £56 | £1,756 | £4,243 | £6,127 | £9,297 | £12,145 | £12,485 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £558 | £1,450 | £3,763 | £7,309 | £10,172 | £13,450 | £16,549 | £17,057 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £0 | £0 | £558 | £1,450 | £3,763 | £7,309 | £10,172 | £13,450 | £16,549 | £17,057 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £0 | £2,000 | £2,000 | £16,400 | £16,400 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | £18,600 | |
| Bill Payments | £127 | £3,917 | £6,661 | £6,722 | £8,733 | £6,766 | £6,140 | £7,096 | £7,096 | £7,413 | £7,261 | £7,361 | |
| Subtotal Spent on Operations | £127 | £5,917 | £8,661 | £23,122 | £25,133 | £25,366 | £24,740 | £25,696 | £25,696 | £26,013 | £25,861 | £25,961 | |
| 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 | £1,291 | £1,302 | £1,313 | £1,324 | £1,335 | £1,346 | £1,357 | £1,369 | £1,380 | £1,392 | £1,403 | £1,415 | |
| 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 | £1,419 | £7,219 | £9,974 | £24,446 | £26,468 | £26,712 | £26,098 | £27,064 | £27,076 | £27,404 | £27,265 | £27,375 | |
| Net Cash Flow | (£1,419) | (£7,219) | (£9,974) | (£24,446) | (£25,910) | (£25,262) | (£22,335) | (£19,755) | (£16,904) | (£13,955) | (£10,715) | (£10,319) | |
| Cash Balance | £212,081 | £204,862 | £194,888 | £170,441 | £144,531 | £119,269 | £96,934 | £77,178 | £60,274 | £46,320 | £35,604 | £25,286 | |
| 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 | £213,500 | £212,081 | £204,862 | £194,888 | £170,441 | £144,531 | £119,269 | £96,934 | £77,178 | £60,274 | £46,320 | £35,604 | £25,286 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £1,673 | £5,798 | £10,063 | £15,019 | £21,026 | £24,190 | £25,258 | £26,487 |
| Inventory | £0 | £0 | £0 | £0 | £0 | £844 | £454 | £892 | £1,033 | £1,246 | £1,279 | £1,357 | £1,408 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £213,500 | £212,081 | £204,862 | £194,888 | £170,441 | £147,047 | £125,520 | £107,889 | £93,231 | £82,546 | £71,789 | £62,218 | £53,180 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £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 |
| Accumulated Depreciation | £0 | £150 | £300 | £450 | £600 | £750 | £900 | £1,050 | £1,200 | £1,350 | £1,500 | £1,650 | £1,800 |
| Total Long-term Assets | £9,000 | £8,850 | £8,700 | £8,550 | £8,400 | £8,250 | £8,100 | £7,950 | £7,800 | £7,650 | £7,500 | £7,350 | £7,200 |
| Total Assets | £222,500 | £220,931 | £213,562 | £203,438 | £178,841 | £155,297 | £133,620 | £115,839 | £101,031 | £90,196 | £79,289 | £69,568 | £60,380 |
| 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 | £3,695 | £6,440 | £6,429 | £8,506 | £6,562 | £5,904 | £6,860 | £6,849 | £7,171 | £7,016 | £7,115 | £7,124 |
| 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 | £3,695 | £6,440 | £6,429 | £8,506 | £6,562 | £5,904 | £6,860 | £6,849 | £7,171 | £7,016 | £7,115 | £7,124 |
| Long-term Liabilities | £100,000 | £98,709 | £97,406 | £96,094 | £94,770 | £93,435 | £92,089 | £90,731 | £89,363 | £87,983 | £86,591 | £85,188 | £83,773 |
| Total Liabilities | £100,000 | £102,404 | £103,846 | £102,523 | £103,276 | £99,997 | £97,992 | £97,591 | £96,211 | £95,154 | £93,607 | £92,303 | £90,897 |
| Paid-in Capital | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 | £145,000 |
| Retained Earnings | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) | (£22,500) |
| Earnings | £0 | (£3,973) | (£12,784) | (£21,585) | (£46,935) | (£67,200) | (£86,872) | (£104,252) | (£117,680) | (£127,458) | (£136,819) | (£145,235) | (£153,017) |
| Total Capital | £122,500 | £118,527 | £109,716 | £100,915 | £75,565 | £55,300 | £35,628 | £18,248 | £4,820 | (£4,958) | (£14,319) | (£22,735) | (£30,517) |
| Total Liabilities and Capital | £222,500 | £220,931 | £213,562 | £203,438 | £178,841 | £155,297 | £133,620 | £115,839 | £101,031 | £90,196 | £79,289 | £69,568 | £60,380 |
| Net Worth | £122,500 | £118,527 | £109,716 | £100,915 | £75,565 | £55,300 | £35,628 | £18,248 | £4,820 | (£4,958) | (£14,319) | (£22,735) | (£30,517) |