| 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 | |||||||||||||
| Meeting Planning | 0% | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £11,888 | £11,888 | £12,888 | £11,888 | £11,888 | £11,888 | £11,888 |
| Resource One Referrals | 0% | £0 | £0 | £0 | £0 | £0 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Total Sales | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| 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 | |
| Meeting Planning | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Resource One Referrals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £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 | ||
| T. Latkovic | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| K. Feltenberg | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,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 | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| Direct Cost of Sales | £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 Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Sales and Marketing and Other Expenses | £275 | £315 | £315 | £315 | £315 | £365 | £365 | £467 | £467 | £467 | £467 | £467 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales Telephone Cost | £484 | £484 | £484 | £484 | £484 | £484 | £484 | £484 | £484 | £484 | £484 | £484 | |
| Service Telephone Cost | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Sales On-line Service | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | |
| Service On-line Service | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | |
| Payroll Taxes | 20% | £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 | £8,953 | £8,993 | £8,993 | £8,993 | £8,993 | £9,043 | £9,043 | £9,145 | £9,145 | £9,145 | £9,145 | £9,145 | |
| Profit Before Interest and Taxes | (£5,953) | (£1,993) | (£993) | (£1,993) | (£1,993) | £3,445 | £3,445 | £4,343 | £3,343 | £3,343 | £3,343 | £3,343 | |
| EBITDA | (£5,953) | (£1,993) | (£993) | (£1,993) | (£1,993) | £3,445 | £3,445 | £4,343 | £3,343 | £3,343 | £3,343 | £3,343 | |
| Interest Expense | £408 | £399 | £390 | £381 | £372 | £363 | £354 | £345 | £337 | £328 | £319 | £310 | |
| Taxes Incurred | (£1,590) | (£598) | (£346) | (£594) | (£591) | £770 | £773 | £999 | £752 | £754 | £756 | £758 | |
| Net Profit | (£4,771) | (£1,794) | (£1,037) | (£1,781) | (£1,774) | £2,311 | £2,318 | £2,998 | £2,255 | £2,262 | £2,268 | £2,275 | |
| Net Profit/Sales | -159.02% | -25.63% | -12.97% | -25.44% | -25.34% | 18.51% | 18.56% | 22.23% | 18.06% | 18.11% | 18.16% | 18.22% | |
| 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 | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| Subtotal Cash from Operations | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| 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 | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| 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 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Bill Payments | (£229) | (£195) | £802 | £1,029 | £780 | £821 | £2,176 | £2,181 | £2,481 | £2,233 | £2,226 | £2,220 | |
| Subtotal Spent on Operations | £7,771 | £7,805 | £8,802 | £9,029 | £8,780 | £8,821 | £10,176 | £10,181 | £10,481 | £10,233 | £10,226 | £10,220 | |
| 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 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | |
| 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 | £8,839 | £8,873 | £9,871 | £10,097 | £9,849 | £9,889 | £11,245 | £11,249 | £11,550 | £11,301 | £11,295 | £11,288 | |
| Net Cash Flow | (£5,839) | (£1,873) | (£1,871) | (£3,097) | (£2,849) | £2,599 | £1,243 | £2,239 | £938 | £1,187 | £1,193 | £1,200 | |
| Cash Balance | £44,161 | £42,288 | £40,417 | £37,320 | £34,471 | £37,070 | £38,313 | £40,552 | £41,490 | £42,677 | £43,870 | £45,070 | |
| 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 | £50,000 | £44,161 | £42,288 | £40,417 | £37,320 | £34,471 | £37,070 | £38,313 | £40,552 | £41,490 | £42,677 | £43,870 | £45,070 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £50,000 | £44,161 | £42,288 | £40,417 | £37,320 | £34,471 | £37,070 | £38,313 | £40,552 | £41,490 | £42,677 | £43,870 | £45,070 |
| 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 | £50,000 | £44,161 | £42,288 | £40,417 | £37,320 | £34,471 | £37,070 | £38,313 | £40,552 | £41,490 | £42,677 | £43,870 | £45,070 |
| 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 | £989 | £1,224 | £976 | £970 | £2,326 | £2,319 | £2,629 | £2,380 | £2,374 | £2,368 | £2,361 |
| 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 | £989 | £1,224 | £976 | £970 | £2,326 | £2,319 | £2,629 | £2,380 | £2,374 | £2,368 | £2,361 |
| Long-term Liabilities | £50,000 | £48,931 | £47,863 | £46,794 | £45,726 | £44,657 | £43,589 | £42,520 | £41,452 | £40,383 | £39,315 | £38,246 | £37,178 |
| Total Liabilities | £50,000 | £48,931 | £48,852 | £48,019 | £46,702 | £45,627 | £45,915 | £44,840 | £44,081 | £42,764 | £41,689 | £40,614 | £39,539 |
| Paid-in Capital | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 |
| Retained Earnings | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) |
| Earnings | £0 | (£4,771) | (£6,564) | (£7,602) | (£9,382) | (£11,156) | (£8,845) | (£6,527) | (£3,529) | (£1,274) | £988 | £3,256 | £5,531 |
| Total Capital | £0 | (£4,771) | (£6,564) | (£7,602) | (£9,382) | (£11,156) | (£8,845) | (£6,527) | (£3,529) | (£1,274) | £988 | £3,256 | £5,531 |
| Total Liabilities and Capital | £50,000 | £44,161 | £42,288 | £40,417 | £37,320 | £34,471 | £37,070 | £38,313 | £40,552 | £41,490 | £42,677 | £43,870 | £45,070 |
| Net Worth | £0 | (£4,771) | (£6,564) | (£7,602) | (£9,382) | (£11,156) | (£8,845) | (£6,527) | (£3,529) | (£1,274) | £988 | £3,256 | £5,531 |
| 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 | |||||||||||||
| Meeting Planning | 0% | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £11,888 | £11,888 | £12,888 | £11,888 | £11,888 | £11,888 | £11,888 |
| Resource One Referrals | 0% | £0 | £0 | £0 | £0 | £0 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Total Sales | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| 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 | |
| Meeting Planning | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Resource One Referrals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £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 | ||
| T. Latkovic | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| K. Feltenberg | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,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 | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| Direct Cost of Sales | £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 Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Sales and Marketing and Other Expenses | £275 | £315 | £315 | £315 | £315 | £365 | £365 | £467 | £467 | £467 | £467 | £467 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales Telephone Cost | £484 | £484 | £484 | £484 | £484 | £484 | £484 | £484 | £484 | £484 | £484 | £484 | |
| Service Telephone Cost | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Sales On-line Service | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | |
| Service On-line Service | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | |
| Payroll Taxes | 20% | £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 | £8,953 | £8,993 | £8,993 | £8,993 | £8,993 | £9,043 | £9,043 | £9,145 | £9,145 | £9,145 | £9,145 | £9,145 | |
| Profit Before Interest and Taxes | (£5,953) | (£1,993) | (£993) | (£1,993) | (£1,993) | £3,445 | £3,445 | £4,343 | £3,343 | £3,343 | £3,343 | £3,343 | |
| EBITDA | (£5,953) | (£1,993) | (£993) | (£1,993) | (£1,993) | £3,445 | £3,445 | £4,343 | £3,343 | £3,343 | £3,343 | £3,343 | |
| Interest Expense | £408 | £399 | £390 | £381 | £372 | £363 | £354 | £345 | £337 | £328 | £319 | £310 | |
| Taxes Incurred | (£1,590) | (£598) | (£346) | (£594) | (£591) | £770 | £773 | £999 | £752 | £754 | £756 | £758 | |
| Net Profit | (£4,771) | (£1,794) | (£1,037) | (£1,781) | (£1,774) | £2,311 | £2,318 | £2,998 | £2,255 | £2,262 | £2,268 | £2,275 | |
| Net Profit/Sales | -159.02% | -25.63% | -12.97% | -25.44% | -25.34% | 18.51% | 18.56% | 22.23% | 18.06% | 18.11% | 18.16% | 18.22% | |
| 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 | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| Subtotal Cash from Operations | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| 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 | £3,000 | £7,000 | £8,000 | £7,000 | £7,000 | £12,488 | £12,488 | £13,488 | £12,488 | £12,488 | £12,488 | £12,488 | |
| 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 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Bill Payments | (£229) | (£195) | £802 | £1,029 | £780 | £821 | £2,176 | £2,181 | £2,481 | £2,233 | £2,226 | £2,220 | |
| Subtotal Spent on Operations | £7,771 | £7,805 | £8,802 | £9,029 | £8,780 | £8,821 | £10,176 | £10,181 | £10,481 | £10,233 | £10,226 | £10,220 | |
| 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 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | £1,069 | |
| 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 | £8,839 | £8,873 | £9,871 | £10,097 | £9,849 | £9,889 | £11,245 | £11,249 | £11,550 | £11,301 | £11,295 | £11,288 | |
| Net Cash Flow | (£5,839) | (£1,873) | (£1,871) | (£3,097) | (£2,849) | £2,599 | £1,243 | £2,239 | £938 | £1,187 | £1,193 | £1,200 | |
| Cash Balance | £44,161 | £42,288 | £40,417 | £37,320 | £34,471 | £37,070 | £38,313 | £40,552 | £41,490 | £42,677 | £43,870 | £45,070 | |
| 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 | £50,000 | £44,161 | £42,288 | £40,417 | £37,320 | £34,471 | £37,070 | £38,313 | £40,552 | £41,490 | £42,677 | £43,870 | £45,070 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £50,000 | £44,161 | £42,288 | £40,417 | £37,320 | £34,471 | £37,070 | £38,313 | £40,552 | £41,490 | £42,677 | £43,870 | £45,070 |
| 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 | £50,000 | £44,161 | £42,288 | £40,417 | £37,320 | £34,471 | £37,070 | £38,313 | £40,552 | £41,490 | £42,677 | £43,870 | £45,070 |
| 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 | £989 | £1,224 | £976 | £970 | £2,326 | £2,319 | £2,629 | £2,380 | £2,374 | £2,368 | £2,361 |
| 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 | £989 | £1,224 | £976 | £970 | £2,326 | £2,319 | £2,629 | £2,380 | £2,374 | £2,368 | £2,361 |
| Long-term Liabilities | £50,000 | £48,931 | £47,863 | £46,794 | £45,726 | £44,657 | £43,589 | £42,520 | £41,452 | £40,383 | £39,315 | £38,246 | £37,178 |
| Total Liabilities | £50,000 | £48,931 | £48,852 | £48,019 | £46,702 | £45,627 | £45,915 | £44,840 | £44,081 | £42,764 | £41,689 | £40,614 | £39,539 |
| Paid-in Capital | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 |
| Retained Earnings | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) | (£4,800) |
| Earnings | £0 | (£4,771) | (£6,564) | (£7,602) | (£9,382) | (£11,156) | (£8,845) | (£6,527) | (£3,529) | (£1,274) | £988 | £3,256 | £5,531 |
| Total Capital | £0 | (£4,771) | (£6,564) | (£7,602) | (£9,382) | (£11,156) | (£8,845) | (£6,527) | (£3,529) | (£1,274) | £988 | £3,256 | £5,531 |
| Total Liabilities and Capital | £50,000 | £44,161 | £42,288 | £40,417 | £37,320 | £34,471 | £37,070 | £38,313 | £40,552 | £41,490 | £42,677 | £43,870 | £45,070 |
| Net Worth | £0 | (£4,771) | (£6,564) | (£7,602) | (£9,382) | (£11,156) | (£8,845) | (£6,527) | (£3,529) | (£1,274) | £988 | £3,256 | £5,531 |