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

\begin{tabular}{|r|r|r|} \hline Average Adjusted Salary & $51,806.57 \\ \hline Lowest Adjusted Salary & $40,119.05 \\ \hline Highest Adjusted Salary & $59,699.04 & \\ \hline # of Positions with a Bonus & 5 & \\ \hline # of Positions without a Bonus & 3 & \\ \hline Highest Total Two-Year Financlal Package & \\ \hline Second Highest Total Two-Year Financial Package & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline Average Adjusted Salary & $51,806.57 \\ \hline Lowest Adjusted Salary & $40,119.05 \\ \hline Highest Adjusted Salary & $59,699.04 & \\ \hline # of Positions with a Bonus & 5 & \\ \hline # of Positions without a Bonus & 3 & \\ \hline Highest Total Two-Year Financlal Package & \\ \hline Second Highest Total Two-Year Financial Package & \\ \hline \end{tabular}