I need the following 3 problems mapped out in excel and I need the steps laid in explicit detail.

he treasurer of a large corporation wants to invest $35 million in excess short-term cash in a particular money market investment. The prospectus quotes the instrument at a true yield of 4.39 percent; that is, the EAR for this investment is 4.39 percent. However, the treasurer wants to know the money market yield on this instrument to make it comparable to the T-bills and CDs she has already bought. If the term of the instrument is 79 days, what are the bond equivalent and discount yields on this investment? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. Omit the "%" sign in your response.) % Bond equivalent yield % Discount yield 2. A Treasury bill that settles on May 18, 2012, pays $100,000 on August 21, 2012. Assuming a discount rate of 1.43 percent, what is the price and bond equivalent yield? Use Excel to answer this question. (Do not round intermediate calculations. Round your answers to 2 decimal places. Omit the "$" & "%" signs in your response.) Price Bond equivalent yield $ % 3 LKD Co. has 12 percent coupon bonds with a YTM of 8.5 percent. The current yield on these bonds is 9.4 percent. How many years do these bonds have left until they mature? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Bonds mature years