Reference no: EM131205200
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.
|
List of all the names of mughals of india
: List of all the names of Mughal's of India? Detail description of Akbar? Famous monuments built by Mughals in India and out side India?
|
|
Can money be valuable in an infinite economy
: Can money be valuable in a finite economy (one that has a known end point)?
|
|
Discuss work of the robert wood johnson foundation committee
: Discuss the work of the Robert Wood Johnson Foundation Committee Initiative on the Future of Nursing and the Institute of Medicine research that led to the IOM report, "Future of Nursing: Leading Change, Advancing Health."
|
|
Monopolistic competitive market structure
: In The News: Pizza, sub sandwiches, furniture, shoes, and many other products are considered to be in the monopolistic competitive market structure.
|
|
Establish 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. Benedict’s expected annual expenses after retirement (current dollars) = $90,000 Rate ..
|
|
Prepare a critical book review about the given book
: Prepare a critical book review (4-6 pages), Papers should be typewritten in 12 point font, with 1 inch margins on all sides (about 250 words/page). Essays must be typed.
|
|
Three-step binomial tree
: (a) What is the value of a 6-month European call option with a strike price of $52 using a three-step binomial tree? (b) Draw the tree mark the value of the option on each nod of the tree.
|
|
Interest rates with quarterly compounding
: a. Calculate the present value of $100 in 1.5 years (=18 months). b. Calculate are the equivalent 6-month, 12-month, 18-month, 24-month interest rates with quarterly compounding. c. Calculate the 6-month forward rate between 1.5 years (=18 months) a..
|
|
What is the firm cash conversion cycle
: What is the firm's free cash flow? What is the firm's cash conversion cycle? What picture of the firm's financial performance do these metrics paint? Develop a sources and uses of cash statement. What is the sources and uses statement telling you ..
|