{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["抵押计算器","关于"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"抵押计算器","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[0,1,0,6],[2,3,2,6]]}
[null,"抵押还款计算器"]
[{"$nulls":8},"Vertex42.com 提供的抵押计算器"]
[null,"复利计算期",12," 输入 12 表示美国抵押贷款或 2 表示加拿大抵押贷款。",{"$nulls":4},"https://www.vertex42.com/Calculators/mortgage-calculators.html"]
[]
[null,"抵押贷款信息","选项 #1","选项 #2","选项 #3","选项 #4","选项 #5"]
[null,"贷款金额",{"v":175000,"d":"175,000.00"},{"v":200000,"d":"200,000.00"},{"v":225000,"d":"225,000.00"},{"$nulls":3},"← 输入每笔贷款金额"]
[null,"年利率",{"v":0.06,"d":"6.000%"},{"v":0.06,"d":"6.000%"},{"v":0.06,"d":"6.000%"},{"$nulls":3},"← 输入每笔贷款的利率"]
[null,"贷款期限（单位：年）",30,30,30,{"$nulls":3},"← 以年为单位输入贷款期限"]
[]
[null,"还款额"]
[null,"月利率",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",((1+C7/$C$3)^($C$3/12))-1)","v":{"v":0.004999999999999893,"d":"0.500%"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",((1+D7/$C$3)^($C$3/12))-1)","v":{"v":0.004999999999999893,"d":"0.500%"}},{"v":0.004999999999999893,"d":"0.500%"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",((1+F7/$C$3)^($C$3/12))-1)","v":" - "}," - "]
[null,"每月还款 (PI)",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",PMT(C11,C8*12,-C6))","v":{"v":1049.2134190173022,"d":"1,049.21"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",PMT(D11,D8*12,-D6))","v":{"v":1199.1010503054883,"d":"1,199.10"}},{"v":1348.9886815936745,"d":"1,348.99"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",PMT(F11,F8*12,-F6))","v":" - "}," - "]
[null,"每月额外还款",{"$nulls":6},"←（选填）输入每月额外还款"]
[null,"每月总还款",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",C12+C13)","v":{"v":1049.2134190173022,"d":"1,049.21"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",D12+D13)","v":{"v":1199.1010503054883,"d":"1,199.10"}},{"v":1348.9886815936745,"d":"1,348.99"}," - "," - "]
[]
[null,"总计"]
[null,"还款期数",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",NPER(C11,-C14,C6))","v":{"v":360.0000000000001,"d":"360.0"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",NPER(D11,-D14,D6))","v":{"v":359.99999999999994,"d":"360.0"}},{"v":359.99999999999994,"d":"360.0"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",NPER(F11,-F14,F6))","v":" - "}," - "]
[null,"偿还年数",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",C17/12)","v":{"v":30.00000000000001,"d":"30.00"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",D17/12)","v":{"v":29.999999999999996,"d":"30.00"}},{"v":29.999999999999996,"d":"30.00"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",F17/12)","v":" - "}," - "]
[null,"还款总额",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",C17*C14)","v":{"v":377716.83084622887,"d":"377,716.83"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",D17*D14)","v":{"v":431676.3781099757,"d":"431,676.38"}},{"v":485635.92537372274,"d":"485,635.93"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",F17*F14)","v":" - "}," - "]
[null,"支付利息总额",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",C19-C6)","v":{"v":202716.83084622887,"d":"202,716.83"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",D19-D6)","v":{"v":231676.37810997572,"d":"231,676.38"}},{"v":260635.92537372274,"d":"260,635.93"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",F19-F6)","v":" - "}," - "]
[]
[null,"第 N 年时的余额 …",5,5,5,{"$nulls":3},"← 输入要估计余额和所有者权益的年份"]
[null,"产权价值",{"$f":"C6","v":{"v":175000,"d":"175,000.00"}},{"$f":"D6","v":{"v":200000,"d":"200,000.00"}},{"v":225000,"d":"225,000.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"← 输入指定年份的估计产权价值"]
[null,"贷款结欠余额",{"$f":"IF(COUNTA(C6,C7,C8,C22)<4,\" - \",-FV(C11,C22*12,-C14,C6))","v":{"v":162845.1244399341,"d":"162,845.12"}},{"$f":"IF(COUNTA(D6,D7,D8,D22)<4,\" - \",-FV(D11,D22*12,-D14,D6))","v":{"v":186108.71364563896,"d":"186,108.71"}},{"v":209372.30285134388,"d":"209,372.30"}," - "," - "]
[null,"所有者权益",{"$f":"IF(COUNTA(C6,C7,C8,C22,C23)<5,\" - \",C23-C24)","v":{"v":12154.875560065906,"d":"12,154.88"}},{"$f":"IF(COUNTA(D6,D7,D8,D22,D23)<5,\" - \",D23-D24)","v":{"v":13891.286354361044,"d":"13,891.29"}},{"v":15627.697148656123,"d":"15,627.70"}," - "," - "]

{"sheet":"关于","index":1,"n_rows":22,"n_cols":2,"rows_kept":22}
[]
[null,"Vertex42.com 提供的抵押还款计算器"]
[null,"https://www.vertex42.com/Calculators/mortgage-payment-calculator.html"]
[]
[null,"关于此模板"]
[null,"使用 Vertex42.com 提供的这个简单的抵押计算器可计算传统住房抵押贷款的每月本金和利息还款。输入贷款金额、利率、期限和每月额外还款，可比较不同的方案。估计特定年份后的房屋净值和结欠余额。"]
[]
[null,"如何使用此模板"]
[null,"单击下面的链接访问 vertex42.com，了解有关如何使用此模板的更多信息。"]
[null,"如何使用此模板"]
[]
[null,"更多抵押计算器"]
[null,"单击下面的链接访问 vertex42.com 并下载其他抵押计算器。"]
[null,"更多抵押计算器"]
[]
[null,"免责声明"]
[null,"此计算器用于教育目的。计算器不包括四舍五入、费用、未付款项、财产税、保险和作出贷款或房屋买卖决策时可能很重要的其他因素。请咨询合格的专业人员，以便做出财务决策。"]
[]
[null,"关于 Vertex42"]
[null,"Vertex42.com 为企业、家庭和教育提供专业设计的电子表格模板，其中大部分模板可供免费下载。这些集合包括各种日历、规划器和日程安排，以及用于预算、减免债务和分期偿还贷款的个人财务电子表格。"]
[]
[null,"企业可查找发票、时间表、库存跟踪表、财务报表和项目计划模板。教师和学生可查找诸如课程表、成绩簿和出勤表等资源。还可通过用餐规划师、清单和锻炼日志来组织家庭生活。通过来自数千名用户的反馈，每个模板都经过了深入的研究、完善和改进。"]