| 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 | |||||||||||||
| Wealthy One-income Households | 0% | £1,200 | £1,200 | £2,245 | £2,400 | £4,808 | £5,100 | £5,312 | £6,400 | £6,454 | £6,514 | £6,600 | £7,400 |
| Affluent Two-income Households | 0% | £3,850 | £3,850 | £4,445 | £4,600 | £8,897 | £9,258 | £10,100 | £14,580 | £15,000 | £15,011 | £16,741 | £17,005 |
| Total Sales | £5,050 | £5,050 | £6,690 | £7,000 | £13,705 | £14,358 | £15,412 | £20,980 | £21,454 | £21,525 | £23,341 | £24,405 | |
| 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 | |
| Wealthy One-income Households | £60 | £60 | £65 | £68 | £132 | £145 | £154 | £165 | £174 | £181 | £187 | £210 | |
| Affluent Two-income Households | £151 | £151 | £160 | £165 | £354 | £365 | £371 | £387 | £412 | £445 | £457 | £489 | |
| Subtotal Direct Cost of Sales | £211 | £211 | £225 | £233 | £486 | £510 | £525 | £552 | £586 | £626 | £644 | £699 | |
| 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 | ||
| Owner | 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 |
| Employees | 0% | £2,250 | £3,185 | £6,200 | £6,254 | £7,000 | £7,000 | £8,000 | £8,000 | £8,000 | £10,000 | £10,000 | £11,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £4,250 | £5,185 | £8,200 | £8,254 | £9,000 | £9,000 | £10,000 | £10,000 | £10,000 | £12,000 | £12,000 | £13,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% | 0.00% | 0.00% | 0.00% | 0.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £5,050 | £5,050 | £6,690 | £7,000 | £13,705 | £14,358 | £15,412 | £20,980 | £21,454 | £21,525 | £23,341 | £24,405 | |
| Direct Cost of Sales | £211 | £211 | £225 | £233 | £486 | £510 | £525 | £552 | £586 | £626 | £644 | £699 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £211 | £211 | £225 | £233 | £486 | £510 | £525 | £552 | £586 | £626 | £644 | £699 | |
| Gross Margin | £4,839 | £4,839 | £6,465 | £6,767 | £13,219 | £13,848 | £14,887 | £20,428 | £20,868 | £20,899 | £22,697 | £23,706 | |
| Gross Margin % | 95.82% | 95.82% | 96.64% | 96.67% | 96.45% | 96.45% | 96.59% | 97.37% | 97.27% | 97.09% | 97.24% | 97.14% | |
| Expenses | |||||||||||||
| Payroll | £4,250 | £5,185 | £8,200 | £8,254 | £9,000 | £9,000 | £10,000 | £10,000 | £10,000 | £12,000 | £12,000 | £13,000 | |
| Sales and Marketing and Other Expenses | £0 | £503 | £503 | £503 | £523 | £523 | £523 | £523 | £528 | £528 | £528 | £828 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Additional Payroll Burden | £169 | £239 | £465 | £469 | £752 | £758 | £759 | £1,041 | £1,050 | £1,099 | £1,125 | £1,133 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £4,719 | £6,227 | £9,468 | £9,526 | £10,575 | £10,581 | £11,582 | £11,864 | £11,878 | £13,927 | £13,953 | £15,261 | |
| Profit Before Interest and Taxes | £120 | (£1,388) | (£3,003) | (£2,759) | £2,644 | £3,267 | £3,305 | £8,564 | £8,990 | £6,972 | £8,744 | £8,445 | |
| EBITDA | £120 | (£1,388) | (£3,003) | (£2,759) | £2,644 | £3,267 | £3,305 | £8,564 | £8,990 | £6,972 | £8,744 | £8,445 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £36 | £0 | £0 | £0 | £0 | £817 | £826 | £2,141 | £2,247 | £1,743 | £2,186 | £2,111 | |
| Net Profit | £84 | (£1,388) | (£3,003) | (£2,759) | £2,644 | £2,450 | £2,479 | £6,423 | £6,742 | £5,229 | £6,558 | £6,334 | |
| Net Profit/Sales | 1.67% | -27.48% | -44.89% | -39.41% | 19.29% | 17.06% | 16.09% | 30.62% | 31.43% | 24.29% | 28.10% | 25.95% | |
| 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 | £5,050 | £5,050 | £6,690 | £7,000 | £13,705 | £14,358 | £15,412 | £20,980 | £21,454 | £21,525 | £23,341 | £24,405 | |
| Subtotal Cash from Operations | £5,050 | £5,050 | £6,690 | £7,000 | £13,705 | £14,358 | £15,412 | £20,980 | £21,454 | £21,525 | £23,341 | £24,405 | |
| 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 | £5,000 | £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 | £5,050 | £5,050 | £6,690 | £12,000 | £13,705 | £14,358 | £15,412 | £20,980 | £21,454 | £21,525 | £23,341 | £24,405 | |
| 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 | £4,250 | £5,185 | £8,200 | £8,254 | £9,000 | £9,000 | £10,000 | £10,000 | £10,000 | £12,000 | £12,000 | £13,000 | |
| Bill Payments | £50 | £1,489 | £1,049 | £1,301 | £2,249 | £1,636 | £3,365 | £2,495 | £5,009 | £5,077 | £3,719 | £5,147 | |
| Subtotal Spent on Operations | £4,300 | £6,674 | £9,249 | £9,555 | £11,249 | £10,636 | £13,365 | £12,495 | £15,009 | £17,077 | £15,719 | £18,147 | |
| 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 | £5,000 | |
| 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 | £4,300 | £6,674 | £9,249 | £9,555 | £11,249 | £10,636 | £13,365 | £12,495 | £15,009 | £17,077 | £15,719 | £23,147 | |
| Net Cash Flow | £750 | (£1,624) | (£2,559) | £2,445 | £2,456 | £3,722 | £2,047 | £8,485 | £6,445 | £4,448 | £7,622 | £1,258 | |
| Cash Balance | £9,825 | £8,200 | £5,641 | £8,086 | £10,542 | £14,264 | £16,311 | £24,796 | £31,242 | £35,690 | £43,312 | £44,570 | |
| 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 | £9,075 | £9,825 | £8,200 | £5,641 | £8,086 | £10,542 | £14,264 | £16,311 | £24,796 | £31,242 | £35,690 | £43,312 | £44,570 |
| Inventory | £0 | £789 | £578 | £353 | £1,120 | £634 | £1,124 | £599 | £1,047 | £1,461 | £835 | £1,191 | £1,492 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £9,075 | £10,614 | £8,778 | £5,994 | £9,206 | £11,176 | £15,388 | £16,910 | £25,843 | £32,703 | £36,525 | £44,503 | £46,062 |
| 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 | £9,075 | £10,614 | £8,778 | £5,994 | £9,206 | £11,176 | £15,388 | £16,910 | £25,843 | £32,703 | £36,525 | £44,503 | £46,062 |
| 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 | £1,455 | £1,007 | £1,226 | £2,196 | £1,523 | £3,285 | £2,328 | £4,838 | £4,955 | £3,548 | £4,968 | £5,193 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £0 |
| Subtotal Current Liabilities | £0 | £1,455 | £1,007 | £1,226 | £7,196 | £6,523 | £8,285 | £7,328 | £9,838 | £9,955 | £8,548 | £9,968 | £5,193 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,455 | £1,007 | £1,226 | £7,196 | £6,523 | £8,285 | £7,328 | £9,838 | £9,955 | £8,548 | £9,968 | £5,193 |
| Paid-in Capital | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 |
| Retained Earnings | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) |
| Earnings | £0 | £84 | (£1,304) | (£4,307) | (£7,066) | (£4,422) | (£1,972) | £507 | £6,930 | £13,673 | £18,902 | £25,460 | £31,794 |
| Total Capital | £9,075 | £9,159 | £7,771 | £4,768 | £2,009 | £4,653 | £7,103 | £9,582 | £16,005 | £22,748 | £27,977 | £34,535 | £40,869 |
| Total Liabilities and Capital | £9,075 | £10,614 | £8,778 | £5,994 | £9,206 | £11,176 | £15,388 | £16,910 | £25,843 | £32,703 | £36,525 | £44,503 | £46,062 |
| Net Worth | £9,075 | £9,159 | £7,771 | £4,768 | £2,009 | £4,653 | £7,103 | £9,582 | £16,005 | £22,748 | £27,977 | £34,535 | £40,869 |
| 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 | |||||||||||||
| Wealthy One-income Households | 0% | £1,200 | £1,200 | £2,245 | £2,400 | £4,808 | £5,100 | £5,312 | £6,400 | £6,454 | £6,514 | £6,600 | £7,400 |
| Affluent Two-income Households | 0% | £3,850 | £3,850 | £4,445 | £4,600 | £8,897 | £9,258 | £10,100 | £14,580 | £15,000 | £15,011 | £16,741 | £17,005 |
| Total Sales | £5,050 | £5,050 | £6,690 | £7,000 | £13,705 | £14,358 | £15,412 | £20,980 | £21,454 | £21,525 | £23,341 | £24,405 | |
| 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 | |
| Wealthy One-income Households | £60 | £60 | £65 | £68 | £132 | £145 | £154 | £165 | £174 | £181 | £187 | £210 | |
| Affluent Two-income Households | £151 | £151 | £160 | £165 | £354 | £365 | £371 | £387 | £412 | £445 | £457 | £489 | |
| Subtotal Direct Cost of Sales | £211 | £211 | £225 | £233 | £486 | £510 | £525 | £552 | £586 | £626 | £644 | £699 | |
| 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 | ||
| Owner | 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 |
| Employees | 0% | £2,250 | £3,185 | £6,200 | £6,254 | £7,000 | £7,000 | £8,000 | £8,000 | £8,000 | £10,000 | £10,000 | £11,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £4,250 | £5,185 | £8,200 | £8,254 | £9,000 | £9,000 | £10,000 | £10,000 | £10,000 | £12,000 | £12,000 | £13,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% | 0.00% | 0.00% | 0.00% | 0.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £5,050 | £5,050 | £6,690 | £7,000 | £13,705 | £14,358 | £15,412 | £20,980 | £21,454 | £21,525 | £23,341 | £24,405 | |
| Direct Cost of Sales | £211 | £211 | £225 | £233 | £486 | £510 | £525 | £552 | £586 | £626 | £644 | £699 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £211 | £211 | £225 | £233 | £486 | £510 | £525 | £552 | £586 | £626 | £644 | £699 | |
| Gross Margin | £4,839 | £4,839 | £6,465 | £6,767 | £13,219 | £13,848 | £14,887 | £20,428 | £20,868 | £20,899 | £22,697 | £23,706 | |
| Gross Margin % | 95.82% | 95.82% | 96.64% | 96.67% | 96.45% | 96.45% | 96.59% | 97.37% | 97.27% | 97.09% | 97.24% | 97.14% | |
| Expenses | |||||||||||||
| Payroll | £4,250 | £5,185 | £8,200 | £8,254 | £9,000 | £9,000 | £10,000 | £10,000 | £10,000 | £12,000 | £12,000 | £13,000 | |
| Sales and Marketing and Other Expenses | £0 | £503 | £503 | £503 | £523 | £523 | £523 | £523 | £528 | £528 | £528 | £828 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Additional Payroll Burden | £169 | £239 | £465 | £469 | £752 | £758 | £759 | £1,041 | £1,050 | £1,099 | £1,125 | £1,133 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £4,719 | £6,227 | £9,468 | £9,526 | £10,575 | £10,581 | £11,582 | £11,864 | £11,878 | £13,927 | £13,953 | £15,261 | |
| Profit Before Interest and Taxes | £120 | (£1,388) | (£3,003) | (£2,759) | £2,644 | £3,267 | £3,305 | £8,564 | £8,990 | £6,972 | £8,744 | £8,445 | |
| EBITDA | £120 | (£1,388) | (£3,003) | (£2,759) | £2,644 | £3,267 | £3,305 | £8,564 | £8,990 | £6,972 | £8,744 | £8,445 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £36 | £0 | £0 | £0 | £0 | £817 | £826 | £2,141 | £2,247 | £1,743 | £2,186 | £2,111 | |
| Net Profit | £84 | (£1,388) | (£3,003) | (£2,759) | £2,644 | £2,450 | £2,479 | £6,423 | £6,742 | £5,229 | £6,558 | £6,334 | |
| Net Profit/Sales | 1.67% | -27.48% | -44.89% | -39.41% | 19.29% | 17.06% | 16.09% | 30.62% | 31.43% | 24.29% | 28.10% | 25.95% | |
| 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 | £5,050 | £5,050 | £6,690 | £7,000 | £13,705 | £14,358 | £15,412 | £20,980 | £21,454 | £21,525 | £23,341 | £24,405 | |
| Subtotal Cash from Operations | £5,050 | £5,050 | £6,690 | £7,000 | £13,705 | £14,358 | £15,412 | £20,980 | £21,454 | £21,525 | £23,341 | £24,405 | |
| 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 | £5,000 | £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 | £5,050 | £5,050 | £6,690 | £12,000 | £13,705 | £14,358 | £15,412 | £20,980 | £21,454 | £21,525 | £23,341 | £24,405 | |
| 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 | £4,250 | £5,185 | £8,200 | £8,254 | £9,000 | £9,000 | £10,000 | £10,000 | £10,000 | £12,000 | £12,000 | £13,000 | |
| Bill Payments | £50 | £1,489 | £1,049 | £1,301 | £2,249 | £1,636 | £3,365 | £2,495 | £5,009 | £5,077 | £3,719 | £5,147 | |
| Subtotal Spent on Operations | £4,300 | £6,674 | £9,249 | £9,555 | £11,249 | £10,636 | £13,365 | £12,495 | £15,009 | £17,077 | £15,719 | £18,147 | |
| 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 | £5,000 | |
| 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 | £4,300 | £6,674 | £9,249 | £9,555 | £11,249 | £10,636 | £13,365 | £12,495 | £15,009 | £17,077 | £15,719 | £23,147 | |
| Net Cash Flow | £750 | (£1,624) | (£2,559) | £2,445 | £2,456 | £3,722 | £2,047 | £8,485 | £6,445 | £4,448 | £7,622 | £1,258 | |
| Cash Balance | £9,825 | £8,200 | £5,641 | £8,086 | £10,542 | £14,264 | £16,311 | £24,796 | £31,242 | £35,690 | £43,312 | £44,570 | |
| 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 | £9,075 | £9,825 | £8,200 | £5,641 | £8,086 | £10,542 | £14,264 | £16,311 | £24,796 | £31,242 | £35,690 | £43,312 | £44,570 |
| Inventory | £0 | £789 | £578 | £353 | £1,120 | £634 | £1,124 | £599 | £1,047 | £1,461 | £835 | £1,191 | £1,492 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £9,075 | £10,614 | £8,778 | £5,994 | £9,206 | £11,176 | £15,388 | £16,910 | £25,843 | £32,703 | £36,525 | £44,503 | £46,062 |
| 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 | £9,075 | £10,614 | £8,778 | £5,994 | £9,206 | £11,176 | £15,388 | £16,910 | £25,843 | £32,703 | £36,525 | £44,503 | £46,062 |
| 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 | £1,455 | £1,007 | £1,226 | £2,196 | £1,523 | £3,285 | £2,328 | £4,838 | £4,955 | £3,548 | £4,968 | £5,193 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £0 |
| Subtotal Current Liabilities | £0 | £1,455 | £1,007 | £1,226 | £7,196 | £6,523 | £8,285 | £7,328 | £9,838 | £9,955 | £8,548 | £9,968 | £5,193 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,455 | £1,007 | £1,226 | £7,196 | £6,523 | £8,285 | £7,328 | £9,838 | £9,955 | £8,548 | £9,968 | £5,193 |
| Paid-in Capital | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 |
| Retained Earnings | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) | (£3,925) |
| Earnings | £0 | £84 | (£1,304) | (£4,307) | (£7,066) | (£4,422) | (£1,972) | £507 | £6,930 | £13,673 | £18,902 | £25,460 | £31,794 |
| Total Capital | £9,075 | £9,159 | £7,771 | £4,768 | £2,009 | £4,653 | £7,103 | £9,582 | £16,005 | £22,748 | £27,977 | £34,535 | £40,869 |
| Total Liabilities and Capital | £9,075 | £10,614 | £8,778 | £5,994 | £9,206 | £11,176 | £15,388 | £16,910 | £25,843 | £32,703 | £36,525 | £44,503 | £46,062 |
| Net Worth | £9,075 | £9,159 | £7,771 | £4,768 | £2,009 | £4,653 | £7,103 | £9,582 | £16,005 | £22,748 | £27,977 | £34,535 | £40,869 |