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?

Solutions

Expert Solution

First, we calculate the amount required at retirement to enable the yearly withdrawals during retirement. The amount required at retirement is calculated using PV function in Excel :

rate = 5% (rate of return earned during retirement)

nper = 25 (number of years in retirement)

pmt = -200000 (yearly withdrawal. This is entered with a negative sign because it is a withdrawal)

PV is calculated to be $2,818,788.91

Next, we calculate the annual rate will you have to earn until retiring to accumulate the required amount at retirement. The annual rate will you have to earn until retiring is calculated using RATE function in Excel :

nper = 35 * 12 (total number of monthly investments = number of years until retirement * 12)

pmt = -2000 (Monthly investment. This is entered with a negative sign because it is a cash outflow)

pv = 0 (amount currently saved is zero)

fv = 2818,788.91 (required amount at retirement)

RATE is calculated to be 0.4961%. This is the monthly rate. To get annual rate, we multiply by 12. Annual rate is 5.953%

You will have to earn an annual rate of 5.953% until retiring

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

You hope to retire in 35 years and plan to invest $350 per month until retiring....

You hope to retire in 35 years and plan to invest $350 per month until retiring. If you expect to earn 9% until you retire and 5% after retiring, how much will you be able to withdraw each month for 30 years during you retirement? A. $5,527 B. $939.44 C. $2,424.29 D. $283.62

You plan to save $1,200 per month for the next 35 years until you retire. After...

You plan to save $1,200 per month for the next 35 years until you retire. After you retire you want to withdraw $450,000 per year for 30 years. If you expect to earn 6% after retirement, what annual rate will you need to earn until you retire to meet your goal?

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

You will retire in 30 years. At the beginning of each month until you retire, you...

You will retire in 30 years. At the beginning of each month until you retire, you will invest X earning interest at 9% convertible monthly. Starting at year 30, you will withdraw $4,000 at the beginning of each month for the next 15 years. Also, starting at year 30, your fund will only earn interest at 6% convertible monthly. Find X such that your account will be empty after the last withdrawal.

Assume that you plan to retire in 35 years and that you estimate you will need...

Assume that you plan to retire in 35 years and that you estimate you will need an income of $100,000 at the beginning of each year for 30 years, following your retirement. You also plan to donate $1,000,000 to the Georgia Southern University College of Business to endow a scholarship in the name of your favorite finance professor. You will make this endowment exactly 5 years after you retire. Assume that you will earn 11.00 percent during your working years...

You are 22 and plan to work for 43 years until you retire at 65. You...

You are 22 and plan to work for 43 years until you retire at 65. You expect to live until you are 88. You will collect a pension. Your annual pension payment will be equal to your final salary times a 3% crediting rate times the number of years that you work. Your starting salary (paid at the end of the year) is $50,000. You expect to get a 4% annual raise. Your discount rate is 5%. Draw a timeline...

You are 30 years old today and planning to retire at age 62. You want to plan your finances for living 35 years past age 62 and die dead broke. You determine you will need $3000 per month from age 62 for the 35 years.

You are 30 years old today and planning to retire at age 62. You want to plan your finances for living 35 years past age 62 and die dead broke. You determine you will need $3000 per month from age 62 for the 35 years.Your plan is to go live in the tropics, on the beach, and live on coconuts and fishing. Also, you need to conclude your retirement savings at age 55 because all your spare money then will...

Assume you are 32 years old and plan to retire in 35 years at age 67....

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 year (that increases with inflation). [Remember this is...

You plan to retire 35 years from now. You expect that you will live 25 years...

You plan to retire 35 years from now. You expect that you will live 25 years after retiring. You want to have enough money upon reaching retirement age to withdraw $180,000 from the account at the beginning of each year you expect to live, and yet still have $2,500,000 left in the account at the time of your expected death (60 years from now). You plan to accumulate the retirement fund by making equal annual deposits at the end of...

You plan to retire in 40 years. After that, you want to receive an annuity of...

You plan to retire in 40 years. After that, you want to receive an annuity of 5000 per month for 25 years, beginning immediately upon retirement. If you can earn 6% per year, compounded monthly, how much must you invest at the end of each month before retirement?

Subjects