Hello, can I get help? I have filled out some but will need the rest as well as in excel.

Problem 12-9A Condensed financial data of Odgers Inc. follow. ODGERS INC. Comparative Balance Sheets December 31 Assets Cash 2014 2013 $ 145,440 $ 87,120 Accounts receivable 158,040 68,400 Inventory 202,500 185,130 Prepaid expenses 51,120 46,800 Long-term investments 248,400 196,200 Plant assets 513,000 436,500 Accumulated depreciation (90,000 ) (93,600 ) Total $1,228,500 $926,550 $ 183,600 $ 121,140 29,700 37,800 Bonds payable 198,000 262,800 Common stock 396,000 315,000 Liabilities and Stockholders' Equity Accounts payable Accrued expenses payable Retained earnings Total 421,200 189,810 $1,228,500 $926,550 ODGERS INC. Income Statement Data For the Year Ended December 31, 2014 Sales revenue $699,228 Less: Cost of goods sold $243,828 Operating expenses, excluding depreciation 22,338 Depreciation expense 83,700 Income tax expense 49,104 Interest expense Loss on disposal of plant assets Net income 8,514 13,500 420,984 $ 278,244 Additional information: 1. New plant assets costing $180,000 were purchased for cash during the year. Old plant assets having an original cost of $103,500 and accumulated depreciation of 2. $87,300 were sold for $2,700 cash. 3. Bonds payable matured and were paid off at face value for cash. 4. A cash dividend of $46,854 was declared and paid during the year. Prepare a statement of cash flows using the indirect method. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).) ODGERS INC. Statement of Cash Flows For the Year Ended December 31, 2014 Cash Flow s from Operating Activities $ Net Income 278244 Adjustments to reconcile net income to Net Cash Provided by Operating Activities $ Decrease in Accrued Expenses Payable Increase in Inventory Increase in Accounts Receivable Depreciation Expense Loss on Disposal of Plant Assets Increase in Prepaid Expenses Increase in Accounts Payable Net Cash Provided by Operating Activities Cash Flow s from Investing Activities Purchase of Investments Purchase of Plant Assets Sale of Plant Assets Net Cash used by Investing Activities Net Cash used by Investing Activities Cash Flow s from Financing Activities Redemption of Bonds Sale of Common Stock Payment of Cash Dividends Net Cash used by Financing Activities Net Increase in Cash Cash at Beginning of Period $ Cash at End of Period LINK TO TEXT Problem 12-10A Condensed financial data of Odgers Inc. follow. ODGERS INC. Comparative Balance Sheets December 31 Assets 2014 Cash 2013 $ 112,312 $ 67,276 Accounts receivable 122,042 52,820 Inventory 156,375 142,962 39,476 36,140 Long-term investments 191,820 151,510 Plant assets 396,150 337,075 Accumulated depreciation (69,500 ) (72,280 ) Prepaid expenses Total $948,675 $715,503 $ 141,780 $ 93,547 Liabilities and Stockholders' Equity Accounts payable Accrued expenses payable 22,935 29,190 Bonds payable 152,900 202,940 Common stock 305,800 243,250 Retained earnings Total 325,260 146,576 $948,675 $715,503 ODGERS INC. Income Statement Data For the Year Ended December 31, 2014 Sales revenue $539,959 Less: Cost of goods sold $188,289 Operating expenses, excluding depreciation 17,250 Depreciation expense 64,635 Income taxes 37,919 Interest expense Loss on disposal of plant assets Net income 6,575 10,425 325,093 $ 214,866 Additional information: 1. New plant assets costing $139,000 were purchased for cash during the year. Old plant assets having an original cost of $79,925 and accumulated depreciation of $67,415 were 2. sold for $2,085 cash. 3. Bonds payable matured and were paid off at face value for cash. 4. A cash dividend of $36,182 was declared and paid during the year. Further analysis reveals that accounts payable pertain to merchandise creditors. Prepare a statement of cash flows for Odgers Inc. using the direct method. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).) ODGERS INC. Statement of Cash Flows For the Year Ended December 31, 2014 Cash Flow s from Operating Activities $ Cash Receipts from Customers Less : Cash Payments $ To Suppliers For Income Taxes For Operating Expenses For Interest Net Cash Provided by Operating Activities Cash Flow s from Investing Activities Sale of Plant Assets Purchase of Plant Assets Purchase of Investments Net Cash used by Investing Activities Cash Flow s from Financing Activities Sale of Common Stock Payment of Cash Dividends Redemption of Bonds Net Cash used by Financing Activities Net Cash used by Financing Activities Net Increase in Cash Cash at Beginning of Period $ Cash at End of Period SHOW SOLUTION LINK TO TEXT Problem 13-2A The comparative statements of Osborne Company are presented here. OSBORNE COMPANY Income Statements For the Years Ended December 31 2014 Net sales Cost of goods sold Gross profit Selling and administrative expenses Income from operations 2013 $1,894,562 1,062,562 832,000 504,022 327,978 $1,754,522 1,010,022 744,500 483,022 261,478 23,957 304,021 93,957 $ 210,064 21,957 239,521 74,957 $ 164,564 Other expenses and losses Interest expense Income before income taxes Income tax expense Net income OSBORNE COMPANY Balance Sheets December 31 Assets 2014 2013 Current assets Cash Debt investments (short-term) Accounts receivable Inventory Total current assets Plant assets (net) Total assets $ 60,100 74,000 121,822 127,957 383,879 662,700 $1,046,579 $ 64,200 50,000 106,822 117,457 338,479 534,000 $872,479 $ 164,022 45,457 209,479 233,700 443,179 $149,422 43,957 193,379 213,700 407,079 290,000 313,400 603,400 $1,046,579 300,000 165,400 465,400 $872,479 Liabilities and Stockholders' Equity Current liabilities Accounts payable Income taxes payable Total current liabilities Bonds payable Total liabilities Stockholders' equity Common stock ($5 par) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity All sales were on account. Net cash provided by operating activities for 2014 was $227,420. Capital expenditures were $136,370, and cash dividends were $62,064. Compute the following ratios for 2014. (Round all answers to 2 decimal places, e.g. 1.83 or 12.61%.) $ (a) Earnings per share (b) Return on common stockholders' equity % (c) Return on assets % (d) Current ratio :1 (e) Accounts receivable turnover times (f) Average collection period days (g) Inventory turnover times (h) Days in inventory days (i) Times interest earned times (j) Asset turnover times (k) Debt to assets % (l) Current cash debt coverage times (m) Cash debt coverage times $ (n) Free cash flow SHOW SOLUTION LINK TO TEXT LINK TO VIDEO Broadening Your Perspective 13-2 The financial statements of The Hershey Company and Tootsie Roll are presented below. THE HERSHEY COMPANY CONSOLIDATED STATEMENTS OF INCOME For the years ended December 31, In thousands of dollars except per share amounts Net Sales Costs and Expenses: Cost of sales Selling, marketing and administrative Business realignment and impairment (credits) 2011 2010 2009 $6,080,788 $5,671,009 $5,298,668 3,548,896 1,477,750 3,255,801 1,426,477 3,245,531 1,208,672 83,433 82,875 5,025,760 1,055,028 92,183 962,845 333,883 $628,962 4,765,711 905,298 96,434 808,864 299,065 $509,799 4,537,078 761,590 90,459 671,131 235,137 $435,994 $2.58 $2.08 $1.77 $2.56 $2.07 $1.77 $2.85 $2.29 $1.97 (886) charges, net Total costs and expenses Income before Interest and Income Taxes Interest expense, net Income before Income Taxes Provision for income taxes Net Income Net Income Per ShareBasicClass B Common Stock Net Income Per ShareDilutedClass B Common Stock Net Income Per ShareBasicCommon Stock Net Income Per ShareDilutedCommon $2.74 $2.21 $1.90 Stock Cash Dividends Paid Per Share: Common Stock $1.3800 $1.2800 $1.1900 Class B Common Stock 1.2500 1.1600 1.0712 The notes to consolidated financial statements are an integral part of these statements and are included in the Hershey's 2011 Annual Report, available at www.thehersheycompany.com. THE HERSHEY COMPANY CONSOLIDATED BALANCE SHEETS December 31, In thousands of dollars ASSETS Current Assets: Cash and cash equivalents Accounts receivabletrade Inventories Deferred income taxes Prepaid expenses and other Total current assets Property, Plant and Equipment, Net Goodwill Other Intangibles Deferred Income Taxes Other Assets Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: Accounts payable Accrued liabilities Accrued income taxes Short-term debt Current portion of long-term debt Total current liabilities Long-term Debt Other Long-term Liabilities Total liabilities Commitments and Contingencies Stockholders' Equity: The Hershey Company Stockholders' Equity Preferred Stock, shares issued: none in 2011 and 2010 Common Stock, shares issued: 299,269,702 in 2011 and 2011 2010 $693,686 399,499 648,953 136,861 167,559 2,046,558 1,559,717 516,745 111,913 38,544 138,722 $4,412,199 $884,642 390,061 533,622 55,760 141,132 2,005,217 1,437,702 524,134 123,080 21,387 161,212 $4,272,732 $420,017 612,186 1,899 42,080 97,593 1,173,775 1,748,500 617,276 3,539,551 $410,655 593,308 9,402 24,088 261,392 1,298,845 1,541,825 494,461 3,335,131 299,269 299,195 60,632 60,706 490,817 4,699,597 434,865 4,374,718 (4,258,962) (4,052,101) (442,331) 849,022 23,626 872,648 $4,412,199 (215,067) 902,316 35,285 937,601 $4,272,732 299,195,325 in 2010 Class B Common Stock, shares issued: 60,632,042 in 2011 and 60,706,419 in 2010 Additional paid-in capital Retained earnings TreasuryCommon Stock shares, at cost: 134,695,826 in 2011 and 132,871,512 in 2010 Accumulated other comprehensive loss The Hershey Company stockholders' equity Noncontrolling interests in subsidiaries Total stockholders' equity Total liabilities and stockholders'equity THE HERSHEY COMPANY CONSOLIDATED STATEMENTS OF CASH FLOWS For the years ended December 31, In thousands of dollars Cash Flows Provided from (Used by) Operating Activities Net income Adjustments to reconcile net income to net cash provided from operations: Depreciation and amortization Stock-based compensation expense, net of tax of $15,127, $17,413 and $19,223, respectively Excess tax benefits from stock-based compensation Deferred income taxes Gain on sale of trademark licensing rights, net of tax of 2011 2010 $628,962 $509,799 $435,994 215,763 197,116 182,411 28,341 32,055 34,927 (13,997) 33,611 (1,385) (18,654) (4,455) (40,578) (11,072) 2009 60,823 $5,962 Business realignment and impairment charges, net of 30,838 77,935 tax of $18,333, $20,635 and $38,308, respectively Contributions to pension plans Changes in assets and liabilities, net of effects from (8,861) (6,073) business acquisitions and divestitures: Accounts receivabletrade Inventories Accounts payable Other assets and liabilities Net Cash Provided from Operating Activities Cash Flows Provided from (Used by) Investing (9,438) (115,331) 7,860 (205,809) 580,867 20,329 (13,910) 90,434 13,777 901,423 Activities Capital additions Capitalized software additions Proceeds from sales of property, plant and equipment Proceeds from sales of trademark licensing rights Business acquisitions Net Cash (Used by) Investing Activities Cash Flows Provided from (Used by) Financing (323,961) (23,606) 312 20,000 (5,750) (333,005) (179,538) (21,949) 2,201 (199,286) (126,324) (19,146) 10,364 (15,220) (150,326) Activities Net change in short-term borrowings Long-term borrowings Repayment of long-term debt Proceeds from lease financing agreement Cash dividends paid Exercise of stock options Excess tax benefits from stock-based compensation Contributions from noncontrolling interests in 10,834 249,126 (256,189) 47,601 (304,083) 184,411 13,997 1,156 348,208 (71,548) (283,434) 92,033 1,385 (458,047) (8,252) (263,403) 28,318 4,455 subsidiaries Repurchase of Common Stock Net Cash (Used by) Financing Activities (Decrease) Increase in Cash and Cash Equivalents Cash and Cash Equivalents as of January 1 (384,515) (438,818) (190,956) 884,642 10,199 (169,099) (71,100) 631,037 253,605 (54,457) 46,584 74,000 37,228 293,272 1,065,749 7,322 (9,314) (698,921) 216,502 37,103 Cash and Cash Equivalents as of December 31 Interest Paid Income Taxes Paid $693,686 $884,642 $253,605 $97,892 292,315 $97,932 350,948 $91,623 252,230 TOOTSIE ROLL INDUSTRIES, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF Earnings, Comprehensive Earnings and Retained Earnings (in thousands except per share data) Net product sales Rental and royalty revenue Total revenue Product cost of goods sold Rental and royalty cost Total costs Product gross margin Rental and royalty gross margin Total gross margin Selling, marketing and administrative expenses Impairment charges Earnings from operations Other income (expense), net Earnings before income taxes Provision for income taxes Net earnings Net earnings Other comprehensive earnings (loss) Comprehensive earnings Retained earnings at beginning of year. Net earnings Cash dividends Stock dividends Retained earnings at end of year Earnings per share Average Common and Class B Common shares For the year ended December 31, 2011 2010 2009 $528,369 $517,149 $495,592 4,136 4,299 3,739 532,505 521,448 499,331 365,225 349,334 319,775 1,038 1,088 852 366,263 350,422 320,627 163,144 167,815 175,817 3,098 3,211 2,887 166,242 171,026 178,704 108,276 106,316 103,755 14,000 57,966 64,710 60,949 2,946 8,358 2,100 60,912 73,068 63,049 16,974 20,005 9,892 $43,938 $53,063 $53,157 $43,938 $53,063 $53,157 (8,740) 1,183 2,845 $35,198 $54,246 $56,002 $135,866 $147,687 $144,949 43,938 53,063 53,157 (18,360) (18,078) (17,790) (47,175) (46,806) (32,629) $114,269 $135,866 $147,687 $0.76 $0.90 $0.89 57,892 outstanding (The accompanying notes are an integral part of these statements.) 58,685 59,425 CONSOLIDATED STATEMENTS OF Financial Position TOOTSIE ROLL INDUSTRIES, INC. AND SUBSIDIARIES (in thousands except per share data) Assets December 31, 2011 CURRENT ASSETS: Cash and cash equivalents Investments Accounts receivable trade, less allowances of $1,731 and $1,531 Other receivables Inventories: Finished goods and work-in-process Raw materials and supplies Prepaid expenses Deferred income taxes Total current assets PROPERTY, PLANT AND EQUIPMENT, at cost: Land Buildings Machinery and equipment Construction in progress LessAccumulated depreciation Net property, plant and equipment OTHER ASSETS: Goodwill Trademarks Investments Split dollar officer life insurance Prepaid expenses Equity method investment Deferred income taxes Total other assets Total assets Liabilities and Shareholders' Equity CURRENT LIABILITIES: Accounts payable Dividends payable Accrued liabilities Total current liabilities NONCURRENT LIABILITES: Deferred income taxes Postretirement health care and life insurance benefits Industrial development bonds Liability for uncertain tax positions Deferred compensation and other liabilities Total noncurrent liabilities SHAREHOLDERS' EQUITY: Common stock, $.69-4/9 par value120,000 shares authorized 2010 $78,612 10,895 41,895 3,391 $115,976 7,996 37,394 9,961 42,676 29,084 5,070 578 212,201 35,416 21,236 6,499 689 235,167 21,939 107,567 322,993 2,598 455,097 242,935 212,162 21,696 102,934 307,178 9,243 440,974 225,482 215,492 73,237 175,024 96,161 74,209 3,212 3,935 7,715 433,493 $857,856 73,237 175,024 64,461 74,441 6,680 4,254 9,203 407,300 $857,959 December 31, 2011 2010 $10,683 4,603 43,069 58,355 $9,791 4,529 44,185 58,505 43,521 26,108 7,500 8,345 48,092 133,566 47,865 20,689 7,500 9,835 46,157 132,046 25,333 25,040 14,601 14,212 533,677 114,269 (19,953) 505,495 135,866 (11,213) 36,479 and 36,057 respectively, issued Class B common stock, $.69-4/9 par value40,000 shares authorized 21,025 and 20,466 respectively, issued Capital in excess of par value Retained earnings, per accompanying statement Accumulated other comprehensive loss Treasury stock (at cost)71 shares and 69 shares, respectively Total shareholders' equity Total liabilities and shareholders' equity (1,992) 665,935 $857,856 (1,992) 667,408 $857,959 TOOTSIE ROLL INDUSTRIES, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF Cash Flows (in thousands) For the year ended December 31, 2011 CASH FLOWS FROM OPERATING ACTIVITIES: Net earnings Adjustments to reconcile net earnings to net cash 2010 2009 $43,938 $53,063 $53,157 19,229 194 1,267 18,279 342 522 17,862 14,000 4,400 233 320 (5,448) 3,963 (15,631) 5,106 84 (5,772) 2,022 2,146 (708) 50,390 717 (2,373) (1,447) 4,936 2,180 2,322 1,429 2,525 310 82,805 (5,899) (2,088) 455 5,203 (2,755) (12,543) 1,384 2,960 305 76,994 (16,351) (3,234) (39,252) 7,680 (51,157) (12,813) (2,902) (9,301) 8,208 (16,808) (20,831) (1,713) (11,331) 17,511 (16,364) (18,190) (18,407) (36,597) (22,881) (18,130) (41,011) (20,723) (17,825) (38,548) Increase (decrease) in cash and cash equivalents (37,364) 24,986 22,082 Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year 115,976 $78,612 90,990 $115,976 68,908 $90,990 Supplemental cash flow information Income taxes paid $16,906 Interest paid $38 Stock dividend issued $47,053 (The accompanying notes are an integral part of these statements.) $20,586 $49 $46,683 $22,364 $182 $32,538 provided by operating activities: Depreciation Impairment charges Impairment of equity method investment Loss from equity method investment Amortization of marketable security premiums Changes in operating assets and liabilities: Accounts receivable Other receivables Inventories Prepaid expenses and other assets Accounts payable and accrued liabilities Income taxes payable and deferred Postretirement health care and life insurance benefits Deferred compensation and other liabilities Others Net cash provided by operating activities CASH FLOWS FROM INVESTING ACTIVITIES: Capital expenditures Net purchase of trading securities Purchase of available for sale securities Sale and maturity of available for sale securities Net cash used in investing activities CASH FLOWS FROM FINANCING ACTIVITIES: Shares repurchased and retired Dividends paid in cash Net cash used in financing activities Based on the information in the financial statements, determine each of the following for each company: The percentage increase (i) in net sales and (ii) in net income from 2010 to 2011. (Round answers to 1 decimal places, e.g. 15.2%. Enter negative amounts using either a negative sign preceding the number e.g. -15.2% or parentheses e.g. (15.2)%.) Hershey Tootsie Roll Percentage increase (decrease) in net sales % % Percentage increase (decrease) in net income % % SHOW SOLUTION The percentage increase (i) in total assets and (ii) in total stockholders' equity from 2010 to 2011. (Round answers to 1 decimal place, e.g. 15.2%. Enter negative amounts using either a negative sign preceding the number e.g. -15.2% or parentheses e.g. (15.2)%.) Hershey Tootsie Roll Percentage increase (decrease) in total assets % % Percentage increase (decrease) in total stockholders' % % equity SHOW SOLUTION The earnings per share for 2011. (Round answers to 2 decimal places, e.g. 15.25.) Hershey Tootsie Roll Earnings per share Question Attempts: 0 of 3 used