Purchase Solution

Company benefits 401K

Not what you're looking for?

Ask Custom Question

Your younger brother, Tom, just received information from his company on his benefits. He tells you that he is not interested in reading the retirement information because he has another 30 years of working before he can even consider retiring. You take a look at the information and see that his company offers a great 401(k) plan that matches contributions up to 6% and has been offering an average return of 12% annually. At this time Tom is making $30,000 per year and receives an average raise of 3% per year.

Individually: Prepare a spreadsheet for Tom that shows how much money he could expect to have in his retirement account in 30 years given the following scenarios:

1. He takes advantage of the 401(k) plan offered by his employer by putting 6% in the plan for the next 30 years. (Assume that the plan will continue to earn 12% annually).
2. He waits 10 years to begin putting 6% of his salary in the plan.

Purchase this Solution

Solution Summary

The solution provides a detailed spreadsheet that shows how much money Tom could expect to have in his retirement account in 30 years given two different scenarios.

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Operations Management

This quiz tests a student's knowledge about Operations Management

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Learning Lean

This quiz will help you understand the basic concepts of Lean.