Answer:
MS Excel File is attached for the loan amortization chart, which details the payment, interest and principal each year of the loan. Replicate the chart in Excel using monthly payments. Ever things is calculated using formulas and a check is also been applied which is highlighted in yellow fill.
Pleas find it.