Personal Finance Concepts

posted by .

I have a project with a group portion and an individual portion. My question is how on earth do I start this, determine the figures in question, etc?!?! Here are the details of the project:

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:

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.)
He waits 10 years to begin putting 6% of his salary in the plan.

Each of you are to prepare your own spreadsheet for this task. The spreadsheet should clearly indicate each of the two scenarios required in the assignment. For the first scenario assume Tom puts his 6% into the fund at the END of each year with one ANNUAL payment. Also assume that Tom gets his annual salary increase each year AFTER the first year (so no raise until 1/1/09 for example). Monthly payments to the fund are not acceptable for this assignment. Use the same basic assumptions for scenario two, only he waits ten years to begin. You will need to use time value of money calculations for these deposits, and this would be a regular annuity when you go to use the tables in the text. You are not required to use the tables (you could use a financial calculator for example). Make sure your work is clearly labeled and explained.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. project Manangement

    Think of a recently completed group project that you have been involved in. This project may have been a student project, a group project, or an extracurricular project. Briefly describe the situation and choose one of the following …
  2. Mike: Project Management

    I've removed your post because you refer to information to which we have no access: "Using the project you created in Unit 1 Individual Assignment, . . ." The rest of your post has a complex set of instructions -- but no indication …
  3. Finance

    Wheel Industries is considering a three year expansion project. The project requires an initial investment of $1.5 million. The project will use straight line depreciation method. The project has no salvage value. It is estimated that …
  4. management

    Think of a recently completed group project that you have been involved in. This project may have been a student project, a group project, or an extracurricular project. Briefly describe the situation and choose one of the following …
  5. management

    Think of a recently completed group project that you have been involved in. This project may have been a student project, a group project, or an extracurricular project. Briefly describe the situation and choose one of the following …
  6. Business finance

    Question No 1: Sumi Inc. has policy of paying a Rs. 9 per share dividend every year. If this policy is to continue indefinitely, what will be the value of a share of stock at a 12% required rate of return?
  7. Academic and Professional Success

    You are working with another student on a group project and the portion the classmate submitted to you does not meet the expected criteria. You are concerned because you have worked very hard on your portion and really want an "A". …
  8. health

    Your health care organization has called upon you to lead a work team to identify service-quality problems within the environment. Individual Portion Answer the following questions about work teams: •What are the benefits of a strong …
  9. Discussion Board

    You are working with another student on a group project and the portion the classmate submitted to you does not meet the expected criteria. You are concerned because you have worked very hard on your portion and really want an "A". …
  10. project management

    Question (6) chapter 8 pages (286 - 287) here is what my instructor sent regarding the Q 6: - - - - - - - - - - - - - - - - - - - - - - - - - - - -- -- - -- - -- - - This exercise is similar to the resource scheduling issues you face …

More Similar Questions