Housing Loan Repayment Schedule Calculator

A housing loan repayment schedule shows how each regular payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, annual interest rate and term to estimate the monthly payment and total interest for a fixed-rate, fully amortizing loan.

Formula

For a fixed annual percentage rate and equal monthly payments, the payment is calculated using the standard amortizing-loan formula:

Monthly payment = P × r ÷ [1 − (1 + r)⁻ⁿ]

• P is the amount borrowed, in dollars.
• r is the monthly interest rate as a decimal: annual APR ÷ 1,200. For an 8% APR, r = 8 ÷ 1,200.
• n is the number of monthly payments: loan term in years × 12.

The calculator rounds the monthly payment to the nearest cent. It estimates total interest as the rounded payment multiplied by the number of scheduled payments, minus the original principal: Total interest = monthly payment × n − P. Because the payment is rounded, the final payment on a real loan may be adjusted slightly to clear the remaining balance.

Worked Example

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

1. Convert the annual APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
2. Find the payment count: 5 × 12 = 60 months.
3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53 per month, rounded to cents.
4. Estimate total interest using that rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

These are level-payment estimates. A lender’s actual schedule may show a different final payment or totals if it uses different dates, rounding conventions, fees or loan terms.

Assumptions

• The interest rate stays fixed for the entire term.
• Payments are equal, made monthly, and assumed to arrive at the end of each monthly period.
• Interest is modelled monthly using APR ÷ 12, with no separate daily-interest timing adjustment.
• Fees, taxes, insurance, mortgage insurance, escrow, late charges and other costs are not included.

How a Housing Loan Schedule Works

A repayment schedule, also called an amortization schedule, lists the payment due in each period and separates it into interest and principal. Interest for a period is calculated on the outstanding balance under the loan’s terms. The portion left after interest is applied reduces principal. In a conventional level-payment schedule with a fixed rate, the total scheduled payment stays broadly level, while its components change.

Early in the loan, the balance is larger, so a larger share of a payment generally goes to interest. As principal falls, the interest portion usually shrinks and more of each payment reduces principal. This does not mean the lender charges more interest simply because a payment is early; it reflects interest being calculated on the balance outstanding for each period.

For example, with the defaults above, the first month’s approximate interest is $20,000 × 0.0066667, or $133.33. Of the $405.53 payment, roughly $272.20 therefore reduces principal, leaving an estimated balance of $19,727.80. Later rows use the revised balance. Small differences can arise because displayed figures are rounded.

Reading and Using the Estimate

The monthly payment is the scheduled principal-and-interest amount under the stated assumptions—not necessarily the full amount billed for housing. A bill can also include separate items such as property-related charges, insurance or escrow collections. Those amounts depend on the loan arrangement and other facts, so they are not inferred by this calculator.

Total interest is the estimated interest paid across the entire term if all scheduled payments are made as modelled. It is not the total cash cost of owning a home, and it does not include fees or other housing expenses. To understand a specific loan, compare this estimate with the lender’s payment schedule and written disclosure; use the same principal, rate, term and payment frequency when checking figures.

• Enter the amount actually borrowed, not a home’s purchase price unless the entire price is financed.
• Use the annual APR as a percentage, such as 6.5 for 6.5%, not 0.065.
• Enter the term in years. The calculator converts it to months by multiplying by 12.
• Check whether the stated rate is fixed for the full term. A changing rate cannot be represented by one fixed-rate calculation.

What Can Change the Schedule?

The calculation is a useful baseline, but actual repayment schedules depend on the contract and payment history. A variable rate can change the interest charged and may alter the payment, term or both, depending on the arrangement. A different payment date or interest-accrual convention can also change the amounts assigned to individual periods.

Extra principal payments, skipped or late payments, payment holidays, fees added to the balance, and loan modifications can all make the actual schedule diverge from the original one. Extra payments may reduce the balance sooner, but how they are applied and whether they change the payment or payoff date depends on the lender’s terms. The calculator does not model these events.

One common misconception is that every housing loan has a fixed monthly payment covering all housing costs. The formula only estimates the regular principal-and-interest payment for a level-payment loan. It does not tell you what a lender will approve, what a household can afford, or what total monthly housing expenses will be.

Frequently Asked Questions

What is a housing loan repayment schedule?
A repayment schedule is a period-by-period record of the planned payments, interest charged, principal repaid and remaining balance. It is often called an amortization schedule.

How do I calculate a monthly housing loan payment?
Use the amortizing-payment formula with the amount borrowed, monthly rate (annual APR divided by 1,200) and total number of monthly payments. This calculator applies that formula and rounds the payment to cents.

Why is the interest portion higher at the start?
Interest is calculated on the outstanding balance. That balance is usually highest at the beginning, so more of an early level payment goes to interest; as principal is repaid, the interest portion generally declines.

Does the calculated payment include taxes and insurance?
No. It estimates principal and interest only. Taxes, insurance, mortgage insurance, escrow and fees are outside the calculation unless separately entered into another estimate.

Does making an extra payment change the schedule?
It can, if the lender applies the extra amount to principal. The effect on the payment amount or payoff date depends on the loan terms and how the payment is processed; this calculator assumes no extra payments.

Why might my lender’s figures differ?
Differences can come from the actual loan amount or rate, payment dates, rounding, fees, rate changes or a final payment adjustment. Check the lender’s schedule and disclosure for the contract-specific figures.

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

Related

• 3-Year Personal Loan Repayment Schedule Calculator
• Loan Repayment Schedule Calculator and Payment Breakdown
• 10-Year Business Loan Repayment Schedule Calculator

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