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.
- Find the current loan’s outstanding balance and remaining term from its latest statement or lender account.
- Get the proposed loan amount, APR, term and itemised costs from the lender’s documents.
- Enter the proposed amount, rate and term, and note the estimated payment and interest.
- 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
- Closing Costs on a House Loan: What to Expect$405.53
- Secured Loan for Home Refinancing: Payment Calculator$405.53
- Closing Cost House Calculator: Estimate Buyer Costs$8,500.00
- Closing Cost House Estimate Calculator
- Loan Repayment Extension Request Letter: What to Include$405.53
- Refinance Calculator With PMI and Loan Term