{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Debt Sculpting - Manual"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":7,"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":"Debt Sculpting - Manual","index":0,"n_rows":65,"n_cols":17,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Inputs"]
[null,null,null,"Project Cost",null,800]
[null,null,null,"Debt to Capital",null,0.8]
[null,null,null,"Debt  ",null,{"$f":"F4*F5","v":640}]
[null,null,null,"Interest Rate",null,0.05]
[null,null,null,"Minimum DSCR",null,1.2]
[null,null,null,"Maximum Debt Life",null,6.8]
[]
[null,null,null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,"CFADS",null,120,120,120,130,130,130,140,120,120,100]
[]
[null,null,"Step 1: Compute LLCR"]
[null,null,null,"NPV of Cash Flows ",null,{"$f":"NPV(F7,F12:O12)","v":952.06799341293424},{"$f":"_xlfn.FORMULATEXT(F15)","v":"=NPV(F7,F12:O12)"}]
[null,null,null,"LLCR",null,{"$f":"F15/F6","v":1.4876062397077097},{"$f":"_xlfn.FORMULATEXT(F16)","v":"=F15/F6"}]
[]
[null,null,"Step 2-4:"]
[null,null,null,"LLCR Factor",null,1.2104312312078009,"llcr_factor"]
[null,null,null,"Final Interpolation Period",null,100,"final_interp"]
[]
[null,null,null,"2 x 2 Table"]
[null,null,null,"Period",null,null,1,10]
[null,null,null,"DSCR",null,null,{"$f":"llcr_factor*F16","v":1.80064505228181},{"$f":"F8","v":1.2}]
[]
[null,null,"Step 5: Interpolate - to Compute Curved DSCR",null,null,{"$f":"interpolate_look_up(F11,23:23,24:24)","v":1.80064505228181},{"$f":"interpolate_look_up(G11,23:23,24:24)","v":1.7212546515740477},{"$f":"interpolate_look_up(H11,23:23,24:24)","v":1.6453645718854399},{"$f":"interpolate_look_up(I11,23:23,24:24)","v":1.5728204841393241},{"$f":"interpolate_look_up(J11,23:23,24:24)","v":1.5034748636246289},{"$f":"interpolate_look_up(K11,23:23,24:24)","v":1.4371866899915464},{"$f":"interpolate_look_up(L11,23:23,24:24)","v":1.3738211604743862},{"$f":"interpolate_look_up(M11,23:23,24:24)","v":1.3132494157584291},{"$f":"interpolate_look_up(N11,23:23,24:24)","v":1.2553482779333054},{"$f":"interpolate_look_up(O11,23:23,24:24)","v":1.2}]
[]
[null,null,"Step 6-7: Debt Service and PV of Debt Service"]
[null,null,null,"Debt Service",null,{"$f":"F12/F26","v":66.642784399920359},{"$f":"G12/G26","v":69.716587194267134},72.932164731425317,82.654060848615131,86.466360792086363,90.454497599587896,101.9055493013788,91.376397019523878,95.591002201841079,83.333333333333343,null,{"$f":"_xlfn.FORMULATEXT(O29)","v":"=O12/O26"}]
[]
[null,null,null,"PV of Debt Service",null,{"$f":"NPV(F7,F29:O29)","v":640.0005233644863},{"$f":"_xlfn.FORMULATEXT(F31)","v":"=NPV(F7,F29:O29)"}]
[]
[null,null,"Step 8: Goal Seek to Find LLCR Factor"]
[]
[null,null,null,"PV DS",null,{"$f":"F31","v":640.0005233644863}]
[null,null,null,"Target Debt",null,{"$f":"F6","v":640}]
[null,null,null,"Difference ",null,{"$f":"F35-F36","v":5.2336448629830556E-4},"difference"]
[]
[null,null,"Step 9: Compute the Average Debt Life"]
[null,null,null,"Debt Balance",null,{"$f":"F11","v":1},{"$f":"G11","v":2},3,4,5,6,7,8,9,10]
[null,null,null,"Opening Balance",null,{"$f":"E43","v":640},{"$f":"F43","v":605.3572156000796},565.90848918581651,521.27174891368202,464.68127551075099,401.44897849420215,331.0669298193244,245.71472700891184,166.62406633983355,79.364267454984144]
[null,null,null,"Less: Repayment",null,{"$f":"F29-F44","v":34.642784399920359},{"$f":"G29-G44","v":39.448726414263149},44.636740272134489,56.590473402931025,63.232297016548813,70.38204867487778,85.352202810412578,79.090660669078289,87.259798884849403,79.365119960584138]
[null,null,null,"Closing Balance",{"$f":"F36","v":640},{"$f":"F41-F42","v":605.3572156000796},{"$f":"G41-G42","v":565.90848918581651},521.27174891368202,464.68127551075099,401.44897849420215,331.0669298193244,245.71472700891184,166.62406633983355,79.364267454984144,-8.5250559999394682E-4]
[null,null,null,"Interest",{"$f":"F7","v":0.05},{"$f":"F41*$E$44","v":32},{"$f":"G41*$E$44","v":30.267860780003982},28.295424459290828,26.063587445684103,23.23406377553755,20.072448924710109,16.55334649096622,12.285736350445593,8.3312033169916777,3.9682133727492075]
[]
[null,null,null,"Average Loan Life "]
[null,null,null,"Sumproduct",{"$f":"SUMPRODUCT(F42:O42,F40:O40)","v":4021.4462233835857}]
[null,null,null,"Loan Life",{"$f":"E47/E43","v":6.2835097240368523}]
[]
[null,null,null,"Sum of Open Debt Balance",{"$f":"SUM(F41:O41)","v":4021.4376983275847}]
[null,null,null,"Loan Life",{"$f":"E50/E43","v":6.2834964036368515},"loan_life"]
[]
[]
[null,null,null,null,null,null,"Final Interpolation Period"]
[null,null,null,null,null,null,null,"LLCR Factor","Loan Life","Goal Seek"]
[null,null,null,null,null,null,5,1.2104312312078009,6.2834964036368515,5.2336448629830556E-4]
[null,null,null,null,null,null,6,1.2104312312078009,6.2834964036368515,5.2336448629830556E-4]
[null,null,null,null,null,null,7,1.2104312312078009,6.2834964036368515,5.2336448629830556E-4]
[null,null,null,null,null,null,8,1.2104312312078009,6.2834964036368515,5.2336448629830556E-4]
[null,null,null,null,null,null,9,1.2104312312078009,6.2834964036368515,5.2336448629830556E-4]
[null,null,null,null,null,null,10,1.2104312312078009,6.2834964036368515,5.2336448629830556E-4]
[null,null,null,null,null,null,10,1.2104312312078009,6.2834964036368515,5.2336448629830556E-4]
[null,null,null,null,null,null,20,1.2104312312078009,6.2834964036368515,5.2336448629830556E-4]
[null,null,null,null,null,null,30,1.2104312312078009,6.2834964036368515,5.2336448629830556E-4]
[null,null,null,null,null,null,100,1.2104312312078009,6.2834964036368515,5.2336448629830556E-4]