Please use EXCEL to solve the problems below. Note: Please give the procedure functions. No function, no score. 1. (40 Points) An investment will provide you with $100 at the end of each year for the next 10 years. a. What is the present value of that annuity if the discount rate is 8% annually? b. What is the present value of the above if the payments are received at the beginning of each year? c. If you deposit those payments into an account earning 8%, what will the future value be in 10 years? d. What will the future value be if you open the account with $1,000 today, and then make the $100 deposits at the end of each year? 2. (20 Points) a. Suppose Big D, Inc., just paid a dividend of S0.50 per share. It is expected to increase its dividend by 2% per year. If the market requires a return of 15% on assets of this risk, how much should the stock be selling for? b. Suppose Moore Oil Inc., is expected to pay a $2 dividend in one year. If the dividend is expected to grow at 5% per year and the required return is 20%, what is the price