90.2K

Verified Solution

Link Copied!

You will design an Excel workbook that provides your personal retirement plan. The design of the workbook is up to you, but it should be detailed enough and documented enough that I can understand your assumptions and inputs when you turn it in. You should use publicly available resources for your estimates of salary, salary growth, and living expenses. Please include a hyperlink in the spreadsheet that acts as a citation to the data you used.

Your time horizon starts when you graduate from SU. You must choose a job, location, and salary based on your desires and opportunities.

You will need to forecast salary, retirement benefits from your employers, annual expenses, and for those who qualify expected social security payments. If you dont plan to work in the US, please research and include any information on government-sponsored retirement plans where you intend to work.

Your savings toward retirement cant be greater than the difference between your take-home pay (net of taxes) and your annual expenses. You should forecast and include major life events including potential capital purchases (cars, houses), and if applicable, saving toward things other than retirement (down payments, childcare expenses, future tuition, and the like). You will forecast your retirement date. You will also forecast your available spending annually after retirement and include a bequest if you plan to do so. The goal of the project is to have a dynamic workbook that forecasts your potential annual expenditures after retirement.

Assume an 8% rate of return on your savings until retirement, and 4% return after retirement.

Answer & Explanation Solved by verified expert

See Answer