R Formula: Divide; Cell Referencing Using Excel to Perform Vertical Analysis Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to this work area Data from the comparative balance sheets of Rollaird Company is presented here. December 31, December 31, 2021 Using these data from the comparative balance sheets of Rollaird Company, perform vertical analysis. 2022 Accounts receivable (net) Inventory 460,000 $ 780,000 400,000 December 31, 2022 December 31, 2021 Amount 400.000 650,000 Total assets 3,164,000 2,800,000 Amount Percent Percent Accounts receivable (net) $ 460,000 Inventory 780,000 650,000 Total assets 3,164,000 2,800,000

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
AutoSave
a Ch13Homework_Question5
OFF
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Tell me
A Share
Comments
A^ A
KA Insert v
Liberation Sans
12
22 Wrap Text v
Custom
Delete v
В I U
A
$ v % 9
.00
Conditional Format
Cell
Find &
Select
Analyze
Data
Paste
Merge & Center v
Sort &
Sensitivity
00
Formatting as Table
Styles
Format v
Filter
С32
fx
K L
0 P
A
В
C
D
E
G
H
J
M
N
R
S
U
V
W
X
Formula: Divide; Cell Referencing
1
2
3 Using Excel to Perform Vertical Analysis
PROBLEM
Student Work Area
Required: Provide input into cells shaded in yellow in this template. Use mathematical
formulas with cell references to this work area.
4
5 Data from the comparative balance sheets of Rollaird Company is
6 presented here.
7
December 31,
December 31,
Using these data from the comparative balance sheets of Rollaird Company, perform vertical
analysis.
8.
9.
2022
2021
Accounts receivable (net)
$
460,000 $
780,000
400,000
650,000
10
11
Inventory
December 31, 2022
December 31, 2021
12
Total assets
3,164,000
2,800,000
Amount
Percent
Amount
Percent
13
Accounts receivable (net)
$
460,000
$
400,000
14
15
Inventory
780,000
650,000
16
17
Total assets
3,164,000
2,800,000
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
Enter Answer
+
Ready
+
100%
曲
Transcribed Image Text:AutoSave a Ch13Homework_Question5 OFF Home Insert Draw Page Layout Formulas Data Review View Tell me A Share Comments A^ A KA Insert v Liberation Sans 12 22 Wrap Text v Custom Delete v В I U A $ v % 9 .00 Conditional Format Cell Find & Select Analyze Data Paste Merge & Center v Sort & Sensitivity 00 Formatting as Table Styles Format v Filter С32 fx K L 0 P A В C D E G H J M N R S U V W X Formula: Divide; Cell Referencing 1 2 3 Using Excel to Perform Vertical Analysis PROBLEM Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to this work area. 4 5 Data from the comparative balance sheets of Rollaird Company is 6 presented here. 7 December 31, December 31, Using these data from the comparative balance sheets of Rollaird Company, perform vertical analysis. 8. 9. 2022 2021 Accounts receivable (net) $ 460,000 $ 780,000 400,000 650,000 10 11 Inventory December 31, 2022 December 31, 2021 12 Total assets 3,164,000 2,800,000 Amount Percent Amount Percent 13 Accounts receivable (net) $ 460,000 $ 400,000 14 15 Inventory 780,000 650,000 16 17 Total assets 3,164,000 2,800,000 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Enter Answer + Ready + 100% 曲
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Vertical statement 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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education