Question

A forty-year-old employee earns $75,000 per year and expects to receive 2.5% annual raises at the end of each year for the ne
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Year Salary Contribution @ 4% at beginning of year Total fund value at beginning of year Interest @ 4% Total fund value at end of year
1 75000.00 3000.00 3000.00 120.00 3120.00
2 76875.00 3075.00 6195.00 247.80 6442.80
3 78796.88 3151.88 9594.68 383.79 9978.46
4 80766.80 3230.67 13209.13 528.37 13737.50
5 82785.97 3311.44 17048.94 681.96 17730.90
6 84855.62 3394.22 21125.12 845.00 21970.12
7 86977.01 3479.08 25449.21 1017.97 26467.17
8 89151.43 3566.06 30033.23 1201.33 31234.56
9 91380.22 3655.21 34889.77 1395.59 36285.36
10 93664.72 3746.59 40031.95 1601.28 41633.23
11 96006.34 3840.25 45473.48 1818.94 47292.42
12 98406.50 3936.26 51228.68 2049.15 53277.83
13 100866.66 4034.67 57312.49 2292.50 59604.99
14 103388.33 4135.53 63740.53 2549.62 66290.15
15 105973.04 4238.92 70529.07 2821.16 73350.23
16 108622.36 4344.89 77695.13 3107.81 80802.93
17 111337.92 4453.52 85256.45 3410.26 88666.70
18 114121.37 4564.85 93231.56 3729.26 96960.82
19 116974.40 4678.98 101639.80 4065.59 105705.39
20 119898.76 4795.95 110501.34 4420.05 114921.39
21 122896.23 4915.85 119837.24 4793.49 124630.73
22 125968.64 5038.75 129669.48 5186.78 134856.26
23 129117.85 5164.71 140020.97 5600.84 145621.81
24 132345.80 5293.83 150915.64 6036.63 156952.27
25 135654.45 5426.18 162378.45 6495.14 168873.58

Retirement Fund Value = 168873.58

Add a comment
Know the answer?
Add Answer to:
A forty-year-old employee earns $75,000 per year and expects to receive 2.5% annual raises at the...
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
  • John starts his career at 21 years old and expects to retire 44 years later at the age of 65. His first annual salary is...

    John starts his career at 21 years old and expects to retire 44 years later at the age of 65. His first annual salary is $72,000 that will increase at 1.5% per year until he finishes his part-time MBA at 28 years old. With his MBA, John expects salary to increase at 3% per year until retirement. At the end of each year, he deposits 10% of his annual salary into a retirement saving plan that pays 6% interest per...

  • 2. [30 points] A young engineer's starting annual salary is $55,000. The engineer expects annual raises of 2%. The engi...

    2. [30 points] A young engineer's starting annual salary is $55,000. The engineer expects annual raises of 2%. The engineer will deposit a constant percentage of the annual salary at the end of each year in a savings account that earns 5%. What percentage must be saved so that there will be $1 million in savings for retirement after 40 years? (Hint: Use GOAL Seek)

  • Q1. Your firm decides to begin to fund a retirement pension for a new employee. The...

    Q1. Your firm decides to begin to fund a retirement pension for a new employee. The details of the pension plan are as follows: The employee is 30 years old; the pension fund will begin to make annual payments to the employee 20 years from the date when funding for the pension begins. When payments begin, the employee will receive quarterly payment for 15 years. The first quarterly payment will be $ 20,000, and each succeeding payment will grow by...

  • FOCUS ON SHOWING CORRECT TIMELINE! THANKS Problem: Assume you are 32 years old and plan to...

    FOCUS ON SHOWING CORRECT TIMELINE! THANKS Problem: Assume you are 32 years old and plan to retire in 35 years at age 67. You are currently earning $75,000/ year and expect average annual salary increases of 4.0%year over the next 35 years. You have $0 saved for retirement. You are trying to determine how much money to save (invest) each year in your 401(k) Plan to fund your retirement in order to pay yourself 70% of your final salary each...

  • An employee has decided to make annual contributions over a 15-year period into a retirement fund....

    An employee has decided to make annual contributions over a 15-year period into a retirement fund. She wants to make the first contribution of $10,000 one year from now (t=1). She then plans to increase her annual contribution by $1,000 each year for the remaining years. The fund is expected to earn 10% per year compounded annually. If she decides to retire in 15 years (from now), what equal annual amount can she withdraw annually for a period of 10...

  • Investment A You are 25 years old, having just started working. You are considering a retirement...

    Investment A 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 $79,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...

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

  • Larry, a 40 year old salesperson, earns $90,000 per year and plans to work until age...

    Larry, a 40 year old salesperson, earns $90,000 per year and plans to work until age 65. He is married to Joan and has 2 children. He expects his annual salary increases to be 3%, and the inflation rate to be 3%, and their average tax bracket (state and federal) is 25%. Larry estimates that 15% of his after-tax income is used for personal consumption. Based on the Human Life Value approach to life insurance needs analysis, how much life...

  • Tasha Jones, a 21-year-old and newly-hired civil engineer, does not plan to keep close tabs on...

    Tasha Jones, a 21-year-old and newly-hired civil engineer, does not plan to keep close tabs on how her 401(k) retirement account's balance will change over time. Instead, she plans to make a reasonable annual contribution that grows each year. Tasha’s contribution, plus her employer matching her contribution, amounts to $4,000 per year which started when she was hired. Thanks to pay raises, Tasha expects the contribution to increase by 2.5% each year until she retires at the age of 67....

  • Applications of Finance When Sam retires at age 67, he wishes to withdraw all his superannuation...

    Applications of Finance When Sam retires at age 67, he wishes to withdraw all his superannuation as a lump sum and use that to invest in an annuity that pays him $70,000 each year for 20 years. This $70,000 income comprises of part principal draw down on the lump sum he invested and part interest he earns from the return on his lump sum. Sam can earn a 2% p.a. return on his lump sum investment. By the final year,...

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