sing the following selected items from the comparative balance sheet of Ivanhoe Company, illustrate horizontal (using 2020 as the se year) and vertical analysis. (Round vertical analysis to 1 decimal place, e.g. 15.2.) Accounts Receivable nventory December 31, December 31, 2021 2020 $754,350 452,610 $677,250 367,220 HORIZONTAL ANALYSIS December 31, 2021 11.38 23.25 % % December 31, 2020 -10.22 -18.87 % %

sing the following selected items from the comparative balance sheet of Ivanhoe Company, illustrate horizontal (using 2020 as the se year) and vertical analysis. (Round vertical analysis to 1 decimal place, e.g. 15.2.) Accounts Receivable nventory December 31, December 31, 2021 2020 $754,350 452,610 $677,250 367,220 HORIZONTAL ANALYSIS December 31, 2021 11.38 23.25 % % December 31, 2020 -10.22 -18.87 % %

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 54CE

See similar textbooks

Similar questions

Asset Efficiency Ratios Rumsford Inc.s financial statements for 2019 indicate the following account balances: Required: 1. Using this information, calculate Rumsfords receivable turnover ratio. (Note: Round to two decimal places.) 2. Using this information, calculate Rumsfords asset turnover ratio and also convert the ratio into days.
view Policies Current Attempt in Progress Using these data from the comparative balance sheet of Cullumber Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Amount Percentage Accounts receivable $ 467,400 $ 410,000 Inventory $ 785,400 % $ 660,000 % Total assets $3,197,900 % $2,830,000 % eTextbook and Media Save for Later Attempts: 0 of 3 used Submit Answer
Problem 17-2A (Algo) Ratios, common-size statements, and trend percer [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets Long-term investments Plant assets, net Total assets Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 2021 $546,242 328,838 217,404 77,566 49,162 126,728 90,676 16,866 $ 73,810 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income KORBIN COMPANY Comparative Balance Sheets December 31 2020 $ 418,466 263,634 2021 % 154,832 57,748 36,825 94,573 60, 259 12,353 $ 47,906 % $61,141 0 113,547…
Using these data from the comparative balance sheets of Concord Company, perform a vertical analysis. Accounts receivable (net) Inventory Total assets (Round percentages to 1 decimal place, e.g. 12.1%.) December 31, 2022 December 31, 2021 $418,320 $425,250 816,720 787,500 2,490,000 3,150,000 December 31, 2022 December 31, 2021 Amount Percentage Amount Percentage Accounts receivable (net) $418,320 % $425,250 % Inventory Total assets 816,720 % 787,500 % 2,490,000 % 3,150,000 %
Using these data from the comparative balance sheets of Blossom Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Amount Percentage Accounts receivable (net) $424,551 enter Accounts receivable in percentages on Dec. 31, 2022 % $ 333,450 enter Accounts receivable in percentages on Dec. 31, 2022 % Inventory 707,585 enter Inventory in percentages on Dec. 31, 2022 % 589,950 enter Inventory in percentages on Dec. 31, 2022 % Total assets 3,011,000 enter Total assets in percentages on Dec. 31, 2022 % 2,565,000 enter Total assets in percentages on Dec. 31, 2022 %
Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) Sales Current assets: Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 1 % % % % % % Year 2 % % % % % % Year 3 % % % % % % Year 4 % % % % % Year 5 % % % % %
Using these data from the comparative balance sheet of Sunland Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Amount Percentage Accounts receivable $ 529,000 Enter a value in percentages rounded to 1 decimal place. % $ 460,000 Enter a value in percentages rounded to 1 decimal place. % Inventory $ 837,800 Enter a value in percentages rounded to 1 decimal place. % $ 710,000 Enter a value in percentages rounded to 1 decimal place. % Total assets $3,225,600 Enter a value in percentages rounded to 1 decimal place. % $2,880,000 Enter a value in percentages rounded to 1 decimal place. %
Comparative data (in thousands) from the balance sheet of Sunland Ltd. are shown below. 2024 2023 2022 2021 Cash $22 $41 $27 $17 Accounts receivable 280 245 214 162 Inventory 510 493 418 343 Prepaid expenses 20 0 10 20 Total current assets $832 $779 $669 $542 Using horizontal analysis, calculate the percent of base year, assuming 2021 is the base year
3. Complete the below table to calculate the balance sheet data in trend percents with 2017 as base year. (Round your percentage answers to 2 decimal places.) KORBIN COMPANY Balance Sheet Data in Trend Percents December 31, 2019, 2018 and 2017 2019 2018 2017 Assets Current assets % % 100.00 % Long-term investments 100.00 Plant assets, net 100.00 Total assets % % 100.00 % Liabilities and Equity Current liabilities % % 100.00 % Common stock 100.00 Other paid-in capital 100.00 Retained earnings 100.00 Total liabilities and equity % % 100.00 % see pictures
Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 Sales $ 562,795 2019 $ 299,200 338,803 Cost of goods sold Gross profit 191,488 223,992 107,712 Selling expenses 79,917 39,494 Administrative expenses 50,652 24,834 Total expenses 130,569 64,328 Income before taxes 93,423 43,384 Income tax expense 17,377 8,807 Net income $ 76,046 $ 34,577 KORBIN COMPANY Comparative Balance Sheets December 31 2021 2020 Assets Current assets $ 38,127 $ 56,965 0 Long-term investments 700 97,740 Plant assets, net Total assets 107,436 $164,401 $ 136,567 Liabilities and Equity Current liabilities $ 20,348 Common stock 68,000 $ 24,003 68,000 8,500 63,898 Other paid-in capital 8,500 Retained earnings 39,719 Total liabilities and equity $164,401 $ 136,567 2020 $431,147 273,778 157,369 59,498 37,941 97,439 59,930 12,286 $ 47,644 2019 $ 50,967 4,550 57,629 $ 113,146 $ 19,801 50,000 5,556 37,789 $113,146 4
The comparative balance sheet of Merrick Equipment Co. for Dec. 31, 20Y9 and 20Y8, is:Dec. 31, 20Y9 Dec. 31, 20Y8AssetsCash $70,720 $47,940Accounts receivable (net) 207,230 188,190Inventories 298,520 289,850Investments 0 102,000Land 295,800 0Equipment 438,600 358,020Accumulated depreciation—equipment (99,110) (84,320)Total assets $1,211,760 $901,680Liabilities and Stockholders' EquityAccounts payable (merchandise creditors) $205,700 $194,140Accrued expenses payable (operating expenses) 30,600 26,860Dividends payable 25,500 20,400Common stock, $1 par 202,000 102,000Paid-in capital: Excess of issue price over par—common stock 354,000 204,000Retained earnings 393,960 354,280Total liabilities and stockholders' equity $1,211,760 $901,680The income statement for the year ended December 31, 20Y9, is as follows:Sales $2,023,898Cost of goods sold 1,245,476Gross profit $778,422Operating expenses:Depreciation expense $14,790Other operating expenses 517,299Total operating expenses 532,089Operating…
Using these data from the comparative balance sheet of Wildhorse Co., perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Amount Percentage Accounts receivable $ 448,400 Enter a value in percentages rounded to 1 decimal place. % $ 380,000 Enter a value in percentages rounded to 1 decimal place. % Inventory $ 768,600 Enter a value in percentages rounded to 1 decimal place. % $ 630,000 Enter a value in percentages rounded to 1 decimal place. % Total assets $3,248,000 Enter a value in percentages rounded to 1 decimal place. % $2,800,000 Enter a value in percentages rounded to 1 decimal place. %