{"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/10/1"]
[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(Rate/12,Period*12,-Principal),2),\"\"),\"\")","v":{"v":83.58,"d":"¥83.58"}}]
[null,"毎月の合計返済額",{"$f":"IFERROR(IF(AND(MonthlyPayment>0,支払までの年数>0),支払までの年数*12*MonthlyPayment,\"\"),\"\")","v":{"v":5014.8,"d":"¥5,014.80"}}]
[null,"合計支払済み額",{"$f":"IFERROR(IF(AND(MonthlyPayment>0,支払までの年数>0),TotalMonthlyPayments+BalloonPayment,\"\"),\"\")","v":{"v":12594.464455242689,"d":"¥12,594.46"}}]
[null,"総利息",{"$f":"IFERROR(IF(OR(TotalAmountPaid>0,支払までの年数>0),TotalAmountPaid-Principal,\"\"),\"\")","v":{"v":2594.464455242689,"d":"¥2,594.46"}}]
[null,"バルーン ペイメント",{"$f":"IFERROR(IF(AND(SUM(Assumptions2)>0,SUM(MonthlyPayment)>0),PV(Rate/12,(Period-支払までの年数)*12,-MonthlyPayment),\"\"),\"\")","v":{"v":7579.664455242689,"d":"¥7,579.66"}}]