Fill in the blanks!! (Debt Service Payment, Net Cash Flow, IRR)??

Home Insert Page Layout Formulas Data Review View 2+ Share A - 11 ZU Calibri (Body) BIU General $ - % Insert ** Delete Format Paste 23 ) 000 .00 .0 Sort & Conditional Format Formatting as Table Cell Styles MN Investment Analysis $11.822.251.54 1509 Year 2014 2015 2016 2017 2018 2019 2020 $11.136.913.04 5%/4933/29/13/09 Inputs Purchase Price Purchase Costs Loan amount Loan Closing Costs Prepayment Penalty Debt Service NOI 2015 Going in cap rate 2014 0 NOI growth rate 1 Exit cap rate 2019 Selling Costs Purchase Price Purchase Costs Loan Amount Loan Closing Costs $11,822,261.54 $177 333.92 $11,135,913.04 $139 211141 $758. 447.00 6.5096 2.00% 6.25% 7.00% $758,447.00 $799,492 26 5815,482.10 $831.791.7 $8.48.427.53 Net Operating Income (NOI Debt Service Payment Capital Gain $1.252.57976 Sale Price Selling Costs Loan Balance Repaid Loan Prepayment Penalty $13,574,841.30 $950.238.89 $64,037.249.98 139211.413 Net Cash Flow Sum of Net Cash Flow $0.00 INUM! meGoONMOON ONMOON Discount Rate NPV 0.00% 5.00% 10.00% 15.00% 20.00% 25.00% 30.00% 35.00% 40.00% 45.00% 50.00% 55.00% 60.00% 65.00% 70.00% 75.00% 80.00% 85.00% 90.00% 95.00% 100.00% $0.00 $0.00 S0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 S0.00 $0.00 S0.00 S0.00 S0.00 $0.00 $0.00 $0.00 S0.00 $0.00 $0.00 $0.00 Home Insert Page Layout Formulas Data Review View 2+ Share A - 11 ZU Calibri (Body) BIU General $ - % Insert ** Delete Format Paste 23 ) 000 .00 .0 Sort & Conditional Format Formatting as Table Cell Styles MN Investment Analysis $11.822.251.54 1509 Year 2014 2015 2016 2017 2018 2019 2020 $11.136.913.04 5%/4933/29/13/09 Inputs Purchase Price Purchase Costs Loan amount Loan Closing Costs Prepayment Penalty Debt Service NOI 2015 Going in cap rate 2014 0 NOI growth rate 1 Exit cap rate 2019 Selling Costs Purchase Price Purchase Costs Loan Amount Loan Closing Costs $11,822,261.54 $177 333.92 $11,135,913.04 $139 211141 $758. 447.00 6.5096 2.00% 6.25% 7.00% $758,447.00 $799,492 26 5815,482.10 $831.791.7 $8.48.427.53 Net Operating Income (NOI Debt Service Payment Capital Gain $1.252.57976 Sale Price Selling Costs Loan Balance Repaid Loan Prepayment Penalty $13,574,841.30 $950.238.89 $64,037.249.98 139211.413 Net Cash Flow Sum of Net Cash Flow $0.00 INUM! meGoONMOON ONMOON Discount Rate NPV 0.00% 5.00% 10.00% 15.00% 20.00% 25.00% 30.00% 35.00% 40.00% 45.00% 50.00% 55.00% 60.00% 65.00% 70.00% 75.00% 80.00% 85.00% 90.00% 95.00% 100.00% $0.00 $0.00 S0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 S0.00 $0.00 S0.00 S0.00 S0.00 $0.00 $0.00 $0.00 S0.00 $0.00 $0.00 $0.00