Question

In: Finance

What would be the monthly mortgage payments for each of the following situations? A $64,000, 15-year...

What would be the monthly mortgage payments for each of the following situations?

A $64,000, 15-year loan at 7.0 percent APR compounded semi-annually

A $140,000, 25-year loan at 5.5 percent APR compounded semi-annually

A $104,000, 20-year loan at 4.0 percent APR compounded semi-annually

Solutions

Expert Solution

Part A)

To determine the amount of payment, we first need to find the effective rate of interest as below:

Effective Rate of Interest = (1+Interest Rate/Compounding Frequency)^Compounding Frequency - 1 = (1+7%/2)^(2) - 1 = 7.1225%

Now, we can calculate the amount of monthly payment with the use of formula given below:

Payment = (Rate of Interest*Present Value of Loan)/(1-(1+Rate of Interest)^(-Period))

Here, Rate of Interest = 7.1225%/12, Present Value of Loan = $64,000 and Period = 15*12 = 180

Using these values in the above formula for Payment, we get,

Monthly Payment = (7.1225%/12*64,000)/(1-(1+7.1225%/12)^(-180)) = $579.64

_____

Part 2)

To determine the amount of payment, we first need to find the effective rate of interest as below:

Effective Rate of Interest = (1+Interest Rate/Compounding Frequency)^Compounding Frequency - 1 = (1+5.5%/2)^(2) - 1 = 5.5756%

Now, we can calculate the amount of monthly payment with the use of formula given below:

Payment = (Rate of Interest*Present Value of Loan)/(1-(1+Rate of Interest)^(-Period))

Here, Rate of Interest = 5.5756%/12, Present Value of Loan = $140,000 and Period = 25*12 = 300

Using these values in the above formula for Payment, we get,

Monthly Payment = (5.5756%/12*140,000)/(1-(1+5.5756%/12)^(-300)) = $866.06

_____

Part 3)

To determine the amount of payment, we first need to find the effective rate of interest as below:

Effective Rate of Interest = (1+Interest Rate/Compounding Frequency)^Compounding Frequency - 1 = (1+4%/2)^(2) - 1 = 4.04%

Now, we can calculate the amount of monthly payment with the use of formula given below:

Payment = (Rate of Interest*Present Value of Loan)/(1-(1+Rate of Interest)^(-Period))

Here, Rate of Interest = 4.04%/12, Present Value of Loan = $104,000 and Period = 20*12 = 240

Using these values in the above formula for Payment, we get,

Monthly Payment = (4.04%/12*104,000)/(1-(1+4.04%/12)^(-240)) = $632.41


Related Solutions

A borrower takes out a 15-year adjustable rate mortgage loan for $560,000 with monthly payments. The...
A borrower takes out a 15-year adjustable rate mortgage loan for $560,000 with monthly payments. The first 4 years of the loan have a “teaser” rate of 5%, after that, the rate can reset with a 5% annual payment cap. On the reset date, the composite rate is 9%. What would the Year 5 (after 4 years; 11 years left) monthly payment be?
A borrower takes out a 15-year adjustable rate mortgage loan for $550,000 with monthly payments. The...
A borrower takes out a 15-year adjustable rate mortgage loan for $550,000 with monthly payments. The first 5 years of the loan have a “teaser” rate of 4%, after that, the rate can reset with a 5% annual payment cap. On the reset date, the composite rate is 7%. What would the Year 6 (after 5 years; 10 years left) monthly payment be?
15. Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments...
15. Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, which mortgage has the lowest cost of borrowing (ie lowest annualized IRR)? Type 1...
1) Consider a $100,000, 30-year, 6.2% mortgage with monthly payments. What portion of the payments during...
1) Consider a $100,000, 30-year, 6.2% mortgage with monthly payments. What portion of the payments during the first 34 months goes toward interest? 2) Orlando Builders Inc. issued a bond with a par value of $1,000, a coupon rate of 8.25% (semiannual coupon), and a yield to maturity of 6.60%? The bond has 15 years to maturity. What is the value of the bond?
A 25-year, $435,000 mortgage at 4.10% compounded quarterly is repaid with monthly payments. a. What is...
A 25-year, $435,000 mortgage at 4.10% compounded quarterly is repaid with monthly payments. a. What is the size of the monthly payments? b. Find the balance of the mortgage at the end of 6 years? c. By how much did the amortization period shorten by if the monthly payments are increased by $100 at the end of year six?
Financial Planning Exercise 7 Calculating monthly mortgage payments EXHIBIT 5.6 A Table of Monthly Mortgage Payments...
Financial Planning Exercise 7 Calculating monthly mortgage payments EXHIBIT 5.6 A Table of Monthly Mortgage Payments (Monthly Payments Necessary to Repay a $10,000 Loan) The monthly loan payments on a mortgage vary not only by the amount of the loan but also by the rate of interest and loan maturity. LOAN MATURITY Rate of Interest 10 Years 15 Years 20 Years 25 Years 30 Years 5.0% $106.07 $79.08 $66.00 $58.46 $53.68 5.5 108.53 81.71 68.79 61.41 56.79 6.0 111.02 84.39...
What is the monthly payment for a $800,000 mortgage for the first 119 payments that is...
What is the monthly payment for a $800,000 mortgage for the first 119 payments that is due in 10 years, has a 25 year amortization, at 5% interest? What is the amount of the 120th payment? Please use Excel and explain. Make sure that formulas are set to show in excel sheet.
Consider a $766,200 principal 28 -year mortgage with monthly payments. The annual mortgage rate is 7.40%...
Consider a $766,200 principal 28 -year mortgage with monthly payments. The annual mortgage rate is 7.40% with monthly compounding. Assume that the remaining balance after the 60 th payment is $613,395 . What is the total prepayment made on or before the 5 th anniversary of the mortgage?
A 25-year, $455,000 mortgage at 4.30% compounded semi-annually is repaid with monthly payments. a. What is...
A 25-year, $455,000 mortgage at 4.30% compounded semi-annually is repaid with monthly payments. a. What is the size of the monthly payments? b. Find the balance of the mortgage at the end of 6 years? c. By how much did the amortization period shorten by if the monthly payments are increased by $275 at the end of year six?
Consider a $5,000,000, 9%, 25-year mortgage with monthly payments. Compute the first three payments and the...
Consider a $5,000,000, 9%, 25-year mortgage with monthly payments. Compute the first three payments and the loan balance after the third payment for each of the following loan types: (a) Interest-only, (b) CAM, (c) CPM.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT