{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Ecoonomic Analysis Exercise","Ecoonomic Analysis","Background Data","Sheet3"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":0,"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":"Ecoonomic Analysis Exercise","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Cost to Shareholder"]
[null,null,"Premium for Target (NRG)"]
[null,null,"Current Share Price",22]
[null,null,"Shares",264]
[null,null,"Maket Cap"]
[]
[null,null,"Premium",0.37]
[null,null,"Consideration"]
[]
[null,null,"Premium 000's"]
[null,null,"After Tax"]
[]
[null,"Net Benefits",null,"Growt Rate",null,null,null,{"$f":"(H15/E15)^(1/3)","v":1.1856311014966876}]
[null,null,"Year",null,1,2,3,4]
[null,null,"Pre-tax Synergy",null,180,null,null,300]
[null,null,"Cost to Achieve"]
[null,null,"Net"]
[null,null,"Disc Rate",0.08]
[null,null,"NPV"]
[null,null,"Transaction Costs"]
[null,null,"Net Pre-tax"]
[]
[null,null,"Federal Tax Rate",0.35]
[null,null,"State Tax Rate",0.04]
[null,null,"Combined Rate"]
[]
[null,null,"After Tax Synergies"]
[]
[null,null,"Net Economic Cost"]

{"sheet":"Ecoonomic Analysis","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Cost to Shareholder"]
[null,null,"Premium for Target (NRG)"]
[null,null,"Current Share Price",22]
[null,null,"Shares",264]
[null,null,"Maket Cap",{"$f":"D3*D4","v":5808}]
[]
[null,null,"Premium",0.37]
[null,null,"Consideration",{"$f":"D5*(1+D7)","v":7956.9600000000009}]
[]
[null,null,"Premium 000's",{"$f":"D8-D5","v":2148.9600000000009}]
[null,null,"After Tax"]
[]
[null,"Net Benefits",null,"Growt Rate",null,null,null,{"$f":"(H15/E15)^(1/3)","v":1.1856311014966876}]
[null,null,"Year",null,1,2,3,4]
[null,null,"Pre-tax Synergy",null,180,{"$f":"E15*$H$13","v":213.41359826940376},{"$f":"F15*$H$13","v":253.02979959052476},300]
[null,null,"Cost to Achieve",100]
[null,null,"Net",{"$f":"D15-D16","v":-100},{"$f":"E15-E16","v":180},213.41359826940376,253.02979959052476,300,{"$f":"H17/D18","v":3750}]
[null,null,"Disc Rate",0.08]
[null,null,"NPV",{"$f":"NPV(D18,17:17)","v":2984.4385063080149}]
[null,null,"Transaction Costs",-500]
[null,null,"Net Pre-tax",{"$f":"SUM(D19:D20)","v":2484.4385063080149}]
[]
[null,null,"Federal Tax Rate",0.35]
[null,null,"State Tax Rate",0.04]
[null,null,"Combined Rate",{"$f":"D24+(1-D24)*D23","v":0.37599999999999995}]
[]
[null,null,"After Tax Synergies",{"$f":"D21*(1-D25)","v":1550.2896279362017}]
[]
[null,null,"Net Economic Cost",{"$f":"D27-D10","v":-598.67037206379928}]

{"sheet":"Background Data","index":2,"n_rows":46,"n_cols":22,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010,2011,2012]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exelon",4.53,6.25,6.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pro Forma",4.96,6.37,6.8]

{"sheet":"Sheet3","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"www.financeenergyinstitute.com"]