Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

finance excel project

Demographics and justifications:

  • Assume you are beginning full time work this year.
  • State the age at which you plan on retiring. How many years do you have to accumulate the dollars necessary to commence retirement? 
  • Report the age at which you expect to die and how much money (if any) you want to have upon death to leave to someone or some organization. How many years will you be spending money in retirement? 
  • Show these assumptions and their justifications on your spreadsheet.

Expected Retirement Spending: (Use a spreadsheet to make this easier)

  • Create an annual expense budget for your needs in your first year of retirement using today’s dollars. For example, you may have no mortgage payment due in retirement. Note that if you retire prior to being eligible for Medicare (age 65 under current law), you will also need to budget for medical insurance. There are sources online available to help you find an estimate of this. Recognize that this figure could vary widely based on your future health.
  • Note that it is not necessary to establish a budget that varies from month to month. The focus of this assignment is your annual needs rather than your expected monthly cash flows.
  • Using your estimate of expenses in today’s dollars, the number of years before retirement and a rate of inflation assumption of 2.1%, report how much money you expect to spend in your each year of retirement in future dollars. Remember to continue to adjust for inflation to account for the impact of inflation during retirement.

Earnings and Savings Behavior:

Create an estimate of your future annual earnings in a spreadsheet, reporting the following assumptions:

  • Your actual current retirement savings
  • Average annual salary growth rate
  • The percentage of salary you expect to contribute each year between now and retirement toward work-sponsored retirement accounts (e.g., 401(k)), including the assumed employer contribution percentage. This can vary from year to year if you wish, either increasing or decreasing over time.

If you do not use a linear salary growth rate, please bold the figures that use a different assumption. For example, if you give yourself a flat $10,000 raise at age 30 because you predict a promotion that year, bold the salary of the year in which the $10,000 raise applies. If you see yourself leaving the workforce to return to school, bold the reduced student salary you expect during those years.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question