Mortgage calculator
Monthly payments, total interest and a full schedule for commercial, housing provident fund or combined loans, with equal payments or equal principal.
Loading…
Runs in this page in your browser; nothing is uploaded.
About this tool
Work out the monthly payment, total interest and total repaid for a commercial loan, a housing provident fund loan or a combined loan. Use it before taking out a home loan to compare equal monthly payments (等额本息) with equal principal (等额本金), or to see how the loan term changes what you pay each month.
Results update as you type and come with a month-by-month schedule of payment, principal, interest and balance that you can download as CSV. Enter the rate from your loan offer, since the defaults are only examples. The figures are estimates, and the calculation runs in your browser.
How to use it
- Choose “Commercial loan”, “Provident fund loan” or “Combined”.
- Enter the amount in units of 10,000 yuan and the yearly rate in percent. A combined loan needs both the commercial and the provident fund amount and rate.
- Pick the “Years”, from 1 to 30, and the “Repayment” method: “Equal monthly payments” or “Equal principal”.
- Read the “Monthly payment” (“First month / last month” for equal principal), “Total interest” and “Total repaid”, and select “Download the schedule (CSV)” to keep the full table.
Common questions
What is the difference between equal monthly payments and equal principal?
With equal monthly payments you pay the same amount every month. With equal principal you repay the same principal each month plus interest on the balance still owed, so the first payment is the highest and the page shows the first and last payments and how much they fall each month. Switch between the two to compare the total interest.
How is the monthly payment calculated?
The monthly rate r is the yearly rate divided by 12, and n is the number of months. For equal monthly payments, payment = loan × r × (1 + r)^n ÷ ((1 + r)^n − 1); for equal principal, each month repays loan ÷ n plus the balance × r.
Are the amounts rounded?
The calculation does not round month by month; amounts are shown and exported with two decimal places. Results may differ slightly from your bank’s repayment schedule, which is the one that counts.
Does it handle prepayment or a change in the interest rate?
No. It assumes one fixed yearly rate for the whole term and does not model prepayment (提前还款).
How is a combined loan calculated?
The commercial and provident fund parts are calculated separately, each with its own amount and rate but the same term and repayment method, and then added together month by month.
Related tools
Age calculator
Work out exact age, the Chinese nominal age (虚岁), days lived, the next birthday, star sign and zodiac animal from a date of birth.
BMI calculator
Body mass index from height and weight, with the Chinese and WHO ranges and the healthy weight for your height.
Unit converter
Convert data size, length, area, volume, weight, time, temperature, pressure, energy, power and speed between units, including Chinese units such as 斤 and 亩.
RMB amount in Chinese capitals
Write amounts in Chinese accounting capitals such as 壹仟零伍元整, or read capitals back into numbers, line by line.
Big number calculator
Add, subtract, multiply and divide integers of any size in binary, octal, decimal or hex, compute a^b mod n, and divide repeatedly until the quotient is 0.
Calculator
Standard, scientific and programmer calculator: exact decimal arithmetic, trigonometry in degrees or radians, and hexadecimal, octal and binary with bitwise operations.