need help with creating these tables

The Rowan Corp has two bond issues outstanding. Both bonds pay $90 annual interest plus 1,000 at maturity. Bond 1 has a maturity of 30 years, and Bond 2 has a maturity of 5 year. 1. Calculate the value of the bonds: a) When the going rate of interest is 5%,9%,15%, and 20%. b) Using Microsoft. Excel's relevant functions, calculate the bond prices. Create a table to summarize your results. c) Please mark the bonds as "Discount Bonds", "At-Par Bonds", and "Premium Bonds" for your answers. 2. Prepare a graph displaying your results. Make sure both bonds are displayed on one graph. Make the x-axis interest rate and y-axis bond prices. 3. Comment on which bond has more interest Rate Risk, include a discussion of the shape of the two curves in Part-2. 4. Prepare a graph displaying the value of each bond over time, for market interest rate of 4%,9%, and 13%. Make the x-axis years and y-axis bond prices. There should be six lines on the graph, representing the value of Bond 1 at three different rates and the value of Bond 2 at three different rates