Question: b . Now create a table that shows the FV at 0 % , 5 % , and 2 0 % for 0 , 1
b Now create a table that shows the FV at and for and years. Then create a graph with years on the horizontal axis and FV on the vertical axis to display your results.
Begin by typing in the row and column labels as shown below in C:C and B:B NOTE: Do not use formulas in these cells! You must enter the actual numbers! We could fill in the table by inserting formulas in all the cells, but a better way is to use an Excel data table Data WhatIf Analysis, Data Table Note that the Row Input Cell is D and the Column Input Cell is D and we set Cell B equal to Cell E Then, we selected highlighted the range B:E then clicked Data, WhatIf Analysis, Data Table, and filled in the menu items to complete the table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
