| 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 | |||||||||||||
| Start-up fees | 0% | £0 | £45,000 | £25,000 | £0 | £0 | £30,000 | £0 | £0 | £0 | £50,000 | £0 | £0 |
| Consulting fees | 0% | £500 | £300 | £0 | £600 | £200 | £0 | £0 | £400 | £200 | £0 | £200 | £0 |
| Training fees | 0% | £0 | £300 | £250 | £0 | £0 | £400 | £0 | £0 | £0 | £600 | £1,000 | £0 |
| Total Sales | £500 | £45,600 | £25,250 | £600 | £200 | £30,400 | £0 | £400 | £200 | £50,600 | £1,200 | £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 | |
| Start-up fees | £0 | £4,500 | £2,500 | £0 | £0 | £3,000 | £0 | £0 | £0 | £5,000 | £0 | £0 | |
| Consulting fees | £200 | £120 | £0 | £240 | £80 | £0 | £0 | £160 | £80 | £0 | £80 | £0 | |
| Training fees | £0 | £150 | £125 | £0 | £0 | £200 | £0 | £0 | £0 | £300 | £500 | £0 | |
| Subtotal Direct Cost of Sales | £200 | £4,770 | £2,625 | £240 | £80 | £3,200 | £0 | £160 | £80 | £5,300 | £580 | £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 | ||
| Ivanhoe | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £10,000 | £10,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £10,000 | £10,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 | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 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 | £500 | £45,600 | £25,250 | £600 | £200 | £30,400 | £0 | £400 | £200 | £50,600 | £1,200 | £0 | |
| Direct Cost of Sales | £200 | £4,770 | £2,625 | £240 | £80 | £3,200 | £0 | £160 | £80 | £5,300 | £580 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £200 | £4,770 | £2,625 | £240 | £80 | £3,200 | £0 | £160 | £80 | £5,300 | £580 | £0 | |
| Gross Margin | £300 | £40,830 | £22,625 | £360 | £120 | £27,200 | £0 | £240 | £120 | £45,300 | £620 | £0 | |
| Gross Margin % | 60.00% | 89.54% | 89.60% | 60.00% | 60.00% | 89.47% | 0.00% | 60.00% | 60.00% | 89.53% | 51.67% | 0.00% | |
| Expenses | |||||||||||||
| Payroll | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £10,000 | £10,000 | |
| Marketing/Promotion | £0 | £1,000 | £1,000 | £0 | £0 | £1,000 | £0 | £0 | £0 | £1,000 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | |
| Insurance | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | |
| Rent | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| 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 | £6,510 | £7,510 | £7,510 | £6,510 | £6,510 | £7,510 | £6,510 | £6,510 | £6,510 | £7,510 | £10,510 | £10,510 | |
| Profit Before Interest and Taxes | (£6,210) | £33,320 | £15,115 | (£6,150) | (£6,390) | £19,690 | (£6,510) | (£6,270) | (£6,390) | £37,790 | (£9,890) | (£10,510) | |
| EBITDA | (£6,210) | £33,320 | £15,115 | (£6,150) | (£6,390) | £19,690 | (£6,510) | (£6,270) | (£6,390) | £37,790 | (£9,890) | (£10,510) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,863) | £9,996 | £4,535 | (£1,845) | (£1,917) | £5,907 | (£1,953) | (£1,881) | (£1,917) | £11,337 | (£2,967) | (£3,153) | |
| Net Profit | (£4,347) | £23,324 | £10,581 | (£4,305) | (£4,473) | £13,783 | (£4,557) | (£4,389) | (£4,473) | £26,453 | (£6,923) | (£7,357) | |
| Net Profit/Sales | -869.40% | 51.15% | 41.90% | -717.50% | -2236.50% | 45.34% | 0.00% | -1097.25% | -2236.50% | 52.28% | -576.92% | 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 | £250 | £22,800 | £12,625 | £300 | £100 | £15,200 | £0 | £200 | £100 | £25,300 | £600 | £0 | |
| Cash from Receivables | £0 | £8 | £1,002 | £22,461 | £12,214 | £293 | £603 | £14,693 | £7 | £197 | £940 | £24,477 | |
| Subtotal Cash from Operations | £250 | £22,808 | £13,627 | £22,761 | £12,314 | £15,493 | £603 | £14,893 | £107 | £25,497 | £1,540 | £24,477 | |
| 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 | £250 | £22,808 | £13,627 | £22,761 | £12,314 | £15,493 | £603 | £14,893 | £107 | £25,497 | £1,540 | £24,477 | |
| 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 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £10,000 | £10,000 | |
| Bill Payments | (£653) | (£572) | £16,022 | £7,286 | (£2,386) | (£929) | £8,820 | (£2,606) | (£2,498) | (£678) | £15,665 | (£4,457) | |
| Subtotal Spent on Operations | £5,347 | £5,428 | £22,022 | £13,286 | £3,615 | £5,071 | £14,820 | £3,394 | £3,502 | £5,322 | £25,665 | £5,543 | |
| 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 | £5,347 | £5,428 | £22,022 | £13,286 | £3,615 | £5,071 | £14,820 | £3,394 | £3,502 | £5,322 | £25,665 | £5,543 | |
| Net Cash Flow | (£5,097) | £17,380 | (£8,396) | £9,475 | £8,700 | £10,422 | (£14,217) | £11,499 | (£3,396) | £20,175 | (£24,125) | £18,934 | |
| Cash Balance | £5,903 | £23,283 | £14,888 | £24,363 | £33,063 | £43,485 | £29,268 | £40,767 | £37,372 | £57,546 | £33,421 | £52,355 | |
| 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 | £11,000 | £5,903 | £23,283 | £14,888 | £24,363 | £33,063 | £43,485 | £29,268 | £40,767 | £37,372 | £57,546 | £33,421 | £52,355 |
| Accounts Receivable | £0 | £250 | £23,042 | £34,665 | £12,504 | £390 | £15,297 | £14,693 | £200 | £293 | £25,397 | £25,057 | £580 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £11,000 | £6,153 | £46,325 | £49,553 | £36,867 | £33,453 | £58,781 | £43,961 | £40,967 | £37,665 | £82,943 | £58,478 | £52,935 |
| 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 | £11,000 | £6,153 | £46,325 | £49,553 | £36,867 | £33,453 | £58,781 | £43,961 | £40,967 | £37,665 | £82,943 | £58,478 | £52,935 |
| 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 | £500 | £0 | £16,848 | £9,495 | £1,115 | £2,173 | £13,719 | £3,456 | £4,851 | £6,021 | £24,846 | £7,304 | £9,119 |
| 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 | £500 | £0 | £16,848 | £9,495 | £1,115 | £2,173 | £13,719 | £3,456 | £4,851 | £6,021 | £24,846 | £7,304 | £9,119 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £500 | £0 | £16,848 | £9,495 | £1,115 | £2,173 | £13,719 | £3,456 | £4,851 | £6,021 | £24,846 | £7,304 | £9,119 |
| Paid-in Capital | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 |
| Retained Earnings | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) |
| Earnings | £0 | (£4,347) | £18,977 | £29,558 | £25,253 | £20,780 | £34,563 | £30,006 | £25,617 | £21,144 | £47,597 | £40,674 | £33,317 |
| Total Capital | £10,500 | £6,153 | £29,477 | £40,058 | £35,753 | £31,280 | £45,063 | £40,506 | £36,117 | £31,644 | £58,097 | £51,174 | £43,817 |
| Total Liabilities and Capital | £11,000 | £6,153 | £46,325 | £49,553 | £36,867 | £33,453 | £58,781 | £43,961 | £40,967 | £37,665 | £82,943 | £58,478 | £52,935 |
| Net Worth | £10,500 | £6,153 | £29,477 | £40,058 | £35,753 | £31,280 | £45,063 | £40,506 | £36,117 | £31,644 | £58,097 | £51,174 | £43,817 |
| 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 | |||||||||||||
| Start-up fees | 0% | £0 | £45,000 | £25,000 | £0 | £0 | £30,000 | £0 | £0 | £0 | £50,000 | £0 | £0 |
| Consulting fees | 0% | £500 | £300 | £0 | £600 | £200 | £0 | £0 | £400 | £200 | £0 | £200 | £0 |
| Training fees | 0% | £0 | £300 | £250 | £0 | £0 | £400 | £0 | £0 | £0 | £600 | £1,000 | £0 |
| Total Sales | £500 | £45,600 | £25,250 | £600 | £200 | £30,400 | £0 | £400 | £200 | £50,600 | £1,200 | £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 | |
| Start-up fees | £0 | £4,500 | £2,500 | £0 | £0 | £3,000 | £0 | £0 | £0 | £5,000 | £0 | £0 | |
| Consulting fees | £200 | £120 | £0 | £240 | £80 | £0 | £0 | £160 | £80 | £0 | £80 | £0 | |
| Training fees | £0 | £150 | £125 | £0 | £0 | £200 | £0 | £0 | £0 | £300 | £500 | £0 | |
| Subtotal Direct Cost of Sales | £200 | £4,770 | £2,625 | £240 | £80 | £3,200 | £0 | £160 | £80 | £5,300 | £580 | £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 | ||
| Ivanhoe | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £10,000 | £10,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £10,000 | £10,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 | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 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 | £500 | £45,600 | £25,250 | £600 | £200 | £30,400 | £0 | £400 | £200 | £50,600 | £1,200 | £0 | |
| Direct Cost of Sales | £200 | £4,770 | £2,625 | £240 | £80 | £3,200 | £0 | £160 | £80 | £5,300 | £580 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £200 | £4,770 | £2,625 | £240 | £80 | £3,200 | £0 | £160 | £80 | £5,300 | £580 | £0 | |
| Gross Margin | £300 | £40,830 | £22,625 | £360 | £120 | £27,200 | £0 | £240 | £120 | £45,300 | £620 | £0 | |
| Gross Margin % | 60.00% | 89.54% | 89.60% | 60.00% | 60.00% | 89.47% | 0.00% | 60.00% | 60.00% | 89.53% | 51.67% | 0.00% | |
| Expenses | |||||||||||||
| Payroll | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £10,000 | £10,000 | |
| Marketing/Promotion | £0 | £1,000 | £1,000 | £0 | £0 | £1,000 | £0 | £0 | £0 | £1,000 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | |
| Insurance | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | |
| Rent | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| 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 | £6,510 | £7,510 | £7,510 | £6,510 | £6,510 | £7,510 | £6,510 | £6,510 | £6,510 | £7,510 | £10,510 | £10,510 | |
| Profit Before Interest and Taxes | (£6,210) | £33,320 | £15,115 | (£6,150) | (£6,390) | £19,690 | (£6,510) | (£6,270) | (£6,390) | £37,790 | (£9,890) | (£10,510) | |
| EBITDA | (£6,210) | £33,320 | £15,115 | (£6,150) | (£6,390) | £19,690 | (£6,510) | (£6,270) | (£6,390) | £37,790 | (£9,890) | (£10,510) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,863) | £9,996 | £4,535 | (£1,845) | (£1,917) | £5,907 | (£1,953) | (£1,881) | (£1,917) | £11,337 | (£2,967) | (£3,153) | |
| Net Profit | (£4,347) | £23,324 | £10,581 | (£4,305) | (£4,473) | £13,783 | (£4,557) | (£4,389) | (£4,473) | £26,453 | (£6,923) | (£7,357) | |
| Net Profit/Sales | -869.40% | 51.15% | 41.90% | -717.50% | -2236.50% | 45.34% | 0.00% | -1097.25% | -2236.50% | 52.28% | -576.92% | 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 | £250 | £22,800 | £12,625 | £300 | £100 | £15,200 | £0 | £200 | £100 | £25,300 | £600 | £0 | |
| Cash from Receivables | £0 | £8 | £1,002 | £22,461 | £12,214 | £293 | £603 | £14,693 | £7 | £197 | £940 | £24,477 | |
| Subtotal Cash from Operations | £250 | £22,808 | £13,627 | £22,761 | £12,314 | £15,493 | £603 | £14,893 | £107 | £25,497 | £1,540 | £24,477 | |
| 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 | £250 | £22,808 | £13,627 | £22,761 | £12,314 | £15,493 | £603 | £14,893 | £107 | £25,497 | £1,540 | £24,477 | |
| 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 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £10,000 | £10,000 | |
| Bill Payments | (£653) | (£572) | £16,022 | £7,286 | (£2,386) | (£929) | £8,820 | (£2,606) | (£2,498) | (£678) | £15,665 | (£4,457) | |
| Subtotal Spent on Operations | £5,347 | £5,428 | £22,022 | £13,286 | £3,615 | £5,071 | £14,820 | £3,394 | £3,502 | £5,322 | £25,665 | £5,543 | |
| 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 | £5,347 | £5,428 | £22,022 | £13,286 | £3,615 | £5,071 | £14,820 | £3,394 | £3,502 | £5,322 | £25,665 | £5,543 | |
| Net Cash Flow | (£5,097) | £17,380 | (£8,396) | £9,475 | £8,700 | £10,422 | (£14,217) | £11,499 | (£3,396) | £20,175 | (£24,125) | £18,934 | |
| Cash Balance | £5,903 | £23,283 | £14,888 | £24,363 | £33,063 | £43,485 | £29,268 | £40,767 | £37,372 | £57,546 | £33,421 | £52,355 | |
| 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 | £11,000 | £5,903 | £23,283 | £14,888 | £24,363 | £33,063 | £43,485 | £29,268 | £40,767 | £37,372 | £57,546 | £33,421 | £52,355 |
| Accounts Receivable | £0 | £250 | £23,042 | £34,665 | £12,504 | £390 | £15,297 | £14,693 | £200 | £293 | £25,397 | £25,057 | £580 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £11,000 | £6,153 | £46,325 | £49,553 | £36,867 | £33,453 | £58,781 | £43,961 | £40,967 | £37,665 | £82,943 | £58,478 | £52,935 |
| 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 | £11,000 | £6,153 | £46,325 | £49,553 | £36,867 | £33,453 | £58,781 | £43,961 | £40,967 | £37,665 | £82,943 | £58,478 | £52,935 |
| 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 | £500 | £0 | £16,848 | £9,495 | £1,115 | £2,173 | £13,719 | £3,456 | £4,851 | £6,021 | £24,846 | £7,304 | £9,119 |
| 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 | £500 | £0 | £16,848 | £9,495 | £1,115 | £2,173 | £13,719 | £3,456 | £4,851 | £6,021 | £24,846 | £7,304 | £9,119 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £500 | £0 | £16,848 | £9,495 | £1,115 | £2,173 | £13,719 | £3,456 | £4,851 | £6,021 | £24,846 | £7,304 | £9,119 |
| Paid-in Capital | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 | £13,550 |
| Retained Earnings | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) | (£3,050) |
| Earnings | £0 | (£4,347) | £18,977 | £29,558 | £25,253 | £20,780 | £34,563 | £30,006 | £25,617 | £21,144 | £47,597 | £40,674 | £33,317 |
| Total Capital | £10,500 | £6,153 | £29,477 | £40,058 | £35,753 | £31,280 | £45,063 | £40,506 | £36,117 | £31,644 | £58,097 | £51,174 | £43,817 |
| Total Liabilities and Capital | £11,000 | £6,153 | £46,325 | £49,553 | £36,867 | £33,453 | £58,781 | £43,961 | £40,967 | £37,665 | £82,943 | £58,478 | £52,935 |
| Net Worth | £10,500 | £6,153 | £29,477 | £40,058 | £35,753 | £31,280 | £45,063 | £40,506 | £36,117 | £31,644 | £58,097 | £51,174 | £43,817 |