| 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 | |||||||||||||
| Funeral Products & Services | £5,884 | £5,884 | £5,884 | £5,884 | £11,768 | £11,768 | £11,768 | £17,652 | £17,682 | £23,536 | £23,535 | £29,420 | |
| Direct Cremations | £0 | £0 | £0 | £1,775 | £0 | £1,775 | £0 | £1,775 | £1,775 | £1,775 | £1,775 | £1,775 | |
| Total Sales | £5,884 | £5,884 | £5,884 | £7,659 | £11,768 | £13,543 | £11,768 | £19,427 | £19,457 | £25,311 | £25,310 | £31,195 | |
| 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 | |
| Funeral Products & Services | £2,059 | £2,059 | £2,059 | £2,059 | £4,119 | £4,119 | £4,119 | £6,178 | £6,189 | £8,238 | £8,237 | £10,297 | |
| Direct Cremations | £0 | £0 | £0 | £621 | £0 | £621 | £0 | £621 | £621 | £621 | £621 | £621 | |
| Subtotal Direct Cost of Sales | £2,059 | £2,059 | £2,059 | £2,681 | £4,119 | £4,740 | £4,119 | £6,799 | £6,810 | £8,859 | £8,859 | £10,918 | |
| 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 | 3% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Salesperson | 3% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Administrative Assistant | 3% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Staff Member | 3% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| Total Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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,884 | £5,884 | £5,884 | £7,659 | £11,768 | £13,543 | £11,768 | £19,427 | £19,457 | £25,311 | £25,310 | £31,195 | |
| Direct Cost of Sales | £2,059 | £2,059 | £2,059 | £2,681 | £4,119 | £4,740 | £4,119 | £6,799 | £6,810 | £8,859 | £8,859 | £10,918 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,059 | £2,059 | £2,059 | £2,681 | £4,119 | £4,740 | £4,119 | £6,799 | £6,810 | £8,859 | £8,859 | £10,918 | |
| Gross Margin | £3,825 | £3,825 | £3,825 | £4,978 | £7,649 | £8,803 | £7,649 | £12,628 | £12,647 | £16,452 | £16,452 | £20,277 | |
| Gross Margin % | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | |
| Expenses | |||||||||||||
| Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Marketing/Promotion | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Depreciation | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | |
| Mortgage Payments | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Payroll Taxes | 15% | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Auto Expenses | 15% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Supplies | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | |
| Profit Before Interest and Taxes | (£9,781) | (£9,781) | (£9,781) | (£8,628) | (£5,957) | (£4,803) | (£5,957) | (£978) | (£959) | £2,846 | £2,846 | £6,671 | |
| EBITDA | (£8,725) | (£8,725) | (£8,725) | (£7,572) | (£4,901) | (£3,747) | (£4,901) | £78 | £97 | £3,902 | £3,902 | £7,727 | |
| Interest Expense | £1,477 | £1,453 | £1,430 | £1,407 | £1,383 | £1,360 | £1,337 | £1,313 | £1,290 | £1,267 | £1,243 | £1,220 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£11,258) | (£11,235) | (£11,211) | (£10,034) | (£7,340) | (£6,163) | (£7,293) | (£2,292) | (£2,249) | £1,579 | £1,602 | £5,451 | |
| Net Profit/Sales | -191.33% | -190.94% | -190.54% | -131.01% | -62.37% | -45.51% | -61.98% | -11.80% | -11.56% | 6.24% | 6.33% | 17.47% | |
| 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,884 | £5,884 | £5,884 | £7,659 | £11,768 | £13,543 | £11,768 | £19,427 | £19,457 | £25,311 | £25,310 | £31,195 | |
| Subtotal Cash from Operations | £5,884 | £5,884 | £5,884 | £7,659 | £11,768 | £13,543 | £11,768 | £19,427 | £19,457 | £25,311 | £25,310 | £31,195 | |
| 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 | £5,884 | £5,884 | £5,884 | £7,659 | £11,768 | £13,543 | £11,768 | £19,427 | £19,457 | £25,311 | £25,310 | £31,195 | |
| 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 | £16,086 | £16,063 | £16,039 | £16,637 | £18,052 | £18,650 | £18,005 | £20,663 | £20,650 | £22,676 | £22,652 | £24,688 | |
| Subtotal Spent on Operations | £16,086 | £16,063 | £16,039 | £16,637 | £18,052 | £18,650 | £18,005 | £20,663 | £20,650 | £22,676 | £22,652 | £24,688 | |
| 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 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| 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 | £19,586 | £19,563 | £19,539 | £20,137 | £21,552 | £22,150 | £21,505 | £24,163 | £24,150 | £26,176 | £26,152 | £28,188 | |
| Net Cash Flow | (£13,702) | (£13,679) | (£13,655) | (£12,478) | (£9,784) | (£8,607) | (£9,737) | (£4,736) | (£4,693) | (£865) | (£842) | £3,007 | |
| Cash Balance | £104,598 | £90,919 | £77,264 | £64,785 | £55,001 | £46,394 | £36,657 | £31,921 | £27,228 | £26,364 | £25,522 | £28,529 | |
| 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 | £118,300 | £104,598 | £90,919 | £77,264 | £64,785 | £55,001 | £46,394 | £36,657 | £31,921 | £27,228 | £26,364 | £25,522 | £28,529 |
| Other Current Assets | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 |
| Total Current Assets | £145,300 | £131,598 | £117,919 | £104,264 | £91,785 | £82,001 | £73,394 | £63,657 | £58,921 | £54,228 | £53,364 | £52,522 | £55,529 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 |
| Accumulated Depreciation | £0 | £1,056 | £2,112 | £3,168 | £4,224 | £5,280 | £6,336 | £7,392 | £8,448 | £9,504 | £10,560 | £11,616 | £12,672 |
| Total Long-term Assets | £80,000 | £78,944 | £77,888 | £76,832 | £75,776 | £74,720 | £73,664 | £72,608 | £71,552 | £70,496 | £69,440 | £68,384 | £67,328 |
| Total Assets | £225,300 | £210,542 | £195,807 | £181,096 | £167,561 | £156,721 | £147,058 | £136,265 | £130,473 | £124,724 | £122,804 | £120,906 | £122,857 |
| 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 | |||||||||||||
| Current Borrowing | £225,000 | £221,500 | £218,000 | £214,500 | £211,000 | £207,500 | £204,000 | £200,500 | £197,000 | £193,500 | £190,000 | £186,500 | £183,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £225,000 | £221,500 | £218,000 | £214,500 | £211,000 | £207,500 | £204,000 | £200,500 | £197,000 | £193,500 | £190,000 | £186,500 | £183,000 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £225,000 | £221,500 | £218,000 | £214,500 | £211,000 | £207,500 | £204,000 | £200,500 | £197,000 | £193,500 | £190,000 | £186,500 | £183,000 |
| Paid-in Capital | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Retained Earnings | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) |
| Earnings | £0 | (£11,258) | (£22,493) | (£33,704) | (£43,739) | (£51,079) | (£57,242) | (£64,535) | (£66,827) | (£69,076) | (£67,496) | (£65,894) | (£60,443) |
| Total Capital | £300 | (£10,958) | (£22,193) | (£33,404) | (£43,439) | (£50,779) | (£56,942) | (£64,235) | (£66,527) | (£68,776) | (£67,196) | (£65,594) | (£60,143) |
| Total Liabilities and Capital | £225,300 | £210,542 | £195,807 | £181,096 | £167,561 | £156,721 | £147,058 | £136,265 | £130,473 | £124,724 | £122,804 | £120,906 | £122,857 |
| Net Worth | £300 | (£10,958) | (£22,193) | (£33,404) | (£43,439) | (£50,779) | (£56,942) | (£64,235) | (£66,527) | (£68,776) | (£67,196) | (£65,594) | (£60,144) |
| 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 | |||||||||||||
| Funeral Products & Services | £5,884 | £5,884 | £5,884 | £5,884 | £11,768 | £11,768 | £11,768 | £17,652 | £17,682 | £23,536 | £23,535 | £29,420 | |
| Direct Cremations | £0 | £0 | £0 | £1,775 | £0 | £1,775 | £0 | £1,775 | £1,775 | £1,775 | £1,775 | £1,775 | |
| Total Sales | £5,884 | £5,884 | £5,884 | £7,659 | £11,768 | £13,543 | £11,768 | £19,427 | £19,457 | £25,311 | £25,310 | £31,195 | |
| 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 | |
| Funeral Products & Services | £2,059 | £2,059 | £2,059 | £2,059 | £4,119 | £4,119 | £4,119 | £6,178 | £6,189 | £8,238 | £8,237 | £10,297 | |
| Direct Cremations | £0 | £0 | £0 | £621 | £0 | £621 | £0 | £621 | £621 | £621 | £621 | £621 | |
| Subtotal Direct Cost of Sales | £2,059 | £2,059 | £2,059 | £2,681 | £4,119 | £4,740 | £4,119 | £6,799 | £6,810 | £8,859 | £8,859 | £10,918 | |
| 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 | 3% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Salesperson | 3% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Administrative Assistant | 3% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Staff Member | 3% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| Total Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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,884 | £5,884 | £5,884 | £7,659 | £11,768 | £13,543 | £11,768 | £19,427 | £19,457 | £25,311 | £25,310 | £31,195 | |
| Direct Cost of Sales | £2,059 | £2,059 | £2,059 | £2,681 | £4,119 | £4,740 | £4,119 | £6,799 | £6,810 | £8,859 | £8,859 | £10,918 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,059 | £2,059 | £2,059 | £2,681 | £4,119 | £4,740 | £4,119 | £6,799 | £6,810 | £8,859 | £8,859 | £10,918 | |
| Gross Margin | £3,825 | £3,825 | £3,825 | £4,978 | £7,649 | £8,803 | £7,649 | £12,628 | £12,647 | £16,452 | £16,452 | £20,277 | |
| Gross Margin % | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | |
| Expenses | |||||||||||||
| Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Marketing/Promotion | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Depreciation | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | £1,056 | |
| Mortgage Payments | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Payroll Taxes | 15% | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Auto Expenses | 15% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Supplies | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | £13,606 | |
| Profit Before Interest and Taxes | (£9,781) | (£9,781) | (£9,781) | (£8,628) | (£5,957) | (£4,803) | (£5,957) | (£978) | (£959) | £2,846 | £2,846 | £6,671 | |
| EBITDA | (£8,725) | (£8,725) | (£8,725) | (£7,572) | (£4,901) | (£3,747) | (£4,901) | £78 | £97 | £3,902 | £3,902 | £7,727 | |
| Interest Expense | £1,477 | £1,453 | £1,430 | £1,407 | £1,383 | £1,360 | £1,337 | £1,313 | £1,290 | £1,267 | £1,243 | £1,220 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£11,258) | (£11,235) | (£11,211) | (£10,034) | (£7,340) | (£6,163) | (£7,293) | (£2,292) | (£2,249) | £1,579 | £1,602 | £5,451 | |
| Net Profit/Sales | -191.33% | -190.94% | -190.54% | -131.01% | -62.37% | -45.51% | -61.98% | -11.80% | -11.56% | 6.24% | 6.33% | 17.47% | |
| 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,884 | £5,884 | £5,884 | £7,659 | £11,768 | £13,543 | £11,768 | £19,427 | £19,457 | £25,311 | £25,310 | £31,195 | |
| Subtotal Cash from Operations | £5,884 | £5,884 | £5,884 | £7,659 | £11,768 | £13,543 | £11,768 | £19,427 | £19,457 | £25,311 | £25,310 | £31,195 | |
| 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 | £5,884 | £5,884 | £5,884 | £7,659 | £11,768 | £13,543 | £11,768 | £19,427 | £19,457 | £25,311 | £25,310 | £31,195 | |
| 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 | £16,086 | £16,063 | £16,039 | £16,637 | £18,052 | £18,650 | £18,005 | £20,663 | £20,650 | £22,676 | £22,652 | £24,688 | |
| Subtotal Spent on Operations | £16,086 | £16,063 | £16,039 | £16,637 | £18,052 | £18,650 | £18,005 | £20,663 | £20,650 | £22,676 | £22,652 | £24,688 | |
| 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 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| 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 | £19,586 | £19,563 | £19,539 | £20,137 | £21,552 | £22,150 | £21,505 | £24,163 | £24,150 | £26,176 | £26,152 | £28,188 | |
| Net Cash Flow | (£13,702) | (£13,679) | (£13,655) | (£12,478) | (£9,784) | (£8,607) | (£9,737) | (£4,736) | (£4,693) | (£865) | (£842) | £3,007 | |
| Cash Balance | £104,598 | £90,919 | £77,264 | £64,785 | £55,001 | £46,394 | £36,657 | £31,921 | £27,228 | £26,364 | £25,522 | £28,529 | |
| 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 | £118,300 | £104,598 | £90,919 | £77,264 | £64,785 | £55,001 | £46,394 | £36,657 | £31,921 | £27,228 | £26,364 | £25,522 | £28,529 |
| Other Current Assets | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 |
| Total Current Assets | £145,300 | £131,598 | £117,919 | £104,264 | £91,785 | £82,001 | £73,394 | £63,657 | £58,921 | £54,228 | £53,364 | £52,522 | £55,529 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 |
| Accumulated Depreciation | £0 | £1,056 | £2,112 | £3,168 | £4,224 | £5,280 | £6,336 | £7,392 | £8,448 | £9,504 | £10,560 | £11,616 | £12,672 |
| Total Long-term Assets | £80,000 | £78,944 | £77,888 | £76,832 | £75,776 | £74,720 | £73,664 | £72,608 | £71,552 | £70,496 | £69,440 | £68,384 | £67,328 |
| Total Assets | £225,300 | £210,542 | £195,807 | £181,096 | £167,561 | £156,721 | £147,058 | £136,265 | £130,473 | £124,724 | £122,804 | £120,906 | £122,857 |
| 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 | |||||||||||||
| Current Borrowing | £225,000 | £221,500 | £218,000 | £214,500 | £211,000 | £207,500 | £204,000 | £200,500 | £197,000 | £193,500 | £190,000 | £186,500 | £183,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £225,000 | £221,500 | £218,000 | £214,500 | £211,000 | £207,500 | £204,000 | £200,500 | £197,000 | £193,500 | £190,000 | £186,500 | £183,000 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £225,000 | £221,500 | £218,000 | £214,500 | £211,000 | £207,500 | £204,000 | £200,500 | £197,000 | £193,500 | £190,000 | £186,500 | £183,000 |
| Paid-in Capital | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Retained Earnings | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) | (£19,700) |
| Earnings | £0 | (£11,258) | (£22,493) | (£33,704) | (£43,739) | (£51,079) | (£57,242) | (£64,535) | (£66,827) | (£69,076) | (£67,496) | (£65,894) | (£60,443) |
| Total Capital | £300 | (£10,958) | (£22,193) | (£33,404) | (£43,439) | (£50,779) | (£56,942) | (£64,235) | (£66,527) | (£68,776) | (£67,196) | (£65,594) | (£60,143) |
| Total Liabilities and Capital | £225,300 | £210,542 | £195,807 | £181,096 | £167,561 | £156,721 | £147,058 | £136,265 | £130,473 | £124,724 | £122,804 | £120,906 | £122,857 |
| Net Worth | £300 | (£10,958) | (£22,193) | (£33,404) | (£43,439) | (£50,779) | (£56,942) | (£64,235) | (£66,527) | (£68,776) | (£67,196) | (£65,594) | (£60,144) |