A newly issued bond with one year to maturity has a price of 100, which equals its face value. The coupon rate on the bond is 15%. the probability of default in 1 year is 35%. and the bonds payoff in default will be 65% of its face value. what is bonds expected return. Calculation should b in excel, This is what i have so far. Plz let me know if its correct or how it should be done. Thanks in advance. Will give good rating.

B11 X fr 1 Face value 100 2 price 100 3 maturity 4 coupon rate 15% 5 probability to default 35% % 6 recovery rate 65% 7 8 Expected CF in the next period 9 If the firm defaults 10 If the firm doesn't defaults 11 Exp CF in the next period 97.500 13 Exp ret -2.500% 15 YTM 15% B11 X fr 1 Face value 100 2 price 100 3 maturity 4 coupon rate 15% 5 probability to default 35% % 6 recovery rate 65% 7 8 Expected CF in the next period 9 If the firm defaults 10 If the firm doesn't defaults 11 Exp CF in the next period 97.500 13 Exp ret -2.500% 15 YTM 15%