Today is your 30th birthday and you plan to retire in 30 years when you are...

Today is your 30th birthday and you plan to retire in 30 years when you are 60. You expect to need $75,000 a year in retirement (the first $75,000 will be paid on your 61st birthday) and expect to live to be 95. If you assume you can earn a nominal rate of 5.5% on your investments calculate the amount you will need to save each year until you retire if you start saving next year on your 31st birthday. Solve in Nominal terms.

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.5% (rate of return earned)

nper = 35 (number of years in retirement)

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

PV is calculated to be $1,154,291.41

Next, we calculate the yearly saving required to accumulate the required amount at retirement. The yearly saving required is calculated using PMT function in Excel :

rate = 5.5% (rate of return earned)

nper = 30 (number of years until retirement)

pv = 0 (amount currently saved is zero)

fv = 1154291.41 (required amount at retirement)

PMT is calculated to be $15,935.44

Amount you will need to save each year is $15,935.44

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Today is your 22nd birthday. You plan to retire on your 60th birthday, immediately after making...

Today is your 22nd birthday. You plan to retire on your 60th birthday, immediately after making your last savings deposit, and begin collecting your retirement payments on your 61st birthday. You decide that your retirement payment will be $80,000 at age 61, growing at 1.5% per year afterwards, and you expect to collect a total of 35 payments. Starting on your 23rd birthday, and on every birthday before you retire, you will make a deposit into your retirement savings account....

Today is your 25th birthday. Your goal is to retire when you turn 70 years old...

Today is your 25th birthday. Your goal is to retire when you turn 70 years old and have sufficient monthly income until your expected demise on your 99th birthday. In order to realize your goal, you are planning to make deposits into a target-date retirement fund that is expected to generate 7.8% annual return, compounded monthly. You want to be able to make monthly withdrawals from this fund starting one month after your retirement until your expected demise. These monthly...

Question 2: You plan to retire 30 years from today on a perpetual weekly income of...

Question 2: You plan to retire 30 years from today on a perpetual weekly income of $1500 per week(i.e. for the purposes of this example. Assume that you live forever). Assuming that your savings earn a n APR of 5% during retirement and 7% before retirement (both with semi-annual compounding), how much money would you need to start saving at the end of each month until retirement to achieve your goal? (52 weeks in a year) Assume that you also...

Assume that you are 30 years old today and expect to retire when you reach age...

Assume that you are 30 years old today and expect to retire when you reach age 65. If you were to retire today, you would like a fixed (pretax) income of $60,000 per year (in addition to Social Security) for a period of 15 years (your approximate life expectancy at age 65). However, you realize that price inflation will erode the purchasing power of the dollar over the next 35 years and you want to adjust your desired retirement income...

Today is Rachel’s 30th birthday. Five years ago, Rachel opened a brokerage account when her grandmother...

Today is Rachel’s 30th birthday. Five years ago, Rachel opened a brokerage account when her grandmother gave her $25,000 for her 25th birthday. Rachel has added $400 to this account each month beginning the month after her 25th birthday. Rachel wants to know how much she needs to add to this account to reach her goal of $400,000 in the account by her 40th birthday. Starting one month from today, she plans to contribute a fixed amount to the account...

Mr. Ambitious is celebrating his 30th birthday today. He plans to retire shortly after his 50th...

Mr. Ambitious is celebrating his 30th birthday today. He plans to retire shortly after his 50th birthday and estimates that he can live comfortably off a pension of $50,000 per year, paid annually for 40 years starting with his 51st birthday. He reckons that in order to achieve this, he only needs to invest $50,000 into his retirement fund every two years until he retires. The first investment will be made on his 32nd birthday and the last on his...

Suppose you plan to retire in 33 years. Today, your retirement has a balance of 500,000....

Suppose you plan to retire in 33 years. Today, your retirement has a balance of 500,000. If you can earn 3% per year in your retirement account, how much more do you need to deposit now so that you can have 2.9 million when you retire? 1. 694,761.60 2. 1,593,376.12 3. 1,093,376.12 4. 593,376.12

2) Today, you celebrated your 30th birthday. Also, you just landed a new job, thanks to...

2) Today, you celebrated your 30th birthday. Also, you just landed a new job, thanks to your excellent education at BW. The new firm provides you a 401-k plan, and you decide to deposit $400 every month for first 20 years. After that (since your kids are out in college and your living expenses are lower) you increase your contribution by $200/month, that results in a total contribution of $600/month. The firm matches it at 100% and deposits the money...

You plan to work for another 30 years at which point you plan to retire, after...

You plan to work for another 30 years at which point you plan to retire, after which you expect to live for another 30 years. During your retirement, you plan to make annual withdrawals at the beginning of each year where each withdrawal should have the same purchasing power as $100,000 today. You would also like to provide a bequest to your children (paid when you die) that has the same purchasing power as $1 million today. To provide for...

Today is Sofia’s 35th birthday. She plans to retire in 32 years at the age of...

Today is Sofia’s 35th birthday. She plans to retire in 32 years at the age of 67, with expected life expectancy of 30 years after that. To maintain her life style, she thinks she will have to withdraw $8,000 from retirement account at the beginning of each month during retirement. Meanwhile, she plans to donate $100 to charity starting on her 70th birthday, and the monthly payment will continue till she passes away. In addition, she would like to establish...

Subjects