subject
Mathematics, 19.12.2020 05:20 csamayoa1760

Complete the amortization table provided in the Excel document posted in IvyLearn in the homework area by setting the appropriate values for a $165,000, 30-year mortgage at 4.5% interest and using Excel’s autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following: How much of the first payment goes towards the principal? How much goes toward the interest?

How much of the last payment goes towards the principal? How much goes toward the interest?

Find the total interest paid by the end of the mortgage.

How much will be owed on the mortgage after making payments for 10 years (hint this is 120 months)?

How much interest has been paid total on the mortgage at the end of 10 years?

How many months will it take to pay at least half of the principal?

Change the spreadsheet from the last question so that the mortgage is for 15 years rather than 30 years.

Find the total interest paid by the end of the mortgage.

What are some advantages and disadvantages of getting a shorter term mortgage?

ansver
Answers: 2

Other questions on the subject: Mathematics

image
Mathematics, 21.06.2019 16:00, favpat11
Find the greatest common factor of the polynomial: 10x^5+15x^4-25x^3 10x^5 x^3 5x^3 5
Answers: 2
image
Mathematics, 21.06.2019 18:10, heavenwagner
which of the following sets of data would produce the largest value for an independent-measures t statistic? the two sample means are 10 and 20 with variances of 20 and 25 the two sample means are 10 and 20 with variances of 120 and 125 the two sample means are 10 and 12 with sample variances of 20 and 25 the two sample means are 10 and 12 with variances of 120 and 125
Answers: 2
image
Mathematics, 22.06.2019 00:30, krojas015
The power generated by an electrical circuit (in watts) as a function of its current c (in amperes) is modeled by p(c)= -15c(c-8) what current will produce the maximum power?
Answers: 1
image
Mathematics, 22.06.2019 01:00, autumnrose02
Anew landowner is interested in constructing a fence around the perimeter of her property. her property is 1,080√30 feet wide and 500√20 feet long. what is the perimeter of the property? (recall that the perimeter is the sum of each side of a shape or boundary). a 1,580√40 feet b. 5,320√5 feet c. 3,160√20 feet d. 10,640√5 feet
Answers: 3
You know the right answer?
Complete the amortization table provided in the Excel document posted in IvyLearn in the homework ar...

Questions in other subjects:

Konu
History, 10.03.2020 04:37