Question

Brief Exercise 13-04 Using these data from the comparative balance sheet of Sandhill Co., perform horizontal analysis. (If am
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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%

Add a comment
Know the answer?
Add Answer to:
Brief Exercise 13-04 Using these data from the comparative balance sheet of Sandhill Co., perform horizontal...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Brief Exercise 13-04 Using these data from the comparative balance sheet of Carla Vista Co., perform...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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 $...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT