b. New create a table that shows the PU at I%, 5%, and 20% for 0, L 2, 3, 4, and 5 years. Then create a graph with years on the horizontal am's and FV on the vertical axis to display your results. Begin by typing in the row and column Labels as shown below. We could ll in the table by inserting formulas in all the cells, but a better way is to use an Excel data table as described in DTmodel. We used the data table procedure. Note that the Row Input Cell is D9 and the Column Input Cell is DID, and we set Cell B32 equal to Cell E11. Then, we selected (highlighted) the range B32:E38, then clicked Data, Table, and lled in the menu items to complete the table. Years Ill]: Interest Rate l9 - 0% 5% 20% 0 $0.00 $0.00 $0.00 1 $0.00 $0.00 $0.00 2 $0.00 $0.00 $0.00 3 $0.00 $0.00 $0.00 4 $0.00 $0.00 $0.00 5 $0.00 $0.00 $0.00 To create the graph, rst select the range C33:E38. Then click the chart wizard. Then follow the menu. It is easy to make a chart, but a lot of detailed steps are involved to format it so that it's "pretty." Pretty charts are generally not necessary to get the picture, though. Note that as the last item in the chart menu you are asked if you want to put the chart on the worksheet or on a separate tab. This is a matter of taste. We put the chart below on the spreadsheet so we could see how changes in the data lead to changes in the graph. Note that the inputs to the data table, hence to the graph, are now in the row and column heads. Change the 20% in Cell E32 to .3 (or 30%}, then to .4, then to .5, etc., to see how the table and the chart changes