Using the heights colony apartments data below, and assuming that a purchase price of $7.5 million, 75%LTV, and 7.5% interest rate, and 30 year term, numerically illustrate what would be the cumulative before tax cash flow including the sale?

4 Tlle rmeigints Colony Apartments Total Capital Investment (TCI) (per appraisal) Net Operating Income (NOI) Overall Rate of Return (ROR-NOI TCI 606,8406,742,000 Loan Amount, with a 70% LTV (LA) Net Operating Income Debt Service (DS) is 12 monthly payments: $6,742,000 $606,840 = .09 or 9% (this is also the c rate) $4,719,400 $606,840 $376,780 o compute one payment, using the BA II Plus: 4,719,400 12 30 = 7 12 CPT PMT = DS 12 x $31,398.29 $376,780 (rounding) Net Cash Flow (NCF) NOI DS $230,060 Equity (EQ) TCI LA Return on Equity (ROE) NCF EQ -230,060 + 2,022,600 PV ITY $31,398.29 $2,022,600 .114 or 11.4% 4 Tlle rmeigints Colony Apartments Total Capital Investment (TCI) (per appraisal) Net Operating Income (NOI) Overall Rate of Return (ROR-NOI TCI 606,8406,742,000 Loan Amount, with a 70% LTV (LA) Net Operating Income Debt Service (DS) is 12 monthly payments: $6,742,000 $606,840 = .09 or 9% (this is also the c rate) $4,719,400 $606,840 $376,780 o compute one payment, using the BA II Plus: 4,719,400 12 30 = 7 12 CPT PMT = DS 12 x $31,398.29 $376,780 (rounding) Net Cash Flow (NCF) NOI DS $230,060 Equity (EQ) TCI LA Return on Equity (ROE) NCF EQ -230,060 + 2,022,600 PV ITY $31,398.29 $2,022,600 .114 or 11.4%