Answer Happy

What is Ann's IRR for this investment?
A B с D E F G Н. K Investment Analysis Year 2014 2015 2016 2017 2018 2019 2020 1 Inputs 2 Purchase Price 3 Purchase Costs 4 Loan amount 5 Loan Closing Costs 6 Prepayment Penalty 7 Debt Service 8 NOI 2015 9 Going in cap rate 2014 10 NOI growth rate 11 Exit cap rate 2019 12 Selling Costs 13 $11,822,261.54 1.50% $10,640,035.38 1.25% 5%/4%/3%/2%/1%/0% $611,802.03 $768,447.00 6.50% 2.00% 6.25% 7.00% Purchase Price Purchase Costs Loan Amount Loan Closing Costs Net Operating Income (NOI) Debt Service Payment 14 Sale Price Selling Costs Loan Balance Repaid Loan Prepayment Penalty 15 16 17 18 Net Cash Flow 19 20 IRR 21.