{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Given Historic Growth","Depreciation","Straight Line Depreciation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":50,"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":"Given Historic Growth","index":0,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Probelm: Neet to find the growth rate and the base retirmement"]
[null,"Life",12,null,"Final",{"$f":"C29","v":-5.2750692702829838E-11}]
[null,"Base Value",3.13354958243557E-2]
[null,"Historic Growth",0.15,null,null,null,null,null,null,"'"]
[null,null,null,null,null,null,null,null,null,"Sub goalseek()"]
[null,"Plant in Service",{"$f":"'[1]Financial Model'!M25","v":112364.323},null,null,null,null,null,null,"    Range(\"final_net_plant\").goalseek Goal:=0, ChangingCell:=Range(\"base_value\")"]
[null,"Accum Depreciation",{"$f":"-'[1]Financial Model'!M26","v":23007.382000000001},null,null,null,null,null,null,"End Sub"]
[]
[null,"Find Initial"]
[]
[null,null,null,1,{"$f":"D11+1","v":2},{"$f":"E11+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"Switch",{"$f":"C2","v":12},{"$f":"D11<=$C$12","v":true},{"$f":"E11<=$C$12","v":true},true,true,true,true,true,true,true,true,true,true,false,false,false,false,false]
[null,"Final Year",null,{"$f":"D11=$C$2","v":false},{"$f":"E11=$C$2","v":false},false,false,false,false,false,false,false,false,false,true,false,false,false,false,false]
[]
[null,"Retirement Rate",null,{"$f":"C3","v":3.13354958243557E-2},{"$f":"D15*(1+$C$4)*E12","v":3.603582019800905E-2},{"$f":"E15*(1+$C$4)*F12","v":4.1441193227710407E-2},4.7657372211866965E-2,5.4805978043647008E-2,6.3026874750194056E-2,7.2480905962723163E-2,8.3353041857131632E-2,9.5855998135701365E-2,0.11023439785605656,0.12676955753446503,0.14578499116463478,0,0,0,0,0]
[]
[null,"Opening Balance",null,{"$f":"C19","v":112364.323},{"$f":"D19","v":108843.33122582694},104794.19068552792,100137.67906418406,94782.690699638624,88624.454080411364,81542.48196830001,73398.21403937196,64032.3059211047,53261.511585097353,40875.098098688904,26630.722589319194,10249.690753544024,10249.690753544024,10249.690753544024,10249.690753544024,10249.690753544024]
[null,"Less: Retirement",null,{"$f":"D15*$C$6","v":3520.9917741730551},{"$f":"E15*$C$6","v":4049.1405402990131},4656.511621343865,5354.9883645454447,6158.2366192272611,7081.9721121113498,8144.2679289280513,9365.908118267258,10770.794336007346,12386.413486408446,14244.375509369713,16381.031835775169,0,0,0,0,0]
[null,"Closing Balance",{"$f":"C6","v":112364.323},{"$f":"D17-D18","v":108843.33122582694},{"$f":"E17-E18","v":104794.19068552792},100137.67906418406,94782.690699638624,88624.454080411364,81542.48196830001,73398.21403937196,64032.3059211047,53261.511585097353,40875.098098688904,26630.722589319194,10249.690753544024,10249.690753544024,10249.690753544024,10249.690753544024,10249.690753544024,10249.690753544024]
[]
[null,"Depreciation",{"$f":"1/C2","v":8.3333333333333329E-2},{"$f":"$C$21*D17*D12","v":9363.6935833333337},{"$f":"$C$21*E17*E12","v":9070.2776021522441},8732.8492237939936,8344.8065886820041,7898.5575583032187,7385.3711733676137,6795.2068306916672,6116.51783661433,5336.0254934253917,4438.4592987581127,3406.2581748907419,2219.2268824432658,0,0,0,0,0]
[]
[null,"Accumulated Depreciation"]
[null,"Opening Balance",null,{"$f":"C27","v":23007.382000000001},{"$f":"D27","v":28850.083809160278},33871.220871013509,37947.558473463636,40937.376697600193,42677.697636676152,42981.096697932422,41632.035599696042,38382.645318043113,32947.876475461155,24999.922287810819,14161.80495333185,-5.2750692702829838E-11,-5.2750692702829838E-11,-5.2750692702829838E-11,-5.2750692702829838E-11,-5.2750692702829838E-11]
[null,"Add: Depreciation",null,{"$f":"D21","v":9363.6935833333337},{"$f":"E21","v":9070.2776021522441},8732.8492237939936,8344.8065886820041,7898.5575583032187,7385.3711733676137,6795.2068306916672,6116.51783661433,5336.0254934253917,4438.4592987581127,3406.2581748907419,2219.2268824432658,0,0,0,0,0]
[null,"Less: Retirement",null,{"$f":"D18","v":3520.9917741730551},{"$f":"E18","v":4049.1405402990131},4656.511621343865,5354.9883645454447,6158.2366192272611,7081.9721121113498,8144.2679289280513,9365.908118267258,10770.794336007346,12386.413486408446,14244.375509369713,16381.031835775169,0,0,0,0,0]
[null,"Closing Balance",{"$f":"C7","v":23007.382000000001},{"$f":"D24+D25-D26","v":28850.083809160278},{"$f":"E24+E25-E26","v":33871.220871013509},37947.558473463636,40937.376697600193,42677.697636676152,42981.096697932422,41632.035599696042,38382.645318043113,32947.876475461155,24999.922287810819,14161.80495333185,-5.2750692702829838E-11,-5.2750692702829838E-11,-5.2750692702829838E-11,-5.2750692702829838E-11,-5.2750692702829838E-11,-5.2750692702829838E-11]
[]
[null,"End Value",{"$f":"SUM(D29:T29)","v":-5.2750692702829838E-11},{"$f":"D27*D13","v":0},{"$f":"E27*E13","v":0},0,0,0,0,0,0,0,0,0,-5.2750692702829838E-11,0,0,0,0,0]
[]
[]
[null,"Net Plant",null,{"$f":"D17-D24","v":89356.941000000006},{"$f":"E17-E24","v":79993.247416666665},70922.969814514421,62190.120590720428,53845.314002038431,45946.756443735212,38561.385270367588,31766.178439675918,25649.660603061588,20313.635109636198,15875.175810878085,12468.917635987344,10249.690753544077,10249.690753544077,10249.690753544077,10249.690753544077,10249.690753544077]
[null,"Net Plant Depreciation Rate",null,{"$f":"D21/D32","v":0.10478977322347385},{"$f":"E21/E32","v":0.11338804080433473},0.1231314656821775,0.13418219018419394,0.14668978544733163,0.16073759596961931,0.17621791289519437,0.1925481168038396,0.20803493566649667,0.21849655538277521,0.2145650678436383,0.17798071550638947,0,0,0,0,0]

{"sheet":"Depreciation","index":1,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,1997,{"$f":"E2+1","v":1998},{"$f":"F2+1","v":1999},{"$f":"G2+1","v":2000},2001,2002,2003,2004,2005,2006,2007,2008,2009,2010]
[]
[null,null,null,"Plane Life",13]
[null,null,null,"Historic Growth",0.1]
[null,null,null,"Units",1]
[]
[null,null,null,"Plant in Service",385702.75199999998]
[null,null,null,"Accum Depreciation",113883.56]
[null,null,null,"Net",271819.19199999998,{"$f":"E10/E8","v":0.70473749692094501}]
[]
[null,null,null,"Retirement",1]
[null,null,null,"Retirement Rate",null,3.3311710750748923E-2,{"$f":"F13*(1+$E$5)","v":3.6642881825823821E-2},{"$f":"G13*(1+$E$5)","v":4.030717000840621E-2},4.4337887009246832E-2,4.8771675710171519E-2,5.3648843281188678E-2,5.9013727609307551E-2,6.4915100370238316E-2,7.140661040726215E-2,7.854727144798837E-2,8.6401998592787216E-2,9.5042198452065949E-2,0.10454641829727256]
[]
[null,null,null,"Plant In Service"]
[null,null,null,"Opening Balance",null,{"$f":"E18","v":385702.75199999998},{"$f":"F18","v":372854.33348960814},358721.07312817709,343174.48673060292,326073.24169327138,307261.87215220666,286569.36565703549,263807.60851234721,238769.67565319009,211227.94950811725,180932.05074853712,147606.56211299897,110948.52461390701]
[null,null,null,"Less: Retirements",null,{"$f":"$E$8*F13","v":12848.418510391844},{"$f":"$E$8*G13","v":14133.260361431032},15546.586397574138,17101.245037331551,18811.369541064709,20692.506495171183,22761.757144688301,25037.932859157136,27541.726145072851,30295.898759580137,33325.488635538153,36658.037499091974,40323.841249001176]
[null,null,null,"Closing Balance",{"$f":"E8","v":385702.75199999998},{"$f":"F16-F17","v":372854.33348960814},{"$f":"G16-G17","v":358721.07312817709},343174.48673060292,326073.24169327138,307261.87215220666,286569.36565703549,263807.60851234721,238769.67565319009,211227.94950811725,180932.05074853712,147606.56211299897,110948.52461390701,70624.683364905824]
[null,null,null,"Depreciation",{"$f":"1/$E$4","v":7.6923076923076927E-2},{"$f":"$E$19*F16","v":29669.442461538463},{"$f":"$E$19*G16","v":28681.102576123703},27593.928702167468,26398.037440815609,25082.557053328568,23635.528627092823,22043.7973582335,20292.892962488248,18366.898127168468,16248.303808316712,13917.850057579779,11354.350931769153,8534.5018933774627]
[]
[null,null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E25","v":113883.56},{"$f":"F25","v":130704.58395114663},145252.42616583931,157299.76847043264,166596.56087391672,172867.74838618058,175810.77051810222,175092.81073164742,170347.77083497855,161172.94281707419,147125.34786581076,127717.7092878524,102414.02272052958]
[null,null,null,"Add: Depreciation",null,{"$f":"F19","v":29669.442461538463},{"$f":"G19","v":28681.102576123703},27593.928702167468,26398.037440815609,25082.557053328568,23635.528627092823,22043.7973582335,20292.892962488248,18366.898127168468,16248.303808316712,13917.850057579779,11354.350931769153,8534.5018933774627]
[null,null,null,"Less: Retirements",null,{"$f":"F17","v":12848.418510391844},{"$f":"G17","v":14133.260361431032},15546.586397574138,17101.245037331551,18811.369541064709,20692.506495171183,22761.757144688301,25037.932859157136,27541.726145072851,30295.898759580137,33325.488635538153,36658.037499091974,40323.841249001176]
[null,null,null,"Closing Balance",{"$f":"E9","v":113883.56},{"$f":"F22+F23-F24","v":130704.58395114663},{"$f":"G22+G23-G24","v":145252.42616583931},157299.76847043264,166596.56087391672,172867.74838618058,175810.77051810222,175092.81073164742,170347.77083497855,161172.94281707419,147125.34786581076,127717.7092878524,102414.02272052958,70624.683364905854]
[]
[null,null,null,"Net Plant",null,{"$f":"F18-F25","v":242149.7495384615},{"$f":"G18-G25","v":213468.64696233778},185874.71826017028,159476.68081935466,134394.12376602608,110758.59513893328,88714.797780699795,68421.904818211537,50055.006691043061,33806.702882726357,19888.852825146576,8534.5018933774263,0]

{"sheet":"Straight Line Depreciation","index":2,"n_rows":28,"n_cols":19,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["Historic Data"]
[null,null,"Life",10,"Find from financial report"]
[null,null,"Base Retirements",8.7921412659990334E-3,"set these two variables"]
[null,null,"Historic Growth",0.42710477337597963]
[]
[null,null,"Plant in Service",112364.323,"given from financial report"]
[null,null,"Accum Depreciation",23007.382000000001]
[]
[null,null,"Closing Plant",{"$f":"LOOKUP(D3,13:13,19:19)","v":7.5702230242313817E-3},"target these tow variables to be zero"]
[null,null,"Closing Acc Depreciation",{"$f":"LOOKUP(D3,13:13,28:28)","v":9.3558926309924573E-3}]
[]
[null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,{"$f":"E13<=$D$3","v":true},{"$f":"F13<=$D$3","v":true},true,true,true,true,true,true,true,true,false,false,false,false,false]
[]
["Gross Plant and Depreciation"]
[null,"Opening Balance",null,null,{"$f":"D19","v":112364.323},110954.45336943888,108942.42168982727,106071.04167566987,101973.28155128944,96125.34851763639,87779.735370927039,75869.671012508799,58872.761315395008,34616.390354003437,7.5702230242313817E-3,7.5702230242313817E-3,7.5702230242313817E-3,7.5702230242313817E-3,7.5702230242313817E-3]
[null,"Less: Retirements",null,{"$f":"D7*D4","v":987.92300107434437},{"$f":"D18*(1+$D$5)*E14","v":1409.8696305611199},{"$f":"E18*(1+$D$5)*F14","v":2012.0316796116033},2871.3800141574088,4097.7601243804265,5847.9330336530547,8345.6131467093473,11910.06435841824,16996.909697113795,24256.370961391574,34616.382783780413,0,0,0,0,0]
[null,"Closing Balance",null,{"$f":"D7","v":112364.323},{"$f":"E17-E18","v":110954.45336943888},108942.42168982727,106071.04167566987,101973.28155128944,96125.34851763639,87779.735370927039,75869.671012508799,58872.761315395008,34616.390354003437,7.5702230242313817E-3,7.5702230242313817E-3,7.5702230242313817E-3,7.5702230242313817E-3,7.5702230242313817E-3,7.5702230242313817E-3]
[]
[null,"Straight Line Rate",null,{"$f":"1/$D$3","v":0.1},0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"Straight Line Depreciation",null,null,{"$f":"E21*E17","v":11236.4323},11095.445336943889,10894.242168982728,10607.104167566988,10197.328155128946,9612.5348517636394,8777.9735370927046,7586.9671012508807,5887.276131539501,3461.6390354003438,7.5702230242313817E-4,7.5702230242313817E-4,7.5702230242313817E-4,7.5702230242313817E-4,7.5702230242313817E-4]
[]
["Accumulated Depreciation"]
[null,"Opening Balance",null,null,{"$f":"D28","v":23007.382000000001},{"$f":"E28","v":32833.944669438875},41917.358326771158,49940.220481596472,56449.56452478304,60798.959646258925,62065.881351313219,58933.790529987687,49523.847934124773,31154.753104272702,9.3558926309924573E-3,1.0112914933415595E-2,1.0869937235838734E-2,1.1626959538261872E-2,1.238398184068501E-2]
[null,"Add: Depreciation Expense",null,null,{"$f":"E22","v":11236.4323},{"$f":"F22","v":11095.445336943889},10894.242168982728,10607.104167566988,10197.328155128946,9612.5348517636394,8777.9735370927046,7586.9671012508807,5887.276131539501,3461.6390354003438,7.5702230242313817E-4,7.5702230242313817E-4,7.5702230242313817E-4,7.5702230242313817E-4,7.5702230242313817E-4]
[null,"Less: Retirements",null,null,{"$f":"E18","v":1409.8696305611199},{"$f":"F18","v":2012.0316796116033},2871.3800141574088,4097.7601243804265,5847.9330336530547,8345.6131467093473,11910.06435841824,16996.909697113795,24256.370961391574,34616.382783780413,0,0,0,0,0]
[null,"Closing Balance",null,{"$f":"D8","v":23007.382000000001},{"$f":"E25+E26-E27","v":32833.944669438875},{"$f":"F25+F26-F27","v":41917.358326771158},49940.220481596472,56449.56452478304,60798.959646258925,62065.881351313219,58933.790529987687,49523.847934124773,31154.753104272702,9.3558926309924573E-3,1.0112914933415595E-2,1.0869937235838734E-2,1.1626959538261872E-2,1.238398184068501E-2,1.3141004143108148E-2]