Please complete this spreadsheet with the correct answers.


Question Description:

30

May 21, 2016. Please complete this spreadsheet with the correct answers. ATTACHMENT PREVIEW Download attachment 2 pages Problem 13-2a Comparative Statements.docx *Problem 13-2A The comparative statements of Osborne Company are presented here. OSBORNE COMPANY Income Statements For the Years Ended December 31 2014 2013 Net sales $1,895,855 $1,755,815 Cost of goods sold 1,063,855 1,011,315 Gross profit 832,000 744,500 Selling and administrative 505,315 484,315 expenses Income from operations 326,685 260,185 Other expenses and losses Interest expense 23,416 21,416 Income before income taxes 303,269 238,769 Income tax expense 93,416 74,416 Net income $ 209,853 $ 164,353 OSBORNE COMPANY Balance Sheets December 31 2014 Assets Current assets Cash Debt investments (short-term) Accounts receivable Inventory Total current assets Plant assets (net) Total assets 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 2013 $ 60,100 $ 64,200 74,000 50,000 123,115 108,115 127,416 116,916 384,631 339,231 661,217 532,517 $1,045,848 $871,748 $ 165,315 $150,715 44,916 43,416 210,231 194,131 232,217 212,217 442,448 406,348 290,000 313,400 603,400 300,000 165,400 465,400 $1,045,848 $871,748 All sales were on account. Net cash provided by operating activities for 2014 was $222,980. Capital expenditures were $136,200, and cash dividends were $61,853. Compute the following ratios for 2014. (Round all answers to 2 decimal places, e.g. 1.83 or 12.61%.) (a) Earnings per share Return on common (b) stockholders ’ equity (c) Return on assets (d) Current ratio Accounts (e) receivable turnover Average (f) collection period (g) Inventory turnover (h) Days in inventory Times (i) interest earned (j) Asset turnover (k) Debt to assets Current (l) cash debt coverage (m) Cash debt coverage (n) Free cash flow Question Attempts: 0 of 3 used Read more TangeliaM
posted a question · May 20, 2016 at 11:35pm

Answer

30