W Y M Der Associate _45_19 > Assignments > Time Value of Money Exercise Time Value of Money Exercise Submit Assignment Due Tuesday by 11:59pm Points 100 Submitting a file upload upload Please complete the Time Value of Money exercise which is attached below. Complete the assignment in Excel, and then upload your excel document here. Be precise in your answers and make sure they are clearly listed and readable in your spreadsheet. You should use the excel formulas to determine the answers. Assignment Week 2 - Time Value of Money (1 Previous File Home insert Page Layout Formulas Data Review View H elp Tell me what you want to do A17 X 3 . You think that in 15 years it will cost $214,000 to provide your child with a 4-year 30 Use EXCEL and solve below. 31 32 34 5. Jamal Doran wishes to have $800,000 in a retirement fund 20 years from now. 35 He can create the retirement fund by making a single mp-sum deposit today. 36 Assume the fund pays 4% 37 How much must Jamal deposit today to have $800,000 in 20 years? 39 Use EXCEL and solve below. 10 43 6. If you pay $10,000 a year into your retirement savings plan each year beginning today. 44 Your account pays 5% interest 45 How much will you have in 30 years? 46 47 Use EXCEL and solve below