Hello, here I have all info provided. I need help with step 2 and step 3 please! The second picture is all the information that was provided to answer these questions. I already answered step one through a provided link but don't know how to answer step 2 and three thank you!

AutoSave OFF " AFC ... 199 project Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Segoe UI 11 AA 207 D Wrap Text v General Paste B A Merge & Center v $ ~ % 9 08 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No D1 fx C D G H Q2 Application Time! Jessica will take the appropriate risk she needs to prepare for retirement. She has no retirement savings yet. Her employer 6 will match - use the following information to determine the overall retirement saving needs. *Step 1: Find out how much should be saved each year. For the inputs, see the "Info Sheet". Place the outcome from the website results in the "Total Amount Saved" for "This Year" cell. **Step 2: How much can be contributed to a 401k? See "Info Sheet" for the percentage of employee/employer match limits. Research a fund analyzer to compare the investment vehicle choices within the employer's 401k plan (focus on fees, profits/losses). Employer offers the following 401k Investment Vehicle choices: DNVYX JIEIX JAQAX ***Step 3: Pick the most appropriate retirement account choice: The following Traditional or Roth IRA choices: Target Date Fund Apple Stock 10 yr. Treasury Note Research own choice *Step 1: Total Amount Saved 7,553 ** Step 2: 101k - Employee Contribution 101k - Employer 18 Contribution 19 Total 401k Contributions Difference in Step 1-Step 2 Amount to invest in an IRA 22 Step 2 - Choice Explanation (discuss the amount and reason for investment vehicle choice) I chose the JIEIX because when I researched it, it has the highest option and it has gone up 11.52% within the past month, so at this point in time it is looking to be the smartest 401k investment option. ***Step 3: Amount to invest in an IRA (your selection) Traditional IRA ROTH IRA 28 Step 3 - Choice Explanation (discuss the amount and reason for the retirement account choice) 29 *Please note that when you finish the table, not all of the IRA boxes may contain data. It is OK to have N/A or zeros in some of the boxes as long as you provide your rationale as to why. If you researched your own choice(s), please make sure to provide justification about your 30 selection under "Choice Explanation". Info Sheet LG9_Project + Ready Accessibility: Good to go 90Excel File Edit View Insert Format Tools Data Window Help 80% Thu 12:38 AM Q = AutoSave OFF A A F ? C ... 199 project me Insert Draw Page Layout Formulas Data Review View Tell me Share Comments pda Segoe UI 11 A b Wrap Text v General E Lo aste BIUV MVA Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No fx B C D E F G H M N o P Q R and are super excited to be financially literate as you enter your first career-related job. However, your friend did not take PFI 2301 and is trying to figure what to do with their finances. They have contacted you for some guidance. Being the awesome friend you are, you agree to walk them through the four personal finance elements (Basics, Borrowing, Building, & Protecting) you learned in class! Scenario: Get started reviewing the information under "Unit 3: Building" to learn more about your friend, Jessica's financial situation. Unit 3: Building - Using Your Current Income Tomorrow LG9-Understand how retirement saving arrangements are associated with tax shelters and investment products Q3 Employer Match (100% of contributions) 100.00% Employee (first 3% of salary) 3.00% Use the link: https://www.cnn.com/business/calculators/retirement-calculator Website Inputs: Jessica Age 33 Current Annual Income $58,500 Spouse N/A ($0) Current Retirement Savings Desired Retirement Age 65 Number of Retirement Income 20 Expected Inflation 3% Income Replacement at Ret. 75% Pre-Retirement Investment Return 8% Post-Retirement Invest. Return 8% Include Social Security No Marital Status Single Social Security Override Amt. Info Sheet LG9_Project + Ready Accessibility: Good to go + 90% NOV 10 39