IT1532 Unit 4 Formulas and Functions to Perform Calculations Worksheet
Please see the attached file. Follow the instruction.
Scenario:
You have been asked by the Employee Relations and Resource departmentto develop a retirement planning worksheet that will allow each currentand prospective employee to see the effect (dollar accumulation) ofinvesting a percent of his or her monthly salary over a period of years(Figure 1 below). The plan calls for the company to match an employee’sinvestment, dollar for dollar, up to 2.50%. Thus, if an employee invests5.00% of his or her annual salary, then the company matches the first2.50%. If an employee invests only 1.75% of his or her annual salary,then the company matches the entire 1.75%. The Employee Relations andResource department wants a one- input data table to show the futurevalue of the investment for different years.
“Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results.”
Attachments
20190605234629unit4datafile (20 kB)