Question

In: Finance

You have just bought a house and have taken out a mortgage (an installment) loan for...

You have just bought a house and have taken out a mortgage (an installment) loan for $500,000. This is a 30-year loan that requires monthly payments and the first payment is due one month from today. The APR for the loan is 24%. You are interested to know how much of your 210th monthly payment will go toward the repayment of principal? That amount is _______________

Question 10 options:

$762.65

$9,586.98

$625.64

$9,494.78

$513.24

$9,382.38

$421.04

$9,245.37

Solutions

Expert Solution

Monthly payment = [P × R × (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P $                                                          500,000
Rate of interest per period:
Annual rate of interest 24.000%
Frequency of payment = Once in 1 month period
Numer of payments in a year = 12/1 = 12
Rate of interest per period R 0.24 /12 = 2.0000%
Total number of payments:
Frequency of payment = Once in 1 month period
Number of years of loan repayment =                                                                  30.00
Total number of payments N 30 × 12 = 360
Period payment using the formula = [ 500000 × 0.02 × (1+0.02)^360] / [(1+0.02 ^360 -1]
Monthly payment = $                                                      10,008.02
Principal paid (nth payment) = Payment ÷ (1+R)^(N-n+1)
Payment                                                 10,008.02
Rate of interest R= 2.0000%
nth payment n= 210
Total payments N= 360
Principal paid = 10008.02/(1+0.02^(360-210+1)
Principal paid =                                                       503.18

Answer is $513.24 (closest)

please rate.


Related Solutions

you just bought a house and have a $188,000 mortgage. the mortgage is for 15 years...
you just bought a house and have a $188,000 mortgage. the mortgage is for 15 years and has a nominal rate of 4.25%.on the 24th payment what will be the amount going to principal?
Suppose you are buying a house and have taken out a mortgage for $250,000. The mortgage...
Suppose you are buying a house and have taken out a mortgage for $250,000. The mortgage is a 30 year fixed rate mortgage with an APR of 5.25%. What is your monthly mortgage payment? Construct a loan amortization table in Excel for mortgage loan in the previous problem. You should do the problem in Excel using monthly payments and you must submit the spreadsheet with formulas.
You have just taken out an amortized loan for $404,000. Assume that the loan will be...
You have just taken out an amortized loan for $404,000. Assume that the loan will be paid in 24 equal monthly installments of ​$18,345.62​ and that the first payment will be due 1 month from today. How much of your third monthly payment will go toward the repayment of​ principal? Fill in the worksheet below.   Month Interest Owing at End of Month​ ($) Principal Repayment​ ($) Principal Owing at End of Month​ ($) 1 2 3
You have just purchased a home and taken out a $410,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $410,000 mortgage. The mortgage has a 30​-year term with monthly payments and an APR of 5.12%. a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ year? b. How much will you pay in​ interest, and how much will you pay in​ principal, during the 20th year​ (i.e., between 19 and 20 years from​ now)?
You have just purchased a home and taken out a $590,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $590,000 mortgage. The mortgage has a ​30-year term with monthly payments and an APR of 5.92%. a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ year? b. How much will you pay in​ interest, and how much will you pay in​ principal, during the 20th year​ (i.e., between 19 and 20 years from​ now)?
You have just purchased a home and taken out a $440,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $440,000 mortgage. The mortgage has a 30​-year term with monthly payments and an APR of 5.28%. a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ year? b. How much will you pay in​ interest, and how much will you pay in​ principal, during the 20th year​ (i.e., between 19 and 20 years from​ now)?
You have just purchased a home and taken out a $440,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $440,000 mortgage. The mortgage has a 30 year term with monthly payments and an APR of 5.92%. How much will you pay in interest, and how much will you pay in principal during the first year? How much will you pay in interest and how much will you pay in principal during the 20th year?
You have just purchased a home and taken out a $480,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $480,000 mortgage. The mortgage has a 30​-year term with monthly payments and an APR of 6.80%. a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ year? b. How much will you pay in​ interest, and how much will you pay in​ principal, during the 20th year​ (i.e., between 19 and 20 years from​ now)?
You have just purchased a home and taken out a $540,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $540,000 mortgage. The mortgage has a 30​-year term with monthly payments and an APR of 7.44%. a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ year? b. How much will you pay in​ interest, and how much will you pay in​ principal, during the 20th year​ (i.e., between 19 and 20 years from​ now)?
You have just bought a house and have a $125,000, 25-year mortgage with a fixed interest...
You have just bought a house and have a $125,000, 25-year mortgage with a fixed interest rate of 8.5 percent with monthly payments. Over the next five years, what percentage of your mortgage payments will go toward the repayment of principal?.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT