The PPMT function is used to calculate the principal portion of a loan payment for a given period based on a constant interest rate and payment schedule. To download the practice Excel file please click on the link below https://www.findeasysolution.com/Downloads/MSExcel/Formulas/PPMT-Function.xlsx To learn how to create Loan Amortization schedule please click on the link below https://youtu.be/0vWk3ZGWEE0