Question

In: Finance

You received an investment opportunity in real estate. The required investment amount is $1,000,000. Since you...

You received an investment opportunity in real estate. The required investment amount is $1,000,000. Since you do not have enough money, you are searched for partners. You found one friend who would like to enter the investment. Although she does not have the necessary funds today, she promises to transfer $400,000 in 4 years.

Accordingly, you have decided to take two loans:

1) A 4-year bullet loan with an annual stated interest rate (APR) of 6.6% compounded monthly. The loan will be paid in a single payment equal to $400,000 (for the interest and principal) at the end of the fifth year;

2) A 25-year mortgage for the remaining required funds to purchase the house. The mortgage has an annual stated interest rate (APR) of 6% and will be repaid in equal monthly payments over the next 25 years.

4 years into the mortgage (4 years after you took the mortgage), you are considering paying off your mortgage.

Suppose that when you came to pay off the mortgage (after 4 years), you found out that the annual interest rate decreased to 5.4% (APR). The bank is demanding a prepayment fee in order to pay off the mortgage. What will be the maximum prepayment fee that you will be willing to pay?

Solutions

Expert Solution

For the 4-year bullet loan (assuming the repayment of the loan at the end of fourth year, & not fifth year which seems to be a mistake as it is a 4 year loan)

monthly rate = 6.6%/12 =0.0055

No of months = 4*12 = 48

So, the amount A which can be borrowed is given by

A = 400000/(1+0.0055)^48

=$307411.70

Remaining amount to be borrowed in 25 year mortgage = $1000000 - $307411.70 = $692588.30

monthly rate = 6%/12 =0.005

No of months = 25*12 = 300

So, the equal monthly payments (B) over the next 25 years.is given by

A/0.005*(1-1/1.005^300) = 692588.30

A =$4462.36

monthly mortgage payment = $4462.36

After 4 years, the outstanding value of loan at rate 6% APR

= present value of remaining payments (21*12 = 252 months)

= 4462.36/0.005*(1-1/1.005^252)

= $638522.13

Now, the value of the loan payments at the reduced rate of 5.4% APR (0.0045 per month)

= 4462.36/0.0045*(1-1/1.0045^252)

= $671769.81

So, the maximum prepayment fee that can be paid = $671769.81 - $638522.13 = $33247.68


Related Solutions

Suppose you have the opportunity to make an investment in a real estate venture that expects...
Suppose you have the opportunity to make an investment in a real estate venture that expects to pay investors $750 at the end of each month for the next 8 years. Based on the risk, you believe that a reasonable rate of return on your investment should be an annualized rate of 15% compounded monthly. (A) How much should you pay for the investment? Suppose you have the opportunity to make an investment in a real estate venture that expects...
One investing firm is assessing an opportunity of a real estate investment. The project requires 4.5...
One investing firm is assessing an opportunity of a real estate investment. The project requires 4.5 million CAD at the beginning of the first year to start up the first complex and 1.6 million CAD at the beginning of the second year to start the second complex. Upon completion in two years, a hotel industry customer would purchase the whole project for 8.7 million CAD. If the average secure interest rate from a bank is 4%, determine the return rate...
What is the present value of $1,000,000 to be received in 15 years, if the opportunity...
What is the present value of $1,000,000 to be received in 15 years, if the opportunity cost is 3.50% annually?
Suppose that you are considering a real estate investment that will provide you with the following...
Suppose that you are considering a real estate investment that will provide you with the following cash flows: Year 1: $160,000 Year 2: 140,000 Year 3: 180,000 Year 4: $5.4 million If the asking price for the property is $3.5 million, what will the NPV be for this investment? Show work a.14.90% b.15.57% c. 16.56% d:14.57% e: none of the above
Assume that you were given an opportunity to purchase a real estate project using an equity...
Assume that you were given an opportunity to purchase a real estate project using an equity participation loan. The NOI for each year of the holding period are shown below: 2 Annual payments are being used to make the problem easier! NOI : Year 1 124,787 Year 2 132,225 Year 3 139,954 Year 4 148,468 Additional information: 1) Purchase price = $1,900,000 2) Estimated value of land = $500,000 3) Anticipated mortgage terms: a) Loan to value ratio = .80...
Assume that you were given an opportunity to purchase a real estate project using an equity...
Assume that you were given an opportunity to purchase a real estate project using an equity participation loan. The NOI for each year of the holding period are shown below: 2 Annual payments are being used to make the problem easier! Year 1 Year 2 Year 3 Year 4 NOI 124,787 132,225 139,954 148,468 Additional information: 1) Purchase price = $1,900,000 2) Estimated value of land = $500,000 3) Anticipated mortgage terms: a) Loan to value ratio = .80 b)...
Assume that you were given an opportunity to purchase a real estate project using an equity...
Assume that you were given an opportunity to purchase a real estate project using an equity participation loan. The NOI for each year of the holding period are shown below: Year 1 Year 2 Year 3 Year 4 NOI 124,787 132,225 139,954 148,468 Additional information: 1) Purchase price = $1,900,000 2) Estimated value of land = $500,000 3) Anticipated mortgage terms: a) Loan to value ratio = .80 b) Interest rate = 5.25% c) Years to maturity = 25 d)...
Describe how real estate investment objectives are set, how the features of real estate are analyzed,...
Describe how real estate investment objectives are set, how the features of real estate are analyzed, and what determines real estate value?
Difference Between Real Estate Investment and the Other Investment?essay?
Difference Between Real Estate Investment and the Other Investment?essay?
You are presented with a real estate investment with cash flow in year 1 of $100,000,...
You are presented with a real estate investment with cash flow in year 1 of $100,000, increasing by $5,000 per year through year 5. And, you estimate you can sell the deal at the end of the 5th year for $1,250,000. If your discount rate is 12%, should you buy the deal at the $1,100,000 asking price? A) Yes, because the IRR is a positive 9.34% B) No, because the NPV is a negative $33,455 C) Yes, because the NPV...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT