Part II Historical Analysis
This part represents the historical analysis of your firm.
a. Statement of cash flows
You will write up an analysis of the statement of cash flows where you will explain ona year-by-year basis.
(1) Where did the firm's operating funds come from?
(2) On what did the firm spend its funds?
(3) Where did they get their financing and what did they pay off?
(4) What was the overall change in cash?
Please try to bring in the relevant information about the events that had significant effect on the
cash inflows and out flows during the four-year period. Please make sure that you conduct and
extensive analysis of the past event like mergers and divestitures, etc. and discuss the effects of
such events on cash flows. BELOW IS THE EXCEL TABLE FOR SCOTTS MIRACLE GROW. THANKS
D 1 SCOTTS MIRACLE-GROCO 2 STATEMENT OF FINANCIAL POSITION TICKER SYMBOL: 2007 SIG 2009 PRIMARY SIC CODE: 2010 2011 2870 2012 2008 2013 2014 2015 2016 4 ASSETS Cash & Equivalents 6 Receivables - Total (Net) 7 Inventaries - Total 8 Prepaid Expenses Current Assets - Other 10 Current Assets - Total 67.900 397.800 405.900 .000 127.700 999.300 84.700 71.600 406.400 401.300 415.900 458.900 .000 .000 137.900 159.100 1,044.900 1.090.900 89.100 423.700 403,600 .000 121.200 1,037.600 130.900 340.400 387.000 .000 134.200 992.500 131.900 344.300 414.900 .000 108.900 1,000.000 129.800 326.200 324.900 .000 100,100 881.000 89.300 350.400 385.100 .000 110.200 935.000 71.400 | 355.400 407.600 .000 114.200 948.600 50,100 388.800 448.200 .000 104.600 991.700 12 Plail, Property & Fquip (Gross) 13 Accumulated Depreciation 14 Plant. Property & Equip (Net) 784 700 418.800 365.900 804.700 460.600 344.100 862.000 492.300 369.700 890,700 495.900 394.800 905.200 510.500 394.700 970.000 542.600 427.400 995.700 573.400 422.300 1,034.200 597.200 437.000 1,066.600 612.900 453.700 1,104.100 633.300 470.800 16 Investments at Equity 17 Investments and Advances - Other 18 Intangibles 19 Deferred Charges 20 Assets - Other 21 TOTAL ASSETS .000 .000 881.700 .000 30.300 2.277.200 .000 .000 744.900 .000 22.400 2,156.300 .000 .000 .000 .000 739.400 703.000 .000 .000 20100 28.600 2.220.100 2.164.000 .000 .000 628.700 .000 36.300 2.052.200 .000 .000 616.500 .000 30.500 2,074.400 .000 .000 599.500 .000 34 400 1.937.200 .000 .000 653.600 .000 32.700 2,058.300 .000 .000 1,095.900 .000 29.000 2,527.200 101.000 90.000 1,124.100 16.700 14.500 2,808.800 23 LIABILITIES 24 Accounts Payable Notes Payable Accrued Expenses 27 Taxes Payable 28 Debt (Long-Term) Die In One Year 29 Oxher Current Liabilities 30 Total Current Liabilities 31 32 Long Term Debt 33 Deferred Taxes (Balance Sheet) 34 Investment Tax Credit Minority Interest 36 Liabilities - Other 37 TOTAL LIABILITIES 202.500 .000 286.800 10.900 86.400 .000 586.600 207.600 .000 314.200 6.300 150,000 .000 678.100 190.000 .000 279.200 .000 160400 127.200 756.800 153.100 .000 249.600 .000 195.000 126.200 723.900 150.000 .000 170.700 .000 3.200 144.700 468.600 152.300 .000 191.400 .000 1.500 88.400 433.600 137.700 85.300 169.600 .000 7.100 110.100 509.800 193.300 84.000 143.100 .000 7.900 116.400 544.700 197.900 122.300 133.000 .000 12.500 147.400 613.100 165.900 .000 138.400 .000 185.000 103.800 593.100 1,031.400 67.900 .000 112.000 .000 1,797.900 849.500 42.600 .000 149.400 .000 1,719.600 649.700 49.600 .000 179.500 .000 1.635.600 436.700 63.000 .000 175.900 .000 1,399.500 791.800 65.200 .000 166.800 .000 1,492.400 781.100 71.600 .000 186.200 .000 1,472.500 478.100 96.200 .000 142.600 .000 1.226.700 692.400 120.400 .000 133.600 13.500 1,504.600 1,028.500 125.400 .000 127.100 12.400 1,906.500 1,131.100 219.100 .000 131.200 19.100 2,093.600 .000 39 SHAREHOLDERS EQUITY 40 Preferred Stock 41 Common Stock 42 Capital Surplus 43 Retained Earnings (Net Other) 44 Tess; Treasury Stock 45 TOTAL SHAREHOLDERS EQUITY .000 .300 480.000 218.500 219.500 479.300 .000 .300 472.100 149.600 18.5.300 436.700 .000 300 451.200 264.700 131.700 584.500 .000 .300 433.700 422.500 92.000 764.500 .300 426,800 521.200 388.500 559.800 .000 .300 408.300 542.900 349.600 601.900 .000 300 397.200 625.600 312.600 710.500 .000 .300 395.000 550.700 392.300 553.700 .000 300 400. 100 577.400 357.100 620.700 .000 .300 401.400 764.900 451.400 715.200 47 TOTAL LIABILITIES AND EQUITY 2277.200 2.156.300 2220100 2.164.000 1052.200 2.074.400 1937.200 2.058.300 2.527200 2,808.800
