Please see attached excel file. Thank you for your help!

Problem 2-20 See the table far below showing financial statement data and stock price data for Corp. a. From 2009 to 2013, what was the total cash flow from operations that Mydec b. Compare capital expenditures with cash flow from operations as a percentage c. What fraction of the total in (a) was spent paying dividends to shareholders? d. What was Mydeco's total retained earnings for this period? a. From 2009 to 2013, what was the total cash flow from operations that Mydec Cash flow from operations (million) b. Compare capital expenditures with cash flow from operations as a percentage Capital expenditures (million) Capital expenditures/cash flow from operations c. What fraction of the total in (a) was spent paying dividends to shareholders? Dividends (million) Dividends/cash flow from operations d. What was Mydeco's total retained earnings for this period? Total net income (million) Total retained earnings (million) 2009-2013 Financial Statement Data and Stock Price Data for Mydeco C (All data as of fiscal year end; $ in millions) Income Statement 2009 2010 Revenue 404.3 363.8 Cost of goods sold - 188.3 - 173.8 Gross profit 216.0 190.0 Sales and marketing - 66.7 - 66.4 Administration - 60.6 - 59.1 Depreciation & amortization - 27.3 - 27.0 EBIT 61.4 37.5 Interest income (expense) Pretax income Income tax Net income Shares outstanding (millions) Earnings per share - 33.7 - 32.9 27.7 4.6 9.7 1.6 18.0 3.0 55 55 $ 0.33 $ 0.05 Balance Sheet Assets Cash Accounts receivable Inventory Total current assets Net property, plant & equip. Goodwill & intangibles Total Liabilities & Stockholders' Equity Accounts payable Accrued compensation Current liabilities Long-term debt Total liabilities Stockholders' equity Total 2009 Statement of Cash Flows Net income Depreciation & amortization Change in accounts receivable Change in inventory Chg. in payables & accrued comp Cash from operations Capital expenditures Cash from investing activities Dividends paid Sale (or purchase) of stock Debt issuance (pay down) Cash from financing activities Change in cash - - - 2010 48.8 88.6 33.7 171.1 245.3 361.7 778.1 68.9 69.8 30.9 169.6 243.3 361.7 774.6 18.7 6.7 25.4 500 525.4 252.7 778.1 17.9 6.4 24.3 500 524.3 250.3 774.6 2009 18.0 27.3 3.9 2.9 2.2 48.5 25.0 25.0 5.4 5.4 18.1 2010 3.0 27.0 18.8 2.8 1.1 50.5 25.0 25.0 5.4 5.4 20.1 - - Mydeco stock price $ 7.92 $ 3.30 Requirements 1. You will calculate the total cash flow from operations by using the function S E12, by using the function SUM and cell references, calculate the total cash operations (1 pt.). 2. You will calculate the total capital expenditures by using the function SUM. by using the function SUM and cell references, calculate the total capital exp pt.). 3. 4. In cell E17, by using cell references, calculate the capital expenditures/cash f operations ratio (1 pt.). You will calculate the total dividends by using the function SUM. In cell E21 function SUM and cell references, calculate the total dividends (1 pt.). 5. In cell E22, by using cell references, calculate the fraction of the total cash fl operations that was spent in dividends (1 pt.). 6. You will calculate the total net income by using the function SUM. In cell E2 the function SUM and cell references, calculate the total net income (1 pt.). 7. In cell E27, by using cell references, calculate the total retained earnings (1 p and stock price data for Mydeco m operations that Mydeco generated? erations as a percentage. dends to shareholders? riod? m operations that Mydeco generated? erations as a percentage. dends to shareholders? riod? ice Data for Mydeco Corp. - 2011 424.6 206.2 218.4 82.8 59.4 34.3 41.9 - 2012 510.7 246.8 263.9 102.1 66.4 38.4 57.0 - 2013 604.1 293.4 310.7 120.8 78.5 38.6 72.8 - 32.2 9.7 3.4 6.3 55 $ 0.11 $ 37.4 39.4 19.6 33.4 6.9 11.7 12.7 21.7 55 55 0.23 $ 0.39 2011 2012 86.3 69.8 28.4 184.5 309.0 361.7 855.2 77.5 76.9 31.7 186.1 345.6 361.7 893.4 85.0 86.1 35.3 206.4 347.0 361.7 915.1 22 7 29 575 604 251.2 855.2 26.8 8.1 34.9 600 634.9 258.5 893.4 31.7 9.7 41.4 600 641.4 273.7 915.1 2011 6.3 34.3 2.5 4.7 47.8 - 100.0 - 100.0 5.4 75.0 69.6 17.4 2012 12.7 38.4 7.1 3.3 5.9 46.6 75.0 75.0 5.4 25.0 19.6 8.8 2013 21.7 38.6 9.2 3.6 6.5 54.0 40.0 40.0 6.5 6.5 7.5 - - - 2013 - - - $ 5.25 $ 8.71 $ 10.89 by using the function SUM. In cell calculate the total cash flow from ing the function SUM. In cell E16, late the total capital expenditures (1 pital expenditures/cash flow from nction SUM. In cell E21, by using the dividends (1 pt.). ction of the total cash flow from unction SUM. In cell E26, by using otal net income (1 pt.). al retained earnings (1 pt.)