Suppose that you wish to save enough to fund $4,500 per month (in today's purchasing power)...

Suppose that you wish to save enough to fund $4,500 per month (in today's purchasing power) for 30 years of retirement. The fund you invest in during your working (or saving) years is expected to earn interest at 6% AR. At retirement, you will move your retirement funds into a less risky investment earning 4% AR. If you are 35 years from retirement, find the level of monthly savings (in current dollars) that will be required.

Please show work :)

Solutions

Expert Solution


	Assuming Annual inflation =2%
	Monthly amount required on retirement(actual dollar)
	$4500*(1+0.02)^35=	$9,000
	Inflation adjusted return during retirement	2%	(4-2)
Rate	Inflation adjusted monthly return =(2/12)%=	0.1667%
Nper	Number of Months in retirement	360	(30*12)
Pmt	Monthly amount required	$9,000
PV	Retirement Fund Required at retirement	$2,434,802	(Using PV function of excel with Rate=0.1667%,Nper=360,Pmt=-9000)
	MONTHLY SAVINGS REQUIRED
Rate	Interest rate during savings=(6/12)%	0.50%
Nper	Number of months of savings	420	(35*12)
FV	Future Value required at retirement	$2,434,802
PMT	Monthly savings required in actual dollars	$1,709	(Using PMT function of excel with Rate=0.5%,Nper=420,Fv=-2434802)

jeff jeffy answered 2 months ago

Next > < Previous

Related Solutions

You plan to deposit $4,500 per month in your kid’s college fund for 12 consecutive years....

You plan to deposit $4,500 per month in your kid’s college fund for 12 consecutive years. Assuming an annual rate of 6% how much should you expect to have on the account at the end of year 12?

Suppose you save $100 per month the year you graduate (at age 22) and get a...

Suppose you save $100 per month the year you graduate (at age 22) and get a 10% return, roughly how much will it be worth when you retire in your mid 60s. Group of answer choices $48,000 $64,000 $77,000 $1200

1. If your salary is $ 1,500 per month and you save $ 500 per month,...

1. If your salary is $ 1,500 per month and you save $ 500 per month, your savings rate is 2. How much money should you invest today at 8% interest to get it to grow to $ 15,000 years? 3. What annual interest rate will make $ 500 increase to $ 1,948 in 12 years? 10 years

Suppose you save $1,000 per month for 35 years. The bank promises you an annual interest...

Suppose you save $1,000 per month for 35 years. The bank promises you an annual interest rate of 3% compounded monthly. How much will the savings account be worth in 35 years? (Assume no withdrawals take place). 420,000.00 $741,563.66 $913,730.94 $1,523,212.27

Now that you are going to save 100 €/month, you decided to save those 100€ per...

Now that you are going to save 100 €/month, you decided to save those 100€ per month in a bank account that offers a 2% interest rate compounded monthly, till the day you retire (that is to say, in 20 years). Please answer the following questions: If you decide to do your deposits at the end of every month (similarly to ex.1, so your first deposit will be in one month from today) in a bank account that offers a...

Suppose your financial advisor tells you that you need to save enough to draw no more...

Suppose your financial advisor tells you that you need to save enough to draw no more than 4% of your initial retirement account balance each year once you retire. You want to withdraw $50,000 per year. What balance must you achieve in your retirement account to reach your goal? Select one: a. $50,000 b. $2,000 c. $1,250,000 d. $679,516

Suppose that you just had your first baby, Oprah, and you wish to ensure that enough...

Suppose that you just had your first baby, Oprah, and you wish to ensure that enough money will be available to pay for Oprah's college education. Tuition and other fees today add up to $12,500 per year. Tuition and other costs are expected to increase at a rate of 4 percent per year. Assuming that all of Oprah's college savings are invested in an account paying 7 percent interest, then the amount of money she will need to have available...

This month, June, your parents wish to save $10,000 for your wedding that will be on...

This month, June, your parents wish to save $10,000 for your wedding that will be on 16th December next year. They start deposit by the end of June and earn j12 = 6% p.a. a) What is the regular deposit required? b) Immediately after your five deposits interest rates fall to j12 = 5%. What new deposit size is required to meet your original target?

1. Suppose a hedge fund earns 1% per month every month. a. What is the EAR...

1. Suppose a hedge fund earns 1% per month every month. a. What is the EAR on an investment in this fund? b. If you need $1 million dollars in 5 years, how much do you have to invest in the fund today? c. If you invest $1 million today, how much money will you have in 5 years? d. If you invest $1,000 every month for 24 months, starting immediately (i.e., first investment at time 0, last investment 23...

You save $75 a month for 30 years. If you are able to earn 6%per...

You save $75 a month for 30 years. If you are able to earn 6% per year on your savings, how much will you have accumulated by the end of 30 years?Assume monthly compounding.

Subjects