Debt Payment Tools

Worksheets and calculators are useful tools for computing loan and mortgage payments and the impact of changes in loan terms.  A variety of calculators are presented in the box at the right under more information.

For more information on this topic, see the links listed below of articles posted on related Web sites.

Loan Calculators
  • Revolving Loan Calculator - University of Illinois Extension – Calculates principal and interest balances for revolving loans.
  • Loan Amortization – University of Illinois Extension -- Simple loan amortization program calculating principal, interest and outstanding balance.
  • Commercial Loan Calculator –  Use this calculator to estimate your debt service coverage with a new loan. If your debt service coverage is high enough, including your new loan payment, you have a good chance of being approved.
  • Enhanced Loan Category – Use the slider controls to instantly change your monthly payment, loan amount, interest rate or term.
  • Alternative Payment Frequencies – Use this calculator to determine your payment or loan amount for different payment frequencies.
  • Amortizing Loan Calculator – Enter your desired payment - and let us calculate your loan amount. Or, enter in the loan amount and we will calculate your monthly payment!
  • Loan Comparison Calculator – Use this calculator to sort through the monthly payments, fees and other costs associated with comparing loan options.
  • Balloon Loan Calculator – A balloon loan can be an excellent option for many borrowers, use this calculator to see how a balloon loan might work for you.
  • Equity Line of Credit Payments – What will my monthly payments be for an interest only equity line of credit?
  • Existing Loan Calculator – Use this calculator to analyze one of your existing loans. Calculate your remaining balance based on the number of monthly payments you have remaining.
  • Line of Credit Payoff – Use this calculator to see what it will take to payoff your line of credit, and what you can change to meet your repayment goals.
Mortgage Calculators
  • Mortgage Loan Calculator PITI – Use this calculator to determine your monthly mortgage principal, interest, taxes and insurance payment (PITI) and amortization schedule.
  • Adjustable Rate Mortgage Calculators –Adjustable rate mortgages can provide attractive interest rates, but your payment is not fixed. This calculator helps you to determine what your adjustable mortgage payments may be.
  • Adjustable Rate Mortgage vs. Fixed Rate Mortgage – A fixed rate mortgage has the same payment for the entire term of the loan. An adjustable rate mortgage (ARM) has a rate that can change, causing your monthly payment to increase or decrease. Use this calculator to compare a fixed rate mortgage to two types of ARMs, a Fully Amortizing ARM and an Interest Only ARM.
  • Mortgage APR Calculator – Use this calculator to determine the Annual Percentage Rate (APR) for your mortgage. Press the report button for a full amortization schedule, either by year or by month.
  • Balloon Mortgage – A balloon mortgage can be an excellent option for many borrowers, use this calculator to see if a balloon mortgage might fit your needs.
  • Interest Only Mortgage Calculator – Use this calculator to generate an amortization schedule for an interest only mortgage.
  • Fixed Rate Mortgage versus Interest Only Calculator – A fixed rate mortgage has the same payment for the entire term of the loan. Use this calculator to compare a fixed rate mortgage to Interest Only Mortgage.
  • Mortgage Comparison, 15 vs. 30 years – Use this calculator to compare these two mortgage terms, and let us help you decide which term is better for you.
Debt Worksheets

Links checked November 2017.