{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Menu","Intro","Show Formula","Sheet Name Function","Short Cuts","Vintage Depreciation","Stable Deferred Taxes","Comprehensive Deferred Tax","Dates Allocate"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":36,"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":"Menu","index":0,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Sheet Tab","Description","Author"]
[null,1,"Menu"]
[null,2,"Intro"]
[null,3,"Show Formula"]
[null,4,"Sheet Name Function"]
[null,5,"Short Cuts"]
[null,6,"Vintage Depreciation"]
[null,7,"Implied Historic Growth"]
[null,8,"Starting Capital Expenditure"]
[null,9,"Net Plant Depreciation Rate"]
[null,10,"Simple Cap Exp to Depreciation"]
[null,11,"Comprehensive Cap Exp to Dep"]
[null,12,"Stable Deferred Taxes"]
[null,13,"Comprehensive Deferred Tax"]
[null,14,"Dates Allocate"]
[]
[null," File Name: ",null,"C:\\Users\\Monika\\Documents\\Courses\\Chapter 1. Models and Analysis\\1. Corporate Model Templates and Exercises\\DCF, Multiples and Depreciation\\Depreciation\\Depreciation Functions.xlsm"]
[]
[null," Colour Codes "]
[]
[null," Last Save Date ",null,"2014-12-02T10:30:09"]
[null," Last Save By",null,"Winston Churchill"]

{"sheet":"Intro","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"User defined functions can solve many problems in excel in a much better manner than macros"]
[]
[null,null,"Functions cannot refer to ranges in the excel sheet"]
[null,null,"Data must be entered as arguments"]
[null,null,"Can have a turn off switch"]
[null,null,"Cannot fix cells"]
[]
[null,"Common Problems when Writing Functions"]
[null,null,"When you read in a variable is not named correctly, you get VALUE"]
[null,null,"You must be careful about using scalars and array inputs to the function"]
[null,null,"Can test using EXIT FUNCTION"]
[]
[]
[null,null,"A user-defined function called by a formula in a worksheet cell cannot change the environment of Microsoft Excel. This means that such a function cannot do any of the following: •Insert, delete, or format cells on the spreadsheet."]
[null,null,"•Change another cell's value.",null,null,null,null," "]
[null,null,"•Move, rename, delete, or add sheets to a workbook."]
[null,null,"•Change any of the environment options, such as calculation mode or screen views."]
[null,null,"•Add names to a workbook."]
[null,null,"•Set properties or execute most methods. "]
[]
[null,"What does work"]
[null,null,"Read in All of the Values"]
[null,null,"Change a Range of Cells with and Array Function"]
[]
[]
[null,"Basics"]
[null,null,"Compute a variable defined as the function name; when you change a function don't forget to change the varible"]
[null,null,"Use the F5 key after error"]
[]
[null,"Some Hints"]
[null,null,"Use Msgbox and CHR(13) to debug; if you are like me you make spelling mistakes"]
[]
[]
[null,"Fancy Stuff"]
[null,null,"You can make an array that goes sideways or up and down"]
[]
[]
[]
[]
[null,"Copying the functions into financial models"]
[null,null,"Method 1: Open VBA and Copy and Paste"]
[null,null,"Method 2: Save as XLA and Open as Excel Adder"]

{"sheet":"Show Formula","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"The Simplest Function"]
[]
[]
[null,null,null,1]
[null,null,null,1]
[]
[null,null,null,{"$f":"SUM(D6:D8)","v":2},null,{"$f":"show_form(D9)","v":"=SUM(D6:D8)"},null,null,null,{"$f":"show_form(F9)","v":"=show_form(D9)"}]
[]
[null,null,null,{"$f":"D6+D7","v":2},null,{"$f":"show_formula(D11)","v":"< ---- Formula for: $D$11  =D6+D7"},null,null,null,{"$f":"show_formula(F11)","v":"< ---- Formula for: $F$11  =show_formula(D11)"}]
[]
[]
[]
[]
[null,null,null,null,"Function must define the function name in the body"]

{"sheet":"Sheet Name Function","index":3,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"This function finds the name of a sheet"]
[]
[]
[null,null,{"$f":"sheet_name(F6)","v":"Sheet Name Function"},null,null,{"$f":"show_formula(C6)","v":"< ---- Formula for: $C$6  =sheet_name(F6)"}]
[]
[null,null,{"$f":"sheet_name('Short Cuts'!D9)","v":"Short Cuts"},null,null,{"$f":"show_formula(C8)","v":"< ---- Formula for: $C$8  =sheet_name('Short Cuts'!D9)"}]

{"sheet":"Short Cuts","index":4,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Input",null,0.1111,"SHIFT, CNTL, D"]
[null,"Input 1",null,0.1]
[null,"Calculation",null,{"$f":"SUM(D4:D5)","v":0.21110000000000001}]
[]
[]
[null,"Switch",null,true,true,true,true,false,false,false,false]
[]
[null,null,null,"SHIFT, CNTL, T",null,null,null,"SHIFT, CNTL, F"]
[]
[]
[null,"Input",null,0.1]
[null,"Input",null,20,"SHIFT, CNTL X"]
[null,"Input",null,100]
[]
[null,null,null,10]
[]
[]
["Title 1"]
[]
[]
["Title 2"]
[]
[]
[null,"SHIFT, CNTL, M to make a title"]

{"sheet":"Vintage Depreciation","index":5,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"requires SHIFT, CNTL, Enter",null,null,null,null,null,{"$f":"f(J34)","v":"=depreciation(J14:T14,J17:P17)"}]
[]
[null,"Eliminate the painful matrix"]
[]
[null,"Rules for Array Output"]
[null,"1. Define function as variant"]
[null,"2. use ReDim to define a new array variable"]
[null,"3. Make the function name equal to the new variable"]
[]
[]
[]
[null,null,null,null,null,null,null,"Model Year",null,2014,{"$f":"J13+1","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,null,null,null,null,null,null,"Capital Expenditure",null,200,{"$f":"J14*1.09","v":218.00000000000003},237.62000000000006,259.00580000000008,282.31632200000013,307.72479098000014,335.42002216820015,365.60782416333819,398.51252833803863,434.37865588846216,473.47273491842378]
[]
[null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,"Check","Factor"]
[null,null,null,null,null,null,null,"Dep Rate",null,{"$f":"VDB(1,0,7,I16,J16,$S$17)","v":0.14285714285714285},{"$f":"VDB(1,0,7,J16,K16,$S$17)","v":0.14285714285714288},0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,null,{"$f":"SUM(J17:P17)","v":1.0000000000000002},1]
[]
[null,null,null,null,null,null,null,"Yr Born","Expenditure"]
[null,null,null,null,null,null,null,{"$f":"TRANSPOSE(J13:T13)","v":2014},{"$f":"TRANSPOSE(J14:T14)","v":200},{"$f":"LOOKUP(J$13-$H20+1,$I$16:$Q$16,$I$17:$Q$17)*$I20","v":28.571428571428569},{"$f":"LOOKUP(K$13-$H20+1,$I$16:$Q$16,$I$17:$Q$17)*$I20","v":28.571428571428577},28.571428571428577,28.571428571428577,28.571428571428577,28.571428571428577,28.571428571428577,0,0,0,0]
[null,null,null,null,null,null,null,2015,218.00000000000003,{"$f":"LOOKUP(J$13-$H21+1,$I$16:$Q$16,$I$17:$Q$17)*$I21","v":0},31.142857142857146,31.142857142857153,31.142857142857153,31.142857142857153,31.142857142857153,31.142857142857153,31.142857142857153,0,0,0]
[null,null,null,null,null,null,null,2016,237.62000000000006,{"$error":"#N/A"},0,33.945714285714295,33.945714285714303,33.945714285714303,33.945714285714303,33.945714285714303,33.945714285714303,33.945714285714303,0,0]
[null,null,null,null,null,null,null,2017,259.00580000000008,{"$error":"#N/A"},{"$error":"#N/A"},0,37.000828571428578,37.000828571428585,37.000828571428585,37.000828571428585,37.000828571428585,37.000828571428585,37.000828571428585,0]
[null,null,null,null,null,null,null,2018,282.31632200000013,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,40.33090314285716,40.330903142857167,40.330903142857167,40.330903142857167,40.330903142857167,40.330903142857167,40.330903142857167]
[null,null,null,null,null,null,null,2019,307.72479098000014,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,43.960684425714305,43.960684425714312,43.960684425714312,43.960684425714312,43.960684425714312,43.960684425714312]
[null,null,null,null,null,null,null,2020,335.42002216820015,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,47.91714602402859,47.917146024028597,47.917146024028597,47.917146024028597,47.917146024028597]
[null,null,null,null,null,null,null,2021,365.60782416333819,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,52.229689166191164,52.229689166191179,52.229689166191179,52.229689166191179]
[null,null,null,null,null,null,null,2022,398.51252833803863,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,56.930361191148371,56.930361191148386,56.930361191148386]
[null,null,null,null,null,null,null,2023,434.37865588846216,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,62.054093698351735,62.054093698351743]
[null,null,null,null,null,null,null,2024,473.47273491842378,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,67.6389621312034]
[]
[null,null,null,null,null,null,null,"Total",null,{"$f":"SUMIF(J20:J30,\"<>#N/A\",J20:J30)","v":28.571428571428569},{"$f":"SUMIF(K20:K30,\"<>#N/A\",K20:K30)","v":59.714285714285722},93.660000000000025,130.6608285714286,170.99173171428578,214.95241614000008,262.86956216402865,286.52782275879127,312.3153268070825,340.42370621971992,371.06183977949479]
[]
[null,null,null,{"$f":"f(J34)","v":"=depreciation(J14:T14,J17:P17)"},null,null,null,null,null,{"$f":"depreciation(J14:T14,J17:P17)","v":0},28.571428298950195,59.714286804199219,93.660003662109375,130.66082763671875,170.99172973632812,214.95240783691406,262.86956787109375,286.52780151367187,312.31533813476562,340.42373657226562]

{"sheet":"Stable Deferred Taxes","index":6,"n_rows":76,"n_cols":104,"rows_kept":76,"cut":false,"hidden":false,"merged":[[66,3,75,3],[64,5,64,9],[63,3,63,9]]}
[]
[null,"Stable Capital Expenditures without Historic Growth"]
[]
[null,"Change in Deferred Tax to Cap Exp",null,null,{"$f":"deferred_tax(E7,E8,E9,E10,E16:AH16)","v":1.4094633425149657E-2},null,{"$f":"show_formulaR(E4)","v":"< ---- =deferred_tax(E7,E8,E9,E10,E16:AH16)"}]
[]
[null,"Assumptions",null,null,null,null,null,"Outputs"]
[null,null,"Growth",null,0.05,null,null,"Change in Deferred Tax/Cap Exp",null,null,null,{"$f":"INDEX(32:32,MATCH(E8,18:18))","v":-1.0229182554696695E-2}]
[null,null,"Book Life",null,10,null,null,"Cap Exp/Depreciation",null,null,null,{"$f":"INDEX(33:33,MATCH(E8,$18:$18))","v":1.2333769044329213}]
[null,null,"Tax Rate",null,0.3]
[null,null,"Timing Code",null,3]
[]
[null,null,"Tax Life",null,10]
[null,null,"Decline Factor",null,2]
[]
[null,null,"Tax Depreciation Year",0,1,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]
[null,null,"Depreciation Rate",null,{"$f":"IF(E15<=$E$12,VDB(1,0,$E$12,D15,E15,$E$13))","v":0.2},{"$f":"IF(F15<=$E$12,VDB(1,0,$E$12,E15,F15,$E$13))","v":0.16000000000000003},0.128,0.1024,8.1920000000000007E-2,6.5536000000000011E-2,6.5536000000000011E-2,6.5536000000000011E-2,6.5536000000000011E-2,6.5536000000000011E-2,false,false,false,false,false,false,false,{"$f":"IF(V15<=$E$12,VDB(1,0,$E$12,U15,V15,$E$13))","v":false},false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,"Period",null,1,{"$f":"D18+1","v":2},{"$f":"E18+1","v":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,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,{"$f":"BQ18+1","v":67},68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101]
[null,"Capital Expenidture",null,100,{"$f":"D19*(1+$E$7)","v":105},{"$f":"E19*(1+$E$7)","v":110.25},115.7625,121.55062500000001,127.62815625000002,134.00956406250003,140.71004226562505,147.74554437890632,155.13282159785163,162.88946267774421,171.03393581163144,179.58563260221302,188.56491423232367,197.99315994393987,207.89281794113688,218.28745883819374,229.20183178010345,240.66192336910862,252.69501953756406,265.32977051444226,278.5962590401644,292.5260719921726,307.15237559178127,322.50999437137034,338.63549408993885,355.56726879443579,373.34563223415762,392.01291384586551,411.61355953815882,432.19423751506679,453.80394939082015,476.49414686036118,500.31885420337926,525.33479691354819,551.60153675922561,579.18161359718692,608.14069427704635,638.54772899089869,670.47511544044369,703.99887121246593,739.19881477308923,776.15875551174372,814.96669328733094,855.71502795169749,898.50077934928242,943.42581831674659,990.59710923258399,1040.1269646942133,1092.1333129289239,1146.7399785753703,1204.0769775041388,1264.2808263793459,1327.4948676983131,1393.8696110832288,1463.5630916373902,1536.7412462192599,1613.578308530223,1694.2572239567342,1778.9700851545708,1867.9185894122995,1961.3145188829146,2059.3802448270603,2162.3492570684134,2270.4667199218343,2383.9900559179259,{"$f":"BQ19*(1+$E$7)","v":2503.1895587138224},2628.3490366495134,2759.7664884819892,2897.7548129060888,3042.6425535513931,3194.7746812289629,3354.5134152904111,3522.2390860549317,3698.3510403576784,3883.2685923755625,4077.4320219943406,4281.3036230940579,4495.3688042487611,4720.1372444611998,4956.1441066842599,5203.9513120184729,5464.1488776193964,5737.3563215003669,6024.2241375753856,6325.4353444541548,6641.707111676863,6973.792467260706,7322.4820906237419,7688.6061951549291,8073.0365049126758,8476.6883301583093,8900.5227466662254,9345.5488839995378,9812.826328199515,10303.467644609491,10818.641026839967,11359.573078181966,11927.551732091064,12523.929318695618,13150.1257846304]
[null,"Plant Balance"]
[null,null,"Opening Balance",null,{"$f":"D24","v":100},{"$f":"E24","v":205},315.25,431.01249999999999,552.56312500000001,680.19128124999997,814.20084531249995,954.91088757812497,1102.6564319570314,1257.7892535548831,1320.6787162326273,1386.7126520442587,1456.0482846464718,1528.8506988787954,1605.2932338227351,1685.5578955138719,1769.8357902895657,1858.327579804044,1951.2439587942463,2048.8061567339587,2151.2464645706568,2258.8087877991898,2371.7492271891492,2490.3366885486066,2614.8535229760373,2745.5961991248391,2882.8760090810811,3027.0198095351352,3178.3708000118922,3337.2893400124872,3504.1538070131119,3679.3614973637673,3863.3295722319563,4056.4960508435543,4259.3208533857323,4472.2868960550186,4695.9012408577692,4930.6963029006583,5177.2311180456918,5436.0926739479764,5707.8973076453758,5993.2921730276448,6292.9567816790277,6607.6046207629788,6937.9848518011277,7284.8840943911846,7649.1282991107446,8031.5847140662827,8433.163949769596,8854.8221472580753,9297.5632546209781,9762.4414173520272,10250.563488219628,10763.09166263061,11301.24624576214,11866.308558050248,12459.623985952763,13082.605185250402,13736.735444512924,14423.572216738572,15144.750827575503,15901.988368954278,16697.087787401993,17531.942176772092,18408.539285610699,{"$f":"BQ24","v":19328.966249891237},20295.414562385798,21310.185290505087,22375.694555030343,23494.47928278186,24669.203246920952,25902.663409266999,27197.796579730348,28557.686408716865,29985.570729152711,31484.849265610344,33059.091728890868,34712.046315335407,36447.64863110218,38270.03106265729,40183.532615790158,42192.709246579667,44302.344708908648,46517.46194435408,48843.335041571787,51285.501793650379,53849.776883332903,56542.265727499551,59369.379013874532,62337.84796456826,65454.740362796678,68727.477380936514,72163.851249983345,75772.043812482516,79560.646003106653,83538.678303262001,87715.6122184251,92101.392829346354,96706.462470813669,101541.78559435435]
[null,null,"Add: Capital Expenditure",{"$f":"D19","v":100},105,110.25,115.7625,121.55062500000001,127.62815625000002,134.00956406250003,140.71004226562505,147.74554437890632,155.13282159785163,162.88946267774421,171.03393581163144,179.58563260221302,188.56491423232367,197.99315994393987,207.89281794113688,218.28745883819374,229.20183178010345,240.66192336910862,252.69501953756406,265.32977051444226,278.5962590401644,292.5260719921726,307.15237559178127,322.50999437137034,338.63549408993885,355.56726879443579,373.34563223415762,392.01291384586551,411.61355953815882,432.19423751506679,453.80394939082015,476.49414686036118,500.31885420337926,525.33479691354819,551.60153675922561,579.18161359718692,608.14069427704635,638.54772899089869,670.47511544044369,703.99887121246593,739.19881477308923,776.15875551174372,814.96669328733094,855.71502795169749,898.50077934928242,943.42581831674659,990.59710923258399,1040.1269646942133,1092.1333129289239,1146.7399785753703,1204.0769775041388,1264.2808263793459,1327.4948676983131,1393.8696110832288,1463.5630916373902,1536.7412462192599,1613.578308530223,1694.2572239567342,1778.9700851545708,1867.9185894122995,1961.3145188829146,2059.3802448270603,2162.3492570684134,{"$f":"BP19","v":2270.4667199218343},2383.9900559179259,2503.1895587138224,2628.3490366495134,2759.7664884819892,2897.7548129060888,3042.6425535513931,3194.7746812289629,3354.5134152904111,3522.2390860549317,3698.3510403576784,3883.2685923755625,4077.4320219943406,4281.3036230940579,4495.3688042487611,4720.1372444611998,4956.1441066842599,5203.9513120184729,5464.1488776193964,5737.3563215003669,6024.2241375753856,6325.4353444541548,6641.707111676863,6973.792467260706,7322.4820906237419,7688.6061951549291,8073.0365049126758,8476.6883301583093,8900.5227466662254,9345.5488839995378,9812.826328199515,10303.467644609491,10818.641026839967,11359.573078181966,11927.551732091064,12523.929318695618,13150.1257846304]
[null,null,"Less: Retirements",null,{"$f":"IF(E18>$E$8,OFFSET(E22,0,-$E$8))","v":false},{"$f":"IF(F18>$E$8,OFFSET(F22,0,-$E$8))","v":false},false,false,false,false,false,false,false,100,105,110.25,115.7625,121.55062500000001,127.62815625000002,134.00956406250003,140.71004226562505,147.74554437890632,155.13282159785163,162.88946267774421,171.03393581163144,179.58563260221302,188.56491423232367,197.99315994393987,207.89281794113688,218.28745883819374,229.20183178010345,240.66192336910862,252.69501953756406,265.32977051444226,278.5962590401644,292.5260719921726,307.15237559178127,322.50999437137034,338.63549408993885,355.56726879443579,373.34563223415762,392.01291384586551,411.61355953815882,432.19423751506679,453.80394939082015,476.49414686036118,500.31885420337926,525.33479691354819,551.60153675922561,579.18161359718692,608.14069427704635,638.54772899089869,670.47511544044369,703.99887121246593,739.19881477308923,776.15875551174372,814.96669328733094,855.71502795169749,898.50077934928242,943.42581831674659,990.59710923258399,1040.1269646942133,1092.1333129289239,1146.7399785753703,1204.0769775041388,1264.2808263793459,1327.4948676983131,1393.8696110832288,1463.5630916373902,{"$f":"IF(BR18>$E$8,OFFSET(BR22,0,-$E$8))","v":1536.7412462192599},1613.578308530223,1694.2572239567342,1778.9700851545708,1867.9185894122995,1961.3145188829146,2059.3802448270603,2162.3492570684134,2270.4667199218343,2383.9900559179259,2503.1895587138224,2628.3490366495134,2759.7664884819892,2897.7548129060888,3042.6425535513931,3194.7746812289629,3354.5134152904111,3522.2390860549317,3698.3510403576784,3883.2685923755625,4077.4320219943406,4281.3036230940579,4495.3688042487611,4720.1372444611998,4956.1441066842599,5203.9513120184729,5464.1488776193964,5737.3563215003669,6024.2241375753856,6325.4353444541548,6641.707111676863,6973.792467260706,7322.4820906237419,7688.6061951549291,8073.0365049126758]
[null,null,"Closing Balance",{"$f":"D21+D22-D23","v":100},{"$f":"E21+E22-E23","v":205},315.25,431.01249999999999,552.56312500000001,680.19128124999997,814.20084531249995,954.91088757812497,1102.6564319570314,1257.7892535548831,1320.6787162326273,1386.7126520442587,1456.0482846464718,1528.8506988787954,1605.2932338227351,1685.5578955138719,1769.8357902895657,1858.327579804044,1951.2439587942463,2048.8061567339587,2151.2464645706568,2258.8087877991898,2371.7492271891492,2490.3366885486066,2614.8535229760373,2745.5961991248391,2882.8760090810811,3027.0198095351352,3178.3708000118922,3337.2893400124872,3504.1538070131119,3679.3614973637673,3863.3295722319563,4056.4960508435543,4259.3208533857323,4472.2868960550186,4695.9012408577692,4930.6963029006583,5177.2311180456918,5436.0926739479764,5707.8973076453758,5993.2921730276448,6292.9567816790277,6607.6046207629788,6937.9848518011277,7284.8840943911846,7649.1282991107446,8031.5847140662827,8433.163949769596,8854.8221472580753,9297.5632546209781,9762.4414173520272,10250.563488219628,10763.09166263061,11301.24624576214,11866.308558050248,12459.623985952763,13082.605185250402,13736.735444512924,14423.572216738572,15144.750827575503,15901.988368954278,16697.087787401993,17531.942176772092,18408.539285610699,{"$f":"BQ21+BQ22-BQ23","v":19328.966249891237},20295.414562385798,21310.185290505087,22375.694555030343,23494.47928278186,24669.203246920952,25902.663409266999,27197.796579730348,28557.686408716865,29985.570729152711,31484.849265610344,33059.091728890868,34712.046315335407,36447.64863110218,38270.03106265729,40183.532615790158,42192.709246579667,44302.344708908648,46517.46194435408,48843.335041571787,51285.501793650379,53849.776883332903,56542.265727499551,59369.379013874532,62337.84796456826,65454.740362796678,68727.477380936514,72163.851249983345,75772.043812482516,79560.646003106653,83538.678303262001,87715.6122184251,92101.392829346354,96706.462470813669,101541.78559435435,106618.87487407208]
[]
[null,"Book Tax Depreciation",null,{"$f":"CHOOSE($E$10,D21*(1/$E$8),AVERAGE(D24,D21)/$E$8,D24/$E$8)","v":10},20.5,31.524999999999999,43.10125,55.2563125,68.019128124999995,81.420084531249998,95.491088757812491,110.26564319570313,125.77892535548831,132.06787162326273,138.67126520442588,145.60482846464717,152.88506988787952,160.5293233822735,168.55578955138719,176.98357902895657,185.83275798040441,195.12439587942464,204.88061567339588,215.12464645706569,225.88087877991899,237.17492271891493,249.03366885486065,261.48535229760375,274.55961991248392,288.28760090810812,302.7019809535135,317.83708000118924,333.72893400124872,350.41538070131116,367.93614973637671,{"$f":"CHOOSE($E$10,AJ21*(1/$E$8),AVERAGE(AJ24,AJ21)/$E$8,AJ24/$E$8)","v":386.33295722319565},405.64960508435541,425.93208533857324,447.22868960550187,469.59012408577689,493.06963029006585,517.72311180456916,543.6092673947976,570.78973076453758,599.3292173027645,629.29567816790279,660.76046207629793,693.79848518011272,728.48840943911841,764.91282991107448,803.15847140662822,843.3163949769596,885.48221472580758,929.75632546209783,976.24414173520267,1025.0563488219627,1076.3091662630609,1130.124624576214,1186.6308558050248,1245.9623985952762,1308.2605185250402,1373.6735444512924,1442.3572216738571,1514.4750827575504,1590.1988368954278,1669.7087787401993,1753.1942176772093,{"$f":"CHOOSE($E$10,BP21*(1/$E$8),AVERAGE(BP24,BP21)/$E$8,BP24/$E$8)","v":1840.85392856107},1932.8966249891237,2029.5414562385799,2131.0185290505087,2237.5694555030341,2349.4479282781858,2466.9203246920952,2590.2663409266997,2719.7796579730348,2855.7686408716863,2998.557072915271,3148.4849265610346,3305.9091728890867,3471.2046315335406,3644.7648631102179,3827.003106265729,4018.3532615790159,4219.270924657967,4430.2344708908649,4651.7461944354081,4884.333504157179,5128.5501793650383,5384.9776883332906,5654.2265727499553,5936.9379013874532,6233.7847964568264,6545.4740362796674,6872.7477380936516,7216.3851249983345,7577.2043812482516,7956.0646003106649,8353.8678303262004,8771.5612218425103,9210.139282934635,9670.6462470813676,10154.178559435435,10661.887487407208]
[null,"Tax Depreciation using Function",null,{"$f":"depreciation(D22:CZ22,$E$16:$AH$16)","v":0},20,37,51.650001525878906,64.472496032714844,75.88812255859375,86.236129760742187,97.101531982421875,108.51021575927734,120.48931884765625,133.06739807128906,139.72076416015625,146.70680236816406,154.04214477539062,161.74424743652344,169.83146667480469,178.32304382324219,187.23918151855469,196.60113525390625,206.43119812011719,216.75276184082031,227.59039306640625,238.96990966796875,250.91842651367187,263.46432495117187,276.63754272460937,290.46942138671875,304.992919921875,320.24252319335937,336.25466918945312,353.06741333007812,370.72076416015625,389.2568359375,408.71966552734375,429.1556396484375,450.61343383789062,473.14407348632812,496.80130004882812,521.641357421875,547.72344970703125,575.109619140625,603.8651123046875,634.058349609375,665.76129150390625,699.04937744140625,734.0018310546875,770.70184326171875,809.2369384765625,849.69879150390625,892.1837158203125,936.79290771484375,983.632568359375,1032.814208984375,1084.4549560546875,1138.6776123046875,1195.6114501953125,1255.3922119140625,1318.1617431640625,1384.06982421875,1453.2733154296875,1525.93701171875,1602.23388671875,1682.3455810546875,1766.462890625,1854.785888671875,1947.5252685546875,2044.9014892578125,2147.146484375,2254.50390625,2367.22900390625,2485.590576171875,2609.8701171875,2740.36328125,2877.381591796875,3021.250732421875,3172.313232421875,3330.92919921875,3497.4755859375,3672.349365234375,3855.966552734375,4048.764892578125,4251.203125,4463.763671875,4686.95166015625,4921.29931640625,5167.3642578125,5425.732421875,5697.01904296875,5981.8701171875,6280.9638671875,6595.01171875,6924.76220703125,7271.00048828125,7634.55029296875,8016.27783203125,8417.091796875,8837.9462890625,9279.84375,9743.8359375,10231.0283203125,10742.580078125]
[]
[null,"Difference",null,{"$f":"D27-D26","v":-10},{"$f":"E27-E26","v":-0.5},5.4750000000000014,8.548751525878906,9.2161835327148438,7.8689944335937554,4.8160452294921896,1.6104432246093836,-1.7554274364257907,-5.2896065078320618,0.99952644802633017,1.0494989557303711,1.1019739035168925,1.1570748875111008,1.2149240542499342,1.2756771234174948,1.3394647942856182,1.4064235381502783,1.4767393744816104,1.5505824467213074,1.6281153837546185,1.7095142864872628,1.7949869490538219,1.8847576588112247,1.9789726535681211,2.0779228121254505,2.1818204786106321,2.2909389683615018,2.4054431921701394,2.5257351882044077,2.6520326287669604,2.7846144237795443,2.923878714304351,3.0700604429883356,3.2235543098642552,3.3847442323887549,3.5539494005512324,3.7316697587622798,3.9182456173058426,4.1141823122336518,4.3198883760874196,4.5358950019229951,4.7626714414722073,5.0008294276083234,5.2508922612935294,5.5134216155690865,5.789013350644268,6.0784670699342769,6.3823965269466498,6.7015010945049198,7.0365822527459159,7.3884266241723253,7.7578601624122712,8.145789791626612,8.5529877284734539,8.9805943902877061,9.4298133187862732,9.9012246390223027,10.3962797674576,10.916093755830389,11.461928961199646,12.035049823322197,12.63680231448825,13.268672947790719,13.931960110804994,{"$f":"BQ27-BQ26","v":14.628643565563834},15.36003301923256,16.127955324491268,16.934450746965922,17.781075628064173,18.670251479779836,19.603776260800259,20.583623276965227,21.61295092518867,22.693659506604035,23.828305860840373,25.020026329663324,26.270954403959422,27.584502124157098,28.963446468645998,30.411630999109093,31.932200342032957,33.529200984135059,35.205465720841858,36.96581224907095,38.814078447461725,40.754733541709356,42.792470218794733,44.932215800046833,47.179070730673629,49.537682470332584,52.014468937598394,54.615363282915496,57.345911720498407,60.2132317205851,63.223966548799581,66.385067219989651,69.704467065364952,73.189690418632381,76.849760877064909,80.692590717791973]
[null,"Change in Deferred Tax",null,{"$f":"D29*$E$9","v":-3},{"$f":"E29*$E$9","v":-0.15},1.6425000000000003,2.5646254577636718,2.7648550598144532,2.3606983300781264,1.4448135688476569,0.48313296738281508,-0.52662823092773714,-1.5868819523496185,0.29985793440789904,0.31484968671911134,0.33059217105506772,0.34712246625333021,0.36447721627498025,0.38270313702524844,0.40183943828568541,0.42192706144508346,0.44302181234448312,0.4651747340163922,0.48843461512638553,0.51285428594617877,0.53849608471614652,0.56542729764336741,0.59369179607043632,0.62337684363763513,0.65454614358318963,0.68728169050845056,0.72163295765104174,0.7577205564613223,0.79560978863008813,0.83538432713386324,0.87716361429130529,0.92101813289650059,0.96706629295927649,1.0154232697166263,1.0661848201653696,1.1195009276286838,1.1754736851917527,1.2342546936700955,1.2959665128262259,1.3607685005768986,1.4288014324416622,1.5002488282824971,1.5752676783880588,1.654026484670726,1.7367040051932803,1.8235401209802831,1.9147189580839949,2.0104503283514759,2.1109746758237748,2.2165279872516974,2.3273580487236813,2.4437369374879836,2.5658963185420363,2.6941783170863118,2.8289439956358819,2.9703673917066906,3.1188839302372799,3.2748281267491164,3.4385786883598937,3.6105149469966591,3.7910406943464747,3.9806018843372155,4.1795880332414983,{"$f":"BQ29*$E$9","v":4.3885930696691497},4.6080099057697677,4.8383865973473803,5.0803352240897768,5.3343226884192516,5.6010754439339507,5.881132878240078,6.1750869830895683,6.4838852775566007,6.8080978519812101,7.1484917582521117,7.5060078988989964,7.8812863211878259,8.2753506372471293,8.6890339405937986,9.1234892997327268,9.5796601026098873,10.058760295240518,10.561639716252557,11.089743674721285,11.644223534238517,12.226420062512807,12.83774106563842,13.47966474001405,14.153721219202088,14.861304741099774,15.604340681279517,16.384608984874649,17.203773516149521,18.063969516175529,18.967189964639875,19.915520165996895,20.911340119609484,21.956907125589712,23.054928263119471,24.20777721533759]
[]
[null,"Deferred Tax/Cap Exp",null,{"$f":"D30/D19","v":-0.03},-1.4285714285714286E-3,1.4897959183673473E-2,2.2154198965672577E-2,2.2746531001502073E-2,1.8496689127546071E-2,1.0781421303436355E-2,3.4335357988933154E-3,-3.5644271584742561E-3,-1.0229182554696695E-2,1.8408676011236484E-3,1.8408609100001748E-3,1.8408609100001791E-3,1.8408645514279172E-3,1.8408576153750916E-3,1.8408675240219586E-3,1.8408727666922456E-3,1.8408537932187246E-3,1.8408471358595875E-3,1.8408543819647472E-3,1.840858695122564E-3,1.8408513011376872E-3,1.8408481714086516E-3,1.8408690362689711E-3,1.8408477455951336E-3,1.8408490973839597E-3,1.8408503848018772E-3,1.8408724548232996E-3,1.8408397584952485E-3,1.8408542160552354E-3,1.8408616301885613E-3,1.8408485167554648E-3,{"$f":"AJ30/AJ19","v":1.8408696519589404E-3},1.8408623324079395E-3,1.8408571041571835E-3,1.8408637432057394E-3,1.8408471455844365E-3,1.8408584364832535E-3,1.8408548520709043E-3,1.8408657759942334E-3,1.8408644755271274E-3,1.8408694296873456E-3,1.840862352315555E-3,1.840871339454308E-3,1.8408788287366362E-3,1.8408737339867583E-3,1.8408485028445531E-3,1.8408494270622095E-3,1.8408511874768124E-3,1.8408469960134949E-3,1.8408485927614579E-3,1.8408523945422572E-3,1.840855291137161E-3,1.8408635671225419E-3,1.8408438623954081E-3,1.8408351047389056E-3,1.8408720417934644E-3,1.8408572896671748E-3,1.8408562089252901E-3,1.8408562089252747E-3,1.8408611102487976E-3,1.8408648445905874E-3,1.8408648445905789E-3,1.8408690785381649E-3,{"$f":"BP30/BP19","v":1.8408497233491224E-3},1.8408604762318844E-3,1.8408553558115009E-3,1.8408462992856958E-3,1.8408569149936367E-3,1.8408468047956023E-3,1.8408588407456332E-3,1.8408599870266061E-3,1.8408294195344486E-3,1.8408418960618735E-3,1.8408468470647878E-3,1.8408440179202416E-3,1.8408664714482921E-3,1.8408613392133339E-3,1.8408613392133142E-3,1.8408434947076726E-3,1.8408442336105694E-3,1.8408435298934791E-3,1.8408649765090017E-3,1.8408547638349574E-3,1.8408584112185203E-3,1.8408572533189554E-3,1.8408550477959792E-3,1.8408550477959755E-3,1.8408600489818103E-3,1.8408695750500568E-3,1.8408568736257096E-3,1.8408534174557875E-3,1.8408591777389321E-3,1.840852124330975E-3,1.8408528707233279E-3,1.8408550032729049E-3,1.8408522952733603E-3,1.8408561638441629E-3,1.8408561638441423E-3,1.8408701994751173E-3,1.8408779970478417E-3]
[null,"Cap Exp/Depreciation",null,null,{"$f":"E22/E26","v":5.1219512195121952},3.4972244250594766,2.6858269771758359,2.1997599821739824,1.876356839144651,1.6459030328206743,1.4735410821683925,1.3399055235789321,1.2333769044329213,1.233376904432921,1.233376904432921,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.233376904432921,1.2333769044329213,1.2333769044329213,1.2333769044329215,1.233376904432921,1.2333769044329213,1.2333769044329213,1.2333769044329215,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329215,1.233376904432921,{"$f":"AK22/AK26","v":1.2333769044329213},1.233376904432921,1.233376904432921,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329215,1.2333769044329213,1.2333769044329213,1.233376904432921,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329215,1.2333769044329217,1.2333769044329217,1.2333769044329219,1.2333769044329219,1.2333769044329219,1.2333769044329217,1.2333769044329217,1.2333769044329217,1.2333769044329215,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,{"$f":"BQ22/BQ26","v":1.233376904432921},1.233376904432921,1.233376904432921,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329215,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329215,1.2333769044329215,1.2333769044329215,1.2333769044329215,1.2333769044329213,1.2333769044329215,1.2333769044329215,1.2333769044329215,1.2333769044329215,1.2333769044329215,1.2333769044329213,1.2333769044329215,1.2333769044329213,1.2333769044329215,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.2333769044329213,1.233376904432921,1.233376904432921,1.2333769044329213,1.2333769044329213,1.2333769044329215,1.2333769044329213]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,1,{"$f":"G39+1","v":2},{"$f":"H39+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,1,{"$f":"TRANSPOSE(D19:W19)","v":100},null,{"$f":"LOOKUP(G$39-$D40+1,$E$15:$AH$15,$E$16:$AH$16)*$E40","v":20},{"$f":"LOOKUP(H$39-$D40+1,$E$15:$AH$15,$E$16:$AH$16)*$E40","v":16.000000000000004},12.8,10.24,8.1920000000000002,6.5536000000000012,6.5536000000000012,6.5536000000000012,6.5536000000000012,6.5536000000000012,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D40+1","v":2},105,null,{"$error":"#N/A"},21,16.800000000000004,13.44,10.752000000000001,8.6016000000000012,6.8812800000000012,6.8812800000000012,6.8812800000000012,6.8812800000000012,6.8812800000000012,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D41+1","v":3},110.25,null,{"$error":"#N/A"},{"$error":"#N/A"},22.05,17.640000000000004,14.112,11.2896,9.0316800000000015,7.2253440000000015,7.2253440000000015,7.2253440000000015,7.2253440000000015,7.2253440000000015,0,0,0,0,0,0,0,0]
[null,null,null,4,115.7625,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},23.152500000000003,18.522000000000006,14.817600000000001,11.854080000000002,9.4832640000000001,7.5866112000000019,7.5866112000000019,7.5866112000000019,7.5866112000000019,7.5866112000000019,0,0,0,0,0,0,0]
[null,null,null,5,121.55062500000001,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},24.310125000000003,19.448100000000007,15.558480000000001,12.446784000000001,9.9574272000000015,7.9659417600000024,7.9659417600000024,7.9659417600000024,7.9659417600000024,7.9659417600000024,0,0,0,0,0,0]
[null,null,null,6,127.62815625000002,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},25.525631250000004,20.420505000000006,16.336404000000002,13.069123200000002,10.455298560000003,8.3642388480000029,8.3642388480000029,8.3642388480000029,8.3642388480000029,8.3642388480000029,0,0,0,0,0]
[null,null,null,7,134.00956406250003,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},26.801912812500007,21.44153025000001,17.153224200000004,13.722579360000005,10.978063488000004,8.782450790400004,8.782450790400004,8.782450790400004,8.782450790400004,8.782450790400004,0,0,0,0]
[null,null,null,8,140.71004226562505,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},28.142008453125012,22.513606762500011,18.010885410000007,14.408708328000007,11.526966662400005,9.2215733299200053,9.2215733299200053,9.2215733299200053,9.2215733299200053,9.2215733299200053,0,0,0]
[null,null,null,9,147.74554437890632,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},29.549108875781265,23.639287100625015,18.91142968050001,15.129143744400007,12.103314995520007,9.6826519964160056,9.6826519964160056,9.6826519964160056,9.6826519964160056,9.6826519964160056,0,0]
[null,null,null,10,155.13282159785163,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},31.026564319570326,24.821251455656267,19.857001164525009,15.885600931620008,12.708480745296006,10.166784596236806,10.166784596236806,10.166784596236806,10.166784596236806,10.166784596236806,0]
[null,null,null,11,162.88946267774421,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},32.577892535548841,26.062314028439079,20.849851222751258,16.679880978201009,13.343904782560806,10.675123826048646,10.675123826048646,10.675123826048646,10.675123826048646,10.675123826048646]
[null,null,null,12,171.03393581163144,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},34.206787162326286,27.365429729861035,21.892343783888826,17.513875027111059,14.011100021688849,11.208880017351079,11.208880017351079,11.208880017351079,11.208880017351079]
[null,null,null,13,179.58563260221302,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},35.917126520442608,28.733701216354088,22.986960973083267,18.389568778466614,14.711655022773293,11.769324018218635,11.769324018218635,11.769324018218635]
[null,null,null,14,188.56491423232367,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"LOOKUP(P$39-$D53+1,$E$15:$AH$15,$E$16:$AH$16)*$E53","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},37.712982846464733,30.170386277171794,24.136309021737432,19.309047217389946,15.447237773911956,12.357790219129566,12.357790219129566]
[null,null,null,15,197.99315994393987,null,{"$error":"#N/A"},{"$f":"LOOKUP(H$39-$D54+1,$E$15:$AH$15,$E$16:$AH$16)*$E54","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},39.598631988787979,31.678905591030386,25.343124472824304,20.274499578259444,16.219599662607557,12.975679730086046]
[null,null,null,16,207.89281794113688,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},41.578563588227382,33.262850870581907,26.610280696465523,21.288224557172416,17.030579645737934]
[null,null,null,17,218.28745883819374,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},43.657491767638753,34.925993414111005,27.940794731288801,22.35263578503104]
[null,null,null,18,229.20183178010345,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},45.840366356020695,36.672293084816559,29.337834467853241]
[null,null,null,19,240.66192336910862,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},48.132384673821726,38.505907739057385]
[null,null,null,20,252.69501953756406,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},50.539003907512814]
[]
[null,null,null,null,null,null,{"$f":"SUMIF(G40:G59,\"<>#N/A\",G40:G59)","v":20},{"$f":"SUMIF(H40:H59,\"<>#N/A\",H40:H59)","v":37},51.650000000000006,64.472500000000011,75.888125000000016,86.236131250000014,97.101537812500027,108.51021470312503,120.48932543828127,133.06739171019535,139.72076129570513,146.70679936049038,154.04213932851493,161.74424629494069,169.83145860968773,178.32303154017211,187.23918311718074,196.60114227303978,206.43119938669179,216.75275935602636]
[]
[null,null,null,"Book Life",{"$f":"E8","v":10},"Growth",{"$f":"E7","v":0.05},"Tax Rate",null,{"$f":"E9","v":0.3}]
[null,null,null,"Stable Ratio of Deferred Tax Increase to Capital Expenditure"]
[null,null,null,null,null,"Declining Balance Factor"]
[null,null,null,null,null,1,{"$f":"F66+0.5","v":1.5},{"$f":"G66+0.5","v":2},{"$f":"H66+0.5","v":2.5},{"$f":"I66+0.5","v":3},null,null,"row_start",{"$f":"ROW(F67)","v":67}]
[null,null,null,"Tax Life",1,0.10372019072055183,0.10372019072055183,0.10372019072055183,0.10372019072055183,0.10372019072055183,null,null,"row_end",{"$f":"ROW(F76)","v":76}]
[null,null,null,null,2,9.657732443397854E-2,0.10014876663489665,0.10372019072055183,0.10372019072055183,0.10372019072055183,null,null,"column_start",{"$f":"COLUMN(F67)","v":6}]
[null,null,null,null,4,8.2963776806925418E-2,8.6946218093084934E-2,9.155626266327957E-2,9.5766467150194573E-2,9.9095961899486953E-2,null,null,"column_end",{"$f":"COLUMN(J67)","v":10},null,null,"db_fac"]
[null,null,null,null,6,7.0194001896390912E-2,7.4762834243431261E-2,8.0711814126935288E-2,8.6075888401118336E-2,9.0417700273183133E-2,null,null,"row_input","db_fac",null,null,"def_tax_ratio"]
[null,null,null,null,8,5.8209179443657694E-2,6.3558362971716409E-2,7.0578679504602365E-2,7.7003547345145001E-2,8.2324797137773423E-2,null,null,"col_input","tax_life",null,null,"tax_life"]
[null,null,null,null,10,4.6954836853110429E-2,5.2949992541810167E-2,6.104947151766163E-2,6.8443904460473784E-2,7.4653182556946515E-2,null,null,"output","def_tax_ratio"]
[null,null,null,null,14,2.6439627665329809E-2,3.3609558154712976E-2,4.3588912310075958E-2,5.2740380834505496E-2,6.0437864010789245E-2]
[null,null,null,null,16,1.7088782557148199E-2,2.4780794924028616E-2,3.5578415505711877E-2,4.5481721787315889E-2,5.3838238228809558E-2]
[null,null,null,null,18,8.2879349466311938E-3,1.6438227234987158E-2,2.8003300930486211E-2,3.8584933232315217E-2,4.7537115749307302E-2,null,null,"1. For Next Loops"]
[null,null,null,null,20,2.8905714077362107E-9,8.6205130586704693E-3,2.0834348665300984E-2,3.2027606589265296E-2,4.1538989157487875E-2,null,null,"2. Cell function in VBA"]

{"sheet":"Comprehensive Deferred Tax","index":7,"n_rows":76,"n_cols":104,"rows_kept":76,"cut":false,"hidden":false,"merged":[[63,3,63,9],[64,5,64,9],[66,3,75,3]]}
[]
[null,"Stable Capital Expenditures without Historic Growth"]
[]
[null,"Change in Deferred Tax to Cap Exp"]
[]
[null,"Assumptions",null,null,null,null,null,null,"Historic Growth",null,0.2,null,{"$f":"deferred_tax(E7,E8,E9,E10,E16:AH16)","v":6.1049470093946914E-2},null,{"$f":"show_formulaR(M6)","v":"< ---- =deferred_tax(E7,E8,E9,E10,E16:AH16)"}]
[null,null,"Growth",null,0.05,null,null,null,"Projected Growth",null,{"$f":"E7","v":0.05}]
[null,null,"Book Life",null,20,null,null,null,"Life",null,20,null,{"$f":"stable_deftax(K6,K7,K8,E9,K10,E16:AH16)","v":6.104946483312728E-2},null,{"$f":"show_formulaR(M8)","v":"< ---- =stable_deftax(K6,K7,K8,E9,K10,E16:AH16)"}]
[null,null,"Tax Rate",null,0.3,null,null,null,"WACC",null,0.1]
[null,null,"Timing Code",null,3,null,null,null,"Timing Code",null,{"$f":"E10","v":3}]
[]
[null,null,"Tax Life",null,10]
[null,null,"Decline Factor",null,2]
[]
[null,null,"Tax Depreciation Year",0,1,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]
[null,null,"Depreciation Rate",null,{"$f":"IF(E15<=$E$12,VDB(1,0,$E$12,D15,E15,$E$13))","v":0.2},{"$f":"IF(F15<=$E$12,VDB(1,0,$E$12,E15,F15,$E$13))","v":0.16000000000000003},0.128,0.1024,8.1920000000000007E-2,6.5536000000000011E-2,6.5536000000000011E-2,6.5536000000000011E-2,6.5536000000000011E-2,6.5536000000000011E-2,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,"Period",null,1,{"$f":"D18+1","v":2},{"$f":"E18+1","v":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,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,{"$f":"BQ18+1","v":67},68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101]
[null,"Capital Expenidture",null,100,{"$f":"D19*(1+$E$7)","v":105},{"$f":"E19*(1+$E$7)","v":110.25},115.7625,121.55062500000001,127.62815625000002,134.00956406250003,140.71004226562505,147.74554437890632,155.13282159785163,162.88946267774421,171.03393581163144,179.58563260221302,188.56491423232367,197.99315994393987,207.89281794113688,218.28745883819374,229.20183178010345,240.66192336910862,252.69501953756406,265.32977051444226,278.5962590401644,292.5260719921726,307.15237559178127,322.50999437137034,338.63549408993885,355.56726879443579,373.34563223415762,392.01291384586551,411.61355953815882,432.19423751506679,453.80394939082015,476.49414686036118,500.31885420337926,525.33479691354819,551.60153675922561,579.18161359718692,608.14069427704635,638.54772899089869,670.47511544044369,703.99887121246593,739.19881477308923,776.15875551174372,814.96669328733094,855.71502795169749,898.50077934928242,943.42581831674659,990.59710923258399,1040.1269646942133,1092.1333129289239,1146.7399785753703,1204.0769775041388,1264.2808263793459,1327.4948676983131,1393.8696110832288,1463.5630916373902,1536.7412462192599,1613.578308530223,1694.2572239567342,1778.9700851545708,1867.9185894122995,1961.3145188829146,2059.3802448270603,2162.3492570684134,2270.4667199218343,2383.9900559179259,{"$f":"BQ19*(1+$E$7)","v":2503.1895587138224},2628.3490366495134,2759.7664884819892,2897.7548129060888,3042.6425535513931,3194.7746812289629,3354.5134152904111,3522.2390860549317,3698.3510403576784,3883.2685923755625,4077.4320219943406,4281.3036230940579,4495.3688042487611,4720.1372444611998,4956.1441066842599,5203.9513120184729,5464.1488776193964,5737.3563215003669,6024.2241375753856,6325.4353444541548,6641.707111676863,6973.792467260706,7322.4820906237419,7688.6061951549291,8073.0365049126758,8476.6883301583093,8900.5227466662254,9345.5488839995378,9812.826328199515,10303.467644609491,10818.641026839967,11359.573078181966,11927.551732091064,12523.929318695618,13150.1257846304]
[null,"Plant Balance"]
[null,null,"Opening Balance",null,{"$f":"D24","v":100},{"$f":"E24","v":205},315.25,431.01249999999999,552.56312500000001,680.19128124999997,814.20084531249995,954.91088757812497,1102.6564319570314,1257.7892535548831,1420.6787162326273,1591.7126520442587,1771.2982846464718,1959.8631988787954,2157.8563588227353,2365.7491767638721,2584.0366356020659,2813.2384673821693,3053.9003907512779,3306.5954102888418,3471.9251808032841,3645.5214398434487,3827.7975118356212,4019.1873874274024,4220.1467567987729,4431.1540946387122,4652.7117993706479,4885.3473893391811,5129.6147588061394,5386.0954967464459,5655.4002715837678,5938.1702851629561,6235.0787994211041,6546.83273939216,6874.1743763617687,7217.8830951798573,7578.7772499388502,7957.7161124357935,8355.601918057584,8773.3820139604632,9212.0511146584886,9672.6536703914135,10156.286353910984,10664.100671606535,11197.305705186862,11757.170990446206,12345.029539968516,12962.281016966943,13610.395067815291,14290.914821206055,15005.460562266358,15755.733590379677,16543.520269898661,17370.696283393594,18239.231097563275,19151.192652441438,20108.75228506351,21114.189899316691,22169.899394282525,23278.394363996653,24442.314082196488,25664.429786306315,26947.651275621633,28295.033839402717,29709.785531372854,{"$f":"BQ24","v":31195.274807941496},32755.038548338569,34392.790475755501,36112.429999543274,37918.051499520436,39813.954074496454,41804.651778221276,43894.884367132341,46089.628585488965,48394.110014763413,50813.815515501585,53354.506291276666,56022.231605840498,58823.34318613253,61764.510345439157,64852.735862711117,68095.372655846688,71500.141288639032,75075.148353070981,78828.905770724523,82770.351059260749,86908.868612223785,91254.312042834979,95817.027644976741,100607.87902722559,105638.27297858686,110920.1866275162,116466.19595889201,122289.50575683662,128403.98104467844,134824.18009691237,141565.38910175799,148643.65855684591,156075.84148468822,163879.63355892265]
[null,null,"Add: Capital Expenditure",{"$f":"D19","v":100},105,110.25,115.7625,121.55062500000001,127.62815625000002,134.00956406250003,140.71004226562505,147.74554437890632,155.13282159785163,162.88946267774421,171.03393581163144,179.58563260221302,188.56491423232367,197.99315994393987,207.89281794113688,218.28745883819374,229.20183178010345,240.66192336910862,252.69501953756406,265.32977051444226,278.5962590401644,292.5260719921726,307.15237559178127,322.50999437137034,338.63549408993885,355.56726879443579,373.34563223415762,392.01291384586551,411.61355953815882,432.19423751506679,453.80394939082015,476.49414686036118,500.31885420337926,525.33479691354819,551.60153675922561,579.18161359718692,608.14069427704635,638.54772899089869,670.47511544044369,703.99887121246593,739.19881477308923,776.15875551174372,814.96669328733094,855.71502795169749,898.50077934928242,943.42581831674659,990.59710923258399,1040.1269646942133,1092.1333129289239,1146.7399785753703,1204.0769775041388,1264.2808263793459,1327.4948676983131,1393.8696110832288,1463.5630916373902,1536.7412462192599,1613.578308530223,1694.2572239567342,1778.9700851545708,1867.9185894122995,1961.3145188829146,2059.3802448270603,2162.3492570684134,{"$f":"BP19","v":2270.4667199218343},2383.9900559179259,2503.1895587138224,2628.3490366495134,2759.7664884819892,2897.7548129060888,3042.6425535513931,3194.7746812289629,3354.5134152904111,3522.2390860549317,3698.3510403576784,3883.2685923755625,4077.4320219943406,4281.3036230940579,4495.3688042487611,4720.1372444611998,4956.1441066842599,5203.9513120184729,5464.1488776193964,5737.3563215003669,6024.2241375753856,6325.4353444541548,6641.707111676863,6973.792467260706,7322.4820906237419,7688.6061951549291,8073.0365049126758,8476.6883301583093,8900.5227466662254,9345.5488839995378,9812.826328199515,10303.467644609491,10818.641026839967,11359.573078181966,11927.551732091064,12523.929318695618,13150.1257846304]
[null,null,"Less: Retirements",null,{"$f":"IF(E18>$E$8,OFFSET(E22,0,-$E$8))","v":false},{"$f":"IF(F18>$E$8,OFFSET(F22,0,-$E$8))","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,100,105,110.25,115.7625,121.55062500000001,127.62815625000002,134.00956406250003,140.71004226562505,147.74554437890632,155.13282159785163,162.88946267774421,171.03393581163144,179.58563260221302,188.56491423232367,197.99315994393987,207.89281794113688,218.28745883819374,229.20183178010345,240.66192336910862,252.69501953756406,265.32977051444226,278.5962590401644,292.5260719921726,307.15237559178127,322.50999437137034,338.63549408993885,355.56726879443579,373.34563223415762,392.01291384586551,411.61355953815882,432.19423751506679,453.80394939082015,476.49414686036118,500.31885420337926,525.33479691354819,551.60153675922561,579.18161359718692,608.14069427704635,638.54772899089869,670.47511544044369,703.99887121246593,739.19881477308923,776.15875551174372,814.96669328733094,855.71502795169749,898.50077934928242,{"$f":"IF(BR18>$E$8,OFFSET(BR22,0,-$E$8))","v":943.42581831674659},990.59710923258399,1040.1269646942133,1092.1333129289239,1146.7399785753703,1204.0769775041388,1264.2808263793459,1327.4948676983131,1393.8696110832288,1463.5630916373902,1536.7412462192599,1613.578308530223,1694.2572239567342,1778.9700851545708,1867.9185894122995,1961.3145188829146,2059.3802448270603,2162.3492570684134,2270.4667199218343,2383.9900559179259,2503.1895587138224,2628.3490366495134,2759.7664884819892,2897.7548129060888,3042.6425535513931,3194.7746812289629,3354.5134152904111,3522.2390860549317,3698.3510403576784,3883.2685923755625,4077.4320219943406,4281.3036230940579,4495.3688042487611,4720.1372444611998,4956.1441066842599]
[null,null,"Closing Balance",{"$f":"D21+D22-D23","v":100},{"$f":"E21+E22-E23","v":205},315.25,431.01249999999999,552.56312500000001,680.19128124999997,814.20084531249995,954.91088757812497,1102.6564319570314,1257.7892535548831,1420.6787162326273,1591.7126520442587,1771.2982846464718,1959.8631988787954,2157.8563588227353,2365.7491767638721,2584.0366356020659,2813.2384673821693,3053.9003907512779,3306.5954102888418,3471.9251808032841,3645.5214398434487,3827.7975118356212,4019.1873874274024,4220.1467567987729,4431.1540946387122,4652.7117993706479,4885.3473893391811,5129.6147588061394,5386.0954967464459,5655.4002715837678,5938.1702851629561,6235.0787994211041,6546.83273939216,6874.1743763617687,7217.8830951798573,7578.7772499388502,7957.7161124357935,8355.601918057584,8773.3820139604632,9212.0511146584886,9672.6536703914135,10156.286353910984,10664.100671606535,11197.305705186862,11757.170990446206,12345.029539968516,12962.281016966943,13610.395067815291,14290.914821206055,15005.460562266358,15755.733590379677,16543.520269898661,17370.696283393594,18239.231097563275,19151.192652441438,20108.75228506351,21114.189899316691,22169.899394282525,23278.394363996653,24442.314082196488,25664.429786306315,26947.651275621633,28295.033839402717,29709.785531372854,{"$f":"BQ21+BQ22-BQ23","v":31195.274807941496},32755.038548338569,34392.790475755501,36112.429999543274,37918.051499520436,39813.954074496454,41804.651778221276,43894.884367132341,46089.628585488965,48394.110014763413,50813.815515501585,53354.506291276666,56022.231605840498,58823.34318613253,61764.510345439157,64852.735862711117,68095.372655846688,71500.141288639032,75075.148353070981,78828.905770724523,82770.351059260749,86908.868612223785,91254.312042834979,95817.027644976741,100607.87902722559,105638.27297858686,110920.1866275162,116466.19595889201,122289.50575683662,128403.98104467844,134824.18009691237,141565.38910175799,148643.65855684591,156075.84148468822,163879.63355892265,172073.61523686879]
[]
[null,"Book Tax Depreciation",null,{"$f":"CHOOSE($E$10,D21*(1/$E$8),AVERAGE(D24,D21)/$E$8,D24/$E$8)","v":5},10.25,15.762499999999999,21.550625,27.62815625,34.009564062499997,40.710042265624999,47.745544378906246,55.132821597851567,62.889462677744156,71.033935811631366,79.585632602212939,88.564914232323588,97.993159943939773,107.89281794113677,118.2874588381936,129.2018317801033,140.66192336910848,152.69501953756389,165.32977051444209,173.5962590401642,182.27607199217243,191.38987559178105,200.95936937137012,211.00733783993866,221.55770473193562,232.6355899685324,244.26736946695905,256.48073794030699,269.30477483732227,282.7700135791884,296.90851425814782,311.75393997105522,327.34163696960798,343.70871881808841,360.89415475899284,378.93886249694253,397.8858056217897,417.78009590287922,438.66910069802316,460.60255573292443,483.63268351957066,507.81431769554922,533.2050335803267,559.86528525934307,587.85854952231034,617.2514769984258,648.11405084834712,680.51975339076455,714.54574106030282,750.27302811331788,787.78667951898387,827.17601349493304,868.53481416967975,911.96155487816372,957.55963262207183,1005.4376142531755,1055.7094949658344,1108.4949697141262,1163.9197181998327,1222.1157041098245,1283.2214893153157,1347.3825637810817,1414.7516919701359,{"$f":"CHOOSE($E$10,BP21*(1/$E$8),AVERAGE(BP24,BP21)/$E$8,BP24/$E$8)","v":1485.4892765686427},1559.7637403970748,1637.7519274169285,1719.639523787775,1805.6214999771637,1895.9025749760217,1990.6977037248228,2090.2325889110639,2194.7442183566172,2304.4814292744481,2419.7055007381705,2540.6907757750791,2667.7253145638333,2801.1115802920249,2941.1671593066267,3088.2255172719579,3242.6367931355558,3404.7686327923343,3575.0070644319517,3753.7574176535491,3941.4452885362261,4138.5175529630378,4345.4434306111889,4562.7156021417486,4790.8513822488367,5030.3939513612795,5281.9136489293433,5546.0093313758098,5823.3097979446011,6114.4752878418312,6420.199052233922,6741.2090048456184,7078.2694550878996,7432.1829278422956,7803.7920742344113,8193.9816779461325,8603.6807618434395]
[null,"Tax Depreciation using Function",null,{"$f":"depreciation(D22:CZ22,$E$16:$AH$16)","v":0},20,37,51.650001525878906,64.472496032714844,75.88812255859375,86.236129760742187,97.101531982421875,108.51021575927734,120.48931884765625,133.06739807128906,139.72076416015625,146.70680236816406,154.04214477539062,161.74424743652344,169.83146667480469,178.32304382324219,187.23918151855469,196.60113525390625,206.43119812011719,216.75276184082031,227.59039306640625,238.96990966796875,250.91842651367187,263.46432495117187,276.63754272460937,290.46942138671875,304.992919921875,320.24252319335937,336.25466918945312,353.06741333007812,370.72076416015625,389.2568359375,408.71966552734375,429.1556396484375,450.61343383789062,473.14407348632812,496.80130004882812,521.641357421875,547.72344970703125,575.109619140625,603.8651123046875,634.058349609375,665.76129150390625,699.04937744140625,734.0018310546875,770.70184326171875,809.2369384765625,849.69879150390625,892.1837158203125,936.79290771484375,983.632568359375,1032.814208984375,1084.4549560546875,1138.6776123046875,1195.6114501953125,1255.3922119140625,1318.1617431640625,1384.06982421875,1453.2733154296875,1525.93701171875,1602.23388671875,1682.3455810546875,1766.462890625,1854.785888671875,1947.5252685546875,2044.9014892578125,2147.146484375,2254.50390625,2367.22900390625,2485.590576171875,2609.8701171875,2740.36328125,2877.381591796875,3021.250732421875,3172.313232421875,3330.92919921875,3497.4755859375,3672.349365234375,3855.966552734375,4048.764892578125,4251.203125,4463.763671875,4686.95166015625,4921.29931640625,5167.3642578125,5425.732421875,5697.01904296875,5981.8701171875,6280.9638671875,6595.01171875,6924.76220703125,7271.00048828125,7634.55029296875,8016.27783203125,8417.091796875,8837.9462890625,9279.84375,9743.8359375,10231.0283203125,10742.580078125]
[]
[null,"Difference",null,{"$f":"D27-D26","v":-5},{"$f":"E27-E26","v":9.75},21.237500000000001,30.099376525878906,36.84433978271484,41.878558496093753,45.526087495117189,49.355987603515629,53.377394161425777,57.599856169912094,62.033462259657696,60.135131557943311,58.141888135840475,56.048984831450852,53.851429495386668,51.544007836611087,49.121212043138883,46.577258149446209,43.906115716342356,41.101427605675099,43.156502800656114,45.314321074233817,47.580034076187701,49.959057142301759,52.456987111233218,55.07983799267376,57.83383141818635,60.725550454915947,63.761785253052381,66.949894352130855,70.297399750889724,73.812249902008432,77.502895966444783,81.378028557735774,85.446920830349086,89.719279078897785,94.205210989385591,98.915494427038425,103.86126151899578,109.05434900900809,114.50706340770057,120.23242878511684,126.24403191382578,132.55625792357955,139.18409218206318,146.14328153237716,153.45036626329295,161.12288762821538,169.1790381131417,177.63797476000968,186.51987960152587,195.84588884039113,205.63819548944196,215.92014188500775,226.71605742652378,238.05181757324067,249.95459766088698,262.45224819822806,275.57485450462377,289.35359722985481,303.82130760892551,319.01239740343431,334.96301727360583,351.71119865486412,369.29661210323229,{"$f":"BQ27-BQ26","v":387.7615281576127},407.14956184088396,427.50696058722497,448.88240627283631,471.3264289302283,494.89287244705224,519.63752827643611,545.61906289338276,572.90016252242685,601.54523168370451,631.62245664679585,663.20388465491669,696.36400564547512,731.18220592774833,767.74103546241713,806.12809944256924,846.4344922076657,888.75660744304832,933.19424250270094,979.85402787002386,1028.8467048494622,1080.2889912638111,1134.3034408270014,1191.0187349386633,1250.5699158262205,1313.0980698206567,1378.7528756554402,1447.6906903366489,1520.0750051269188,1596.078779797328,1675.8827920293816,1759.6768339746004,1847.6608221577044,1940.0438632655887,2037.0466423663675,2138.8993162815605]
[null,"Change in Deferred Tax",null,{"$f":"D29*$E$9","v":-1.5},{"$f":"E29*$E$9","v":2.9249999999999998},6.3712499999999999,9.0298129577636708,11.053301934814451,12.563567548828125,13.657826248535157,14.806796281054687,16.013218248427734,17.279956850973626,18.610038677897307,18.040539467382992,17.442566440752142,16.814695449435256,16.155428848616001,15.463202350983325,14.736363612941664,13.973177444833862,13.171834714902706,12.330428281702529,12.946950840196834,13.594296322270145,14.27401022285631,14.987717142690528,15.737096133369965,16.523951397802126,17.350149425455903,18.217665136474782,19.128535575915713,20.084968305639254,21.089219925266917,22.143674970602529,23.250868789933435,24.413408567320733,25.634076249104726,26.915783723669335,28.261563296815677,29.674648328111527,31.158378455698731,32.716304702702423,34.35211902231017,36.06972863553505,37.873209574147729,39.766877377073861,41.755227654618956,43.842984459713144,46.035109878987882,48.336866288464613,50.753711433942506,53.291392428002901,55.955963880457759,58.753766652117335,61.691458646832587,64.776042565502323,68.014817227957124,71.415545271972192,74.986379298266087,78.735674459468413,82.672456351387126,86.806079168956444,91.146392282677652,95.703719221030283,100.48890518208175,105.51335959645924,110.78898363096968,{"$f":"BQ29*$E$9","v":116.32845844728381},122.14486855226518,128.25208817616749,134.66472188185088,141.39792867906849,148.46786173411567,155.89125848293082,163.68571886801482,171.87004875672804,180.46356950511134,189.48673699403875,198.961165396475,208.90920169364253,219.3546617783245,230.32231063872513,241.83842983277077,253.93034766229971,266.62698223291449,279.95827275081029,293.95620836100716,308.65401145483867,324.08669737914335,340.29103224810041,357.30562048159896,375.17097474786613,393.92942094619701,413.62586269663205,434.30720710099467,456.02250153807563,478.82363393919837,502.76483760881445,527.90305019238008,554.29824664731132,582.01315897967663,611.11399270991024,641.66979488446816]
[]
[null,"Deferred Tax/Cap Exp",null,{"$f":"D30/D19","v":-1.4999999999999999E-2},2.7857142857142855E-2,5.77891156462585E-2,7.8002919406229748E-2,9.0935788563937456E-2,9.843883918700834E-2,0.10191680231244804,0.10522913675985679,0.10838376423291954,0.11138814257996406,0.11424949393267303,0.105479297905253,9.7126736632589611E-2,8.9171920014337921E-2,8.1595893783352302E-2,7.438064722063463E-2,6.7508979633433913E-2,6.0964510345797529E-2,5.4731693865426173E-2,4.8795691756281588E-2,4.8795696069439419E-2,4.8795688675454522E-2,4.8795685545725484E-2,4.8795706410585768E-2,4.8795685119911961E-2,4.8795686471700746E-2,4.8795687759118654E-2,4.8795709829140027E-2,4.8795677132812035E-2,4.879569159037208E-2,4.8795699004505408E-2,4.8795685891072298E-2,{"$f":"AJ30/AJ19","v":4.8795707026275829E-2},4.8795699706724822E-2,4.879569447847408E-2,4.8795701117522614E-2,4.8795684519901239E-2,4.8795695810800087E-2,4.8795692226387723E-2,4.8795703150311051E-2,4.8795701849843942E-2,4.879570680400417E-2,4.8795699726632391E-2,4.8795708713771133E-2,4.8795716203053417E-2,4.8795711108303511E-2,4.879568587716137E-2,4.8795686801379023E-2,4.8795688561793588E-2,4.8795684370330258E-2,4.8795685967078208E-2,4.8795689768858966E-2,4.8795692665453853E-2,4.879570094143923E-2,4.8795681236712116E-2,4.8795672479055641E-2,4.8795709416110215E-2,4.8795694663983924E-2,4.8795693583242067E-2,4.8795693583242046E-2,4.8795698484565594E-2,4.8795702218907375E-2,4.8795702218907354E-2,4.8795706452854928E-2,{"$f":"BP30/BP19","v":4.8795687097665907E-2},4.87956978505487E-2,4.8795692730128321E-2,4.8795683673602486E-2,4.8795694289310423E-2,4.8795684179112411E-2,4.8795696215062453E-2,4.8795697361343406E-2,4.8795666793851236E-2,4.8795679270378638E-2,4.8795684221381586E-2,4.8795681392237035E-2,4.8795703845765093E-2,4.8795698713530115E-2,4.8795698713530074E-2,4.8795680869024444E-2,4.8795681607927369E-2,4.8795680904210256E-2,4.8795702350825719E-2,4.8795692138151679E-2,4.8795695785535283E-2,4.8795694627635715E-2,4.8795692422112791E-2,4.8795692422112777E-2,4.8795697423298583E-2,4.8795706949366816E-2,4.8795694247942466E-2,4.8795690791772595E-2,4.879569655205572E-2,4.8795689498647772E-2,4.8795690245040164E-2,4.8795692377589801E-2,4.8795689669590234E-2,4.8795693538160989E-2,4.8795693538160968E-2,4.8795707573791904E-2,4.8795715371364644E-2]
[null,"Cap Exp/Depreciation",null,null,{"$f":"E22/E26","v":10.24390243902439},6.9944488501189532,5.3716539543516717,4.3995199643479648,3.752713678289302,3.2918060656413486,2.947082164336785,2.6798110471578642,2.4667538088658425,2.2931217426793924,2.1490554289679129,2.0277288603376702,1.9242660849001958,1.8350911925570363,1.7575220567170624,1.6895074615483072,1.6294518537092584,1.5760954358429768,1.5284302322036449,1.5284302322036449,1.5284302322036449,1.5284302322036449,1.5284302322036449,1.5284302322036447,1.5284302322036445,1.5284302322036445,1.5284302322036445,1.5284302322036445,1.5284302322036452,1.5284302322036449,1.5284302322036452,1.5284302322036452,1.5284302322036452,1.5284302322036449,1.5284302322036449,1.5284302322036449,1.5284302322036449,1.5284302322036447,1.5284302322036452,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036445,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036449,1.5284302322036447,1.5284302322036449,1.5284302322036447,1.5284302322036449,1.5284302322036449,1.5284302322036449,1.5284302322036449,1.5284302322036447,1.5284302322036445,1.5284302322036445,1.5284302322036447,1.5284302322036443,1.5284302322036443,1.5284302322036445,{"$f":"BQ22/BQ26","v":1.5284302322036445},1.5284302322036445,1.5284302322036445,1.5284302322036445,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036445,1.5284302322036449,1.5284302322036449,1.5284302322036445,1.5284302322036443,1.5284302322036445,1.5284302322036447,1.5284302322036445,1.5284302322036449,1.5284302322036449,1.5284302322036447,1.5284302322036445,1.5284302322036445,1.5284302322036447,1.5284302322036447,1.5284302322036447,1.5284302322036449,1.5284302322036449,1.5284302322036452,1.5284302322036449,1.5284302322036447,1.5284302322036447,1.5284302322036447]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,1,{"$f":"G39+1","v":2},{"$f":"H39+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,1,{"$f":"TRANSPOSE(D19:W19)","v":100},null,{"$f":"LOOKUP(G$39-$D40+1,$E$15:$AH$15,$E$16:$AH$16)*$E40","v":20},{"$f":"LOOKUP(H$39-$D40+1,$E$15:$AH$15,$E$16:$AH$16)*$E40","v":16.000000000000004},12.8,10.24,8.1920000000000002,6.5536000000000012,6.5536000000000012,6.5536000000000012,6.5536000000000012,6.5536000000000012,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D40+1","v":2},105,null,{"$error":"#N/A"},21,16.800000000000004,13.44,10.752000000000001,8.6016000000000012,6.8812800000000012,6.8812800000000012,6.8812800000000012,6.8812800000000012,6.8812800000000012,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D41+1","v":3},110.25,null,{"$error":"#N/A"},{"$error":"#N/A"},22.05,17.640000000000004,14.112,11.2896,9.0316800000000015,7.2253440000000015,7.2253440000000015,7.2253440000000015,7.2253440000000015,7.2253440000000015,0,0,0,0,0,0,0,0]
[null,null,null,4,115.7625,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},23.152500000000003,18.522000000000006,14.817600000000001,11.854080000000002,9.4832640000000001,7.5866112000000019,7.5866112000000019,7.5866112000000019,7.5866112000000019,7.5866112000000019,0,0,0,0,0,0,0]
[null,null,null,5,121.55062500000001,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},24.310125000000003,19.448100000000007,15.558480000000001,12.446784000000001,9.9574272000000015,7.9659417600000024,7.9659417600000024,7.9659417600000024,7.9659417600000024,7.9659417600000024,0,0,0,0,0,0]
[null,null,null,6,127.62815625000002,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},25.525631250000004,20.420505000000006,16.336404000000002,13.069123200000002,10.455298560000003,8.3642388480000029,8.3642388480000029,8.3642388480000029,8.3642388480000029,8.3642388480000029,0,0,0,0,0]
[null,null,null,7,134.00956406250003,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},26.801912812500007,21.44153025000001,17.153224200000004,13.722579360000005,10.978063488000004,8.782450790400004,8.782450790400004,8.782450790400004,8.782450790400004,8.782450790400004,0,0,0,0]
[null,null,null,8,140.71004226562505,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},28.142008453125012,22.513606762500011,18.010885410000007,14.408708328000007,11.526966662400005,9.2215733299200053,9.2215733299200053,9.2215733299200053,9.2215733299200053,9.2215733299200053,0,0,0]
[null,null,null,9,147.74554437890632,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},29.549108875781265,23.639287100625015,18.91142968050001,15.129143744400007,12.103314995520007,9.6826519964160056,9.6826519964160056,9.6826519964160056,9.6826519964160056,9.6826519964160056,0,0]
[null,null,null,10,155.13282159785163,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},31.026564319570326,24.821251455656267,19.857001164525009,15.885600931620008,12.708480745296006,10.166784596236806,10.166784596236806,10.166784596236806,10.166784596236806,10.166784596236806,0]
[null,null,null,11,162.88946267774421,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},32.577892535548841,26.062314028439079,20.849851222751258,16.679880978201009,13.343904782560806,10.675123826048646,10.675123826048646,10.675123826048646,10.675123826048646,10.675123826048646]
[null,null,null,12,171.03393581163144,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},34.206787162326286,27.365429729861035,21.892343783888826,17.513875027111059,14.011100021688849,11.208880017351079,11.208880017351079,11.208880017351079,11.208880017351079]
[null,null,null,13,179.58563260221302,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},35.917126520442608,28.733701216354088,22.986960973083267,18.389568778466614,14.711655022773293,11.769324018218635,11.769324018218635,11.769324018218635]
[null,null,null,14,188.56491423232367,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"LOOKUP(P$39-$D53+1,$E$15:$AH$15,$E$16:$AH$16)*$E53","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},37.712982846464733,30.170386277171794,24.136309021737432,19.309047217389946,15.447237773911956,12.357790219129566,12.357790219129566]
[null,null,null,15,197.99315994393987,null,{"$error":"#N/A"},{"$f":"LOOKUP(H$39-$D54+1,$E$15:$AH$15,$E$16:$AH$16)*$E54","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},39.598631988787979,31.678905591030386,25.343124472824304,20.274499578259444,16.219599662607557,12.975679730086046]
[null,null,null,16,207.89281794113688,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},41.578563588227382,33.262850870581907,26.610280696465523,21.288224557172416,17.030579645737934]
[null,null,null,17,218.28745883819374,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},43.657491767638753,34.925993414111005,27.940794731288801,22.35263578503104]
[null,null,null,18,229.20183178010345,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},45.840366356020695,36.672293084816559,29.337834467853241]
[null,null,null,19,240.66192336910862,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},48.132384673821726,38.505907739057385]
[null,null,null,20,252.69501953756406,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},50.539003907512814]
[]
[null,null,null,null,null,null,{"$f":"SUMIF(G40:G59,\"<>#N/A\",G40:G59)","v":20},{"$f":"SUMIF(H40:H59,\"<>#N/A\",H40:H59)","v":37},51.650000000000006,64.472500000000011,75.888125000000016,86.236131250000014,97.101537812500027,108.51021470312503,120.48932543828127,133.06739171019535,139.72076129570513,146.70679936049038,154.04213932851493,161.74424629494069,169.83145860968773,178.32303154017211,187.23918311718074,196.60114227303978,206.43119938669179,216.75275935602636]
[]
[null,null,null,"Book Life",{"$f":"E8","v":20},"Growth",{"$f":"E7","v":0.05},"Tax Rate",null,{"$f":"E9","v":0.3}]
[null,null,null,"Stable Ratio of Deferred Tax Increase to Capital Expenditure"]
[null,null,null,null,null,"Declining Balance Factor"]
[null,null,null,null,null,1,{"$f":"F66+0.5","v":1.5},{"$f":"G66+0.5","v":2},{"$f":"H66+0.5","v":2.5},{"$f":"I66+0.5","v":3},null,null,"row_start",{"$f":"ROW(F67)","v":67}]
[null,null,null,"Tax Life",1,0.10372019072055183,0.10372019072055183,0.10372019072055183,0.10372019072055183,0.10372019072055183,null,null,"row_end",{"$f":"ROW(F76)","v":76}]
[null,null,null,null,2,9.657732443397854E-2,0.10014876663489665,0.10372019072055183,0.10372019072055183,0.10372019072055183,null,null,"column_start",{"$f":"COLUMN(F67)","v":6}]
[null,null,null,null,4,8.2963776806925418E-2,8.6946218093084934E-2,9.155626266327957E-2,9.5766467150194573E-2,9.9095961899486953E-2,null,null,"column_end",{"$f":"COLUMN(J67)","v":10},null,null,"db_fac"]
[null,null,null,null,6,7.0194001896390912E-2,7.4762834243431261E-2,8.0711814126935288E-2,8.6075888401118336E-2,9.0417700273183133E-2,null,null,"row_input","db_fac",null,null,"def_tax_ratio"]
[null,null,null,null,8,5.8209179443657694E-2,6.3558362971716409E-2,7.0578679504602365E-2,7.7003547345145001E-2,8.2324797137773423E-2,null,null,"col_input","tax_life",null,null,"tax_life"]
[null,null,null,null,10,4.6954836853110429E-2,5.2949992541810167E-2,6.104947151766163E-2,6.8443904460473784E-2,7.4653182556946515E-2,null,null,"output","def_tax_ratio"]
[null,null,null,null,14,2.6439627665329809E-2,3.3609558154712976E-2,4.3588912310075958E-2,5.2740380834505496E-2,6.0437864010789245E-2]
[null,null,null,null,16,1.7088782557148199E-2,2.4780794924028616E-2,3.5578415505711877E-2,4.5481721787315889E-2,5.3838238228809558E-2]
[null,null,null,null,18,8.2879349466311938E-3,1.6438227234987158E-2,2.8003300930486211E-2,3.8584933232315217E-2,4.7537115749307302E-2,null,null,"1. For Next Loops"]
[null,null,null,null,20,2.8905714077362107E-9,8.6205130586704693E-3,2.0834348665300984E-2,3.2027606589265296E-2,4.1538989157487875E-2,null,null,"2. Cell function in VBA"]

{"sheet":"Dates Allocate","index":8,"n_rows":49,"n_cols":48,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Problem:  Develop portfolio of assets with different start and end dates"]
[]
[null,null,null,null,"Input Start dates and end dates"]
[null,null,null,null,"Applies in Real Estate and Solar Models"]
[]
[null,null,null,{"$f":"f(I18)","v":"=percent_of_time($F18,$G18,I$15,I$16)"}]
[]
[null,null,null,"Function date_percent(start_operation, end_operation, start_date, end_date)"]
[]
[null,null,null,"This function which is very helpful for real estate and portfolios"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"2014-06-01","2014-09-01","2014-11-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01","2019-03-01","2020-03-01","2021-03-01","2022-03-01","2023-03-01","2024-03-01","2025-03-01","2026-03-01","2027-03-01","2028-03-01","2029-03-01","2030-03-01","2031-03-01","2032-03-01","2033-03-01","2034-03-01","2035-03-01","2036-03-01","2037-03-01","2038-03-01","2039-03-01","2040-03-01","2041-03-01","2042-03-01","2043-03-01","2044-03-01","2045-03-01","2046-03-01","2047-03-01","2048-03-01","2049-03-01","2050-03-01","2051-03-01"]
[null,null,null,null,null,null,null,null,"2014-08-31","2014-10-31","2015-02-28","2016-02-29","2017-02-28","2018-02-28","2019-02-28","2020-02-29","2021-02-28","2022-02-28","2023-02-28","2024-02-29","2025-02-28","2026-02-28","2027-02-28","2028-02-29","2029-02-28","2030-02-28","2031-02-28","2032-02-29","2033-02-28","2034-02-28","2035-02-28","2036-02-29","2037-02-28","2038-02-28","2039-02-28","2040-02-29","2041-02-28","2042-02-28","2043-02-28","2044-02-29","2045-02-28","2046-02-28","2047-02-28","2048-02-29","2049-02-28","2050-02-28","2051-02-28","2052-02-29"]
[]
[null,null,null,"First Increment",null,"2014-07-14","2040-06-01",null,{"$f":"percent_of_time($F18,$G18,I$15,I$16)","v":0.53260869565217395},{"$f":"percent_of_time($F18,$G18,J$15,J$16)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.25205479452054796,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Second Increment",null,"2014-07-31","2040-04-01",null,{"$f":"percent_of_time($F19,$G19,I$15,I$16)","v":0.34782608695652173},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8.4931506849315067E-2,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Third Increment",null,"2015-04-28","2040-11-01",null,{"$f":"percent_of_time($F20,$G20,I$15,I$16)","v":0},0,0,0.84153005464480879,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.67123287671232879,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Fourth Increment",null,"2015-05-31","2041-03-01",null,{"$f":"percent_of_time($F21,$G21,I$15,I$16)","v":0},0,0,0.75136612021857918,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Fifth Increment",null,"2017-05-31","2041-03-01",null,{"$f":"percent_of_time($F22,$G22,I$15,I$16)","v":0},0,0,0,0,0.75068493150684934,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,"Difference",null,{"$f":"F18-I15","v":43}]
[null,null,null,null,null,null,"Total Days",null,{"$f":"I16-I15+1","v":92}]
[]
[null,null,null,null,null,null,"Percent out",null,{"$f":"I25/I26","v":0.46739130434782611}]
[null,null,null,null,null,null,"Percent In",null,{"$f":"1-I28","v":0.53260869565217384}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"2014-07-01",{"$f":"I34","v":"2014-07-31"},{"$f":"J34","v":"2014-08-30"},"2014-09-29","2014-10-28","2014-11-27","2014-12-26","2015-01-25","2015-02-24","2015-03-23","2015-04-22","2015-05-21","2015-06-20","2015-07-19","2015-08-18","2015-09-17","2015-10-16","2015-11-15","2015-12-14","2016-01-13","2016-02-12","2016-03-11","2016-04-10","2016-05-09","2016-06-08","2016-07-07","2016-08-06","2016-09-05","2016-10-04","2016-11-03","2016-12-02","2017-01-01","2017-01-31","2017-02-27","2017-03-26","2017-04-25","2017-05-24","2017-06-23","2017-07-22","2017-08-21"]
[null,null,null,null,null,null,null,null,{"$f":"EDATE(I33,1)-1","v":"2014-07-31"},{"$f":"EDATE(J33,1)-1","v":"2014-08-30"},{"$f":"EDATE(K33,1)-1","v":"2014-09-29"},"2014-10-28","2014-11-27","2014-12-26","2015-01-25","2015-02-24","2015-03-23","2015-04-22","2015-05-21","2015-06-20","2015-07-19","2015-08-18","2015-09-17","2015-10-16","2015-11-15","2015-12-14","2016-01-13","2016-02-12","2016-03-11","2016-04-10","2016-05-09","2016-06-08","2016-07-07","2016-08-06","2016-09-05","2016-10-04","2016-11-03","2016-12-02","2017-01-01","2017-01-31","2017-02-27","2017-03-26","2017-04-25","2017-05-24","2017-06-23","2017-07-22","2017-08-21","2017-09-20"]
[]
[null,null,null,"First Increment",null,"2014-07-14","2017-06-01",null,{"$f":"percent_of_time($F36,$G36,I$33,I$34)","v":0.58064516129032262},{"$f":"percent_of_time($F36,$G36,J$33,J$34)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.25806451612903225,0,0,0]
[null,null,null,"Second Increment",null,"2014-07-31","2017-06-01",null,{"$f":"percent_of_time($F37,$G37,I$15,I$16)","v":0.34782608695652173},{"$f":"percent_of_time($F37,$G37,J$15,J$16)","v":1},1,1,1,0.25205479452054796,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,null,null,"Third Increment",null,"2015-04-28","2016-11-01",null,{"$f":"percent_of_time($F38,$G38,I$15,I$16)","v":0},0,0,0.84153005464480879,0.67123287671232879,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]
["s",null,null,"Fourth Increment",null,"2015-05-31",{"$f":"EDATE(F39,5*12)","v":"2020-05-31"},null,{"$f":"percent_of_time($F39,$G39,I$15,I$16)","v":0},0,0,0.75136612021857918,1,1,1,1,0.24931506849315069,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,null,null,"Fifth Increment",null,"2017-05-31",{"$f":"EDATE(F40,5*12)","v":"2022-05-31"},null,{"$f":"percent_of_time($F40,$G40,I$15,I$16)","v":0},0,0,0,0,0.75068493150684934,1,1,1,1,0.24931506849315069,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,null,null,null,null,null,"Days Before Start",null,{"$f":"F36-I33","v":13}]
[null,null,null,null,null,null,"Total Days in Month",null,{"$f":"I34-I33+1","v":31}]
[null,null,null,null,null,null,"Percent Not in Serv",null,{"$f":"I43/I44","v":0.41935483870967744}]
[null,null,null,null,null,null,"Percent Not in Serv",null,{"$f":"1-I45","v":0.58064516129032251}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I34-F36","v":17}]
[null,null,null,null,null,null,null,null,{"$f":"I44-I48","v":14}]