Required: 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns for both product lines above. Express each amount as a percentage of net sales. Note: You should use absolute references in the divisors of all formulas. 2. Use the Excel IF function and the completed vertical analysis above to answer each of the questions below: Which product line has the highest gross profit %? Which product line has the highest net income %?
Required: 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns for both product lines above. Express each amount as a percentage of net sales. Note: You should use absolute references in the divisors of all formulas. 2. Use the Excel IF function and the completed vertical analysis above to answer each of the questions below: Which product line has the highest gross profit %? Which product line has the highest net income %?
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![18
19 Required:
20 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns
for both product lines above. Express each amount as a percentage of net sales.
22 Note: You should use absolute references in the divisors of all formulas.
23 2. Use the Excel IF function and the completed vertical analysis above to answer each of the
21
24
questions below:
25
26
Which product line has the highest gross profit %?
27
Which product line has the highest net income %?
28
29
30
31
Sheet1
+)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff4ed74fd-f67c-4818-b7b1-25d2d307c13a%2F7d2a7cd9-dcb4-4850-ae5f-5ac91df29b92%2Fe41ce4q_processed.png&w=3840&q=75)
Transcribed Image Text:18
19 Required:
20 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns
for both product lines above. Express each amount as a percentage of net sales.
22 Note: You should use absolute references in the divisors of all formulas.
23 2. Use the Excel IF function and the completed vertical analysis above to answer each of the
21
24
questions below:
25
26
Which product line has the highest gross profit %?
27
Which product line has the highest net income %?
28
29
30
31
Sheet1
+)
![1. Use vertical analysis to compare profitability.
区 日
Perform Vertical Analysis - Excel
FILE
НОМE
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Sign In
Calibri
11
A A
%
Paste
BIU-
Alignment Number
Conditional Format as Cell
Cells
Formatting -
Table Styles -
Clipboard E
Font
Styles
A1
fx
Lake Athletics sells two distinct product lines: Apparel and Equipment.
В
C
D
E
F
1 Lake Athletics sells two distinct product lines: Apparel and Equipment.
2 The income statement for each product line appears below.
3
4
LAKE ATHLETICS
Income Statement
For the Year Ended December 31, 20X1
7
Apparel
Equipment
8
Amount
Percent
Amount
Percent
9 Net sales
$3,150,000
1,400,000
$5,550,000
2,720,000
2,830,000
10 Cost of goods sold
11 Gross profit
12 Operating expenses
13 Operating income
1,750,000
800,000
950,000
875,000
1,955,000
14 Other income
20,000
10,000
15 Income before tax
1,965,000
491,000
970,000
16 Income tax expense
241,250
$728,750
17 Net income
$1,474,750
18
19 Required:
20 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns
for both product lines above. Express each amount as a percentage of net sales.
22 Note: You should use absolute references in the divisors of all formulas.
23 2. Use the Excel IF function and the completed vertical analysis above to answer each of the
21
24
questions below:
Sheet1
READY
曲
+ 100%](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff4ed74fd-f67c-4818-b7b1-25d2d307c13a%2F7d2a7cd9-dcb4-4850-ae5f-5ac91df29b92%2Fvgvcfel_processed.png&w=3840&q=75)
Transcribed Image Text:1. Use vertical analysis to compare profitability.
区 日
Perform Vertical Analysis - Excel
FILE
НОМE
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Sign In
Calibri
11
A A
%
Paste
BIU-
Alignment Number
Conditional Format as Cell
Cells
Formatting -
Table Styles -
Clipboard E
Font
Styles
A1
fx
Lake Athletics sells two distinct product lines: Apparel and Equipment.
В
C
D
E
F
1 Lake Athletics sells two distinct product lines: Apparel and Equipment.
2 The income statement for each product line appears below.
3
4
LAKE ATHLETICS
Income Statement
For the Year Ended December 31, 20X1
7
Apparel
Equipment
8
Amount
Percent
Amount
Percent
9 Net sales
$3,150,000
1,400,000
$5,550,000
2,720,000
2,830,000
10 Cost of goods sold
11 Gross profit
12 Operating expenses
13 Operating income
1,750,000
800,000
950,000
875,000
1,955,000
14 Other income
20,000
10,000
15 Income before tax
1,965,000
491,000
970,000
16 Income tax expense
241,250
$728,750
17 Net income
$1,474,750
18
19 Required:
20 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns
for both product lines above. Express each amount as a percentage of net sales.
22 Note: You should use absolute references in the divisors of all formulas.
23 2. Use the Excel IF function and the completed vertical analysis above to answer each of the
21
24
questions below:
Sheet1
READY
曲
+ 100%
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 3 steps with 4 images
![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