{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["ConvertibleBond"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"ConvertibleBond","index":0,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Convertible Bond Valuation by Binomial Tree",{"$nulls":12},"INPUTS"]
[{"$nulls":14},"Stock price",100]
[{"$nulls":14},"Volatility",0.25]
[{"$nulls":14},"Risk Free Rate",{"$f":"0.02","v":0.02}]
[null,"t_0",null,"t_0+dt",null,"t_0+2*dt",null,"t_0+3*dt",null,"t_0+4*dt",null,"t_0+5*dt",null,null,"Risky Rate (rfr+cds)",{"$f":"0.06+rfr","v":0.08}]
[{"$nulls":11},{"$f":"J9*u","v":349.034295746184},null,null,"Coupon",0.06]
[{"$nulls":11},{"$f":"M8*L9+(1-L9)*pv","v":3490.3429574618399},{"$f":"L7*cr","v":3490.3429574618399},null,"Maturity (in years)",5]
[{"$nulls":9},{"$f":"H11*u","v":271.82818284590445},null,{"$f":"IF(M8>=pv,1,0)","v":1},null,null,"Conversion ratio",10]
[{"$nulls":9},{"$f":"((p*L8)/(J12))+((1-p)*L12/(J12))+1000*coupon","v":2778.818396043428},{"$f":"J9*cr","v":2718.2818284590444}]
[{"$nulls":7},{"$f":"F13*u","v":211.70000166126744},null,{"$f":"(p*(L9)+((1-p)*L13))","v":1},null,{"$f":"J13*u","v":211.70000166126744}]
[{"$nulls":7},{"$f":"((p*J10)/(H14))+((1-p)*J14/(H14))+1000*coupon","v":2236.6593870203151},{"$f":"H11*cr","v":2117.0000166126742},{"$f":"((1+rfr)*J11)+((1+cs)*(1-J11))","v":1.02},null,{"$f":"M12*L13+(1-L13)*pv","v":2117.0000166126742},{"$f":"L11*cr","v":2117.0000166126742},null,"MODEL PARAMETERS"]
[{"$nulls":5},{"$f":"D15*u","v":164.87212707001279},null,{"$f":"(p*(J11)+((1-p)*J15))","v":1},null,{"$f":"H15*u","v":164.87212707001279},null,{"$f":"IF(M12>=pv,1,0)","v":1},null,null,"dt ",1]
[{"$nulls":5},{"$f":"((p*H12)/(F16))+((1-p)*H16/(F16))+1000*coupon","v":1828.8580365964763},{"$f":"F13*cr","v":1648.7212707001279},{"$f":"((1+rfr)*H13)+((1+cs)*(1-H13))","v":1.02},null,{"$f":"((p*L12)/(J16))+((1-p)*L16/(J16))+1000*coupon","v":1709.0467153910647},{"$f":"J13*cr","v":1648.7212707001279},null,null,null,"u",{"$f":"EXP(P4*SQRT(P13))","v":1.2840254166877414}]
[null,null,null,{"$f":"B17*u","v":128.40254166877415},null,{"$f":"(p*(H13)+((1-p)*H17))","v":0.8576066433797771},null,{"$f":"F13*d","v":128.40254166877415},null,{"$f":"(p*(L13)+((1-p)*L17))","v":1},null,{"$f":"J17*u","v":128.40254166877415},null,null,"d",{"$f":"1/u","v":0.77880078307140488}]
[null,null,null,{"$f":"((p*F14)/(D18))+((1-p)*F18/(D18))+1000*coupon","v":1529.8212554325519},{"$f":"D15*cr","v":1284.0254166877414},{"$f":"((1+rfr)*F15)+((1+cs)*(1-F15))","v":1.0285436013972133},null,{"$f":"((p*J14)/(H18))+((1-p)*J18/(H18))+1000*coupon","v":1437.5049291376786},{"$f":"H15*cr","v":1284.0254166877414},{"$f":"((1+rfr)*J15)+((1+cs)*(1-J15))","v":1.02},null,{"$f":"M16*L17","v":1284.0254166877414},{"$f":"L15*cr","v":1284.0254166877414},null,"Probability Up",{"$f":"(EXP(rfr*P13)-d)/(u-d)","v":0.47780836660206977}]
[null,{"$f":"P3","v":100},null,{"$f":"(p*(F15)+((1-p)*F19))","v":0.65349643195469309},null,{"$f":"D15*d","v":100},null,{"$f":"(p*(J15)+((1-p)*J19))","v":0.7273158980092016},null,{"$f":"H19*u","v":100},null,{"$f":"IF(M16>=pv,1,0)","v":1},{"$f":"L17","v":1}]
[null,{"$f":"((p*D16)/(B20))+((1-p)*D20/(B20))+1000*coupon","v":1319.0966019486623},{"$f":"B17*cr","v":1000},{"$f":"((1+rfr)*D17)+((1+cs)*(1-D17))","v":1.0407902140827185},null,{"$f":"((p*H16)/(F20))+((1-p)*H20/(F20))+1000*coupon","v":1256.1133996413528},{"$f":"F17*cr","v":1000},{"$f":"((1+rfr)*H17)+((1+cs)*(1-H17))","v":1.0363610461194479},null,{"$f":"((p*L16)/(J20))+((1-p)*L20/(J20))+1000*coupon","v":1170.0601671696663},{"$f":"J17*cr","v":1000},null,null,null,"Par Value",{"$f":"1000*(1+P7)","v":1060}]
[null,{"$f":"(p*(D17)+((1-p)*D21))","v":0.45844529849904803},null,{"$f":"B17*d","v":77.880078307140494},null,{"$f":"(p*(H17)+((1-p)*H21))","v":0.46673440726805043},null,{"$f":"F17*d","v":77.880078307140494},null,{"$f":"(p*(L17)+((1-p)*L21))","v":0.47780836660206977},null,{"$f":"J21*u","v":77.880078307140479}]
[null,{"$f":"((1+rfr)*B19)+((1+cs)*(1-B19))","v":1.0524932820900572},null,{"$f":"((p*F18)/(D22))+((1-p)*F22/(D22))+1000*coupon","v":1137.9525863624954},{"$f":"D19*cr","v":778.80078307140491},{"$f":"((1+rfr)*F19)+((1+cs)*(1-F19))","v":1.0519959355639172},null,{"$f":"((p*J18)/(H22))+((1-p)*J22/(H22))+1000*coupon","v":1094.3387756024695},{"$f":"H19*cr","v":778.80078307140491},{"$f":"((1+rfr)*J19)+((1+cs)*(1-J19))","v":1.0513314980038757},null,{"$f":"(M20*L21)+((1-L21)*pv)","v":1060},{"$f":"L19*cr","v":778.80078307140479}]
[null,null,null,{"$f":"(p*(F19)+((1-p)*F23))","v":0.27997238258140777},null,{"$f":"D19*d","v":60.653065971263345},null,{"$f":"(p*(J19)+((1-p)*J23))","v":0.22830083519493791},null,{"$f":"H23*u","v":60.653065971263338},null,{"$f":"IF(M20>=pv,1,0)","v":0}]
[null,null,null,{"$f":"((1+rfr)*D21)+((1+cs)*(1-D21))","v":1.0632016570451157},null,{"$f":"((p*H20)/(F24))+((1-p)*H24/(F24))+1000*coupon","v":1045.400671655475},{"$f":"F21*cr","v":606.53065971263345},{"$f":"((1+rfr)*H21)+((1+cs)*(1-H21))","v":1.0663019498883037},null,{"$f":"((p*L20)/(J24))+((1-p)*L24/(J24))+1000*coupon","v":1041.4814814814813},{"$f":"J21*cr","v":606.53065971263334}]
[{"$nulls":5},{"$f":"(p*(H21)+((1-p)*H25))","v":0.1090840491583816},null,{"$f":"F21*d","v":47.236655274101473},null,{"$f":"(p*(L21)+((1-p)*L25))","v":0},null,{"$f":"J25*u","v":47.236655274101473}]
[{"$nulls":5},{"$f":"((1+rfr)*F23)+((1+cs)*(1-F23))","v":1.0734549570504972},null,{"$f":"((p*J22)/(H26))+((1-p)*J26/(H26))+1000*coupon","v":1024.3347050754455},{"$f":"H23*cr","v":472.36655274101474},{"$f":"((1+rfr)*J23)+((1+cs)*(1-J23))","v":1.08},null,{"$f":"(M24*L25)+((1-L25)*pv)","v":1060},{"$f":"L23*cr","v":472.36655274101474}]
[{"$nulls":7},{"$f":"(p*(J23)+((1-p)*J27))","v":0},null,{"$f":"H23*d","v":36.787944117144235},null,{"$f":"IF(M24>=pv,1,0)","v":0}]
[{"$nulls":7},{"$f":"((1+rfr)*H25)+((1+cs)*(1-H25))","v":1.08},null,{"$f":"((p*L24)/(J28))+((1-p)*L28/(J28))+1000*coupon","v":1041.4814814814813},{"$f":"J25*cr","v":367.87944117144235}]
[{"$nulls":9},{"$f":"(p*(L25)+((1-p)*L29))","v":0},null,{"$f":"J25*d","v":28.650479686019011}]
[{"$nulls":9},{"$f":"((1+rfr)*J27)+((1+cs)*(1-J27))","v":1.08},null,{"$f":"(M28*L29)+((1-L29)*pv)","v":1060},{"$f":"L27*cr","v":286.50479686019014}]
[{"$nulls":11},{"$f":"IF(M28>=pv,1,0)","v":0}]
[]
[]
[]
[null,"stock price"]
[null,"convertible price"]
[null,"conversion probability"]
[null,"credit-adjusted discount rate"]