Question

In: Finance

PLEASE ROUND TO THE NEAREST CENT FOR FINAL ANSWER Compare the monthly payments and total loan...

PLEASE ROUND TO THE NEAREST CENT FOR FINAL ANSWER

Compare the monthly payments and total loan costs for the following pairs of loan options. Assume that both loans are fixed rate and have the same closing costs.

You need a ​$130,000 loan.

Option​ 1: a​ 30-year loan at an APR of 9.5​%.

Option​ 2: a​ 15-year loan at an APR of 8.5%.

--------------------------------------------------------------------

1.) Find the monthly payment for each option.

The monthly payment for option 1 is what?

The monthly payment for option 2 is ​what?.

​(Do not round until the final answer. Then round to the nearest cent as​ needed.)

2.) Find the total payment for each option.

The total payment for option 1 is what?

The total payment for option 2 is what?

​(Round to the nearest cent as​ needed.)

Compare the two options. Which appears to be the better​ option?

A.Option 2 is the better​ option, but only if the borrower can afford the higher monthly payments over the entire term of the loan.

B.Option 1 will always be the better option.

C.Option 1 is the better​ option, but only if the borrower plans to stay in the same home for the entire term of the loan.

D.Option 2 will always be the better option

Solutions

Expert Solution

As we know that the formula for EMI is given by

EMI = [P x R x (1+R)^N]/[(1+R)^N -1]

Where

P = Principal or Loan Amount

R = Rate of interest (Monthly)

N = Total Monthly Payments

Now in question we have 2 options, we will solve for option 1

Option 1

P = 130000

R = 9.5/12 = 0.7916666667%

N = 12 months * 30 years = 360

Putting in the formula we get

EMI = [P x R x (1+R)^N]/[(1+R)^N -1]

= [130000 * (0.095/12) * (1+(0.095/12))^360]/(1+(0.095/12))^360 - 1)

= [130000 * (0.007916666667) * 17.0948617968]/16.0948617968

= 17,593.4619332808/16.0948617968

= 1,093.1104693784

= 1093.11

EMI = 1093.11

Total Payment for Option 1

So Total Payment = 1093.11 * 360

= 3,93,519.6

Option 2

P = 130000

R = 8.5/12 = 0.7083333333

N = 12 months * 15 years = 180

Putting in the formula we get

EMI = [P x R x (1+R)^N]/[(1+R)^N -1]

= [130000 * (0.085/12) * (1+(0.085/12))^180]/(1+(0.085/12))^180 -1)

= 3,280.6099462031/2.5626533352

= 1,280.1614253248

= 1280.16

EMI = 1280.16

So Total Payment = 1280.16 * 180

= 2,30,428.8

As the payment in option 2 is the best option as the total payment would be (393519.6 - 230428.8) = 1,63,091.6 less. The monthly payments would be higher by (1280.16/1093.11) - 1 = 17.11% higher so it might affect the payment capability of the borrower. So the Answer A

A. Option 2 is the better​ option, but only if the borrower can afford the higher monthly payments over the entire term of the loan.


Related Solutions

Please round to the nearest cent for all answers. --------------------------------------------------------------------------------- Compare the monthly payment and total...
Please round to the nearest cent for all answers. --------------------------------------------------------------------------------- Compare the monthly payment and total payment for the following pairs of loan options. Assume that both loans are fixed rate and have the same closing costs. You need a ​$160,000 loan. Option​ 1: a​ 30-year loan at an APR of 7.25%. Option​ 2: a​ 15-year loan at an APR of 6.8%. ---------------------------------------------------------------- Find the monthly payment for each option. The monthly payment for option 1 is​what. The monthly payment...
Determine the payment to amortize the debt. (round your answer to the nearest cent.) Quartey payments...
Determine the payment to amortize the debt. (round your answer to the nearest cent.) Quartey payments on $15,500 at 3.5% for 6 years. Find the unpaid balance on the debt. (Round your answer to the nearest cent) After 7 years of monthly payments on $180,000 at 3% for 25 years.
Calculate the present value of the annuity. (round your answer to the nearest cent.) $1800 monthly...
Calculate the present value of the annuity. (round your answer to the nearest cent.) $1800 monthly at 6.1% for 30 years. Determine the payment to amortize the debt. (round your answer to the nearest cent.) Monthly payments on $170,000 at 3% for 25 years.
1.Determine the payment to amortize the debt. (Round your answer to the nearest cent.) Quarterly payments...
1.Determine the payment to amortize the debt. (Round your answer to the nearest cent.) Quarterly payments on $19,500 at 3.2% for 6 years. 2.Calculate the present value of the annuity. (Round your answer to the nearest cent.) $13,000 annually at 5% for 10 years. 3.In the following ordinary annuity, the interest is compounded with each payment, and the payment is made at the end of the compounding period. How much must you invest each month in a mutual fund yielding...
28. calculate  the present value of the annuity. (Round your answer to the nearest cent.) $1300 monthly...
28. calculate  the present value of the annuity. (Round your answer to the nearest cent.) $1300 monthly at 6.3% for 30 years. 29. determine the payment to amortize the debt. (Round your answer to the nearest cent.) Monthly payments on $130,000 at 4% for 25 years.
Find the average total cost for producing 32 sneakers. Round your answer to the nearest cent.
The table below represents the costs of producing sneakers.QuantityFixed CostVariable CostTotal CostAverage Fixed CostAverage Variable CostAverage Total Cost8$117$10$127???16$117$60$177???24$117$110$227???32$117$160$277???40$117$210$327???Find the average total cost for producing 32 sneakers. Round your answer to the nearest cent.Provide your answer below:
*Do not round any answer until your final answer. Round your final answer to the nearest...
*Do not round any answer until your final answer. Round your final answer to the nearest whole dollar. When entering your final answer, do not use commas or $ sign. (Sorry...Canvas is very sensitive and will mark your answer incorrect due to rounding and punctuation.) Due to possible rounding differences, all answer solutions are programmed as acceptable that are +/- 1. For example, if the correct answer is $54,372, all possible answer solutions that would be accepted would be 54,371,...
Compare the monthly payments and total loan costs for the following pairs of loan options. Assume...
Compare the monthly payments and total loan costs for the following pairs of loan options. Assume that both loans are fixed rate and have the same closing costs. You need a ​$90,000 loan. Calculate Option​ 1: a​ 30-year loan at an APR of 6.65​%. Option​ 2: a​ 15-year loan at an APR of 6.25%.
Compare the monthly payments and total loan costs for the following pairs of loan options. Assume...
Compare the monthly payments and total loan costs for the following pairs of loan options. Assume that both loans are fixed rate and have the same closing costs. You need a ​$110,000 loan. Option​ 1: a​ 30-year loan at an APR of 7.25​%. Option​ 2: a​ 15-year loan at an APR of 6.8%. --------------------------------------------------------------------------------------------------------- 1.) Find the monthly payment for each option. The monthly payment for option 1 is what? The monthly payment for option 2 is​what?. ​(Do not round...
Compare the monthly payments and total loan costs for the following pairs of loan options. Assume...
Compare the monthly payments and total loan costs for the following pairs of loan options. Assume that both loans are fixed rate and have the same closing costs. You need a ​$110,000 loan. Option​ 1: a​ 30-year loan at an APR of 7.25​%. Option​ 2: a​ 15-year loan at an APR of 6.8%. 1.) Find the monthly payment for each option. The monthly payment for option 1 is what? The monthly payment for option 2 is​ what?. ​(Do not round...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT