Answer -
Dec. 31, 2022 | Dec. 31, 2021 | |||
Amount | Percentage | Amount | Percentage | |
Accounts receivable | $377600 | 11.9% | $320000 | 11.7% |
Inventory | $695400 | 21.9% | $570000 | 20.8% |
Total assets | $3178400 | 100.0% | $2740000 | 100.0% |
Calculation:
Vertical analysis is the proportional analysis of a financial statement, where each line item on a financial statement is listed as a percentage of another item. Every line item on a balance sheet is stated as a percentage of total assets.
So,
Total assets taken as a denominator for accounts receivable and inventory,
Dec. 31, 2022:
Accounts receivable (Percentage) = [Accounts receivable / Total assets] * 100
= [$377600 / $3178400] * 100
= 11.88% ≈ 11.9%
Inventory (Percentage) = [Inventory / Total assets] * 100
= [$695400 / $3178400] * 100
= 21.88% ≈ 21.9%
Total assets (Percentage) = [Total assets / Total assets] * 100
= [$3178400 / $3178400] * 100
= 100%
Dec. 31, 2021:
Accounts receivable (Percentage) = [Accounts receivable / Total assets] * 100
= [$320000 / $2740000] * 100
= 11.68% ≈ 11.7%
Inventory (Percentage) = [Inventory / Total assets] * 100
= [$570000 / $2740000] * 100
= 20.80% ≈ 20.8%
Total assets (Percentage) = [Total assets / Total assets] * 100
= [$2740000 / $2740000] * 100
= 100%
Brief Exercise 13-05 Using these data from the comparative balance sheet of Oriole Company, perform vertical...
Brief Exercise 13-05 Using these data from the comparative balance sheet of Oriole 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 $ 377,600 Enter a value in percentages rounded to 1 decimal place. % $ 320,000 Enter a value in percentages rounded to 1 decimal place. % Inventory $ 695,400 Enter a value in percentages rounded to 1 decimal place. % $ 570,000 Enter...
Brief Exercise 13-05 Using these data from the comparative balance sheet of Blossom Company, perform vertical analysis. (Round percentages to 1 decimal place, e.. 12.59.) Dec 31, 2022 Dec 31, 2021 Amount Percentage Amount Percentage Accounts receivable $590,000 $500,000 Inventory $ 915,000 % $750,000 Total assets $3,387,200 $220.000
Brief Exercise 13-04 Using these data from the comparative balance sheet of Sandhill Co., perform horizontal analysis. (If amount and percentage are a decrease show the numbers negative, e.g. -55,000, -20% or (55,000), (209). Round percentages to o decimal places, e.g. 129.) Increase or (Decrease) Amount Percentage Dec. 31, 2022 Dec 31, 2021 5556,300 $ 480,000 Accounts receivable Inventory $ 576,000 $ 730,000 Total assets $3,306,000 $2,900,000 Click if you would like to Show Work for this question: Open Show...
. 12.56.) Brief Exercise 13-05 Using these data from the comparative balance sheet of Carla Vista Co., perform vertical analysis. (found percentages to 1 decimal place Dec. 31, 2022 Dec 31, 2021 Amount Percentage Amount Percentage Accounts peceivable $ 535,800 $ 470,000 Inventory $ 856,800 $ 720,000 Total assets $3,265,700 % $2,890,000 LINK TO TEXT
Brief Exercise 13-04 Using these data from the comparative balance sheet of Carla Vista Co., perform horizontal analysis. (If amount and percentage are a de Increase or (Decrease) Amount Percentage Dec 31, 2022 Dec. 31, 2021 $417,600 $360,000 Accounts receivable Inventory $ 732,000 $ 610,000 Total assets $3,169,200 $2,780,000 decrease show the numbers as negative, e.g. -55,000, -20% or (55,000). (20%). Round percentages to o decimal places, e.g. 12%.)
Brief Exercise 13-5 Using these data from the comparative balance sheet of Sandhill Co., perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.) Dec. 31, 2017 Dec. 31, 2016 Percentage Percentage Amount Amount $ 438,000 Accounts receivable $504,000 $ 821,000 $649,000 Inventory % $2,775,000 Total assets $3,154,000 %
Brief Exercise 13-04 Using these data from the comparative balance sheet of Ivanhoe Company, perform horizontal analysis. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 0 decimal places, e.g. 12%.) Increase or (Decrease) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Accounts receivable $ 487,200 $ 420,000 $Enter increase or decrease amount in dollars. Enter increase or decrease in percentages rounded to 0 decimal places. % Inventory...
Brief Exercise 13-04 Using these data from the comparative balance sheet of Crane Company, perform horizontal analysis. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 0 decimal places, e.g. 12%.) Increase or (Decrease) Dec. 31, 2020 Dec. 31, 2019 Amount Percentage Accounts receivable $445,200 $371,000 % $ Inventory 692,500 554,000 $ Total assets 3,313,440 2,808,000 % $
Practice Brief Exercise 02 Using these data from the comparative balance sheet of Crane Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.) Dec. 31, 2020 Amount Percentage Dec. 31, 2019 Amount Percentage Accounts receivable $575,000 % $ 428,000 % Inventory 798,000 % 587,000 % Total assets 3,167,000 % 2,812,000 %
Brief Exercise 13-4 Using these data from the comparative balance sheet of Sandhill Co., perform horizontal analysis. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to O decimal places, e.g. 12%.) uzing these data from the comparati Increase or Decrease Dec. 31, 2017 Dec. 31, 2016 Amount Percentage Accounts receivable $ 511,000 $ 435,000 76,000 Inventory $ 825,000 $ 589,000 236,000 Total assets $3,159,000 $2,773,000 $ 386,000