This finance video tutorial explains how to create an amortization table in excel. To reach the formula for compound interest, you algebraically rearrange the formula for CAGR.Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. Just convert the "daily compound interest" into "effective monthly interest". Use our home loan EMI calculator, input the loan amount, the rate of interest and the loan tenure. The debt snowball is a debt payoff method where you pay your debts from smallest to largest, regardless of interest rate. Knock out the smallest debt first.