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.This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. This loan amortization calculator figures your loan payment and interest costs at various payment intervals. Simply input the principal amount borrowed. This should give you a basic structure for your amortization schedule with accrued interest and principal and interest payments. The APR gives borrowers a more accurate assessment of a loan's actual cost. Modify values and click calculate to use. NerdWallet's early mortgage payoff calculator figures out how much more to pay. Combining the strengths of the American Institute of CPAs (AICPA) and The Chartered Institute of Management Accountants (CIMA).