This finance video tutorial explains how to create an amortization table in excel. Download a Compound Interest Calculator for Excel or use the online calculator for compound interest problems related to savings or loans.This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. 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 free loan payment calculator to estimate monthly payments, interest, and repayment timelines. After that, your HELOC rate will move up and down with interest rates. The age of the loan. Your Truck Loan Results, Amount. Loan amount: Monthly payment: Sales Tax: Total Interest: Total Cost: Generate Monthly Truck Loan Amortization Schedule?