![vampirelover709chc](/avatars/13689.jpg)
vampirelover709chc
19.12.2020 •
Mathematics
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?
Solved
Show answers
More tips
- W Work and Career Which types of activities are not subject to mandatory licensing?...
- C Computers and Internet Thin Client: What It Is and Why You Need It?...
- F Food and Cooking The Most Delicious and Simple Fish in Batter Recipe...
- F Food and Cooking Red Caviar: How to Choose the Best?...
- C Computers and Internet Clearing Cache: How to Speed Up Your Browser...
- S Style and Beauty How are artificial nails removed?...
- S Style and Beauty Secrets of Tying a Pareo: 5 Ways...
- F Food and Cooking Everything You Need to Know About Pasta...
Answers on questions: Mathematics
- M Mathematics The inverse variation equation shows the relationship between wavelength in meters, x, and frequency, y. 3 x 10 Х m What are the wavelengths for X-rays with frequency 3 * 10187 1x...
- M Mathematics Fiona y sus amigas fueron a una tienda de batidos. Pidieron tres batidos de fresa y dos batidos de proteínas por un total de $ 24,00. La semana pasada pidieron un batido de fresa...
- M Mathematics Convert 76,000 ml into l. show your work....
Ответ:
Papua New Guinea
Explanation:
Papua New Guinea is the modern day country which contains the most traditional ethnic groups, but Eritrea is a also a very traditional modern day place, and contains around six ethnic groups