Please provide formulas for empty cells, thank you!

You plan to purchase 100 shares of EXCO today, and sell them 12 years from today when your child enters college Calculate the estimated purchase price, sales price, and capital gain or transaction. The firm pays an annual dividend What are the amounts of the 12 annual didends you receive on all shares owned during the 12 years you own this stock Dividends are received at the end of each year Most recent al udend per share Required Rate of Retum Years Sale Share Purchased Purchase ale commision tees per 100 shares (roundio The most recent annual share udends are as follows 2290 70 12 100 8.50 245 250 256 2,80 270 2.00 DIV1 OV 2 DIV DIV 4 DIV 5 DIVO DIV> DIVO DIVO DW 10 DIV 11 DIV 12 Calculate the assumed compounding growth rate Chint above Calculate the first har dend you receive (1) What is the total cost of the purchase including commission tres What was the Holding Period Relum on sale What was the GEOMETRIC annualized rate What was the ARITHMETIC annualized rate Calculate the assumed to her commissions fees) Calculate the first dend the newer ICON et sales price What is the Capital Gain on the mastiment when sold Given the dende pad over the years as calculated above, what was the Total Return for this restent in dolar terms? ID Total Returns You plan to purchase 100 shares of EXCO today, and sell them 12 years from today when your child enters college Calculate the estimated purchase price, sales price, and capital gain or transaction. The firm pays an annual dividend What are the amounts of the 12 annual didends you receive on all shares owned during the 12 years you own this stock Dividends are received at the end of each year Most recent al udend per share Required Rate of Retum Years Sale Share Purchased Purchase ale commision tees per 100 shares (roundio The most recent annual share udends are as follows 2290 70 12 100 8.50 245 250 256 2,80 270 2.00 DIV1 OV 2 DIV DIV 4 DIV 5 DIVO DIV> DIVO DIVO DW 10 DIV 11 DIV 12 Calculate the assumed compounding growth rate Chint above Calculate the first har dend you receive (1) What is the total cost of the purchase including commission tres What was the Holding Period Relum on sale What was the GEOMETRIC annualized rate What was the ARITHMETIC annualized rate Calculate the assumed to her commissions fees) Calculate the first dend the newer ICON et sales price What is the Capital Gain on the mastiment when sold Given the dende pad over the years as calculated above, what was the Total Return for this restent in dolar terms? ID Total Returns