Equity Loan Payment Schedule Calculator

This equity loan payment schedule calculator estimates a fixed-rate loan’s monthly payment and total interest from the amount borrowed, annual percentage rate (APR), and term. Enter the figures from a lender’s quote to see the level-payment estimate; this schedule is not a home-equity line of credit (HELOC) draw or variable-rate forecast.

Formula

The calculator uses the standard fixed-payment amortizing-loan formula. It first calculates the monthly payment, rounds that payment to cents, then multiplies the rounded payment by the number of monthly payments and subtracts the original principal to estimate total interest.

• p = amount borrowed, in dollars.
• apr = annual percentage rate, entered as a percentage per year.
• r = monthly interest rate, calculated as apr ÷ 1,200.
• yrs = loan term in years.
• n = number of monthly payments, calculated as yrs × 12.
• pmt = monthly payment in dollars, rounded to the nearest cent.
• int = estimated total interest in dollars over the stated term.

In symbols, pmt = round[p × r ÷ (1 − (1 + r)⁻ⁿ), 2], where r = apr ÷ 1,200 and n = yrs × 12. Then int = pmt × n − p. This assumes regular monthly payments and a fixed rate. The formula does not calculate a lender’s exact statement balance or payment dates.

Worked Example

Using the calculator’s default values—$20,000 borrowed, 8% APR, and a five-year term:

1. Convert the APR to a monthly rate: 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
2. Find the number of payments: 5 × 12 = 60.
3. Apply the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = about $405.53 per month after rounding.
4. Multiply the rounded payment by the payment count: $405.53 × 60 = $24,331.80.
5. Subtract the principal: $24,331.80 − $20,000 = $4,331.80 estimated total interest.

The estimated schedule therefore has 60 level monthly payments of $405.53, with total scheduled payments of $24,331.80. Actual lender figures can differ because a contract may use different payment dates, rounding, fees, or other terms.

Assumptions

• The interest rate is fixed for the full term.
• Payments are equal monthly payments made at regular intervals; the formula treats them as end-of-period payments.
• Interest is compounded monthly using APR ÷ 12 as the periodic rate.
• Fees, taxes, insurance, mortgage insurance, escrow, and other charges are not included.
• The payment is rounded to cents, and total interest uses that rounded payment for every scheduled month.

How to Read an Equity Loan Payment Schedule

An equity loan is generally structured as a lump-sum loan secured by home equity, with repayment governed by the specific loan agreement. A payment schedule, also called an amortization schedule, shows how each scheduled payment is split between interest and principal, as well as the remaining balance after each payment.

Early in a typical amortizing loan, the outstanding balance is higher, so more of each payment goes toward interest. As the balance declines, the interest portion usually falls and the principal portion rises. The scheduled payment can remain level even while its allocation changes. This calculator reports the payment and total interest, not a month-by-month table or a precise payoff balance.

For a full schedule, each period’s interest is generally based on the opening balance and the applicable periodic rate; the rest of the payment reduces principal. The exact method and timing are determined by the loan documents. Ask the lender for its amortization schedule if you need dates, a per-payment breakdown, or a balance for a particular day.

What Changes the Payment?

For otherwise identical inputs, a larger principal usually means a larger payment. A higher APR also raises the payment and the interest cost. A longer term generally lowers the required monthly payment but increases the number of payments over which interest accrues. These are mathematical relationships in the formula, not a judgment about which term or loan to choose.

For example, compare terms only after entering the actual quoted principal and APR, and keep those inputs unchanged if you want to isolate the effect of term. The results remain estimates: changing the payment frequency, rate structure, or fee treatment can change the schedule.

Equity Loan Versus a HELOC

A fixed-amount equity loan and a HELOC should not be treated as interchangeable in this calculator. A fixed loan provides a defined principal amount and may have a scheduled repayment term. A HELOC is a credit line that can involve borrowing at different times and may have a changing rate or distinct draw and repayment periods. A single fixed-rate amortization formula cannot represent those changing balances and terms.

Use the calculator only when the figures describe a fixed-rate loan repaid through regular monthly installments. For a line of credit, ask the lender for payment illustrations that account for the amount drawn, rate changes, and applicable repayment provisions. Do not assume a HELOC’s payment will stay level simply because this calculator shows one level payment.

Common Errors and Limits

• Entering APR as a decimal: enter 8 for 8%, not 0.08. The calculator converts the annual percentage to a monthly rate.
• Using the home’s value instead of the loan amount: enter the principal actually borrowed, not an estimate of property value or equity.
• Confusing total interest with total payments: total interest excludes repayment of principal; total scheduled payments equal principal plus interest in this simplified calculation.
• Expecting fees or optional charges to appear: they are not inputs, so the outputs exclude them.
• Assuming every final payment is identical: lender rounding or payment-date rules may result in a small adjustment to the last payment.

The calculator also assumes the APR can be treated as the interest rate for this monthly calculation. If the lender’s disclosed APR includes charges or the contract uses a different rate convention, the estimate may not match its schedule. Enter the loan’s relevant figures as specified in the lender’s documents.

Frequently Asked Questions

How do I calculate a monthly equity loan payment?
Enter the principal, annual APR, and term in years. The calculator converts the APR to a monthly rate and applies the fixed-payment formula, rounding the result to cents.

Does this calculator show principal and interest for every month?
No. It estimates the monthly payment and total interest. Request a lender-provided amortization schedule for the monthly interest, principal, and remaining-balance detail.

Is an equity loan payment the same as a HELOC payment?
No. This calculation models a fixed principal amount, fixed APR, and regular monthly installments. A HELOC may have a changing balance or rate and different periods, which this formula does not model.

Why might my lender’s payment differ?
The agreement may include a different rate basis, payment timing, fees, rounding convention, or other charges. Compare the calculator’s assumptions with the lender’s disclosed terms.

Does total interest include fees, taxes, or insurance?
No. The estimate uses principal, APR, and term only. Those other amounts are not included unless reflected in the figures you enter, and they may be billed separately.

This result is an estimate for educational use; the lender’s disclosure gives the exact figures.

Related

• Mortgage Loan Amount Calculator: The Loan a Monthly Payment Repays
• Home Equity Loan Calculator: Amount Up to a CLTV Limit and Payment
• Mortgage Calculator With Escrow: Payment With Tax and Insurance

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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2