Question: 1. Create a spreadsheet to determine retirement savings using the following criteria. Annual Compensation: $60,000 (monthly $5,000) 401K (4038) Contribution Percent 6% Company match 50%

1. Create a spreadsheet to determine retirement savings using the following criteria. Annual Compensation: $60,000 (monthly $5,000) 401K (4038) Contribution Percent 6% Company match 50% up to 6% (e. g. 3% 50% x 6%) Tax Rate 25% Annual Investment Return Rate 8% In your spreadsheet, each of these elds should be changeable. For example, if change the base pay to $48,000, your spreadsheet will calculate new retirement amounts. The intent of this exercise is also for you to learn how to do what if analysis for any of the key inputs on retirement savings. Please include your expected 401K (403B) balance at 10 year intervals as follows: 10 years, 20 years, 30 years, 40 years. Most of you will be 32, 42, 52 and 62 (ready for retirement) for these intervals. Create your le to allow for What if analysis for the following variables: 1. annual salary 2. investment rate 3. contribution percent 4. company match percent In your spreadsheet, highlight these elds in yellow indicating they can be modied to arrive at new retirement account balances
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
