subject
Business, 28.05.2021 14:00 mariahdixon80

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?

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 06:10
Information on gerken power co., is shown below. assume the company’s tax rate is 40 percent. debt: 9,400 8.4 percent coupon bonds outstanding, $1,000 par value, 21 years to maturity, selling for 100.5 percent of par; the bonds make semiannual payments. common stock: 219,000 shares outstanding, selling for $83.90 per share; beta is 1.24. preferred stock: 12,900 shares of 5.95 percent preferred stock outstanding, currently selling for $97.10 per share. market: 7.2 percent market risk premium and 5 percent risk-free rate. required: calculate the company's wacc. (do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) wacc %
Answers: 2
question
Business, 22.06.2019 20:20
Digitalhealth electronics inc. is a company that builds diagnostic devices. it was the first company to develop a compact mri scanner by reconfiguring the components of the mri technology. this smaller and user-friendly version of the huge mri scanner created demand from small hospitals, nursing homes, and private practice doctors who were earlier dependent on the scanning machines in large hospitals. which of the following types of innovations does this scenario best illustrate? a. disruptive innovation b. incremental innovation c. radical innovation d. architectural innovation
Answers: 3
question
Business, 23.06.2019 00:30
Dr. hughes enjoys offering to employees who perform over and above the call of duty
Answers: 1
question
Business, 23.06.2019 02:30
Driving would be more pleasant if we didn't have to put up with the bad habits of other drivers. a newspaper reported the results of a valvoline oil company survey of 500 drivers in which the drivers marked their complaints about other drivers. the top complaints turned out to be tailgating, marked by 24% of the respondents; not using turn signals, marked by 19%; being cut off, marked by 15%; other drivers driving too slowly, marked by 12%; and other drivers being inconsiderate marked by 5%.
Answers: 1
You know the right answer?
Stan is going to work for the next 30 years and then retire. Starting the day he retires, he would l...
Questions
question
Business, 30.11.2020 22:10
question
Mathematics, 30.11.2020 22:10