Use the Table Below to Answer the Following Questions) -What's the Total Retirement Balance When Sheila Has Reached the Joined

question 17

Multiple Choice

Use the table below to answer the following questions) .
Sheila joined Simsin Tradings at the age of 36 with a starting salary of $75,000. She expects a salary increase of 5 percent every year. Her retirement plan requires her to pay 9 percent of her salary, while the company matches it at 32 percent. She expects an annual return of 7 percent on her retirement portfolio. Using a predictive model for Sheila's first five years, calculate the following, assuming that the salary increases at the same rate every year, and the return of interest does not change. $\begin{array} { |l|l| } \hline \text {Retir ement Plan Model for Sheila }\\\hline\\\hline \text { Data }\\\hline\\\hline \text { Retirement Contribution percent of salary) } & 9 \text { percent } \\\hline \text { Employer Match } & 32 \text { percent } \\\hline \text { Annual Salary Increase } & 5 \text { percent } \\\hline \text { Annual Return on Investment } & 7 \text { percent } \\\hline\end{array}$

-What's the total retirement balance when Sheila has reached the age of 40 while working with Simsin?

• A) $108,374.54
• B) $56,253.36
• C) $53,627.87
• D) $91,163

---

Definitions:

What-if Analysis

A process that allows for changing variables to see how those changes will affect the outcome of a formula or situation.

VLOOKUP

A function in spreadsheet programs that searches for a value in the first column of a range and returns a value in the same row from a specified column.

Pivot Table

A data summarization tool used in spreadsheet software that enables users to reorganize, group, and summarize data for analysis.

Orientation

The direction in which a document or image is displayed or printed, typically either landscape (horizontal) or portrait (vertical).