need help with formula and excel spreadsheet

Use this handout as your coversheet after filling in the blanks with values you make-up and attaching whatever spreadsheets you generate when solving the problems below. 6. What is the present value of an annuity due which pays $ per year for 10 years if a 12% discount rate is used? 7. How much would you have to pay today for a 25-year annuity paying $45,000 annually if it begins 15 years from now and you want a. return? 8. If you want a % return, what is the most you should pay today for a stock that will trade at $75 in 5 years and pay a $2 annual dividend? 9. If you paid $750 for an investment years ago that is now worth $2000, what was your rate of return? 10. If you save $100 per month, what annual rate of interest must you earn in order to accumulate $10,000 after years? Use this handout as your coversheet after filling in the blanks with values you make-up and attaching whatever spreadsheets you generate when solving the problems below. 6. What is the present value of an annuity due which pays $ per year for 10 years if a 12% discount rate is used? 7. How much would you have to pay today for a 25-year annuity paying $45,000 annually if it begins 15 years from now and you want a. return? 8. If you want a % return, what is the most you should pay today for a stock that will trade at $75 in 5 years and pay a $2 annual dividend? 9. If you paid $750 for an investment years ago that is now worth $2000, what was your rate of return? 10. If you save $100 per month, what annual rate of interest must you earn in order to accumulate $10,000 after years