Question

In: Finance

Which of the following options regarding a $200,000 mortgage, compounded semi-annually results in the lowest total...

Which of the following options regarding a $200,000 mortgage, compounded semi-annually results in the lowest total interest payment?

A 3.5% interest rate, paid bi-weekly and amortized over 20 years

A 3.5% interest rate, paid monthly and amortized over 20 years

A 3.25% interest rate, paid monthly and amortized over 22 years

A 4% interest rate, paid monthly and amortized over 15 years

Solutions

Expert Solution

Answer is:

A 4% interest rate, paid monthly and amortized over 15 years

Please rate.

Calculations are below:

Total interest on:

A 3.5% interest rate, paid bi-weekly and amortized over 20 years:

Payment = [P × R × (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P $                                                          200,000
Rate of interest per period:
Annual rate of interest 3.500%
Frequency of payment = Once in 0.5 month period
Numer of payments in a year = 12/0.5 = 24
Rate of interest per period R 0.035 /24 = 0.1458%
Total number of payments:
Frequency of payment = Once in 0.5 month period
Number of years of loan repayment =                                                                  20.00
Total number of payments N 20 × 24 = 480
Period payment using the formula = [ 200000 × 0.00146 × (1+0.00146)^480] / [(1+0.00146 ^480 -1]
Payment = $                                                            579.67
Total interest pay:
Total payments = 579.67 × 480
$                                                    278,241.60
Less principle amount $                                                    200,000.00
Interest payment- Finance charge $                                                      78,241.60

Total interest paid on:

A 3.5% interest rate, paid monthly and amortized over 20 years

Payment = [P × R × (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P $                                                          200,000
Rate of interest per period:
Annual rate of interest 3.500%
Frequency of payment = Once in 1.0 month period
Numer of payments in a year = 12/1 = 12
Rate of interest per period R 0.035 /12 = 0.2917%
Total number of payments:
Frequency of payment = Once in 1.0 month period
Number of years of loan repayment =                                                                  20.00
Total number of payments N 20 × 12 = 240
Period payment using the formula = [ 200000 × 0.00292 × (1+0.00292)^240] / [(1+0.00292 ^240 -1]
Payment = $                                                         1,159.92
Total interest pay:
Total payments = 1159.92 × 240
$                                                    278,380.80
Less principle amount $                                                    200,000.00
Interest payment- Finance charge $                                                      78,380.80

Total interest paid on:

A 3.25% interest rate, paid monthly and amortized over 22 years

Payment = [P × R × (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P $                                                          200,000
Rate of interest per period:
Annual rate of interest 3.250%
Frequency of payment = Once in 1.0 month period
Numer of payments in a year = 12/1 = 12
Rate of interest per period R 0.0325 /12 = 0.2708%
Total number of payments:
Frequency of payment = Once in 1.0 month period
Number of years of loan repayment =                                                                  22.00
Total number of payments N 22 × 12 = 264
Period payment using the formula = [ 200000 × 0.00271 × (1+0.00271)^264] / [(1+0.00271 ^264 -1]
Payment = $                                                         1,061.39
Total interest pay:
Total payments = 1061.39 × 264
$                                                    280,206.96
Less principle amount $                                                    200,000.00
Interest payment- Finance charge $                                                      80,206.96

Total interest paid on:

A 4% interest rate, paid monthly and amortized over 15 years

Payment = [P × R × (1+R)^N ] / [(1+R)^N -1]

Related Solutions

A 25 years $500000 mortgage at 4.30% compounded semi annually is repaid with monthly payment what...
A 25 years $500000 mortgage at 4.30% compounded semi annually is repaid with monthly payment what is size of monthly payment and balance of mortgage at end of 6 years and how much did the amortization period shorten by if the monthly payment are increased by $125 at end of year six?
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?
Today, you borrow $300,000 to buy a condo unit. The mortgage rate is 3.75% compounded semi-annually....
Today, you borrow $300,000 to buy a condo unit. The mortgage rate is 3.75% compounded semi-annually. The loan is to be repaid in equal monthly payments over 19 years. The first payment is due at the end of the first month. What portion (in dollars) of the third payment will be used to pay down the principal balance? Question 5 options: $822 $845 $867 $890 $913
A loan of $27,150.00 at 5.00% compounded semi-annually is to be repaid with payments at the...
A loan of $27,150.00 at 5.00% compounded semi-annually is to be repaid with payments at the end of every 6 months. The loan was settled in 4 years. a. Calculate the size of the periodic payment. $3,406.15 $4,200.70 $3,786.54 $4,276.00 b. Calculate the total interest paid. $3,142.32 $30,292.32 -$644.22 $6,928.86
A $37,000 loan at 8.2% compounded semi-annually is to be repaid by equal semi-annual payments over...
A $37,000 loan at 8.2% compounded semi-annually is to be repaid by equal semi-annual payments over 10 years. a) What will be the principal component of the sixth payment? b) What will be the interest component of the sixteenth payment? c) How much will Payments 6 to 15 inclusive reduce the principal? d) How much interest will be paid in the third year? e) What will be the final payment?
Thirteen semi-annual deposits are made earning interest of 6.3​% compounded semi-annually. The size of the first...
Thirteen semi-annual deposits are made earning interest of 6.3​% compounded semi-annually. The size of the first deposit is $1600 and the deposits increase at 3.2​% thereafter. a)Determine the total amount deposited b)how much was the accumulated value of the deposits just after the last deposits was made c)what is the size of the 11th deposits d)what is the amount of interest included in the accumulated value
What nominal rate per annum compounded weekly is equal to 9.5% p.a. compounded semi-annually?
What nominal rate per annum compounded weekly is equal to 9.5% p.a. compounded semi-annually?
A construction company signed a loan contract at 4.07 % compounded semi-annually , with the provision...
A construction company signed a loan contract at 4.07 % compounded semi-annually , with the provision to pay $665 at the end of each month for three years. (a) What is amount of the loan? (b) How much will be owed at the end of seventeen months? (c) How much of the principal will be repaid within the first seventeen months? (d) How much interest is paid during the first seventeen months?
A $5000 semi-annual coupon bond paying interest at 12.4%/year compounded semi-annually is redeemable at par in...
A $5000 semi-annual coupon bond paying interest at 12.4%/year compounded semi-annually is redeemable at par in 16 years. It is callable at 115 at the end of 8 years and at 111 at the end of 11 years. Determine the price to guarantee a yield rate of 13.4%/year compounded semi-annually.
a company deposits 3700 a month into an account that earns 9% interacest compounded semi annually...
a company deposits 3700 a month into an account that earns 9% interacest compounded semi annually how much money will the company have accumulated in 6 years assume no interperiod compunding
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT