| 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 | |||||||||||||
| Used car purchasers | 0% | £0 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 | |
| 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 | |
| Used car purchasers | £0 | £84 | £133 | £161 | £252 | £315 | £357 | £385 | £413 | £455 | £518 | £560 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £84 | £133 | £161 | £252 | £315 | £357 | £385 | £413 | £455 | £518 | £560 | |
| 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% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Name or Title | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Name or Title | 0% | £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 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £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 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 | |
| Direct Cost of Sales | £0 | £84 | £133 | £161 | £252 | £315 | £357 | £385 | £413 | £455 | £518 | £560 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £84 | £133 | £161 | £252 | £315 | £357 | £385 | £413 | £455 | £518 | £560 | |
| Gross Margin | £0 | £1,116 | £1,767 | £2,139 | £3,348 | £4,185 | £4,743 | £5,115 | £5,487 | £6,045 | £6,882 | £7,440 | |
| Gross Margin % | 0.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | |
| Expenses | |||||||||||||
| Payroll | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Sales and Marketing and Other Expenses | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Depreciation | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| 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 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | |
| Profit Before Interest and Taxes | (£3,642) | (£2,526) | (£1,875) | (£1,503) | (£294) | £543 | £1,101 | £1,473 | £1,845 | £2,403 | £3,240 | £3,798 | |
| EBITDA | (£3,325) | (£2,209) | (£1,558) | (£1,186) | £23 | £860 | £1,418 | £1,790 | £2,162 | £2,720 | £3,557 | £4,115 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,093) | (£758) | (£563) | (£451) | (£88) | £163 | £330 | £442 | £554 | £721 | £972 | £1,139 | |
| Net Profit | (£2,549) | (£1,768) | (£1,313) | (£1,052) | (£206) | £380 | £771 | £1,031 | £1,292 | £1,682 | £2,268 | £2,659 | |
| Net Profit/Sales | 0.00% | -147.35% | -69.08% | -45.74% | -5.72% | 8.45% | 15.11% | 18.75% | 21.89% | 25.88% | 30.65% | 33.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 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 | |
| Subtotal Cash from Operations | £0 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 | |
| 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 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 | |
| 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 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Bill Payments | (£768) | (£1,091) | (£442) | (£100) | £50 | £499 | £810 | £1,017 | £1,157 | £1,298 | £1,511 | £1,822 | |
| Subtotal Spent on Operations | £2,232 | £1,909 | £2,558 | £2,900 | £3,050 | £3,499 | £3,810 | £4,017 | £4,157 | £4,298 | £4,511 | £4,822 | |
| 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,232 | £1,909 | £2,558 | £2,900 | £3,050 | £3,499 | £3,810 | £4,017 | £4,157 | £4,298 | £4,511 | £4,822 | |
| Net Cash Flow | (£2,232) | (£709) | (£658) | (£600) | £550 | £1,001 | £1,290 | £1,483 | £1,743 | £2,202 | £2,889 | £3,178 | |
| Cash Balance | £9,268 | £8,558 | £7,900 | £7,300 | £7,850 | £8,850 | £10,141 | £11,624 | £13,367 | £15,569 | £18,457 | £21,635 | |
| 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,500 | £9,268 | £8,558 | £7,900 | £7,300 | £7,850 | £8,850 | £10,141 | £11,624 | £13,367 | £15,569 | £18,457 | £21,635 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £11,500 | £9,268 | £8,558 | £7,900 | £7,300 | £7,850 | £8,850 | £10,141 | £11,624 | £13,367 | £15,569 | £18,457 | £21,635 |
| 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 | £317 | £634 | £951 | £1,268 | £1,585 | £1,902 | £2,219 | £2,536 | £2,853 | £3,170 | £3,487 | £3,804 |
| Total Long-term Assets | £19,000 | £18,683 | £18,366 | £18,049 | £17,732 | £17,415 | £17,098 | £16,781 | £16,464 | £16,147 | £15,830 | £15,513 | £15,196 |
| Total Assets | £30,500 | £27,951 | £26,924 | £25,949 | £25,032 | £25,265 | £25,948 | £26,922 | £28,088 | £29,514 | £31,399 | £33,970 | £36,831 |
| 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 | £0 | £742 | £1,079 | £1,214 | £1,653 | £1,956 | £2,159 | £2,294 | £2,429 | £2,631 | £2,935 | £3,137 |
| 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 | £0 | £742 | £1,079 | £1,214 | £1,653 | £1,956 | £2,159 | £2,294 | £2,429 | £2,631 | £2,935 | £3,137 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £0 | £742 | £1,079 | £1,214 | £1,653 | £1,956 | £2,159 | £2,294 | £2,429 | £2,631 | £2,935 | £3,137 |
| Paid-in Capital | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 |
| Retained Earnings | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) |
| Earnings | £0 | (£2,549) | (£4,318) | (£5,630) | (£6,682) | (£6,888) | (£6,508) | (£5,737) | (£4,706) | (£3,415) | (£1,733) | £535 | £3,194 |
| Total Capital | £30,500 | £27,951 | £26,182 | £24,870 | £23,818 | £23,612 | £23,992 | £24,763 | £25,794 | £27,085 | £28,768 | £31,036 | £33,694 |
| Total Liabilities and Capital | £30,500 | £27,951 | £26,924 | £25,949 | £25,032 | £25,265 | £25,948 | £26,922 | £28,088 | £29,514 | £31,399 | £33,970 | £36,831 |
| Net Worth | £30,500 | £27,951 | £26,182 | £24,870 | £23,818 | £23,612 | £23,992 | £24,763 | £25,794 | £27,085 | £28,768 | £31,036 | £33,694 |
| 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 | |||||||||||||
| Used car purchasers | 0% | £0 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 | |
| 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 | |
| Used car purchasers | £0 | £84 | £133 | £161 | £252 | £315 | £357 | £385 | £413 | £455 | £518 | £560 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £84 | £133 | £161 | £252 | £315 | £357 | £385 | £413 | £455 | £518 | £560 | |
| 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% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Name or Title | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Name or Title | 0% | £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 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £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 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 | |
| Direct Cost of Sales | £0 | £84 | £133 | £161 | £252 | £315 | £357 | £385 | £413 | £455 | £518 | £560 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £84 | £133 | £161 | £252 | £315 | £357 | £385 | £413 | £455 | £518 | £560 | |
| Gross Margin | £0 | £1,116 | £1,767 | £2,139 | £3,348 | £4,185 | £4,743 | £5,115 | £5,487 | £6,045 | £6,882 | £7,440 | |
| Gross Margin % | 0.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | 93.00% | |
| Expenses | |||||||||||||
| Payroll | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Sales and Marketing and Other Expenses | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Depreciation | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| 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 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | £3,642 | |
| Profit Before Interest and Taxes | (£3,642) | (£2,526) | (£1,875) | (£1,503) | (£294) | £543 | £1,101 | £1,473 | £1,845 | £2,403 | £3,240 | £3,798 | |
| EBITDA | (£3,325) | (£2,209) | (£1,558) | (£1,186) | £23 | £860 | £1,418 | £1,790 | £2,162 | £2,720 | £3,557 | £4,115 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,093) | (£758) | (£563) | (£451) | (£88) | £163 | £330 | £442 | £554 | £721 | £972 | £1,139 | |
| Net Profit | (£2,549) | (£1,768) | (£1,313) | (£1,052) | (£206) | £380 | £771 | £1,031 | £1,292 | £1,682 | £2,268 | £2,659 | |
| Net Profit/Sales | 0.00% | -147.35% | -69.08% | -45.74% | -5.72% | 8.45% | 15.11% | 18.75% | 21.89% | 25.88% | 30.65% | 33.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 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 | |
| Subtotal Cash from Operations | £0 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 | |
| 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 | £1,200 | £1,900 | £2,300 | £3,600 | £4,500 | £5,100 | £5,500 | £5,900 | £6,500 | £7,400 | £8,000 | |
| 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 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Bill Payments | (£768) | (£1,091) | (£442) | (£100) | £50 | £499 | £810 | £1,017 | £1,157 | £1,298 | £1,511 | £1,822 | |
| Subtotal Spent on Operations | £2,232 | £1,909 | £2,558 | £2,900 | £3,050 | £3,499 | £3,810 | £4,017 | £4,157 | £4,298 | £4,511 | £4,822 | |
| 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,232 | £1,909 | £2,558 | £2,900 | £3,050 | £3,499 | £3,810 | £4,017 | £4,157 | £4,298 | £4,511 | £4,822 | |
| Net Cash Flow | (£2,232) | (£709) | (£658) | (£600) | £550 | £1,001 | £1,290 | £1,483 | £1,743 | £2,202 | £2,889 | £3,178 | |
| Cash Balance | £9,268 | £8,558 | £7,900 | £7,300 | £7,850 | £8,850 | £10,141 | £11,624 | £13,367 | £15,569 | £18,457 | £21,635 | |
| 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,500 | £9,268 | £8,558 | £7,900 | £7,300 | £7,850 | £8,850 | £10,141 | £11,624 | £13,367 | £15,569 | £18,457 | £21,635 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £11,500 | £9,268 | £8,558 | £7,900 | £7,300 | £7,850 | £8,850 | £10,141 | £11,624 | £13,367 | £15,569 | £18,457 | £21,635 |
| 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 | £317 | £634 | £951 | £1,268 | £1,585 | £1,902 | £2,219 | £2,536 | £2,853 | £3,170 | £3,487 | £3,804 |
| Total Long-term Assets | £19,000 | £18,683 | £18,366 | £18,049 | £17,732 | £17,415 | £17,098 | £16,781 | £16,464 | £16,147 | £15,830 | £15,513 | £15,196 |
| Total Assets | £30,500 | £27,951 | £26,924 | £25,949 | £25,032 | £25,265 | £25,948 | £26,922 | £28,088 | £29,514 | £31,399 | £33,970 | £36,831 |
| 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 | £0 | £742 | £1,079 | £1,214 | £1,653 | £1,956 | £2,159 | £2,294 | £2,429 | £2,631 | £2,935 | £3,137 |
| 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 | £0 | £742 | £1,079 | £1,214 | £1,653 | £1,956 | £2,159 | £2,294 | £2,429 | £2,631 | £2,935 | £3,137 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £0 | £742 | £1,079 | £1,214 | £1,653 | £1,956 | £2,159 | £2,294 | £2,429 | £2,631 | £2,935 | £3,137 |
| Paid-in Capital | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 |
| Retained Earnings | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) | (£1,500) |
| Earnings | £0 | (£2,549) | (£4,318) | (£5,630) | (£6,682) | (£6,888) | (£6,508) | (£5,737) | (£4,706) | (£3,415) | (£1,733) | £535 | £3,194 |
| Total Capital | £30,500 | £27,951 | £26,182 | £24,870 | £23,818 | £23,612 | £23,992 | £24,763 | £25,794 | £27,085 | £28,768 | £31,036 | £33,694 |
| Total Liabilities and Capital | £30,500 | £27,951 | £26,924 | £25,949 | £25,032 | £25,265 | £25,948 | £26,922 | £28,088 | £29,514 | £31,399 | £33,970 | £36,831 |
| Net Worth | £30,500 | £27,951 | £26,182 | £24,870 | £23,818 | £23,612 | £23,992 | £24,763 | £25,794 | £27,085 | £28,768 | £31,036 | £33,694 |