Using these data from the comparative balance sheet of Rollaird Company, perform horizontal analysis.
Using these data from the comparative balance sheet of Rollaird Company, perform horizontal analysis.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![### Brief Exercise 18-04
Using these data from the comparative balance sheet of Rollaird Company, perform horizontal analysis.
#### Data Table:
| | December 31, 2020 | December 31, 2019 |
|-----------------------:|-----------------:|-----------------:|
| **Accounts receivable**| $532,000 | $400,000 |
| **Inventory** | $861,800 | $620,000 |
| **Total assets** | $2,954,350 | $2,569,000 |
*Note: Enter negative amounts using either a negative sign preceding the number e.g., -45 or parentheses e.g., (45).*
#### Horizontal Analysis:
| | December 31, 2020 | December 31, 2019 | Increase or (Decrease) | |
|-----------------------:|-----------------:|-----------------:|-----------------------:|----------------:|
| **Accounts receivable**| $532,000 | $400,000 | $______ | ______%|
| **Inventory** | $861,800 | $620,000 | $______ | ______%|
| **Total assets** | $2,954,350 | $2,569,000 | $______ | ______%|
[Link to Text]
#### Detailed Explanation:
The table above shows the balance sheet data for Rollaird Company on December 31, 2020, and December 31, 2019. It includes values for accounts receivable, inventory, and total assets. The goal is to perform a horizontal analysis to determine the amount and percentage increase or decrease between the two years.
Horizontal analysis compares financial data over a period of time to identify trends and growth patterns. This involves calculating both the dollar and percentage changes between the periods.
**Instructions for Calculation:**
1. **Dollar Change Amount**:
- Subtract the 2019 value from the 2020 value for each category.
2. **Percentage Change**:
- Use the formula:
\[
\text{Percentage Change} = \left( \frac{\text{2020 Value} - \text{2019 Value}}{\text{2019 Value}} \right) \times 100
\]
Fill in the "Increase or (Decrease)" columns with the calculated dollar and percentage amounts.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff9e159a4-9637-434e-a29d-9a02e82e3af6%2F0f68b043-6a17-4887-80e2-812e84ed44db%2Fxgdcxxd.jpeg&w=3840&q=75)
Transcribed Image Text:### Brief Exercise 18-04
Using these data from the comparative balance sheet of Rollaird Company, perform horizontal analysis.
#### Data Table:
| | December 31, 2020 | December 31, 2019 |
|-----------------------:|-----------------:|-----------------:|
| **Accounts receivable**| $532,000 | $400,000 |
| **Inventory** | $861,800 | $620,000 |
| **Total assets** | $2,954,350 | $2,569,000 |
*Note: Enter negative amounts using either a negative sign preceding the number e.g., -45 or parentheses e.g., (45).*
#### Horizontal Analysis:
| | December 31, 2020 | December 31, 2019 | Increase or (Decrease) | |
|-----------------------:|-----------------:|-----------------:|-----------------------:|----------------:|
| **Accounts receivable**| $532,000 | $400,000 | $______ | ______%|
| **Inventory** | $861,800 | $620,000 | $______ | ______%|
| **Total assets** | $2,954,350 | $2,569,000 | $______ | ______%|
[Link to Text]
#### Detailed Explanation:
The table above shows the balance sheet data for Rollaird Company on December 31, 2020, and December 31, 2019. It includes values for accounts receivable, inventory, and total assets. The goal is to perform a horizontal analysis to determine the amount and percentage increase or decrease between the two years.
Horizontal analysis compares financial data over a period of time to identify trends and growth patterns. This involves calculating both the dollar and percentage changes between the periods.
**Instructions for Calculation:**
1. **Dollar Change Amount**:
- Subtract the 2019 value from the 2020 value for each category.
2. **Percentage Change**:
- Use the formula:
\[
\text{Percentage Change} = \left( \frac{\text{2020 Value} - \text{2019 Value}}{\text{2019 Value}} \right) \times 100
\]
Fill in the "Increase or (Decrease)" columns with the calculated dollar and percentage amounts.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education