{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Blank Exercise","Completed Basic Exercise","Sweep with Taxes Blank","Sweep with Taxes Completed","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":9,"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":"Blank Exercise","index":0,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions"]
[null,"Cash Flow",null,null,null,100]
[null,"Growth",null,null,null,0.2]
[null,"Interest Rate",null,null,null,0.2]
[null,"Initial Debt",null,null,null,600]
[null,"Opening Balance",null,null,null,true]
[]
["Method 1: Iteration Button"]
[]
[null,"Debt Schedule"]
[null,null,"Opening Balance",null,null,null,{"$f":"F14","v":600},{"$f":"G14","v":600},600,600,600,600,600,600,600,600]
[null,null,"Less: Repayment from Sweep",null,null,null,{"$f":"G22","v":0},{"$f":"H22","v":0},0,0,0,0,0,0,0,0]
[null,null,"Closing Balance",null,null,{"$f":"F6","v":600},{"$f":"G12-G13","v":600},{"$f":"H12-H13","v":600},600,600,600,600,600,600,600,600]
[]
[null,null,"Interest Expense on Average Balance",null,null,null,{"$f":"IF($F$7,G12*$F$5,AVERAGE(G14,G12)*$F$5)","v":120},{"$f":"IF($F$7,H12*$F$5,AVERAGE(H14,H12)*$F$5)","v":120},120,120,120,120,120,120,120,120]
[]
[null,"Cash Flow Statement"]
[null,null,"Cash Flow",null,null,null,{"$f":"$F$3","v":100},{"$f":"G19*(1+$F$4)","v":120},{"$f":"H19*(1+$F$4)","v":144},{"$f":"I19*(1+$F$4)","v":172.79999999999998},{"$f":"J19*(1+$F$4)","v":207.35999999999999},{"$f":"K19*(1+$F$4)","v":248.83199999999997},{"$f":"L19*(1+$F$4)","v":298.59839999999997},{"$f":"M19*(1+$F$4)","v":358.31807999999995},{"$f":"N19*(1+$F$4)","v":429.98169599999994},{"$f":"O19*(1+$F$4)","v":515.97803519999991}]
[null,null,"Less: Interest Expense",null,null,null,{"$f":"G16","v":120},{"$f":"H16","v":120},120,120,120,120,120,120,120,120]
[null,null,"Cash Flow After Interest",null,null,null,{"$f":"G19-G20","v":-20},{"$f":"H19-H20","v":0},24,52.799999999999983,87.359999999999985,128.83199999999997,178.59839999999997,238.31807999999995,309.98169599999994,395.97803519999991]
[null,null,"Less: Repayments"]
[null,null,"Equity Cash Flow",null,null,null,{"$f":"G21-G22","v":-20},{"$f":"H21-H22","v":0},24,52.799999999999983,87.359999999999985,128.83199999999997,178.59839999999997,238.31807999999995,309.98169599999994,395.97803519999991]
[]
[]
["Method 2: Horrible Copy and Paste"]
[]
[null,"Debt Schedule"]
[null,null,"Opening Balance",null,null,null,{"$f":"F31","v":600},{"$f":"G31","v":500},380,236,63.200000000000017,0,0,0,0,0]
[null,null,"Less: Repayment from Sweep",null,null,null,{"$f":"G41","v":100},{"$f":"H41","v":120},144,172.79999999999998,63.200000000000017,0,0,0,0,0]
[null,null,"Closing Balance",null,null,{"$f":"F6","v":600},{"$f":"G29-G30","v":500},{"$f":"H29-H30","v":380},236,63.200000000000017,0,0,0,0,0,0]
[]
[null,null,"Computed Interest Expense",null,null,null,{"$f":"AVERAGE(G31,G29)*$F$5","v":110},{"$f":"AVERAGE(H31,H29)*$F$5","v":88},61.6,29.920000000000005,6.3200000000000021,0,0,0,0,0,"computed"]
[null,null,"Fixed Interest Expense",null,null,null,null,null,null,null,null,null,null,null,null,null,"fixed"]
[null,null,"Difference"]
[]
[null,"Cash Flow Statement"]
[null,null,"Cash Flow",null,null,null,{"$f":"$F$3","v":100},{"$f":"G38*(1+$F$4)","v":120},{"$f":"H38*(1+$F$4)","v":144},{"$f":"I38*(1+$F$4)","v":172.79999999999998},{"$f":"J38*(1+$F$4)","v":207.35999999999999},{"$f":"K38*(1+$F$4)","v":248.83199999999997},{"$f":"L38*(1+$F$4)","v":298.59839999999997},{"$f":"M38*(1+$F$4)","v":358.31807999999995},{"$f":"N38*(1+$F$4)","v":429.98169599999994},{"$f":"O38*(1+$F$4)","v":515.97803519999991}]
[null,null,"Less: Interest Expense",null,null,null,{"$f":"G34","v":0},{"$f":"H34","v":0},0,0,0,0,0,0,0,0]
[null,null,"Cash Flow After Interest",null,null,null,{"$f":"G38-G39","v":100},{"$f":"H38-H39","v":120},144,172.79999999999998,207.35999999999999,248.83199999999997,298.59839999999997,358.31807999999995,429.98169599999994,515.97803519999991]
[null,null,"Less: Repayments",null,null,null,{"$f":"MIN(G40,G29)","v":100},{"$f":"MIN(H40,H29)","v":120},{"$f":"MIN(I40,I29)","v":144},{"$f":"MIN(J40,J29)","v":172.79999999999998},{"$f":"MIN(K40,K29)","v":63.200000000000017},{"$f":"MIN(L40,L29)","v":0},{"$f":"MIN(M40,M29)","v":0},{"$f":"MIN(N40,N29)","v":0},{"$f":"MIN(O40,O29)","v":0},{"$f":"MIN(P40,P29)","v":0}]
[null,null,"Equity Cash Flow",null,null,null,{"$f":"G40-G41","v":0},{"$f":"H40-H41","v":0},0,0,144.15999999999997,248.83199999999997,298.59839999999997,358.31807999999995,429.98169599999994,515.97803519999991]
[]
["Method 3: Function Method"]
[]
[null,"Debt Schedule"]
[null,null,"Opening Balance",null,null,null,{"$f":"F49","v":600},{"$f":"G49","v":500},380,236,63.200000000000017,0,0,0,0,0]
[null,null,"Less: Repayment from Sweep",null,null,null,{"$f":"G58","v":100},{"$f":"H58","v":120},144,172.79999999999998,63.200000000000017,0,0,0,0,0]
[null,null,"Closing Balance",null,null,{"$f":"F14","v":600},{"$f":"G47-G48","v":500},{"$f":"H47-H48","v":380},236,63.200000000000017,0,0,0,0,0,0]
[]
[null,null,"Interest Expense on Average Balance"]
[null,null,"Check",null,null,null,{"$f":"AVERAGE(G49,G47)*$F$5","v":110},{"$f":"AVERAGE(H49,H47)*$F$5","v":88},{"$f":"AVERAGE(I49,I47)*$F$5","v":61.6},{"$f":"AVERAGE(J49,J47)*$F$5","v":29.920000000000005},6.3200000000000021,0,0,0,0,0]
[]
[null,"Cash Flow Statement"]
[null,null,"Cash Flow",null,null,null,{"$f":"$F$3","v":100},{"$f":"G55*(1+$F$4)","v":120},{"$f":"H55*(1+$F$4)","v":144},{"$f":"I55*(1+$F$4)","v":172.79999999999998},{"$f":"J55*(1+$F$4)","v":207.35999999999999},{"$f":"K55*(1+$F$4)","v":248.83199999999997},{"$f":"L55*(1+$F$4)","v":298.59839999999997},{"$f":"M55*(1+$F$4)","v":358.31807999999995},{"$f":"N55*(1+$F$4)","v":429.98169599999994},{"$f":"O55*(1+$F$4)","v":515.97803519999991}]
[null,null,"Less: Interest Expense",null,null,null,{"$f":"G51","v":0},{"$f":"H51","v":0},{"$f":"I51","v":0},{"$f":"J51","v":0},{"$f":"K51","v":0},{"$f":"L51","v":0},{"$f":"M51","v":0},{"$f":"N51","v":0},{"$f":"O51","v":0},{"$f":"P51","v":0}]
[null,null,"Cash Flow After Interest",null,null,null,{"$f":"G55-G56","v":100},{"$f":"H55-H56","v":120},144,172.79999999999998,207.35999999999999,248.83199999999997,298.59839999999997,358.31807999999995,429.98169599999994,515.97803519999991]
[null,null,"Less: Repayments",null,null,null,{"$f":"MIN(G57,G47)","v":100},{"$f":"MIN(H57,H47)","v":120},144,172.79999999999998,63.200000000000017,0,{"$f":"MIN(M57,M47)","v":0},{"$f":"MIN(N57,N47)","v":0},0,0]
[null,null,"Equity Cash Flow",null,null,null,{"$f":"G57-G58","v":0},{"$f":"H57-H58","v":0},0,0,144.15999999999997,248.83199999999997,298.59839999999997,358.31807999999995,429.98169599999994,515.97803519999991]

{"sheet":"Completed Basic Exercise","index":1,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions"]
[null,"Cash Flow",null,null,null,100]
[null,"Growth",null,null,null,0.2]
[null,"Interest Rate",null,null,null,0.2]
[null,"Initial Debt",null,null,null,600]
[null,"Opening Balance",null,null,null,true]
[]
["Method 1: Iteration Button"]
[]
[null,"Debt Schedule"]
[null,null,"Opening Balance",null,null,null,{"$f":"F14","v":600},{"$f":"G14","v":620},624,604.79999999999995,552.95999999999992,456.19199999999989,298.59839999999991,59.719679999999926,0,0]
[null,null,"Less: Repayment from Sweep",null,null,null,{"$f":"G22","v":-20},{"$f":"H22","v":-4},19.199999999999989,51.839999999999989,96.768000000000001,157.59359999999998,238.87871999999999,59.719679999999926,0,0]
[null,null,"Closing Balance",null,null,{"$f":"F6","v":600},{"$f":"G12-G13","v":620},{"$f":"H12-H13","v":624},604.79999999999995,552.95999999999992,456.19199999999989,298.59839999999991,59.719679999999926,0,0,0]
[]
[null,null,"Interest Expense on Average Balance",null,null,null,{"$f":"IF($F$7,G12*$F$5,AVERAGE(G14,G12)*$F$5)","v":120},{"$f":"IF($F$7,H12*$F$5,AVERAGE(H14,H12)*$F$5)","v":124},124.80000000000001,120.96,110.59199999999998,91.238399999999984,59.719679999999983,11.943935999999987,0,0]
[]
[null,"Cash Flow Statement"]
[null,null,"Cash Flow",null,null,null,{"$f":"$F$3","v":100},{"$f":"G19*(1+$F$4)","v":120},{"$f":"H19*(1+$F$4)","v":144},{"$f":"I19*(1+$F$4)","v":172.79999999999998},{"$f":"J19*(1+$F$4)","v":207.35999999999999},{"$f":"K19*(1+$F$4)","v":248.83199999999997},{"$f":"L19*(1+$F$4)","v":298.59839999999997},{"$f":"M19*(1+$F$4)","v":358.31807999999995},{"$f":"N19*(1+$F$4)","v":429.98169599999994},{"$f":"O19*(1+$F$4)","v":515.97803519999991}]
[null,null,"Less: Interest Expense",null,null,null,{"$f":"G16","v":120},{"$f":"H16","v":124},124.80000000000001,120.96,110.59199999999998,91.238399999999984,59.719679999999983,11.943935999999987,0,0]
[null,null,"Cash Flow After Interest",null,null,null,{"$f":"G19-G20","v":-20},{"$f":"H19-H20","v":-4},19.199999999999989,51.839999999999989,96.768000000000001,157.59359999999998,238.87871999999999,346.37414399999994,429.98169599999994,515.97803519999991]
[null,null,"Less: Repayments",null,null,null,{"$f":"MIN(G21,G12)","v":-20},{"$f":"MIN(H21,H12)","v":-4},19.199999999999989,51.839999999999989,96.768000000000001,157.59359999999998,238.87871999999999,59.719679999999926,0,0]
[null,null,"Equity Cash Flow",null,null,null,{"$f":"G21-G22","v":0},{"$f":"H21-H22","v":0},0,0,0,0,0,286.65446400000002,429.98169599999994,515.97803519999991]
[]
[]
["Method 2: Horrible Copy and Paste"]
[]
[null,"Debt Schedule"]
[null,null,"Opening Balance",null,null,null,{"$f":"F31","v":600},{"$f":"G31","v":622.22222222222217},627.16049382716039,606.52949245541822,549.31382411217783,440.98356280377288,262.4999100935002,0,0,0]
[null,null,"Less: Repayment from Sweep",null,null,null,{"$f":"G41","v":-22.222222222222229},{"$f":"H41","v":-4.9382716049382509},20.631001371742144,57.215668343240367,108.33026130840491,178.48365271027268,262.4999100935002,0,0,0]
[null,null,"Closing Balance",null,null,{"$f":"F6","v":600},{"$f":"G29-G30","v":622.22222222222217},{"$f":"H29-H30","v":627.16049382716039},{"$f":"I29-I30","v":606.52949245541822},{"$f":"J29-J30","v":549.31382411217783},{"$f":"K29-K30","v":440.98356280377288},{"$f":"L29-L30","v":262.4999100935002},{"$f":"M29-M30","v":0},{"$f":"N29-N30","v":0},{"$f":"O29-O30","v":0},{"$f":"P29-P30","v":0}]
[]
[null,null,"Computed Interest Expense",null,null,null,{"$f":"AVERAGE(G31,G29)*$F$5","v":122.22222222222223},{"$f":"AVERAGE(H31,H29)*$F$5","v":124.93827160493825},123.36899862825786,115.58433165675962,99.029738691595071,70.3483472897273,26.249991009350023,0,0,0,"computed"]
[null,null,"Fixed Interest Expense",null,null,null,122.22222222222223,124.93827160493825,123.36899862825786,115.58433165675962,99.029738691595071,70.3483472897273,26.249991009350012,0,0,0,"fixed"]
[null,null,"Difference",null,{"$f":"SUM(G35:P35)","v":0},null,{"$f":"G33-G34","v":0},{"$f":"H33-H34","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Cash Flow Statement"]
[null,null,"Cash Flow",null,null,null,{"$f":"$F$3","v":100},{"$f":"G38*(1+$F$4)","v":120},{"$f":"H38*(1+$F$4)","v":144},{"$f":"I38*(1+$F$4)","v":172.79999999999998},{"$f":"J38*(1+$F$4)","v":207.35999999999999},{"$f":"K38*(1+$F$4)","v":248.83199999999997},{"$f":"L38*(1+$F$4)","v":298.59839999999997},{"$f":"M38*(1+$F$4)","v":358.31807999999995},{"$f":"N38*(1+$F$4)","v":429.98169599999994},{"$f":"O38*(1+$F$4)","v":515.97803519999991}]
[null,null,"Less: Interest Expense",null,null,null,{"$f":"G34","v":122.22222222222223},{"$f":"H34","v":124.93827160493825},123.36899862825786,115.58433165675962,99.029738691595071,70.3483472897273,26.249991009350012,0,0,0]
[null,null,"Cash Flow After Interest",null,null,null,{"$f":"G38-G39","v":-22.222222222222229},{"$f":"H38-H39","v":-4.9382716049382509},{"$f":"I38-I39","v":20.631001371742144},{"$f":"J38-J39","v":57.215668343240367},{"$f":"K38-K39","v":108.33026130840491},{"$f":"L38-L39","v":178.48365271027268},{"$f":"M38-M39","v":272.34840899064994},{"$f":"N38-N39","v":358.31807999999995},{"$f":"O38-O39","v":429.98169599999994},{"$f":"P38-P39","v":515.97803519999991}]
[null,null,"Less: Repayments",null,null,null,{"$f":"MIN(G40,G29)","v":-22.222222222222229},{"$f":"MIN(H40,H29)","v":-4.9382716049382509},{"$f":"MIN(I40,I29)","v":20.631001371742144},{"$f":"MIN(J40,J29)","v":57.215668343240367},{"$f":"MIN(K40,K29)","v":108.33026130840491},{"$f":"MIN(L40,L29)","v":178.48365271027268},{"$f":"MIN(M40,M29)","v":262.4999100935002},{"$f":"MIN(N40,N29)","v":0},{"$f":"MIN(O40,O29)","v":0},{"$f":"MIN(P40,P29)","v":0}]
[null,null,"Equity Cash Flow",null,null,null,{"$f":"G40-G41","v":0},{"$f":"H40-H41","v":0},{"$f":"I40-I41","v":0},{"$f":"J40-J41","v":0},{"$f":"K40-K41","v":0},{"$f":"L40-L41","v":0},{"$f":"M40-M41","v":9.8484988971497387},{"$f":"N40-N41","v":358.31807999999995},{"$f":"O40-O41","v":429.98169599999994},{"$f":"P40-P41","v":515.97803519999991}]
[]
["Method 3: Function Method"]
[]
[null,"Debt Schedule"]
[null,null,"Opening Balance",null,null,null,{"$f":"F49","v":600},{"$f":"G49","v":622.22222222222217},627.16049382716039,606.52949245541822,549.31382411217783,440.98356280377288,262.4999100935002,0,0,0]
[null,null,"Less: Repayment from Sweep",null,null,null,{"$f":"G58","v":-22.222222222222229},{"$f":"H58","v":-4.9382716049382509},20.631001371742144,57.215668343240367,108.33026130840491,178.48365271027268,262.4999100935002,0,0,0]
[null,null,"Closing Balance",null,null,{"$f":"F14","v":600},{"$f":"G47-G48","v":622.22222222222217},{"$f":"H47-H48","v":627.16049382716039},{"$f":"I47-I48","v":606.52949245541822},{"$f":"J47-J48","v":549.31382411217783},{"$f":"K47-K48","v":440.98356280377288},{"$f":"L47-L48","v":262.4999100935002},{"$f":"M47-M48","v":0},{"$f":"N47-N48","v":0},{"$f":"O47-O48","v":0},{"$f":"P47-P48","v":0}]
[]
[null,null,"Interest Expense on Average Balance",null,null,null,{"$f":"average_interest($F$5,G55,G47)","v":122.22222222222223},{"$f":"average_interest($F$5,H55,H47)","v":124.93827160493825},123.36899862825786,115.58433165675962,99.029738691595071,70.3483472897273,26.249991009350023,0,0,0]
[null,null,"Check",null,null,null,{"$f":"AVERAGE(G49,G47)*$F$5","v":122.22222222222223},{"$f":"AVERAGE(H49,H47)*$F$5","v":124.93827160493825},{"$f":"AVERAGE(I49,I47)*$F$5","v":123.36899862825786},{"$f":"AVERAGE(J49,J47)*$F$5","v":115.58433165675962},99.029738691595071,70.3483472897273,26.249991009350023,0,0,0]
[]
[null,"Cash Flow Statement"]
[null,null,"Cash Flow",null,null,null,{"$f":"$F$3","v":100},{"$f":"G55*(1+$F$4)","v":120},{"$f":"H55*(1+$F$4)","v":144},{"$f":"I55*(1+$F$4)","v":172.79999999999998},{"$f":"J55*(1+$F$4)","v":207.35999999999999},{"$f":"K55*(1+$F$4)","v":248.83199999999997},{"$f":"L55*(1+$F$4)","v":298.59839999999997},{"$f":"M55*(1+$F$4)","v":358.31807999999995},{"$f":"N55*(1+$F$4)","v":429.98169599999994},{"$f":"O55*(1+$F$4)","v":515.97803519999991}]
[null,null,"Less: Interest Expense",null,null,null,{"$f":"G51","v":122.22222222222223},{"$f":"H51","v":124.93827160493825},{"$f":"I51","v":123.36899862825786},{"$f":"J51","v":115.58433165675962},{"$f":"K51","v":99.029738691595071},{"$f":"L51","v":70.3483472897273},{"$f":"M51","v":26.249991009350023},{"$f":"N51","v":0},{"$f":"O51","v":0},{"$f":"P51","v":0}]
[null,null,"Cash Flow After Interest",null,null,null,{"$f":"G55-G56","v":-22.222222222222229},{"$f":"H55-H56","v":-4.9382716049382509},{"$f":"I55-I56","v":20.631001371742144},{"$f":"J55-J56","v":57.215668343240367},{"$f":"K55-K56","v":108.33026130840491},{"$f":"L55-L56","v":178.48365271027268},{"$f":"M55-M56","v":272.34840899064994},{"$f":"N55-N56","v":358.31807999999995},{"$f":"O55-O56","v":429.98169599999994},{"$f":"P55-P56","v":515.97803519999991}]
[null,null,"Less: Repayments",null,null,null,{"$f":"MIN(G57,G47)","v":-22.222222222222229},{"$f":"MIN(H57,H47)","v":-4.9382716049382509},{"$f":"MIN(I57,I47)","v":20.631001371742144},{"$f":"MIN(J57,J47)","v":57.215668343240367},{"$f":"MIN(K57,K47)","v":108.33026130840491},{"$f":"MIN(L57,L47)","v":178.48365271027268},{"$f":"MIN(M57,M47)","v":262.4999100935002},{"$f":"MIN(N57,N47)","v":0},{"$f":"MIN(O57,O47)","v":0},{"$f":"MIN(P57,P47)","v":0}]
[null,null,"Equity Cash Flow",null,null,null,{"$f":"G57-G58","v":0},{"$f":"H57-H58","v":0},{"$f":"I57-I58","v":0},{"$f":"J57-J58","v":0},{"$f":"K57-K58","v":0},{"$f":"L57-L58","v":0},{"$f":"M57-M58","v":9.8484988971497387},{"$f":"N57-N58","v":358.31807999999995},{"$f":"O57-O58","v":429.98169599999994},{"$f":"P57-P58","v":515.97803519999991}]

{"sheet":"Sweep with Taxes Blank","index":2,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions"]
[null,"Cash Flow",null,null,null,100]
[null,"Growth",null,null,null,0.2]
[null,"Interest Rate",null,null,null,0.2]
[null,"Initial Debt",null,null,null,600]
[null,"Opening Balance",null,null,null,true]
[null,"Income Tax Rate",null,null,null,0.3]
[]
["Resolution of Circular Refereces with Function"]
[]
[null,"Debt Schedule"]
[null,null,"Opening Balance",null,null,null,{"$f":"F15","v":600},{"$f":"G15","v":530},446,345.2,224.24,79.088000000000022,0,0,0,0]
[null,null,"Less: Repayment from Sweep",null,null,null,{"$f":"G34","v":70},{"$f":"H34","v":84},100.80000000000001,120.95999999999998,145.15199999999999,79.088000000000022,0,0,0,0]
[null,null,"Closing Balance",null,null,{"$f":"F6","v":600},{"$f":"G13-G14","v":530},{"$f":"H13-H14","v":446},345.2,224.24,79.088000000000022,0,0,0,0,0]
[]
[null,null,"Interest Expense on Average Balance"]
[]
[]
[null,"Cash Flow Statement"]
[null,null,"Cash Flow",null,null,null,{"$f":"$F$3","v":100},{"$f":"G21*(1+$F$4)","v":120},{"$f":"H21*(1+$F$4)","v":144},{"$f":"I21*(1+$F$4)","v":172.79999999999998},{"$f":"J21*(1+$F$4)","v":207.35999999999999},{"$f":"K21*(1+$F$4)","v":248.83199999999997},{"$f":"L21*(1+$F$4)","v":298.59839999999997},{"$f":"M21*(1+$F$4)","v":358.31807999999995},{"$f":"N21*(1+$F$4)","v":429.98169599999994},{"$f":"O21*(1+$F$4)","v":515.97803519999991}]
[null,null,"Less: Interest Expense",null,null,null,{"$f":"G17","v":0},{"$f":"H17","v":0},{"$f":"I17","v":0},{"$f":"J17","v":0},{"$f":"K17","v":0},{"$f":"L17","v":0},{"$f":"M17","v":0},{"$f":"N17","v":0},{"$f":"O17","v":0},{"$f":"P17","v":0}]
[null,null,"EBT before NOL",null,null,null,{"$f":"G21-G22","v":100},{"$f":"H21-H22","v":120},144,172.79999999999998,207.35999999999999,248.83199999999997,298.59839999999997,358.31807999999995,429.98169599999994,515.97803519999991]
[]
[null,null,"NOL Balance"]
[null,null,"Opening Balance",null,null,null,{"$f":"F29","v":0},{"$f":"G29","v":0},0,0,0,0,0,0,0,0]
[null,null,"Add: NOL Created from Losses",null,null,null,{"$f":"MAX(-G23,0)","v":0},{"$f":"MAX(-H23,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Less: NOL Used from Postivie Income",null,null,null,{"$f":"MIN(G26,MAX(G23,0))","v":0},{"$f":"MIN(H26,MAX(H23,0))","v":0},0,0,0,0,0,0,0,0]
[null,null,"Closing NOL Balance",null,null,null,{"$f":"G26+G27-G28","v":0},{"$f":"H26+H27-H28","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Adjusted EBT",null,null,null,{"$f":"G23+G27-G28","v":100},{"$f":"H23+H27-H28","v":120},{"$f":"I23+I27-I28","v":144},172.79999999999998,207.35999999999999,248.83199999999997,298.59839999999997,358.31807999999995,429.98169599999994,515.97803519999991]
[null,null,"Less: Taxes",null,null,null,{"$f":"G31*$F$8","v":30},{"$f":"H31*$F$8","v":36},{"$f":"I31*$F$8","v":43.199999999999996},51.839999999999996,62.207999999999991,74.649599999999992,89.579519999999988,107.49542399999999,128.99450879999998,154.79341055999996]
[null,null,"Cash Flow After Interest",null,null,null,{"$f":"G21-G22-G32","v":70},{"$f":"H21-H22-H32","v":84},100.80000000000001,120.95999999999998,145.15199999999999,174.18239999999997,209.01887999999997,250.82265599999997,300.98718719999999,361.18462463999992]
[null,null,"Less: Repayments",null,null,null,{"$f":"MIN(G33,G13)","v":70},{"$f":"MIN(H33,H13)","v":84},100.80000000000001,120.95999999999998,145.15199999999999,79.088000000000022,0,0,0,0]
[null,null,"Equity Cash Flow",null,null,null,{"$f":"G33-G34","v":0},{"$f":"H33-H34","v":0},0,0,0,95.094399999999951,209.01887999999997,250.82265599999997,300.98718719999999,361.18462463999992]

{"sheet":"Sweep with Taxes Completed","index":3,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions"]
[null,"Cash Flow",null,null,null,100]
[null,"Growth",null,null,null,0.2]
[null,"Interest Rate",null,null,null,0.2]
[null,"Initial Debt",null,null,null,600]
[null,"Opening Balance",null,null,null,true]
[null,"Income Tax Rate",null,null,null,0.3]
[]
["Resolution of Circular Refereces with Function"]
[]
[null,"Debt Schedule"]
[null,null,"Opening Balance",null,null,null,{"$f":"F15","v":600},{"$f":"G15","v":622.22222222222217},627.16049382716039,606.52949245541822,565.66420343083007,494.74053513009483,381.92470170881882,214.66725895530769,0,0]
[null,null,"Less: Repayment from Sweep",null,null,null,{"$f":"G34","v":-22.222222222222229},{"$f":"H34","v":-4.9382716049382509},20.631001371742144,40.865289024588101,70.923668300735244,112.81583342127601,167.25744275351113,214.66725895530769,0,0]
[null,null,"Closing Balance",null,null,{"$f":"F6","v":600},{"$f":"G13-G14","v":622.22222222222217},{"$f":"H13-H14","v":627.16049382716039},606.52949245541822,565.66420343083007,494.74053513009483,381.92470170881882,214.66725895530769,0,0,0]
[]
[null,null,"Interest Expense on Average Balance",null,null,null,{"$f":"average_interest_taxes($F$5,G21,G13,$F$8,G26)","v":122.22222222222223},{"$f":"average_interest_taxes($F$5,H21,H13,$F$8,H26)","v":124.93827160493825},123.36899862825786,117.21936958862484,106.04047385609249,87.66652368389137,59.659196066412655,21.466725895530772,0,0]
[null,null,"Check",null,null,null,{"$f":"AVERAGE(G15,G13)*$F$5","v":122.22222222222223},{"$f":"AVERAGE(H15,H13)*$F$5","v":124.93827160493825},123.36899862825786,117.21936958862484,106.04047385609249,87.66652368389137,59.659196066412655,21.466725895530772,0,0]
[]
[null,"Cash Flow Statement"]
[null,null,"Cash Flow",null,null,null,{"$f":"$F$3","v":100},{"$f":"G21*(1+$F$4)","v":120},{"$f":"H21*(1+$F$4)","v":144},{"$f":"I21*(1+$F$4)","v":172.79999999999998},{"$f":"J21*(1+$F$4)","v":207.35999999999999},{"$f":"K21*(1+$F$4)","v":248.83199999999997},{"$f":"L21*(1+$F$4)","v":298.59839999999997},{"$f":"M21*(1+$F$4)","v":358.31807999999995},{"$f":"N21*(1+$F$4)","v":429.98169599999994},{"$f":"O21*(1+$F$4)","v":515.97803519999991}]
[null,null,"Less: Interest Expense",null,null,null,{"$f":"G17","v":122.22222222222223},{"$f":"H17","v":124.93827160493825},{"$f":"I17","v":123.36899862825786},{"$f":"J17","v":117.21936958862484},{"$f":"K17","v":106.04047385609249},{"$f":"L17","v":87.66652368389137},{"$f":"M17","v":59.659196066412655},{"$f":"N17","v":21.466725895530772},{"$f":"O17","v":0},{"$f":"P17","v":0}]
[null,null,"EBT before NOL",null,null,null,{"$f":"G21-G22","v":-22.222222222222229},{"$f":"H21-H22","v":-4.9382716049382509},20.631001371742144,55.580630411375139,101.3195261439075,161.1654763161086,238.93920393358732,336.85135410446918,429.98169599999994,515.97803519999991]
[]
[null,null,"NOL Balance"]
[null,null,"Opening Balance",null,null,null,{"$f":"F29","v":0},{"$f":"G29","v":22.222222222222229},27.160493827160479,6.5294924554183353,0,0,0,0,0,0]
[null,null,"Add: NOL Created from Losses",null,null,null,{"$f":"MAX(-G23,0)","v":22.222222222222229},{"$f":"MAX(-H23,0)","v":4.9382716049382509},0,0,0,0,0,0,0,0]
[null,null,"Less: NOL Used from Postivie Income",null,null,null,{"$f":"MIN(G26,MAX(G23,0))","v":0},{"$f":"MIN(H26,MAX(H23,0))","v":0},20.631001371742144,6.5294924554183353,0,0,0,0,0,0]
[null,null,"Closing NOL Balance",null,null,null,{"$f":"G26+G27-G28","v":22.222222222222229},{"$f":"H26+H27-H28","v":27.160493827160479},6.5294924554183353,0,0,0,0,0,0,0]
[]
[null,null,"Adjusted EBT",null,null,null,{"$f":"G23+G27-G28","v":0},{"$f":"H23+H27-H28","v":0},{"$f":"I23+I27-I28","v":0},49.051137955956804,101.3195261439075,161.1654763161086,238.93920393358732,336.85135410446918,429.98169599999994,515.97803519999991]
[null,null,"Less: Taxes",null,null,null,{"$f":"G31*$F$8","v":0},{"$f":"H31*$F$8","v":0},{"$f":"I31*$F$8","v":0},14.71534138678704,30.395857843172248,48.349642894832577,71.681761180076194,101.05540623134075,128.99450879999998,154.79341055999996]
[null,null,"Cash Flow After Interest",null,null,null,{"$f":"G21-G22-G32","v":-22.222222222222229},{"$f":"H21-H22-H32","v":-4.9382716049382509},20.631001371742144,40.865289024588101,70.923668300735244,112.81583342127601,167.25744275351113,235.79594787312843,300.98718719999999,361.18462463999992]
[null,null,"Less: Repayments",null,null,null,{"$f":"MIN(G33,G13)","v":-22.222222222222229},{"$f":"MIN(H33,H13)","v":-4.9382716049382509},20.631001371742144,40.865289024588101,70.923668300735244,112.81583342127601,167.25744275351113,214.66725895530769,0,0]
[null,null,"Equity Cash Flow",null,null,null,{"$f":"G33-G34","v":0},{"$f":"H33-H34","v":0},0,0,0,0,0,21.128688917820739,300.98718719999999,361.18462463999992]

{"sheet":"Sheet2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}