Please answer the questions in excel formula.

L|E@_Ll\"|"" |;| ILI El. \":5\" \"io'iiiil Paste V B 1' u v 53353; v {1); v A 7 Alignment Number Conditional Format as C3\" Cells Editing 7 _ v v Formatting ' Table ' Styles ' - . Clipboard FT- Font f?- Styles A A1 v fr V woo-Amm-h Metallica Bearings, Inc., is a young start-up company. No dividends will be paid on the stock over the next nine years because the rm needs to plow back its earnings to fuel growth. The company will pay a $14 per share dividend 10 years from today and will increase the dividend by 3.9 percent per year thereafter. If the required return on this stock is 12.5 percent, what is the current share price? Future dividend Years until first dividend Dividend growth rate Required return Complete the following analysis. Do not hard code values in your calculations. Stock price in 9 years Stock price today _ db . . ' _ E .,.. BEE,MAA l;l Iii WHEW , , , ' Conditional Format as Cell -- Paste \\'f B I Q v _ 5) A Align'ment Number Formatting . Table' Styles' Cells Editing Clipboard F: Font n Styles A a A B c D E F G H I J K 1 A Maloney, Inc., has an odd dividend policy. The company has just paid a dividend of $3.50 per 3 share and has announced that it will increase the dividend by $4.50 per share for each of the next five years, and then never pay another dividend. If you require a return of 11 percent on the company's stock, how much will you pay for a share today? 4 5 6 Current dividend 7 Dividend growth 8 Required return 9 10 11 Complete the following analysis. Do not hard code values in your calculations. 12 13 Year Dividend 14 1 15 2 16 3 17 4 18 5 19 20 Share price 21