Mortgage calculator
Supports commercial, provident-fund, and combined mortgages. Switch between equal-installment and equal-principal methods, and preview the full amortization schedule.
Parameters
Input Parameters
Result
Result Overview
Amortization schedule
Amortization Schedule
Monthly trend
Monthly Trend
Prepayment simulation
Prepayment Simulation
Mortgage Calculator Guide
Commercial / Provident Fund / Combined Loans
The mortgage calculator is the core tool in FinCompute’s financial module, designed for first-time buyers, upgraders, property investors and household financial planners. It fully supports commercial loans, housing provident fund loans and combined loans, with both equal-installment and equal-principal repayment methods, plus a built-in early-repayment simulator. It instantly produces the monthly payment, total interest, total repayment, principal/interest composition, a complete monthly amortization schedule and trend charts. All computation runs locally in your browser — sensitive figures such as loan amounts and rates never leave your device, making it safe to experiment repeatedly before a purchase decision.
Early Repayment Simulator Guide
Shorten term / Reduce monthly payment
The early repayment simulator helps you assess the financial benefit of partially prepaying your mortgage. When you receive a bonus, have idle cash or want to reduce long-term debt, enter the prepayment amount and the number of months already paid, then choose between “shorten the term” and “reduce the monthly payment.” The tool instantly computes the interest saved, the adjusted monthly payment and the remaining term, giving you quantitative support for your decision. It models the main loan’s principal, rate and method; combined loans are estimated using a weighted average rate.
How to use the mortgage calculator
A home is the largest purchase most people ever make, and the monthly payment, total interest and repayment tempo shape years of cash flow. This tool turns the standard amortization formulas into three simple inputs, giving you a complete, verifiable payment plan in 30 seconds.
Three loan types supported
Commercial loans priced off the LPR or your bank's quoted rate; housing provident fund loans, which usually carry a lower rate but a capped amount; and combined loans, where the commercial and provident portions are computed separately with their own rates and terms, then merged into a single monthly payment — matching what your bank produces.
Equal installment vs equal principal
Equal installment (annuity) keeps your monthly payment flat, with interest dominating the early months. Equal principal repays a fixed slice of principal each month, so total interest is lower but the initial payment is higher. FinCompute shows both side by side so you can compare cash flow and total cost.
Early-repayment simulator
When you have a bonus or spare cash, you can either shorten the term or reduce the monthly payment. Enter the prepayment amount and how many months have elapsed; the calculator instantly shows the interest saved and the months shortened (or the new monthly payment), so you can pick the strategy that fits your goals.
Charts and CSV export
The principal/interest chart reveals how much of each payment is truly interest; the trend line shows how that mix evolves over the life of the loan; the paginated schedule exports to CSV for archiving or for discussions with your bank and family.
Formula reference
Equal-installment monthly payment = P · r(1+r)^n / ((1+r)^n − 1). Equal-principal first-month payment = P/n + P·r, then decreases by P·r/n each month, where P is principal, r is the monthly rate (annual rate ÷ 12) and n is the number of months. For combined loans, the two parts are summed.
FAQ
QWhich repayment method is better, equal installment or equal principal?
Equal principal costs less in total interest but has a much higher first payment. Equal installment keeps monthly payments flat and is easier to budget around. Pick equal installment if you want predictable cash flow, and equal principal if you can front-load larger payments and want to minimize total interest.
QHow are combined loans calculated?
The commercial portion and the provident-fund portion are calculated independently using their own principal, rate and term. Their monthly payments, principal and interest are then added together for each row, producing a schedule that matches a combined-loan bank statement.
QWhen prepaying, should I shorten the term or reduce the monthly payment?
Shortening the term usually saves far more interest, because the principal is paid down faster. Reducing the payment lowers your monthly burden but saves less overall. Choose term reduction if your income is stable and you want to be debt-free sooner.
QWhy is my bank's monthly payment slightly different from the result here?
Differences usually come from (1) using the latest LPR plus spread, (2) the bank's day-count convention (30/360 vs actual days), or (3) the first payment covering a partial month after disbursement. This tool gives the canonical annuity result; banks may round or adjust the first/last installment.
QHow much can I borrow from the housing provident fund?
Caps vary by city. A common pattern is RMB 500k–600k for an individual and RMB 800k–1.2M for a couple, but local rules change frequently. Enter the actual approved amount into the tool and check with your local provident-fund center for the exact cap.
QWhere can I check the current LPR?
The Loan Prime Rate is published monthly (usually on the 20th) by the National Interbank Funding Center, and is reposted by the People's Bank of China and major banks. The tool defaults to 3.85%; replace it with the rate written in your actual loan contract.
QCan I export the amortization schedule?
Yes. Click "Export CSV" on the schedule card to download a file with monthly payment, principal, interest and remaining principal. It opens cleanly in Excel, Numbers or WPS.
QDoes it support second-home rates?
Yes. Just type the actual annual rate shown in your second-home loan contract into the commercial or provident rate field — the calculator uses whatever rate you supply.