Question

In: Finance

Decision #2: Planning for Retirement *If you could show how you got the answers using EXCEL...

Decision #2: Planning for Retirement

*If you could show how you got the answers using EXCEL that would be great!* Thanks!

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 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 Todd and Jessalyn 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 8.4% annually.

  1. How much money will Todd and Jessalyn 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 Todd and Jessalyn 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 Todd and Jessalyn have in 45 years if they put $2400 per year away for each of the next 45 years?
  1. How much money will Todd and Jessalyn 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 8.4% 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 Todd and Jessalyn 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 $1,000,000 saved up on the first day of their retirement 45 years from today?

Solutions

Expert Solution

­

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE


Related Solutions

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...
Please show how you got the answers so that I can learn how to do this!...
Please show how you got the answers so that I can learn how to do this! 200.00mL of 2.00 M solution of a weak acid is mixed with 300.00 mL of a 2.00 M solution containing its conjugate base. 50.000 g of the slightly soluble salt silver acetate (AgC2H3O2) is added to this buffer solution. After thorough mixing, the solution is assumed to be saturated. To determine the amount of the solid which remains undissolved, the solution is filtered, and...
2.    Costs are in hours/unit output. PLEASE SHOW ALL WORK/HOW YOU GOT YOUR ANSWERS. Table 2...
2.    Costs are in hours/unit output. PLEASE SHOW ALL WORK/HOW YOU GOT YOUR ANSWERS. Table 2 Watches Rings U.S. 4 2 U.K. 2 1 a.    In which good does the U.S. and the U.K. have an absolute advantage? How can you tell?                                 U.S. ____________________                     U.K. ____________________     b.    Fill in the opportunity cost of producing watches and rings in each country?         U.S.                Watches__________ Rings___________              U.K.       Watches___________ Rings___________ c.     In which good does the U.S. and the U.K. have...
Using excel and show formulas You are planning to purchase a house that costs $480,000. You...
Using excel and show formulas You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Base scenario (#1): Use function “PMT” to calculate your mortgage payment. Scenario #2: Use function “PV” to calculate the loan amount given a payment of $1,500 per month. What is the most that you can borrow? Based on that...
DO NOT SOLVE USING EXCEL. You are doing some long-range retirement planning. On the day you...
DO NOT SOLVE USING EXCEL. You are doing some long-range retirement planning. On the day you retire (23 years from now) you want to be able to withdraw $200,000. Then, you want to withdraw the following amounts at the end of each year after that (during your retirement period). Years 1-4 $160,000 Years 5-9 $175,000 Years 10-15 $165,000 Years 16-26 $145,000 At the end of the 26th year in retirement, you’d like to have $500,000 remaining in your retirement account...
***PLEASE USE EXCEL AND SHOW FORMULAS**** Barry and Samantha are starting to take their retirement planning...
***PLEASE USE EXCEL AND SHOW FORMULAS**** Barry and Samantha are starting to take their retirement planning seriously. They are both 46 and plan to retire in 20 years at the age of 66. They expect to live 20 years in retirement (a life expectancy of 86). Between their 401k and IRA accounts they currently have $84,295 in retirement savings. They currently have a combined income of $80,000 per year and expect to be able to live comfortably in retirement with...
Can you put this in excel and show the formulas of how you're getting the answers...
Can you put this in excel and show the formulas of how you're getting the answers please! Hi-Tek Manufacturing Inc. makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown below: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,718,000 Cost of goods sold 1,220,369 Gross margin 497,631 Selling and administrative expenses 650,000 Net operating loss $ (152,369) Hi-Tek produced and sold 60,300 units of B300 at a...
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...
Show work and explain how you got your answer, do not just post an excel spreadsheet...
Show work and explain how you got your answer, do not just post an excel spreadsheet with answers please. You are deciding between two mutually exclusive investment opportunities. Both require the same initial investment of $ 10.3 million. Investment A will generate $ 2.18 million per year​ (starting at the end of the first​ year) in perpetuity. Investment B will generate $ 1.51 million at the end of the first​ year, and its revenues will grow at 2.2 % per...
Please solve all answers on Excel and show step by step how you get the WACC...
Please solve all answers on Excel and show step by step how you get the WACC answer.   Tornado Motors is a major producer of sport and utility trucks. It is a family owned company, started by Jane Biscayne in 1935, at the height of the Great Depression. Today the firm produces 3 lines of trucks. These include a standard, no-frills short bed pickup truck (Model A), a mid-size version (Model B ) and a larger, heavy-duty work truck (Model C)....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT