Answer:
Please find the complete question in the attached file.
Step-by-step explanation:
Use PMT for the interest amount computation
At first, the bulk of an initial premium is paid at the rate of interest, and that only the remainder of the small part is used for amortization. The very first three years schedule is shown below:
By the 49th payment, upwards of half of the initial amount borrowed would be the total principal paid. Using the formula CUMPRINC in excel, the entire principal payment is calculated twice.
Total Interest Expense