Homework Help is Here – Start Your Trial Now!
Business
Accounting
While follwoing the intructions, can you fill up the board in the second picture?

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

Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter26: Capital Budgeting (capbud)
Section: Chapter Questions
Problem 2R
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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.
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
Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
SEE MORE TEXTBOOKS