Answered step by step
Verified Expert Solution
Question
1 Approved Answer
B D E G H 1 K M N O Investment Analysis Year 2014 2015 2016 2017 2018 2019 2020 $11,822,261.54 1.50% $10,640,035.38 1.25% 5%/4%/3%/2%/1%/0%
B D E G H 1 K M N O Investment Analysis Year 2014 2015 2016 2017 2018 2019 2020 $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 $11,822,261.54 $177,333.92 $10,640,035.38 $133,000.44 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 14 15 16 17 18 19 20 211 $848,427.58 Net Operating Income (NOI) Debt Service Payment $768,447.00 $611,802.03 $783,815.94 $611,802.03 $799,492.26 $611,802.03 $815,482.10 $611,802.03 $831,791.75 $611,802.03 Capital Gain $1,752,579.76 Sale Price Selling Costs Loan Balance Repaid Loan Prepayment Penalty $13,574,841.30 $950,238.89 $10,640,035.38 $106,400.35 Net Cash Flow Sum of Net Cash flow $0.00 IRR B D E G H 1 K M N O Investment Analysis Year 2014 2015 2016 2017 2018 2019 2020 $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 $11,822,261.54 $177,333.92 $10,640,035.38 $133,000.44 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 14 15 16 17 18 19 20 211 $848,427.58 Net Operating Income (NOI) Debt Service Payment $768,447.00 $611,802.03 $783,815.94 $611,802.03 $799,492.26 $611,802.03 $815,482.10 $611,802.03 $831,791.75 $611,802.03 Capital Gain $1,752,579.76 Sale Price Selling Costs Loan Balance Repaid Loan Prepayment Penalty $13,574,841.30 $950,238.89 $10,640,035.38 $106,400.35 Net Cash Flow Sum of Net Cash flow $0.00 IRR
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started