complete the problem by using excel formulas

A B D \begin{tabular}{ll|l} G & H & I \end{tabular} \begin{tabular}{ll|l} \hline & J & L \end{tabular} N P.18: Price/earning ratio (LO2) Botos facial Care had earmings after taxes of $370,000 in 201 with 200,000 shares of stock outstanding. The stock price was $31.50 in 202, earnings after taxes increased to $436,000 with the same 200,000 shares outstanding. The stock price was $42.00. a. Compute earnings per share and the P/E ratio for 2001; (The P/E ratio equals the stock price divided by earnings per share). b. Compute earnings per share and the P/E ratio for 20x2. c. Give a goneral explanation of why the P/E ratio changed. 1 2 3 Given: 4 (5) 6 7 a) b) c). Percent Change = ChangerOnginal e.g.. (Price2-Price 1) Price 1 P-19. Price/earning ratio (to2) Stilley Corporation had earnings after taxes of \$436,000 in 2002 with 200,000 shares outstanding The stock prike was 542.00 . in 203, earnings after taxes declined to $206,000 with the same 200,000 shares outstandine. The stock price decines to $27,80. a. Compuse earnings per share and the P/E ratio for 202. b. Compute earnings per share and the P/E ratio for 203. c. Give a ceneral explanation of why the P/E changed; (You might want to conwult the tentbook to eaplain this surpraing result). 8