calculate-loan

01 Loan payments

Macquarie Refinance Calculator: Estimate Loan Payments

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

Monthly payment $405.53
Total interest
$4,331.67
= 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 Macquarie refinance calculator can estimate repayments and total interest on a refinanced loan when you enter the amount borrowed, annual interest rate and loan term. This general calculator shows the scheduled monthly payment and interest over the full term; it does not provide a Macquarie quote or include refinancing costs.

Formula

The calculator uses the standard fixed-rate, fully amortizing loan payment formula. It calculates a level monthly payment that repays the entered principal and interest over the chosen number of months:

  • Monthly rate: r = APR / 1,200. APR is entered as a percentage per year; division by 1,200 converts it to a monthly decimal rate.
  • Number of monthly payments: n = years × 12.
  • Monthly payment: P × r / [1 − (1 + r)−n].
  • Total interest: monthly payment × n − P.

Here, P is the loan principal in dollars, r is the monthly interest rate as a decimal, n is the number of monthly payments, and APR is the annual percentage rate entered in percent. The payment is rounded to cents before total interest is calculated. A real offer may use a different rate structure, payment schedule or fee treatment, so these figures are an estimate rather than a lender’s quote.

Worked Example

Using the calculator’s default values—$20,000 borrowed, 8% APR and a five-year term—the monthly rate is 8 / 1,200 = 0.0066667, and the term is 5 × 12 = 60 monthly payments.

Monthly payment = 20,000 × 0.0066667 / [1 − (1 + 0.0066667)−60] = $405.53 when rounded to the nearest cent. Total interest = $405.53 × 60 − $20,000 = $4,331.80. The result is based on 60 payments of the rounded monthly amount.

Assumptions

  • The interest rate is fixed for the full term.
  • Payments are made monthly at the end of each period.
  • Interest compounds monthly at APR divided by 12.
  • Fees, taxes, insurance, mortgage insurance and escrow are not included.

Using the Estimate for a Refinance

To explore a possible refinance, enter the amount you would actually borrow, the rate supplied for comparison, and the proposed repayment term. The amount borrowed may not be the same as the balance on an existing loan if costs are added to the new principal. Use lender-provided figures for the rate and any amount to be financed rather than relying on a generic rate assumption.

For a like-for-like comparison, calculate the existing loan’s remaining payments and interest separately, then compare them with the estimated new loan payments and costs over the same time horizon. A lower monthly payment alone does not establish that the overall borrowing cost is lower: a longer term can reduce each payment while increasing the number of payments and total interest. This calculator does not decide whether refinancing is suitable for a particular borrower.

  1. Find the current loan’s outstanding balance and remaining term from its latest statement or lender account.
  2. Get the proposed loan amount, APR, term and itemised costs from the lender’s documents.
  3. Enter the proposed amount, rate and term, and note the estimated payment and interest.
  4. Account separately for fees and any other charges not represented by the calculator, then compare totals over the period you are evaluating.

What the Results Include—and Leave Out

The monthly payment is the scheduled principal-and-interest amount under the formula’s assumptions. The total-interest result is that rounded payment multiplied by the number of payments, less the original principal. It is not the total amount repaid: to estimate that under this simplified model, add the principal to the interest result.

The calculation does not include application, valuation, settlement or discharge charges, or any other lender or third-party costs. It also does not model a variable rate, introductory rate, missed or extra payments, payment-frequency changes, or fees that are paid separately. If a cost is included in the new loan balance, it changes the principal and therefore affects the payment and interest; if paid upfront, it is outside these outputs.

Common Comparison Mistakes

  • Comparing different terms: A longer term usually spreads repayment across more months. Compare the term as well as the monthly amount.
  • Using the wrong principal: The refinance amount may differ from the balance shown on an older statement. Use the current payoff or borrowing figure supplied for the proposed transaction.
  • Forgetting costs: The calculator’s outputs exclude fees. Treat costs separately or include them in the principal only if they will actually be financed.
  • Mixing rate formats: Enter an annual percentage such as 8 for 8%, not 0.08 or a monthly rate. The formula converts APR to a monthly rate.
  • Reading a rounded estimate as an exact quote: The displayed payment is rounded to cents; actual lender calculations may differ because of dates, rounding conventions or loan terms.

The formula is suitable for a straightforward fixed-rate loan with equal monthly payments. It cannot reproduce a lender’s complete payoff statement or determine approval, eligibility, the applicable rate or transaction costs. Obtain those details directly from the lender and check the loan disclosure for the full repayment schedule.

Frequently Asked Questions

Does this calculator give a Macquarie refinance quote?
No. It is a general loan-payment estimate and does not connect to a lender or use an individualised offer. Use the figures and disclosures provided by the lender for a quote.

What loan amount should I enter?
Enter the principal you expect to borrow for the new loan. If costs will be added to the balance, include them only when the lender confirms they are being financed.

Why can a longer refinance term lower the monthly payment?
It divides repayment across more months. The calculator also shows total interest, which can rise when interest accrues over a longer repayment period.

Does the result include refinancing fees?
No. Fees and other transaction costs are not inputs in this calculator. Check the lender’s itemised figures and account for costs separately.

Can I use it for a variable-rate loan?
The formula assumes one fixed rate throughout the term. It cannot forecast payments when a rate changes; a variable-rate estimate would need to be recalculated whenever the rate or loan balance 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 | $ | 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

The whole Loan payments section →