Sunday, July 13, 2008

如何自动生成月分期付款表格?

如果您想知道您付款的详细情况,例如,在每个月的付款中,有多少用来付本金,有多少用来付利息,3年或5年后,您还有多少剩余贷款,请用以下表格。

请将贷款总额,年利息,和分期付款年限变换成您贷款的实际情况,您就可得到您贷款的分期付款细节表格。(每月付款数目自动算出,不必输入)。

注意:本表为您方便而建, 适合于加拿大房屋贷款, 但本作者不负任何负面责任。

The linked spreadsheet below is designed to help you calculate the monthly payment, and its corresponding amortization table.

After inputting the mortgage amount, annual interest rate, and amortization in years, you will be able to get a detailed amortization table of your mortgage.

To the best knowledge of the author, this table is accurate and mathematically correct. But it is only a reference and the author is not liable for any negative consequences.

注意,表格绿色部分会自动生成,请不要填写。您仅需输入3个变量。

请放心点击下面网站链接,您就可使用本表。
(Please click the link below to access the amortization table).


http://public.sheet.zoho.com/public/yanli.song2/monthlyamortizationtable-2