Part B: Points: Total 100 (Q110, 02 30, Q3 30, Q4 20, Q5-10) Given the following data for an investment: Principal 5000 Duration (Years)4 Final Value 1. Create a worksheet called "Investment" on the same Workbook you used in "Part A" with the 2. Create and place a formula to determine the Final Value above. Use a function in Excel to 3. Create a 2 variable Data table to show the APR (interest rates) from 1%, 1.5%, 2.0%, to 20% and data above. (You can place the data anywhere on the worksheet (e.g. C2 to DS). calculate this. (You must place it next to the cell at the right of the "Final Value cell). 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). 4. 5. Add a Title to your graph and label the axes appropriately. (lf no axes labels are present, create 6. 7. 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