{"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,"merged":[[1,1,1,2],[6,1,6,2]]}
["                                                                                                                                                                                                                                                                                                                                                            ","期末整付式貸款","日期"]
[null,"假設條件"]
[null,"貸款本金",{"v":10000,"d":"NT$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":"NT$83.58"}}]
[null,"每月還款金額總計",{"$f":"IFERROR(IF(AND(每月還款金額>0,期末整付剩餘年數>0),期末整付剩餘年數*12*每月還款金額,\"\"),\"\")","v":{"v":5014.8,"d":"NT$5,014.80"}}]
[null,"支付金額總計",{"$f":"IFERROR(IF(AND(每月還款金額>0,期末整付剩餘年數>0),每月還款金額總計+期末整付金額,\"\"),\"\")","v":{"v":12594.464455242689,"d":"NT$12,594.46"}}]
[null,"利息總計",{"$f":"IFERROR(IF(OR(支付金額總計>0,期末整付剩餘年數>0),支付金額總計-本金,\"\"),\"\")","v":{"v":2594.464455242689,"d":"NT$2,594.46"}}]
[null,"期末整付金額",{"$f":"IFERROR(IF(AND(SUM(假設條件2)>0,SUM(每月還款金額)>0),PV(利率/12,(週期-期末整付剩餘年數)*12,-每月還款金額),\"\"),\"\")","v":{"v":7579.664455242689,"d":"NT$7,579.66"}}]