If you have any comments, or suggestions for enhancing the calculator, please let me know in the comments. The calculator uses the IFERROR function, so you’ll need to change that if using an earlier version of Excel. The file is in Excel 2007 format, and zipped. In the Download section, click the link to get the Enhanced Loan Payment Calculator. To see the formulas, and experiment with the calculator, go to the PMT function page on my Contextures website. Loan Repayment Tracker, EXCEL Worksheet, Easy EXCEL Budget ad vertisement by ASALBIC Ad vertisement from shop ASALBIC ASALBIC From shop ASALBIC. You can omit the minus sign, to show the payment as a negative number.ĭownload the Excel Loan Payment Calculator Debt Snowball Excel Spreadsheet Google Sheets Debt Payoff Tracker Excel Debt Snowball Calculator Student Loan Payoff House Debt Payoff Chart. I added a minus sign before the present value variable, so the monthly payment is shown as a positive number. The payment amount is calculated with the PMT function: The Lists sheet has a lookup table of frequencies and number of payments.īased on the frequency that you select, a number of payments per year is calculated in cell E5, using a VLOOKUP formula. Type in any cell, except Payment Frequency, where you can select from a drop down list of options. Of course, if you are the Bank of Dad, you might offer a lower interest rate, so you can adjust any, or all, or the green cells. Be on top of your mortgage payments with confidence using s Mortgage Loan Amortization Calculator. It uses the PMT function to calculate the payment amount, and you can enter the variables: Easily Editable, Printable, Downloadable. (The kids will think you’re cool when you say “nifty”.) (Oh yes, they will stick to the plan, without fail.) To help you figure out the payment amounts, here is a nifty Excel loan payment calculator. Can you afford that new car? Or maybe you loaned money to one of your kids, and you want to calculate a repayment schedule.

Excel student loan repayment calculator