The person will take 252 months to repay half of the principal. You can use the formulas PPMT for principal, IPMT for interest and PMT for EMI.The loan amortization schedule is as below:
https://docs.google.com/spreadsheets/d/1fBu2WU5iVZpQOafhTUIg_ygvv02S_mK4a1Tdj37l5X0/edit?usp=sharing
PS: The loan schedule is too long to attach here. You can find it in the above link. It is not possible to attach it as a picture too.
Question 16 1 pts Excel Questions 13-16. Complete the amortization table provided in the Excel document...
Loans Excel Homework Assignment Mortgage Amortization Schedule Excel Assignment 1. Excel: Complete the amortization table provided in the Excel document posted in 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: a. How much of the first payment goes towards the principal? How much goes toward the interest?...