| 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 |
Your business plan can look as polished and professional as this sample plan. It's fast and easy, with LivePlan.
"I just wrote my first business plan in 24 hours using LivePlan and it's beautiful and complete."
Business planning has never been easier. With 500 complete sample plans, easy financials, and access anywhere, LivePlan turns your great idea into a great plan for success.
| 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 |
