The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance.To reach the formula for compound interest, you algebraically rearrange the formula for CAGR. It is a schedule of payments that break down your interest and principles payments towards any interest-bearing loan.