Develop a report for tim outlining the factors

Assignment Help Case Study
Reference no: EM131009008

Case Problem: Retirement Plan

Tim is 37 years old and would like to establish a retirement plan. Develop a spreadsheet model that could be used to assist tim with retirement planning. Your model should include the following input parameters:

Tim's current age =37

Tim's current total savings = 259,000

Annual rate of return on retirement savings= 4 percent

Tim's current salary = 145,000

Tim's expected annual percentage increase in salary = 2 percent

Tim's expected age of retirement = 65

Tim's expected annual expenses after retirement (Current dollars) 90,000

Rate of return on retirement savings after retirement = 3 percent

Income tax rate postretirement = 15 percent

Assume that Tim's employer contributes 6% of Tim's salary to his retirement fund. Tim can make an addition annual contribution to his retirement fund before taxes (tax free) up to a contribution of 16,000. Assume he contributes 6000 per year. Also assume an inflation rate of 2%.

Managerial Report

Your spreadsheet model should provide the accumulated saving at the onset of retirement as well as the age at which funds will be depleted (given assumption on the input parameters).

AS a feature of your spreadsheet model, build a data table to demonstrate the sensitivity of the age at which funds will be depleted to the retirement age and additional pretax contributions. Similarly, consider other factors you think might be important. Develop a report for Tim outlining the factors that will have the greatest impact on his retirement.

Reference no: EM131009008

What is the greatest takeaway from the given case

Which of Michael Porter's four competitive strategies is AutoZone trying to follow? Discuss. What is the greatest takeaway from this case in terms of strategic management?

Evaluate the validity and reliability of the data

Describe why each piece of evidence is relevant to patients, the community, and the hospital. Summarize the analysis used to create the recommendation. Evaluate the validity a

Summarise the political environment in indonesia

Case Study - Astra International: Building successful international business around fluxing national government policy. Briefly summarise the political environment in Indonesi

Evaluate the information received in the survey

Evaluate the information received in the survey (Please assume a questionnaire survey was conducted from university students about the issue), identify alternative courses o

What degree you believe harley-davidson is proceeding

Discuss to what degree you believe Harley-Davidson is currently proceeding towards its mission, vision, and values - Identify two or three of H-D's most important stakeholders

Explain how officials of philadelphia identified the problem

Explain how the officials of Philadelphia identified the problems, framed options for solving the problem and finally created a workable plan of action to implement the MWN

Develop your understanding of activity based costing

This assessment has four primary aims: To provide you with an opportunity to develop your understanding of Activity Based Costing; To provide you with the means to further ref

Case study - the age of moral machines

Case Study: The Age of Moral Machines, ORIGINAL VERSION- A robot may not injure a human being, or through inaction, allow a human being to come to harm and A robot must obey t


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd