Assume you are investing in your retirement account with the same conditions stated in Question 3.Use the Guess-and-Check method with your FV function from Question 3 to determine how long it would take for the high school graduate's retirement account to have just over $1.5 million.Use the Guess-and-Check method with your FV function from Question 3 to determine how long it would take for your retirement account to have just over $1.5 million.What is the absolute change or percent change between the years to save one million dollars? Be sure to explain the change value.For your spreadsheet: Fill in the formulas for the section titled "Question 4 - How Long to $1.5 Million". You should be using cell references and/or formulas in EVERY cell in this section. Do not just type in the numbers. (Hint: The FV function is used to find the future value of an account given a constant monthly deposit.)

Transcribed Image Text:

17 Jx A B C D E Name: Marina Eguia Chosen Career: Registered Nurse 2021 Median Salary for Chosen Career: $ 77,600.00 HS Grad Median Salary: $ 30,270.00 2023 Subaru Outback Hybrid: $ 40,625.00 Question 1 - Salary HS Graduate You Absolute Change Percent Change Annual Salary $ 30,270.00 $ Gross Monthly Salary $ 2,522.50 $ 77,600.00 $ 6,466.67 $ 47,330.00 47,330.00 156 156 Question 2 - Mortgage HS Graduate You Absolute Change Percent Change 27% of Monthly Salary $ 681.08 $ Present Value (what I can afford) $129,066.81 1,746.00 $ $330,874.94 1,064.93 $201,808.13 156 156 Question 3 - Retirement Account HS Graduate You Absolute Change Percent Change 14% of Monthly Salary $ 353.15 $ 905.33 $ Future Value (value of account) Question 4 - How Long to $1.5 Million Future Value Years to 1.5 Million $430,513.26 $1,103,661.34 552.18 $673,148.08 156 156 HS Graduate $353.15 38 You $905.33 28 Absolute Change Percent Change -10% -26 Question 5 - Car Loan Loan Amount (after down navment) Sheet1 HS Graduate You 35.825.00 35.825.00 17 Jx A B C D E Name: Marina Eguia Chosen Career: Registered Nurse 2021 Median Salary for Chosen Career: $ 77,600.00 HS Grad Median Salary: $ 30,270.00 2023 Subaru Outback Hybrid: $ 40,625.00 Question 1 - Salary HS Graduate You Absolute Change Percent Change Annual Salary $ 30,270.00 $ Gross Monthly Salary $ 2,522.50 $ 77,600.00 $ 6,466.67 $ 47,330.00 47,330.00 156 156 Question 2 - Mortgage HS Graduate You Absolute Change Percent Change 27% of Monthly Salary $ 681.08 $ Present Value (what I can afford) $129,066.81 1,746.00 $ $330,874.94 1,064.93 $201,808.13 156 156 Question 3 - Retirement Account HS Graduate You Absolute Change Percent Change 14% of Monthly Salary $ 353.15 $ 905.33 $ Future Value (value of account) Question 4 - How Long to $1.5 Million Future Value Years to 1.5 Million $430,513.26 $1,103,661.34 552.18 $673,148.08 156 156 HS Graduate $353.15 38 You $905.33 28 Absolute Change Percent Change -10% -26 Question 5 - Car Loan Loan Amount (after down navment) Sheet1 HS Graduate You 35.825.00 35.825.00