{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Input","Calc.&Output"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"項目","数値"]
[null,"初回CFADS",300]
[null,"CFADS劣化率",0.01]
[null,"DSCR",1.4]
[null,"固定金利",4.4999999999999998E-2]
[null,"借入タイミング",2]
[null,"完済タイミング",29]
[null,"tol",{"$f":"10^-6","v":9.9999999999999995E-7}]

{"sheet":"Calc.&Output","index":1,"n_rows":26,"n_cols":48,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Counter",null,{"$f":"+H2+1","v":1},{"$f":"+I2+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,null,null,null,null,null,"借入フラグ",null,{"$f":"(I2=Input!$C8)*1","v":0},{"$f":"(J2=Input!$C8)*1","v":1},{"$f":"(K2=Input!$C8)*1","v":0},{"$f":"(L2=Input!$C8)*1","v":0},{"$f":"(M2=Input!$C8)*1","v":0},{"$f":"(N2=Input!$C8)*1","v":0},{"$f":"(O2=Input!$C8)*1","v":0},{"$f":"(P2=Input!$C8)*1","v":0},{"$f":"(Q2=Input!$C8)*1","v":0},{"$f":"(R2=Input!$C8)*1","v":0},{"$f":"(S2=Input!$C8)*1","v":0},{"$f":"(T2=Input!$C8)*1","v":0},{"$f":"(U2=Input!$C8)*1","v":0},{"$f":"(V2=Input!$C8)*1","v":0},{"$f":"(W2=Input!$C8)*1","v":0},{"$f":"(X2=Input!$C8)*1","v":0},{"$f":"(Y2=Input!$C8)*1","v":0},{"$f":"(Z2=Input!$C8)*1","v":0},{"$f":"(AA2=Input!$C8)*1","v":0},{"$f":"(AB2=Input!$C8)*1","v":0},{"$f":"(AC2=Input!$C8)*1","v":0},{"$f":"(AD2=Input!$C8)*1","v":0},{"$f":"(AE2=Input!$C8)*1","v":0},{"$f":"(AF2=Input!$C8)*1","v":0},{"$f":"(AG2=Input!$C8)*1","v":0},{"$f":"(AH2=Input!$C8)*1","v":0},{"$f":"(AI2=Input!$C8)*1","v":0},{"$f":"(AJ2=Input!$C8)*1","v":0},{"$f":"(AK2=Input!$C8)*1","v":0},{"$f":"(AL2=Input!$C8)*1","v":0},{"$f":"(AM2=Input!$C8)*1","v":0},{"$f":"(AN2=Input!$C8)*1","v":0},{"$f":"(AO2=Input!$C8)*1","v":0},{"$f":"(AP2=Input!$C8)*1","v":0},{"$f":"(AQ2=Input!$C8)*1","v":0},{"$f":"(AR2=Input!$C8)*1","v":0},{"$f":"(AS2=Input!$C8)*1","v":0},{"$f":"(AT2=Input!$C8)*1","v":0},{"$f":"(AU2=Input!$C8)*1","v":0},{"$f":"(AV2=Input!$C8)*1","v":0}]
[null,null,null,null,null,null,"返済フラグ",null,{"$f":"(I2>=Input!$C8)*(I2<=Input!$C9)","v":0},{"$f":"(J2>=Input!$C8)*(J2<=Input!$C9)","v":1},{"$f":"(K2>=Input!$C8)*(K2<=Input!$C9)","v":1},{"$f":"(L2>=Input!$C8)*(L2<=Input!$C9)","v":1},{"$f":"(M2>=Input!$C8)*(M2<=Input!$C9)","v":1},{"$f":"(N2>=Input!$C8)*(N2<=Input!$C9)","v":1},{"$f":"(O2>=Input!$C8)*(O2<=Input!$C9)","v":1},{"$f":"(P2>=Input!$C8)*(P2<=Input!$C9)","v":1},{"$f":"(Q2>=Input!$C8)*(Q2<=Input!$C9)","v":1},{"$f":"(R2>=Input!$C8)*(R2<=Input!$C9)","v":1},{"$f":"(S2>=Input!$C8)*(S2<=Input!$C9)","v":1},{"$f":"(T2>=Input!$C8)*(T2<=Input!$C9)","v":1},{"$f":"(U2>=Input!$C8)*(U2<=Input!$C9)","v":1},{"$f":"(V2>=Input!$C8)*(V2<=Input!$C9)","v":1},{"$f":"(W2>=Input!$C8)*(W2<=Input!$C9)","v":1},{"$f":"(X2>=Input!$C8)*(X2<=Input!$C9)","v":1},{"$f":"(Y2>=Input!$C8)*(Y2<=Input!$C9)","v":1},{"$f":"(Z2>=Input!$C8)*(Z2<=Input!$C9)","v":1},{"$f":"(AA2>=Input!$C8)*(AA2<=Input!$C9)","v":1},{"$f":"(AB2>=Input!$C8)*(AB2<=Input!$C9)","v":1},{"$f":"(AC2>=Input!$C8)*(AC2<=Input!$C9)","v":1},{"$f":"(AD2>=Input!$C8)*(AD2<=Input!$C9)","v":1},{"$f":"(AE2>=Input!$C8)*(AE2<=Input!$C9)","v":1},{"$f":"(AF2>=Input!$C8)*(AF2<=Input!$C9)","v":1},{"$f":"(AG2>=Input!$C8)*(AG2<=Input!$C9)","v":1},{"$f":"(AH2>=Input!$C8)*(AH2<=Input!$C9)","v":1},{"$f":"(AI2>=Input!$C8)*(AI2<=Input!$C9)","v":1},{"$f":"(AJ2>=Input!$C8)*(AJ2<=Input!$C9)","v":1},{"$f":"(AK2>=Input!$C8)*(AK2<=Input!$C9)","v":1},{"$f":"(AL2>=Input!$C8)*(AL2<=Input!$C9)","v":0},{"$f":"(AM2>=Input!$C8)*(AM2<=Input!$C9)","v":0},{"$f":"(AN2>=Input!$C8)*(AN2<=Input!$C9)","v":0},{"$f":"(AO2>=Input!$C8)*(AO2<=Input!$C9)","v":0},{"$f":"(AP2>=Input!$C8)*(AP2<=Input!$C9)","v":0},{"$f":"(AQ2>=Input!$C8)*(AQ2<=Input!$C9)","v":0},{"$f":"(AR2>=Input!$C8)*(AR2<=Input!$C9)","v":0},{"$f":"(AS2>=Input!$C8)*(AS2<=Input!$C9)","v":0},{"$f":"(AT2>=Input!$C8)*(AT2<=Input!$C9)","v":0},{"$f":"(AU2>=Input!$C8)*(AU2<=Input!$C9)","v":0},{"$f":"(AV2>=Input!$C8)*(AV2<=Input!$C9)","v":0}]
[null,"マクロで用いるセルの名前",null,"項目","計算式"]
[]
[]
[]
[null,null,null,"CFADS","所与",null,{"$f":"SUM(I9:AV9)","v":9660},null,{"$f":"Input!$C$4*(1-Input!$C$5*(I2-1))","v":300},{"$f":"Input!$C$4*(1-Input!$C$5*(J2-1))","v":297},{"$f":"Input!$C$4*(1-Input!$C$5*(K2-1))","v":294},{"$f":"Input!$C$4*(1-Input!$C$5*(L2-1))","v":291},{"$f":"Input!$C$4*(1-Input!$C$5*(M2-1))","v":288},{"$f":"Input!$C$4*(1-Input!$C$5*(N2-1))","v":285},{"$f":"Input!$C$4*(1-Input!$C$5*(O2-1))","v":282},{"$f":"Input!$C$4*(1-Input!$C$5*(P2-1))","v":279},{"$f":"Input!$C$4*(1-Input!$C$5*(Q2-1))","v":276},{"$f":"Input!$C$4*(1-Input!$C$5*(R2-1))","v":273},{"$f":"Input!$C$4*(1-Input!$C$5*(S2-1))","v":270},{"$f":"Input!$C$4*(1-Input!$C$5*(T2-1))","v":267},{"$f":"Input!$C$4*(1-Input!$C$5*(U2-1))","v":264},{"$f":"Input!$C$4*(1-Input!$C$5*(V2-1))","v":261},{"$f":"Input!$C$4*(1-Input!$C$5*(W2-1))","v":258},{"$f":"Input!$C$4*(1-Input!$C$5*(X2-1))","v":255},{"$f":"Input!$C$4*(1-Input!$C$5*(Y2-1))","v":252},{"$f":"Input!$C$4*(1-Input!$C$5*(Z2-1))","v":249},{"$f":"Input!$C$4*(1-Input!$C$5*(AA2-1))","v":246.00000000000003},{"$f":"Input!$C$4*(1-Input!$C$5*(AB2-1))","v":243.00000000000003},{"$f":"Input!$C$4*(1-Input!$C$5*(AC2-1))","v":240},{"$f":"Input!$C$4*(1-Input!$C$5*(AD2-1))","v":237},{"$f":"Input!$C$4*(1-Input!$C$5*(AE2-1))","v":234},{"$f":"Input!$C$4*(1-Input!$C$5*(AF2-1))","v":231},{"$f":"Input!$C$4*(1-Input!$C$5*(AG2-1))","v":228},{"$f":"Input!$C$4*(1-Input!$C$5*(AH2-1))","v":225},{"$f":"Input!$C$4*(1-Input!$C$5*(AI2-1))","v":222},{"$f":"Input!$C$4*(1-Input!$C$5*(AJ2-1))","v":219},{"$f":"Input!$C$4*(1-Input!$C$5*(AK2-1))","v":216},{"$f":"Input!$C$4*(1-Input!$C$5*(AL2-1))","v":213},{"$f":"Input!$C$4*(1-Input!$C$5*(AM2-1))","v":210},{"$f":"Input!$C$4*(1-Input!$C$5*(AN2-1))","v":206.99999999999997},{"$f":"Input!$C$4*(1-Input!$C$5*(AO2-1))","v":203.99999999999997},{"$f":"Input!$C$4*(1-Input!$C$5*(AP2-1))","v":200.99999999999997},{"$f":"Input!$C$4*(1-Input!$C$5*(AQ2-1))","v":197.99999999999997},{"$f":"Input!$C$4*(1-Input!$C$5*(AR2-1))","v":194.99999999999997},{"$f":"Input!$C$4*(1-Input!$C$5*(AS2-1))","v":192},{"$f":"Input!$C$4*(1-Input!$C$5*(AT2-1))","v":189},{"$f":"Input!$C$4*(1-Input!$C$5*(AU2-1))","v":186},{"$f":"Input!$C$4*(1-Input!$C$5*(AV2-1))","v":183}]
[null,null,null,"DSCR","所与",null,{"$f":"Input!C6","v":1.4},null,{"$f":"$G10","v":1.4},1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4]
[null,null,"⓪","TargetDS","自動計算",null,{"$f":"SUM(I11:AV11)","v":-5130},null,{"$f":"-I9/I10*I4","v":0},-212.14285714285717,-210,-207.85714285714286,-205.71428571428572,-203.57142857142858,-201.42857142857144,-199.28571428571431,-197.14285714285717,-195,-192.85714285714286,-190.71428571428572,-188.57142857142858,-186.42857142857144,-184.28571428571431,-182.14285714285717,-180,-177.85714285714286,-175.71428571428575,-173.57142857142861,-171.42857142857144,-169.28571428571431,-167.14285714285717,-165,-162.85714285714286,-160.71428571428572,-158.57142857142858,-156.42857142857144,-154.28571428571431,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"期首元本","自動計算　Σ①",null,null,null,{"$f":"H16","v":0},0,4917.8571428571431,4707.8571428571431,4500,4294.2857142857147,4090.7142857142862,3889.2857142857147,3690.0000000000005,3492.8571428571431,3297.8571428571431,3105.0000000000005,2914.2857142857147,2725.7142857142862,2539.2857142857147,2355.0000000000005,2172.8571428571431,1992.8571428571431,1815.0000000000002,1639.2857142857144,1465.7142857142858,1294.2857142857142,1125,957.85714285714289,792.85714285714289,630,469.28571428571428,310.71428571428567,154.28571428571422,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"借入　期首実行","自動計算",null,null,null,{"$f":"-$G15*I3","v":0},5130,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"pasted_repayment（I列~AV列）","①","元金返済(仮値)","数値入力　⑤をペースト",null,{"$f":"SUMIFS(I15:AV15,I$4:AV$4,1)","v":-5130},null,{"$f":"I11","v":0},{"$f":"J11","v":-212.14285714285717},-210,-207.85714285714286,-205.71428571428572,-203.57142857142858,-201.42857142857144,-199.28571428571431,-197.14285714285717,-195,-192.85714285714286,-190.71428571428572,-188.57142857142858,-186.42857142857144,-184.28571428571431,-182.14285714285717,-180,-177.85714285714286,-175.71428571428575,-173.57142857142861,-171.42857142857144,-169.28571428571431,-167.14285714285717,-165,-162.85714285714286,-160.71428571428572,-158.57142857142858,-156.42857142857144,-154.28571428571431,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"②","期末元本","自動計算　Σ①",null,null,null,{"$f":"IF(ABS(SUM(I13:I15))>tol,SUM(I13:I15),0)","v":0},4917.8571428571431,4707.8571428571431,4500,4294.2857142857147,4090.7142857142862,3889.2857142857147,3690.0000000000005,3492.8571428571431,3297.8571428571431,3105.0000000000005,2914.2857142857147,2725.7142857142862,2539.2857142857147,2355.0000000000005,2172.8571428571431,1992.8571428571431,1815.0000000000002,1639.2857142857144,1465.7142857142858,1294.2857142857142,1125,957.85714285714289,792.85714285714289,630,469.28571428571428,310.71428571428567,154.28571428571422,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"加重平均金利","所与",null,null,null,2.5000000000000001E-2,2.5499999999999998E-2,2.5999999999999999E-2,2.6499999999999999E-2,2.7E-2,2.75E-2,2.8000000000000001E-2,2.8500000000000001E-2,2.9000000000000001E-2,2.9499999999999998E-2,0.03,3.0499999999999999E-2,3.1E-2,3.15E-2,3.2000000000000001E-2,3.2500000000000001E-2,3.3000000000000002E-2,3.3500000000000002E-2,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,"③","利息(期主・期末平均基準)","自動計算　②*金利",null,{"$f":"SUMIFS(I19:AV19,I$4:AV$4,1)","v":-1707.9476785714287},null,{"$f":"-(I13+I16)/2*I18","v":0},-62.702678571428571,-125.13428571428571,-122.00410714285714,-118.72285714285714,-115.29375,-111.72000000000001,-108.00482142857145,-104.15142857142858,-100.16303571428571,-96.042857142857144,-91.794107142857158,-87.420000000000016,-82.923750000000013,-78.308571428571454,-73.577678571428578,-68.734285714285733,-63.781607142857148,-17.271428571428572,-15.525,-13.8,-12.096428571428572,-10.414285714285716,-8.7535714285714299,-7.1142857142857148,-5.496428571428571,-3.9,-2.3249999999999993,-0.77142857142857113,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"④","DS(仮値)","自動計算　①＋③",null,{"$f":"SUMIFS(I20:AV20,I$4:AV$4,1)","v":-6837.9476785714305},null,{"$f":"I19+I15","v":0},-274.84553571428575,-335.13428571428574,-329.86124999999998,-324.43714285714287,-318.8651785714286,-313.14857142857147,-307.29053571428574,-301.29428571428576,-295.16303571428568,-288.89999999999998,-282.50839285714289,-275.99142857142863,-269.35232142857149,-262.59428571428577,-255.72053571428575,-248.73428571428573,-241.63875000000002,-192.98571428571432,-189.09642857142862,-185.22857142857146,-181.38214285714287,-177.55714285714288,-173.75357142857143,-169.97142857142859,-166.21071428571429,-162.47142857142859,-158.75357142857143,-155.05714285714288,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"⑤","dif","自動計算　⓪-④",null,{"$f":"SUM(I22:AV22)","v":1707.9476785714289},null,{"$f":"I11-I20","v":0},{"$f":"J11-J20","v":62.702678571428578},125.13428571428574,122.00410714285712,118.72285714285715,115.29375000000002,111.72000000000003,108.00482142857143,104.1514285714286,100.16303571428568,96.042857142857116,91.794107142857172,87.420000000000044,82.923750000000041,78.308571428571469,73.577678571428578,68.734285714285733,63.781607142857155,17.271428571428572,15.525000000000006,13.800000000000011,12.096428571428561,10.414285714285711,8.7535714285714334,7.1142857142857281,5.4964285714285666,3.9000000000000057,2.3249999999999886,0.77142857142857224,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"tol(所与)",{"$f":"tol","v":9.9999999999999995E-7}]
[null,"judge(G列)","⑤","judge","自動計算　abs(⑤)<tol",null,{"$f":"AND(I24:AV24)","v":false},null,{"$f":"(0<=I22)*(I22<=tol)=1","v":true},{"$f":"(0<=J22)*(J22<=tol)=1","v":false},{"$f":"(0<=K22)*(K22<=tol)=1","v":false},{"$f":"(0<=L22)*(L22<=tol)=1","v":false},{"$f":"(0<=M22)*(M22<=tol)=1","v":false},{"$f":"(0<=N22)*(N22<=tol)=1","v":false},{"$f":"(0<=O22)*(O22<=tol)=1","v":false},{"$f":"(0<=P22)*(P22<=tol)=1","v":false},{"$f":"(0<=Q22)*(Q22<=tol)=1","v":false},{"$f":"(0<=R22)*(R22<=tol)=1","v":false},{"$f":"(0<=S22)*(S22<=tol)=1","v":false},{"$f":"(0<=T22)*(T22<=tol)=1","v":false},{"$f":"(0<=U22)*(U22<=tol)=1","v":false},{"$f":"(0<=V22)*(V22<=tol)=1","v":false},{"$f":"(0<=W22)*(W22<=tol)=1","v":false},{"$f":"(0<=X22)*(X22<=tol)=1","v":false},{"$f":"(0<=Y22)*(Y22<=tol)=1","v":false},{"$f":"(0<=Z22)*(Z22<=tol)=1","v":false},{"$f":"(0<=AA22)*(AA22<=tol)=1","v":false},{"$f":"(0<=AB22)*(AB22<=tol)=1","v":false},{"$f":"(0<=AC22)*(AC22<=tol)=1","v":false},{"$f":"(0<=AD22)*(AD22<=tol)=1","v":false},{"$f":"(0<=AE22)*(AE22<=tol)=1","v":false},{"$f":"(0<=AF22)*(AF22<=tol)=1","v":false},{"$f":"(0<=AG22)*(AG22<=tol)=1","v":false},{"$f":"(0<=AH22)*(AH22<=tol)=1","v":false},{"$f":"(0<=AI22)*(AI22<=tol)=1","v":false},{"$f":"(0<=AJ22)*(AJ22<=tol)=1","v":false},{"$f":"(0<=AK22)*(AK22<=tol)=1","v":false},{"$f":"(0<=AL22)*(AL22<=tol)=1","v":true},{"$f":"(0<=AM22)*(AM22<=tol)=1","v":true},{"$f":"(0<=AN22)*(AN22<=tol)=1","v":true},{"$f":"(0<=AO22)*(AO22<=tol)=1","v":true},{"$f":"(0<=AP22)*(AP22<=tol)=1","v":true},{"$f":"(0<=AQ22)*(AQ22<=tol)=1","v":true},{"$f":"(0<=AR22)*(AR22<=tol)=1","v":true},{"$f":"(0<=AS22)*(AS22<=tol)=1","v":true},{"$f":"(0<=AT22)*(AT22<=tol)=1","v":true},{"$f":"(0<=AU22)*(AU22<=tol)=1","v":true},{"$f":"(0<=AV22)*(AV22<=tol)=1","v":true}]
[]
[null,"caluculated_repayment（I列~AV列）","⑥","元金返済(修正値)","自動計算　⓪+③",null,{"$f":"SUMIFS(I26:AV26,I$4:AV$4,1)","v":-3422.0523214285713},null,{"$f":"(I11-I19)","v":0},{"$f":"(J11-J19)","v":-149.44017857142859},{"$f":"(K11-K19)","v":-84.86571428571429},-85.853035714285724,-86.991428571428585,-88.277678571428581,-89.708571428571432,-91.280892857142859,-92.991428571428585,-94.836964285714288,-96.814285714285717,-98.920178571428565,-101.15142857142857,-103.50482142857143,-105.97714285714285,-108.56517857142859,-111.26571428571427,-114.07553571428571,-158.44285714285718,-158.04642857142861,-157.62857142857143,-157.18928571428575,-156.72857142857146,-156.24642857142857,-155.74285714285713,-155.21785714285716,-154.67142857142858,-154.10357142857146,-153.51428571428573,0,0,0,{"$f":"(AO11-AO19)","v":0},0,0,0,0,0,0,0]