(a)
Multi step income statement: A multiple step income statement refers to the income statement that shows the operating, and non-operating activities of the business, under separate head. In different steps of the multi-step income statement, principal operating activities are reported that starts from the record of sales revenue with all contra sales revenue account like sales returns, allowances and sales discounts.
To Prepare: The multi-step income statement of Company D for the year ended December 31, 2017.
(b)
Gross Profit Rate: It is the financial ratio that evaluates the money left out of the total revenues after deducting the cost of goods sold. Thus, it shows the relationship between the gross profit on sales and net sales. It is calculated by using the following formula:
Profit Margin: It measures the amount of net income earned from each dollar of sales revenue generated by a company. Thus, it shows the relationship between the net income and net sales. It is calculated by using the following formula:
To Determine: The profit margin and gross profit rate of Company D for the year 2017.
(c)
To Explain: Whether the decline in profit margin in 2017 is a cause for concern.
Trending nowThis is a popular solution!
Chapter 5 Solutions
FINANCIAL ACCT.:TOOLS...(LL)-W/ACCESS
- 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_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_forwardUse the following information from Eiffel Company’s financial statements. 2018 IncomeStatement BalanceSheets Sales $309,000 Cost of Goods Sold (145,000) Operating Expenses, other than Depreciation Expense (27,000) Depreciation expense (16,000) Gain on Sale of Plant Assets 16,000 Net Income $137,000 Dec. 31,2018 Accounts Receivable $45,300 Inventory 1,600 Accounts Payable 22,500 Accured Liabilities 900 Dec. 31, 2017 Accounts Receivable $22,250 Inventory 1,800 Accounts Payable 22,250 Accured Liabilities 1,150 Prepare the operating activities section of the statement of cash flows (indirect method) for the year 2018. Use the minus sign to indicate cash outflows, a decrease in cash or cash payments. Eiffel Company Statement of Cash Flows (Indirect Method) For the Year Ended December 31, 2018 Operating…arrow_forward
- In its income statement for the year ended December 31, 2022, Splish Brothers Inc. reported the following condensed data. Prepare a multiple step income statement , and then calculate the profit margin and gross profit rate. Salaries and wages expenses $576,600 Loss on disposal of plant assets $103,540 Cost of goods sold 1,223,880 Sales revenue 2,740,400 Interest expense 89,460 Income tax expense 31,000 Interest revenue 80,600 Sales discounts 198,400 Depreciation expense 384,400 Utilities expense 136,400arrow_forwardFollowing are the jumbled information related to XYZ Company for the year 2016. Revenue 300,000 Equipment 150,000 Administration Expenses 40,000 Trade Receivable 50,000 Interest expense 10,000 Cost of goods sold 130,000 Tax 25,000 What will be the company's reported Gross profit and Net Income (Net Profit)? Gross Profit 130,000 and Net Profit 95,000 Gross Profit 170,000 and Net Profit 120,000 Gross Profit 130,000 and Net Profit 105,000 Gross Profit 170,000 and Net Profit 95,000arrow_forwardIn its income statement for the year ended December 31, 2022, Cullumber Company reported the following condensed data. Operating expenses $ 710,000 Interest revenue $ 23,000 Cost of goods sold 1,246,000 Loss on disposal of plant assets 7,000 Interest expense 60,000 Net sales 2,190,000 Income tax expense 35,000 Other comprehensive income (net of $1,200 tax) 7,300 (a) Prepare a multiple-step income statement.arrow_forward
- In its income statement for the year ended December 31, 2019, Cullumber Company reported the following condensed data. Operating expenses - $915,000 Cost of goods sold - $1,290,000 Interest expenses - $70,100 Selling expense - $490,000 Interest revenue - $28,100 Loss on sale of equipment - $15,000 Net sales - $2,400,000 Administrative expenses - $435,000 Prepare a multi-step income statement.arrow_forwardIn its income statement for the year ended December 31, 2022, Wildhorse Co. reported the following condensed data. Operating expenses $ 726,000 Interest revenue $ 39,000 Cost of goods sold 1,262,000 Loss on disposal of plant assets 23,000 Interest expense 75,000 Net sales 2,205,000 Income tax expense 51,000 Other comprehensive income (net of $1,200 tax) 8,900 I have to find a Income statement as well as a Comprehensive income, statement is needed, and I am confused.arrow_forwardThe following information is available for UST Company: Sales $850,000 Interest Revenue 5,000 Cost of Goods Sold 350,000 Salaries Expense 100,000 Supplies Expense 15,000 Interest Expense 25,000 Advertising Expense 65,000 Use the above information to prepare a multiple-step income statement for the year ended December 31, 2014.arrow_forward
- Following is a randon list of accounts with normal balances for the Wiggins Company as of December 31, 2018. Based on the information given below, calculate operating income for the year ended December 21, 2018. Cost of Goods Sold $117,000 General Expenses 36,000 Administrative Expenses 12,000 Net Cash Provided by Financing Activities 69,000 Dividends Paid 16,000 Extraordinary Loss from a flood, Net of tax savings of $32,000 74,000 Income Tax Expense 11,000 Other Selling Expenses 26,000 Net Sales 278,000 Advertising Expense 39,000 Accounts Receivable 33,000 Accounts Payable 40,000arrow_forwardBelow are the financial statements of Coco Stationary Statement of Comprehensive Income for the Year ended 31 December 2017 $ $ Sales 305,830 Cost of goods sold 210,935 Depreciation 26,850 Earnings before interest and taxes 68,045 Interest paid 11,930 Taxable income 56,115 Taxes (35%) 19,640 Net income 36,475 Dividends 20,000 Retained earnings 16,475 Coco Stationary Statement of Financial Position as at 31 December 2017 $ Net plant and equipment 260,525 Cash 22,050 Accounts receivable 13,850 Inventory 24,650 Total current assets 60,550 Total assets 321,075 Ordinary shares 25,000 Retained earnings 167,840 Total owners' equity 192,840 Long term debt 85,000 Accounts payable 22,850 Notes payable 9,000 Other 11,385 Total current liabilities 43,235 Total liabilities after owners' equity 321,075 Calculate the following financial ratios as at 31 December 201 Profitability ratios i.…arrow_forwardBelow are the financial statements of Coco Stationary Statement of Comprehensive Income for the Year ended 31 December 2017 $ $ Sales 305,830 Cost of goods sold 210,935 Depreciation 26,850 Earnings before interest and taxes 68,045 Interest paid 11,930 Taxable income 56,115 Taxes (35%) 19,640 Net income 36,475 Dividends 20,000 Retained earnings 16,475 Coco Stationary Statement of Financial Position as at 31 December 2017 $ Net plant and equipment 260,525 Cash 22,050 Accounts receivable 13,850 Inventory 24,650 Total current assets 60,550 Total assets 321,075 Ordinary shares 25,000 Retained earnings 167,840 Total owners' equity 192,840 Long term debt 85,000 Accounts payable 22,850 Notes payable 9,000 Other 11,385 Total current liabilities 43,235 Total liabilities after owners' equity 321,075 Calculate the following financial ratios as at 31 December 2017 a. Liquidity ratios: 1)…arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning