| Funding Forecast | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Funding | |||||||||||||
| Dues | 0% | £5,000 | £5,000 | £2,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Monthly Meetings | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Motorcycle Show | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | £11,000 | £0 | £0 | £0 |
| SuperRide | 0% | £0 | £0 | £5,800 | £1,800 | £5,600 | £9,400 | £3,200 | £8,000 | £13,000 | £24,000 | £29,000 | £7,500 |
| Awards Banquet | 0% | £0 | £0 | £3,500 | £3,500 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Conference | 0% | £0 | £0 | £0 | £0 | £6,000 | £6,000 | £6,000 | £12,000 | £0 | £0 | £0 | £0 |
| Newsletter | 0% | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Total Funding | £5,600 | £5,600 | £12,400 | £5,900 | £22,200 | £16,000 | £9,800 | £30,600 | £24,600 | £24,600 | £29,600 | £8,100 | |
| Direct Cost of Funding | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
| Dues | £150 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Monthly Meetings | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Motorcycle Show | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | £9,000 | £0 | £0 | £0 | £0 | |
| SuperRide | £500 | £500 | £2,300 | £1,800 | £3,000 | £4,000 | £10,000 | £14,000 | £4,000 | £16,000 | £18,000 | £600 | |
| Awards Banquet | £0 | £0 | £1,000 | £0 | £12,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Conference | £0 | £0 | £6,000 | £500 | £500 | £0 | £500 | £8,000 | £0 | £0 | £0 | £0 | |
| Newsletter | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | |
| Subtotal Cost of Funding | £1,125 | £975 | £9,775 | £2,775 | £16,475 | £4,475 | £20,975 | £31,475 | £4,475 | £16,475 | £18,475 | £1,075 | |
| Personnel Plan | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Executive Director | 0% | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 |
| Other | 0% | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | |
| Surplus and Deficit | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Funding | £5,600 | £5,600 | £12,400 | £5,900 | £22,200 | £16,000 | £9,800 | £30,600 | £24,600 | £24,600 | £29,600 | £8,100 | |
| Direct Cost | £1,125 | £975 | £9,775 | £2,775 | £16,475 | £4,475 | £20,975 | £31,475 | £4,475 | £16,475 | £18,475 | £1,075 | |
| Other Costs of Funding | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Direct Cost | £1,125 | £975 | £9,775 | £2,775 | £16,475 | £4,475 | £20,975 | £31,475 | £4,475 | £16,475 | £18,475 | £1,075 | |
| Gross Surplus | £4,475 | £4,625 | £2,625 | £3,125 | £5,725 | £11,525 | (£11,175) | (£875) | £20,125 | £8,125 | £11,125 | £7,025 | |
| Gross Surplus % | 79.91% | 82.59% | 21.17% | 52.97% | 25.79% | 72.03% | -114.03% | -2.86% | 81.81% | 33.03% | 37.58% | 86.73% | |
| Expenses | |||||||||||||
| Payroll | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | |
| Marketing/Promotion | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Telephone Service | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| 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 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | |
| Surplus Before Interest and Taxes | £160 | £310 | (£1,690) | (£1,190) | £1,410 | £7,210 | (£15,490) | (£5,190) | £15,810 | £3,810 | £6,810 | £2,710 | |
| EBITDA | £160 | £310 | (£1,690) | (£1,190) | £1,410 | £7,210 | (£15,490) | (£5,190) | £15,810 | £3,810 | £6,810 | £2,710 | |
| 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 Surplus | £160 | £310 | (£1,690) | (£1,190) | £1,410 | £7,210 | (£15,490) | (£5,190) | £15,810 | £3,810 | £6,810 | £2,710 | |
| Net Surplus/Funding | 2.86% | 5.54% | -13.63% | -20.17% | 6.35% | 45.06% | -158.06% | -16.96% | 64.27% | 15.49% | 23.01% | 33.46% | |
| Pro Forma Cash Flow | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Funding | £5,600 | £5,600 | £12,400 | £5,900 | £22,200 | £16,000 | £9,800 | £30,600 | £24,600 | £24,600 | £29,600 | £8,100 | |
| Subtotal Cash from Operations | £5,600 | £5,600 | £12,400 | £5,900 | £22,200 | £16,000 | £9,800 | £30,600 | £24,600 | £24,600 | £29,600 | £8,100 | |
| 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,600 | £5,600 | £12,400 | £5,900 | £22,200 | £16,000 | £9,800 | £30,600 | £24,600 | £24,600 | £29,600 | £8,100 | |
| Expenditures | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | |
| Bill Payments | £61 | £1,835 | £1,983 | £10,257 | £3,947 | £16,790 | £5,740 | £22,040 | £31,290 | £5,590 | £17,257 | £18,610 | |
| Subtotal Spent on Operations | £3,661 | £5,435 | £5,583 | £13,857 | £7,547 | £20,390 | £9,340 | £25,640 | £34,890 | £9,190 | £20,857 | £22,210 | |
| 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 | £3,661 | £5,435 | £5,583 | £13,857 | £7,547 | £20,390 | £9,340 | £25,640 | £34,890 | £9,190 | £20,857 | £22,210 | |
| Net Cash Flow | £1,939 | £165 | £6,817 | (£7,957) | £14,653 | (£4,390) | £460 | £4,960 | (£10,290) | £15,410 | £8,743 | (£14,110) | |
| Cash Balance | £13,939 | £14,104 | £20,920 | £12,964 | £27,617 | £23,227 | £23,687 | £28,647 | £18,357 | £33,767 | £42,510 | £28,400 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £12,000 | £13,939 | £14,104 | £20,920 | £12,964 | £27,617 | £23,227 | £23,687 | £28,647 | £18,357 | £33,767 | £42,510 | £28,400 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £12,000 | £13,939 | £14,104 | £20,920 | £12,964 | £27,617 | £23,227 | £23,687 | £28,647 | £18,357 | £33,767 | £42,510 | £28,400 |
| 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 | £12,000 | £13,939 | £14,104 | £20,920 | £12,964 | £27,617 | £23,227 | £23,687 | £28,647 | £18,357 | £33,767 | £42,510 | £28,400 |
| Liabilities and Capital | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £1,779 | £1,634 | £10,140 | £3,374 | £16,617 | £5,017 | £20,967 | £31,117 | £5,017 | £16,617 | £18,550 | £1,730 |
| 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 | £1,779 | £1,634 | £10,140 | £3,374 | £16,617 | £5,017 | £20,967 | £31,117 | £5,017 | £16,617 | £18,550 | £1,730 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,779 | £1,634 | £10,140 | £3,374 | £16,617 | £5,017 | £20,967 | £31,117 | £5,017 | £16,617 | £18,550 | £1,730 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Surplus/Deficit | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Surplus/Deficit | £0 | £160 | £470 | (£1,220) | (£2,410) | (£1,000) | £6,210 | (£9,280) | (£14,470) | £1,340 | £5,150 | £11,960 | £14,670 |
| Total Capital | £12,000 | £12,160 | £12,470 | £10,780 | £9,590 | £11,000 | £18,210 | £2,720 | (£2,470) | £13,340 | £17,150 | £23,960 | £26,670 |
| Total Liabilities and Capital | £12,000 | £13,939 | £14,104 | £20,920 | £12,964 | £27,617 | £23,227 | £23,687 | £28,647 | £18,357 | £33,767 | £42,510 | £28,400 |
| Net Worth | £12,000 | £12,160 | £12,470 | £10,780 | £9,590 | £11,000 | £18,210 | £2,720 | (£2,470) | £13,340 | £17,150 | £23,960 | £26,670 |
| Funding Forecast | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Funding | |||||||||||||
| Dues | 0% | £5,000 | £5,000 | £2,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Monthly Meetings | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Motorcycle Show | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | £11,000 | £0 | £0 | £0 |
| SuperRide | 0% | £0 | £0 | £5,800 | £1,800 | £5,600 | £9,400 | £3,200 | £8,000 | £13,000 | £24,000 | £29,000 | £7,500 |
| Awards Banquet | 0% | £0 | £0 | £3,500 | £3,500 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Conference | 0% | £0 | £0 | £0 | £0 | £6,000 | £6,000 | £6,000 | £12,000 | £0 | £0 | £0 | £0 |
| Newsletter | 0% | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Total Funding | £5,600 | £5,600 | £12,400 | £5,900 | £22,200 | £16,000 | £9,800 | £30,600 | £24,600 | £24,600 | £29,600 | £8,100 | |
| Direct Cost of Funding | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
| Dues | £150 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Monthly Meetings | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Motorcycle Show | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | £9,000 | £0 | £0 | £0 | £0 | |
| SuperRide | £500 | £500 | £2,300 | £1,800 | £3,000 | £4,000 | £10,000 | £14,000 | £4,000 | £16,000 | £18,000 | £600 | |
| Awards Banquet | £0 | £0 | £1,000 | £0 | £12,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Conference | £0 | £0 | £6,000 | £500 | £500 | £0 | £500 | £8,000 | £0 | £0 | £0 | £0 | |
| Newsletter | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | |
| Subtotal Cost of Funding | £1,125 | £975 | £9,775 | £2,775 | £16,475 | £4,475 | £20,975 | £31,475 | £4,475 | £16,475 | £18,475 | £1,075 | |
| Personnel Plan | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Executive Director | 0% | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 | £3,250 |
| Other | 0% | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | |
| Surplus and Deficit | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Funding | £5,600 | £5,600 | £12,400 | £5,900 | £22,200 | £16,000 | £9,800 | £30,600 | £24,600 | £24,600 | £29,600 | £8,100 | |
| Direct Cost | £1,125 | £975 | £9,775 | £2,775 | £16,475 | £4,475 | £20,975 | £31,475 | £4,475 | £16,475 | £18,475 | £1,075 | |
| Other Costs of Funding | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Direct Cost | £1,125 | £975 | £9,775 | £2,775 | £16,475 | £4,475 | £20,975 | £31,475 | £4,475 | £16,475 | £18,475 | £1,075 | |
| Gross Surplus | £4,475 | £4,625 | £2,625 | £3,125 | £5,725 | £11,525 | (£11,175) | (£875) | £20,125 | £8,125 | £11,125 | £7,025 | |
| Gross Surplus % | 79.91% | 82.59% | 21.17% | 52.97% | 25.79% | 72.03% | -114.03% | -2.86% | 81.81% | 33.03% | 37.58% | 86.73% | |
| Expenses | |||||||||||||
| Payroll | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | |
| Marketing/Promotion | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Telephone Service | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| 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 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | £4,315 | |
| Surplus Before Interest and Taxes | £160 | £310 | (£1,690) | (£1,190) | £1,410 | £7,210 | (£15,490) | (£5,190) | £15,810 | £3,810 | £6,810 | £2,710 | |
| EBITDA | £160 | £310 | (£1,690) | (£1,190) | £1,410 | £7,210 | (£15,490) | (£5,190) | £15,810 | £3,810 | £6,810 | £2,710 | |
| 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 Surplus | £160 | £310 | (£1,690) | (£1,190) | £1,410 | £7,210 | (£15,490) | (£5,190) | £15,810 | £3,810 | £6,810 | £2,710 | |
| Net Surplus/Funding | 2.86% | 5.54% | -13.63% | -20.17% | 6.35% | 45.06% | -158.06% | -16.96% | 64.27% | 15.49% | 23.01% | 33.46% | |
| Pro Forma Cash Flow | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Funding | £5,600 | £5,600 | £12,400 | £5,900 | £22,200 | £16,000 | £9,800 | £30,600 | £24,600 | £24,600 | £29,600 | £8,100 | |
| Subtotal Cash from Operations | £5,600 | £5,600 | £12,400 | £5,900 | £22,200 | £16,000 | £9,800 | £30,600 | £24,600 | £24,600 | £29,600 | £8,100 | |
| 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,600 | £5,600 | £12,400 | £5,900 | £22,200 | £16,000 | £9,800 | £30,600 | £24,600 | £24,600 | £29,600 | £8,100 | |
| Expenditures | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | |
| Bill Payments | £61 | £1,835 | £1,983 | £10,257 | £3,947 | £16,790 | £5,740 | £22,040 | £31,290 | £5,590 | £17,257 | £18,610 | |
| Subtotal Spent on Operations | £3,661 | £5,435 | £5,583 | £13,857 | £7,547 | £20,390 | £9,340 | £25,640 | £34,890 | £9,190 | £20,857 | £22,210 | |
| 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 | £3,661 | £5,435 | £5,583 | £13,857 | £7,547 | £20,390 | £9,340 | £25,640 | £34,890 | £9,190 | £20,857 | £22,210 | |
| Net Cash Flow | £1,939 | £165 | £6,817 | (£7,957) | £14,653 | (£4,390) | £460 | £4,960 | (£10,290) | £15,410 | £8,743 | (£14,110) | |
| Cash Balance | £13,939 | £14,104 | £20,920 | £12,964 | £27,617 | £23,227 | £23,687 | £28,647 | £18,357 | £33,767 | £42,510 | £28,400 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £12,000 | £13,939 | £14,104 | £20,920 | £12,964 | £27,617 | £23,227 | £23,687 | £28,647 | £18,357 | £33,767 | £42,510 | £28,400 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £12,000 | £13,939 | £14,104 | £20,920 | £12,964 | £27,617 | £23,227 | £23,687 | £28,647 | £18,357 | £33,767 | £42,510 | £28,400 |
| 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 | £12,000 | £13,939 | £14,104 | £20,920 | £12,964 | £27,617 | £23,227 | £23,687 | £28,647 | £18,357 | £33,767 | £42,510 | £28,400 |
| Liabilities and Capital | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £1,779 | £1,634 | £10,140 | £3,374 | £16,617 | £5,017 | £20,967 | £31,117 | £5,017 | £16,617 | £18,550 | £1,730 |
| 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 | £1,779 | £1,634 | £10,140 | £3,374 | £16,617 | £5,017 | £20,967 | £31,117 | £5,017 | £16,617 | £18,550 | £1,730 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,779 | £1,634 | £10,140 | £3,374 | £16,617 | £5,017 | £20,967 | £31,117 | £5,017 | £16,617 | £18,550 | £1,730 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Surplus/Deficit | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Surplus/Deficit | £0 | £160 | £470 | (£1,220) | (£2,410) | (£1,000) | £6,210 | (£9,280) | (£14,470) | £1,340 | £5,150 | £11,960 | £14,670 |
| Total Capital | £12,000 | £12,160 | £12,470 | £10,780 | £9,590 | £11,000 | £18,210 | £2,720 | (£2,470) | £13,340 | £17,150 | £23,960 | £26,670 |
| Total Liabilities and Capital | £12,000 | £13,939 | £14,104 | £20,920 | £12,964 | £27,617 | £23,227 | £23,687 | £28,647 | £18,357 | £33,767 | £42,510 | £28,400 |
| Net Worth | £12,000 | £12,160 | £12,470 | £10,780 | £9,590 | £11,000 | £18,210 | £2,720 | (£2,470) | £13,340 | £17,150 | £23,960 | £26,670 |