| 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 | |||||||||||||
| Service 1 | 0% | 400 | 800 | 1,200 | 1,800 | 2,200 | 2,600 | 3,000 | 3,400 | 3,800 | 4,200 | 4,600 | 5,000 |
| Service 2 | 0% | 0 | 0 | 0 | 0 | 2,200 | 2,600 | 3,000 | 3,400 | 3,800 | 4,200 | 4,600 | 5,000 |
| Total Unit Sales | 400 | 800 | 1,200 | 1,800 | 4,400 | 5,200 | 6,000 | 6,800 | 7,600 | 8,400 | 9,200 | 10,000 | |
| 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 | |
| Service 1 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | |
| Service 2 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | |
| Sales | |||||||||||||
| Service 1 | £1,400 | £2,800 | £4,200 | £6,300 | £7,700 | £9,100 | £10,500 | £11,900 | £13,300 | £14,700 | £16,100 | £17,500 | |
| Service 2 | £0 | £0 | £0 | £0 | £3,300 | £3,900 | £4,500 | £5,100 | £5,700 | £6,300 | £6,900 | £7,500 | |
| Total Sales | £1,400 | £2,800 | £4,200 | £6,300 | £11,000 | £13,000 | £15,000 | £17,000 | £19,000 | £21,000 | £23,000 | £25,000 | |
| 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 | |
| Service 1 | 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 |
| Service 2 | 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 | |||||||||||||
| Service 1 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Service 2 | £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 | ||
| Mary | 0% | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| John | 0% | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Matthew and Erika | 0% | £400 | £400 | £400 | £400 | £400 | £400 | £600 | £600 | £600 | £600 | £600 | £600 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £2,400 | £2,400 | £2,400 | £4,400 | £4,400 | £4,400 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | |
| 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 | £1,400 | £2,800 | £4,200 | £6,300 | £11,000 | £13,000 | £15,000 | £17,000 | £19,000 | £21,000 | £23,000 | £25,000 | |
| 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 | £1,400 | £2,800 | £4,200 | £6,300 | £11,000 | £13,000 | £15,000 | £17,000 | £19,000 | £21,000 | £23,000 | £25,000 | |
| 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 | £2,400 | £2,400 | £2,400 | £4,400 | £4,400 | £4,400 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | |
| Marketing/Promotion | £280 | £410 | £630 | £770 | £950 | £1,130 | £1,310 | £1,490 | £1,670 | £1,850 | £2,030 | £2,210 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Franchise Fee | £133 | £133 | £133 | £133 | £133 | £133 | £133 | £133 | £133 | £133 | £133 | £133 | |
| Rent | £134 | £134 | £134 | £134 | £134 | £134 | £134 | £134 | £134 | £134 | £134 | £134 | |
| Utilities | £73 | £73 | £73 | £73 | £73 | £73 | £73 | £73 | £73 | £73 | £73 | £73 | |
| Insurance | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | |
| Payroll Taxes | 15% | £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 Operating Expenses | £3,037 | £3,167 | £3,387 | £5,527 | £5,707 | £5,887 | £6,267 | £6,447 | £6,627 | £6,807 | £6,987 | £7,167 | |
| Profit Before Interest and Taxes | (£1,637) | (£367) | £813 | £773 | £5,293 | £7,113 | £8,733 | £10,553 | £12,373 | £14,193 | £16,013 | £17,833 | |
| EBITDA | (£1,637) | (£367) | £813 | £773 | £5,293 | £7,113 | £8,733 | £10,553 | £12,373 | £14,193 | £16,013 | £17,833 | |
| Interest Expense | £131 | £128 | £126 | £123 | £121 | £118 | £116 | £113 | £111 | £108 | £106 | £103 | |
| Taxes Incurred | (£530) | (£99) | £137 | £130 | £1,034 | £1,399 | £1,723 | £2,088 | £2,452 | £2,817 | £3,181 | £3,546 | |
| Net Profit | (£1,237) | (£396) | £550 | £520 | £4,138 | £5,596 | £6,894 | £8,352 | £9,810 | £11,268 | £12,726 | £14,184 | |
| Net Profit/Sales | -88.39% | -14.15% | 13.09% | 8.25% | 37.62% | 43.04% | 45.96% | 49.13% | 51.63% | 53.66% | 55.33% | 56.73% | |
| 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 | £47 | £1,447 | £2,847 | £4,270 | £6,457 | £11,067 | £13,067 | £15,067 | £17,067 | £19,067 | £21,067 | |
| Subtotal Cash from Operations | £0 | £47 | £1,447 | £2,847 | £4,270 | £6,457 | £11,067 | £13,067 | £15,067 | £17,067 | £19,067 | £21,067 | |
| 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 | £47 | £1,447 | £2,847 | £4,270 | £6,457 | £11,067 | £13,067 | £15,067 | £17,067 | £19,067 | £21,067 | |
| 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 | £2,400 | £2,400 | £2,400 | £4,400 | £4,400 | £4,400 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | |
| Bill Payments | £8 | £256 | £811 | £1,255 | £1,416 | £2,480 | £3,021 | £3,524 | £4,066 | £4,608 | £5,150 | £5,692 | |
| Subtotal Spent on Operations | £2,408 | £2,656 | £3,211 | £5,655 | £5,816 | £6,880 | £7,621 | £8,124 | £8,666 | £9,208 | £9,750 | £10,292 | |
| 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 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| 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 | £2,708 | £2,956 | £3,511 | £5,955 | £6,116 | £7,180 | £7,921 | £8,424 | £8,966 | £9,508 | £10,050 | £10,592 | |
| Net Cash Flow | (£2,708) | (£2,909) | (£2,065) | (£3,108) | (£1,846) | (£724) | £3,146 | £4,642 | £6,100 | £7,558 | £9,016 | £10,474 | |
| Cash Balance | £13,292 | £10,383 | £8,318 | £5,210 | £3,364 | £2,640 | £5,786 | £10,428 | £16,528 | £24,087 | £33,103 | £43,577 | |
| 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 | £16,000 | £13,292 | £10,383 | £8,318 | £5,210 | £3,364 | £2,640 | £5,786 | £10,428 | £16,528 | £24,087 | £33,103 | £43,577 |
| Accounts Receivable | £0 | £1,400 | £4,153 | £6,907 | £10,360 | £17,090 | £23,633 | £27,567 | £31,500 | £35,433 | £39,367 | £43,300 | £47,233 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £16,000 | £14,692 | £14,536 | £15,225 | £15,570 | £20,454 | £26,273 | £33,352 | £41,928 | £51,962 | £63,453 | £76,403 | £90,811 |
| 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 | £16,000 | £14,692 | £14,536 | £15,225 | £15,570 | £20,454 | £26,273 | £33,352 | £41,928 | £51,962 | £63,453 | £76,403 | £90,811 |
| 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 | £230 | £770 | £1,209 | £1,334 | £2,380 | £2,904 | £3,389 | £3,913 | £4,437 | £4,961 | £5,485 | £6,009 |
| Current Borrowing | £16,000 | £15,700 | £15,400 | £15,100 | £14,800 | £14,500 | £14,200 | £13,900 | £13,600 | £13,300 | £13,000 | £12,700 | £12,400 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £16,000 | £15,930 | £16,170 | £16,309 | £16,134 | £16,880 | £17,104 | £17,289 | £17,513 | £17,737 | £17,961 | £18,185 | £18,409 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £16,000 | £15,930 | £16,170 | £16,309 | £16,134 | £16,880 | £17,104 | £17,289 | £17,513 | £17,737 | £17,961 | £18,185 | £18,409 |
| Paid-in Capital | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 |
| Retained Earnings | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) |
| Earnings | £0 | (£1,237) | (£1,634) | (£1,084) | (£564) | £3,573 | £9,169 | £16,063 | £24,415 | £34,224 | £45,492 | £58,218 | £72,402 |
| Total Capital | £0 | (£1,237) | (£1,634) | (£1,084) | (£564) | £3,573 | £9,169 | £16,063 | £24,415 | £34,224 | £45,492 | £58,218 | £72,402 |
| Total Liabilities and Capital | £16,000 | £14,692 | £14,536 | £15,225 | £15,570 | £20,454 | £26,273 | £33,352 | £41,928 | £51,962 | £63,453 | £76,403 | £90,811 |
| Net Worth | £0 | (£1,237) | (£1,634) | (£1,084) | (£564) | £3,573 | £9,169 | £16,063 | £24,415 | £34,224 | £45,492 | £58,218 | £72,402 |
| 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 | |||||||||||||
| Service 1 | 0% | 400 | 800 | 1,200 | 1,800 | 2,200 | 2,600 | 3,000 | 3,400 | 3,800 | 4,200 | 4,600 | 5,000 |
| Service 2 | 0% | 0 | 0 | 0 | 0 | 2,200 | 2,600 | 3,000 | 3,400 | 3,800 | 4,200 | 4,600 | 5,000 |
| Total Unit Sales | 400 | 800 | 1,200 | 1,800 | 4,400 | 5,200 | 6,000 | 6,800 | 7,600 | 8,400 | 9,200 | 10,000 | |
| 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 | |
| Service 1 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | £3.50 | |
| Service 2 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | |
| Sales | |||||||||||||
| Service 1 | £1,400 | £2,800 | £4,200 | £6,300 | £7,700 | £9,100 | £10,500 | £11,900 | £13,300 | £14,700 | £16,100 | £17,500 | |
| Service 2 | £0 | £0 | £0 | £0 | £3,300 | £3,900 | £4,500 | £5,100 | £5,700 | £6,300 | £6,900 | £7,500 | |
| Total Sales | £1,400 | £2,800 | £4,200 | £6,300 | £11,000 | £13,000 | £15,000 | £17,000 | £19,000 | £21,000 | £23,000 | £25,000 | |
| 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 | |
| Service 1 | 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 |
| Service 2 | 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 | |||||||||||||
| Service 1 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Service 2 | £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 | ||
| Mary | 0% | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| John | 0% | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Matthew and Erika | 0% | £400 | £400 | £400 | £400 | £400 | £400 | £600 | £600 | £600 | £600 | £600 | £600 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £2,400 | £2,400 | £2,400 | £4,400 | £4,400 | £4,400 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | |
| 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 | £1,400 | £2,800 | £4,200 | £6,300 | £11,000 | £13,000 | £15,000 | £17,000 | £19,000 | £21,000 | £23,000 | £25,000 | |
| 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 | £1,400 | £2,800 | £4,200 | £6,300 | £11,000 | £13,000 | £15,000 | £17,000 | £19,000 | £21,000 | £23,000 | £25,000 | |
| 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 | £2,400 | £2,400 | £2,400 | £4,400 | £4,400 | £4,400 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | |
| Marketing/Promotion | £280 | £410 | £630 | £770 | £950 | £1,130 | £1,310 | £1,490 | £1,670 | £1,850 | £2,030 | £2,210 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Franchise Fee | £133 | £133 | £133 | £133 | £133 | £133 | £133 | £133 | £133 | £133 | £133 | £133 | |
| Rent | £134 | £134 | £134 | £134 | £134 | £134 | £134 | £134 | £134 | £134 | £134 | £134 | |
| Utilities | £73 | £73 | £73 | £73 | £73 | £73 | £73 | £73 | £73 | £73 | £73 | £73 | |
| Insurance | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | |
| Payroll Taxes | 15% | £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 Operating Expenses | £3,037 | £3,167 | £3,387 | £5,527 | £5,707 | £5,887 | £6,267 | £6,447 | £6,627 | £6,807 | £6,987 | £7,167 | |
| Profit Before Interest and Taxes | (£1,637) | (£367) | £813 | £773 | £5,293 | £7,113 | £8,733 | £10,553 | £12,373 | £14,193 | £16,013 | £17,833 | |
| EBITDA | (£1,637) | (£367) | £813 | £773 | £5,293 | £7,113 | £8,733 | £10,553 | £12,373 | £14,193 | £16,013 | £17,833 | |
| Interest Expense | £131 | £128 | £126 | £123 | £121 | £118 | £116 | £113 | £111 | £108 | £106 | £103 | |
| Taxes Incurred | (£530) | (£99) | £137 | £130 | £1,034 | £1,399 | £1,723 | £2,088 | £2,452 | £2,817 | £3,181 | £3,546 | |
| Net Profit | (£1,237) | (£396) | £550 | £520 | £4,138 | £5,596 | £6,894 | £8,352 | £9,810 | £11,268 | £12,726 | £14,184 | |
| Net Profit/Sales | -88.39% | -14.15% | 13.09% | 8.25% | 37.62% | 43.04% | 45.96% | 49.13% | 51.63% | 53.66% | 55.33% | 56.73% | |
| 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 | £47 | £1,447 | £2,847 | £4,270 | £6,457 | £11,067 | £13,067 | £15,067 | £17,067 | £19,067 | £21,067 | |
| Subtotal Cash from Operations | £0 | £47 | £1,447 | £2,847 | £4,270 | £6,457 | £11,067 | £13,067 | £15,067 | £17,067 | £19,067 | £21,067 | |
| 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 | £47 | £1,447 | £2,847 | £4,270 | £6,457 | £11,067 | £13,067 | £15,067 | £17,067 | £19,067 | £21,067 | |
| 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 | £2,400 | £2,400 | £2,400 | £4,400 | £4,400 | £4,400 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | |
| Bill Payments | £8 | £256 | £811 | £1,255 | £1,416 | £2,480 | £3,021 | £3,524 | £4,066 | £4,608 | £5,150 | £5,692 | |
| Subtotal Spent on Operations | £2,408 | £2,656 | £3,211 | £5,655 | £5,816 | £6,880 | £7,621 | £8,124 | £8,666 | £9,208 | £9,750 | £10,292 | |
| 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 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| 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 | £2,708 | £2,956 | £3,511 | £5,955 | £6,116 | £7,180 | £7,921 | £8,424 | £8,966 | £9,508 | £10,050 | £10,592 | |
| Net Cash Flow | (£2,708) | (£2,909) | (£2,065) | (£3,108) | (£1,846) | (£724) | £3,146 | £4,642 | £6,100 | £7,558 | £9,016 | £10,474 | |
| Cash Balance | £13,292 | £10,383 | £8,318 | £5,210 | £3,364 | £2,640 | £5,786 | £10,428 | £16,528 | £24,087 | £33,103 | £43,577 | |
| 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 | £16,000 | £13,292 | £10,383 | £8,318 | £5,210 | £3,364 | £2,640 | £5,786 | £10,428 | £16,528 | £24,087 | £33,103 | £43,577 |
| Accounts Receivable | £0 | £1,400 | £4,153 | £6,907 | £10,360 | £17,090 | £23,633 | £27,567 | £31,500 | £35,433 | £39,367 | £43,300 | £47,233 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £16,000 | £14,692 | £14,536 | £15,225 | £15,570 | £20,454 | £26,273 | £33,352 | £41,928 | £51,962 | £63,453 | £76,403 | £90,811 |
| 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 | £16,000 | £14,692 | £14,536 | £15,225 | £15,570 | £20,454 | £26,273 | £33,352 | £41,928 | £51,962 | £63,453 | £76,403 | £90,811 |
| 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 | £230 | £770 | £1,209 | £1,334 | £2,380 | £2,904 | £3,389 | £3,913 | £4,437 | £4,961 | £5,485 | £6,009 |
| Current Borrowing | £16,000 | £15,700 | £15,400 | £15,100 | £14,800 | £14,500 | £14,200 | £13,900 | £13,600 | £13,300 | £13,000 | £12,700 | £12,400 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £16,000 | £15,930 | £16,170 | £16,309 | £16,134 | £16,880 | £17,104 | £17,289 | £17,513 | £17,737 | £17,961 | £18,185 | £18,409 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £16,000 | £15,930 | £16,170 | £16,309 | £16,134 | £16,880 | £17,104 | £17,289 | £17,513 | £17,737 | £17,961 | £18,185 | £18,409 |
| Paid-in Capital | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 | £9,604 |
| Retained Earnings | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) | (£9,604) |
| Earnings | £0 | (£1,237) | (£1,634) | (£1,084) | (£564) | £3,573 | £9,169 | £16,063 | £24,415 | £34,224 | £45,492 | £58,218 | £72,402 |
| Total Capital | £0 | (£1,237) | (£1,634) | (£1,084) | (£564) | £3,573 | £9,169 | £16,063 | £24,415 | £34,224 | £45,492 | £58,218 | £72,402 |
| Total Liabilities and Capital | £16,000 | £14,692 | £14,536 | £15,225 | £15,570 | £20,454 | £26,273 | £33,352 | £41,928 | £51,962 | £63,453 | £76,403 | £90,811 |
| Net Worth | £0 | (£1,237) | (£1,634) | (£1,084) | (£564) | £3,573 | £9,169 | £16,063 | £24,415 | £34,224 | £45,492 | £58,218 | £72,402 |