FIN NPV, IRR questions
Q1
If a lender requires a DCR of 1.20, a maximum LTV of 70 percent amortized over 25 years with an interest rate of 6 percent what is the maximum loan if the NOI is $100,000? What is the maximum property value?
----------------------------------------------------------------------------------
Q2
NPV, IRR, Before and After Tax Cash Flows
You are analyzing a commercial real estate investment that generates a net operating income of $5,000,000which increases by 3.5 percent per year. The purchase price is $58 million, the holding period is 10 years, the nominal income tax rate is 28 percent, the recapture tax rate is 25 percent and the long-term capital gain tax rate is 15 percent. A lender is willing to provide financing for the 10 year holding period with a 25 year amortization period for a fixed rate of 7 percent based on a loan to value ratio of 75 percent (25 percent equity). Calculate the before and after tax IRR and NPV based on a discount rate of 4% above the going in cap rate and a terminal cap rate of 1% over the going in cap rate. The cost of sale is three percent. Remember: going in cap rate-1st years noi /purchase price.
--------------------------------------------------------------------------------------
Q4
You are analyzing a investment property with NOI of $125,000. If a lender is willing to make a loan at 6 percent, amortized for 25 years (assume annual payment) with an LTV of 70 percent and the equity requirement is 9 percent what is the overall rate (cap rate)? What is the value of the property?
12 years ago
Purchase the answer to view it

- reply.xlsx