Part A-Drill Complete the following calculations on a single excel worksheet using financial functions. Label each answer on the worksheet and submit the worksheet to the dropbox named according to our naming convention. No assumptions for flexibility are required-these are just drill exercises, not business problem. Just generate an excel function that can solve the problem. 1) How much would you have in 40 years if you deposited $10,000 today and earned 7% annual interest compounded annually? 2) How much would you have in 25 years if you deposited $5,000 today and earned 9% annual interest compounded monthly? 3) How much would you have to deposit today in order to have $1,000,000 in 25 years if you could earn 12% interest? Assume annual compounding. 4) How much would you be willing to pay today for the right to receive $1,000 at the end of every year for the next 20 years if your discount rate is 8%? 5) You deposit $100 at the beginning of each month for the next 10 years. The annual rate of return is 5%, compounded monthly. How much do you have at the end of the 10 years? 6) A potential investment earns $500,000 during its first year, $300,000 during its second year, $100,000 during its third year nothing during its fourth year and $20,000 in its fifth year and final year. What is the most you would be willing to pay today to invest in this project if your required rate of return is 15%? 7) What is the monthly payment on a $250,000, 30 year mortgage if the annual interest rate is 3.25%? B) You repay a $8,000 loan with 6.5% annual interest by making monthly payments of $100 at end of each month. How many payments will you have to make to pay off the loan? 9) Don Corleone offers to loan you $500 today. All you have to do is repay him $100 at end of each year for the next 10 yeaks. What annual rate of interest is Don charging you