| 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 | |||||||||||||
| Parents | 0% | £0 | £0 | £4,340 | £4,909 | £5,232 | £5,453 | £5,890 | £6,112 | £6,323 | £6,878 | £7,211 | £7,323 |
| Family & Friends | 0% | £0 | £0 | £3,902 | £4,413 | £4,704 | £4,902 | £5,295 | £5,495 | £5,684 | £6,183 | £6,483 | £6,583 |
| Total Sales | £0 | £0 | £8,242 | £9,322 | £9,936 | £10,355 | £11,185 | £11,607 | £12,007 | £13,061 | £13,694 | £13,906 | |
| 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 | |
| Parents | £0 | £0 | £1,736 | £1,964 | £2,093 | £2,181 | £2,356 | £2,445 | £2,529 | £2,751 | £2,884 | £2,929 | |
| Family & Friends | £0 | £0 | £1,561 | £1,765 | £1,881 | £1,961 | £2,118 | £2,198 | £2,274 | £2,473 | £2,593 | £2,633 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £3,297 | £3,729 | £3,974 | £4,142 | £4,474 | £4,643 | £4,803 | £5,225 | £5,477 | £5,563 | |
| 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 | ||
| Sandy | 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 staff | 0% | £0 | £0 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Sales staff | 0% | £0 | £0 | £0 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Sales staff | 0% | £0 | £0 | £0 | £0 | £0 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Bookkeeper | 0% | £0 | £0 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 1 | 3 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £2,000 | £2,000 | £4,200 | £5,600 | £5,600 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| 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 | £8,242 | £9,322 | £9,936 | £10,355 | £11,185 | £11,607 | £12,007 | £13,061 | £13,694 | £13,906 | |
| Direct Cost of Sales | £0 | £0 | £3,297 | £3,729 | £3,974 | £4,142 | £4,474 | £4,643 | £4,803 | £5,225 | £5,477 | £5,563 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £3,297 | £3,729 | £3,974 | £4,142 | £4,474 | £4,643 | £4,803 | £5,225 | £5,477 | £5,563 | |
| Gross Margin | £0 | £0 | £4,945 | £5,593 | £5,961 | £6,213 | £6,711 | £6,964 | £7,204 | £7,837 | £8,216 | £8,344 | |
| Gross Margin % | 0.00% | 0.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £2,000 | £4,200 | £5,600 | £5,600 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Sales and Marketing and Other Expenses | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Depreciation | £316 | £316 | £316 | £316 | £316 | £316 | £316 | £316 | £316 | £316 | £316 | £316 | |
| Rent | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £300 | £300 | £630 | £840 | £840 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 |
| Other | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Total Operating Expenses | £6,041 | £6,041 | £8,571 | £10,181 | £10,181 | £11,791 | £11,791 | £11,791 | £11,791 | £11,791 | £11,791 | £11,791 | |
| Profit Before Interest and Taxes | (£6,041) | (£6,041) | (£3,626) | (£4,588) | (£4,220) | (£5,578) | (£5,080) | (£4,827) | (£4,587) | (£3,954) | (£3,575) | (£3,447) | |
| EBITDA | (£5,725) | (£5,725) | (£3,310) | (£4,272) | (£3,904) | (£5,262) | (£4,764) | (£4,511) | (£4,271) | (£3,638) | (£3,259) | (£3,131) | |
| 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 | (£6,041) | (£6,041) | (£3,626) | (£4,588) | (£4,220) | (£5,578) | (£5,080) | (£4,827) | (£4,587) | (£3,954) | (£3,575) | (£3,447) | |
| Net Profit/Sales | 0.00% | 0.00% | -44.00% | -49.21% | -42.47% | -53.86% | -45.42% | -41.59% | -38.20% | -30.27% | -26.11% | -24.79% | |
| 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 | £8,242 | £9,322 | £9,936 | £10,355 | £11,185 | £11,607 | £12,007 | £13,061 | £13,694 | £13,906 | |
| Subtotal Cash from Operations | £0 | £0 | £8,242 | £9,322 | £9,936 | £10,355 | £11,185 | £11,607 | £12,007 | £13,061 | £13,694 | £13,906 | |
| 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 | £8,242 | £9,322 | £9,936 | £10,355 | £11,185 | £11,607 | £12,007 | £13,061 | £13,694 | £13,906 | |
| 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 | £2,000 | £4,200 | £5,600 | £5,600 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Bill Payments | £124 | £3,725 | £3,967 | £10,894 | £8,471 | £8,519 | £8,819 | £9,314 | £9,308 | £9,478 | £10,166 | £10,227 | |
| Subtotal Spent on Operations | £2,124 | £5,725 | £8,167 | £16,494 | £14,071 | £15,519 | £15,819 | £16,314 | £16,308 | £16,478 | £17,166 | £17,227 | |
| 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,124 | £5,725 | £8,167 | £16,494 | £14,071 | £15,519 | £15,819 | £16,314 | £16,308 | £16,478 | £17,166 | £17,227 | |
| Net Cash Flow | (£2,124) | (£5,725) | £75 | (£7,172) | (£4,135) | (£5,164) | (£4,634) | (£4,707) | (£4,301) | (£3,417) | (£3,472) | (£3,321) | |
| Cash Balance | £49,426 | £43,701 | £43,776 | £36,604 | £32,468 | £27,305 | £22,671 | £17,964 | £13,663 | £10,247 | £6,775 | £3,454 | |
| 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 | £51,550 | £49,426 | £43,701 | £43,776 | £36,604 | £32,468 | £27,305 | £22,671 | £17,964 | £13,663 | £10,247 | £6,775 | £3,454 |
| Inventory | £0 | £0 | £0 | £3,626 | £4,102 | £4,372 | £4,556 | £4,921 | £5,107 | £5,283 | £5,747 | £6,025 | £6,119 |
| Other Current Assets | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Total Current Assets | £55,050 | £52,926 | £47,201 | £50,902 | £44,205 | £40,340 | £35,361 | £31,093 | £26,571 | £22,446 | £19,494 | £16,300 | £13,073 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 |
| Accumulated Depreciation | £0 | £316 | £632 | £948 | £1,264 | £1,580 | £1,896 | £2,212 | £2,528 | £2,844 | £3,160 | £3,476 | £3,792 |
| Total Long-term Assets | £19,000 | £18,684 | £18,368 | £18,052 | £17,736 | £17,420 | £17,104 | £16,788 | £16,472 | £16,156 | £15,840 | £15,524 | £15,208 |
| Total Assets | £74,050 | £71,610 | £65,569 | £68,954 | £61,941 | £57,760 | £52,465 | £47,881 | £43,043 | £38,602 | £35,334 | £31,824 | £28,281 |
| 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,601 | £3,601 | £10,612 | £8,187 | £8,225 | £8,508 | £9,004 | £8,993 | £9,139 | £9,824 | £9,890 | £9,793 |
| 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,601 | £3,601 | £10,612 | £8,187 | £8,225 | £8,508 | £9,004 | £8,993 | £9,139 | £9,824 | £9,890 | £9,793 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £3,601 | £3,601 | £10,612 | £8,187 | £8,225 | £8,508 | £9,004 | £8,993 | £9,139 | £9,824 | £9,890 | £9,793 |
| Paid-in Capital | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 |
| Retained Earnings | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) |
| Earnings | £0 | (£6,041) | (£12,082) | (£15,708) | (£20,296) | (£24,515) | (£30,093) | (£35,173) | (£40,000) | (£44,587) | (£48,541) | (£52,116) | (£55,563) |
| Total Capital | £74,050 | £68,009 | £61,968 | £58,342 | £53,754 | £49,535 | £43,957 | £38,877 | £34,050 | £29,463 | £25,509 | £21,934 | £18,487 |
| Total Liabilities and Capital | £74,050 | £71,610 | £65,569 | £68,954 | £61,941 | £57,760 | £52,465 | £47,881 | £43,043 | £38,602 | £35,334 | £31,824 | £28,281 |
| Net Worth | £74,050 | £68,009 | £61,968 | £58,342 | £53,754 | £49,535 | £43,957 | £38,877 | £34,050 | £29,463 | £25,509 | £21,934 | £18,487 |
| 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 | |||||||||||||
| Parents | 0% | £0 | £0 | £4,340 | £4,909 | £5,232 | £5,453 | £5,890 | £6,112 | £6,323 | £6,878 | £7,211 | £7,323 |
| Family & Friends | 0% | £0 | £0 | £3,902 | £4,413 | £4,704 | £4,902 | £5,295 | £5,495 | £5,684 | £6,183 | £6,483 | £6,583 |
| Total Sales | £0 | £0 | £8,242 | £9,322 | £9,936 | £10,355 | £11,185 | £11,607 | £12,007 | £13,061 | £13,694 | £13,906 | |
| 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 | |
| Parents | £0 | £0 | £1,736 | £1,964 | £2,093 | £2,181 | £2,356 | £2,445 | £2,529 | £2,751 | £2,884 | £2,929 | |
| Family & Friends | £0 | £0 | £1,561 | £1,765 | £1,881 | £1,961 | £2,118 | £2,198 | £2,274 | £2,473 | £2,593 | £2,633 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £3,297 | £3,729 | £3,974 | £4,142 | £4,474 | £4,643 | £4,803 | £5,225 | £5,477 | £5,563 | |
| 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 | ||
| Sandy | 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 staff | 0% | £0 | £0 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Sales staff | 0% | £0 | £0 | £0 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Sales staff | 0% | £0 | £0 | £0 | £0 | £0 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Bookkeeper | 0% | £0 | £0 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 1 | 3 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £2,000 | £2,000 | £4,200 | £5,600 | £5,600 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| 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 | £8,242 | £9,322 | £9,936 | £10,355 | £11,185 | £11,607 | £12,007 | £13,061 | £13,694 | £13,906 | |
| Direct Cost of Sales | £0 | £0 | £3,297 | £3,729 | £3,974 | £4,142 | £4,474 | £4,643 | £4,803 | £5,225 | £5,477 | £5,563 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £3,297 | £3,729 | £3,974 | £4,142 | £4,474 | £4,643 | £4,803 | £5,225 | £5,477 | £5,563 | |
| Gross Margin | £0 | £0 | £4,945 | £5,593 | £5,961 | £6,213 | £6,711 | £6,964 | £7,204 | £7,837 | £8,216 | £8,344 | |
| Gross Margin % | 0.00% | 0.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £2,000 | £4,200 | £5,600 | £5,600 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Sales and Marketing and Other Expenses | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Depreciation | £316 | £316 | £316 | £316 | £316 | £316 | £316 | £316 | £316 | £316 | £316 | £316 | |
| Rent | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £300 | £300 | £630 | £840 | £840 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 |
| Other | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Total Operating Expenses | £6,041 | £6,041 | £8,571 | £10,181 | £10,181 | £11,791 | £11,791 | £11,791 | £11,791 | £11,791 | £11,791 | £11,791 | |
| Profit Before Interest and Taxes | (£6,041) | (£6,041) | (£3,626) | (£4,588) | (£4,220) | (£5,578) | (£5,080) | (£4,827) | (£4,587) | (£3,954) | (£3,575) | (£3,447) | |
| EBITDA | (£5,725) | (£5,725) | (£3,310) | (£4,272) | (£3,904) | (£5,262) | (£4,764) | (£4,511) | (£4,271) | (£3,638) | (£3,259) | (£3,131) | |
| 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 | (£6,041) | (£6,041) | (£3,626) | (£4,588) | (£4,220) | (£5,578) | (£5,080) | (£4,827) | (£4,587) | (£3,954) | (£3,575) | (£3,447) | |
| Net Profit/Sales | 0.00% | 0.00% | -44.00% | -49.21% | -42.47% | -53.86% | -45.42% | -41.59% | -38.20% | -30.27% | -26.11% | -24.79% | |
| 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 | £8,242 | £9,322 | £9,936 | £10,355 | £11,185 | £11,607 | £12,007 | £13,061 | £13,694 | £13,906 | |
| Subtotal Cash from Operations | £0 | £0 | £8,242 | £9,322 | £9,936 | £10,355 | £11,185 | £11,607 | £12,007 | £13,061 | £13,694 | £13,906 | |
| 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 | £8,242 | £9,322 | £9,936 | £10,355 | £11,185 | £11,607 | £12,007 | £13,061 | £13,694 | £13,906 | |
| 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 | £2,000 | £4,200 | £5,600 | £5,600 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Bill Payments | £124 | £3,725 | £3,967 | £10,894 | £8,471 | £8,519 | £8,819 | £9,314 | £9,308 | £9,478 | £10,166 | £10,227 | |
| Subtotal Spent on Operations | £2,124 | £5,725 | £8,167 | £16,494 | £14,071 | £15,519 | £15,819 | £16,314 | £16,308 | £16,478 | £17,166 | £17,227 | |
| 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,124 | £5,725 | £8,167 | £16,494 | £14,071 | £15,519 | £15,819 | £16,314 | £16,308 | £16,478 | £17,166 | £17,227 | |
| Net Cash Flow | (£2,124) | (£5,725) | £75 | (£7,172) | (£4,135) | (£5,164) | (£4,634) | (£4,707) | (£4,301) | (£3,417) | (£3,472) | (£3,321) | |
| Cash Balance | £49,426 | £43,701 | £43,776 | £36,604 | £32,468 | £27,305 | £22,671 | £17,964 | £13,663 | £10,247 | £6,775 | £3,454 | |
| 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 | £51,550 | £49,426 | £43,701 | £43,776 | £36,604 | £32,468 | £27,305 | £22,671 | £17,964 | £13,663 | £10,247 | £6,775 | £3,454 |
| Inventory | £0 | £0 | £0 | £3,626 | £4,102 | £4,372 | £4,556 | £4,921 | £5,107 | £5,283 | £5,747 | £6,025 | £6,119 |
| Other Current Assets | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Total Current Assets | £55,050 | £52,926 | £47,201 | £50,902 | £44,205 | £40,340 | £35,361 | £31,093 | £26,571 | £22,446 | £19,494 | £16,300 | £13,073 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 |
| Accumulated Depreciation | £0 | £316 | £632 | £948 | £1,264 | £1,580 | £1,896 | £2,212 | £2,528 | £2,844 | £3,160 | £3,476 | £3,792 |
| Total Long-term Assets | £19,000 | £18,684 | £18,368 | £18,052 | £17,736 | £17,420 | £17,104 | £16,788 | £16,472 | £16,156 | £15,840 | £15,524 | £15,208 |
| Total Assets | £74,050 | £71,610 | £65,569 | £68,954 | £61,941 | £57,760 | £52,465 | £47,881 | £43,043 | £38,602 | £35,334 | £31,824 | £28,281 |
| 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,601 | £3,601 | £10,612 | £8,187 | £8,225 | £8,508 | £9,004 | £8,993 | £9,139 | £9,824 | £9,890 | £9,793 |
| 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,601 | £3,601 | £10,612 | £8,187 | £8,225 | £8,508 | £9,004 | £8,993 | £9,139 | £9,824 | £9,890 | £9,793 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £3,601 | £3,601 | £10,612 | £8,187 | £8,225 | £8,508 | £9,004 | £8,993 | £9,139 | £9,824 | £9,890 | £9,793 |
| Paid-in Capital | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 |
| Retained Earnings | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) | (£65,950) |
| Earnings | £0 | (£6,041) | (£12,082) | (£15,708) | (£20,296) | (£24,515) | (£30,093) | (£35,173) | (£40,000) | (£44,587) | (£48,541) | (£52,116) | (£55,563) |
| Total Capital | £74,050 | £68,009 | £61,968 | £58,342 | £53,754 | £49,535 | £43,957 | £38,877 | £34,050 | £29,463 | £25,509 | £21,934 | £18,487 |
| Total Liabilities and Capital | £74,050 | £71,610 | £65,569 | £68,954 | £61,941 | £57,760 | £52,465 | £47,881 | £43,043 | £38,602 | £35,334 | £31,824 | £28,281 |
| Net Worth | £74,050 | £68,009 | £61,968 | £58,342 | £53,754 | £49,535 | £43,957 | £38,877 | £34,050 | £29,463 | £25,509 | £21,934 | £18,487 |