Please answer all questions showing how to input them on excel. I will rate right away! Thanks so much!

8.10 Yield to maturity: Rudy Sandberg wants to invest in four-year bonds that are currently priced at $868.43. These bonds have a coupon rate of 6 percent and pay semiannual coupon payments. What is the current market yield on this bond? Realized yield: Four years ago, Lisa Stills bought six-year, 5.5 percent coupon bonds issued by the Fairways Corp. for $947.68. If she sells these bonds at the current price of $894.52, what will be the realized yield on the bonds? Assume similar coupon-paying bonds make annual Expected returns: John is watching an old game show rerun on television called Let's Make a Deal in which the contestant chooses a prize behind one of two curtains. Behind one of the curtains is a gag prize worth $150, and behind the other is a round-the world trip worth $7,200. The game show has placed a subliminal message on the curtain containing the gag prize, which makes the probability of choosing the gag prize equal to 75 percent. What is the expected value of the selection, and what is the standard deviation of that selection? The security market line: If the expected return on the market is 10 percent and the risk-free rate is 4 percent, what is the expected return for a stock with a beta equal to 1.5? What is the market risk premium for the set of circumstances