{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Corporate Model","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":32,"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":"Corporate Model","index":0,"n_rows":104,"n_cols":12,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[]
["Period",null,null,null,2016,{"$f":"E2+1","v":2017},{"$f":"F2+1","v":2018},2019,2020,2021,2022,2023]
["Historic Switch",null,null,null,true,false,false,false,false,false,false,false]
[]
["Historic Balance"]
[null,"Assets"]
[null,null,"Cash Balance",null,150]
[null,null,"Gross Assets",null,1000]
[null,null,"Acccumulated Depreciation",null,450]
[null,null,"Net Plant",null,{"$f":"E8-E9","v":550}]
[null,null,null,"Total Assets",{"$f":"E10+E7","v":700}]
[]
[null,null,"Debt",null,400]
[null,null,"Equity",null,{"$f":"E11-E13","v":300}]
[null,null,null,"Total",{"$f":"SUM(E13:E14)","v":700}]
[]
["Operating Analysis and Assumptions"]
[null,"EBITDA",null,null,150,100,280,{"$f":"G18*1.03","v":288.40000000000003},297.05200000000002,305.96356000000003,315.14246680000002,324.59674080400004]
[null,"Cap Exp",null,null,80,400,200,80,80,80,80,80]
[]
["Depreciation"]
[null,"Historic Growth",null,null,9.2058045142561329E-2]
[null,"Life",null,null,7]
[]
[null,"Gross Plant - Existing Plant"]
[null,null,"Opening Balance",null,null,{"$f":"E28","v":1000},{"$f":"F28","v":891.99340280982312},774.04392941981848,645.23625808393547,504.57080432550549,350.95596387498313,183.19964150769917]
[null,null,"Less Retirement",null,98.901883165081458,{"$f":"E27*(1+$E$22)","v":108.00659719017686},{"$f":"F27*(1+$E$22)","v":117.94947339000461},128.80767133588301,140.66545375842995,153.61484045052239,167.75632236728396,183.19964146472148]
[null,null,"Closing Balance",null,{"$f":"IF(E3,E8,E26-E27)","v":1000},{"$f":"IF(F3,F8,F26-F27)","v":891.99340280982312},774.04392941981848,645.23625808393547,504.57080432550549,350.95596387498313,183.19964150769917,4.2977688963219407E-8]
[]
[null,null,"Depreciation",null,{"$f":"1/E23","v":0.14285714285714285},{"$f":"AVERAGE(F28,F26)*$E$30","v":135.14238591498736},{"$f":"AVERAGE(G28,G26)*$E$30","v":119.00266658783154},101.37715625026813,82.129075886388634,61.109054871463471,38.153971813048734,13.085688682191204]
[]
[null,"Accumulated Depreciation"]
[null,null,"Opening Balance",null,null,{"$f":"E36","v":450},{"$f":"F36","v":477.13578872481048},478.18898192263737,450.75846683702252,392.22208896498114,299.71630338592217,170.11395283168693]
[null,null,"Add: Depreciation",null,null,{"$f":"F30","v":135.14238591498736},{"$f":"G30","v":119.00266658783154},101.37715625026813,82.129075886388634,61.109054871463471,38.153971813048734,13.085688682191204]
[null,null,"Less: Retirements",null,null,{"$f":"F27","v":108.00659719017686},{"$f":"G27","v":117.94947339000461},128.80767133588301,140.66545375842995,153.61484045052239,167.75632236728396,183.19964146472148]
[null,null,"Closing Balance",null,{"$f":"IF(E3,E9,E33+E34-E35)","v":450},{"$f":"IF(F3,F9,F33+F34-F35)","v":477.13578872481048},478.18898192263737,450.75846683702252,392.22208896498114,299.71630338592217,170.11395283168693,4.9156653858517529E-8]
[]
[null,null,"Net Plant",null,{"$f":"E28-E36","v":550},{"$f":"F28-F36","v":414.85761408501264},{"$f":"G28-G36","v":295.85494749718112},194.47779124691294,112.34871536052435,51.239660489060952,13.085688676012239,-6.1789648952981224E-9]
[]
[null,"New Gross Plant"]
[null,null,"Opening Balance",null,null,{"$f":"E43","v":0},{"$f":"F43","v":400},600,680,760,840,920]
[null,null,"Add: Cap Exp",null,null,{"$f":"F19","v":400},{"$f":"G19","v":200},80,80,80,80,80]
[null,null,"Closing Balance",null,null,{"$f":"SUM(F41:F42)","v":400},{"$f":"SUM(G41:G42)","v":600},680,760,840,920,1000]
[]
[null,null,"Depreciation Expense",null,{"$f":"E30","v":0.14285714285714285},{"$f":"AVERAGE(F43,F41)*$E$45","v":28.571428571428569},{"$f":"AVERAGE(G43,G41)*$E$45","v":71.428571428571431},91.428571428571416,102.85714285714285,114.28571428571428,125.71428571428571,137.14285714285714]
[]
[null,null,"Accumulated Depreciation",null,null,{"$f":"E47+F45","v":28.571428571428569},{"$f":"F47+G45","v":100},191.42857142857142,294.28571428571428,408.57142857142856,534.28571428571422,671.42857142857133]
[]
[null,null,"Total Net Plant",null,{"$f":"E38+E43-E47","v":550},{"$f":"F38+F43-F47","v":786.28618551358409},795.85494749718112,683.0492198183415,578.06300107481002,482.6682319176324,398.79997439029808,328.57142856524968]
[]
[]
["Financing"]
[null,"Cash Balance"]
[null,null,"Opening Balance",null,null,{"$f":"E56","v":150},{"$f":"F56","v":-150},-70,138.40000000000003,355.45200000000006,581.41556000000014,816.55802680000011]
[null,null,"Add: New Surplus Cash",null,null,{"$f":"F85","v":-300},{"$f":"G85","v":80},208.40000000000003,217.05200000000002,225.96356000000003,235.14246680000002,244.59674080400004]
[null,null,"Closing Balance",null,{"$f":"IF(E3,E7,E54+E55)","v":150},{"$f":"F54+F55","v":-150},{"$f":"G54+G55","v":-70},138.40000000000003,355.45200000000006,581.41556000000014,816.55802680000011,1061.1547676040002]
[null,null,"Interest Income",null,0.02]
[]
[null,"Debt Balance"]
[null,null,"Opening Balance",null,null,{"$f":"E62","v":400},{"$f":"F62","v":400},400,400,400,400,400]
[]
[null,null,"Closing Debt Balance",null,{"$f":"IF(E3,E13,E60+E61-#REF!)","v":400},{"$f":"IF(F3,F13,E62)","v":400},{"$f":"IF(G3,G13,F62)","v":400},{"$f":"IF(H3,H13,G62)","v":400},{"$f":"IF(I3,I13,H62)","v":400},{"$f":"IF(J3,J13,I62)","v":400},{"$f":"IF(K3,K13,J62)","v":400},{"$f":"IF(L3,L13,K62)","v":400}]
[null,null,"Interest Expense",null,0.05]
[]
["Profit and Loss"]
[null,null,"EBITDA",null,null,{"$f":"F18","v":100},{"$f":"G18","v":280},{"$f":"H18","v":288.40000000000003},{"$f":"I18","v":297.05200000000002},{"$f":"J18","v":305.96356000000003},{"$f":"K18","v":315.14246680000002},{"$f":"L18","v":324.59674080400004}]
[null,null,"Less: Depreciation",null,null,{"$f":"F45+F30","v":163.71381448641591},{"$f":"G45+G30","v":190.43123801640297},{"$f":"H45+H30","v":192.80572767883956},{"$f":"I45+I30","v":184.98621874353148},{"$f":"J45+J30","v":175.39476915717773},{"$f":"K45+K30","v":163.86825752733444},{"$f":"L45+L30","v":150.22854582504834}]
[null,null,"EBIT",null,null,{"$f":"F66-F67","v":-63.713814486415913},{"$f":"G66-G67","v":89.568761983597028},95.594272321160474,112.06578125646854,130.5687908428223,151.27420927266559,174.36819497895169]
[null,null,"Less: Interest Expense",null,null,{"$f":"F63","v":0},{"$f":"G63","v":0},0,0,0,0,0]
[null,null,"Add: Interest Income",null,null,{"$f":"F57","v":0},{"$f":"G57","v":0},{"$f":"H57","v":0},{"$f":"I57","v":0},{"$f":"J57","v":0},{"$f":"K57","v":0},{"$f":"L57","v":0}]
[null,null,"EBT",null,null,{"$f":"F68-F69+F70","v":-63.713814486415913},{"$f":"G68-G69+G70","v":89.568761983597028},95.594272321160474,112.06578125646854,130.5687908428223,151.27420927266559,174.36819497895169]
[null,null,"Less: Taxes Paid",null,0.3]
[null,null,"Earnings",null,null,{"$f":"F71-F72","v":-63.713814486415913},{"$f":"G71-G72","v":89.568761983597028},{"$f":"H71-H72","v":95.594272321160474},{"$f":"I71-I72","v":112.06578125646854},{"$f":"J71-J72","v":130.5687908428223},{"$f":"K71-K72","v":151.27420927266559},{"$f":"L71-L72","v":174.36819497895169}]
[]
["Cash Flow Statement"]
[null,null,"EBITDA",null,null,{"$f":"F66","v":100},{"$f":"G66","v":280},{"$f":"H66","v":288.40000000000003},{"$f":"I66","v":297.05200000000002},{"$f":"J66","v":305.96356000000003},{"$f":"K66","v":315.14246680000002},{"$f":"L66","v":324.59674080400004}]
[null,null,"Less: Taxes Paid",null,null,{"$f":"F72","v":0},{"$f":"G72","v":0},0,0,0,0,0]
[null,null,"Less: WC Changes"]
[null,null,null,"Net Operating Cash Flow",null,{"$f":"F76-F77-F78","v":100},{"$f":"G76-G77-G78","v":280},288.40000000000003,297.05200000000002,305.96356000000003,315.14246680000002,324.59674080400004]
[null,null,"Less: Capital Expenditures",null,null,{"$f":"F19","v":400},{"$f":"G19","v":200},{"$f":"H19","v":80},{"$f":"I19","v":80},{"$f":"J19","v":80},{"$f":"K19","v":80},{"$f":"L19","v":80}]
[null,null,null,"Cash Before Financing",null,{"$f":"F79-F80","v":-300},{"$f":"G79-G80","v":80},208.40000000000003,217.05200000000002,225.96356000000003,235.14246680000002,244.59674080400004]
[null,null,"Less: Interest Expense",null,null,{"$f":"F69","v":0},{"$f":"G69","v":0},{"$f":"H69","v":0},{"$f":"I69","v":0},{"$f":"J69","v":0},{"$f":"K69","v":0},{"$f":"L69","v":0}]
[null,null,"Add: Income",null,null,{"$f":"F70","v":0},{"$f":"G70","v":0},{"$f":"H70","v":0},{"$f":"I70","v":0},{"$f":"J70","v":0},{"$f":"K70","v":0},{"$f":"L70","v":0}]
[null,null,"Less: Dividends",null,0.6]
[null,null,null,"Surplus Cash",null,{"$f":"F81-F82+F83","v":-300},{"$f":"G81-G82+G83","v":80},208.40000000000003,217.05200000000002,225.96356000000003,235.14246680000002,244.59674080400004]
[]
["Balance Sheet"]
[null,"Equity Balance"]
[null,null,"Opening Balance",null,null,{"$f":"E92","v":300},{"$f":"F92","v":236.28618551358409},325.85494749718112,421.44921981834159,533.51500107481013,664.08379191763242,815.35800119029795]
[null,null,"Add: Net Income",null,null,{"$f":"F73","v":-63.713814486415913},{"$f":"G73","v":89.568761983597028},{"$f":"H73","v":95.594272321160474},{"$f":"I73","v":112.06578125646854},{"$f":"J73","v":130.5687908428223},{"$f":"K73","v":151.27420927266559},{"$f":"L73","v":174.36819497895169}]
[null,null,"Less: Dividends",null,null,{"$f":"F84","v":0},{"$f":"G84","v":0},{"$f":"H84","v":0},{"$f":"I84","v":0},{"$f":"J84","v":0},{"$f":"K84","v":0},{"$f":"L84","v":0}]
[null,null,"Closing Balance",null,{"$f":"IF(E3,E14,E89+E90-E91+#REF!)","v":300},{"$f":"IF(F3,F14,F89+F90-F91)","v":236.28618551358409},{"$f":"IF(G3,G14,G89+G90-G91)","v":325.85494749718112},{"$f":"IF(H3,H14,H89+H90-H91)","v":421.44921981834159},{"$f":"IF(I3,I14,I89+I90-I91)","v":533.51500107481013},{"$f":"IF(J3,J14,J89+J90-J91)","v":664.08379191763242},{"$f":"IF(K3,K14,K89+K90-K91)","v":815.35800119029795},{"$f":"IF(L3,L14,L89+L90-L91)","v":989.72619616924965}]
[]
[null,"Assets"]
[null,null,"Cash Balance",null,{"$f":"E56","v":150},{"$f":"F56","v":-150},{"$f":"G56","v":-70},{"$f":"H56","v":138.40000000000003},{"$f":"I56","v":355.45200000000006},{"$f":"J56","v":581.41556000000014},{"$f":"K56","v":816.55802680000011},{"$f":"L56","v":1061.1547676040002}]
[null,null,"Net Plant",null,{"$f":"E49","v":550},{"$f":"F49","v":786.28618551358409},{"$f":"G49","v":795.85494749718112},{"$f":"H49","v":683.0492198183415},{"$f":"I49","v":578.06300107481002},{"$f":"J49","v":482.6682319176324},{"$f":"K49","v":398.79997439029808},{"$f":"L49","v":328.57142856524968}]
[null,null,null,"Total",{"$f":"SUM(E95:E96)","v":700},{"$f":"SUM(F95:F96)","v":636.28618551358409},725.85494749718112,821.44921981834159,933.51500107481002,1064.0837919176324,1215.3580011902982,1389.7261961692498]
[]
[null,null,"Debt",null,{"$f":"E62","v":400},{"$f":"F62","v":400},{"$f":"G62","v":400},{"$f":"H62","v":400},{"$f":"I62","v":400},{"$f":"J62","v":400},{"$f":"K62","v":400},{"$f":"L62","v":400}]
[null,null,"Equity",null,{"$f":"E92","v":300},{"$f":"F92","v":236.28618551358409},325.85494749718112,421.44921981834159,533.51500107481013,664.08379191763242,815.35800119029795,989.72619616924965]
[null,null,null,"Total",{"$f":"SUM(E99:E100)","v":700},{"$f":"SUM(F99:F100)","v":636.28618551358409},725.85494749718112,821.44921981834159,933.51500107481013,1064.0837919176324,1215.358001190298,1389.7261961692498]
[]
[null,null,"Difference",null,{"$f":"E101-E97","v":0},{"$f":"F101-F97","v":0},0,0,0,0,0,0]
[null,null,"Test",null,{"$f":"ROUND(E103,3)=0","v":true},{"$f":"ROUND(F103,3)=0","v":true},true,true,true,true,true,true]

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