{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["气球型贷款"],"not_rendered":{"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"气球型贷款","index":0,"n_rows":12,"n_cols":3,"rows_kept":12}
["                                                                                                                                                                                                                                                                                                                                                            ","气球型贷款","XX 年 1 月 10 日"]
[null,"假设"]
[null,"贷款本金",{"v":10000,"d":"¥10,000.00"}]
[null,"年利率",{"v":0.0585,"d":"5.85%"}]
[null,"摊还期（以年计）",15]
[null,"至期末整付的年限",5]
[null,"关键财务数据"]
[null,"每月还款",{"$f":"IFERROR(IF(SUM(假设)>0,ROUND(PMT(利率/12,时期*12,-本金),2),\"\"),\"\")","v":{"v":83.58,"d":"¥83.58"}}]
[null,"每月还款总计",{"$f":"IFERROR(IF(AND(每月还款>0,YearsUntilPayment>0),YearsUntilPayment*12*每月还款,\"\"),\"\")","v":{"v":5014.8,"d":"¥5,014.80"}}]
[null,"已还款总额",{"$f":"IFERROR(IF(AND(每月还款>0,YearsUntilPayment>0),每月还款总计+期末整付,\"\"),\"\")","v":{"v":12594.464455242689,"d":"¥12,594.46"}}]
[null,"总利息",{"$f":"IFERROR(IF(OR(已还款总额>0,YearsUntilPayment>0),已还款总额-本金,\"\"),\"\")","v":{"v":2594.464455242689,"d":"¥2,594.46"}}]
[null,"期末整付",{"v":7579.664455242689,"d":"¥7,579.66"}]