Question

7. In cells H2:H9, calculate the value of the adjusted salary package for each position over a two-year period, including any one-time bonus. The bonus does not need to be adjusted for location because the employee plans to use the bonus toward a vacation. Assume that the employee will receive a 2.5% raise after the first year of employment in the new position. Make sure that cells H2:H9 are formatted as Currency with two decimal places. Hint: The two-year package should consist of the adjusted salary in year one, the adjusted salary in year two (which is 2.5% higher than the adjusted salary in year one), and the one-time bonus in year one. Check Figure: Cell H5 = $88,674.69. How would you do this ?

Answer 1