(Answered):Formulas And Functions To Perform Calculations . . . .

Question Description

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