Question

You are trying to plan for retirement in 20 years and currently you have $50,000 in...

You are trying to plan for retirement in 20 years and currently you have $50,000 in a savings account and $80,000 in stocks. In addition, you plan to add to your savings by depositing $10,000 per year in your savings account at the end of each of the next 20 years, until retirement. Assume that your savings account returns 5% compounded annually and your investment in stocks will return 10% compounded annually, how much do you have at the end of 20 years? (Ignore taxes)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1 Savings 2 Annual depostit 3 Period 4 Rate of return 50000 10000 20 5% 463324.43 7 Stocks 8 Period 9 Rate of return 10 FV 801 Savings 2 Annual depostit 3 Period 4 Rate of return 50000 10000 20 0.05 -FV(B4,B3,-B2,-B1) 7 Stocks 8 Period 9 Rate of return 10 FV 80000 20 0.1 -B7*(1+B9)AB8 -SUM(B10, B5) 12 FV 13 16

Add a comment
Know the answer?
Add Answer to:
You are trying to plan for retirement in 20 years and currently you have $50,000 in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • *Handwritten Answer preferred* The Simpsons are planning to retire in 10 years. They currently have $200,000...

    *Handwritten Answer preferred* The Simpsons are planning to retire in 10 years. They currently have $200,000 in savings. In addition, they plan on adding to their savings by depositing $20,000 per year at the end of each year for the next 10 year. a) [6 pts] Assuming they receive an interest of 7% compounded annually, how much will they have in their account at the end of 10 years? b) [6 pts] At retirement, the Simpsons will deposit all of...

  • You wish to retire in 12 years and currently have $50,000 in a savings account yielding...

    You wish to retire in 12 years and currently have $50,000 in a savings account yielding 5 percent annually and $100,000 in quality “blue chip” stocks yielding 10 percent. If you expect to add $30,000 at the end of each year to your stock portfolios, how much will you have in your retirement fund when you retire? What rate of return must you earn on your retirement funds if you want to withdraw $102,000 per year for the next 15...

  • You would like to start saving for retirement and you have 40 years until the planned...

    You would like to start saving for retirement and you have 40 years until the planned retirement date. Each year, during your retirement years (assume 30 years), you would like to spend an amount equivalent to the purchasing power of $50,000 today. You estimate that the expected rate of return on some recommended investment portfolio is 8%AER and you plan to select that portfolio during the working (savings) years. Assume 4%AER yield on your investments during retirement years. The annual...

  • Your retirement plan: You hope to retire at age 62, and according to actuarial tables, you expect to live for 20 more years. You know of an investment option that will yield 4% annually compounded co...

    Your retirement plan: You hope to retire at age 62, and according to actuarial tables, you expect to live for 20 more years. You know of an investment option that will yield 4% annually compounded continuously, and you plan to withdraw $50,000 per year in retirement, for 20 years. How much money will you need to have in the account at the beginning of retirement so that you can withdraw $50,000/year for 20 years? Begin your solution with letting R(t)...

  • You have 35 years until your retirement. You currently have $50,000 in your 401(k) account. You...

    You have 35 years until your retirement. You currently have $50,000 in your 401(k) account. You can contribute $10 thousand per year and your company will match 50 percent of your contribution. You expect an average return of 8% over the life of your 401(k) investments. a. What is your future value of your 401(k) in 35 years? b. What is your future value of your 401(k) if the average return drops to 5%? c. Given the original information above...

  • You are 25 years old, having just started working. You are considering a retirement plan for...

    You are 25 years old, having just started working. You are considering a retirement plan for a retirement at the age of 65. You want to be able to withdraw $76,000 from your savings account on each birthday for 20 years following your retirement at the age of 65. Your first withdrawal will be on your 66th birthday. To achieve your goal, you intend to make equal annual deposits in a pension scheme which offers 7% interest per year. According...

  • 6. You are trying to determine how much money you will need at retirement in your...

    6. You are trying to determine how much money you will need at retirement in your retirement "nest egg." You plan to retire on your 60th birthday and immediately take your first withdrawal from your retirement account of $4,583.33. You plan to make 24 such withdrawals each year (i.e., two per month). You plan on doing his until you are 72 years old. Assume beginning of the period withdrawal with the first on your 60th birthday and your final birthday....

  • You are planning your retirement in 10 years. You currently have $166,000 in a bond account...

    You are planning your retirement in 10 years. You currently have $166,000 in a bond account and $606,000 in a stock account. You plan to add $7,400 per year at the end of each of the next 10 years to your bond account. The stock account will earn a return of 11 percent and the bond account will earn a return of 7.5 percent. When you retire, you plan to withdraw an equal amount for each of the next 24...

  • You are trying to decide how much to save for retirement. Assume you plan to save...

    You are trying to decide how much to save for retirement. Assume you plan to save $4,000 per year with the first investment made one year from now. You think you can earn 7.0% per year on your investments and you plan to retire in 45 years, immediately after making your last $4,000 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing $4,000 per year, you wanted to...

  • Problem 7 (12 marks) You are currently 25 years old and have decided to start paying...

    Problem 7 (12 marks) You are currently 25 years old and have decided to start paying into your registered retirement plan. You will start to deposit $125 at the end of each month starting with this month until you are 60 years old and you retire. If interest rates are expected to be 5% compounded monthly from the time you are 25 until you are 40 and then are 6% compounded monthly until you retire at 60. a. How much...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT