Reference no: EM131132932
Microsoft Word - Ch7-Retirement.docx
Benedict's Retirement Planning
Benedict is 37 years old and would like to establish a retirement plan. Develop a spreadsheet model that could be used to assist Benedict with retirement planning.
Your model should include the following input parameters:
Benedict's current age = 37 years
Benedict's current total retirement savings = $259,000
Annual rate of return on retirement savings = 4 percent
Benedict's current annual salary = $145,000
Benedict's expected annual percentage increase in salary = 2 percent/year Benedict's own percentage of annual salary contributed to retirement = 6 percent Benedict's expected age of retirement = 65
Benedict'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 Benedict's employer contributes 6% of Benedict's salary to his retirement fund in addition to the money Benedict himself puts aside. Benedict can make an additional annual contribution to his retirement fund before taxes (tax free) up to a contribution of $16,000. Assume he contributes $6,000 per year. Also, assume an inflation rate of 2%.
Managerial Report:
Your spreadsheet model should provide the accumulated savings at the onset of retirement as well as the age at which funds will be depleted (given assumptions 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 pre-tax contributions. Similarly, consider other factors you think might be important.
Develop a report for Benedict outlining the factors that will have the greatest impact on his retirement.
|
Accounting technique which looks at fixed and variable cost
: a managerial accounting technique which looks at the fixed and variable costs of a business to arrive at a number of unit sales (volume) to maximize profits?
|
|
Why might urban ii have good political reasons
: In your own words write one or two paragraphs about the following: Given the events of the previous decades (The Crusades), why might Urban II have good political reasons to commission an army that took an oath to St. Peter?
|
|
To create a project scope and project charter
: In 3-5, you will use Microsoft Word/Excel to create a project scope and project charter. Use Microsoft Project to create a work breakdown structure (WBS), baseline schedule, and cost estimates. One submission per group will suffice. This mileston..
|
|
Unification of italy and of germany
: Analyze the similarities and differences in the methods used by Cavour and Bismarck to bring about the unification of Italy and of Germany, respectively.
|
|
Like to establish a retirement plan
: Benedict is 37 years old and would like to establish a retirement plan. Develop a spreadsheet model that could be used to assist Benedict with retirement planning.
|
|
Time that is required for a business to acquire resources
: What is the time that is required for a business to acquire resources - convert them into product,- sell the product,- and receive cash from the sale?
|
|
Be as per the harvard referencing system
: In working out your responses to the Discussion Question, you should choose examples from your own experience or find appropriate cases on the Web that you can discuss. Credit will be given for references you make to relevant examples from real c..
|
|
An institution to which private wealth is contributed
: What do we call an institution to which private wealth is contributed - and from which private wealth is distributed for public purposes?
|
|
How did the idea of vampires originate
: How did the idea of vampires originate? How does this tie into folklore ideas about death and folklore ideas about the nature of vampires?
|