{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Sheet1","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["1a)",{"$f":"(150)/(10+3)","v":11.538461538461538},{"$f":"getformula(B2)","v":"<--  =(150)/(10+3)"}]
[]
["b)",{"$f":"(150+(10*8))/(10+3+10)","v":10},{"$f":"getformula(B4)","v":"<--  =(150+(10*8))/(10+3+10)"}]
[]
["c)",{"$f":"(150)/(10+3+10-(80/19))","v":7.9831932773109235},{"$f":"getformula(B6)","v":"<--  =(150)/(10+3+10-(80/19))"}]
[]
["d)",{"$f":"(150-(3.77*10))/(10+3)","v":8.638461538461538},{"$f":"getformula(B8)","v":"<--  =(150-(3.77*10))/(10+3)"}]
[]
["2)",{"$f":"100+(3*3.5)-(4.5*5.2)","v":87.1},{"$f":"getformula(B10)","v":"<--  =100+(3*3.5)-(4.5*5.2)"}]
[]
["3)","BV of Debt",200,"FV"]
[null,"Average Maturity",5,"N"]
[null,"Rd",7.1999999999999995E-2,"I(%)"]
[null,"Interest Expense",26,"PMT"]
[null,"MV of debt",{"$f":"-PV(C14,C13,C15,C12)","v":247.30867313130975},{"$f":"getformula(C16)","v":"<--  =-PV(C14,C13,C15,C12)"}]
[]
["4)","FCFE",{"$f":"20+2-6-(0-5)","v":21},{"$f":"getformula(C18)","v":"<--  =20+2-6-(0-5)"}]
[null,"Re",{"$f":"1.1*0.07+0.015","v":9.2000000000000012E-2},{"$f":"getformula(C19)","v":"<--  =1.1*0.07+0.015"}]
[null,"Equity Value",{"$f":"(C18*(1+0.03))/(C19-0.03)","v":348.87096774193537},{"$f":"getformula(C20)","v":"<--  =(C18*(1+0.03))/(C19-0.03)"}]
[]
[null,"Per share value",{"$f":"(C20+3)/5","v":70.374193548387069},{"$f":"getformula(C22)","v":"<--  =(C20+3)/5"}]