{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Multiple","Relationships"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":56,"comments":1,"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":"Multiple","index":0,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,6,0,7],[7,1,7,2]]}
[null,"Company",null,null,null,null,"Estimated Multiple based on Growth and Unlevered cost of equity assumptions below"]
[null,"M_d",{"$f":"debt/ebitda","v":{"$error":"#DIV/0!"}},"(1-t)",{"$f":"1-tax","v":0.7},null,null,"EBITDA*x"]
[null,"em:",{"$f":"ebitda/sales","v":{"$error":"#DIV/0!"}},"j/em",{"$f":"j/em","v":{"$error":"#DIV/0!"}},null,"Multiple for n periods      (Term I)",{"$f":"E9/ebitda","v":{"$error":"#DIV/0!"}}]
[null,"j:",{"$f":"d_a/sales","v":{"$error":"#DIV/0!"}},"1-j/em",{"$f":"1-E3","v":{"$error":"#DIV/0!"}},null,"PV of Terminal Multiple  (Term II)",{"$f":"E8*(1/rho)*((1+gr_eda)/(1+rho))^periods","v":{"$error":"#DIV/0!"}}]
[null,"r_d:",{"$f":"int/lt_debt","v":{"$error":"#DIV/0!"}},"1/(rho-ge)",{"$f":"1/(rho-gr_eda)","v":10},null,"Leverage Multiple            (Term III)",{"$f":"tax*a_M_d","v":{"$error":"#DIV/0!"}}]
[null,"t",0.3,"((1+ge)/(1+rho))^n",{"$f":"((1+gr_eda)/(1+rho))^periods","v":0.62092132305915504},null,"Estimated Multiple: M_ed",{"$f":"SUM(H3:H5)","v":{"$error":"#DIV/0!"}}]
[null,"Market EV/EBITDA",{"$f":"e_v/ebitda","v":{"$error":"#DIV/0!"}},"1/rho",{"$f":"1/rho","v":10},null,"Price per share at M_ed (GC):",{"$f":"(H6*ebitda-debt-ant_debt)/o_shares","v":{"$error":"#DIV/0!"}}]
[null,"GAAP numbers 10K",null,"(1-t)*(1-j/em)",{"$f":"E2*E4","v":{"$error":"#DIV/0!"}},null,"Surplus Cash per share   (RC):",{"$f":"cash/o_shares","v":{"$error":"#DIV/0!"}}]
[null,"CAPEX + NWC",null,"(1-t)(1-j/em)+((j-cw)/em))",{"$f":"SUM(M32:M41)","v":{"$error":"#DIV/0!"}},null,"Total value per share",{"$f":"H8+H7","v":{"$error":"#DIV/0!"}}]
[null,"D&A",null,"1-j/em-r_d*M_d",{"$f":"E4-r_d*M_d","v":{"$error":"#DIV/0!"}},null,"Discount (Premium)",{"$f":"(H9-pps)/H9","v":{"$error":"#DIV/0!"}}]
[null,"Sales",null,"1/rho*(1+rho)^n",{"$f":"1/(rho*(1+rho)^periods)","v":6.2092132305915495},null,"Number of growth years",5]
[null,"EBITDA",{"$f":"IF(C24=0,ebit+d_a, ebit+d_a+rent)","v":0},"(1+ge)^n",{"$f":"(1+gr_eda)^periods","v":1},null,"Assumed Unlevered cost of equity",0.1]
[null,"EBIT",null,"cw",{"$f":"cw_am/sales","v":{"$error":"#DIV/0!"}},null,"Imput Growth in EBITDA",0]
[null,"Ajusted LT Debt",{"$f":"IF(C26=0,IF(C24=0,lt_debt,lt_debt+cap_leases))","v":0},"Price per share"]
[null,"LT Debt",null,"# of Shares outstanding (000)"]
[null,"Surplus Cash",null,"Float (%)"]
[null,"Mkt Cap",{"$f":"pps*o_shares","v":0},"Float Shares",{"$f":"E16*o_shares","v":0}]
[null,"EV",{"$f":"debt+mkt_cap-cash","v":0}]
[null,"Interest"]
[null,"Extra Borrowing",{"$f":"MAX(-SUM(O32:O41)-cash,0)","v":{"$error":"#DIV/0!"}}]
[null,"Anticipated M_d",{"$f":"(C20+lt_debt)/ebitda","v":{"$error":"#DIV/0!"}}]
[null,"Annual Rent",0]
[null,"Capitalized Leases",{"$f":"rent*7","v":0}]
[null,"EBITDAR Analysis?",0]
[null,"(Ebitda - Capex)/EV",{"$f":"(ebitda-cw_am)/e_v","v":{"$error":"#DIV/0!"}}]
[null,"WACC",0]
[]
[]
[]
[null,null,null,null,null,null,null,null,"NOPAT+DA","UFCF","D-UFCF",null,"DUFCF-G",null,"Financing"]
[null,null,null,null,"Growth Factor",null,"Discount Factor",null,{"$f":"E2*E4*ebitda+d_a","v":{"$error":"#DIV/0!"}}]
[null,1,{"$f":"IF(B32<=periods,1,0)","v":1},{"$f":"((1+gr_eda)/(1+rho))^B32","v":0.90909090909090906},{"$f":"(1+gr_eda)^B32","v":1},null,{"$f":"1/(1+rho)^B32","v":0.90909090909090906},null,{"$f":"($E$2*$E$4*ebitda+d_a)*$E32","v":{"$error":"#DIV/0!"}},{"$f":"I32-cw_am","v":{"$error":"#DIV/0!"}},{"$f":"G32*J32","v":{"$error":"#DIV/0!"}},{"$f":"AND(C32=1,J32>0)","v":{"$error":"#DIV/0!"}},{"$f":"K32*L32","v":{"$error":"#DIV/0!"}},{"$f":"AND(C32=1,J32<0)","v":{"$error":"#DIV/0!"}},{"$f":"K32*N32","v":{"$error":"#DIV/0!"}}]
[null,2,1,0.82644628099173545,1,null,0.82644628099173545,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"G33*J33","v":{"$error":"#DIV/0!"}},{"$f":"AND(C33=1,J33>0)","v":{"$error":"#DIV/0!"}},{"$f":"K33*L33","v":{"$error":"#DIV/0!"}},{"$f":"AND(C33=1,J33<0)","v":{"$error":"#DIV/0!"}},{"$f":"K33*N33","v":{"$error":"#DIV/0!"}}]
[null,3,1,0.75131480090157765,1,null,0.75131480090157754,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,4,1,0.68301345536507052,1,null,0.68301345536507052,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,5,1,0.62092132305915504,1,null,0.62092132305915493,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,6,0,0.56447393005377722,1,null,0.56447393005377722,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,7,0,0.51315811823070656,1,null,0.51315811823070645,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,8,0,0.4665073802097332,1,null,0.46650738020973315,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,9,0,0.42409761837248472,1,null,0.42409761837248466,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,10,0,0.38554328942953153,1,null,0.38554328942953148,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Relationships","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"Actual","Calculated",null,"Data"]
["M_ed",14.97,{"$f":"(1-F3)*(1-F5)*((1-F9/F11)-F4*F12)*B3+F12","v":15.451931038158694}]
["M_pe",25.68,{"$f":"(B2-F12)/((1-r_dp)*(1-r_t)*((1-F9/F11)-r_r_d*F12))","v":24.830445279737525},null,"dp:",0]
["M_e",18.329999999999998,null,null,"r_d:",{"$f":"7.3/r_td","v":2.4999999999999998E-2}]
["M_R",2.84,null,null,"t:",0.28939999999999999]
[null,null,null,null,"EBITDA:",330.2]
[null,null,null,null,"D:",292]
[null,null,null,null,"DA:",59.3]
[null,null,null,null,"j:",{"$f":"F8/F10","v":3.5335478488857104E-2}]
[null,null,null,null,"R:",1678.2]
[null,null,null,null,"em:",{"$f":"F6/F10","v":0.1967584316529615}]
[null,null,null,null,"M_d:",{"$f":"F7/F6","v":0.88431253785584496}]