| 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 | |||||||||||||
| Dog owners | 0% | £0 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 | |
| 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 | |
| Dog owners | £0 | £5 | £9 | £14 | £24 | £27 | £28 | £32 | £31 | £28 | £28 | £32 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £5 | £9 | £14 | £24 | £27 | £28 | £32 | £31 | £28 | £28 | £32 | |
| 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 | ||
| Payroll | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Other | 0% | £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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,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 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 | |
| Direct Cost of Sales | £0 | £5 | £9 | £14 | £24 | £27 | £28 | £32 | £31 | £28 | £28 | £32 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £5 | £9 | £14 | £24 | £27 | £28 | £32 | £31 | £28 | £28 | £32 | |
| Gross Margin | £0 | £225 | £441 | £686 | £1,176 | £1,323 | £1,372 | £1,568 | £1,519 | £1,372 | £1,372 | £1,568 | |
| Gross Margin % | 0.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | |
| Expenses | |||||||||||||
| Payroll | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Sales and Marketing and Other Expenses | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £50 | £50 | £50 | £50 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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/ license/ bonding | £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 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Profit Before Interest and Taxes | (£1,250) | (£1,025) | (£809) | (£564) | (£74) | £73 | £122 | £318 | £319 | £172 | £172 | £368 | |
| EBITDA | (£1,250) | (£1,025) | (£809) | (£564) | (£74) | £73 | £122 | £318 | £319 | £172 | £172 | £368 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£1,250) | (£1,025) | (£809) | (£564) | (£74) | £73 | £122 | £318 | £319 | £172 | £172 | £368 | |
| Net Profit/Sales | 0.00% | -445.48% | -179.78% | -80.57% | -6.17% | 5.41% | 8.71% | 19.88% | 20.58% | 12.29% | 12.29% | 23.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 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 | |
| Subtotal Cash from Operations | £0 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 | |
| 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 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Bill Payments | £8 | £250 | £255 | £259 | £264 | £274 | £277 | £278 | £280 | £231 | £228 | £228 | |
| Subtotal Spent on Operations | £1,008 | £1,250 | £1,255 | £1,259 | £1,264 | £1,274 | £1,277 | £1,278 | £1,280 | £1,231 | £1,228 | £1,228 | |
| 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 | £1,008 | £1,250 | £1,255 | £1,259 | £1,264 | £1,274 | £1,277 | £1,278 | £1,280 | £1,231 | £1,228 | £1,228 | |
| Net Cash Flow | (£1,008) | (£1,020) | (£805) | (£559) | (£64) | £76 | £123 | £322 | £270 | £169 | £172 | £372 | |
| Cash Balance | £3,192 | £2,172 | £1,367 | £808 | £743 | £819 | £942 | £1,264 | £1,534 | £1,703 | £1,875 | £2,247 | |
| 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 | £4,200 | £3,192 | £2,172 | £1,367 | £808 | £743 | £819 | £942 | £1,264 | £1,534 | £1,703 | £1,875 | £2,247 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £4,200 | £3,192 | £2,172 | £1,367 | £808 | £743 | £819 | £942 | £1,264 | £1,534 | £1,703 | £1,875 | £2,247 |
| 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 | £4,200 | £3,192 | £2,172 | £1,367 | £808 | £743 | £819 | £942 | £1,264 | £1,534 | £1,703 | £1,875 | £2,247 |
| 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 | £242 | £246 | £250 | £255 | £265 | £268 | £269 | £273 | £223 | £220 | £220 | £224 |
| 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 | £242 | £246 | £250 | £255 | £265 | £268 | £269 | £273 | £223 | £220 | £220 | £224 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £242 | £246 | £250 | £255 | £265 | £268 | £269 | £273 | £223 | £220 | £220 | £224 |
| Paid-in Capital | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Retained Earnings | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) |
| Earnings | £0 | (£1,250) | (£2,275) | (£3,084) | (£3,648) | (£3,722) | (£3,649) | (£3,527) | (£3,209) | (£2,890) | (£2,718) | (£2,546) | (£2,178) |
| Total Capital | £4,200 | £2,950 | £1,925 | £1,116 | £552 | £478 | £551 | £673 | £991 | £1,310 | £1,482 | £1,654 | £2,022 |
| Total Liabilities and Capital | £4,200 | £3,192 | £2,172 | £1,367 | £808 | £743 | £819 | £942 | £1,264 | £1,534 | £1,703 | £1,875 | £2,247 |
| Net Worth | £4,200 | £2,950 | £1,925 | £1,116 | £552 | £478 | £551 | £673 | £991 | £1,310 | £1,482 | £1,654 | £2,022 |
| 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 | |||||||||||||
| Dog owners | 0% | £0 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 | |
| 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 | |
| Dog owners | £0 | £5 | £9 | £14 | £24 | £27 | £28 | £32 | £31 | £28 | £28 | £32 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £5 | £9 | £14 | £24 | £27 | £28 | £32 | £31 | £28 | £28 | £32 | |
| 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 | ||
| Payroll | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Other | 0% | £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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,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 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 | |
| Direct Cost of Sales | £0 | £5 | £9 | £14 | £24 | £27 | £28 | £32 | £31 | £28 | £28 | £32 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £5 | £9 | £14 | £24 | £27 | £28 | £32 | £31 | £28 | £28 | £32 | |
| Gross Margin | £0 | £225 | £441 | £686 | £1,176 | £1,323 | £1,372 | £1,568 | £1,519 | £1,372 | £1,372 | £1,568 | |
| Gross Margin % | 0.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | |
| Expenses | |||||||||||||
| Payroll | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Sales and Marketing and Other Expenses | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £50 | £50 | £50 | £50 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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/ license/ bonding | £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 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Profit Before Interest and Taxes | (£1,250) | (£1,025) | (£809) | (£564) | (£74) | £73 | £122 | £318 | £319 | £172 | £172 | £368 | |
| EBITDA | (£1,250) | (£1,025) | (£809) | (£564) | (£74) | £73 | £122 | £318 | £319 | £172 | £172 | £368 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£1,250) | (£1,025) | (£809) | (£564) | (£74) | £73 | £122 | £318 | £319 | £172 | £172 | £368 | |
| Net Profit/Sales | 0.00% | -445.48% | -179.78% | -80.57% | -6.17% | 5.41% | 8.71% | 19.88% | 20.58% | 12.29% | 12.29% | 23.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 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 | |
| Subtotal Cash from Operations | £0 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 | |
| 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 | £230 | £450 | £700 | £1,200 | £1,350 | £1,400 | £1,600 | £1,550 | £1,400 | £1,400 | £1,600 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Bill Payments | £8 | £250 | £255 | £259 | £264 | £274 | £277 | £278 | £280 | £231 | £228 | £228 | |
| Subtotal Spent on Operations | £1,008 | £1,250 | £1,255 | £1,259 | £1,264 | £1,274 | £1,277 | £1,278 | £1,280 | £1,231 | £1,228 | £1,228 | |
| 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 | £1,008 | £1,250 | £1,255 | £1,259 | £1,264 | £1,274 | £1,277 | £1,278 | £1,280 | £1,231 | £1,228 | £1,228 | |
| Net Cash Flow | (£1,008) | (£1,020) | (£805) | (£559) | (£64) | £76 | £123 | £322 | £270 | £169 | £172 | £372 | |
| Cash Balance | £3,192 | £2,172 | £1,367 | £808 | £743 | £819 | £942 | £1,264 | £1,534 | £1,703 | £1,875 | £2,247 | |
| 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 | £4,200 | £3,192 | £2,172 | £1,367 | £808 | £743 | £819 | £942 | £1,264 | £1,534 | £1,703 | £1,875 | £2,247 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £4,200 | £3,192 | £2,172 | £1,367 | £808 | £743 | £819 | £942 | £1,264 | £1,534 | £1,703 | £1,875 | £2,247 |
| 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 | £4,200 | £3,192 | £2,172 | £1,367 | £808 | £743 | £819 | £942 | £1,264 | £1,534 | £1,703 | £1,875 | £2,247 |
| 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 | £242 | £246 | £250 | £255 | £265 | £268 | £269 | £273 | £223 | £220 | £220 | £224 |
| 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 | £242 | £246 | £250 | £255 | £265 | £268 | £269 | £273 | £223 | £220 | £220 | £224 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £242 | £246 | £250 | £255 | £265 | £268 | £269 | £273 | £223 | £220 | £220 | £224 |
| Paid-in Capital | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Retained Earnings | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) |
| Earnings | £0 | (£1,250) | (£2,275) | (£3,084) | (£3,648) | (£3,722) | (£3,649) | (£3,527) | (£3,209) | (£2,890) | (£2,718) | (£2,546) | (£2,178) |
| Total Capital | £4,200 | £2,950 | £1,925 | £1,116 | £552 | £478 | £551 | £673 | £991 | £1,310 | £1,482 | £1,654 | £2,022 |
| Total Liabilities and Capital | £4,200 | £3,192 | £2,172 | £1,367 | £808 | £743 | £819 | £942 | £1,264 | £1,534 | £1,703 | £1,875 | £2,247 |
| Net Worth | £4,200 | £2,950 | £1,925 | £1,116 | £552 | £478 | £551 | £673 | £991 | £1,310 | £1,482 | £1,654 | £2,022 |