| 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 | |||||||||||||
| Wood | 0% | £0 | £0 | £350 | £800 | £1,350 | £1,800 | £3,100 | £3,500 | £3,750 | £3,900 | £4,100 | £3,900 |
| Assorted | 0% | £0 | £0 | £305 | £696 | £1,175 | £1,566 | £2,697 | £3,045 | £3,263 | £3,393 | £3,567 | £3,393 |
| Exterior | 0% | £0 | £0 | £266 | £608 | £1,026 | £1,368 | £2,356 | £2,660 | £2,850 | £2,964 | £3,116 | £2,964 |
| Total Sales | £0 | £0 | £921 | £2,104 | £3,551 | £4,734 | £8,153 | £9,205 | £9,863 | £10,257 | £10,783 | £10,257 | |
| 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 | |
| Wood | £0 | £0 | £35 | £80 | £135 | £180 | £310 | £350 | £375 | £390 | £410 | £390 | |
| Assorted | £0 | £0 | £52 | £118 | £200 | £266 | £458 | £518 | £555 | £577 | £606 | £577 | |
| Exterior | £0 | £0 | £51 | £116 | £195 | £260 | £448 | £505 | £542 | £563 | £592 | £563 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £137 | £314 | £530 | £706 | £1,216 | £1,373 | £1,471 | £1,530 | £1,608 | £1,530 | |
| 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 | ||
| Josh | 0% | £0 | £0 | £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 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Sales | 0% | £0 | £0 | £0 | £0 | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Bookkeeper | 0% | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Service | 0% | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Service | 0% | £0 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Total People | 0 | 0 | 1 | 4 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £0 | £0 | £2,000 | £6,400 | £8,200 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| 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 | £921 | £2,104 | £3,551 | £4,734 | £8,153 | £9,205 | £9,863 | £10,257 | £10,783 | £10,257 | |
| Direct Cost of Sales | £0 | £0 | £137 | £314 | £530 | £706 | £1,216 | £1,373 | £1,471 | £1,530 | £1,608 | £1,530 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £137 | £314 | £530 | £706 | £1,216 | £1,373 | £1,471 | £1,530 | £1,608 | £1,530 | |
| Gross Margin | £0 | £0 | £783 | £1,790 | £3,021 | £4,028 | £6,937 | £7,832 | £8,391 | £8,727 | £9,175 | £8,727 | |
| Gross Margin % | 0.00% | 0.00% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £2,000 | £6,400 | £8,200 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Rent | £0 | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Utilities | £0 | £0 | £220 | £220 | £220 | £220 | £220 | £220 | £220 | £220 | £220 | £220 | |
| Insurance | 15% | £0 | £0 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 |
| Payroll Taxes | 15% | £0 | £0 | £300 | £960 | £1,230 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 |
| Total Operating Expenses | £1,000 | £1,000 | £4,420 | £9,480 | £11,550 | £13,390 | £13,390 | £13,390 | £13,390 | £13,390 | £13,390 | £13,390 | |
| Profit Before Interest and Taxes | (£1,000) | (£1,000) | (£3,637) | (£7,690) | (£8,529) | (£9,362) | (£6,453) | (£5,558) | (£4,999) | (£4,663) | (£4,215) | (£4,663) | |
| EBITDA | £0 | £0 | (£2,637) | (£6,690) | (£7,529) | (£8,362) | (£5,453) | (£4,558) | (£3,999) | (£3,663) | (£3,215) | (£3,663) | |
| Interest Expense | £576 | £568 | £561 | £553 | £545 | £537 | £529 | £521 | £513 | £505 | £497 | £489 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£1,576) | (£1,568) | (£4,197) | (£8,243) | (£9,074) | (£9,899) | (£6,982) | (£6,079) | (£5,512) | (£5,168) | (£4,712) | (£5,152) | |
| Net Profit/Sales | 0.00% | 0.00% | -455.99% | -391.76% | -255.57% | -209.11% | -85.64% | -66.04% | -55.89% | -50.39% | -43.70% | -50.23% | |
| 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 | £921 | £2,104 | £3,551 | £4,734 | £8,153 | £9,205 | £9,863 | £10,257 | £10,783 | £10,257 | |
| Subtotal Cash from Operations | £0 | £0 | £921 | £2,104 | £3,551 | £4,734 | £8,153 | £9,205 | £9,863 | £10,257 | £10,783 | £10,257 | |
| 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 | £921 | £2,104 | £3,551 | £4,734 | £8,153 | £9,205 | £9,863 | £10,257 | £10,783 | £10,257 | |
| 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 | £0 | £2,000 | £6,400 | £8,200 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Bill Payments | £19 | £576 | £649 | £2,969 | £2,675 | £3,903 | £4,135 | £4,370 | £4,658 | £4,682 | £4,693 | £4,773 | |
| Subtotal Spent on Operations | £19 | £576 | £2,649 | £9,369 | £10,875 | £13,703 | £13,935 | £14,170 | £14,458 | £14,482 | £14,493 | £14,573 | |
| 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 | £904 | £911 | £919 | £927 | £934 | £942 | £950 | £958 | £966 | £974 | £982 | £990 | |
| 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 | £923 | £1,487 | £3,568 | £10,296 | £11,809 | £14,645 | £14,885 | £15,128 | £15,424 | £15,457 | £15,475 | £15,563 | |
| Net Cash Flow | (£923) | (£1,487) | (£2,647) | (£8,192) | (£8,259) | (£9,911) | (£6,732) | (£5,923) | (£5,561) | (£5,200) | (£4,692) | (£5,306) | |
| Cash Balance | £65,677 | £64,190 | £61,543 | £53,351 | £45,092 | £35,181 | £28,449 | £22,526 | £16,965 | £11,765 | £7,073 | £1,767 | |
| 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 | £66,600 | £65,677 | £64,190 | £61,543 | £53,351 | £45,092 | £35,181 | £28,449 | £22,526 | £16,965 | £11,765 | £7,073 | £1,767 |
| Inventory | £0 | £0 | £0 | £863 | £549 | £1,019 | £1,313 | £1,338 | £1,510 | £1,618 | £1,683 | £1,769 | £1,683 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £66,600 | £65,677 | £64,190 | £62,405 | £53,900 | £46,111 | £36,494 | £29,787 | £24,036 | £18,583 | £13,448 | £8,842 | £3,450 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 |
| Accumulated Depreciation | £0 | £1,000 | £2,000 | £3,000 | £4,000 | £5,000 | £6,000 | £7,000 | £8,000 | £9,000 | £10,000 | £11,000 | £12,000 |
| Total Long-term Assets | £60,000 | £59,000 | £58,000 | £57,000 | £56,000 | £55,000 | £54,000 | £53,000 | £52,000 | £51,000 | £50,000 | £49,000 | £48,000 |
| Total Assets | £126,600 | £124,677 | £122,190 | £119,405 | £109,900 | £101,111 | £90,494 | £82,787 | £76,036 | £69,583 | £63,448 | £57,842 | £51,450 |
| 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 | £557 | £549 | £2,881 | £2,545 | £3,765 | £3,990 | £4,215 | £4,502 | £4,526 | £4,533 | £4,622 | £4,372 |
| 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 | £557 | £549 | £2,881 | £2,545 | £3,765 | £3,990 | £4,215 | £4,502 | £4,526 | £4,533 | £4,622 | £4,372 |
| Long-term Liabilities | £70,000 | £69,096 | £68,185 | £67,265 | £66,339 | £65,404 | £64,462 | £63,512 | £62,554 | £61,588 | £60,614 | £59,632 | £58,641 |
| Total Liabilities | £70,000 | £69,653 | £68,734 | £70,147 | £68,884 | £69,169 | £68,452 | £67,727 | £67,056 | £66,114 | £65,147 | £64,254 | £63,013 |
| Paid-in Capital | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 |
| Retained Earnings | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) |
| Earnings | £0 | (£1,576) | (£3,144) | (£7,341) | (£15,584) | (£24,658) | (£34,557) | (£41,540) | (£47,619) | (£53,131) | (£58,299) | (£63,012) | (£68,163) |
| Total Capital | £56,600 | £55,024 | £53,456 | £49,259 | £41,016 | £31,942 | £22,043 | £15,060 | £8,981 | £3,469 | (£1,699) | (£6,412) | (£11,563) |
| Total Liabilities and Capital | £126,600 | £124,677 | £122,190 | £119,405 | £109,900 | £101,111 | £90,494 | £82,787 | £76,036 | £69,583 | £63,448 | £57,842 | £51,450 |
| Net Worth | £56,600 | £55,024 | £53,456 | £49,259 | £41,016 | £31,942 | £22,043 | £15,060 | £8,981 | £3,469 | (£1,699) | (£6,412) | (£11,563) |
| 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 | |||||||||||||
| Wood | 0% | £0 | £0 | £350 | £800 | £1,350 | £1,800 | £3,100 | £3,500 | £3,750 | £3,900 | £4,100 | £3,900 |
| Assorted | 0% | £0 | £0 | £305 | £696 | £1,175 | £1,566 | £2,697 | £3,045 | £3,263 | £3,393 | £3,567 | £3,393 |
| Exterior | 0% | £0 | £0 | £266 | £608 | £1,026 | £1,368 | £2,356 | £2,660 | £2,850 | £2,964 | £3,116 | £2,964 |
| Total Sales | £0 | £0 | £921 | £2,104 | £3,551 | £4,734 | £8,153 | £9,205 | £9,863 | £10,257 | £10,783 | £10,257 | |
| 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 | |
| Wood | £0 | £0 | £35 | £80 | £135 | £180 | £310 | £350 | £375 | £390 | £410 | £390 | |
| Assorted | £0 | £0 | £52 | £118 | £200 | £266 | £458 | £518 | £555 | £577 | £606 | £577 | |
| Exterior | £0 | £0 | £51 | £116 | £195 | £260 | £448 | £505 | £542 | £563 | £592 | £563 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £137 | £314 | £530 | £706 | £1,216 | £1,373 | £1,471 | £1,530 | £1,608 | £1,530 | |
| 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 | ||
| Josh | 0% | £0 | £0 | £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 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Sales | 0% | £0 | £0 | £0 | £0 | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Bookkeeper | 0% | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Service | 0% | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Service | 0% | £0 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Total People | 0 | 0 | 1 | 4 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £0 | £0 | £2,000 | £6,400 | £8,200 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| 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 | £921 | £2,104 | £3,551 | £4,734 | £8,153 | £9,205 | £9,863 | £10,257 | £10,783 | £10,257 | |
| Direct Cost of Sales | £0 | £0 | £137 | £314 | £530 | £706 | £1,216 | £1,373 | £1,471 | £1,530 | £1,608 | £1,530 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £137 | £314 | £530 | £706 | £1,216 | £1,373 | £1,471 | £1,530 | £1,608 | £1,530 | |
| Gross Margin | £0 | £0 | £783 | £1,790 | £3,021 | £4,028 | £6,937 | £7,832 | £8,391 | £8,727 | £9,175 | £8,727 | |
| Gross Margin % | 0.00% | 0.00% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £2,000 | £6,400 | £8,200 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Rent | £0 | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Utilities | £0 | £0 | £220 | £220 | £220 | £220 | £220 | £220 | £220 | £220 | £220 | £220 | |
| Insurance | 15% | £0 | £0 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 |
| Payroll Taxes | 15% | £0 | £0 | £300 | £960 | £1,230 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 |
| Total Operating Expenses | £1,000 | £1,000 | £4,420 | £9,480 | £11,550 | £13,390 | £13,390 | £13,390 | £13,390 | £13,390 | £13,390 | £13,390 | |
| Profit Before Interest and Taxes | (£1,000) | (£1,000) | (£3,637) | (£7,690) | (£8,529) | (£9,362) | (£6,453) | (£5,558) | (£4,999) | (£4,663) | (£4,215) | (£4,663) | |
| EBITDA | £0 | £0 | (£2,637) | (£6,690) | (£7,529) | (£8,362) | (£5,453) | (£4,558) | (£3,999) | (£3,663) | (£3,215) | (£3,663) | |
| Interest Expense | £576 | £568 | £561 | £553 | £545 | £537 | £529 | £521 | £513 | £505 | £497 | £489 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£1,576) | (£1,568) | (£4,197) | (£8,243) | (£9,074) | (£9,899) | (£6,982) | (£6,079) | (£5,512) | (£5,168) | (£4,712) | (£5,152) | |
| Net Profit/Sales | 0.00% | 0.00% | -455.99% | -391.76% | -255.57% | -209.11% | -85.64% | -66.04% | -55.89% | -50.39% | -43.70% | -50.23% | |
| 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 | £921 | £2,104 | £3,551 | £4,734 | £8,153 | £9,205 | £9,863 | £10,257 | £10,783 | £10,257 | |
| Subtotal Cash from Operations | £0 | £0 | £921 | £2,104 | £3,551 | £4,734 | £8,153 | £9,205 | £9,863 | £10,257 | £10,783 | £10,257 | |
| 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 | £921 | £2,104 | £3,551 | £4,734 | £8,153 | £9,205 | £9,863 | £10,257 | £10,783 | £10,257 | |
| 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 | £0 | £2,000 | £6,400 | £8,200 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Bill Payments | £19 | £576 | £649 | £2,969 | £2,675 | £3,903 | £4,135 | £4,370 | £4,658 | £4,682 | £4,693 | £4,773 | |
| Subtotal Spent on Operations | £19 | £576 | £2,649 | £9,369 | £10,875 | £13,703 | £13,935 | £14,170 | £14,458 | £14,482 | £14,493 | £14,573 | |
| 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 | £904 | £911 | £919 | £927 | £934 | £942 | £950 | £958 | £966 | £974 | £982 | £990 | |
| 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 | £923 | £1,487 | £3,568 | £10,296 | £11,809 | £14,645 | £14,885 | £15,128 | £15,424 | £15,457 | £15,475 | £15,563 | |
| Net Cash Flow | (£923) | (£1,487) | (£2,647) | (£8,192) | (£8,259) | (£9,911) | (£6,732) | (£5,923) | (£5,561) | (£5,200) | (£4,692) | (£5,306) | |
| Cash Balance | £65,677 | £64,190 | £61,543 | £53,351 | £45,092 | £35,181 | £28,449 | £22,526 | £16,965 | £11,765 | £7,073 | £1,767 | |
| 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 | £66,600 | £65,677 | £64,190 | £61,543 | £53,351 | £45,092 | £35,181 | £28,449 | £22,526 | £16,965 | £11,765 | £7,073 | £1,767 |
| Inventory | £0 | £0 | £0 | £863 | £549 | £1,019 | £1,313 | £1,338 | £1,510 | £1,618 | £1,683 | £1,769 | £1,683 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £66,600 | £65,677 | £64,190 | £62,405 | £53,900 | £46,111 | £36,494 | £29,787 | £24,036 | £18,583 | £13,448 | £8,842 | £3,450 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 |
| Accumulated Depreciation | £0 | £1,000 | £2,000 | £3,000 | £4,000 | £5,000 | £6,000 | £7,000 | £8,000 | £9,000 | £10,000 | £11,000 | £12,000 |
| Total Long-term Assets | £60,000 | £59,000 | £58,000 | £57,000 | £56,000 | £55,000 | £54,000 | £53,000 | £52,000 | £51,000 | £50,000 | £49,000 | £48,000 |
| Total Assets | £126,600 | £124,677 | £122,190 | £119,405 | £109,900 | £101,111 | £90,494 | £82,787 | £76,036 | £69,583 | £63,448 | £57,842 | £51,450 |
| 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 | £557 | £549 | £2,881 | £2,545 | £3,765 | £3,990 | £4,215 | £4,502 | £4,526 | £4,533 | £4,622 | £4,372 |
| 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 | £557 | £549 | £2,881 | £2,545 | £3,765 | £3,990 | £4,215 | £4,502 | £4,526 | £4,533 | £4,622 | £4,372 |
| Long-term Liabilities | £70,000 | £69,096 | £68,185 | £67,265 | £66,339 | £65,404 | £64,462 | £63,512 | £62,554 | £61,588 | £60,614 | £59,632 | £58,641 |
| Total Liabilities | £70,000 | £69,653 | £68,734 | £70,147 | £68,884 | £69,169 | £68,452 | £67,727 | £67,056 | £66,114 | £65,147 | £64,254 | £63,013 |
| Paid-in Capital | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 |
| Retained Earnings | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) | (£8,400) |
| Earnings | £0 | (£1,576) | (£3,144) | (£7,341) | (£15,584) | (£24,658) | (£34,557) | (£41,540) | (£47,619) | (£53,131) | (£58,299) | (£63,012) | (£68,163) |
| Total Capital | £56,600 | £55,024 | £53,456 | £49,259 | £41,016 | £31,942 | £22,043 | £15,060 | £8,981 | £3,469 | (£1,699) | (£6,412) | (£11,563) |
| Total Liabilities and Capital | £126,600 | £124,677 | £122,190 | £119,405 | £109,900 | £101,111 | £90,494 | £82,787 | £76,036 | £69,583 | £63,448 | £57,842 | £51,450 |
| Net Worth | £56,600 | £55,024 | £53,456 | £49,259 | £41,016 | £31,942 | £22,043 | £15,060 | £8,981 | £3,469 | (£1,699) | (£6,412) | (£11,563) |