I need assistance solving the below problems in excel.

7-1BOND VALUATION Callaghan Motors's bonds have 10 years remaining to maturity. Interest is paid annually; they have a $1,000 par value; the coupon interest rate is 8%; and the yield to maturity is 9%. What is the bond's current market price?

7-2YIELD TO MATURITY AND FUTURE PRICEA bond has a $1,000 par value, 10 years to maturity, and a 7% annual coupon and sells for $985.

a. What is its yield to maturity (YTM)?

b. Assume that the yield to maturity remains constant for the next three years. What will

the price be 3 years from today?

7-10CURRENT YIELD, CAPITAL GAINS YIELD, AND YIELD TO MATURITYHooper Printing Inc. has bonds outstanding with 9 years left to maturity. The bonds have an 8% annual coupon rate and were issued 1 year ago at their par value of $1,000. However, due to changes in interest rates, the bond's market price has fallen to $901 40. The capital gains yield last year was 9 86%.

a. What is the yield to maturity?

b. For the coming year, what are the expected current and capital gains yields? (Hint:

Refer to footnote 7 for the definition of the current yield and to Table 7.1.)

c. Will the actual realized yields be equal to the expected yields if interest rates change? If

not, how will they differ?

7-14 EXPECTED INTEREST RATELloyd Corporation's 14% coupon rate, semiannual payment, $1,000 par value bonds, which mature in 30 years, are callable 5 years from today at $1,050. They sell at a price of $1,353 54, and the yield curve is flat. Assume that interest rates are expected to remain at their current level.

a. What is the best estimate of these bonds' remaining life?

b. If Lloyd plans to raise additional capital and wants to use debt financing, what coupon

rate would it have to set in order to issue new bonds at par?