Please use Excel to solve this question with steps. Thanks.

6. 10 points - Bonds Consider a $1,000-par junk bond paying a 12% annual coupon. The issuing company has 20% chance of defaulting this year, in which case, the bond would not pay anything. If the company survives the first year, paying the annual coupon payment, it then has a 25% chance of defaulting in the second year. If the company defaults in the second year, neither the final coupon payment nor par value of the bond will be paid. a) What price must investors pay for this bond to expect a 10% yield to maturity? b) At that price, what is the expected holding period return? c) At that place, what is the standard deviation of returns? Assume that periodic cash flows are reinvested at 10%