Ans:Horizontal Analysis
Increase or decrease | ||||
Particulars | Dec 31,2022 | Dec 31,2021 | Amount | Percentage |
Accounts Receivable | $556,800 | $480,000 | 76,800;inc | 16% |
Inventory | $876,000 | $730,000 | 146,000;inc | 20% |
Total Assets | $3,306,000 | $2,900,000 | 406,000;inc | 14% |
inc= Increase
Required Percentage= Amount increase or decrease/ base year i.e 2021 *100
Account receivable = 76,800/480,000*100
= 16%
Inventory = 146,000/730,000*100
=20%
Total Assets= 406,000/2,900,000*100
= 14%
Brief Exercise 13-04 Using these data from the comparative balance sheet of Sandhill Co., perform horizontal...
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-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-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
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 % $
Brief Exercise 13-05 Using these data from the comparative balance sheet of Oriole Company, perform vertical analysis (Round percentages to I decimal place, e.g. 13 Dec. 31, 2022 Amount Percentage $377,600 % Dec. 31, 2021 Amount Percentage $ 320,000 Accounts receivable Inventory $ 695,400 W $570,000 Total assets $3,178,400 $2,740,000 Click if you would like to Show Work for this question: Open Show Work
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 %
Using these data from the comparative balance sheet of Sheridan 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 $ 535,500 $ 450,000 $ % Inventory $ 861,000 $ 700,000 $ % Total assets $3,357,900 $2,870,000 $
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 $ 362,700 $ 310,000 $Enter increase or decrease amount in dollars. Enter increase or decrease in percentages rounded to 0 decimal places. % Inventory $ 677,600 $...
Practice Brief Exercise 01 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) Amount Percentage Dec. 31, 2020 Dec. 31, 2019 Accounts receivable $445,200 $371,000 % $ Inventory 692,500 554,000 % $ Total assets 3,313,440 2,808,000 % $
Using these data from the comparative balance sheet of Blossom 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 $ 345,000 $ 300,000 $Enter increase or decrease amount in dollars. Enter increase or decrease in percentages rounded to 0 decimal places. % Inventory $ 649,000 $...