Complete the problems using Excel formula. Show all work (display all the variables used in your formulas, and/or detail all steps used in determining the calculation)

1. How much must you invest at 7% interest to see your investment grow to $15,000 in 9 years?

2. To save for her newborn son's college education, Lea Wilson will invest $7,000 at the beginning of each year for the next 17 years. The interest rate is 8 percent. What is the future value?

3. A 10-year bond, with a par value equaling $1,000, pays 7% annually. If similar bonds are currently yielding 6% annually, what is the market value of the bond? Use semi-annual analysis.