M 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 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).xlsx Previous File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do K14Xf 4 A B C D E 1 Assignment 2 - Time Value of Money F H LIMIN 3 4 1. If you inherited $45,000 today and invested all of it in a security that paid a 7% rate of return how much would you have in 25 years? 6 Use EXCEL and solve below. 10 2. If the average new home costs $275,000 today, how much will it cost in 10 years 11 if the price increases by 5% each year? 12 13 Use EXCEL and solve below. 14 15 16 17 3. You think that in 15 years it will cost $214,000 to provide your child with a 4-year 18 collge education. Will you have enough if you take $75,000 toady and invest it for 19 15 years at 4%? 20 21 Use EXCEL and solve below 22 How much will you have in 15 years? 24 Will you have enough? 25 27 4. If you can earn 4%, how much will you have to save each year if you want to retire 28 in 35 years with $1,000,000? 29 30 Use EXCEL and solve below