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...
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
}
]
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Balance Sheet Analysis
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage