Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. Start Excel. Download and open the workbook named: Berk_DeMarzo_Harford_Problem_2-9_Start.

In cell D11, by using cell references, calculate the growth rate in revenues for 2016.

To calculate the growth rate in revenues for 2017-2019, copy cell D11 and paste it onto cells E11:G11.

In cell D16, by using cell references, calculate the growth rate in net income for 2016.

To calculate the growth rate in net income for 2017-2019, copy cell D16 and paste it onto cells E16:G16.

Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

See the table far below showing financial statement data and stock price data for Mydeco Corp. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. a. By what percentage did Mydeco's revenues grow each year from 2016-2019? b. By what percentage did net income grow each year? a. By what percentage did Mydeco's revenues grow each year from 2016-2019? Growth rate in revenues b. By what percentage did net income grow each year? Growth rate in net income 2015-2019 Financial Statement Data and Stock Price Data for Mydeco Corp. 15_on10 Financial Statamont Data and Starl Prico Mata for Mvdarn Corn B \begin{tabular}{|l|l|lll|} D & E & F & G & H \\ \hline 245.3 & 243.3 & 309.0 & 345.6 & 347.0 \\ 361.7 & 361.7 & 361.7 & 361.7 & 361.7 \\ \hline 778.1 & 774.6 & 855.2 & 893.4 & 915.1 \end{tabular} Liabilities \& Stockholders' Equity Accounts Payable Accrued Compensation Total Current Liabilities Long-term Debt Total Liabilities Stockholders' Equity Total Liabilities \& Stockholders' \begin{tabular}{rrrrr} 18.7 & 17.9 & 22.0 & 26.8 & 31.7 \\ 6.7 & 6.4 & 7.0 & 8.1 & 9.7 \\ \hline 25.4 & 24.3 & 29.0 & 34.9 & 41.4 \\ 500.0 & 500.0 & 575.0 & 600.0 & 600.0 \\ \hline 525.4 & 524.3 & 604.0 & 634.9 & 641.4 \\ 252.7 & 250.3 & 251.2 & 258.5 & 273.7 \\ \hline 778.1 & 774.6 & 855.2 & 893.4 & 915.1 \end{tabular} Equity \begin{tabular}{lccccc} Statement of Cash Flows & 2015 & 2016 & 2017 & 2018 & 2019 \\ \hline Net Income & 18.0 & 3.0 & 6.3 & 12.7 & 21.7 \\ Depreciation \& Amortization & 27.3 & 27.0 & 34.3 & 38.4 & 38.6 \\ Chg. in Accounts Receivable & 3.9 & 18.8 & 0.0 & (7.1) & (9.2) \\ Chg. in Inventory & (2.9) & 2.8 & 2.5 & (3.3) & (3.6) \\ Chg. in Payables \& Accrued Comp. & 2.2 & (1.1) & 4.7 & 5.9 & 6.5 \\ \hline Cash from Operations & 48.5 & 50.5 & 47.8 & 46.6 & 54.0 \\ Capital Expenditures & (25.0) & (25.0) & (100.0) & (75.0) & (40.0) \\ \hline Cash from Investing Activities & (25.0) & (25.0) & (100.0) & (75.0) & (40.0) \\ Dividends Paid & (5.4) & (5.4) & (5.4) & (5.4) & (6.5) \\ Sale (or Purchase) of Stock & 0.0 & 0.0 & 0.0 & 0.0 & 0.0 \\ Debt Issuance (Pay Down) & 0.0 & 0.0 & 75.0 & 25.0 & 0.0 \\ \hline Cash from Financing Activities & (5.4) & (5.4) & 69.6 & 19.6 & (6.5) \\ Change in Cash & 18.1 & 20.1 & 17.4 & (8.8) & 7.5 \\ Mydeco Stock Price & $7.92 & $3.30 & $5.25 & $8.71 & $10.89 \end{tabular}