Question

In: Finance

BUSI 320 Problem#3 (Decision #2) Decision #2: Planning for Retirement Mike and Joy are 25, newly...

BUSI 320 Problem#3 (Decision #2)

Decision #2: Planning for Retirement

Mike and Joy are 25, newly married, and ready to embark on the journey of life. They both plan to retire 45 years from today. Because their budget seems tight right now, they had been thinking that they would wait at least 10 years and then start investing $2400 per year to prepare for retirement. Joy just told Mike, though, that she had heard that they would actually have more money the day they retire if they put $2400 per year away for the next 10 years - and then simply let that money sit for the next 35 years without any additional payments - than they would have if they waited 10 years to start investing for retirement and then made yearly payments for 35 years (as they originally planned to do).  

Please help Mike and Joy make an informed decision:   

Assume that all payments are made at the end of a year, and that the rate of return on all yearly investments will be 7.2% annually.

  1. How much money will Mike and Joy have in 45 years if they do nothing for the next 10 years, then puts $2400 per year away for the remaining 35 years?
  1. How much money will Mike and Joy have in 10 years if they put $2400 per year away for the next 10 years?

b2) How much will the amount you just computed grow to if it remains invested for the remaining 35 years, but without any additional yearly deposits being made?

  1. How much money will Mike and Joy have in 45 years if they put $2400 per year away for each of the next 45 years?
  1. How much money will Mike and Joy have in 45 years if they put away $200 per MONTH at the end of each month for the next 45 years? (Remember to adjust the 7.2% annual rate to a Rate per month!) (Round this rate per month to 5 places past the decimal)   Example of rounding: .062134 = .06213 or 6.213%
  1. If Mike and Joy wait 25 years (after the kids are raised!) before they put anything away for retirement, how much will they have to put away at the end of each year for 20 years in order to have $800,000 saved up on the first day of their retirement 45 years from today?

Solutions

Expert Solution

Amount Invested per year = P = $2400

Rate of Interest = r = 7.2%

(a) Investment made from Year 11 to Year 45 = $2400

=> Value in Account = P(1+r)34 + .... + P(1+r)2 + P(1+r) + P = P[(1+r)35 -1]/r = 2400[(1+0.072)35 -1]/0.072 = $346590.23

(b) Amount Saved for first 10 years = $2400

Value of savings after 10 years = P(1+r)9 + .... + P(1+r)2 + P(1+r) + P = P[(1+r)10 -1]/r = 2400[(1+0.072)10 -1]/0.072 = $33474.37

(b-2) Value of this amount at Year 45 = 33474.38*(1+r)35 = $381531.17

(c) Amount invested each year for 45 years = $2700

Value in account after 45 years = P(1+r)44 + .... + P(1+r)2 + P(1+r) + P = P[(1+r)45 -1]/r = 2400[(1+0.072)45 -1]/0.072 = $728121.39

(d) Amount invested each month P = $200

Number of months = 45*12 = 540

Interest Rate = r = 0.072/12

Value after 45 years = P(1+r)539 + .... + P(1+r)2 + P(1+r) + P = P[(1+r)540 -1]/r = 200[(1+0.072/12)540 -1]/(0.072/12) = $809590.50

(f) Let the amount saved each year for 20 years be X

Value in 25 years = $800000

=> 800000 = P(1+r)19 + .... + P(1+r)2 + P(1+r) + P = P[(1+r)20 -1]/r = X[(1+0.072)20 -1]/0.072

=> X = 800000/[[(1+0.072)25 -1]/0.072] = 800000/41.90 = $19092.17


Related Solutions

BUSI 320 Comprehensive Problem 3 Spring 2020 Decision #2: Planning for Retirement Todd and Jessalyn are...
BUSI 320 Comprehensive Problem 3 Spring 2020 Decision #2: Planning for Retirement Todd and Jessalyn are 25, newly married, and ready to embark on the journey of life.   They both plan to retire 45 years from today. Because their budget seems tight right now, they had been thinking that they would wait at least 10 years and then start investing $2400 per year to prepare for retirement. Jessalyn just told Todd, though, that she had heard that they would actually...
Decision #2:  Planning for Retirement Todd and Jessalyn are 25, newly married, and ready to embark on...
Decision #2:  Planning for Retirement Todd and Jessalyn are 25, newly married, and ready to embark on the journey of life.   They both plan to retire 45 years from today.  Because their budget seems tight right now, they had been thinking that they would wait at least 10 years and then start investing $2400 per year to prepare for retirement.   Jessalyn just told Todd, though, that she had heard that they would actually have more money the day they retire if they put $2400...
Decision #2: Planning for Retirement Todd and Jessalyn are 25, newly married, and ready to embark...
Decision #2: Planning for Retirement Todd and Jessalyn are 25, newly married, and ready to embark on the journey of life.   They both plan to retire 45 years from today. Because their budget seems tight right now, they had been thinking that they would wait at least 10 years and then start investing $2400 per year to prepare for retirement. Jessalyn just told Todd, though, that she had heard that they would actually have more money the day they retire...
Decision #2: Planning for Retirement Todd and Jessalyn are 25, newly married, and ready to embark...
Decision #2: Planning for Retirement Todd and Jessalyn are 25, newly married, and ready to embark on the journey of life.   They both plan to retire 45 years from today. Because their budget seems tight right now, they had been thinking that they would wait at least 10 years and then start investing $2400 per year to prepare for retirement. Jessalyn just told Todd, though, that she had heard that they would actually have more money the day they retire...
Decision #2: Planning for Retirement Erich and Mallory are 22, newly married, and ready to embark...
Decision #2: Planning for Retirement Erich and Mallory are 22, newly married, and ready to embark on the journey of life.   They both plan to retire 45 years from today. Because their budget seems tight right now, they had been thinking that they would wait at least 10 years and then start investing $1800 per year to prepare for retirement. Mallory just told Erich, though, that she had heard that they would actually have more money the day they retire...
Decision #2: Planning for Retirement Erich and Mallory are 22, newly married, and ready to embark...
Decision #2: Planning for Retirement Erich and Mallory are 22, newly married, and ready to embark on the journey of life.   They both plan to retire 45 years from today. Because their budget seems tight right now, they had been thinking that they would wait at least 10 years and then start investing $3000 per year to prepare for retirement. Mallory just told Erich, though, that she had heard that they would actually have more money the day they retire...
Decision #2: Planning for Retirement Erich and Mallory are 22, newly married, and ready to embark...
Decision #2: Planning for Retirement Erich and Mallory are 22, newly married, and ready to embark on the journey of life.   They both plan to retire 45 years from today. Because their budget seems tight right now, they had been thinking that they would wait at least 10 years and then start investing $3000 per year to prepare for retirement. Mallory just told Erich, though, that she had heard that they would actually have more money the day they retire...
Decision #2: Planning for Retirement Erich and Mallory are 22, newly married, and ready to embark...
Decision #2: Planning for Retirement Erich and Mallory are 22, newly married, and ready to embark on the journey of life.   They both plan to retire 45 years from today. Because their budget seems tight right now, they had been thinking that they would wait at least 10 years and then start investing $3000 per year to prepare for retirement. Mallory just told Erich, though, that she had heard that they would actually have more money the day they retire...
BUSI 320 Comprehensive Problem 3 Spring 2020 *If you could show how you got the answers...
BUSI 320 Comprehensive Problem 3 Spring 2020 *If you could show how you got the answers using EXCEL that would be awesome!* Thanks! Use what you have learned about the time value of money to analyze each of the following decisions: Decision #1:   Which set of Cash Flows is worth more now? Assume that your grandmother wants to give you generous gift. She wants you to choose which one of the following sets of cash flows you would like to...
BUSI 320 Comprehensive Problem 2 Spring 2020 You have been asked to assess the expected financial...
BUSI 320 Comprehensive Problem 2 Spring 2020 You have been asked to assess the expected financial impact of each of the following proposals to improve the profitability of credit sales made by your company. Each proposal is independent of the other. Answer all questions. Showing your work may earn you partial credit. Proposal #1 would extend trade credit to some customers that previously have been denied credit because they were considered poor risks. Sales are projected to increase by $200,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT