| Inflows | |
|---|---|
| Project revenue | |
| House sale proceeds (gross) | |
| Outflows | |
| Oak bill | |
| Rent debt | |
| Mortgage payoff | |
| Loan repayment | |
| Rent | |
| Loan interest | |
| Loan principal (12-month) | |
| Balances | |
| Start Balance | |
| End Balance | |
| Projection horizon (months) | |
| Assets | |
|---|---|
| Cash | |
| House (book value) | |
| Liabilities | |
| Loan payable | |
| Interest payable | |
| Rent payable (12-month) | |
| Equity | |
| Total equity | |
| Inflows | |
|---|---|
| Sales revenue | |
| Rent income (12-month) | |
| Loan Principal | |
| Repaid rent debt | |
| Interest received (12 months) | |
| Outflows | |
| Condo costs | |
| Payment to Sandy | |
| Balances | |
| Start Balance | |
| End Balance | |
| Total benefit | |
| Projection horizon (months) | |
| Assets | |
|---|---|
| Cash | |
| Loan receivable | |
| Rent receivable (12-month) | |
| Liabilities | |
| Total liabilities | |
| Equity | |
| Total equity | |