| 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 | |||||||||||||
| Middle to upper class | 0% | £0 | £0 | £1,456 | £2,564 | £3,545 | £4,785 | £5,265 | £6,500 | £6,014 | £0 | £0 | £0 |
| Older people | 0% | £0 | £0 | £1,345 | £2,478 | £3,654 | £4,875 | £6,000 | £5,325 | £5,874 | £0 | £0 | £0 |
| Total Sales | £0 | £0 | £2,801 | £5,042 | £7,199 | £9,660 | £11,265 | £11,825 | £11,888 | £0 | £0 | £0 | |
| 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 | |
| Middle to upper class | £0 | £0 | £146 | £256 | £355 | £479 | £527 | £650 | £601 | £0 | £0 | £0 | |
| Older people | £0 | £0 | £135 | £248 | £365 | £488 | £600 | £533 | £587 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £280 | £504 | £720 | £966 | £1,127 | £1,183 | £1,189 | £0 | £0 | £0 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Dan | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Employee 1 | 0% | £0 | £0 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £0 | £0 | £0 |
| Employee 2 | 0% | £0 | £0 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £0 | £0 | £0 |
| Employee 3 | 0% | £0 | £0 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £0 | £0 | £0 |
| Employee 4 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Employee 5 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Employee 6 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 1 | 41 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 1 | 1 | 1 | |
| Total Payroll | £3,000 | £3,000 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £3,000 | £3,000 | £3,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 | £2,801 | £5,042 | £7,199 | £9,660 | £11,265 | £11,825 | £11,888 | £0 | £0 | £0 | |
| Direct Cost of Sales | £0 | £0 | £280 | £504 | £720 | £966 | £1,127 | £1,183 | £1,189 | £0 | £0 | £0 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £280 | £504 | £720 | £966 | £1,127 | £1,183 | £1,189 | £0 | £0 | £0 | |
| Gross Margin | £0 | £0 | £2,521 | £4,538 | £6,479 | £8,694 | £10,139 | £10,643 | £10,699 | £0 | £0 | £0 | |
| Gross Margin % | 0.00% | 0.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 0.00% | 0.00% | 0.00% | |
| Expenses | |||||||||||||
| Payroll | £3,000 | £3,000 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £3,000 | £3,000 | £3,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £0 | £0 | £0 | |
| Depreciation | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Rent | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Payroll Taxes | 15% | £450 | £450 | £1,026 | £1,026 | £1,026 | £1,026 | £1,026 | £1,026 | £1,026 | £450 | £450 | £450 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £4,180 | £4,180 | £8,696 | £8,696 | £8,696 | £8,696 | £8,696 | £8,696 | £8,696 | £4,180 | £4,180 | £4,180 | |
| Profit Before Interest and Taxes | (£4,180) | (£4,180) | (£6,175) | (£4,158) | (£2,217) | (£2) | £1,443 | £1,947 | £2,003 | (£4,180) | (£4,180) | (£4,180) | |
| EBITDA | (£4,000) | (£4,000) | (£5,995) | (£3,978) | (£2,037) | £178 | £1,623 | £2,127 | £2,183 | (£4,000) | (£4,000) | (£4,000) | |
| Interest Expense | (£1) | (£2) | (£3) | (£3) | (£4) | (£5) | (£6) | (£7) | (£8) | (£8) | (£9) | (£10) | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,179) | (£4,178) | (£6,173) | (£4,155) | (£2,213) | £3 | £1,448 | £1,953 | £2,011 | (£4,172) | (£4,171) | (£4,170) | |
| Net Profit/Sales | 0.00% | 0.00% | -220.37% | -82.41% | -30.74% | 0.03% | 12.86% | 16.52% | 16.91% | 0.00% | 0.00% | 0.00% | |
| 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 | £2,801 | £5,042 | £7,199 | £9,660 | £11,265 | £11,825 | £11,888 | £0 | £0 | £0 | |
| Subtotal Cash from Operations | £0 | £0 | £2,801 | £5,042 | £7,199 | £9,660 | £11,265 | £11,825 | £11,888 | £0 | £0 | £0 | |
| 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 | £2,801 | £5,042 | £7,199 | £9,660 | £11,265 | £11,825 | £11,888 | £0 | £0 | £0 | |
| 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 | £3,000 | £3,000 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £3,000 | £3,000 | £3,000 | |
| Bill Payments | £33 | £999 | £1,030 | £1,961 | £2,184 | £2,400 | £2,642 | £2,799 | £2,852 | £2,795 | £992 | £991 | |
| Subtotal Spent on Operations | £3,033 | £3,999 | £7,870 | £8,801 | £9,024 | £9,240 | £9,482 | £9,639 | £9,692 | £5,795 | £3,992 | £3,991 | |
| 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 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| 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 | £3,133 | £4,099 | £7,970 | £8,901 | £9,124 | £9,340 | £9,582 | £9,739 | £9,792 | £5,895 | £4,092 | £4,091 | |
| Net Cash Flow | (£3,133) | (£4,099) | (£5,169) | (£3,859) | (£1,925) | £320 | £1,683 | £2,086 | £2,096 | (£5,895) | (£4,092) | (£4,091) | |
| Cash Balance | £25,667 | £21,568 | £16,398 | £12,539 | £10,614 | £10,934 | £12,617 | £14,704 | £16,800 | £10,904 | £6,813 | £2,722 | |
| 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 | £28,800 | £25,667 | £21,568 | £16,398 | £12,539 | £10,614 | £10,934 | £12,617 | £14,704 | £16,800 | £10,904 | £6,813 | £2,722 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £28,800 | £25,667 | £21,568 | £16,398 | £12,539 | £10,614 | £10,934 | £12,617 | £14,704 | £16,800 | £10,904 | £6,813 | £2,722 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 |
| Accumulated Depreciation | £0 | £180 | £360 | £540 | £720 | £900 | £1,080 | £1,260 | £1,440 | £1,620 | £1,800 | £1,980 | £2,160 |
| Total Long-term Assets | £10,800 | £10,620 | £10,440 | £10,260 | £10,080 | £9,900 | £9,720 | £9,540 | £9,360 | £9,180 | £9,000 | £8,820 | £8,640 |
| Total Assets | £39,600 | £36,287 | £32,008 | £26,658 | £22,619 | £20,514 | £20,654 | £22,157 | £24,064 | £25,980 | £19,904 | £15,633 | £11,362 |
| 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 | £966 | £965 | £1,888 | £2,104 | £2,312 | £2,549 | £2,703 | £2,757 | £2,762 | £959 | £958 | £957 |
| Current Borrowing | £0 | (£100) | (£200) | (£300) | (£400) | (£500) | (£600) | (£700) | (£800) | (£900) | (£1,000) | (£1,100) | (£1,200) |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £866 | £765 | £1,588 | £1,704 | £1,812 | £1,949 | £2,003 | £1,957 | £1,862 | (£41) | (£142) | (£243) |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £866 | £765 | £1,588 | £1,704 | £1,812 | £1,949 | £2,003 | £1,957 | £1,862 | (£41) | (£142) | (£243) |
| Paid-in Capital | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Retained Earnings | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) |
| Earnings | £0 | (£4,179) | (£8,358) | (£14,530) | (£18,685) | (£20,898) | (£20,895) | (£19,446) | (£17,493) | (£15,483) | (£19,654) | (£23,825) | (£27,995) |
| Total Capital | £39,600 | £35,421 | £31,243 | £25,070 | £20,915 | £18,702 | £18,705 | £20,154 | £22,107 | £24,118 | £19,946 | £15,775 | £11,605 |
| Total Liabilities and Capital | £39,600 | £36,287 | £32,008 | £26,658 | £22,619 | £20,514 | £20,654 | £22,157 | £24,064 | £25,980 | £19,904 | £15,633 | £11,362 |
| Net Worth | £39,600 | £35,421 | £31,243 | £25,070 | £20,915 | £18,702 | £18,705 | £20,154 | £22,107 | £24,118 | £19,946 | £15,775 | £11,605 |
| 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 | |||||||||||||
| Middle to upper class | 0% | £0 | £0 | £1,456 | £2,564 | £3,545 | £4,785 | £5,265 | £6,500 | £6,014 | £0 | £0 | £0 |
| Older people | 0% | £0 | £0 | £1,345 | £2,478 | £3,654 | £4,875 | £6,000 | £5,325 | £5,874 | £0 | £0 | £0 |
| Total Sales | £0 | £0 | £2,801 | £5,042 | £7,199 | £9,660 | £11,265 | £11,825 | £11,888 | £0 | £0 | £0 | |
| 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 | |
| Middle to upper class | £0 | £0 | £146 | £256 | £355 | £479 | £527 | £650 | £601 | £0 | £0 | £0 | |
| Older people | £0 | £0 | £135 | £248 | £365 | £488 | £600 | £533 | £587 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £280 | £504 | £720 | £966 | £1,127 | £1,183 | £1,189 | £0 | £0 | £0 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Dan | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Employee 1 | 0% | £0 | £0 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £0 | £0 | £0 |
| Employee 2 | 0% | £0 | £0 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £0 | £0 | £0 |
| Employee 3 | 0% | £0 | £0 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £0 | £0 | £0 |
| Employee 4 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Employee 5 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Employee 6 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 1 | 41 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 1 | 1 | 1 | |
| Total Payroll | £3,000 | £3,000 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £3,000 | £3,000 | £3,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 | £2,801 | £5,042 | £7,199 | £9,660 | £11,265 | £11,825 | £11,888 | £0 | £0 | £0 | |
| Direct Cost of Sales | £0 | £0 | £280 | £504 | £720 | £966 | £1,127 | £1,183 | £1,189 | £0 | £0 | £0 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £280 | £504 | £720 | £966 | £1,127 | £1,183 | £1,189 | £0 | £0 | £0 | |
| Gross Margin | £0 | £0 | £2,521 | £4,538 | £6,479 | £8,694 | £10,139 | £10,643 | £10,699 | £0 | £0 | £0 | |
| Gross Margin % | 0.00% | 0.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 0.00% | 0.00% | 0.00% | |
| Expenses | |||||||||||||
| Payroll | £3,000 | £3,000 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £3,000 | £3,000 | £3,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £0 | £0 | £0 | |
| Depreciation | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Rent | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Payroll Taxes | 15% | £450 | £450 | £1,026 | £1,026 | £1,026 | £1,026 | £1,026 | £1,026 | £1,026 | £450 | £450 | £450 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £4,180 | £4,180 | £8,696 | £8,696 | £8,696 | £8,696 | £8,696 | £8,696 | £8,696 | £4,180 | £4,180 | £4,180 | |
| Profit Before Interest and Taxes | (£4,180) | (£4,180) | (£6,175) | (£4,158) | (£2,217) | (£2) | £1,443 | £1,947 | £2,003 | (£4,180) | (£4,180) | (£4,180) | |
| EBITDA | (£4,000) | (£4,000) | (£5,995) | (£3,978) | (£2,037) | £178 | £1,623 | £2,127 | £2,183 | (£4,000) | (£4,000) | (£4,000) | |
| Interest Expense | (£1) | (£2) | (£3) | (£3) | (£4) | (£5) | (£6) | (£7) | (£8) | (£8) | (£9) | (£10) | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,179) | (£4,178) | (£6,173) | (£4,155) | (£2,213) | £3 | £1,448 | £1,953 | £2,011 | (£4,172) | (£4,171) | (£4,170) | |
| Net Profit/Sales | 0.00% | 0.00% | -220.37% | -82.41% | -30.74% | 0.03% | 12.86% | 16.52% | 16.91% | 0.00% | 0.00% | 0.00% | |
| 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 | £2,801 | £5,042 | £7,199 | £9,660 | £11,265 | £11,825 | £11,888 | £0 | £0 | £0 | |
| Subtotal Cash from Operations | £0 | £0 | £2,801 | £5,042 | £7,199 | £9,660 | £11,265 | £11,825 | £11,888 | £0 | £0 | £0 | |
| 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 | £2,801 | £5,042 | £7,199 | £9,660 | £11,265 | £11,825 | £11,888 | £0 | £0 | £0 | |
| 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 | £3,000 | £3,000 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £6,840 | £3,000 | £3,000 | £3,000 | |
| Bill Payments | £33 | £999 | £1,030 | £1,961 | £2,184 | £2,400 | £2,642 | £2,799 | £2,852 | £2,795 | £992 | £991 | |
| Subtotal Spent on Operations | £3,033 | £3,999 | £7,870 | £8,801 | £9,024 | £9,240 | £9,482 | £9,639 | £9,692 | £5,795 | £3,992 | £3,991 | |
| 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 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| 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 | £3,133 | £4,099 | £7,970 | £8,901 | £9,124 | £9,340 | £9,582 | £9,739 | £9,792 | £5,895 | £4,092 | £4,091 | |
| Net Cash Flow | (£3,133) | (£4,099) | (£5,169) | (£3,859) | (£1,925) | £320 | £1,683 | £2,086 | £2,096 | (£5,895) | (£4,092) | (£4,091) | |
| Cash Balance | £25,667 | £21,568 | £16,398 | £12,539 | £10,614 | £10,934 | £12,617 | £14,704 | £16,800 | £10,904 | £6,813 | £2,722 | |
| 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 | £28,800 | £25,667 | £21,568 | £16,398 | £12,539 | £10,614 | £10,934 | £12,617 | £14,704 | £16,800 | £10,904 | £6,813 | £2,722 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £28,800 | £25,667 | £21,568 | £16,398 | £12,539 | £10,614 | £10,934 | £12,617 | £14,704 | £16,800 | £10,904 | £6,813 | £2,722 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 |
| Accumulated Depreciation | £0 | £180 | £360 | £540 | £720 | £900 | £1,080 | £1,260 | £1,440 | £1,620 | £1,800 | £1,980 | £2,160 |
| Total Long-term Assets | £10,800 | £10,620 | £10,440 | £10,260 | £10,080 | £9,900 | £9,720 | £9,540 | £9,360 | £9,180 | £9,000 | £8,820 | £8,640 |
| Total Assets | £39,600 | £36,287 | £32,008 | £26,658 | £22,619 | £20,514 | £20,654 | £22,157 | £24,064 | £25,980 | £19,904 | £15,633 | £11,362 |
| 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 | £966 | £965 | £1,888 | £2,104 | £2,312 | £2,549 | £2,703 | £2,757 | £2,762 | £959 | £958 | £957 |
| Current Borrowing | £0 | (£100) | (£200) | (£300) | (£400) | (£500) | (£600) | (£700) | (£800) | (£900) | (£1,000) | (£1,100) | (£1,200) |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £866 | £765 | £1,588 | £1,704 | £1,812 | £1,949 | £2,003 | £1,957 | £1,862 | (£41) | (£142) | (£243) |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £866 | £765 | £1,588 | £1,704 | £1,812 | £1,949 | £2,003 | £1,957 | £1,862 | (£41) | (£142) | (£243) |
| Paid-in Capital | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Retained Earnings | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) | (£400) |
| Earnings | £0 | (£4,179) | (£8,358) | (£14,530) | (£18,685) | (£20,898) | (£20,895) | (£19,446) | (£17,493) | (£15,483) | (£19,654) | (£23,825) | (£27,995) |
| Total Capital | £39,600 | £35,421 | £31,243 | £25,070 | £20,915 | £18,702 | £18,705 | £20,154 | £22,107 | £24,118 | £19,946 | £15,775 | £11,605 |
| Total Liabilities and Capital | £39,600 | £36,287 | £32,008 | £26,658 | £22,619 | £20,514 | £20,654 | £22,157 | £24,064 | £25,980 | £19,904 | £15,633 | £11,362 |
| Net Worth | £39,600 | £35,421 | £31,243 | £25,070 | £20,915 | £18,702 | £18,705 | £20,154 | £22,107 | £24,118 | £19,946 | £15,775 | £11,605 |