| 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 | ||
| Units | |||||||||||||
| Assisted Living Main Residents | 0% | 8 | 10 | 10 | 12 | 12 | 14 | 14 | 14 | 14 | 14 | 14 | 14 |
| Medicare Residents - Skilled Nursing Facility | 0% | 3 | 4 | 4 | 6 | 8 | 9 | 10 | 10 | 10 | 10 | 10 | 10 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Units | 11 | 14 | 14 | 18 | 20 | 23 | 24 | 24 | 24 | 24 | 24 | 24 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Assisted Living Main Residents | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | |
| Medicare Residents - Skilled Nursing Facility | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Funding | |||||||||||||
| Assisted Living Main Residents | £25,600 | £32,000 | £32,000 | £38,400 | £38,400 | £44,800 | £44,800 | £44,800 | £44,800 | £44,800 | £44,800 | £44,800 | |
| Medicare Residents - Skilled Nursing Facility | £12,150 | £16,200 | £16,200 | £24,300 | £32,400 | £36,450 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Funding | £37,750 | £48,200 | £48,200 | £62,700 | £70,800 | £81,250 | £85,300 | £85,300 | £85,300 | £85,300 | £85,300 | £85,300 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Assisted Living Main Residents | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Medicare Residents - Skilled Nursing Facility | 20.00% | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 |
| Other | 20.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Funding | |||||||||||||
| Assisted Living Main Residents | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Medicare Residents - Skilled Nursing Facility | £2,430 | £3,240 | £3,240 | £4,860 | £6,480 | £7,290 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Funding | £2,430 | £3,240 | £3,240 | £4,860 | £6,480 | £7,290 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | |
| 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 | ||
| Medical/Clinical Personnel | |||||||||||||
| Medical Director | 100% | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 |
| LPNs - Full-time 35-40 hrs, night | 200% | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 |
| LPNs - swing shift, 30 hours, day | 100% | £0 | £0 | £0 | £0 | £0 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 |
| Subtotal | £15,250 | £15,250 | £15,250 | £15,250 | £15,250 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | |
| Caretaking Personnel | |||||||||||||
| Elder Assistants | 600% | £15,600 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £15,600 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | |
| Administrative Personnel | |||||||||||||
| Medicare Liason / Billing Specialist | 100% | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 |
| Financial Manager | 100% | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 |
| Janice Ruthers - Part-time Marketing | 100% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | |
| Fundraising Personnel | |||||||||||||
| Development Officer - Part-time | 100% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Total People | 13 | 13 | 13 | 13 | 13 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | |
| Total Payroll | £40,250 | £43,370 | £43,370 | £43,370 | £43,370 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | |
| 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 | £37,750 | £48,200 | £48,200 | £62,700 | £70,800 | £81,250 | £85,300 | £85,300 | £85,300 | £85,300 | £85,300 | £85,300 | |
| Direct Cost | £2,430 | £3,240 | £3,240 | £4,860 | £6,480 | £7,290 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | |
| Medical/Clinical Payroll | £15,250 | £15,250 | £15,250 | £15,250 | £15,250 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | |
| Non-reusable Medical Equipment | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| #NAME? | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Direct Cost | £18,080 | £18,890 | £18,890 | £20,510 | £22,130 | £27,815 | £28,625 | £28,625 | £28,625 | £28,625 | £28,625 | £28,625 | |
| Gross Surplus | £19,670 | £29,310 | £29,310 | £42,190 | £48,670 | £53,435 | £56,675 | £56,675 | £56,675 | £56,675 | £56,675 | £56,675 | |
| Gross Surplus % | 52.11% | 60.81% | 60.81% | 67.29% | 68.74% | 65.77% | 66.44% | 66.44% | 66.44% | 66.44% | 66.44% | 66.44% | |
| Operating Expenses | |||||||||||||
| Caretaking Expenses | |||||||||||||
| Caretaking Payroll | £15,600 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | |
| Groceries | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | |
| Cleaning Supplies | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Other Caretaking Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Caretaking Expenses | £17,100 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | |
| Caretaking % | 45.30% | 41.95% | 41.95% | 32.25% | 28.56% | 24.89% | 23.70% | 23.70% | 23.70% | 23.70% | 23.70% | 23.70% | |
| Administrative Expenses | |||||||||||||
| Administrative Payroll | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | |
| Other Expense Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Property Taxes | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,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 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Payroll Taxes | 15% | £6,038 | £6,506 | £6,506 | £6,506 | £6,506 | £7,237 | £7,237 | £7,237 | £7,237 | £7,237 | £7,237 | £7,237 |
| Grounds and Building Upkeep | 15% | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Administrative Expenses | £18,938 | £19,406 | £19,406 | £19,406 | £19,406 | £20,137 | £20,137 | £20,137 | £20,137 | £20,137 | £20,137 | £20,137 | |
| Administrative % | 50.17% | 40.26% | 40.26% | 30.95% | 27.41% | 24.78% | 23.61% | 23.61% | 23.61% | 23.61% | 23.61% | 23.61% | |
| Fundraising Expenses: | |||||||||||||
| Fundraising Payroll | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Brochures, Marketing | £800 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Fundraising Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Fundraising Expenses | £2,000 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Fundraising % | 5.30% | 2.49% | 2.49% | 1.91% | 1.69% | 1.48% | 1.41% | 1.41% | 1.41% | 1.41% | 1.41% | 1.41% | |
| Total Operating Expenses | £38,038 | £40,826 | £40,826 | £40,826 | £40,826 | £41,557 | £41,557 | £41,557 | £41,557 | £41,557 | £41,557 | £41,557 | |
| Surplus Before Interest and Taxes | (£18,368) | (£11,516) | (£11,516) | £1,365 | £7,845 | £11,878 | £15,118 | £15,118 | £15,118 | £15,118 | £15,118 | £15,118 | |
| EBITDA | (£18,268) | (£11,416) | (£11,416) | £1,465 | £7,945 | £11,978 | £15,218 | £15,218 | £15,218 | £15,218 | £15,218 | £15,218 | |
| Interest Expense | £1,821 | £1,808 | £1,792 | £1,775 | £1,750 | £1,725 | £1,696 | £1,671 | £1,646 | £1,621 | £1,596 | £1,579 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Surplus | (£20,188) | (£13,324) | (£13,307) | (£411) | £6,095 | £10,153 | £13,422 | £13,447 | £13,472 | £13,497 | £13,522 | £13,539 | |
| Net Surplus/Funding | -53.48% | -27.64% | -27.61% | -0.65% | 8.61% | 12.50% | 15.74% | 15.76% | 15.79% | 15.82% | 15.85% | 15.87% | |
| 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 | £28,313 | £36,150 | £36,150 | £47,025 | £53,100 | £60,938 | £63,975 | £63,975 | £63,975 | £63,975 | £63,975 | £63,975 | |
| Cash from Receivables | £0 | £315 | £9,525 | £12,050 | £12,171 | £15,743 | £17,787 | £20,346 | £21,325 | £21,325 | £21,325 | £21,325 | |
| Subtotal Cash from Operations | £28,313 | £36,465 | £45,675 | £59,075 | £65,271 | £76,680 | £81,762 | £84,321 | £85,300 | £85,300 | £85,300 | £85,300 | |
| 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 | £5,000 | £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 | £25,000 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £33,313 | £36,465 | £45,675 | £59,075 | £65,271 | £76,680 | £106,762 | £84,321 | £85,300 | £85,300 | £85,300 | £85,300 | |
| 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 | £40,250 | £43,370 | £43,370 | £43,370 | £43,370 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | |
| Bill Payments | £505 | £15,244 | £17,734 | £18,145 | £21,314 | £22,879 | £23,588 | £24,315 | £23,507 | £23,482 | £23,457 | £23,432 | |
| Subtotal Spent on Operations | £40,755 | £58,614 | £61,104 | £61,515 | £64,684 | £71,124 | £71,833 | £72,560 | £71,752 | £71,727 | £71,702 | £71,677 | |
| 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 | £500 | £500 | £1,000 | £1,000 | £1,000 | £1,000 | £500 | £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,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £2,000 | |
| 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 | £42,255 | £60,114 | £63,104 | £63,515 | £67,684 | £74,124 | £75,333 | £75,560 | £74,752 | £74,727 | £74,702 | £73,677 | |
| Net Cash Flow | (£8,943) | (£23,649) | (£17,430) | (£4,440) | (£2,413) | £2,556 | £31,429 | £8,761 | £10,548 | £10,573 | £10,598 | £11,623 | |
| Cash Balance | £69,057 | £45,408 | £27,978 | £23,539 | £21,126 | £23,682 | £55,111 | £63,873 | £74,421 | £84,994 | £95,592 | £107,215 | |
| 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 | £78,000 | £69,057 | £45,408 | £27,978 | £23,539 | £21,126 | £23,682 | £55,111 | £63,873 | £74,421 | £84,994 | £95,592 | £107,215 |
| Accounts Receivable | £0 | £9,438 | £21,173 | £23,698 | £27,323 | £32,853 | £37,423 | £40,960 | £41,939 | £41,939 | £41,939 | £41,939 | £41,939 |
| Inventory | £6,000 | £3,570 | £3,240 | £3,240 | £4,860 | £6,480 | £7,290 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 |
| Other Current Assets | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 |
| Total Current Assets | £115,000 | £113,065 | £100,821 | £85,917 | £86,722 | £91,458 | £99,394 | £135,171 | £144,912 | £155,460 | £166,033 | £176,631 | £188,254 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £725,000 | £725,000 | £725,000 | £725,000 | £725,000 | £725,000 |
| Accumulated Depreciation | £0 | £100 | £200 | £300 | £400 | £500 | £600 | £700 | £800 | £900 | £1,000 | £1,100 | £1,200 |
| Total Long-term Assets | £750,000 | £749,900 | £749,800 | £749,700 | £749,600 | £749,500 | £749,400 | £724,300 | £724,200 | £724,100 | £724,000 | £723,900 | £723,800 |
| Total Assets | £865,000 | £862,965 | £850,621 | £835,617 | £836,322 | £840,958 | £848,794 | £859,471 | £869,112 | £879,560 | £890,033 | £900,531 | £912,054 |
| 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 | £14,653 | £17,133 | £17,436 | £20,552 | £22,094 | £22,776 | £23,531 | £22,724 | £22,700 | £22,676 | £22,651 | £22,635 |
| Current Borrowing | £5,000 | £9,500 | £9,000 | £8,000 | £7,000 | £6,000 | £5,000 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £5,000 | £24,153 | £26,133 | £25,436 | £27,552 | £28,094 | £27,776 | £28,031 | £27,224 | £27,200 | £27,176 | £27,151 | £27,135 |
| Long-term Liabilities | £210,000 | £209,000 | £208,000 | £207,000 | £206,000 | £204,000 | £202,000 | £199,000 | £196,000 | £193,000 | £190,000 | £187,000 | £185,000 |
| Total Liabilities | £215,000 | £233,153 | £234,133 | £232,436 | £233,552 | £232,094 | £229,776 | £227,031 | £223,224 | £220,200 | £217,176 | £214,151 | £212,135 |
| Paid-in Capital | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 |
| Accumulated Surplus/Deficit | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) |
| Surplus/Deficit | £0 | (£20,188) | (£33,512) | (£46,819) | (£47,230) | (£41,135) | (£30,982) | (£17,560) | (£4,112) | £9,360 | £22,858 | £36,380 | £49,919 |
| Total Capital | £650,000 | £629,812 | £616,488 | £603,181 | £602,770 | £608,865 | £619,018 | £632,440 | £645,888 | £659,360 | £672,858 | £686,380 | £699,919 |
| Total Liabilities and Capital | £865,000 | £862,965 | £850,621 | £835,617 | £836,322 | £840,958 | £848,794 | £859,471 | £869,112 | £879,560 | £890,033 | £900,531 | £912,054 |
| Net Worth | £650,000 | £629,812 | £616,488 | £603,181 | £602,770 | £608,865 | £619,018 | £632,440 | £645,888 | £659,360 | £672,858 | £686,380 | £699,919 |
| 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 | ||
| Units | |||||||||||||
| Assisted Living Main Residents | 0% | 8 | 10 | 10 | 12 | 12 | 14 | 14 | 14 | 14 | 14 | 14 | 14 |
| Medicare Residents - Skilled Nursing Facility | 0% | 3 | 4 | 4 | 6 | 8 | 9 | 10 | 10 | 10 | 10 | 10 | 10 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Units | 11 | 14 | 14 | 18 | 20 | 23 | 24 | 24 | 24 | 24 | 24 | 24 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Assisted Living Main Residents | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | £3,200.00 | |
| Medicare Residents - Skilled Nursing Facility | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | £4,050.00 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Funding | |||||||||||||
| Assisted Living Main Residents | £25,600 | £32,000 | £32,000 | £38,400 | £38,400 | £44,800 | £44,800 | £44,800 | £44,800 | £44,800 | £44,800 | £44,800 | |
| Medicare Residents - Skilled Nursing Facility | £12,150 | £16,200 | £16,200 | £24,300 | £32,400 | £36,450 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Funding | £37,750 | £48,200 | £48,200 | £62,700 | £70,800 | £81,250 | £85,300 | £85,300 | £85,300 | £85,300 | £85,300 | £85,300 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Assisted Living Main Residents | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Medicare Residents - Skilled Nursing Facility | 20.00% | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 | £810.00 |
| Other | 20.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Funding | |||||||||||||
| Assisted Living Main Residents | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Medicare Residents - Skilled Nursing Facility | £2,430 | £3,240 | £3,240 | £4,860 | £6,480 | £7,290 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Funding | £2,430 | £3,240 | £3,240 | £4,860 | £6,480 | £7,290 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | |
| 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 | ||
| Medical/Clinical Personnel | |||||||||||||
| Medical Director | 100% | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 |
| LPNs - Full-time 35-40 hrs, night | 200% | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 | £9,750 |
| LPNs - swing shift, 30 hours, day | 100% | £0 | £0 | £0 | £0 | £0 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 |
| Subtotal | £15,250 | £15,250 | £15,250 | £15,250 | £15,250 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | |
| Caretaking Personnel | |||||||||||||
| Elder Assistants | 600% | £15,600 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £15,600 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | |
| Administrative Personnel | |||||||||||||
| Medicare Liason / Billing Specialist | 100% | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 |
| Financial Manager | 100% | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 |
| Janice Ruthers - Part-time Marketing | 100% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | |
| Fundraising Personnel | |||||||||||||
| Development Officer - Part-time | 100% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Total People | 13 | 13 | 13 | 13 | 13 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | |
| Total Payroll | £40,250 | £43,370 | £43,370 | £43,370 | £43,370 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | |
| 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 | £37,750 | £48,200 | £48,200 | £62,700 | £70,800 | £81,250 | £85,300 | £85,300 | £85,300 | £85,300 | £85,300 | £85,300 | |
| Direct Cost | £2,430 | £3,240 | £3,240 | £4,860 | £6,480 | £7,290 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | |
| Medical/Clinical Payroll | £15,250 | £15,250 | £15,250 | £15,250 | £15,250 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | £20,125 | |
| Non-reusable Medical Equipment | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| #NAME? | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Direct Cost | £18,080 | £18,890 | £18,890 | £20,510 | £22,130 | £27,815 | £28,625 | £28,625 | £28,625 | £28,625 | £28,625 | £28,625 | |
| Gross Surplus | £19,670 | £29,310 | £29,310 | £42,190 | £48,670 | £53,435 | £56,675 | £56,675 | £56,675 | £56,675 | £56,675 | £56,675 | |
| Gross Surplus % | 52.11% | 60.81% | 60.81% | 67.29% | 68.74% | 65.77% | 66.44% | 66.44% | 66.44% | 66.44% | 66.44% | 66.44% | |
| Operating Expenses | |||||||||||||
| Caretaking Expenses | |||||||||||||
| Caretaking Payroll | £15,600 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | £18,720 | |
| Groceries | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | |
| Cleaning Supplies | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Other Caretaking Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Caretaking Expenses | £17,100 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | £20,220 | |
| Caretaking % | 45.30% | 41.95% | 41.95% | 32.25% | 28.56% | 24.89% | 23.70% | 23.70% | 23.70% | 23.70% | 23.70% | 23.70% | |
| Administrative Expenses | |||||||||||||
| Administrative Payroll | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | |
| Other Expense Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Property Taxes | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,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 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Payroll Taxes | 15% | £6,038 | £6,506 | £6,506 | £6,506 | £6,506 | £7,237 | £7,237 | £7,237 | £7,237 | £7,237 | £7,237 | £7,237 |
| Grounds and Building Upkeep | 15% | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Administrative Expenses | £18,938 | £19,406 | £19,406 | £19,406 | £19,406 | £20,137 | £20,137 | £20,137 | £20,137 | £20,137 | £20,137 | £20,137 | |
| Administrative % | 50.17% | 40.26% | 40.26% | 30.95% | 27.41% | 24.78% | 23.61% | 23.61% | 23.61% | 23.61% | 23.61% | 23.61% | |
| Fundraising Expenses: | |||||||||||||
| Fundraising Payroll | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Brochures, Marketing | £800 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Fundraising Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Fundraising Expenses | £2,000 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Fundraising % | 5.30% | 2.49% | 2.49% | 1.91% | 1.69% | 1.48% | 1.41% | 1.41% | 1.41% | 1.41% | 1.41% | 1.41% | |
| Total Operating Expenses | £38,038 | £40,826 | £40,826 | £40,826 | £40,826 | £41,557 | £41,557 | £41,557 | £41,557 | £41,557 | £41,557 | £41,557 | |
| Surplus Before Interest and Taxes | (£18,368) | (£11,516) | (£11,516) | £1,365 | £7,845 | £11,878 | £15,118 | £15,118 | £15,118 | £15,118 | £15,118 | £15,118 | |
| EBITDA | (£18,268) | (£11,416) | (£11,416) | £1,465 | £7,945 | £11,978 | £15,218 | £15,218 | £15,218 | £15,218 | £15,218 | £15,218 | |
| Interest Expense | £1,821 | £1,808 | £1,792 | £1,775 | £1,750 | £1,725 | £1,696 | £1,671 | £1,646 | £1,621 | £1,596 | £1,579 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Surplus | (£20,188) | (£13,324) | (£13,307) | (£411) | £6,095 | £10,153 | £13,422 | £13,447 | £13,472 | £13,497 | £13,522 | £13,539 | |
| Net Surplus/Funding | -53.48% | -27.64% | -27.61% | -0.65% | 8.61% | 12.50% | 15.74% | 15.76% | 15.79% | 15.82% | 15.85% | 15.87% | |
| 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 | £28,313 | £36,150 | £36,150 | £47,025 | £53,100 | £60,938 | £63,975 | £63,975 | £63,975 | £63,975 | £63,975 | £63,975 | |
| Cash from Receivables | £0 | £315 | £9,525 | £12,050 | £12,171 | £15,743 | £17,787 | £20,346 | £21,325 | £21,325 | £21,325 | £21,325 | |
| Subtotal Cash from Operations | £28,313 | £36,465 | £45,675 | £59,075 | £65,271 | £76,680 | £81,762 | £84,321 | £85,300 | £85,300 | £85,300 | £85,300 | |
| 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 | £5,000 | £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 | £25,000 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £33,313 | £36,465 | £45,675 | £59,075 | £65,271 | £76,680 | £106,762 | £84,321 | £85,300 | £85,300 | £85,300 | £85,300 | |
| 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 | £40,250 | £43,370 | £43,370 | £43,370 | £43,370 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | £48,245 | |
| Bill Payments | £505 | £15,244 | £17,734 | £18,145 | £21,314 | £22,879 | £23,588 | £24,315 | £23,507 | £23,482 | £23,457 | £23,432 | |
| Subtotal Spent on Operations | £40,755 | £58,614 | £61,104 | £61,515 | £64,684 | £71,124 | £71,833 | £72,560 | £71,752 | £71,727 | £71,702 | £71,677 | |
| 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 | £500 | £500 | £1,000 | £1,000 | £1,000 | £1,000 | £500 | £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,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £2,000 | |
| 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 | £42,255 | £60,114 | £63,104 | £63,515 | £67,684 | £74,124 | £75,333 | £75,560 | £74,752 | £74,727 | £74,702 | £73,677 | |
| Net Cash Flow | (£8,943) | (£23,649) | (£17,430) | (£4,440) | (£2,413) | £2,556 | £31,429 | £8,761 | £10,548 | £10,573 | £10,598 | £11,623 | |
| Cash Balance | £69,057 | £45,408 | £27,978 | £23,539 | £21,126 | £23,682 | £55,111 | £63,873 | £74,421 | £84,994 | £95,592 | £107,215 | |
| 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 | £78,000 | £69,057 | £45,408 | £27,978 | £23,539 | £21,126 | £23,682 | £55,111 | £63,873 | £74,421 | £84,994 | £95,592 | £107,215 |
| Accounts Receivable | £0 | £9,438 | £21,173 | £23,698 | £27,323 | £32,853 | £37,423 | £40,960 | £41,939 | £41,939 | £41,939 | £41,939 | £41,939 |
| Inventory | £6,000 | £3,570 | £3,240 | £3,240 | £4,860 | £6,480 | £7,290 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 | £8,100 |
| Other Current Assets | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 | £31,000 |
| Total Current Assets | £115,000 | £113,065 | £100,821 | £85,917 | £86,722 | £91,458 | £99,394 | £135,171 | £144,912 | £155,460 | £166,033 | £176,631 | £188,254 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £725,000 | £725,000 | £725,000 | £725,000 | £725,000 | £725,000 |
| Accumulated Depreciation | £0 | £100 | £200 | £300 | £400 | £500 | £600 | £700 | £800 | £900 | £1,000 | £1,100 | £1,200 |
| Total Long-term Assets | £750,000 | £749,900 | £749,800 | £749,700 | £749,600 | £749,500 | £749,400 | £724,300 | £724,200 | £724,100 | £724,000 | £723,900 | £723,800 |
| Total Assets | £865,000 | £862,965 | £850,621 | £835,617 | £836,322 | £840,958 | £848,794 | £859,471 | £869,112 | £879,560 | £890,033 | £900,531 | £912,054 |
| 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 | £14,653 | £17,133 | £17,436 | £20,552 | £22,094 | £22,776 | £23,531 | £22,724 | £22,700 | £22,676 | £22,651 | £22,635 |
| Current Borrowing | £5,000 | £9,500 | £9,000 | £8,000 | £7,000 | £6,000 | £5,000 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £5,000 | £24,153 | £26,133 | £25,436 | £27,552 | £28,094 | £27,776 | £28,031 | £27,224 | £27,200 | £27,176 | £27,151 | £27,135 |
| Long-term Liabilities | £210,000 | £209,000 | £208,000 | £207,000 | £206,000 | £204,000 | £202,000 | £199,000 | £196,000 | £193,000 | £190,000 | £187,000 | £185,000 |
| Total Liabilities | £215,000 | £233,153 | £234,133 | £232,436 | £233,552 | £232,094 | £229,776 | £227,031 | £223,224 | £220,200 | £217,176 | £214,151 | £212,135 |
| Paid-in Capital | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 | £699,150 |
| Accumulated Surplus/Deficit | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) | (£49,150) |
| Surplus/Deficit | £0 | (£20,188) | (£33,512) | (£46,819) | (£47,230) | (£41,135) | (£30,982) | (£17,560) | (£4,112) | £9,360 | £22,858 | £36,380 | £49,919 |
| Total Capital | £650,000 | £629,812 | £616,488 | £603,181 | £602,770 | £608,865 | £619,018 | £632,440 | £645,888 | £659,360 | £672,858 | £686,380 | £699,919 |
| Total Liabilities and Capital | £865,000 | £862,965 | £850,621 | £835,617 | £836,322 | £840,958 | £848,794 | £859,471 | £869,112 | £879,560 | £890,033 | £900,531 | £912,054 |
| Net Worth | £650,000 | £629,812 | £616,488 | £603,181 | £602,770 | £608,865 | £619,018 | £632,440 | £645,888 | £659,360 | £672,858 | £686,380 | £699,919 |