EXCEL模板-房屋按揭计算表

房屋按揭计算表格模板

项目方案1方案2方案3方案4

房款总额550000330000160000200000绿色区域数据可修改首付几成20%20%20%20%

首期付款110000660003200040000

贷款440000264000128000160000

贷款利率 5.58% 5.58% 5.58% 5.31%国家利率上周已经调整付款年限1510105

契税1.5%8250495024003000

购房费用3500350035003500

每月还款3,597.152,862.261,387.763,028.77

利息总额207,486.4079,471.2738,531.5321,726.30

总还款647,486.40343,471.27166,531.53181,726.30

总付款769,236.40417,921.27204,431.53228,226.30

蓝色数据可更改

绿色区域数据可修改

率上周已经调整