Our first assignment is on Time Value of Money. This will be due Tuesday, February 11 at 11:59pm. This is worth 30 points. Your assignment must be submitted in Excel with all relevant financial formulas. Zero credit for answers that are not calculated with the correct Excel financial formula. The Excel files embedded in the Powerpoints as well as the Excel file posted on Canvas should be helpful. Remember to include a heading at the top of your spreadsheet explaining what this spreadsheet is all about - so facts like course name, assignment name, date, and your name would be appropriate. The heading is a graded element of this assignment. All rules of academic integrity apply to this and all work in this course. 1) George expects to inherited $1,000,000 when his grandfather passes away. George expects his grandfather to live 13 more years and George uses a 4% discount rate. What is the present value of the $1,000,000 inheritance? Also, calculate for a 7% and 10% discount rate. 2) Zeinab won a lawsuit that will pay her $250,000 today and another $300,000 in five years. Zeinab plans to invest the money in an account that earns 6% annually. What is the future value in 15 years of the money Zeinab has won in the lawsuit? 3) Jenny wants to retire in 35 years. To do this she plans to save $5,000 a year starting today. How much will Jenny have in her retirement account in 35 years, assuming a 5% annual investment return. Also, calculate assuming a 7% annual return and a 9% annual return. 4) U.S, Savings bonds purchased for $25 are guaranteed to double in value 20 years. What is the interest rate that will result in a doubling of the bond in 20 years? 5) Juan won a lottery jackpot and received $300,000 after taxes. If Juan wants to retire with $1,000,000. How long will it take for Juan to have $1,000,000 if his investments earn 7% annually? Also, calculate how long it will take if the investment earn 9% and 15%