Download

R23/100)*(1+R41/100))-R89-R90,IF(AND(R83=0,R84=1),(1-Q93-R38*Q94)*Q87*R42/((1+R23/100)*(1+R41/100)),R87))) =IF(S87=0,0,IF(S83=1,R87*S42/((1+S23/100)*(1+S41/100))-S89-S90,IF(AND(S83=0,S84=1),(1-R93-S38*R94)*R87*S42/((1+S23/100)*(1+S41/100)),S87))) =IF(T87=0,0,IF(T83=1,S87*T42/((1+T23/100)*(1+T41/100))-T89-T90,IF(AND(T83=0,T84=1),(1-S93-T38*S94)*S87*T42/((1+T23/100)*(1+T41/100)),T87))) =IF(U87=0,0,IF(U83=1,T87*U42/((1+U23/100)*(1+U41/100))-U89-U90,IF(AND(U83=0,U84=1),(1-T93-U38*T94)*T87*U42/((1+U23/100)*(1+U41/100)),U87))) =IF(V87=0,0,IF(V83=1,U87*V42/((1+V23/100)*(1+V41/100))-V89-V90,IF(AND(V83=0,V84=1),(1-U93-V38*U94)*U87*V42/((1+V23/100)*(1+V41/100)),V87))) =IF(W87=0,0,IF(W83=1,V87*W42/((1+W23/100)*(1+W41/100))-W89-W90,IF(AND(W83=0,W84=1),(1-V93-W38*V94)*V87*W42/((1+W23/100)*(1+W41/100)),W87))) Rolled over long-term debt ='Input data'!C67*$D$87 =IF(E87=0,0,IF(E83=1,E38*D87*D94*E42/((1+E23/100)*(1+E41/100)),IF(AND(E83=0,E84=1),(E38*D87*D94*E42/((1+E23/100)*(1+E41/100)))*(1-ABS(E87-D87*E42/((1+E23/100)*(1+E41/100)))/((E38*D87*D94*E42/((1+E23/100)*(1+E41/100)))+(D93*D87*E42/((1+E23/100)*(1+E41/100))))),0))) =IF(F87=0,0,IF(F83=1,F38*E87*E94*F42/((1+F23/100)*(1+F41/100)),IF(AND(F83=0,F84=1),(F38*E87*E94*F42/((1+F23/100)*(1+F41/100)))*(1-ABS(F87-E87*F42/((1+F23/100)*(1+F41/100)))/((F38*E87*E94*F42/((1+F23/100)*(1+F41/100)))+(E93*E87*F42/((1+F23/100)*(1+F41/100))))),0))) =IF(G87=0,0,IF(G83=1,G38*F87*F94*G42/((1+G23/100)*(1+G41/100)),IF(AND(G83=0,G84=1),(G38*F87*F94*G42/((1+G23/100)*(1+G41/100)))*(1-ABS(G87-F87*G42/((1+G23/100)*(1+G41/100)))/((G38*F87*F94*G42/((1+G23/100)*(1+G41/100)))+(F93*F87*G42/((1+G23/100)*(1+G41/100))))),0))) =IF(H87=0,0,IF(H83=1,H38*G87*G94*H42/((1+H23/100)*(1+H41/100)),IF(AND(H83=0,H84=1),(H38*G87*G94*H42/((1+H23/100)*(1+H41/100)))*(1-ABS(H87-G87*H42/((1+H23/100)*(1+H41/100)))/((H38*G87*G94*H42/((1+H23/100)*(1+H41/100)))+(G93*G87*H42/((1+H23/100)*(1+H41/100))))),0))) =IF(I87=0,0,IF(I83=1,I38*H87*H94*I42/((1+I23/100)*(1+I41/100)),IF(AND(I83=0,I84=1),(I38*H87*H94*I42/((1+I23/100)*(1+I41/100)))*(1-ABS(I87-H87*I42/((1+I23/100)*(1+I41/100)))/((I38*H87*H94*I42/((1+I23/100)*(1+I41/100)))+(H93*H87*I42/((1+I23/100)*(1+I41/100))))),0))) =IF(J87=0,0,IF(J83=1,J38*I87*I94*J42/((1+J23/100)*(1+J41/100)),IF(AND(J83=0,J84=1),(J38*I87*I94*J42/((1+J23/100)*(1+J41/100)))*(1-ABS(J87-I87*J42/((1+J23/100)*(1+J41/100)))/((J38*I87*I94*J42/((1+J23/100)*(1+J41/100)))+(I93*I87*J42/((1+J23/100)*(1+J41/100))))),0))) =IF(K87=0,0,IF(K83=1,K38*J87*J94*K42/((1+K23/100)*(1+K41/100)),IF(AND(K83=0,K84=1),(K38*J87*J94*K42/((1+K23/100)*(1+K41/100)))*(1-ABS(K87-J87*K42/((1+K23/100)*(1+K41/100)))/((K38*J87*J94*K42/((1+K23/100)*(1+K41/100)))+(J93*J87*K42/((1+K23/100)*(1+K41/100))))),0))) =IF(L87=0,0,IF(L83=1,L38*K87*K94*L42/((1+L23/100)*(1+L41/100)),IF(AND(L83=0,L84=1),(L38*K87*K94*L42/((1+L23/100)*(1+L41/100)))*(1-ABS(L87-K87*L42/((1+L23/100)*(1+L41/100)))/((L38*K87*K94*L42/((1+L23/100)*(1+L41/100)))+(K93*K87*L42/((1+L23/100)*(1+L41/100))))),0))) =IF(M87=0,0,IF(M83=1,M38*L87*L94*M42/((1+M23/100)*(1+M41/100)),IF(AND(M83=0,M84=1),(M38*L87*L94*M42/((1+M23/100)*(1+M41/100)))*(1-ABS(M87-L87*M42/((1+M23/100)*(1+M41/100)))/((M38*L87*L94*M42/((1+M23/100)*(1+M41/100)))+(L93*L87*M42/((1+M23/100)*(1+M41/100))))),0))) =IF(N87=0,0,IF(N83=1,N38*M87*M94*N42/((1+N23/100)*(1+N41/100)),IF(AND(N83=0,N84=1),(N38*M87*M94*N42/((1+N23/100)*(1+N41/100)))*(1-ABS(N87-M87*N42/((1+N23/100)*(1+N41/100)))/((N38*M87*M94*N42/((1+N23/100)*(1+N41/100)))+(M93*M87*N42/((1+N23/100)*(1+N41/100))))),0))) =IF(O87=0,0,IF(O83=1,O38*N87*N94*O42/((1+O23/100)*(1+O41/100)),IF(AND(O83=0,O84=1),(O38*N87*N94*O42/((1+O23/100)*(1+O41/100)))*(1-ABS(O87-N87*O42/((1+O23/100)*(1+O41/100)))/((O38*N87*N94*O42/((1+O23/100)*(1+O41/100)))+(N93*N87*O42/((1+O23/100)*(1+O41/100))))),0))) =IF(P87=0,0,IF(P83=1,P38*O87*O94*P42/((1+P23/100)*(1+P41/100)),IF(AND(P83=0,P84=1),(P38*O87*O94*P42/((1+P23/100)*(1+P41/100)))*(1-ABS(P87-O87*P42/((1+P23/100)*(1+P41/100)))/((P38*O87*O94*P42/((1+P23/100)*(1+P41/100)))+(O93*O87*P42/((1+P23/100)*(1+P41/100))))),0))) =IF(Q87=0,0,IF(Q83=1,Q38*P87*P94*Q42/((1+Q23/100)*(1+Q41/100)),IF(AND(Q83=0,Q84=1),(Q38*P87*P94*Q42/((1+Q23/100)*(1+Q41/100)))*(1-ABS(Q87-P87*Q42/((1+Q23/100)*(1+Q41/100)))/((Q38*P87*P94*Q42/((1+Q23/100)*(1+Q41/100)))+(P93*P87*Q42/((1+Q23/100)*(1+Q41/100))))),0))) =IF(R87=0,0,IF(R83=1,R38*Q87*Q94*R42/((1+R23/100)*(1+R41/100)),IF(AND(R83=0,R84=1),(R38*Q87*Q94*R42/((1+R23/100)*(1+R41/100)))*(1-ABS(R87-Q87*R42/((1+R23/100)*(1+R41/100)))/((R38*Q87*Q94*R42/((1+R23/100)*(1+R41/100)))+(Q93*Q87*R42/((1+R23/100)*(1+R41/100))))),0))) =IF(S87=0,0,IF(S83=1,S38*R87*R94*S42/((1+S23/100)*(1+S41/100)),IF(AND(S83=0,S84=1),(S38*R87*R94*S42/((1+S23/100)*(1+S41/100)))*(1-ABS(S87-R87*S42/((1+S23/100)*(1+S41/100)))/((S38*R87*R94*S42/((1+S23/100)*(1+S41/100)))+(R93*R87*S42/((1+S23/100)*(1+S41/100))))),0))) =IF(T87=0,0,IF(T83=1,T38*S87*S94*T42/((1+T23/100)*(1+T41/100)),IF(AND(T83=0,T84=1),(T38*S87*S94*T42/((1+T23/100)*(1+T41/100)))*(1-ABS(T87-S87*T42/((1+T23/100)*(1+T41/100)))/((T38*S87*S94*T42/((1+T23/100)*(1+T41/100)))+(S93*S87*T42/((1+T23/100)*(1+T41/100))))),0))) =IF(U87=0,0,IF(U83=1,U38*T87*T94*U42/((1+U23/100)*(1+U41/100)),IF(AND(U83=0,U84=1),(U38*T87*T94*U42/((1+U23/100)*(1+U41/100)))*(1-ABS(U87-T87*U42/((1+U23/100)*(1+U41/100)))/((U38*T87*T94*U42/((1+U23/100)*(1+U41/100)))+(T93*T87*U42/((1+U23/100)*(1+U41/100))))),0))) =IF(V87=0,0,IF(V83=1,V38*U87*U94*V42/((1+V23/100)*(1+V41/100)),IF(AND(V83=0,V84=1),(V38*U87*U94*V42/((1+V23/100)*(1+V41/100)))*(1-ABS(V87-U87*V42/((1+V23/100)*(1+V41/100)))/((V38*U87*U94*V42/((1+V23/100)*(1+V41/100)))+(U93*U87*V42/((1+V23/100)*(1+V41/100))))),0))) =IF(W87=0,0,IF(W83=1,W38*V87*V94*W42/((1+W23/100)*(1+W41/100)),IF(AND(W83=0,W84=1),(W38*V87*V94*W42/((1+W23/100)*(1+W41/100)))*(1-ABS(W87-V87*W42/((1+W23/100)*(1+W41/100)))/((W38*V87*V94*W42/((1+W23/100)*(1+W41/100)))+(V93*V87*W42/((1+W23/100)*(1+W41/100))))),0))) Rolled over short-term debt ='Input data'!C68*$D$87 =IF(E87=0,0,IF(E83=1,(1-D94)*D87*E42/((1+E23/100)*(1+E41/100)),IF(AND(E83=0,E84=1),(D93*D87*E42/((1+E23/100)*(1+E41/100)))*(1-ABS(E87-D87*E42/((1+E23/100)*(1+E41/100)))/((E38*D87*D94*E42/((1+E23/100)*(1+E41/100)))+(D93*D87*E42/((1+E23/100)*(1+E41/100))))),0))) =IF(F87=0,0,IF(F83=1,(1-E94)*E87*F42/((1+F23/100)*(1+F41/100)),IF(AND(F83=0,F84=1),(E93*E87*F42/((1+F23/100)*(1+F41/100)))*(1-ABS(F87-E87*F42/((1+F23/100)*(1+F41/100)))/((F38*E87*E94*F42/((1+F23/100)*(1+F41/100)))+(E93*E87*F42/((1+F23/100)*(1+F41/100))))),0))) =IF(G87=0,0,IF(G83=1,(1-F94)*F87*G42/((1+G23/100)*(1+G41/100)),IF(AND(G83=0,G84=1),(F93*F87*G42/((1+G23/100)*(1+G41/100)))*(1-ABS(G87-F87*G42/((1+G23/100)*(1+G41/100)))/((G38*F87*F94*G42/((1+G23/100)*(1+G41/100)))+(F93*F87*G42/((1+G23/100)*(1+G41/100))))),0))) =IF(H87=0,0,IF(H83=1,(1-G94)*G87*H42/((1+H23/100)*(1+H41/100)),IF(AND(H83=0,H84=1),(G93*G87*H42/((1+H23/100)*(1+H41/100)))*(1-ABS(H87-G87*H42/((1+H23/100)*(1+H41/100)))/((H38*G87*G94*H42/((1+H23/100)*(1+H41/100)))+(G93*G87*H42/((1+H23/100)*(1+H41/100))))),0))) =IF(I87=0,0,IF(I83=1,(1-H94)*H87*I42/((1+I23/100)*(1+I41/100)),IF(AND(I83=0,I84=1),(H93*H87*I42/((1+I23/100)*(1+I41/100)))*(1-ABS(I87-H87*I42/((1+I23/100)*(1+I41/100)))/((I38*H87*H94*I42/((1+I23/100)*(1+I41/100)))+(H93*H87*I42/((1+I23/100)*(1+I41/100))))),0))) =IF(J87=0,0,IF(J83=1,(1-I94)*I87*J42/((1+J23/100)*(1+J41/100)),IF(AND(J83=0,J84=1),(I93*I87*J42/((1+J23/100)*(1+J41/100)))*(1-ABS(J87-I87*J42/((1+J23/100)*(1+J41/100)))/((J38*I87*I94*J42/((1+J23/100)*(1+J41/100)))+(I93*I87*J42/((1+J23/100)*(1+J41/100))))),0))) =IF(K87=0,0,IF(K83=1,(1-J94)*J87*K42/((1+K23/100)*(1+K41/100)),IF(AND(K83=0,K84=1),(J93*J87*K42/((1+K23/100)*(1+K41/100)))*(1-ABS(K87-J87*K42/((1+K23/100)*(1+K41/100)))/((K38*J87*J94*K42/((1+K23/100)*(1+K41/100)))+(J93*J87*K42/((1+K23/100)*(1+K41/100))))),0))) =IF(L87=0,0,IF(L83=1,(1-K94)*K87*L42/((1+L23/100)*(1+L41/100)),IF(AND(L83=0,L84=1),(K93*K87*L42/((1+L23/100)*(1+L41/100)))*(1-ABS(L87-K87*L42/((1+L23/100)*(1+L41/100)))/((L38*K87*K94*L42/((1+L23/100)*(1+L41/100)))+(K93*K87*L42/((1+L23/100)*(1+L41/100))))),0))) =IF(M87=0,0,IF(M83=1,(1-L94)*L87*M42/((1+M23/100)*(1+M41/100)),IF(AND(M83=0,M84=1),(L93*L87*M42/((1+M23/100)*(1+M41/100)))*(1-ABS(M87-L87*M42/((1+M23/100)*(1+M41/100)))/((M38*L87*L94*M42/((1+M23/100)*(1+M41/100)))+(L93*L87*M42/((1+M23/100)*(1+M41/100))))),0))) =IF(N87=0,0,IF(N83=1,(1-M94)*M87*N42/((1+N23/100)*(1+N41/100)),IF(AND(N83=0,N84=1),(M93*M87*N42/((1+N23/100)*(1+N41/100)))*(1-ABS(N87-M87*N42/((1+N23/100)*(1+N41/100)))/((N38*M87*M94*N42/((1+N23/100)*(1+N41/100)))+(M93*M87*N42/((1+N23/100)*(1+N41/100))))),0))) =IF(O87=0,0,IF(O83=1,(1-N94)*N87*O42/((1+O23/100)*(1+O41/100)),IF(AND(O83=0,O84=1),(N93*N87*O42/((1+O23/100)*(1+O41/100)))*(1-ABS(O87-N87*O42/((1+O23/100)*(1+O41/100)))/((O38*N87*N94*O42/((1+O23/100)*(1+O41/100)))+(N93*N87*O42/((1+O23/100)*(1+O41/100))))),0))) =IF(P87=0,0,IF(P83=1,(1-O94)*O87*P42/((1+P23/100)*(1+P41/100)),IF(AND(P83=0,P84=1),(O93*O87*P42/((1+P23/100)*(1+P41/100)))*(1-ABS(P87-O87*P42/((1+P23/100)*(1+P41/100)))/((P38*O87*O94*P42/((1+P23/100)*(1+P41/100)))+(O93*O87*P42/((1+P23/100)*(1+P41/100))))),0))) =IF(Q87=0,0,IF(Q83=1,(1-P94)*P87*Q42/((1+Q23/100)*(1+Q41/100)),IF(AND(Q83=0,Q84=1),(P93*P87*Q42/((1+Q23/100)*(1+Q41/100)))*(1-ABS(Q87-P87*Q42/((1+Q23/100)*(1+Q41/100)))/((Q38*P87*P94*Q42/((1+Q23/100)*(1+Q41/100)))+(P93*P87*Q42/((1+Q23/100)*(1+Q41/100))))),0))) =IF(R87=0,0,IF(R83=1,(1-Q94)*Q87*R42/((1+R23/100)*(1+R41/100)),IF(AND(R83=0,R84=1),(Q93*Q87*R42/((1+R23/100)*(1+R41/100)))*(1-ABS(R87-Q87*R42/((1+R23/100)*(1+R41/100)))/((R38*Q87*Q94*R42/((1+R23/100)*(1+R41/100)))+(Q93*Q87*R42/((1+R23/100)*(1+R41/100))))),0))) =IF(S87=0,0,IF(S83=1,(1-R94)*R87*S42/((1+S23/100)*(1+S41/100)),IF(AND(S83=0,S84=1),(R93*R87*S42/((1+S23/100)*(1+S41/100)))*(1-ABS(S87-R87*S42/((1+S23/100)*(1+S41/100)))/((S38*R87*R94*S42/((1+S23/100)*(1+S41/100)))+(R93*R87*S42/((1+S23/100)*(1+S41/100))))),0))) =IF(T87=0,0,IF(T83=1,(1-S94)*S87*T42/((1+T23/100)*(1+T41/100)),IF(AND(T83=0,T84=1),(S93*S87*T42/((1+T23/100)*(1+T41/100)))*(1-ABS(T87-S87*T42/((1+T23/100)*(1+T41/100)))/((T38*S87*S94*T42/((1+T23/100)*(1+T41/100)))+(S93*S87*T42/((1+T23/100)*(1+T41/100))))),0))) =IF(U87=0,0,IF(U83=1,(1-T94)*T87*U42/((1+U23/100)*(1+U41/100)),IF(AND(U83=0,U84=1),(T93*T87*U42/((1+U23/100)*(1+U41/100)))*(1-ABS(U87-T87*U42/((1+U23/100)*(1+U41/100)))/((U38*T87*T94*U42/((1+U23/100)*(1+U41/100)))+(T93*T87*U42/((1+U23/100)*(1+U41/100))))),0))) =IF(V87=0,0,IF(V83=1,(1-U94)*U87*V42/((1+V23/100)*(1+V41/100)),IF(AND(V83=0,V84=1),(U93*U87*V42/((1+V23/100)*(1+V41/100)))*(1-ABS(V87-U87*V42/((1+V23/100)*(1+V41/100)))/((V38*U87*U94*V42/((1+V23/100)*(1+V41/100)))+(U93*U87*V42/((1+V23/100)*(1+V41/100))))),0))) =IF(W87=0,0,IF(W83=1,(1-V94)*V87*W42/((1+W23/100)*(1+W41/100)),IF(AND(W83=0,W84=1),(V93*V87*W42/((1+W23/100)*(1+W41/100)))*(1-ABS(W87-V87*W42/((1+W23/100)*(1+W41/100)))/((W38*V87*V94*W42/((1+W23/100)*(1+W41/100)))+(V93*V87*W42/((1+W23/100)*(1+W41/100))))),0))) New long-term debt ='Input data'!C69*$D$87 =IF(E87=0,0,IF(E83=1,'Input data'!$C$58*(E87-D87*E42/((1+E23/100)*(1+E41/100))),0)) =IF(F87=0,0,IF(F83=1,'Input data'!$C$58*(F87-E87*F42/((1+F23/100)*(1+F41/100))),0)) =IF(G87=0,0,IF(G83=1,'Input data'!$C$58*(G87-F87*G42/((1+G23/100)*(1+G41/100))),0)) =IF(H87=0,0,IF(H83=1,'Input data'!$C$58*(H87-G87*H42/((1+H23/100)*(1+H41/100))),0)) =IF(I87=0,0,IF(I83=1,'Input data'!$C$58*(I87-H87*I42/((1+I23/100)*(1+I41/100))),0)) =IF(J87=0,0,IF(J83=1,'Input data'!$C$58*(J87-I87*J42/((1+J23/100)*(1+J41/100))),0)) =IF(K87=0,0,IF(K83=1,'Input data'!$C$58*(K87-J87*K42/((1+K23/100)*(1+K41/100))),0)) =IF(L87=0,0,IF(L83=1,'Input data'!$C$58*(L87-K87*L42/((1+L23/100)*(1+L41/100))),0)) =IF(M87=0,0,IF(M83=1,'Input data'!$C$58*(M87-L87*M42/((1+M23/100)*(1+M41/100))),0)) =IF(N87=0,0,IF(N83=1,'Input data'!$C$58*(N87-M87*N42/((1+N23/100)*(1+N41/100))),0)) =IF(O87=0,0,IF(O83=1,'Input data'!$C$58*(O87-N87*O42/((1+O23/100)*(1+O41/100))),0)) =IF(P87=0,0,IF(P83=1,'Input data'!$C$58*(P87-O87*P42/((1+P23/100)*(1+P41/100))),0)) =IF(Q87=0,0,IF(Q83=1,'Input data'!$C$58*(Q87-P87*Q42/((1+Q23/100)*(1+Q41/100))),0)) =IF(R87=0,0,IF(R83=1,'Input data'!$C$58*(R87-Q87*R42/((1+R23/100)*(1+R41/100))),0)) =IF(S87=0,0,IF(S83=1,'Input data'!$C$58*(S87-R87*S42/((1+S23/100)*(1+S41/100))),0)) =IF(T87=0,0,IF(T83=1,'Input data'!$C$58*(T87-S87*T42/((1+T23/100)*(1+T41/100))),0)) =IF(U87=0,0,IF(U83=1,'Input data'!$C$58*(U87-T87*U42/((1+U23/100)*(1+U41/100))),0)) =IF(V87=0,0,IF(V83=1,'Input data'!$C$58*(V87-U87*V42/((1+V23/100)*(1+V41/100))),0)) =IF(W87=0,0,IF(W83=1,'Input data'!$C$58*(W87-V87*W42/((1+W23/100)*(1+W41/100))),0)) New short-term debt ='Input data'!C70*$D$87 =IF(E87=0,0,IF(E83=1,'Input data'!$C$57*(E87-D87*E42/((1+E23/100)*(1+E41/100))),0)) =IF(F87=0,0,IF(F83=1,'Input data'!$C$57*(F87-E87*F42/((1+F23/100)*(1+F41/100))),0)) =IF(G87=0,0,IF(G83=1,'Input data'!$C$57*(G87-F87*G42/((1+G23/100)*(1+G41/100))),0)) =IF(H87=0,0,IF(H83=1,'Input data'!$C$57*(H87-G87*H42/((1+H23/100)*(1+H41/100))),0)) =IF(I87=0,0,IF(I83=1,'Input data'!$C$57*(I87-H87*I42/((1+I23/100)*(1+I41/100))),0)) =IF(J87=0,0,IF(J83=1,'Input data'!$C$57*(J87-I87*J42/((1+J23/100)*(1+J41/100))),0)) =IF(K87=0,0,IF(K83=1,'Input data'!$C$57*(K87-J87*K42/((1+K23/100)*(1+K41/100))),0)) =IF(L87=0,0,IF(L83=1,'Input data'!$C$57*(L87-K87*L42/((1+L23/100)*(1+L41/100))),0)) =IF(M87=0,0,IF(M83=1,'Input data'!$C$57*(M87-L87*M42/((1+M23/100)*(1+M41/100))),0)) =IF(N87=0,0,IF(N83=1,'Input data'!$C$57*(N87-M87*N42/((1+N23/100)*(1+N41/100))),0)) =IF(O87=0,0,IF(O83=1,'Input data'!$C$57*(O87-N87*O42/((1+O23/100)*(1+O41/100))),0)) =IF(P87=0,0,IF(P83=1,'Input data'!$C$57*(P87-O87*P42/((1+P23/100)*(1+P41/100))),0)) =IF(Q87=0,0,IF(Q83=1,'Input data'!$C$57*(Q87-P87*Q42/((1+Q23/100)*(1+Q41/100))),0)) =IF(R87=0,0,IF(R83=1,'Input data'!$C$57*(R87-Q87*R42/((1+R23/100)*(1+R41/100))),0)) =IF(S87=0,0,IF(S83=1,'Input data'!$C$57*(S87-R87*S42/((1+S23/100)*(1+S41/100))),0)) =IF(T87=0,0,IF(T83=1,'Input data'!$C$57*(T87-S87*T42/((1+T23/100)*(1+T41/100))),0)) =IF(U87=0,0,IF(U83=1,'Input data'!$C$57*(U87-T87*U42/((1+U23/100)*(1+U41/100))),0)) =IF(V87=0,0,IF(V83=1,'Input data'!$C$57*(V87-U87*V42/((1+V23/100)*(1+V41/100))),0)) =IF(W87=0,0,IF(W83=1,'Input data'!$C$57*(W87-V87*W42/((1+W23/100)*(1+W41/100))),0)) Share of short-term debt in total government debt =1-D94 =IF(E87<>0,(E90+E92)/(E88+E89+E90+E91+E92),0) =IF(F87<>0,(F90+F92)/(F88+F89+F90+F91+F92),0) =IF(G87<>0,(G90+G92)/(G88+G89+G90+G91+G92),0) =IF(H87<>0,(H90+H92)/(H88+H89+H90+H91+H92),0) =IF(I87<>0,(I90+I92)/(I88+I89+I90+I91+I92),0) =IF(J87<>0,(J90+J92)/(J88+J89+J90+J91+J92),0) =IF(K87<>0,(K90+K92)/(K88+K89+K90+K91+K92),0) =IF(L87<>0,(L90+L92)/(L88+L89+L90+L91+L92),0) =IF(M87<>0,(M90+M92)/(M88+M89+M90+M91+M92),0) =IF(N87<>0,(N90+N92)/(N88+N89+N90+N91+N92),0) =IF(O87<>0,(O90+O92)/(O88+O89+O90+O91+O92),0) =IF(P87<>0,(P90+P92)/(P88+P89+P90+P91+P92),0) =IF(Q87<>0,(Q90+Q92)/(Q88+Q89+Q90+Q91+Q92),0) =IF(R87<>0,(R90+R92)/(R88+R89+R90+R91+R92),0) =IF(S87<>0,(S90+S92)/(S88+S89+S90+S91+S92),0) =IF(T87<>0,(T90+T92)/(T88+T89+T90+T91+T92),0) =IF(U87<>0,(U90+U92)/(U88+U89+U90+U91+U92),0) =IF(V87<>0,(V90+V92)/(V88+V89+V90+V91+V92),0) =IF(W87<>0,(W90+W92)/(W88+W89+W90+W91+W92),0) Share of long-term debt in total government debt =(D88+D89+D91)/D87 =IF(E87<>0,(E88+E89+E91)/(E88+E89+E90+E91+E92),1) =IF(F87<>0,(F88+F89+F91)/(F88+F89+F90+F91+F92),1) =IF(G87<>0,(G88+G89+G91)/(G88+G89+G90+G91+G92),1) =IF(H87<>0,(H88+H89+H91)/(H88+H89+H90+H91+H92),1) =IF(I87<>0,(I88+I89+I91)/(I88+I89+I90+I91+I92),1) =IF(J87<>0,(J88+J89+J91)/(J88+J89+J90+J91+J92),1) =IF(K87<>0,(K88+K89+K91)/(K88+K89+K90+K91+K92),1) =IF(L87<>0,(L88+L89+L91)/(L88+L89+L90+L91+L92),1) =IF(M87<>0,(M88+M89+M91)/(M88+M89+M90+M91+M92),1) =IF(N87<>0,(N88+N89+N91)/(N88+N89+N90+N91+N92),1) =IF(O87<>0,(O88+O89+O91)/(O88+O89+O90+O91+O92),1) =IF(P87<>0,(P88+P89+P91)/(P88+P89+P90+P91+P92),1) =IF(Q87<>0,(Q88+Q89+Q91)/(Q88+Q89+Q90+Q91+Q92),1) =IF(R87<>0,(R88+R89+R91)/(R88+R89+R90+R91+R92),1) =IF(S87<>0,(S88+S89+S91)/(S88+S89+S90+S91+S92),1) =IF(T87<>0,(T88+T89+T91)/(T88+T89+T90+T91+T92),1) =IF(U87<>0,(U88+U89+U91)/(U88+U89+U90+U91+U92),1) =IF(V87<>0,(V88+V89+V91)/(V88+V89+V90+V91+V92),1) =IF(W87<>0,(W88+W89+W91)/(W88+W89+W90+W91+W92),1) IIR =C35 =D35 =E98+E99 =F98+F99 =G98+G99 =H98+H99 =I98+I99 =J98+J99 =K98+K99 =L98+L99 =M98+M99 =N98+N99 =O98+O99 =P98+P99 =Q98+Q99 =R98+R99 =S98+S99 =T98+T99 =U98+U99 =V98+V99 =W98+W99 Long-term implicit interest rate =((E35*D87)-(E37*D90+D92))/(D88+D89+D91) =((F35*E87)-(F37*E90+E92))/(E88+E89+E91) =((G35*F87)-(G37*F90+F92))/(F88+F89+F91) =IF(G87>0,(G97*G88+H36*(G91+G89))/(G88+G89+G91),H36) =IF(H87>0,(H97*H88+I36*(H91+H89))/(H88+H89+H91),I36) =IF(I87>0,(I97*I88+J36*(I91+I89))/(I88+I89+I91),J36) =IF(J87>0,(J97*J88+K36*(J91+J89))/(J88+J89+J91),K36) =IF(K87>0,(K97*K88+L36*(K91+K89))/(K88+K89+K91),L36) =IF(L87>0,(L97*L88+M36*(L91+L89))/(L88+L89+L91),M36) =IF(M87>0,(M97*M88+N36*(M91+M89))/(M88+M89+M91),N36) =IF(N87>0,(N97*N88+O36*(N91+N89))/(N88+N89+N91),O36) =IF(O87>0,(O97*O88+P36*(O91+O89))/(O88+O89+O91),P36) =IF(P87>0,(P97*P88+Q36*(P91+P89))/(P88+P89+P91),Q36) =IF(Q87>0,(Q97*Q88+R36*(Q91+Q89))/(Q88+Q89+Q91),R36) =IF(R87>0,(R97*R88+S36*(R91+R89))/(R88+R89+R91),S36) =IF(S87>0,(S97*S88+T36*(S91+S89))/(S88+S89+S91),T36) =IF(T87>0,(T97*T88+U36*(T91+T89))/(T88+T89+T91),U36) =IF(U87>0,(U97*U88+V36*(U91+U89))/(U88+U89+U91),V36) =IF(V87>0,(V97*V88+W36*(V91+V89))/(V88+V89+V91),W36) Nominal implicit interest rate on debt (Excel approximation) =E35 =F35 =G35 =(H97*(G88+G89+G91)+H37*(G90+G92))/G87 =(I97*(H88+H89+H91)+I37*(H90+H92))/H87 =(J97*(I88+I89+I91)+J37*(I90+I92))/I87 =(K97*(J88+J89+J91)+K37*(J90+J92))/J87 =(L97*(K88+K89+K91)+L37*(K90+K92))/K87 =(M97*(L88+L89+L91)+M37*(L90+L92))/L87 =(N97*(M88+M89+M91)+N37*(M90+M92))/M87 =(O97*(N