Question: I need help adding rule 8 5 to the following excel. I am unsure how to enter the formula. I attached a jpg of the

I need help adding rule 85 to the following excel. I am unsure how to enter the formula. I attached a jpg of the excel as well as the instructions below that tries to explain it. I am lost.
With Excel open and ready to go, your job is to:
Create an Excel worksheet that is identical to the following screenshot.
Notes on This Screenshot: There are three major input items, highlighted with yellow background, for the average salary, the percentage for each year of service, and early retirement reduction percentage. The normal retirement age could be another input item to make the model more flexible, in case that the normal retirement age is not age 65. However, you can assume the normal retirement age.
You should have an input cell to hold "the rule of age plus service requirement for unreduced early retirement benefit, as noted in the Rule 85. Other popular rules are Rule 80 and Rule 75. Once you have a firm understanding of this, then:
Format the Excel worksheet with the following requirements:
Use proper page formats and print setup
Include the retirement ages and years of service in the row headings and column headings.
Include the default rule of Rule 85, which means no early retirement reduction if age plus service is at least 85. The input for the Rule should be a whole number between 65 and 100.
Use Excel formulas to calculate the body of the table which are the retirement benefits.
Notes on Color: If the benefit in a given cell divided by the average salary is above 50% but below 100%, then it should be bold and in blue color with a light yellow fill color for the background. if the benefit in a cell divided by the average salary is at least 100% then this cell should be bold and in red color with a gray background color.
Provide comment instructions (Like the Rule comment instructions in the screenshot above) for the Average salary, percentage for each year of service and early retirement reduction percentage.
Create the formula in one cell in the table and copy/paste to the rest of the table.
 I need help adding rule 85 to the following excel. I

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!