please i need help with question 1 using excel and the formulas to get the answers

1. Stock Pricing (20 points) Copper Communications has just paid a dividend of $2.97 and is projected to pay a dividend of $3.11 in the upcoming year. a. Determine the annual rate of growth in dividends between year 0 and year 1 b. Suppose you can earn 13% on alternative investments with similar risk. If the company's dividend grows at this rate indefinitely, what is the most you would be willing to pay per share for this company...? c. If the firm's dividends were expected to grow at previous rates for three years, and then be the same for the indefinite future (ie, zero growth), what is the most you would be willing to pay per share? Assume the same discount rate. 2. Retirement Savings (20 points) You plan to retire in exactly 22 years. a. Suppose you save $500 per month. Assume that your account earns interest monthly at an 8.0% annual rate, compounded monthly. How 2