Question

In: Finance

1. You have just turned 22, and you intend to start saving for your retirement. You...

1. You have just turned 22, and you intend to start saving for your retirement. You plan to retire in 43 years when you turn 65. During your retirement, you would like to have an annual income of$120,000 per year for 26years (until age 91).

a)Calculate how much you need to have in your account before the first withdrawal at age 66.

b)Calculate how much you would have to save annually between now and age 65 in order to finance your retirement income and to fill that account.

Make the following assumptions:

Assume that the relevant compounded interest rate is 4 percent per year.

You make the first deposit today and the last deposition the day you turn 65 (44 deposits in total).

You make the first withdrawal when you turn 66and the last withdrawal when you turn 91(26 withdrawals).

(PLEASE SHOW STEP-BY-STEP EXCEL FORMULA WITH FUNCTIONS)

Solutions

Expert Solution

A: Amount required before the first withdrawal

Using financial calculator

Input: N =26

I/Y = 4

PMT = -120000

Solve for PV as 1,917,932.30

Hence amount required before first withdrawal = $1,917,932.30

B: Since the deposits are made at the beginning of periods, this is annuity due.

n=44

Rate = 4%

Fv of annuity due= 1,917,932.30

Future Value of annuity due= (1+Rate)*A*((1+rate)^number of periods-1)/rate

1,917,932.30 = 1.04*A*(1.04^44-1)/0.04

1,917,932.30=120.029392 *A

A = 1,917,932.30/ 120.029392

= 15978.86

Amount to be saved annually =15978.86

Excel formula


Related Solutions

You have just turned 25 years old and decide to start saving for your retirement. You...
You have just turned 25 years old and decide to start saving for your retirement. You plan to save $5,000 at the end of each year (so the first deposit will be one year from now), and will make the last deposit when you retire when you turn 65 (that is, 40 deposits in total. Suppose your pension fund earns 8% per year on your retirement savings. a) How much will you have saved for retirement by the time you...
You have just turned 20 and decided to begin saving $750 quarterly for your retirement. If...
You have just turned 20 and decided to begin saving $750 quarterly for your retirement. If you average 9.0% annual return on your account, how much will you have accumulated when you retire at age 65? (round to nearest penny)
You want to start saving for retirement. You currently have $7,000 set aside for retirement in...
You want to start saving for retirement. You currently have $7,000 set aside for retirement in an IRA. You want to contribute an additional $300 per month for the next 5 years (10%). Then, you believe that you can invest $1,000 per month for the next 45 years (10%). How much would you have at retirement if you would do this?
You have just turned 22 received your degree and accepted your first job. You must decide...
You have just turned 22 received your degree and accepted your first job. You must decide how much to put in your retirement plan. The plan works as follows. Every dollar in the plan earns 6.5 percent per year. You may not make withdrawals until you retire at 65. After that you can withdrawal money as needed. You believe you will live to 100 and work until 65, and believe you need 95000 per year to be comfortable starting at...
You are just 25 years old and you have $50,000 in your retirement saving accounts. You...
You are just 25 years old and you have $50,000 in your retirement saving accounts. You expect to retire at the age of 65 (work for 40 more years) and expect to live for another 25 years after your retirement. On the day you retire, you want to have enough money in our retirement saving accounts such that you are able to draw $7,000 per month for 25 years. You are conservative in your estimate of interest rate and expect...
Suppose you start saving for retirement by depositing $4,000 EVERY YEAR into your retirement account. If...
Suppose you start saving for retirement by depositing $4,000 EVERY YEAR into your retirement account. If your annual return is 8%, how much will you have in 45 years? How much would you have if all deposits were made on the FIRST of the year (as opposed to the last day of the year)? (please solve by hand and not excel)
Your friend tells you that she wants to start saving for retirement by investing in the...
Your friend tells you that she wants to start saving for retirement by investing in the stock market. Given that you have taken this finance class, she asks you for advice about what stocks she should buy. What would you tell her?
You are 25 years old and decide to start saving for your retirement. You plan to...
You are 25 years old and decide to start saving for your retirement. You plan to save $3000 at the end of each year (so the first deposit will be one year from now), and will make the last deposit when you retire at age 65. Suppose you earn 10% per year on your retirement savings. How much will you have saved for retirement? How much will you have saved if you wait until age 35 to start saving (again,...
You are 25 years old and decide to start saving for your retirement. You plan to...
You are 25 years old and decide to start saving for your retirement. You plan to save $5,000 at the end of each year​ (so the first deposit will be one year from​ now), and will make the last deposit when you retire at age 65. Suppose you earn 8% per year on your retirement savings. a. How much will you have saved for​ retirement? The amount that you will have accumulated for retirement is _____ b. How much will...
Tom decides to get an early start on retirement saving and, beginning at age 22, he...
Tom decides to get an early start on retirement saving and, beginning at age 22, he invests $4,000 per year in a Roth IRA for 10 years in a row. At that point, he stops contributing to the account but leaves the money invested until age 65 (a period of 33 years). Harry doesn’t start investing until he’s 32 but from then on invests $5,000 in a Roth IRA each year for 33 years until retirement at age 65. If...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT