The HSH Associates amortization calculator is a free online tool that computes a loan’s monthly payment and full amortization schedule from the loan amount, interest rate, and term. You enter those three numbers and it returns the payment, total interest, and a year-by-year or month-by-month breakdown of principal and interest. This page explains how that calculator works, how to read its output, and how to use the same math on any loan.
What HSH Associates and Their Calculator Are
HSH Associates is a publisher of mortgage and financial data, known for its national surveys of mortgage rates and its suite of free online calculators. The amortization calculator on its site is one of the most-used tools because it is simple, fast, and does not require registration. It was designed for homebuyers, refinancers, and anyone comparing loan offers, but the underlying formula works for any fixed-rate installment loan.
The tool’s popularity comes from its clarity: it shows not just the monthly payment but also a full amortization table, so you can see exactly how much of each payment goes to interest versus principal at any point in the loan. That detail matters because early payments are mostly interest, and the balance declines slowly at first.
How the Amortization Formula Works
The calculator uses the standard fixed-rate amortization formula. For a loan amount P, an annual interest rate APR (in percent), and a term of n months, the monthly payment M is:
M = P × (r / (1 − (1 + r)−n))
where r = APR / 1200 (the monthly interest rate as a decimal).
Each month, the interest portion is the current balance times r, and the principal portion is the payment minus that interest. After each payment, the balance is reduced by the principal portion, and the next month’s interest is calculated on the new, lower balance. This is called amortization, from the Latin for “to kill off”—the debt is gradually eliminated.
Worked Example with Default Values
Using the calculator defaults: $20,000 loan, 8% APR, 5-year term (60 months).
- Monthly rate r = 8 / 1200 = 0.0066667.
- Number of payments n = 5 × 12 = 60.
- Payment = 20000 × (0.0066667 / (1 − (1.0066667)−60))
- Compute (1.0066667)−60 ≈ 0.67121.
- Denominator = 1 − 0.67121 = 0.32879.
- Payment = 20000 × (0.0066667 / 0.32879) = 20000 × 0.020276 = $405.52.
So the monthly payment is $405.52. Total paid over 60 months = 60 × 405.52 = $24,331.20. Total interest = $24,331.20 − $20,000 = $4,331.20. That matches the calculator output.
Assumptions
- The interest rate is fixed for the entire term.
- Payments are made at the end of each month, starting one month after the loan is issued.
- Interest compounds monthly at APR / 12, which is the standard for most consumer loans.
- The calculation does not include property taxes, insurance, PMI, escrow, origination fees, or prepayment penalties unless you add them manually.
How to Use the Calculator for Real Decisions
To get a realistic estimate, enter the exact loan amount you expect to borrow, the annual percentage rate (APR) that a lender quotes you, and the term in years. The APR should include the interest rate plus any lender fees that are rolled into the rate, but be aware that some fees are not included in the APR calculation.
If you are comparing loans with different terms, run the calculator for each term (e.g., 15-year vs. 30-year mortgage) and compare the monthly payment and total interest. A shorter term has a higher payment but far less total interest. If you are considering extra payments, use the calculator’s extra payment feature (if available) or adjust the term to see the effect of paying more each month.
A common use is to check how much house you can afford. Decide on a comfortable monthly payment, then work backward: input different loan amounts until the payment matches your budget. Remember that your total housing cost includes taxes and insurance, which the calculator does not include.
Common Mistakes and How to Avoid Them
- Using the nominal rate instead of APR: The APR includes some fees, so it is usually slightly higher than the advertised interest rate. Using the lower rate understates your true payment.
- Mismatching the term: If you enter 30 in a field labeled “years” but the calculator expects months, your payment will be wildly wrong. Always check the unit label.
- Forgetting about taxes and insurance: For a mortgage, your actual monthly payment will be higher than the amortization payment because lenders escrow property tax and insurance. The calculator only shows principal and interest.
- Rounding too early: If you compute by hand, do not round the monthly rate or the payment until the final step. The calculator uses full precision internally, so your manual result may differ by a few cents if you round early.
- Ignoring the effect of extra payments: A single extra payment can shorten the term by months and save thousands in interest. The basic calculator does not show this unless you use the extra payment option.
Limitations of the Amortization Calculator
The HSH calculator, like all standard amortization calculators, assumes a fixed interest rate and level payments. It does not handle adjustable-rate mortgages (ARMs), interest-only periods, balloon payments, or loans with changing payment amounts. For those, you need a more specialized calculator or a spreadsheet that models the specific rate changes.
It also does not account for the timing of your first payment. If your first payment is due more than one month after closing, the interest accrues daily, and the payment is slightly different. The calculator assumes a standard one-month gap.
Finally, the calculator gives an estimate, not a commitment. Lenders use their own systems that may include daily interest proration, odd-day interest, and rounding rules that can change the exact payment by a few dollars.
Alternatives to the HSH Calculator
Several other free amortization calculators are available, including those on bank websites, financial news sites, and this very page. The formula is identical everywhere, so the results will match to the cent if you enter the same inputs. Some tools offer additional features:
- Extra payment calculators: Show how much time and interest you save by paying extra each month or making a lump-sum payment.
- Biweekly payment calculators: Show the effect of making half-payments every two weeks, which effectively makes one extra payment per year.
- Amortization schedule generators: Provide a full table of every payment, with running balances, which is useful for tax or accounting purposes.
- Refinance calculators: Compare your current loan with a new one, factoring in closing costs and the break-even point.
Whichever tool you use, the math is the same. The key is to enter accurate inputs and understand what the output does and does not include.
Frequently Asked Questions
What is the difference between an amortization calculator and a loan payment calculator?
They are essentially the same. A loan payment calculator typically shows just the monthly payment and total interest, while an amortization calculator also provides a full schedule showing each payment’s split between principal and interest and the remaining balance after each payment. The HSH tool includes both.
Can I use the HSH calculator for an auto loan or personal loan?
Yes. The amortization formula works for any fixed-rate, equal-payment loan, including auto loans, personal loans, and student loans. Just enter the loan amount, APR, and term in years. For auto loans, the term is usually 3 to 7 years; for personal loans, 1 to 5 years.
Why does the total interest seem so high?
Because interest is calculated on the remaining balance each month, and early in the loan the balance is large. For a 30-year mortgage at a typical rate, the total interest can exceed the principal. That is normal and is why many people choose shorter terms or make extra payments to reduce total interest.
Does the calculator include property taxes and insurance?
No. The HSH amortization calculator only computes principal and interest. For a mortgage, your actual monthly payment will include escrow for property taxes and homeowners insurance, which you must add separately. Some lenders also require PMI if your down payment is less than 20%.
How do I calculate the amortization schedule myself in Excel?
You can use the PMT function to get the payment: =PMT(rate/12, term*12, -loan). Then create a table where each row calculates interest = previous balance × rate/12, principal = payment − interest, and new balance = previous balance − principal. The HSH calculator does exactly this internally.
What if I make extra payments? Can the calculator show that?
The basic HSH calculator does not have an extra payment field, but you can simulate it by reducing the loan term and increasing the payment. For a precise schedule with extra payments, use a dedicated extra payment calculator or a spreadsheet that adds the extra amount to the principal each month.
Remember, the result from any amortization calculator is an estimate. Your lender’s official disclosure will show the exact payment, including any fees or adjustments.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- Personal Loans Interest Free? The Real Answer$405.53
- Personal Loan 0% Interest: Is It Real?$405.53
- Personal Loan Zero Interest: Is It Real?$405.53
- Only Loans LLC: What It Is and How It Works$405.53
- Personal Loan and Interest Only Option?$133.33
- No Interest Personal Loan? What It Really Means$405.53