Comparative income statement data for Oriole Inc. and Cheyenne Ltd., two competitors, are shown below for the year ended December 31, 2021.
| Oriole | Cheyenne | |||
| Net sales | $2,170,000 | $540,000 | ||
| Cost of goods sold | 1,226,050 | 342,360 | ||
| Gross profit | 943,950 | 197,640 | ||
| Operating expenses | 564,200 | 86,400 | ||
| Profit from operations | 379,750 | 111,240 | ||
| Interest expense | 6,080 | 1,252 | ||
| Profit before income tax | 373,670 | 109,988 | ||
| Income tax expense | 112,101 | 27,497 | ||
| Profit | $261,569 | $82,491 |
| Additional information: | ||||
| Average total assets | $977,000 | $333,563 | ||
| Average total shareholders’ equity | 796,000 | 257,808 |
(a)
Using vertical analysis, calculate the percentage of the base amount of the income statement for each company. (Round answers to 1 decimal place, e.g. 12.5%.)
| ORIOLE
AND CHEYENNE COMPANIES Income Statements December 31, 2021Month Ended December 31, 2021Year Ended December 31, 2021 |
||||||
| Oriole | Cheyenne | |||||
| Percent | Percent | |||||
| Net sales | % | % | ||||
| Cost of goods sold | % | % | ||||
| Gross profit | % | % | ||||
| Operating expenses | % | % | ||||
| Profit from operations | % | % | ||||
| Interest expense | % | % | ||||
| Profit before income tax | % | % | ||||
| Income tax expense | % | % | ||||
| Profit | % | % | ||||
Vertical analysis of the income statement:
| Particulars | Oriole company | Cheyenne company | ||
| Dec 31,2021 Year ended | % | Dec 31,2021 Year ended | % | |
| Net sales | 2170000 | 100% | 540000 | 100% |
| Cost of goods sold | 1226050 | 56.5% | 342360 | 63.4% |
| Gross profit | 943950 | 43.5% | 197640 | 36.6% |
| operating expenses | 564200 | 26.0% | 86400 | 16.0% |
| profit form operations | 379750 | 17.5% | 111240 | 20.6% |
| interest expense | 6080 | 0.3% | 1252 | 0.2% |
| profit before income taxes | 373670 | 17.2% | 109988 | 20.4% |
| income tax expenses | 112101 | 5.2% | 27497 | 5.1% |
| Profit | 261569 | 12.1% | 82491 | 15.3% |
Comparative income statement data for Oriole Inc. and Cheyenne Ltd., two competitors, are shown below for...
In its income statement for the year ended December 31, 2022, Cheyenne Corp.reported the following condensed data. Salaries and wages expenses Cost of goods sold Interest expense Interest revenue Depreciation expense $520,800 Loss on disposal of plant assets 1,125,180 Sales revenue 80,940 Income tax expense 74,100 Sales discounts 353,400 Utilities expense $95,190 2,519,400 28,500 182,400 125,400 (a) Your Answer Correct Answer Your answer is correct. Prepare a multiple-step income statement. (List other revenues before other expenses.) Cheyenne Corp. Income Statement...
Here are comparative statement data for Pharoah Company and Cullumber Company, two competitors. All balance sheet data are as of December 31, 2017, and December 31, 2016. Pharoah Company Cullumber Company 2017 2016 2017 2016 Net sales $1,922,000 $561,000 Cost of goods sold 1,084,000 291,000 Operating expenses 256,000 85,000 Interest expense 6,800 2,500 Income tax expense 68,600 32,000 Current assets 704,106 $674,806 180,006 $ 171,649 Plant assets (net) 1,137,888 1,080,000 301,812 271,754 Current liabilities 143,262 163,760 76,352 65,407 Long-term liabilities...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Previous Year Year $429,000 $378,000 270,270 211,680 64,350 68,040 Sales Cost of goods sold Selling expenses Administrative expenses Income tax expense 68,640 56,700 8,580 15,120 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Innovation Quarter Inc. Comparative Income Statement For...
The following are the financial statements of Cheyenne Corp.. Cheyenne Corp. Comparative Balance Sheets December 31 Assets 2019 2018 Cash $37,900 $20,200 Accounts receivable 32,100 19,600 Inventory 31,000 20,400 Equipment 59,500 77,800 Accumulated depreciation equipment (29,900) (23,800) Total $130,600 $114,200 Liabilities and Stockholders' Equity Accounts payable Income taxes payable Bonds payable Common stock Retained earnings Total $28,400 $16,800 7,300 8,400 27,400 32,500 18,200 14,900 49,300 41,600 $130,600 $114,200 Cheyenne Corp. Income Statement For the Year Ended December 31, 2019 Sales...
Here are comparative statement data for Duke Company and Lord Company, two competitors. All balance sheet data are as of December 31, 2022, and December 31, 2021 Duke Company Lord Company 2021 2022 2021 2022 $1,849,000 $546,000 Net sales Cost of goods sold 1,063,200 289,000 Operating expenses 240,000 82,000 Interest expense 6,800 3,600 Income tax expense 62,000 28,000 325,980 $312.410 Current assets 83,336 $79,467 Plant assets (net) 526,800 500,000 139,729 125,812 Current liabilities 66,325 75,815 35,348 30,281 25,000 Long-term liabilities...
WileyPLUS Problem 5-10 a (Indirect Method) The income statement of Tamache Corporation is shown below: TAMACHE CORPORATION Statement of Income Year Ended December 31, 2020 Sales revenue $8,856,000 Cost of goods sold 5,400,000 Gross profit 3,456,000 Operating expenses $1,803,600 Depreciation expense 86,400 1,890,000 Profit before income tax $1,566,000 Income tax expense 548,100 Net income $1,017,900 Additional information: 1. Accounts receivable decreased $324,000 during the year. 2. Prepaid expenses increased $216,000 during the year. 3. Inventory decreased $432,000 during the year....
Horizontal Analysis of the Income Statement Income statement
data for Winthrop Company for two recent years ended December 31,
are as follows: Current Year Sales Cost of goods sold Gross profit
$665,600 567,000 Previous Year $520,000 450,000 $98,600 $70,000
Selling expenses$29,500 Administrative expenses 26,460 $25,000
21,000 $ 46,000 Total operating expenses$55,960 Income before
income tax$42,640 $ 24,000 Income tax expenses 17,1009,600 Net
income$ 25,540$ 14,400
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent...
The following income statement does not reflect intraperiod tax allocation. INCOME STATEMENT For the Fiscal Year Ended March 31, 2021 ($ in millions) Sales revenue Cost of goods sold Gross profit Operating expenses Income tax expense Income before discontinued operations Loss from discontinued operations Net income $ 822 (356) 466 (182) (49) 235 (88) $ 147 The company's tax rate is 25%. Required: Recast the income statement to reflect intraperiod tax allocation. (Loss amounts should be indicated with a minus...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows: Current Year Previous Year Sales $932,400 $740,000 Cost of goods sold 787,200 640,000 Gross profit $145,200 $100,000 Selling expenses $41,760 $36,000 Administrative expenses 37,200 30,000 Total operating expenses $78,960 $66,000 Income before income tax $66,240 $34,000 Income tax expenses 26,500 13,600 Net income $39,740 $20,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
The following Income statement does not reflect Intraperlod tax allocation. INCOME STATEMENT For the Fiscal Year Ended March 31, 2021 ($ in millions) Sales revenue Cost of goods sold Gross profit Operating expenses Income tax expense Income before discontinued operations Loss from discontinued operations Net income $ 830 (350) 480 (180) (54) 246 (84) $ 162 The company's tax rate is 25%. Required: Recast the income statement to reflect Intraperlod tax allocation. (Loss amounts should be Indicated with a minus...