| 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 | |||||||||||||
| Professional install | 0% | £0 | £0 | £6,589 | £9,854 | £11,454 | £13,545 | £13,989 | £14,022 | £14,585 | £15,655 | £15,878 | £16,002 |
| DIY | 0% | £0 | £0 | £0 | £8,573 | £9,965 | £11,784 | £12,170 | £12,199 | £12,689 | £13,620 | £13,814 | £13,922 |
| Total Sales | £0 | £0 | £6,589 | £18,427 | £21,419 | £25,329 | £26,159 | £26,221 | £27,274 | £29,275 | £29,692 | £29,924 | |
| 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 | |
| Professional install | £0 | £0 | £2,965 | £4,434 | £5,154 | £6,095 | £6,295 | £6,310 | £6,563 | £7,045 | £7,145 | £7,201 | |
| DIY | £0 | £0 | £0 | £3,858 | £4,484 | £5,303 | £5,477 | £5,490 | £5,710 | £6,129 | £6,216 | £6,265 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £2,965 | £8,292 | £9,639 | £11,398 | £11,772 | £11,800 | £12,273 | £13,174 | £13,361 | £13,466 | |
| 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 | ||
| Sara | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Sales | 0% | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Sales | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Warehouse | 0% | £0 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Warehouse | 0% | £0 | £0 | £0 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Customer service | 0% | £0 | £0 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Bookkeeper/ HR | 0% | £0 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Total People | 1 | 4 | 5 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £2,000 | £6,700 | £8,000 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | |
| 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 | £6,589 | £18,427 | £21,419 | £25,329 | £26,159 | £26,221 | £27,274 | £29,275 | £29,692 | £29,924 | |
| Direct Cost of Sales | £0 | £0 | £2,965 | £8,292 | £9,639 | £11,398 | £11,772 | £11,800 | £12,273 | £13,174 | £13,361 | £13,466 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £2,965 | £8,292 | £9,639 | £11,398 | £11,772 | £11,800 | £12,273 | £13,174 | £13,361 | £13,466 | |
| Gross Margin | £0 | £0 | £3,624 | £10,135 | £11,780 | £13,931 | £14,388 | £14,422 | £15,001 | £16,101 | £16,331 | £16,458 | |
| Gross Margin % | 0.00% | 0.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £6,700 | £8,000 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | |
| Sales and Marketing and Other Expenses | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | |
| Depreciation | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Insurance | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | |
| Payroll Taxes | 15% | £300 | £1,005 | £1,200 | £1,695 | £1,695 | £1,695 | £1,695 | £1,695 | £1,695 | £1,695 | £1,695 | £1,695 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £7,383 | £12,788 | £14,283 | £18,078 | £18,078 | £18,078 | £18,078 | £18,078 | £18,078 | £18,078 | £18,078 | £18,078 | |
| Profit Before Interest and Taxes | (£7,383) | (£12,788) | (£10,659) | (£7,943) | (£6,298) | (£4,147) | (£3,690) | (£3,656) | (£3,077) | (£1,977) | (£1,747) | (£1,620) | |
| EBITDA | (£6,350) | (£11,755) | (£9,626) | (£6,910) | (£5,265) | (£3,114) | (£2,657) | (£2,623) | (£2,044) | (£944) | (£714) | (£587) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£7,383) | (£12,788) | (£10,659) | (£7,943) | (£6,298) | (£4,147) | (£3,690) | (£3,656) | (£3,077) | (£1,977) | (£1,747) | (£1,620) | |
| Net Profit/Sales | 0.00% | 0.00% | -161.77% | -43.11% | -29.40% | -16.37% | -14.11% | -13.94% | -11.28% | -6.75% | -5.89% | -5.41% | |
| 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 | £1,647 | £4,607 | £5,355 | £6,332 | £6,540 | £6,555 | £6,818 | £7,319 | £7,423 | £7,481 | |
| Cash from Receivables | £0 | £0 | £0 | £165 | £5,238 | £13,895 | £16,162 | £19,018 | £19,621 | £19,692 | £20,505 | £21,967 | |
| Subtotal Cash from Operations | £0 | £0 | £1,647 | £4,771 | £10,592 | £20,227 | £22,702 | £25,573 | £26,440 | £27,011 | £27,928 | £29,447 | |
| 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 | £1,647 | £4,771 | £10,592 | £20,227 | £22,702 | £25,573 | £26,440 | £27,011 | £27,928 | £29,447 | |
| 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,000 | £6,700 | £8,000 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | |
| Bill Payments | £145 | £4,374 | £5,160 | £8,409 | £14,082 | £15,442 | £17,156 | £17,518 | £17,560 | £18,048 | £18,925 | £19,110 | |
| Subtotal Spent on Operations | £2,145 | £11,074 | £13,160 | £19,709 | £25,382 | £26,742 | £28,456 | £28,818 | £28,860 | £29,348 | £30,225 | £30,410 | |
| 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 | £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,145 | £11,074 | £13,160 | £19,709 | £25,382 | £26,742 | £28,456 | £28,818 | £28,860 | £29,348 | £30,225 | £30,410 | |
| Net Cash Flow | (£2,145) | (£11,074) | (£11,513) | (£14,938) | (£14,790) | (£6,515) | (£5,754) | (£3,245) | (£2,421) | (£2,337) | (£2,296) | (£962) | |
| Cash Balance | £91,855 | £80,782 | £69,268 | £54,331 | £39,541 | £33,026 | £27,273 | £24,028 | £21,607 | £19,270 | £16,973 | £16,011 | |
| 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 | £94,000 | £91,855 | £80,782 | £69,268 | £54,331 | £39,541 | £33,026 | £27,273 | £24,028 | £21,607 | £19,270 | £16,973 | £16,011 |
| Accounts Receivable | £0 | £0 | £0 | £4,942 | £18,597 | £29,424 | £34,526 | £37,983 | £38,631 | £39,466 | £41,730 | £43,493 | £43,969 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £94,000 | £91,855 | £80,782 | £74,210 | £72,928 | £68,965 | £67,552 | £65,256 | £62,659 | £61,073 | £60,999 | £60,466 | £59,980 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 |
| Accumulated Depreciation | £0 | £1,033 | £2,066 | £3,099 | £4,132 | £5,165 | £6,198 | £7,231 | £8,264 | £9,297 | £10,330 | £11,363 | £12,396 |
| Total Long-term Assets | £62,000 | £60,967 | £59,934 | £58,901 | £57,868 | £56,835 | £55,802 | £54,769 | £53,736 | £52,703 | £51,670 | £50,637 | £49,604 |
| Total Assets | £156,000 | £152,822 | £140,716 | £133,111 | £130,796 | £125,800 | £123,354 | £120,025 | £116,395 | £113,776 | £112,669 | £111,103 | £109,584 |
| 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 | £4,205 | £4,887 | £7,941 | £13,569 | £14,871 | £16,572 | £16,933 | £16,960 | £17,418 | £18,288 | £18,469 | £18,570 |
| 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 | £4,205 | £4,887 | £7,941 | £13,569 | £14,871 | £16,572 | £16,933 | £16,960 | £17,418 | £18,288 | £18,469 | £18,570 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £4,205 | £4,887 | £7,941 | £13,569 | £14,871 | £16,572 | £16,933 | £16,960 | £17,418 | £18,288 | £18,469 | £18,570 |
| Paid-in Capital | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 |
| Retained Earnings | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) |
| Earnings | £0 | (£7,383) | (£20,171) | (£30,830) | (£38,773) | (£45,071) | (£49,218) | (£52,908) | (£56,564) | (£59,642) | (£61,619) | (£63,366) | (£64,986) |
| Total Capital | £156,000 | £148,617 | £135,829 | £125,170 | £117,227 | £110,929 | £106,782 | £103,092 | £99,436 | £96,358 | £94,381 | £92,634 | £91,014 |
| Total Liabilities and Capital | £156,000 | £152,822 | £140,716 | £133,111 | £130,796 | £125,800 | £123,354 | £120,025 | £116,395 | £113,776 | £112,669 | £111,103 | £109,584 |
| Net Worth | £156,000 | £148,617 | £135,829 | £125,170 | £117,227 | £110,929 | £106,782 | £103,092 | £99,436 | £96,358 | £94,381 | £92,634 | £91,014 |
| 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 | |||||||||||||
| Professional install | 0% | £0 | £0 | £6,589 | £9,854 | £11,454 | £13,545 | £13,989 | £14,022 | £14,585 | £15,655 | £15,878 | £16,002 |
| DIY | 0% | £0 | £0 | £0 | £8,573 | £9,965 | £11,784 | £12,170 | £12,199 | £12,689 | £13,620 | £13,814 | £13,922 |
| Total Sales | £0 | £0 | £6,589 | £18,427 | £21,419 | £25,329 | £26,159 | £26,221 | £27,274 | £29,275 | £29,692 | £29,924 | |
| 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 | |
| Professional install | £0 | £0 | £2,965 | £4,434 | £5,154 | £6,095 | £6,295 | £6,310 | £6,563 | £7,045 | £7,145 | £7,201 | |
| DIY | £0 | £0 | £0 | £3,858 | £4,484 | £5,303 | £5,477 | £5,490 | £5,710 | £6,129 | £6,216 | £6,265 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £2,965 | £8,292 | £9,639 | £11,398 | £11,772 | £11,800 | £12,273 | £13,174 | £13,361 | £13,466 | |
| 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 | ||
| Sara | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Sales | 0% | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Sales | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Warehouse | 0% | £0 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Warehouse | 0% | £0 | £0 | £0 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Customer service | 0% | £0 | £0 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Bookkeeper/ HR | 0% | £0 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Total People | 1 | 4 | 5 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £2,000 | £6,700 | £8,000 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | |
| 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 | £6,589 | £18,427 | £21,419 | £25,329 | £26,159 | £26,221 | £27,274 | £29,275 | £29,692 | £29,924 | |
| Direct Cost of Sales | £0 | £0 | £2,965 | £8,292 | £9,639 | £11,398 | £11,772 | £11,800 | £12,273 | £13,174 | £13,361 | £13,466 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £2,965 | £8,292 | £9,639 | £11,398 | £11,772 | £11,800 | £12,273 | £13,174 | £13,361 | £13,466 | |
| Gross Margin | £0 | £0 | £3,624 | £10,135 | £11,780 | £13,931 | £14,388 | £14,422 | £15,001 | £16,101 | £16,331 | £16,458 | |
| Gross Margin % | 0.00% | 0.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £6,700 | £8,000 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | |
| Sales and Marketing and Other Expenses | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | |
| Depreciation | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | £1,033 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Insurance | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | |
| Payroll Taxes | 15% | £300 | £1,005 | £1,200 | £1,695 | £1,695 | £1,695 | £1,695 | £1,695 | £1,695 | £1,695 | £1,695 | £1,695 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £7,383 | £12,788 | £14,283 | £18,078 | £18,078 | £18,078 | £18,078 | £18,078 | £18,078 | £18,078 | £18,078 | £18,078 | |
| Profit Before Interest and Taxes | (£7,383) | (£12,788) | (£10,659) | (£7,943) | (£6,298) | (£4,147) | (£3,690) | (£3,656) | (£3,077) | (£1,977) | (£1,747) | (£1,620) | |
| EBITDA | (£6,350) | (£11,755) | (£9,626) | (£6,910) | (£5,265) | (£3,114) | (£2,657) | (£2,623) | (£2,044) | (£944) | (£714) | (£587) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£7,383) | (£12,788) | (£10,659) | (£7,943) | (£6,298) | (£4,147) | (£3,690) | (£3,656) | (£3,077) | (£1,977) | (£1,747) | (£1,620) | |
| Net Profit/Sales | 0.00% | 0.00% | -161.77% | -43.11% | -29.40% | -16.37% | -14.11% | -13.94% | -11.28% | -6.75% | -5.89% | -5.41% | |
| 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 | £1,647 | £4,607 | £5,355 | £6,332 | £6,540 | £6,555 | £6,818 | £7,319 | £7,423 | £7,481 | |
| Cash from Receivables | £0 | £0 | £0 | £165 | £5,238 | £13,895 | £16,162 | £19,018 | £19,621 | £19,692 | £20,505 | £21,967 | |
| Subtotal Cash from Operations | £0 | £0 | £1,647 | £4,771 | £10,592 | £20,227 | £22,702 | £25,573 | £26,440 | £27,011 | £27,928 | £29,447 | |
| 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 | £1,647 | £4,771 | £10,592 | £20,227 | £22,702 | £25,573 | £26,440 | £27,011 | £27,928 | £29,447 | |
| 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,000 | £6,700 | £8,000 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | £11,300 | |
| Bill Payments | £145 | £4,374 | £5,160 | £8,409 | £14,082 | £15,442 | £17,156 | £17,518 | £17,560 | £18,048 | £18,925 | £19,110 | |
| Subtotal Spent on Operations | £2,145 | £11,074 | £13,160 | £19,709 | £25,382 | £26,742 | £28,456 | £28,818 | £28,860 | £29,348 | £30,225 | £30,410 | |
| 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 | £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,145 | £11,074 | £13,160 | £19,709 | £25,382 | £26,742 | £28,456 | £28,818 | £28,860 | £29,348 | £30,225 | £30,410 | |
| Net Cash Flow | (£2,145) | (£11,074) | (£11,513) | (£14,938) | (£14,790) | (£6,515) | (£5,754) | (£3,245) | (£2,421) | (£2,337) | (£2,296) | (£962) | |
| Cash Balance | £91,855 | £80,782 | £69,268 | £54,331 | £39,541 | £33,026 | £27,273 | £24,028 | £21,607 | £19,270 | £16,973 | £16,011 | |
| 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 | £94,000 | £91,855 | £80,782 | £69,268 | £54,331 | £39,541 | £33,026 | £27,273 | £24,028 | £21,607 | £19,270 | £16,973 | £16,011 |
| Accounts Receivable | £0 | £0 | £0 | £4,942 | £18,597 | £29,424 | £34,526 | £37,983 | £38,631 | £39,466 | £41,730 | £43,493 | £43,969 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £94,000 | £91,855 | £80,782 | £74,210 | £72,928 | £68,965 | £67,552 | £65,256 | £62,659 | £61,073 | £60,999 | £60,466 | £59,980 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 | £62,000 |
| Accumulated Depreciation | £0 | £1,033 | £2,066 | £3,099 | £4,132 | £5,165 | £6,198 | £7,231 | £8,264 | £9,297 | £10,330 | £11,363 | £12,396 |
| Total Long-term Assets | £62,000 | £60,967 | £59,934 | £58,901 | £57,868 | £56,835 | £55,802 | £54,769 | £53,736 | £52,703 | £51,670 | £50,637 | £49,604 |
| Total Assets | £156,000 | £152,822 | £140,716 | £133,111 | £130,796 | £125,800 | £123,354 | £120,025 | £116,395 | £113,776 | £112,669 | £111,103 | £109,584 |
| 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 | £4,205 | £4,887 | £7,941 | £13,569 | £14,871 | £16,572 | £16,933 | £16,960 | £17,418 | £18,288 | £18,469 | £18,570 |
| 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 | £4,205 | £4,887 | £7,941 | £13,569 | £14,871 | £16,572 | £16,933 | £16,960 | £17,418 | £18,288 | £18,469 | £18,570 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £4,205 | £4,887 | £7,941 | £13,569 | £14,871 | £16,572 | £16,933 | £16,960 | £17,418 | £18,288 | £18,469 | £18,570 |
| Paid-in Capital | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 | £165,000 |
| Retained Earnings | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) | (£9,000) |
| Earnings | £0 | (£7,383) | (£20,171) | (£30,830) | (£38,773) | (£45,071) | (£49,218) | (£52,908) | (£56,564) | (£59,642) | (£61,619) | (£63,366) | (£64,986) |
| Total Capital | £156,000 | £148,617 | £135,829 | £125,170 | £117,227 | £110,929 | £106,782 | £103,092 | £99,436 | £96,358 | £94,381 | £92,634 | £91,014 |
| Total Liabilities and Capital | £156,000 | £152,822 | £140,716 | £133,111 | £130,796 | £125,800 | £123,354 | £120,025 | £116,395 | £113,776 | £112,669 | £111,103 | £109,584 |
| Net Worth | £156,000 | £148,617 | £135,829 | £125,170 | £117,227 | £110,929 | £106,782 | £103,092 | £99,436 | £96,358 | £94,381 | £92,634 | £91,014 |