Help! Need help with CIS 200 project!

APR - 6%

Principal = 2000

Duration (years) =3

Final Value = ?

1. Create a worksheet "Investment" with the data above.

2. Create and place formula to determine Final Value above. Use a function in Excel to calculate this.

3. Create a 2 variable Data table to show various APR (interest rate) from 1%, 1.5%, 2%, to 20% and their corresponding Duration in years from 1, 2 , 3, 4, to 20.

4. Create a chart (2D, clustered column) plotting the Final Value data for the first two years 91,2) and the first two interest rates (1.0%, 1.5%) Only from your data table.

5. Add a title to your graph and label the axes appropriately

Part B Points: Total -100 (Q1 10, Q2 30, Q3 30, Q4 -20, Q5 10) Given the following data for an investment: APR = 6% Principal 2000 Duration (Years) 3 Final Value? 1. Create a worksheet called "Investment" on the same Workbook you used in "Part A" with the data above. (You can place the data anywhere on the worksheet (e.g. C2 to D5). Create and place a formula to determine the Final Value above. Use a function in Excel to calculate this. (You must place it next to the cell at the right of the "Final Value" cell). Create a 2 variable Data table to show the various APR(interest rates) from 1%, 1.5%, 2.0%, to 20% and their corresponding Duration in years from 1, 2, 3, 4, to 20, (You may use any axis for the principal and duration in your table). Create a chart (2D, clustered column) plotting the Final value data for the first two years (1, 2) and the first two interest rates (1.0%, and 1.5%) ONLY, from your Data table. (You must use Layout 7 for your graph). 2. 3. 4. 5. Add a Title to your graph and label the axes appropriately. (f no axes labels are present, create one for the x and one for the y axis). Save your Workbook. Review your work and upload this Workbook to Blackboard via the link for Project1. 6. 7. NOTE: You will lose 30% (not 30 points) for each day this project is late. There are no exceptions to this rule