{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Convertible Bond Pricing","Conversion Probabilities","Credit Discount Rates","Binomial Stock Tree"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":13,"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":"Convertible Bond Pricing","index":0,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[6,1,7,1],[6,0,7,0],[6,3,7,4],[2,0,3,0],[2,1,3,1],[4,0,5,0],[4,1,5,1],[2,3,3,4],[4,3,5,4],[8,0,9,0],[8,1,9,1],[8,3,9,4],[10,0,11,0],[10,1,11,1],[10,3,11,4],[21,1,22,1],[21,3,22,4],[21,0,22,0],[12,0,13,0],[12,1,13,1],[12,3,13,4],[16,3,16,4],[18,3,18,5],[19,3,19,5],[15,3,15,4]]}
[null,null,null,null,null,null,null,null,null,null,null,"Stock Price Today",{"$f":"'Binomial Stock Tree'!B9","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,"Conversion Probability Today",{"$f":"'Conversion Probabilities'!B9","v":0.40778957884986156}]
["Initial Stock Price",{"$f":"C3/10","v":100},1000,"InitialStockPrice",null,null,null,null,null,null,null,"Credit Discount Rate Today",{"$f":"'Credit Discount Rates'!B9","v":9.5532625269008298E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"Convertible Bond Price Today",{"$f":"B31","v":1240.7196729239508}]
["Stock Volatility",{"$f":"C5/1000","v":0.25},250,"StockVolatility"]
[]
["Risk Free Rate",{"$f":"C7/10000","v":0.06},600,"RiskFreeRate"]
[]
["Conversion Price",{"$f":"C9","v":1070},1070,"ConversionPrice"]
[]
["Credit Risk Premium",{"$f":"C11/10000","v":0.06},600,"CreditRiskPremium"]
[]
["Conversion Ratio",10,null,"ConversionRatio"]
[]
["Transition Multiplier"]
["Up Factor",{"$f":"EXP(StockVolatility*SQRT(1))","v":1.2840254166877414},null,"LambdaUp"]
["Down Factor",{"$f":"1/LambdaUp","v":0.77880078307140488},null,"LambdaDown"]
["Transition Probability"]
["Probability Up",{"$f":"(EXP(RiskFreeRate*1)-LambdaDown)/(LambdaUp-LambdaDown)","v":0.56021766288001273},null,"TransitionProbabilityUp"]
["Probability Down",{"$f":"1-TransitionProbabilityUp","v":0.43978233711998727},null,"TransitionProbabilityDown"]
["Convertible Bond"]
["Coupon",{"$f":"100*C22/100","v":70},70,"Coupon"]
[]
[]
[]
["Convertible Pricing Tree"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Binomial Stock Tree'!J5*ConversionRatio>ConverstionPrice,'Binomial Stock Tree'!J5*ConversionRatio,1000+Coupon)","v":2718.2818284590444}]
[null,null,null,null,null,null,null,{"$f":"TransitionProbabilityUp*(J27/(1+'Credit Discount Rates'!H6))+TransitionProbabilityDown*(J29/(1+'Credit Discount Rates'!H6))+Coupon","v":2190.6679119589348}]
[null,null,null,null,null,{"$f":"TransitionProbabilityUp*(H28/(1+'Credit Discount Rates'!F7))+TransitionProbabilityDown*(H30/(1+'Credit Discount Rates'!F7))+Coupon","v":1770.6538535396858},null,null,null,{"$f":"IF('Binomial Stock Tree'!J7*ConversionRatio>ConverstionPrice,'Binomial Stock Tree'!J7*ConversionRatio,1000+Coupon)","v":1648.7212707001279}]
[null,null,null,{"$f":"TransitionProbabilityUp*(F29/(1+'Credit Discount Rates'!D8))+TransitionProbabilityDown*(F31/(1+'Credit Discount Rates'!D8))+Coupon","v":1458.1757121961602},null,null,null,{"$f":"TransitionProbabilityUp*(J29/(1+'Credit Discount Rates'!H8))+TransitionProbabilityDown*(J31/(1+'Credit Discount Rates'!H8))+Coupon","v":1353.3455798345676}]
[null,{"$f":"TransitionProbabilityUp*(D30/(1+'Credit Discount Rates'!B9))+TransitionProbabilityDown*(D32/(1+'Credit Discount Rates'!B9))+Coupon","v":1240.7196729239508},null,null,null,{"$f":"TransitionProbabilityUp*(H30/(1+'Credit Discount Rates'!F9))+TransitionProbabilityDown*(H32/(1+'Credit Discount Rates'!F9))+Coupon","v":1168.0164279721159},null,null,null,{"$f":"IF('Binomial Stock Tree'!J9*ConversionRatio>ConverstionPrice,'Binomial Stock Tree'!J9*ConversionRatio,1000+Coupon)","v":1070}]
[null,null,null,{"$f":"TransitionProbabilityUp*(F31/(1+'Credit Discount Rates'!D10))+TransitionProbabilityDown*(F33/(1+'Credit Discount Rates'!D10))+Coupon","v":1058.8551832868873},null,null,null,{"$f":"TransitionProbabilityUp*(J31/(1+'Credit Discount Rates'!H10))+TransitionProbabilityDown*(J33/(1+'Credit Discount Rates'!H10))+Coupon","v":1025.3571428571427}]
[null,null,null,null,null,{"$f":"TransitionProbabilityUp*(H32/(1+'Credit Discount Rates'!F11))+TransitionProbabilityDown*(H34/(1+'Credit Discount Rates'!F11))+Coupon","v":1006.731404357118},null,null,null,{"$f":"IF('Binomial Stock Tree'!J11*ConversionRatio>ConverstionPrice,'Binomial Stock Tree'!J11*ConversionRatio,1000+Coupon)","v":1070}]
[null,null,null,null,null,null,null,{"$f":"TransitionProbabilityUp*(J33/(1+'Credit Discount Rates'!H12))+TransitionProbabilityDown*(J35/(1+'Credit Discount Rates'!H12))+Coupon","v":1079.433962264151}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Binomial Stock Tree'!J13*ConversionRatio>ConverstionPrice,'Binomial Stock Tree'!J13*ConversionRatio,1000+Coupon)","v":1070}]
[]
[]
[null,null,null,"Node 1",null,"Node 2",null,"Node 3",null,"Node 4"]

{"sheet":"Conversion Probabilities","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Conversion Probabilities"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Binomial Stock Tree'!J5*ConversionRatio>1070,1,0)","v":1}]
[null,null,null,null,null,null,null,{"$f":"TransitionProbabilityUp*J5+TransitionProbabilityDown*J7","v":1}]
[null,null,null,null,null,{"$f":"TransitionProbabilityUp*H6+TransitionProbabilityDown*H8","v":0.80659149595728186},null,null,null,{"$f":"IF('Binomial Stock Tree'!J7*ConversionRatio>1070,1,0)","v":1}]
[null,null,null,{"$f":"TransitionProbabilityUp*F7+TransitionProbabilityDown*F9","v":0.58988977572541978},null,null,null,{"$f":"TransitionProbabilityUp*J7+TransitionProbabilityDown*J9","v":0.56021766288001273}]
[null,{"$f":"TransitionProbabilityUp*D8+TransitionProbabilityDown*D10","v":0.40778957884986156},null,null,null,{"$f":"TransitionProbabilityUp*H8+TransitionProbabilityDown*H10","v":0.31384382980274361},null,null,null,{"$f":"IF('Binomial Stock Tree'!J9*ConversionRatio>1070,1,0)","v":0}]
[null,null,null,{"$f":"TransitionProbabilityUp*F9+TransitionProbabilityDown*F11","v":0.17582085684140553},null,null,null,{"$f":"TransitionProbabilityUp*J9+TransitionProbabilityDown*J11","v":0}]
[null,null,null,null,null,{"$f":"TransitionProbabilityUp*H10+TransitionProbabilityDown*H12","v":0},null,null,null,{"$f":"IF('Binomial Stock Tree'!J11*ConversionRatio>1070,1,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"TransitionProbabilityUp*J11+TransitionProbabilityDown*J13","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Binomial Stock Tree'!J13*ConversionRatio>1070,1,0)","v":0}]
[]
[]
[null,null,null,"Node 1",null,"Node 2",null,"Node 3",null,"Node 4"]

{"sheet":"Credit Discount Rates","index":2,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,3]]}
[]
[]
["Credit Discount Rates"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"'Conversion Probabilities'!J5*RiskFreeRate+((1-'Conversion Probabilities'!J5)*(RiskFreeRate+IF('Binomial Stock Tree'!J5>50,CreditRiskPremium,0)))","v":0.06}]
[null,null,null,null,null,null,null,{"$f":"'Conversion Probabilities'!H6*RiskFreeRate+((1-'Conversion Probabilities'!H6)*(RiskFreeRate+IF('Binomial Stock Tree'!H6>50,CreditRiskPremium,0)))","v":0.06}]
[null,null,null,null,null,{"$f":"'Conversion Probabilities'!F7*RiskFreeRate+((1-'Conversion Probabilities'!F7)*(RiskFreeRate+IF('Binomial Stock Tree'!F7>50,CreditRiskPremium,0)))","v":7.1604510242563091E-2},null,null,null,{"$f":"'Conversion Probabilities'!J7*RiskFreeRate+((1-'Conversion Probabilities'!J7)*(RiskFreeRate+IF('Binomial Stock Tree'!J7>50,CreditRiskPremium,0)))","v":0.06}]
[null,null,null,{"$f":"'Conversion Probabilities'!D8*RiskFreeRate+((1-'Conversion Probabilities'!D8)*(RiskFreeRate+IF('Binomial Stock Tree'!D8>50,CreditRiskPremium,0)))","v":8.4606613456474813E-2},null,null,null,{"$f":"'Conversion Probabilities'!H8*RiskFreeRate+((1-'Conversion Probabilities'!H8)*(RiskFreeRate+IF('Binomial Stock Tree'!H8>50,CreditRiskPremium,0)))","v":8.6386940227199227E-2}]
[null,{"$f":"'Conversion Probabilities'!B9*RiskFreeRate+((1-'Conversion Probabilities'!B9)*(RiskFreeRate+IF('Binomial Stock Tree'!B9>50,CreditRiskPremium,0)))","v":9.5532625269008298E-2},null,null,null,{"$f":"'Conversion Probabilities'!F9*RiskFreeRate+((1-'Conversion Probabilities'!F9)*(RiskFreeRate+IF('Binomial Stock Tree'!F9>50,CreditRiskPremium,0)))","v":0.10116937021183538},null,null,null,{"$f":"'Conversion Probabilities'!J9*RiskFreeRate+((1-'Conversion Probabilities'!J9)*(RiskFreeRate+IF('Binomial Stock Tree'!J9>50,CreditRiskPremium,0)))","v":0.12}]
[null,null,null,{"$f":"'Conversion Probabilities'!D10*RiskFreeRate+((1-'Conversion Probabilities'!D10)*(RiskFreeRate+IF('Binomial Stock Tree'!D10>50,CreditRiskPremium,0)))","v":0.10945074858951567},null,null,null,{"$f":"'Conversion Probabilities'!H10*RiskFreeRate+((1-'Conversion Probabilities'!H10)*(RiskFreeRate+IF('Binomial Stock Tree'!H10>50,CreditRiskPremium,0)))","v":0.12}]
[null,null,null,null,null,{"$f":"'Conversion Probabilities'!F11*RiskFreeRate+((1-'Conversion Probabilities'!F11)*(RiskFreeRate+IF('Binomial Stock Tree'!F11>50,CreditRiskPremium,0)))","v":0.12},null,null,null,{"$f":"'Conversion Probabilities'!J11*RiskFreeRate+((1-'Conversion Probabilities'!J11)*(RiskFreeRate+IF('Binomial Stock Tree'!J11>50,CreditRiskPremium,0)))","v":0.12}]
[null,null,null,null,null,null,null,{"$f":"'Conversion Probabilities'!H12*RiskFreeRate+((1-'Conversion Probabilities'!H12)*(RiskFreeRate+IF('Binomial Stock Tree'!H12>50,CreditRiskPremium,0)))","v":0.06}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Conversion Probabilities'!J13*RiskFreeRate+((1-'Conversion Probabilities'!J13)*(RiskFreeRate+IF('Binomial Stock Tree'!J13>50,CreditRiskPremium,0)))","v":0.06}]
[]
[]
[null,null,null,"Node 1",null,"Node 2",null,"Node 3",null,"Node 4"]
[]
["*No Credit Risk Premium for Stock Price less than 50"]

{"sheet":"Binomial Stock Tree","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Binomial Stock Tree"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"H6*(LambdaUp)","v":271.82818284590445}]
[null,null,null,null,null,null,null,{"$f":"F7*(LambdaUp)","v":211.70000166126744}]
[null,null,null,null,null,{"$f":"D8*(LambdaUp)","v":164.87212707001279},null,null,null,{"$f":"H6*LambdaDown","v":164.87212707001279}]
[null,null,null,{"$f":"B9*(LambdaUp)","v":128.40254166877415},null,null,null,{"$f":"F7*LambdaDown","v":128.40254166877415}]
[null,{"$f":"InitialStockPrice","v":100},null,null,null,{"$f":"D8*LambdaDown","v":100},null,null,null,{"$f":"H8*LambdaDown","v":100}]
[null,null,null,{"$f":"B9*LambdaDown","v":77.880078307140494},null,null,null,{"$f":"F9*LambdaDown","v":77.880078307140494}]
[null,null,null,null,null,{"$f":"D10*LambdaDown","v":60.653065971263345},null,null,null,{"$f":"H10*LambdaDown","v":60.653065971263345}]
[null,null,null,null,null,null,null,{"$f":"F11*LambdaDown","v":47.236655274101473}]
[null,null,null,null,null,null,null,null,null,{"$f":"H12*LambdaDown","v":36.787944117144235}]
[]
[]
[null,null,null,"Node 1",null,"Node 2",null,"Node 3",null,"Node 4"]