This finance video tutorial explains how to create an amortization table in excel. To use our amortization calculator, type in a dollar figure under "Loan amount.This document provides instructions for creating a mortgage payment calculator in Excel that includes a data table and amortization schedule. Use these calculator templates to help you navigate your loans, budgets, net worth, and more. This spreadsheet creates an amortization schedule for a fixed-rate loan, with optional extra payments. Users will enter a percentage in the down payment cell. Use our free loan payment calculator to estimate monthly payments, interest, and repayment timelines. LendingTree helps you get the best deal possible on your loans. By providing multiple offers from several lenders, we show your options, you score the win. Stock performance is actually not as sensitive to valuation as it is to growth and profitability.