While follwoing the intructions, can you fill up the board in the second picture?

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

While follwoing the intructions, can you fill up the board in the second picture? 

10
11 Instructions
12 1. DO NOT change the format of the cells. They have been been formatted to be appropriate for the computations you are doing
2. Your work should only be in the color coded cells as under:
13
14
Pick an option from the dropdown
15
Computations - Must use formulas
16
Input your answer / Link to your work on other tabz
17
Transcribed Image Text:10 11 Instructions 12 1. DO NOT change the format of the cells. They have been been formatted to be appropriate for the computations you are doing 2. Your work should only be in the color coded cells as under: 13 14 Pick an option from the dropdown 15 Computations - Must use formulas 16 Input your answer / Link to your work on other tabz 17
A
1 NIKE, INC.
2 Consolidated Statement of Income
3
In $ Millions
4
5
6
7
Revenues
8
Cost of sales
9
Gross profit
10 Demand creation expense
11 Operating overhead expense
12 Total selling and administrative expense
13 Interest expense (income), net
14
Other (income) expense, net
Income before income taxes
Income tax expense
Net Income
15
16
17
18
19
B
D
Year Ended
May 31 2022 May 31 2021
46,710.00
25,231.00
21,479.00
3,850.00
10,954.00
14,804.00
205.00
-181.00
6,651.00
605.00
6,046.00
44,538.00
24,576.00
19,962.00
3,114.00
9,911.00
13,025.00
262.00
14.00
6,661.00
934.00
5,727.00
F
37,403.00
21,162.00
16,241.00
3,592.00
9,534.00
13,126.00
H
Common Sized
May 31 2020 May 31 2022 May 31 2021
89.00
139.00
2,887.00
348.00
2,539.00
J
L
N
Year over Year Change
May 31 2022 May 31 2021
Transcribed Image Text:A 1 NIKE, INC. 2 Consolidated Statement of Income 3 In $ Millions 4 5 6 7 Revenues 8 Cost of sales 9 Gross profit 10 Demand creation expense 11 Operating overhead expense 12 Total selling and administrative expense 13 Interest expense (income), net 14 Other (income) expense, net Income before income taxes Income tax expense Net Income 15 16 17 18 19 B D Year Ended May 31 2022 May 31 2021 46,710.00 25,231.00 21,479.00 3,850.00 10,954.00 14,804.00 205.00 -181.00 6,651.00 605.00 6,046.00 44,538.00 24,576.00 19,962.00 3,114.00 9,911.00 13,025.00 262.00 14.00 6,661.00 934.00 5,727.00 F 37,403.00 21,162.00 16,241.00 3,592.00 9,534.00 13,126.00 H Common Sized May 31 2020 May 31 2022 May 31 2021 89.00 139.00 2,887.00 348.00 2,539.00 J L N Year over Year Change May 31 2022 May 31 2021
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Documentation techniques
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
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