Question

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.

What is your monthly mortgage payment?

Answer 1

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

.