Homework answers / question archive / Sara B

Sara B

Economics

Share With

Sara B. Goode wishes to retire in the year 2022 with personal savings of $500,000 (1997 spending power). Assume that the expected inflation rate in the economy will average 3.75% per year during this period. Sara plans to invest in a 7.5% per year savings account, and her salary is expected to increase by 8.0% per year between 1997 and 2022. Assume that Sara's 1997 salary was $60,000 and that the first deposit took place at the end of 1997. What percent of her yearly salary must Sara put aside for retirement purposes to make her retirement plan a reality?

please help me answer in excel, thankyou