Question

In: Finance

A recent college graduate has taken a new job at Work LLC, and since the company...

A recent college graduate has taken a new job at Work LLC, and since the company does not offer a traditional pension plan, she plans to take advantage of a tax-free investment account backed by a reputable financial institution that offers a guaranteed 8% annual return for as long as she lives.

The graduate plans on working for 45 years before retiring and will save a fixed amount each year until retirement, starting at the end of this year and continuing for all 45 years of work. Once she is retired, she expects to be able to live on the equivalent of $30,000/year in today’s terms in addition to expected social security payments. She expects annual inflation to be 4% per year over her life.

She doesn’t know how long she will live, but knows that with medical advancements, it could be for a very long time. Since one of her great fears is that she will outlive her savings, she plans to arrange retirement funding that will be in place if she were to live “forever” with the understanding that her heirs will inherit the remainder when she dies.

If she wants to save a fixed amount each year, starting with one year from now until her 45th work anniversary, how much does she need to save each year?

1. Identify the problem – All information needed to identify the problem is included in the case, and the student must select the needed information and represent it in a simplified form, which could be a combination of words and graphical representations.

2. Explain the strategy for solving the problem – Although there may be more than one way to solve a problem, the student must choose a method and explain how it will be applied.

3. Application of solution tools – The student must apply mathematical and logical tools to solve the problem. These may include formulae, logical deductions, and other appropriate devices.

4. Describe the solution – The student must provide a solution to the problem. The quality of the solution will be evaluated.

Solutions

Expert Solution

1 Problem is to find the goal of savings required
at the time of retirement and fixed amount to be saved each year
2 Strategy:
Calculate annual expenses required at the time of retirement
Calculate Real Rate of Return during retirement after adjusting for inflation
Calculate Corpus required for retirement income in perpetuity
Calculate Fixed annual savings required during 45 years
3 Annual expenses after retirement at current price $30,000
Number of years to retirement 45
Annual inflation rate 4%
Annual income required at the time of returement $175,235 30000*(1.04^45)
Nominal investment return=8% 0.08
Inflation adjusted real return during retirement =R
Inflation rate=4% 0.04
(1+R)=1.08/1.04 1.038461538
Inflation adjusted return =R= 0.038461538
Retirement Corpus required for Perpetual retirement income $4,556,117 (175235/0.038461538)
Fv Amount required at the time of retirement $4,556,117
Rate Annual investment return 8%
Nper Number of years of fixed amount of savings 45
PMT Annual amount of Savings required $11,788 (Using PMT function of excel with Rate=8%, Nper=45, Fv=-4556117)
4 She will need to save $11,788 per year for 45 years
At the time of retirement the total savings will be $4,556,117
This savings will give an inflation adjusted return of $175,235 per year in perpetuity
The amount of $175235 will be equivalent to $30,000 today

Related Solutions

A recent college graduate has taken a new job at Work LLC, and since the company...
A recent college graduate has taken a new job at Work LLC, and since the company does not offer a traditional pension plan, she plans to take advantage of a tax-free investment account backed by a reputable financial institution that offers a guaranteed 8% annual return for as long as she lives. The graduate plans on working for 45 years before retiring and will save a fixed amount each year until retirement, starting at the end of this year and...
Final Scenario You're a recent graduate of Champlain College and landed a great job in New...
Final Scenario You're a recent graduate of Champlain College and landed a great job in New York as a junior financial analyst for Chuck Schwable, a leading investment firm whose name bears no resemblance to a well known investment firm. Schwable has recently been hired by Giggle, a leading tech giant, to provide some capital budgeting recommendations for a major building project in downtown Manhattan. This is it...it's your big chance to make a great first impression and show off...
Jorge Jones, a recent management graduate has a new job as a shelf stocker at the...
Jorge Jones, a recent management graduate has a new job as a shelf stocker at the local Shop and Stop (bad job market). In order to maintain some of the knowledge he gained in college, Jorge wants to apply regression analysis to predict weekly sales on the cereal aisle. He believes there would be a relationship between the shelf space that a particular product takes up and the sales of that product. Jorge has gathered the following data: Shelf Space...
Use Worksheet 9.1. Lexi Thomas, a recent college graduate, has decided to accept a job offer...
Use Worksheet 9.1. Lexi Thomas, a recent college graduate, has decided to accept a job offer from a nonprofit organization. She’ll earn $44,000 a year but will receive no employee health benefits. Lexi estimates that her monthly living expenses will be about $2,000 a month, including rent, food, transportation, and clothing. She has no health problems and expects to remain in good health in the near future. Using the Internet or other resources, gather information about three health insurance policies...
Angle, age 24 and single, is a recent college graduate. They have just accepted a job...
Angle, age 24 and single, is a recent college graduate. They have just accepted a job offer with Financial Planning Pals, LLC, as a financial planner making $100,000/ yr.    Angle has some student debt and lives in an apartment without any roommates. They have $0 savings currently. Additionally, Financial Planning Pals, LLC is a cheap employer and they do not offer any type of Qualified Retirement Plan. Angle is confused about how to pay down their student loan debt, establishing...
Angle, age 24 and single, is a recent college graduate. They have just accepted a job...
Angle, age 24 and single, is a recent college graduate. They have just accepted a job offer with Financial Planning Pals, LLC, as a financial planner making $100,000/ yr.    Angle has some student debt and lives in an apartment without any roommates. They have $0 savings currently. Additionally, Financial Planning Pals, LLC is a cheap employer and they do not offer any type of Qualified Retirement Plan. Angle is confused about how to pay down their student loan debt, establishing...
A recent college graduate from Clayton State University has the choice of buying a new car...
A recent college graduate from Clayton State University has the choice of buying a new car for $33,500 or investing the money for four years with an 11% expected annual rate of return. He has an investment of $41,000 in equities and bonds which yields 8% expected annual rate of return. If the graduate decides to purchase the car, the best estimate of the opportunity cost of that decision is ________. Question 2 options: $3,280 $18,040 $14,740 $41,000
A recent graduate moving to a new job collected a sample of the monthly rent (in...
A recent graduate moving to a new job collected a sample of the monthly rent (in dollars) and the size (in square feet) of 3-bedroom apartments in one area of a city. Use Excel to find the best fit linear regression equation, where size of the apartment is the explanatory variable. Round the slope and intercept to two decimal places. Size   Rent 961   "909 " 949   1048 924   "841 " 920   "704 " 902   1131 893   "867 " 888   2532...
A new graduate enters the work force and is looking for a job. She is considered:...
A new graduate enters the work force and is looking for a job. She is considered: A. cyclically unemployed. B. underemployed. C. frictionally unemployed. D. naturally unemployed.
Sally is a recent college graduate. She has a plan for retirement as shown in the...
Sally is a recent college graduate. She has a plan for retirement as shown in the table below: Years Sally savings per year 1-10 $6,000 11-20 $10,000 21-30 $11,000 Sally expects to earn 7% per year on their savings. How much does Sally expect to have at the end of 30 years? Round your answer to the nearest dollar, for example 438597. Mary and Fred both want to retire 10 years form now. The table shows the amount of money...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT