calculate-loan

01 Loan payments

Housing Loan Payment Viewer and Monthly Cost Calculator

Calculator No. 01-6449 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.80
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A housing loan payment viewer estimates your monthly principal-and-interest payment from the loan amount, annual APR, and repayment term. Enter those figures to see the payment and the total interest implied by a fixed-rate, monthly-payment calculation; the estimate does not include housing costs such as taxes or insurance.

Formula

The calculator uses the standard fixed-payment loan formula. It converts the annual percentage rate (APR) to a monthly rate, then calculates the payment needed to repay principal and interest in equal monthly installments:

Monthly payment = round[P × r ÷ (1 − (1 + r)−n), 2]

  • P is the amount borrowed, in dollars.
  • r is the monthly interest rate as a decimal: APR ÷ 1,200. For an 8% APR, r = 8 ÷ 1,200.
  • n is the number of monthly payments: loan term in years × 12.
  • round(…, 2) rounds the payment to the nearest cent.

Total interest is estimated as monthly payment × n − P. This total uses the rounded monthly payment, so it may differ slightly from a calculation that retains fractions of a cent in every installment. The formula assumes a positive APR and a fixed rate over the full term.

Worked Example

Using the calculator’s defaults—$20,000 borrowed, 8% APR, and five years:

  1. Convert the APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
  2. Convert the term to payments: 5 × 12 = 60 months.
  3. Substitute the values: payment = round[$20,000 × 0.0066667 ÷ (1 − (1.0066667)−60), 2].
  4. The monthly principal-and-interest payment is $405.53.
  5. Using the displayed payment, total interest = $405.53 × 60 − $20,000 = $4,331.80.

Assumptions

  • The interest rate remains fixed for the entire loan term.
  • Payments are equal, made monthly, and occur at the end of each payment period.
  • Interest is modelled monthly at APR divided by 12.
  • The estimate excludes fees, taxes, homeowners insurance, mortgage insurance, escrow deposits, and other charges because they are not inputs.

What a Housing Loan Payment Viewer Shows

A housing loan payment viewer is a calculator for estimating the scheduled payment on a housing-related loan. The phrase can also describe a lender’s account tool that displays an existing payment schedule. This page provides the calculation: it estimates principal and interest from the loan balance at origination, APR, and term. It does not retrieve an individual loan account or verify a lender’s figures.

For example, a home loan payment can be larger than its principal-and-interest component if the borrower also pays amounts for property-related charges through the same monthly bill. Those additional amounts depend on the property, loan arrangement, and applicable charges. Since they are not entered here, treat the displayed payment as a loan-payment estimate, not a complete monthly housing budget.

How to Use and Interpret the Estimate

  • Loan amount: Enter the principal being borrowed, rather than the property’s purchase price if a down payment or other funds reduce the amount financed.
  • APR: Enter the annual rate supplied for the loan scenario. The 8% default is only an example, not a statement about available rates. Obtain the applicable figure and its definition from the lender.
  • Term: Enter the repayment period in years. A longer term generally spreads repayment across more installments; under this formula, that changes both the scheduled payment and total interest.
  • Results: Monthly payment is the same scheduled amount throughout this fixed-rate model. Total interest is the estimated sum of interest over all payments, not the total of payments and not the full cost of owning a home.

Small input changes can have different effects. A larger principal raises the payment when other inputs stay fixed. A change in APR affects the interest portion and payment. Changing the term changes the number of installments, so compare estimates only when you understand which inputs differ.

Why the Payment Changes Over Time

Although the model shows one level monthly payment, the split between principal and interest changes as the balance falls. Interest for a period is based on the outstanding balance and periodic rate. Early in repayment, the balance is relatively high, so more of a scheduled payment may go toward interest; later, more can go toward principal. The payment formula accounts for this pattern while producing equal installments.

For the worked example, the first month’s approximate interest is $20,000 × 0.0066667, or $133.33. The rest of the $405.53 payment—about $272.20—reduces principal. Later interest is calculated on a smaller balance. Actual servicing schedules may differ because of payment dates, rounding conventions, fees, rate changes, or other contract terms.

Common Problems and Limits

  • Entering the rate incorrectly: APR is entered as a percentage, so enter 8 for 8%, not 0.08. The formula converts it to a monthly decimal rate.
  • Using the wrong principal: The property price, down payment, financed amount, and current outstanding balance are different quantities. Use the principal relevant to the estimate.
  • Confusing payment with total housing cost: This result excludes taxes, insurance, mortgage insurance, escrow, and fees. Add those separately using figures supplied for the specific situation.
  • Assuming every loan is fixed-rate: A variable-rate loan may have payments that change, so one fixed APR cannot represent its full future schedule.
  • Expecting an exact lender quote: Payment timing, daily interest, rounding, fees, and contract details can affect the billed amount. This formula is a simplified estimate, not a substitute for a loan disclosure or account statement.

The estimate also does not determine eligibility, approval, or what amount a person can afford. Those questions require information and criteria beyond this arithmetic.

Frequently Asked Questions

What does a housing loan payment viewer calculate?
It estimates the monthly principal-and-interest payment for a loan using the amount borrowed, APR, and term. This calculator also estimates total interest across the scheduled payments.

Does the monthly payment include property taxes and insurance?
No. Taxes, homeowners insurance, mortgage insurance, escrow, and fees are excluded. The result covers only the payment calculated from principal, interest, and term.

Why is my lender’s payment different?
A lender’s figure may include additional charges or reflect different payment dates, rounding, fees, or loan terms. Compare the same principal, rate, term, and included costs, and consult the lender’s disclosure for its exact calculation.

Is APR the same as the monthly interest rate?
No. APR is entered as a yearly percentage. This calculator divides it by 12 to model the monthly rate, using APR ÷ 1,200 as a decimal.

Can I use this for an adjustable-rate housing loan?
Only for a simplified estimate during a period when a particular rate applies. The calculator assumes that rate stays fixed for the entire term, so it cannot project later rate changes.

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

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

The whole Loan payments section →