Concept explainers
(a) Current ratio
Inventory Turnover: It is a part of efficiency ratios used during the process of ratio analysis. It reflects the number of times a company’s inventory is converted into sale during a particular period. The cost of goods sold is divided by average inventory to get the value of inventory turnover.
Profit Margin: Profit margin reflects the portion of net income in the net sales. It is a profitability measure tool that is used to evaluate the net income a business earns on every dollar of net sales. It is computed as net income divided by net revenue.
Return on Total Assets: It is a measure to evaluate the efficiency of company’s assets. It reports the profit earned as the percentage of total assets used in the business. A company’s
The rate of Return on Common
Debt to Assets Ratio: It is the ratio between total assets of the company and the total liabilities. Debt ratio reflects the finance strategy of the company. It is used to evaluate company’s ability to pay its debts. Higher debt ratio implies the higher financial risk.
Times Interest Earned Ratio: It’s a measure to evaluate the net income for interest payment on the debt of a company. It is a part of solvency ratios.
To compute: Current ratio for 2016 and 2017.
(b)
To compute: Inventory turnover
(c)
To compute: Profit margin
(d)
To compute: Return on assets
(e)
To compute: Return on common stockholder’s equity
(f)
To compute: Debt to assets ratio
(g)
To compute: Times interest earned
Want to see the full answer?
Check out a sample textbook solutionChapter 14 Solutions
Managerial Accounting: Tools for Business Decision Making
- The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. Open the file CASHFLOW from the website for this book at cengagebrain.com. First, enter the formulas. Then, complete the worksheet in the manner described next. According to the problem, cash increased from 39,600 to 67,210 during the year. This is a 27,610 increase. To record this increase on the worksheet, move to row 17. Since this is the first account you are analyzing, enter the letter a in column C. Then enter 27610 in column D (a debit since cash increased). This brings the year-end balance (column G) to 67,210, its proper balance. Now move to the bottom part of the statement where you see the categories Operating Activities, Investing Activities, and so on. The credit side of the entry has to be entered here. The proper space for this cash entry is on row 59. Enter the letter a in cell E59 and 27610 in cell F59. Notice the totals at the bottom of the page (row 60) now agree. The next account balance that changed is accounts receivable. It increased by 9,035. To enter this change on the worksheet, enter the letter b in cell C18 and 9035 in cell D18 (again, a debit since accounts receivable increased). This brings the year-end balance in column G to 121,250, its proper balance. The change in accounts receivable balance is an operating activity adjustment (as explained in your textbook). Enter the credit side of this entry in cells E34 and F34, and enter the explanation Increase in accounts receivable in cell A34. Note: Your textbook probably shows Net income as the first item under Operating Activities. We will get to that later. The sequence in which you enter items on this worksheet is not important. All other balance sheet accounts must be analyzed in the same manner, placing appropriate debit or credit entries in the top part of the worksheet to obtain the proper balances in column G, and then entering the second side of the entry in the appropriate row on the bottom part of the worksheet. You should use letter references to identify all entries. Also, you must enter a description of the entry in column A under the appropriate activity category. Although a sequence of analyzing the balance sheet from top to bottom is suggested here, this order is not necessary. As mentioned earlier, your textbook may specify a different sequence. Also, note that some accounts may have both debit and credit adjustments to them. The worksheet is not a substitute for a statement of cash flows, but it does provide you with all the numbers you need to properly prepare one. You will be done with your analysis when: a. The individual account balances at December 31, 2013, as shown on the worksheet (column G) equal those shown in the given problem data. b. The transaction column totals are equal (cells D60 and F60). c. The sum of the operating, investing, and financing activities (cell G59) equals the change in cash (cell D59 or F59). When you are finished, enter your name in cell A1. Save your completed file as CASHFLOW2. Print the worksheet when done. Also print your formulas. Check figure: Total credits at 12/31/2013 (cell G31), 860,460.arrow_forwardMahoney Company has the following financial statements for 2017 and 2018. Assume that the purchase of equipment and the withdrawals were in the form of cash. Required Prepare a statement of cash flows for the year ended December 31, 2018. Check Figure Net cash flows from operating activities, 76,800arrow_forwardThe comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. You have been asked to prepare a statement of cash flows for Prime Sports Gear for 2013. Review the worksheet called CASHFLOW that has been provided to assist you in preparing the statement. The worksheet has been designed so that as you make entries in columns D and F, column G will be automatically updated. For example, FORMULA1 should be entered as =B17+D17F17. Columns C and E are to be used to enter letter references for each of the debit and credit entries on the worksheet.arrow_forward
- Partial balance sheets and additional information are listed below for Funk Company. Funk Company Partial Balance Sheets as of December 31 2018 2017 Assets Cash $ 42,000 $ 21,000 Accounts receivable 95,000 90,800 Inventory 26,000 42,000 Liabilities Accounts payable $ 59,000 $ 74,000 Additional information for 2018: Net income was $172,000.Depreciation expense was $32,000.Sales totaled $820,000.Cost of goods sold totaled $327,000. Required:Prepare the summary entry for the amount of cash received from customers during 2018. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)arrow_forwardUse the following excerpts from Zowleski Company’s financial information. Dec. 31, 2018 Dec. 31, 2017 Cash $103,100 $95,000 Accounts Receivable 22,100 22,900 Merchandise Inventory 140,000 131,000 Plant Assets 185,000 150,000 Accumulated Depreciation (25,000) (21,000) Total Assets $425,200 $377,900 Accounts Payable $19,000 $21,000 Notes Payable 140,500 120,000 Common Stock 20,000 20,000 Retained Earnings 245,700 216,900 Total Liabilities and Equity $425,200 $377,900 Additional Information: Net Income for 2018 $28,800 Depreciation Expense for 2018 (Accumulated Depreciation Increase) 4,000 Plant Assets Purchased (Plant Assets Increase), Finance by Note 35,000 Notes Payable Increased by Amount of Plant Assets Purchase 35,000 Notes Payable Decreased by Amount of Principal…arrow_forward6 The condensed financial statements of Underwood Company for the years 2017 and 2018 are presented as follows. (Amounts in thousands.) UNDERWOOD COMPANYBalance SheetsDecember 31 2018 2017 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 470 400 Inventory 460 390 Prepaid expenses 120 160 Total current assets 1,380 1,310 Investments 10 10 Property, plant, and equipment 420 380 Intangibles and other assets 530 510 Total assets $2,340 $2,210 Current liabilities $900 $790 Long-term liabilities 410 380 Stockholders’ equity—common 1,030 1,040 Total liabilities and stockholders’ equity $2,340 $2,210 UNDERWOOD COMPANYIncome StatementsFor the Years Ended December 31 2018 2017 Sales revenue $3,800 $3,460 Costs and expenses Cost of goods sold 955 890 Selling & administrative expenses…arrow_forward
- Rosnan Industries' 2018 and 2017 balance sheets and income statements are shown below. Balance Sheets: 2018 2017 Cash and equivalents $120 $105 Accounts receivable 275 300 Inventories 375 350 Total current assets $770 $755 Net plant and equipment 2,000 1,490 Total assets $2,770 $2,245 Accounts payable $150 $85 Accruals 75 50 Notes payable 170 195 Total current liabilities $395 $330 Long-term debt 450 290 Common stock 1,225 1,225 Retained earnings 700 400 Total liabilities and equity $2,770 $2,245 Income Statements: 2018 2017 Sales $2,000 $1,500 Operating costs excluding depreciation 1,250 1,000 EBITDA $750 $500 Depreciation and amortization 100 75 EBIT $650 $425 Interest 62 45 EBT $588 $380 Taxes (40%) 235 152 Net income $353 $228 Dividends paid $53 $48 Addition to retained earnings $300 $180…arrow_forwardBaker Company had the following balances in its accounting records as of December 31,2016: Assets Liabilities and Equity Cash $35,000 Accounts Payable 7,500 Accounts Receivable 9,000 Inventory 10,000 Common Stock 40,000 Land 41,000 Retained Earnings 47,500 Total 95,000 Total 95,000 The following accounting events apply to Baker Company’s 2017 fiscal year: May 1 Made cash payment on accounts payable of $5,500. June 1 Purchased $60,000 inventory on account. August 1 Sold $31,000 worth of inventory for $56,000. The customer paid $22,000 in cash. Nov. 1 Paid $51,000 owed to the supplier. Dec. 31 Received cash collections from accounts receivable amounting to $36,000. Incurred other operating expenses on account during the year that amounted to $8,000. Record Journal entries for each transaction. Prepare 2017’s Income Statement and Balance Sheet for Baker…arrow_forwardPartial balance sheets and additional information are listed below for Monaco Company. Monaco Company Partial Balance Sheets as of December 31 2018 2017 Assets Cash $ 30,000 $ 15,000 Accounts receivable 50,000 80,000 Inventory 20,000 30,000 Liabilities Accounts payable $ 55,000 $ 62,000 Additional information for 2018: Net income was $260,000.Depreciation expense was $20,000.Sales totaled $700,000.Cost of goods sold totaled $295,000. Required:Prepare the summary entry for the amount of cash paid to merchandise suppliers during 2018. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)arrow_forward
- The condensed financial statements of Ivanhoe Company for the years 2016 and 2017 are presented as follows. (Amounts in thousands.) IVANHOE COMPANYBalance SheetsDecember 3120172016Current assets Cash and cash equivalents$330$360 Accounts receivable (net)640570 Inventory530460 Prepaid expenses120160 Total current assets1,6201,550Investments180180Property, plant, and equipment (net)420380Intangibles and other assets530510 Total assets$2,750$2,620Current liabilities$1,070$960Long-term liabilities480450Stockholders’ equity—common1,2001,210 Total liabilities and stockholders’ equity$2,750$2,620 IVANHOE COMPANYIncome StatementsFor the Year Ended December 3120172016Sales revenue$3,870$3,530Costs and expenses Cost of goods sold1,1251,060 Selling & administrative expenses2,4002,330 Interest expense2520 Total costs and expenses3,5503,410Income before income taxes320120Income tax expense9636Net income$ 224$ 84 Compute the following ratios for 2017 and 2016.…arrow_forwardThe condensed financial statements of Ivanhoe Company for the years 2016 and 2017 are presented as follows. (Amounts in thousands.) IVANHOE COMPANYBalance SheetsDecember 3120172016Current assets Cash and cash equivalents$330$360 Accounts receivable (net)640570 Inventory530460 Prepaid expenses120160 Total current assets1,6201,550Investments180180Property, plant, and equipment (net)420380Intangibles and other assets530510 Total assets$2,750$2,620Current liabilities$1,070$960Long-term liabilities480450Stockholders’ equity—common1,2001,210 Total liabilities and stockholders’ equity$2,750$2,620 IVANHOE COMPANYIncome StatementsFor the Year Ended December 3120172016Sales revenue$3,870$3,530Costs and expenses Cost of goods sold1,1251,060 Selling & administrative expenses2,4002,330 Interest expense2520 Total costs and expenses3,5503,410Income before income taxes320120Income tax expense9636Net income$ 224$ 84 Compute the following ratios for 2017 and 2016.…arrow_forwardHartman, Inc. has prepared the following comparative balance sheets for 2017 and 2018: 2018 2017 Cash $ 282,000 $ 153,000 Accounts receivable 139,000 117,000 Inventory 150,000 180,000 Prepaid expenses 18,000 27,000 Plant assets 1,295,000 1,050,000 Accumulated depreciation (450,000) (375,000)…arrow_forward
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
- College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub