| Funding 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 | ||
| Funding | |||||||||||||
| United Way | 0% | £0 | £0 | £0 | £60,000 | £0 | £0 | £0 | £0 | £55,000 | £0 | £0 | £0 |
| Federal Government | 0% | £0 | £0 | £10,000 | £10,000 | £5,000 | £25,000 | £0 | £0 | £0 | £0 | £20,000 | £0 |
| Local Government | 0% | £0 | £0 | £12,000 | £0 | £20,000 | £0 | £1,500 | £5,000 | £0 | £0 | £0 | £0 |
| Corporations/Individuals | 0% | £0 | £0 | £5,000 | £2,500 | £7,000 | £6,000 | £15,000 | £9,000 | £12,000 | £0 | £2,000 | £1,500 |
| Organizational Activities | 0% | £0 | £0 | £0 | £0 | £8,000 | £0 | £0 | £500 | £0 | £12,000 | £0 | £0 |
| Total Funding | £0 | £0 | £27,000 | £72,500 | £40,000 | £31,000 | £16,500 | £14,500 | £67,000 | £12,000 | £22,000 | £1,500 | |
| Direct Cost of Funding | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenses for Organizational Activities | £0 | £0 | £0 | £0 | £960 | £0 | £0 | £60 | £0 | £1,440 | £0 | £0 | |
| Administrative Expenses | £0 | £0 | £3,645 | £9,788 | £5,400 | £4,185 | £2,228 | £1,958 | £9,045 | £1,620 | £2,970 | £203 | |
| Subtotal Cost of Funding | £0 | £0 | £3,645 | £9,788 | £6,360 | £4,185 | £2,228 | £2,018 | £9,045 | £3,060 | £2,970 | £203 | |
| 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 | ||
| Executive Director | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Associate Director | 0% | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Chemical Dependency Counselor | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| AIDS Counselor | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £800 | £800 | £800 | £800 | £800 | £800 |
| Family Reunification Counselor | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Admin Staff | 0% | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Admin Staff | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total People | 0 | 0 | 1 | 1 | 1 | 3 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £0 | £0 | £2,000 | £2,000 | £2,000 | £6,000 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | |
| 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 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Surplus and Deficit | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Funding | £0 | £0 | £27,000 | £72,500 | £40,000 | £31,000 | £16,500 | £14,500 | £67,000 | £12,000 | £22,000 | £1,500 | |
| Direct Cost | £0 | £0 | £3,645 | £9,788 | £6,360 | £4,185 | £2,228 | £2,018 | £9,045 | £3,060 | £2,970 | £203 | |
| Other Costs of Funding | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Direct Cost | £0 | £0 | £3,645 | £9,788 | £6,360 | £4,185 | £2,228 | £2,018 | £9,045 | £3,060 | £2,970 | £203 | |
| Gross Surplus | £0 | £0 | £23,355 | £62,713 | £33,640 | £26,815 | £14,273 | £12,483 | £57,955 | £8,940 | £19,030 | £1,298 | |
| Gross Surplus % | 0.00% | 0.00% | 86.50% | 86.50% | 84.10% | 86.50% | 86.50% | 86.09% | 86.50% | 74.50% | 86.50% | 86.50% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £2,000 | £2,000 | £2,000 | £6,000 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | |
| Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £383 | £383 | £383 | £383 | £383 | £383 | £383 | £383 | £383 | £383 | £383 | £383 | |
| Leased Building | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Utilities | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Insurance | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Payroll Taxes | 15% | £0 | £0 | £300 | £300 | £300 | £900 | £1,770 | £1,770 | £1,770 | £1,770 | £1,770 | £1,770 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £7,183 | £7,183 | £9,483 | £9,483 | £9,483 | £14,083 | £20,753 | £20,753 | £20,753 | £20,753 | £20,753 | £20,753 | |
| Surplus Before Interest and Taxes | (£7,183) | (£7,183) | £13,872 | £53,230 | £24,157 | £12,732 | (£6,481) | (£8,271) | £37,202 | (£11,813) | (£1,723) | (£19,456) | |
| EBITDA | (£6,800) | (£6,800) | £14,255 | £53,613 | £24,540 | £13,115 | (£6,098) | (£7,888) | £37,585 | (£11,430) | (£1,340) | (£19,073) | |
| 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 | (£7,183) | (£7,183) | £13,872 | £53,230 | £24,157 | £12,732 | (£6,481) | (£8,271) | £37,202 | (£11,813) | (£1,723) | (£19,456) | |
| Net Surplus/Funding | 0.00% | 0.00% | 51.38% | 73.42% | 60.39% | 41.07% | -39.28% | -57.04% | 55.53% | -98.44% | -7.83% | -1297.03% | |
| 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 Funding | £0 | £0 | £27,000 | £72,500 | £40,000 | £31,000 | £16,500 | £14,500 | £67,000 | £12,000 | £22,000 | £1,500 | |
| Subtotal Cash from Operations | £0 | £0 | £27,000 | £72,500 | £40,000 | £31,000 | £16,500 | £14,500 | £67,000 | £12,000 | £22,000 | £1,500 | |
| 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 | £0 | £27,000 | £72,500 | £40,000 | £31,000 | £16,500 | £14,500 | £67,000 | £12,000 | £22,000 | £1,500 | |
| 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 | £0 | £0 | £2,000 | £2,000 | £2,000 | £6,000 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | |
| Bill Payments | £227 | £6,800 | £6,932 | £10,950 | £16,773 | £13,408 | £11,849 | £10,791 | £10,822 | £17,416 | £11,627 | £11,448 | |
| Subtotal Spent on Operations | £227 | £6,800 | £8,932 | £12,950 | £18,773 | £19,408 | £23,649 | £22,591 | £22,622 | £29,216 | £23,427 | £23,248 | |
| 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 | £227 | £6,800 | £8,932 | £12,950 | £18,773 | £19,408 | £23,649 | £22,591 | £22,622 | £29,216 | £23,427 | £23,248 | |
| Net Cash Flow | (£227) | (£6,800) | £18,069 | £59,550 | £21,227 | £11,593 | (£7,149) | (£8,091) | £44,378 | (£17,216) | (£1,427) | (£21,748) | |
| Cash Balance | £17,773 | £10,973 | £29,042 | £88,592 | £109,819 | £121,411 | £114,263 | £106,172 | £150,550 | £133,335 | £131,908 | £110,160 | |
| 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 | £18,000 | £17,773 | £10,973 | £29,042 | £88,592 | £109,819 | £121,411 | £114,263 | £106,172 | £150,550 | £133,335 | £131,908 | £110,160 |
| Other Current Assets | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 |
| Total Current Assets | £41,000 | £40,773 | £33,973 | £52,042 | £111,592 | £132,819 | £144,411 | £137,263 | £129,172 | £173,550 | £156,335 | £154,908 | £133,160 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £383 | £766 | £1,149 | £1,532 | £1,915 | £2,298 | £2,681 | £3,064 | £3,447 | £3,830 | £4,213 | £4,596 |
| Total Long-term Assets | £0 | (£383) | (£766) | (£1,149) | (£1,532) | (£1,915) | (£2,298) | (£2,681) | (£3,064) | (£3,447) | (£3,830) | (£4,213) | (£4,596) |
| Total Assets | £41,000 | £40,390 | £33,207 | £50,893 | £110,060 | £130,904 | £142,113 | £134,582 | £126,108 | £170,103 | £152,505 | £150,695 | £128,564 |
| 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 | £6,573 | £6,573 | £10,387 | £16,325 | £13,011 | £11,489 | £10,438 | £10,235 | £17,028 | £11,242 | £11,155 | £8,480 |
| 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 | £6,573 | £6,573 | £10,387 | £16,325 | £13,011 | £11,489 | £10,438 | £10,235 | £17,028 | £11,242 | £11,155 | £8,480 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £6,573 | £6,573 | £10,387 | £16,325 | £13,011 | £11,489 | £10,438 | £10,235 | £17,028 | £11,242 | £11,155 | £8,480 |
| Paid-in Capital | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| Accumulated Surplus/Deficit | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) |
| Surplus/Deficit | £0 | (£7,183) | (£14,366) | (£494) | £52,736 | £76,893 | £89,625 | £83,144 | £74,874 | £112,076 | £100,263 | £98,540 | £79,084 |
| Total Capital | £41,000 | £33,817 | £26,634 | £40,506 | £93,736 | £117,893 | £130,625 | £124,144 | £115,874 | £153,076 | £141,263 | £139,540 | £120,084 |
| Total Liabilities and Capital | £41,000 | £40,390 | £33,207 | £50,893 | £110,060 | £130,904 | £142,113 | £134,582 | £126,108 | £170,103 | £152,505 | £150,695 | £128,564 |
| Net Worth | £41,000 | £33,817 | £26,634 | £40,506 | £93,736 | £117,892 | £130,624 | £124,144 | £115,873 | £153,076 | £141,263 | £139,540 | £120,084 |
| Funding 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 | ||
| Funding | |||||||||||||
| United Way | 0% | £0 | £0 | £0 | £60,000 | £0 | £0 | £0 | £0 | £55,000 | £0 | £0 | £0 |
| Federal Government | 0% | £0 | £0 | £10,000 | £10,000 | £5,000 | £25,000 | £0 | £0 | £0 | £0 | £20,000 | £0 |
| Local Government | 0% | £0 | £0 | £12,000 | £0 | £20,000 | £0 | £1,500 | £5,000 | £0 | £0 | £0 | £0 |
| Corporations/Individuals | 0% | £0 | £0 | £5,000 | £2,500 | £7,000 | £6,000 | £15,000 | £9,000 | £12,000 | £0 | £2,000 | £1,500 |
| Organizational Activities | 0% | £0 | £0 | £0 | £0 | £8,000 | £0 | £0 | £500 | £0 | £12,000 | £0 | £0 |
| Total Funding | £0 | £0 | £27,000 | £72,500 | £40,000 | £31,000 | £16,500 | £14,500 | £67,000 | £12,000 | £22,000 | £1,500 | |
| Direct Cost of Funding | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenses for Organizational Activities | £0 | £0 | £0 | £0 | £960 | £0 | £0 | £60 | £0 | £1,440 | £0 | £0 | |
| Administrative Expenses | £0 | £0 | £3,645 | £9,788 | £5,400 | £4,185 | £2,228 | £1,958 | £9,045 | £1,620 | £2,970 | £203 | |
| Subtotal Cost of Funding | £0 | £0 | £3,645 | £9,788 | £6,360 | £4,185 | £2,228 | £2,018 | £9,045 | £3,060 | £2,970 | £203 | |
| 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 | ||
| Executive Director | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Associate Director | 0% | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Chemical Dependency Counselor | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| AIDS Counselor | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £800 | £800 | £800 | £800 | £800 | £800 |
| Family Reunification Counselor | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Admin Staff | 0% | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Admin Staff | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total People | 0 | 0 | 1 | 1 | 1 | 3 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £0 | £0 | £2,000 | £2,000 | £2,000 | £6,000 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | |
| 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 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Surplus and Deficit | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Funding | £0 | £0 | £27,000 | £72,500 | £40,000 | £31,000 | £16,500 | £14,500 | £67,000 | £12,000 | £22,000 | £1,500 | |
| Direct Cost | £0 | £0 | £3,645 | £9,788 | £6,360 | £4,185 | £2,228 | £2,018 | £9,045 | £3,060 | £2,970 | £203 | |
| Other Costs of Funding | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Direct Cost | £0 | £0 | £3,645 | £9,788 | £6,360 | £4,185 | £2,228 | £2,018 | £9,045 | £3,060 | £2,970 | £203 | |
| Gross Surplus | £0 | £0 | £23,355 | £62,713 | £33,640 | £26,815 | £14,273 | £12,483 | £57,955 | £8,940 | £19,030 | £1,298 | |
| Gross Surplus % | 0.00% | 0.00% | 86.50% | 86.50% | 84.10% | 86.50% | 86.50% | 86.09% | 86.50% | 74.50% | 86.50% | 86.50% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £2,000 | £2,000 | £2,000 | £6,000 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | |
| Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £383 | £383 | £383 | £383 | £383 | £383 | £383 | £383 | £383 | £383 | £383 | £383 | |
| Leased Building | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Utilities | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Insurance | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Payroll Taxes | 15% | £0 | £0 | £300 | £300 | £300 | £900 | £1,770 | £1,770 | £1,770 | £1,770 | £1,770 | £1,770 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £7,183 | £7,183 | £9,483 | £9,483 | £9,483 | £14,083 | £20,753 | £20,753 | £20,753 | £20,753 | £20,753 | £20,753 | |
| Surplus Before Interest and Taxes | (£7,183) | (£7,183) | £13,872 | £53,230 | £24,157 | £12,732 | (£6,481) | (£8,271) | £37,202 | (£11,813) | (£1,723) | (£19,456) | |
| EBITDA | (£6,800) | (£6,800) | £14,255 | £53,613 | £24,540 | £13,115 | (£6,098) | (£7,888) | £37,585 | (£11,430) | (£1,340) | (£19,073) | |
| 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 | (£7,183) | (£7,183) | £13,872 | £53,230 | £24,157 | £12,732 | (£6,481) | (£8,271) | £37,202 | (£11,813) | (£1,723) | (£19,456) | |
| Net Surplus/Funding | 0.00% | 0.00% | 51.38% | 73.42% | 60.39% | 41.07% | -39.28% | -57.04% | 55.53% | -98.44% | -7.83% | -1297.03% | |
| 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 Funding | £0 | £0 | £27,000 | £72,500 | £40,000 | £31,000 | £16,500 | £14,500 | £67,000 | £12,000 | £22,000 | £1,500 | |
| Subtotal Cash from Operations | £0 | £0 | £27,000 | £72,500 | £40,000 | £31,000 | £16,500 | £14,500 | £67,000 | £12,000 | £22,000 | £1,500 | |
| 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 | £0 | £27,000 | £72,500 | £40,000 | £31,000 | £16,500 | £14,500 | £67,000 | £12,000 | £22,000 | £1,500 | |
| 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 | £0 | £0 | £2,000 | £2,000 | £2,000 | £6,000 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | £11,800 | |
| Bill Payments | £227 | £6,800 | £6,932 | £10,950 | £16,773 | £13,408 | £11,849 | £10,791 | £10,822 | £17,416 | £11,627 | £11,448 | |
| Subtotal Spent on Operations | £227 | £6,800 | £8,932 | £12,950 | £18,773 | £19,408 | £23,649 | £22,591 | £22,622 | £29,216 | £23,427 | £23,248 | |
| 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 | £227 | £6,800 | £8,932 | £12,950 | £18,773 | £19,408 | £23,649 | £22,591 | £22,622 | £29,216 | £23,427 | £23,248 | |
| Net Cash Flow | (£227) | (£6,800) | £18,069 | £59,550 | £21,227 | £11,593 | (£7,149) | (£8,091) | £44,378 | (£17,216) | (£1,427) | (£21,748) | |
| Cash Balance | £17,773 | £10,973 | £29,042 | £88,592 | £109,819 | £121,411 | £114,263 | £106,172 | £150,550 | £133,335 | £131,908 | £110,160 | |
| 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 | £18,000 | £17,773 | £10,973 | £29,042 | £88,592 | £109,819 | £121,411 | £114,263 | £106,172 | £150,550 | £133,335 | £131,908 | £110,160 |
| Other Current Assets | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 | £23,000 |
| Total Current Assets | £41,000 | £40,773 | £33,973 | £52,042 | £111,592 | £132,819 | £144,411 | £137,263 | £129,172 | £173,550 | £156,335 | £154,908 | £133,160 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £383 | £766 | £1,149 | £1,532 | £1,915 | £2,298 | £2,681 | £3,064 | £3,447 | £3,830 | £4,213 | £4,596 |
| Total Long-term Assets | £0 | (£383) | (£766) | (£1,149) | (£1,532) | (£1,915) | (£2,298) | (£2,681) | (£3,064) | (£3,447) | (£3,830) | (£4,213) | (£4,596) |
| Total Assets | £41,000 | £40,390 | £33,207 | £50,893 | £110,060 | £130,904 | £142,113 | £134,582 | £126,108 | £170,103 | £152,505 | £150,695 | £128,564 |
| 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 | £6,573 | £6,573 | £10,387 | £16,325 | £13,011 | £11,489 | £10,438 | £10,235 | £17,028 | £11,242 | £11,155 | £8,480 |
| 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 | £6,573 | £6,573 | £10,387 | £16,325 | £13,011 | £11,489 | £10,438 | £10,235 | £17,028 | £11,242 | £11,155 | £8,480 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £6,573 | £6,573 | £10,387 | £16,325 | £13,011 | £11,489 | £10,438 | £10,235 | £17,028 | £11,242 | £11,155 | £8,480 |
| Paid-in Capital | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| Accumulated Surplus/Deficit | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) | (£4,000) |
| Surplus/Deficit | £0 | (£7,183) | (£14,366) | (£494) | £52,736 | £76,893 | £89,625 | £83,144 | £74,874 | £112,076 | £100,263 | £98,540 | £79,084 |
| Total Capital | £41,000 | £33,817 | £26,634 | £40,506 | £93,736 | £117,893 | £130,625 | £124,144 | £115,874 | £153,076 | £141,263 | £139,540 | £120,084 |
| Total Liabilities and Capital | £41,000 | £40,390 | £33,207 | £50,893 | £110,060 | £130,904 | £142,113 | £134,582 | £126,108 | £170,103 | £152,505 | £150,695 | £128,564 |
| Net Worth | £41,000 | £33,817 | £26,634 | £40,506 | £93,736 | £117,892 | £130,624 | £124,144 | £115,873 | £153,076 | £141,263 | £139,540 | £120,084 |