| 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
A forty-year-old employee earns $75,000 per year and expects to receive 2.5% annual raises at the...
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 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 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 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. 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 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 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 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 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....
Imagine you are 25 years old right now. You would like to retire in 40 years (at age 65). You would like to fund your retirement. You would like to have enough saving to withdraw $50,000 each year in retirement and you want to plan for 20 hears (the last withdrawal is at age 85). You will earn 7% annually on your saving before you retire. Then once you retire, you will move your nest egg into a safer investment,...