M N O P Week Two Financial Exercises Part 1 Complete the following problems using either the financial functions in Excel or the Present Value and Fature Value formulas as noted below: PY = F 1/(1+1R F PV *(1+0* (1) If you wish to have $42.000 in 10 years, how much do you need to deposit in the bank today if the account pays an interest rate of 7%? (2) What will $10,000 grow to be in 11 years if it is invested today at 9%? You would like to have $120,000 in a college fund in 10 years. How much do you need today if you expect to cam 12% while you are investing to pay for your child's college? You have been offered $3.500 (in 5 years from now) for providing $2,000 today into a business venture with a friend. If interest rates are 10%, what is the future value of the original $2,0007