Cash Flow Statement Analysis 4. Relying on the figures of Mydeco Corp. prepare a common-size analysis of the company's statement of cash flows and fill in the table below. Mydeco Corp. Common-Size Cash Flow Statement: Indirect Format Percentage of Revenue in 2009 2010 2011 2012 2013 Cash flow from operating activities: Net Income Depreciation & Amortization Chg. in Accounts Receivable Chg. in Inventory Chg. in Payables & Accrued Comp. Net cash provided by operating activities Cash flow from investing activities: Capital Expenditures Net cash used for investing activities Cash flow from financing activities: Dividends Paid Sale (or purchase) of stock Debt Issuance (Pay Down) Net cash used for financing activities Change in Cash Summary: Problems 53 TABLE 2.5 2009-2013 Financial Statement Data and Stock Price Data for Mydeco Corp (59.1) Mydeco Corp. 2009-2013 Income Statement Revenue Cost of Goods Sold Grou Profit Sales and Marketing Administration Depreciation & Amortization EBIT Interest Income (E) Pretax Income Income Tax Net Income Shares attending millions Farming pershan (All data as of fiscal year end; in 5 million) 2009 2010 2011 2012 2013 10-13 363.8 4246 510.7 6021 (1883) (173.8) (2062) (246,8) 293.4) 2160 190.0 218.4 263.9 310.7 (66.7) (664) (102.1) (1208) (60.6 (59.4) (66,4) (78.5) (273) (27.0) (363) 38.6 (386) 61.4 37.5 41.9 57.0 72.8 (38.7 (322) (374 (9.4) 277 9.7 196 33.4 (9.7 (16) (3.4) (6.9) (11.7) 18.0 3.0 12.7 21.7 55.0 55.0 55.0 55.0 55.0 SO.33 50.05 $0.11 $0.23 $0.39 1.6 Balance Sheet 2009 2010 2011 2012 2013 863 77.5 850 68.9 69.8 69.8 48,8 88.6 33.7 1711 245,3 30.9 169.6 2433 3617 774.6 28.4 184.5 300 361.7 8552 76.9 31.7 186.1 345.6 86.1 353 206.4 147.0 361.7 915.1 361.7 3617 7781 893.4 Assets Cash Accounts Receivable Inventory Total Current Assets Net Property Plant & Equip Goodwill & Intangibles Total Assets Lighline Stockholders' Equity Accounts Payable Accrued Compensation Total Current Liabilities Long-term Debt Total Liabilities Stockholders' Equity Total Liabilities & Stockholders' Equity 179 31.7 9.7 6.4 414 18.7 6.7 25.4 500.0 525.4 2527 778.1 24.3 500.0 5243 22.0 7.0 29.0 575.0 6040 251-2 855.2 26.8 8.1 34.9 6000 634.9 258,5 893.4 250.3 600.0 641.4 273.7 915.1 7746 Statement of Cash Flows 2009 2010 2011 2012 63 18.0 273 39 (2.9) 22 3.0 270 18.8 2.8 (1.1) 50.5 (25.0) (25.0) (54) Net Income Depreciation & Amortization Chg, in Accounts Receivable Chg in Inventory Chg, in Payables & Accrued Comp. Cash from Operations Capital Expenditur Cash from Investing Activities Dividends Paid Sale for purchase) of stock Debt Issuance (Pay Down) Cash from Financing Activities Change in Cash Myde Stock 12.7 38.4 (7.1) (3.3) 59 46.6 3443 (0.0) 25 4.7 47.8 (1000) (100.0) (5.4) 2013 21.7 386 19.2) 3.6) 65 54.0 (10,0) (400) 48.3 (25.0) (25.0) (54) 05.01 (7.5.0) (5.4) 75.0 25.0 19.6 (5.1) (5.4) 69.6 16.59 20.1 18.1 $792 17.4 $5.25 (8.8) $8.77 75 $10.89 30
