current age, desired age of retirement & salary information can be whatever you desire

Inputo B3 (age as of 1/1/2022)- 30 Input B4 (age of spouse/partner as of 1/1/2022) = Input B6 (initial aftertax earnings of head)= Input B7 (initial aftertax earnings of spouse, if no spouse, = 0) = Input B9 (retirement age of head) = Input B10 (retirement age of spouse/partner, 0 if none) = Input B11 (Monthly Social Security pension of head from Quick Calculator) = Inputo B12 (Monthly Social Security pension of head from Quick Calculator)=,0 if no spouse/partner) Input0 E6 aftertax earnings of head last year before retirement Input0 E7 (aftertax earnings of spouse last year before retirement) Do not type in any other cells in sheet Input without discussion with instructor Net investments at age 30 (cell B5 in LCS Input0) = Goal seek level (use $300,000) for Goal Seek in cell N2 of Main sheet of LCS Outputs in Main Sheet of LCS, after you have completed Goal Seck Aftertax household earned income in 2022 (B4) = Suggested spending in 2022 (64) = Suggested saving out of income in 2022 (F4) - Suggested saving as a % of aftertax income in 2022 (L4) Compare the suggested saving % to the results from your homework #2. Discuss whether suggested percents are reasonable. First year of retirement (first year income is below desired spending) Aftertax household earned income in year before final retirement (for couple, last year at least one is employed) - Maximum net investments (column G, typically just before first retirement) - Suggested spending in first year of full retirement Note income patterns in retirement Inputo B3 (age as of 1/1/2022)- 30 Input B4 (age of spouse/partner as of 1/1/2022) = Input B6 (initial aftertax earnings of head)= Input B7 (initial aftertax earnings of spouse, if no spouse, = 0) = Input B9 (retirement age of head) = Input B10 (retirement age of spouse/partner, 0 if none) = Input B11 (Monthly Social Security pension of head from Quick Calculator) = Inputo B12 (Monthly Social Security pension of head from Quick Calculator)=,0 if no spouse/partner) Input0 E6 aftertax earnings of head last year before retirement Input0 E7 (aftertax earnings of spouse last year before retirement) Do not type in any other cells in sheet Input without discussion with instructor Net investments at age 30 (cell B5 in LCS Input0) = Goal seek level (use $300,000) for Goal Seek in cell N2 of Main sheet of LCS Outputs in Main Sheet of LCS, after you have completed Goal Seck Aftertax household earned income in 2022 (B4) = Suggested spending in 2022 (64) = Suggested saving out of income in 2022 (F4) - Suggested saving as a % of aftertax income in 2022 (L4) Compare the suggested saving % to the results from your homework #2. Discuss whether suggested percents are reasonable. First year of retirement (first year income is below desired spending) Aftertax household earned income in year before final retirement (for couple, last year at least one is employed) - Maximum net investments (column G, typically just before first retirement) - Suggested spending in first year of full retirement Note income patterns in retirement