To calculate a loan payment amount, given an interest rate, the loan term, and the loan amount, you can use the PMT function. In the example shown, the. Professional financial calculators for Microsoft Excel by Spreadsheet including Loan Calculators, Mortgage Calculators, Wedding Budget Calculator. For. Use the spreadsheet to compare different terms, rates, and loan amounts. The spreadsheet allows complete flexibility in how you make additional payments. Term loans use a different amortizing method than common amortizing loans. Here's how to use Excel to generate a term-loan amortization schedule. 1, Loan Calculator with Extra Payments. 2. 3, Enter values, Instructions. 4, Loan amount, Must be between 1 and 30 years. 5, Annual interest rate, If your extra. Free collection of financial calculators in Excel, including retirement, (k), budget, Although intuitive to use, each calculator also contains helpful information.