{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["ローン計算シート"],"not_rendered":{"defined_names":9},"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,10,6,11],[7,10,7,11],[10,2,10,5],[10,6,10,8],[10,9,10,12],[18,2,18,12]]}
[]
[null,"大学ローン",{"$nulls":4},{"v":5000000,"d":"¥5,000,000"},{"$nulls":4},{"v":40673,"d":"4067300.00%"}]
[null,"計算シート"]
[]
[null," 毎月の学生ローン返済額合計が初年度の年収の 8% を超えないようにすることをお勧めします。"]
[]
[null,null,"現在の毎月支払額合計:",null,{"$f":"CollegeLoans[[#Totals],[現在の毎月支払額]]","v":{"v":32858.59072605883,"d":"¥32,859"}},{"$nulls":3},"予定される毎月支払額合計:",null,{"$f":"CollegeLoans[[#Totals],[予定支払額]]","v":{"v":32858.59072605883,"d":"¥32,859"}}]
[null,null,"毎月の収入に対する割合:",null,{"$f":"CollegeLoans[[#Totals],[現在の毎月支払額]]/EstimatedMonthlySalary","v":{"v":0.07886061774254119,"d":"7.89%"}},{"$nulls":3},"毎月の収入に対する割合:",null,{"$f":"CollegeLoans[[#Totals],[予定支払額]]/EstimatedMonthlySalary","v":{"v":0.07886061774254119,"d":"7.89%"}}]
[]
[]
[null,null,"一般ローンの明細",{"$nulls":3},"ローン返済データ",null,null,"支払明細"]
[null,null,"ローン番号","貸主","ローン金額","年利","開始日","期間 (年)","終了日","現在の毎月支払額","利息合計","予定支払額","年間支払額"]
[null,null,"10998M88","貸主 1",{"v":1000000,"d":"¥1,000,000"},{"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],[年利]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[ローン金額]],0,0),\"\")","v":{"v":10606.551523907523,"d":"¥10,607"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[予定支払額]]*(CollegeLoans[[#This Row],[期間 (年)]]*12))-CollegeLoans[[#This Row],[ローン金額]],\"\")","v":{"v":272786.1828689028,"d":"¥272,786"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[ローン金額]:[期間 (年)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[年利]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[ローン金額]],0,0))","v":{"v":10606.551523907523,"d":"¥10,607"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[予定支払額]]*12,\"\")","v":{"v":127278.61828689027,"d":"¥127,279"}}]
[null,null,"20987N87","貸主 2",{"v":800000,"d":"¥800,000"},{"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],[年利]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[ローン金額]],0,0),\"\")","v":{"v":8485.24121912602,"d":"¥8,485"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[予定支払額]]*(CollegeLoans[[#This Row],[期間 (年)]]*12))-CollegeLoans[[#This Row],[ローン金額]],\"\")","v":{"v":218228.94629512227,"d":"¥218,229"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[ローン金額]:[期間 (年)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[年利]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[ローン金額]],0,0))","v":{"v":8485.24121912602,"d":"¥8,485"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[予定支払額]]*12,\"\")","v":{"v":101822.89462951223,"d":"¥101,823"}}]
[null,null,"36785LM","貸主 3",{"v":600000,"d":"¥600,000"},{"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],[年利]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[ローン金額]],0,0),\"\")","v":{"v":6218.304525420918,"d":"¥6,218"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[予定支払額]]*(CollegeLoans[[#This Row],[期間 (年)]]*12))-CollegeLoans[[#This Row],[ローン金額]],\"\")","v":{"v":146196.54305051023,"d":"¥146,197"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[ローン金額]:[期間 (年)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[年利]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[ローン金額]],0,0))","v":{"v":6218.304525420918,"d":"¥6,218"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[予定支払額]]*12,\"\")","v":{"v":74619.65430505102,"d":"¥74,620"}}]
[null,null,"765R43","貸主 4",{"v":400000,"d":"¥400,000"},{"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],[年利]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[ローン金額]],0,0),\"\")","v":{"v":7548.493457604374,"d":"¥7,548"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[予定支払額]]*(CollegeLoans[[#This Row],[期間 (年)]]*12))-CollegeLoans[[#This Row],[ローン金額]],\"\")","v":{"v":52909.607456262456,"d":"¥52,910"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[ローン金額]:[期間 (年)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[年利]]/12,CollegeLoans[[#This Row],[期間 (年)]]*12,-CollegeLoans[[#This Row],[ローン金額]],0,0))","v":{"v":7548.493457604374,"d":"¥7,548"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[予定支払額]]*12,\"\")","v":{"v":90581.92149125249,"d":"¥90,582"}}]
[null,null,"合計",null,{"$f":"SUBTOTAL(109,CollegeLoans[ローン金額])","v":{"v":2800000,"d":"¥2,800,000"}},{"$nulls":4},{"$f":"SUBTOTAL(109,CollegeLoans[現在の毎月支払額])","v":{"v":32858.59072605883,"d":"¥32,859"}},{"$f":"SUBTOTAL(109,CollegeLoans[利息合計])","v":{"v":690121.2796707978,"d":"¥690,121"}},{"$f":"SUBTOTAL(109,CollegeLoans[予定支払額])","v":{"v":32858.59072605883,"d":"¥32,859"}},{"$f":"SUBTOTAL(109,CollegeLoans[年間支払額])","v":{"v":394303.088712706,"d":"¥394,303"}}]
[null,null,"平均",null,{"$f":"AVERAGE(CollegeLoans[ローン金額])","v":{"v":700000,"d":"¥700,000"}},{"$f":"AVERAGE(CollegeLoans[年利])","v":{"v":0.04875,"d":"4.88%"}},{"$nulls":4},{"$f":"AVERAGE(CollegeLoans[利息合計])","v":{"v":172530.31991769944,"d":"¥172,530"}},null,{"$f":"AVERAGE(CollegeLoans[年間支払額])","v":{"v":98575.7721781765,"d":"¥98,576"}}]
[]
[{"$nulls":10},"連結ローン返済額合計:",null,{"$f":"CollegeLoans[[#Totals],[ローン金額]]+CollegeLoans[[#Totals],[利息合計]]","v":{"v":3490121.2796707978,"d":"¥3,490,121"}}]
[]
[{"$nulls":10},"卒業後の推定月収:",null,{"$f":"(EstimatedAnnualSalary/12)","v":{"v":416666.6666666667,"d":"¥416,667"}}]