DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a horizontal analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance. Accounts Receivable Inventory Total Assets Dec. 31, 2022 Dec. 31, 2021 460,000 780,000 3,164,000 NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point for the answer, as seen in the example below. The text box will highlight red if incorrect after clicking the Submit button (bottom right corner). Example: 400,000 650,000 2,800,000 Accounts Receivable 30000 = 500000 = = 6.0 % %
DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a horizontal analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance. Accounts Receivable Inventory Total Assets Dec. 31, 2022 Dec. 31, 2021 460,000 780,000 3,164,000 NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point for the answer, as seen in the example below. The text box will highlight red if incorrect after clicking the Submit button (bottom right corner). Example: 400,000 650,000 2,800,000 Accounts Receivable 30000 = 500000 = = 6.0 % %
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...
Related questions
Question
I need help come My Horizontal and Vertical Analysis
![DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a horizontal
analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance.
X
F4
$
Accounts Receivable
Inventory
Total Assets
R
○ 발
2.0
NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point
for the answer, as seen in the example below. The text box will highlight red if incorrect after
clicking the Submit button (bottom right corner).
F5
%
5
T
Dec. 31, 2022 Dec. 31, 2021
F6
6
460,000
780,000
3,164,000
Accounts Receivable
Example:
Y
F7
&
7
8
F8
U
400,000
650,000
2,800,000
W
30000
8
F9
F
=
500000
prt sc
F10
9
11
home
F11
O
6.0
end
F12
P
%
%
insert
+
[
6:44 A
12/16/20
delete
bac
}
]](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd525ec05-0c3c-44f8-bda2-c2b8211d10ad%2F1ac672d5-33cd-463a-9a88-f11ca115cbb6%2Fd8ftnij_processed.jpeg&w=3840&q=75)
Transcribed Image Text:DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a horizontal
analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance.
X
F4
$
Accounts Receivable
Inventory
Total Assets
R
○ 발
2.0
NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point
for the answer, as seen in the example below. The text box will highlight red if incorrect after
clicking the Submit button (bottom right corner).
F5
%
5
T
Dec. 31, 2022 Dec. 31, 2021
F6
6
460,000
780,000
3,164,000
Accounts Receivable
Example:
Y
F7
&
7
8
F8
U
400,000
650,000
2,800,000
W
30000
8
F9
F
=
500000
prt sc
F10
9
11
home
F11
O
6.0
end
F12
P
%
%
insert
+
[
6:44 A
12/16/20
delete
bac
}
]
Expert Solution

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 3 steps with 2 images

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

Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning

Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning

Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning

Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning