Please use excel formulas for solutions when you show your work

A B D E F G H K 7 8 9 10 11 12 Most recent annual dividend per share: Required Rate of Return: Years until Sale: Shares Purchased: Purchase/Sale commision & fees per 100 shares (round lot') 5.00 5.0% 12 250 10.00 13 14 15 16 The most recent 6 annual p/share dividends are 17 18 3.75 3.50 2.00 4.00 4.50 5.00 19 20 21 22 23 Calculate the assumed compounding growth rate 24 25 Calculate the first p/share dividend you'll receive (D1) 101 26 27 What is the total cost of this purchase? 28 29 30 Calculate the assumed net sales price (after commissions & fees): 31 32 Calculate the first dividend the new owner will receive: Net sales price 33 34 35 36 What is the Capital Gain on the investment when sold: A B D E F G H K 7 8 9 10 11 12 Most recent annual dividend per share: Required Rate of Return: Years until Sale: Shares Purchased: Purchase/Sale commision & fees per 100 shares (round lot') 5.00 5.0% 12 250 10.00 13 14 15 16 The most recent 6 annual p/share dividends are 17 18 3.75 3.50 2.00 4.00 4.50 5.00 19 20 21 22 23 Calculate the assumed compounding growth rate 24 25 Calculate the first p/share dividend you'll receive (D1) 101 26 27 What is the total cost of this purchase? 28 29 30 Calculate the assumed net sales price (after commissions & fees): 31 32 Calculate the first dividend the new owner will receive: Net sales price 33 34 35 36 What is the Capital Gain on the investment when sold