{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["貸款計算機"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"貸款計算機","index":0,"n_rows":22,"n_cols":13,"rows_kept":22,"merged":[[1,1,1,3],[1,6,2,8],[1,11,2,12],[2,1,2,3],[6,5,6,6],[7,5,7,6],[10,2,10,5],[10,6,10,8],[10,9,10,12],[18,2,18,12]]}
[]
[null,"大學助學貸款",{"$nulls":4},{"v":1500000,"d":"NT$1,500,000"},{"$nulls":4},{"v":40673,"d":"4067300.00%"}]
[null,"計算機 "]
[]
[null,"建議每月學生貸款返還總金額不超過第一年年薪的 8%。"]
[]
[null,null,"您目前每月還款合計金額：",null,null,{"$f":"CollegeLoans[[#Totals],[目前每月還款金額]]","v":{"v":9857.57721781765,"d":"NT$9,857.58"}},null,null,"您的預定每月還款合計金額：",{"$nulls":3},{"$f":"CollegeLoans[[#Totals],[預定還款金額]]","v":{"v":9857.57721781765,"d":"NT$9,857.58"}}]
[null,null,"佔每月收入百分比：",null,null,{"$f":"CollegeLoans[[#Totals],[目前每月還款金額]]/EstimatedMonthlySalary","v":{"v":0.0788606177425412,"d":"7.89%"}},null,null,"  佔每月收入百分比：",{"$nulls":3},{"$f":"CollegeLoans[[#Totals],[預定還款金額]]/EstimatedMonthlySalary","v":{"v":0.0788606177425412,"d":"7.89%"}}]
[]
[]
[null,null,"一般貸款詳細資料",{"$nulls":3},"貸款償還資料",null,null,"還款詳細資料"]
[null,null,"貸款編號","貸方","貸款金額","年\n利率","開始日期","期間 (年)","結束日期","目前每月還款金額","總\n利息","預定還款金額","每年\n還款金額"]
[null,null,"10998M88","貸方 1",{"v":300000,"d":"NT$300,000.00"},{"v":0.05,"d":"5.00%"},{"v":40634,"d":"4063400.00%"},10,{"$f":"IF(AND(CollegeLoans[[#This Row],[開始日期]]>0,CollegeLoans[[#This Row],[期間 (年)]]>0),EDATE(CollegeLoans[[#This Row],[開始日期]],CollegeLoans[[#This Row],[期間 (年)]]*12),\"\")","v":{"v":44287,"d":"4428700.00%"}},{"$f":"IF(AND(LoanStartLToday,COUNT(CollegeLoans[[#This Row],[貸款金額]:[期間 (年)]])=4,CollegeLoans[[#This Row],[開始日期]]<TODAY()),PMT(CollegeLoans[[#This Row],[年\n利率]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[貸款金額]],0,0),\"\")","v":{"v":3181.965457172257,"d":"NT$3,181.97"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[預定還款金額]]*(CollegeLoans[[#This Row],[期間 (年)]]*12))-CollegeLoans[[#This Row],[貸款金額]],\"\")","v":{"v":81835.85486067086,"d":"NT$81,835.85"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[貸款金額]:[期間 (年)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[年\n利率]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[貸款金額]],0,0))","v":{"v":3181.965457172257,"d":"NT$3,181.97"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[預定還款金額]]*12,\"\")","v":{"v":38183.58548606709,"d":"NT$38,183.59"}}]
[null,null,"20987N87","貸方 2",{"v":240000,"d":"NT$240,000.00"},{"v":0.05,"d":"5.00%"},{"v":40664,"d":"4066400.00%"},10,{"$f":"IF(AND(CollegeLoans[[#This Row],[開始日期]]>0,CollegeLoans[[#This Row],[期間 (年)]]>0),EDATE(CollegeLoans[[#This Row],[開始日期]],CollegeLoans[[#This Row],[期間 (年)]]*12),\"\")","v":{"v":44317,"d":"4431700.00%"}},{"$f":"IF(AND(LoanStartLToday,COUNT(CollegeLoans[[#This Row],[貸款金額]:[期間 (年)]])=4,CollegeLoans[[#This Row],[開始日期]]<TODAY()),PMT(CollegeLoans[[#This Row],[年\n利率]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[貸款金額]],0,0),\"\")","v":{"v":2545.5723657378057,"d":"NT$2,545.57"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[預定還款金額]]*(CollegeLoans[[#This Row],[期間 (年)]]*12))-CollegeLoans[[#This Row],[貸款金額]],\"\")","v":{"v":65468.6838885367,"d":"NT$65,468.68"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[貸款金額]:[期間 (年)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[年\n利率]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[貸款金額]],0,0))","v":{"v":2545.5723657378057,"d":"NT$2,545.57"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[預定還款金額]]*12,\"\")","v":{"v":30546.86838885367,"d":"NT$30,546.87"}}]
[null,null,"36785LM","貸方 3",{"v":180000,"d":"NT$180,000.00"},{"v":0.045,"d":"4.50%"},{"v":40969,"d":"4096900.00%"},10,{"$f":"IF(AND(CollegeLoans[[#This Row],[開始日期]]>0,CollegeLoans[[#This Row],[期間 (年)]]>0),EDATE(CollegeLoans[[#This Row],[開始日期]],CollegeLoans[[#This Row],[期間 (年)]]*12),\"\")","v":{"v":44621,"d":"4462100.00%"}},{"$f":"IF(AND(LoanStartLToday,COUNT(CollegeLoans[[#This Row],[貸款金額]:[期間 (年)]])=4,CollegeLoans[[#This Row],[開始日期]]<TODAY()),PMT(CollegeLoans[[#This Row],[年\n利率]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[貸款金額]],0,0),\"\")","v":{"v":1865.4913576262754,"d":"NT$1,865.49"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[預定還款金額]]*(CollegeLoans[[#This Row],[期間 (年)]]*12))-CollegeLoans[[#This Row],[貸款金額]],\"\")","v":{"v":43858.96291515304,"d":"NT$43,858.96"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[貸款金額]:[期間 (年)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[年\n利率]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[貸款金額]],0,0))","v":{"v":1865.4913576262754,"d":"NT$1,865.49"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[預定還款金額]]*12,\"\")","v":{"v":22385.896291515306,"d":"NT$22,385.90"}}]
[null,null,"765R43","貸方 4",{"v":120000,"d":"NT$120,000.00"},{"v":0.05,"d":"5.00%"},{"v":41030,"d":"4103000.00%"},5,{"$f":"IF(AND(CollegeLoans[[#This Row],[開始日期]]>0,CollegeLoans[[#This Row],[期間 (年)]]>0),EDATE(CollegeLoans[[#This Row],[開始日期]],CollegeLoans[[#This Row],[期間 (年)]]*12),\"\")","v":{"v":42856,"d":"4285600.00%"}},{"$f":"IF(AND(LoanStartLToday,COUNT(CollegeLoans[[#This Row],[貸款金額]:[期間 (年)]])=4,CollegeLoans[[#This Row],[開始日期]]<TODAY()),PMT(CollegeLoans[[#This Row],[年\n利率]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[貸款金額]],0,0),\"\")","v":{"v":2264.548037281312,"d":"NT$2,264.55"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[預定還款金額]]*(CollegeLoans[[#This Row],[期間 (年)]]*12))-CollegeLoans[[#This Row],[貸款金額]],\"\")","v":{"v":15872.882236878737,"d":"NT$15,872.88"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[貸款金額]:[期間 (年)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[年\n利率]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[貸款金額]],0,0))","v":{"v":2264.548037281312,"d":"NT$2,264.55"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[預定還款金額]]*12,\"\")","v":{"v":27174.576447375744,"d":"NT$27,174.58"}}]
[null,null,"合計",null,{"$f":"SUBTOTAL(109,CollegeLoans[貸款金額])","v":{"v":840000,"d":"NT$840,000.00"}},{"$nulls":4},{"$f":"SUBTOTAL(109,CollegeLoans[目前每月還款金額])","v":{"v":9857.57721781765,"d":"NT$9,857.58"}},{"$f":"SUBTOTAL(109,CollegeLoans[總\n利息])","v":{"v":207036.38390123934,"d":"NT$207,036.38"}},{"$f":"SUBTOTAL(109,CollegeLoans[預定還款金額])","v":{"v":9857.57721781765,"d":"NT$9,857.58"}},{"$f":"SUBTOTAL(109,CollegeLoans[每年\n還款金額])","v":{"v":118290.92661381181,"d":"NT$118,290.93"}}]
[null,null,"平均",null,{"$f":"AVERAGE(CollegeLoans[貸款金額])","v":{"v":210000,"d":"NT$210,000.00"}},{"$f":"AVERAGE(CollegeLoans[年\n利率])","v":{"v":0.04875,"d":"4.88%"}},{"$nulls":4},{"$f":"AVERAGE(CollegeLoans[總\n利息])","v":{"v":51759.095975309836,"d":"NT$51,759.10"}},null,{"$f":"AVERAGE(CollegeLoans[每年\n還款金額])","v":{"v":29572.731653452953,"d":"NT$29,572.73"}}]
[]
[{"$nulls":10},"合併貸款償還總額：",null,{"$f":"CollegeLoans[[#Totals],[貸款金額]]+CollegeLoans[[#Totals],[總\n利息]]","v":{"v":1047036.3839012394,"d":"NT$1,047,036.38"}}]
[]
[{"$nulls":10},"預估畢業後月收入：",null,{"$f":"(EstimatedAnnualSalary/12)","v":{"v":125000,"d":"NT$125,000.00"}}]