Question

In: Finance

you plan to retire in 35 years. during each year of retirement, you want to have...

you plan to retire in 35 years. during each year of retirement, you want to have an amount of money with the same prchaning powe that $50,000 has today. inflation is expected to be 3% per year form now.

A. how much money do you need in the first year of retiment (35 years from todya)? round to the nearest dollar.

B.  Ignore your answer to “a” and assume you need $125,000 in the first year of
retirement. Call it CF1. Note that you withdraw that money 35 years from today (t = 35). Now
assume you will keep your retirement savings (“nest egg”) in an investment that generates a
return of 4% per year, during each year of your retirement and in the year before it starts. You
plan to be retired for 27 years. You will continue to need the same purchasing power (during each
year of retirement) that $125,000 represents in the first year of retirement. Inflation will remain
at 3% per year forever. How much money do you need to have in your retirement account, one
year before your retirement starts (this helps with timing issues), to fund (or finance) this stream
of withdrawals [i.e. what is the nest egg size at t=34]? Round your final answer to the nearest
thousand dollars.

C.Ignore your answer to “b” and assume your nest egg size at [t = 34] is $5,000,000.
Also assume that you will save money in an investment that earns 7% per year until [t = 34], to
reach your goal. You will make your first savings payment (into the investment) in one year (CF1).
You will grow your annual payments by 2% per year. You will make 34 annual payments. How big
must your first savings payment be, to reach your goal?

Solutions

Expert Solution

For Part A

To have the same purchasing power of amount $ 50,000 after 35 years follow below principle to calculate figure -

Future Value = 50,000 (3% ; 35 Yrs) FVAT ( Future Value Annuity Factor)

= 50,000 * 2.814

= $ 1,40,700 (After 35 years you should have $ 1,40,700 to have same purchasing capacity as of today).

For Part B

Below Schedule will help you out to know the value of nest egg amount as of t 34 i.e.

Term Yr Nest Size
Year-end
Earnings Withdrawals Present Value factor @ 4% Present Value of Withdrawl
0 34            2,870,252                   0.9615
1 35            2,860,062          114,810            125,000                   1.0000                            125,000
2 36            2,845,715          114,402            128,750                   0.9615                            123,798
3 37            2,826,931          113,829            132,613                   0.9246                            122,608
4 38            2,803,417          113,077            136,591                   0.8890                            121,429
5 39            2,774,865          112,137            140,689                   0.8548                            120,261
6 40            2,740,951          110,995            144,909                   0.8219                            119,105
7 41            2,701,332          109,638            149,257                   0.7903                            117,960
8 42            2,655,651          108,053            153,734                   0.7599                            116,825
9 43            2,603,531          106,226            158,346                   0.7307                            115,702
10 44            2,544,575          104,141            163,097                   0.7026                            114,590
11 45            2,478,369          101,783            167,990                   0.6756                            113,488
12 46            2,404,474            99,135            173,029                   0.6496                            112,396
13 47            2,322,433            96,179            178,220                   0.6246                            111,316
14 48            2,231,764            92,897            183,567                   0.6006                            110,245
15 49            2,131,961            89,271            189,074                   0.5775                            109,185
16 50            2,022,493            85,278            194,746                   0.5553                            108,136
17 51            1,902,805            80,900            200,588                   0.5339                            107,096
18 52            1,772,311            76,112            206,606                   0.5134                            106,066
19 53            1,630,399            70,892            212,804                   0.4936                            105,046
20 54            1,476,427            65,216            219,188                   0.4746                            104,036
21 55            1,309,720            59,057            225,764                   0.4564                            103,036
22 56            1,129,572            52,389            232,537                   0.4388                            102,045
23 57               935,242            45,183            239,513                   0.4220                            101,064
24 58               725,953            37,410            246,698                   0.4057                            100,092
25 59               500,892            29,038            254,099                   0.3901                              99,130
26 60               259,206            20,036            261,722                   0.3751                              98,176
27 61                            0            10,368            269,574                   0.3607                              97,232

According to above schedule you should have $ 28,70,252 to withdraw amount of $ 1,25,000 along with inflation addition.


Related Solutions

You want to retire in 35 years and plan to invest $2,000 per month until you...
You want to retire in 35 years and plan to invest $2,000 per month until you retire. If you would like to be able to withdraw $200,000 per year for 25 years during retirement, what annual rate will you have to earn until retiring if you expect to earn 5% after you retire?
You want to retire 35 years from today with $2.5 million in your Individual Retirement Account...
You want to retire 35 years from today with $2.5 million in your Individual Retirement Account (IRA). You currently have 100,000.00 saved in your IRA which is earning 9.00% annually. What amount would you need to save and deposit at the beginning of each quarter to achieve your retirement goal? Note that you are making the deposits quarterly, not annually.
You plan to retire in year 20 Your retirement will last 25 years starting in year...
You plan to retire in year 20 Your retirement will last 25 years starting in year 21 You want to have $50,000 each year of your retirement. How much would you have to invest each year, starting in one year, for 15 years , to exactly pay for your retirement ,if your investments earn 6.00% APR (compounded annually)?
You plan to retire in year 20 Your retirement will last 25 years starting in year...
You plan to retire in year 20 Your retirement will last 25 years starting in year 21 You want to have $50,000 each year of your retirement. How much would you have to invest each year, starting in one year, for 15 years , to exactly pay for your retirement ,if your investments earn 6.00% APR (compounded annually)? Answers: $21,349 $21,546 $20,930 $20,520
You plan to retire in year 20 Your retirement will last 25 years starting in year...
You plan to retire in year 20 Your retirement will last 25 years starting in year 21 You want to have $50,000 each year of your retirement. How much would you have to invest each year, starting in one year, for 15 years , to exactly pay for your retirement ,if your investments earn 6.00% APR (compounded annually)? a. 21.,349 b. 21, 546 c. 20,520 d. 20,930
If you want to have an $500,000 amount (F) when you retire in 35 years, what...
If you want to have an $500,000 amount (F) when you retire in 35 years, what equal series amount (A) do you need to invest each year with a 5% interest rate? (Hint, use (A/F, i, n)) Same question as 1, but how much is the equal series amount (A) if you had procrastinated for 10 years and now have only 25 years to accumulate the $500,000 desired at retirement? Same question as 2, but the interest rate is 7%,...
You are 25 years old and plan to retire 35 year from today. You expect that...
You are 25 years old and plan to retire 35 year from today. You expect that you will live 30 years after retiring. You want to have enough money upon reaching retirement age to withdraw $150,000 from the account at the beginning of each year you expect to live, and yet still have $1,000,000 left in the account at the time of your expected death (65 years from now). You plan to accumulate the retirement fund by making equal annual...
You are 25 years old and plan to retire 35 year from today. You expect that...
You are 25 years old and plan to retire 35 year from today. You expect that you will live 30 years after retiring. You want to have enough money upon reaching retirement age to withdraw $150,000 from the account at the beginning of each year you expect to live, and yet still have $1,000,000 left in the account at the time of your expected death (65 years from now). You plan to accumulate the retirement fund by making equal annual...
A couple will retire in 40 years; they plan to withdraw $39,000 a year in retirement,...
A couple will retire in 40 years; they plan to withdraw $39,000 a year in retirement, and they will make 20 withdraw. They believe that they can earn 8% interest on the retirement savings. - If they make annual deposit into their retirement savings, how much will they need to save each year? Assume the first deposit comes at the end of the first year, and the first withdraw comes at the end of year 41.
You set up a savings plan for retirement in 35 years. You will deposit $250 each...
You set up a savings plan for retirement in 35 years. You will deposit $250 each month for 35 years. The account will earn an average of 6.5% compounded monthly. a. How much will you have in your retirement plan in 35 years? b. How much interest did you earn. c. What percent of the balance is interest? Could you show the formula in Excel? I think it is PV.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT