Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started