Stan is going to work for the next 30 years and then retire. Starting the day...

Stan is going to work for the next 30 years and then retire. Starting the day he retires, he would like to withdraw $90,000 per year (in monthly installments) from an investment account for a twenty-five year retirement. At the end of his retirement, he would like to leave a bequest of $100,000 to his heirs. He currently has $10,000 in his investment account for these purposes. Stan plans to save for retirement by making monthly deposits into the investment account, beginning two years from now and ending the month before he retires. The investment account pays 9 percent compounded monthly. Construct a flexible spreadsheet model to answer the following questions:

1. How much must Stan invest each month to accomplish his retirement goals?

2. If Stan's employer will contribute $0.50 for every $1.00 he invests, how much of the deposit in #1 will Stan have to contribute?

Inputs:
	Years to retirement
	Length of retirement (in years)
	Years until the first deposit
	Desired annual retirement income
	Desired bequest to his heirs
	Amount already invested
	Annual interest rate
	Compounding periods per year

Ouputs:
	At retirement:
	Value of retirement income:
	Value of bequest:
	Total needed at retirement
	Funds available at retirement
	Additional Funds needed

1.	Required monthly payment

2.	Stan's contribution
	Company contribution
	Total

Expert Solution


Inputs:
	Years to retirement	30
	Length of retirement (in years)	25
	Years until the first deposit	2
	Desired annual retirement income	$90,000
	Desired bequest to his heirs	$100,000
	Amount already invested	$10,000
	Annual interest rate	9%
	Compounding periods per year	12
Ouputs:
	At retirement:
	Value of retirement income:	$900,415	(Using PV Function of excel with Rate=(9/12)%,Nper=(25*12),Pmt=(90000/12),Type=1)
	Value of bequest:	$10,629	(Using PV Function of excel with Rate=(9/12)%,Nper=(25*12),Fv=100000)
	Total needed at retirement	$911,044	(900415+10629)
	Funds available at retirement	$147,306	(Using FV Function of excel with Rate=(9/12)%,Nper=(30*12),Pv=-10000)
	Additional Funds needed	$763,738	(911044-147306)

1	Required monthly payment	$502.59	(Using PMT Function of excel with Rate=(9/12)%,Nper=((30-2)*12),Fv=763738,Type=1)

2	Stan's contribution	$335.06	(2/3)*502.59)
	Company contribution	$167.53	(1/3)*502.59)
	Total	$502.59	(335.06+167.53)

jeff jeffy answered 4 weeks ago

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

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.

you will work for 40 years then you will retire. when yiu retire, you will make...

you will work for 40 years then you will retire. when yiu retire, you will make the first of 40 annual investments of $7549 in a fund. the fund is expected to return 9.9% per year, how much will you have on the day that you make your last deposit?

Please show the work: Current book value per share is $30. For the next three years,...

Please show the work: Current book value per share is $30. For the next three years, the net income and dividends paid per share are shown in the table below. Compute the ending book value and residual income for each of the three years. The required rate of return on equity is 11%. The share price at the end of year 3 will be 2.5 times the book value at that time. Year 1 Year 2 Year 3 Net Income...

A woman plans to retire in 40 years, and she expects to live for 30 years...

A woman plans to retire in 40 years, and she expects to live for 30 years after that. She wants to spend 10,000 a month after she retires. To finance her retirement she is going to invest monthly (with her investment one month from know) over 40 years at 12.6%. After she retires she will move her investment to a more liquid account earning 7.2% a year. Ignore taxes and transaction costs. How much does she have to sabe a...

You are 30 years old and want to retire at the age of age 65 and...

You are 30 years old and want to retire at the age of age 65 and expect to live another 25 years. On the day you retire, you want to have $900,000 in your retirement savings account. a) If you invest monthly starting one month from today and your investment earns 6.0 percent per year, How much money do you need to invest every month until you retire? b) You're retired with $900,000 and you have 25 more years. You...

You plan to retire in 30 years. Beginning in 31 years from now you wish to...

You plan to retire in 30 years. Beginning in 31 years from now you wish to have an annual retirement income of $80,000 / year as measured in today’s dollars. The inflation rate is assumed to be 2.5%. Each year in retirement you wish to have your retirement income grow by 3% per year. You plan on living for 35 years in retirement. Starting in one year from now you are going to make annual deposits into a savings account....

You are 40 years old and want to retire at age 65. Each year, starting one...

You are 40 years old and want to retire at age 65. Each year, starting one year from now, you will deposit an equal amount into an investment account that pays 4% interest. The last deposit will be on your 65th birthday. On your 65th birthday, you will switch the accumulated savings into a safer bank account that pays only 4.2% interest. You will withdraw your annual income of $110,000 at the end of that year (on your 66th birthday)...

You are 40 years old and want to retire at age 60. Each year, starting one...

You are 40 years old and want to retire at age 60. Each year, starting one year from now, you will deposit an equal amount into an investment account that pays 4.6% interest. The last deposit will be on your 60th birthday. On your 60th birthday, you will switch the accumulated savings into a safer bank account that pays only 4.2% interest. You will withdraw your annual income of $130,000 at the end of that year (on your 61st birthday)...

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)?

Question