Mainland mortgage calculator

Commercial loan monthly payment and repayment schedule.

Inputs

Mode

Loan amountHome area

Loan amount

10k CNY

Loan term

Annual rate

First repayment date

Total loanCN¥1,000,000.00

Result

Equal installment monthlyCN¥5,307.27

First paymentCN¥6,861.11

Principal totalCN¥1,000,000.00

Equal installment

Interest savedCN¥173,574.52

First month diffCN¥1,553.84

Last month diffCN¥2,518.15

First 12 periods

Date	Payment	Principal	Interest	Balance
2020-01	CN¥5,307.27	CN¥1,223.93	CN¥4,083.33	CN¥998,776.07
2020-02	CN¥5,307.27	CN¥1,228.93	CN¥4,078.34	CN¥997,547.13
2020-03	CN¥5,307.27	CN¥1,233.95	CN¥4,073.32	CN¥996,313.18
2020-04	CN¥5,307.27	CN¥1,238.99	CN¥4,068.28	CN¥995,074.20
2020-05	CN¥5,307.27	CN¥1,244.05	CN¥4,063.22	CN¥993,830.15
2020-06	CN¥5,307.27	CN¥1,249.13	CN¥4,058.14	CN¥992,581.02
2020-07	CN¥5,307.27	CN¥1,254.23	CN¥4,053.04	CN¥991,326.79
2020-08	CN¥5,307.27	CN¥1,259.35	CN¥4,047.92	CN¥990,067.44
2020-09	CN¥5,307.27	CN¥1,264.49	CN¥4,042.78	CN¥988,802.95
2020-10	CN¥5,307.27	CN¥1,269.66	CN¥4,037.61	CN¥987,533.30
2020-11	CN¥5,307.27	CN¥1,274.84	CN¥4,032.43	CN¥986,258.46
2020-12	CN¥5,307.27	CN¥1,280.05	CN¥4,027.22	CN¥984,978.41

Date	Payment	Principal	Interest	Balance
2020-01	CN¥6,861.11	CN¥2,777.78	CN¥4,083.33	CN¥997,222.22
2020-02	CN¥6,849.77	CN¥2,777.78	CN¥4,071.99	CN¥994,444.44
2020-03	CN¥6,838.43	CN¥2,777.78	CN¥4,060.65	CN¥991,666.67
2020-04	CN¥6,827.08	CN¥2,777.78	CN¥4,049.31	CN¥988,888.89
2020-05	CN¥6,815.74	CN¥2,777.78	CN¥4,037.96	CN¥986,111.11
2020-06	CN¥6,804.40	CN¥2,777.78	CN¥4,026.62	CN¥983,333.33
2020-07	CN¥6,793.06	CN¥2,777.78	CN¥4,015.28	CN¥980,555.56
2020-08	CN¥6,781.71	CN¥2,777.78	CN¥4,003.94	CN¥977,777.78
2020-09	CN¥6,770.37	CN¥2,777.78	CN¥3,992.59	CN¥975,000.00
2020-10	CN¥6,759.03	CN¥2,777.78	CN¥3,981.25	CN¥972,222.22
2020-11	CN¥6,747.69	CN¥2,777.78	CN¥3,969.91	CN¥969,444.44
2020-12	CN¥6,736.34	CN¥2,777.78	CN¥3,958.56	CN¥966,666.67