has to be done on excel with all the formulas

f) He is considering another Bond, Bond D. It has an 7% semiannual coupon rate N a $1,000 face value. Interest is paid at the end of each 6 month period. Bond D is scheduled to mature in 9 years and has a Price of $1,200. It is also callable after 5 years at a call price of $1,050. 10% 1) What is the Bond's Yield to Maturity (YTM)? 10% 2) What is the Bond's Yield to Call (YTC)? 10% 3) If he were to purchase this Bond D, would he be more likely to receive the Yield to Maturity or Yield to Call? Explain your