You graduate from College at 21. For your retirement, you decide to invest into a Fidelity...

You graduate from College at 21. For your retirement, you decide to invest into a Fidelity mutual fund that gives you a 7.5% APR compounding monthly. After some years of work, you will retire and move the investment into another Vanguard money market account which gives you a 3% APR compounding monthly. During the years of working, you invest $350 every month. You plan to spend $4,500 every month until you pass away. You estimate that you will pass away at 85 years old. When can you retire?

Solutions

Expert Solution

To estimate the age of retirement, the future value of the savings at retirement has to equal to present value of the total monthly spending over retirement, at that age. This can be solved using Solver as follows:

Graduation age (g)	21
Retirement age ('R)	59.7
Number of years of working	38.7	Number of years of retirement (85-R)	25.3
PMT	350	PMT	4500
N	465	N	303
APR	7.50%	APR	3%
rate	0.625%	rate	0.250%
FV	9,56,200.38	PV	9,56,200.38
FV - PV	(0.00)

Formulas:

One can retire approximately at the age of 59.7 years. (Note: There is no exact answer to this question.)

jeff jeffy answered 3 months ago

Next > < Previous

Related Solutions

Imagine that you graduate from college and your first employer offers a retirement fund that is...

Imagine that you graduate from college and your first employer offers a retirement fund that is optional for you to join. After one year on the job, you can contribute a monthly sum to the fund and earn an average return equal to the Standard and Poor’s 500, which is 10%. Assume that you are 22 when you graduate (and 23 when you start contributing), and you plan on working until you are 67, and you can contribute $500 per...

You receive a $1,000 gift from your grandmother when you graduate from college. Your grandmother withdrew...

You receive a $1,000 gift from your grandmother when you graduate from college. Your grandmother withdrew the $1,000 from her checking account and gave you ten $100 bills. You deposit the ten bills into your checking account. Discuss the impact of these transactions on your grandmother's balance sheet, your balance sheet, and the Fed's balance sheet.

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...

Lillian Coleman is 21 years old and has just graduated from college. In considering the retirement...

Lillian Coleman is 21 years old and has just graduated from college. In considering the retirement investing options available at her new job, she is thinking about the long-term effects of inflation. Help her by answering the following related questions: Explain the effect of long-term inflation on meeting retirement financial planning goals. If long-term inflation is expected to average 4 percent per year and you expect a long-term investment return of 6 percent per year, what is Lillian's long-term expected...

Assume you graduate from college with $32,000 in student loans. If your interest rate is fixed...

Assume you graduate from college with $32,000 in student loans. If your interest rate is fixed at 4.60% APR with monthly compounding and you repay the loans over a 10-year period, what will be your monthly payment?

After graduating from college with your MBA, you decide to take your grandma’s secret cinnamon roll...

After graduating from college with your MBA, you decide to take your grandma’s secret cinnamon roll recipe and open up a bakery. You grew up devouring your grandma’s rolls, and you have convinced her to give you the secret. You are confident that your bakery will be the next big hit in the fast-food business. You take out a business loan for the maximum amount your bank will give you, hire several employees, and open a beautiful store that is...

Assume that as an investor, you decide to invest part of your wealth in a risky...

Assume that as an investor, you decide to invest part of your wealth in a risky asset that has an expected return of 11%, and a standard deviation of 15%. You invest the rest of your capital in the risk-free rate, which offers a return of 3%. You want the resulting portfolio to have an expected return of 5%. What percentage of your capital should you invest in the risky asset?

You are 25 years old and decide to start saving for your retirement. You plan to...

You are 25 years old and decide to start saving for your retirement. You plan to save $3000 at the end of each year (so the first deposit will be one year from now), and will make the last deposit when you retire at age 65. Suppose you earn 10% per year on your retirement savings. How much will you have saved for retirement? How much will you have saved if you wait until age 35 to start saving (again,...

You are planning to save for your retirement in 35 years and the college tuition for...

You are planning to save for your retirement in 35 years and the college tuition for your two children. Your current monthly salary is $9,000 per month and you expect your salary to keep pace with inflation. You expect inflation to be a 3.5 percent EAR for the rest of your life. You plan to deposit 12 percent of your salary each month into a retirement account. Additionally, your employer will deposit 4 percent of your salary into the account....

3. You are planning for your retirement. You have 3,000 today to invest and plan on...

3. You are planning for your retirement. You have 3,000 today to invest and plan on putting in 300 a month until you retire in 30 years at an interest rate of 11%.The month of retire, you estimate needing 20,000 in expenses. After that, you wish to pull money each month so that there is still 500,000 at the end of your retirement 35 years after you retire. During this time, you can only earn 7% per year. How much...

Subjects