Complete the common-size Balance Sheet for 2020 & 2019 and the Income Statement 2020, 2019 and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Complete the common-size Balance Sheet for 2020 & 2019 and the Income Statement 2020, 2019 and 2018 (areas highlighted in yellow must be completed for each worksheet and will need either: 1) Excel formulas or 2) the number inputted that you derived for each item using a calculator). I encourage you all to try and learn how to use the simple formula in Excel. Here is the worksheet template: Costco Ratio & CS Project Student Worksheet Spring 2021.xlsx Ratio Analysis Summary PDF to use for Ratio Calculations: Ratio Analysis Summary.pdf 4 5 6 7 REVENUE 8 Net sales 9 Membership fees 10 Total revenue 11 OPERATING EXPENSES 52 Weeks Ended 52 Weeks Ended August 30, 2020 September 1, 2019 52 Weeks Ended September 2, 2018 $ 163,220 $ 149,351 $ 3,541 3,352 138,434 3,142 166,761 100.0% 152,703 100.0% 141,576 100.0% 12 Merchandise costs 13 Selling, general and administrative 14 Preopening expenses 15 Operating income 16 OTHER INCOME (EXPENSE) 17 Interest expense 18 Interest income and other, net 19 INCOME BEFORE INCOME TAXES 20 Provision for income taxes 144,939 132,886 123,152 16,332 14,994 13,876 55 86 68 5,435 4,737 4,480 (160) (150) (159) 92 178 121 5,367 3.2% 4,765 3.1% 4,442 3.1% 1,308 1,061 1,263 21 Net income including noncontrolling interests 4,059 3,704 3,179 22 Net income attributable to noncontrolling interests (57) (45) (45) 23 NET INCOME ATTRIBUTABLE TO COSTCO $ 4,002 2.4% $ 3,659 2.4% $ 3,134 2.2% 24 NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO 25 Basic $ 9.05 $ 8.32 $ 7.15 26 Diluted $ 9.02 $ 8.26 $ 7.09 27 Shares used in calculation (000's) 28 Basic 29 Diluted 442,297 443,901 439,755 442,923 438,515 441,834 30 31 32 Check To See If You Did It Correctly (Must add to 100%) 33 34 35 36 0% 06 0% REVENUE Net sales Membership fees Total revenue OPERATING EXPENSES COSTCO WHOLESALE CORPORATION CONSOLIDATED STATEMENTS OF INCOME (amounts in millions, except per share data) 52 Weeks Ended August 30, 2020 163,220 $ 52 Weeks Ended September 1, 2019 52 Weeks Ended 3,541 166,761 149,351 $ 3,352 152,703 September 2, 2018 138,434 3,142 141,576 Merchandise costs 144,939 132,886 Selling, general and administrative 16,332 Preopening expenses 55 Operating income OTHER INCOME (EXPENSE) Interest expense Interest income and other, net INCOME BEFORE INCOME TAXES Provision for income taxes 5,435 4,737 14,994 86 123,152 13,876 4,480 68 (160) (150) (159) 92 178 121 5,367 4,765 4,442 1.308- 1,061 1,263 Net income including noncontrolling interests Net income attributable to noncontrolling interests NET INCOME ATTRIBUTABLE TO COSTCO 4,059 3,704 3,179 (57) (45) 4,002 $ 3,659 (45) 3,134 NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO: Basic Diluted Shares used in calculation (000's) Basic Diluted 9.05 $ 8.32 $ 7.15 9.02 $ 8.26 $ 7.09 442,297 443,901 439,755 442,923 438,515 441,834 Complete the common-size Balance Sheet for 2020 & 2019 and the Income Statement 2020, 2019 and 2018 (areas highlighted in yellow must be completed for each worksheet and will need either: 1) Excel formulas or 2) the number inputted that you derived for each item using a calculator). I encourage you all to try and learn how to use the simple formula in Excel. Here is the worksheet template: Costco Ratio & CS Project Student Worksheet Spring 2021.xlsx Ratio Analysis Summary PDF to use for Ratio Calculations: Ratio Analysis Summary.pdf 4 5 6 7 REVENUE 8 Net sales 9 Membership fees 10 Total revenue 11 OPERATING EXPENSES 52 Weeks Ended 52 Weeks Ended August 30, 2020 September 1, 2019 52 Weeks Ended September 2, 2018 $ 163,220 $ 149,351 $ 3,541 3,352 138,434 3,142 166,761 100.0% 152,703 100.0% 141,576 100.0% 12 Merchandise costs 13 Selling, general and administrative 14 Preopening expenses 15 Operating income 16 OTHER INCOME (EXPENSE) 17 Interest expense 18 Interest income and other, net 19 INCOME BEFORE INCOME TAXES 20 Provision for income taxes 144,939 132,886 123,152 16,332 14,994 13,876 55 86 68 5,435 4,737 4,480 (160) (150) (159) 92 178 121 5,367 3.2% 4,765 3.1% 4,442 3.1% 1,308 1,061 1,263 21 Net income including noncontrolling interests 4,059 3,704 3,179 22 Net income attributable to noncontrolling interests (57) (45) (45) 23 NET INCOME ATTRIBUTABLE TO COSTCO $ 4,002 2.4% $ 3,659 2.4% $ 3,134 2.2% 24 NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO 25 Basic $ 9.05 $ 8.32 $ 7.15 26 Diluted $ 9.02 $ 8.26 $ 7.09 27 Shares used in calculation (000's) 28 Basic 29 Diluted 442,297 443,901 439,755 442,923 438,515 441,834 30 31 32 Check To See If You Did It Correctly (Must add to 100%) 33 34 35 36 0% 06 0% REVENUE Net sales Membership fees Total revenue OPERATING EXPENSES COSTCO WHOLESALE CORPORATION CONSOLIDATED STATEMENTS OF INCOME (amounts in millions, except per share data) 52 Weeks Ended August 30, 2020 163,220 $ 52 Weeks Ended September 1, 2019 52 Weeks Ended 3,541 166,761 149,351 $ 3,352 152,703 September 2, 2018 138,434 3,142 141,576 Merchandise costs 144,939 132,886 Selling, general and administrative 16,332 Preopening expenses 55 Operating income OTHER INCOME (EXPENSE) Interest expense Interest income and other, net INCOME BEFORE INCOME TAXES Provision for income taxes 5,435 4,737 14,994 86 123,152 13,876 4,480 68 (160) (150) (159) 92 178 121 5,367 4,765 4,442 1.308- 1,061 1,263 Net income including noncontrolling interests Net income attributable to noncontrolling interests NET INCOME ATTRIBUTABLE TO COSTCO 4,059 3,704 3,179 (57) (45) 4,002 $ 3,659 (45) 3,134 NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO: Basic Diluted Shares used in calculation (000's) Basic Diluted 9.05 $ 8.32 $ 7.15 9.02 $ 8.26 $ 7.09 442,297 443,901 439,755 442,923 438,515 441,834
Expert Answer:
Related Book For
Auditing A Practical Approach
ISBN: 9780730382645
4th Edition
Authors: Robyn Moroney, Fiona Campbell, Jane Hamilton
Posted Date:
Students also viewed these finance questions
-
Assuming the use of special journals, the sale of merchandise to Jerri Wiles on account would be recorded in the
-
Explain how Linux script files are similar or different than batch files? Does the Linux user created have a secure location to store files? Explain how one Linux user can share data with another...
-
ECON 374 PROJECT -- PART 2 Financial Ratios Common sire balance sheet for 2021 Cash and equivalents Total current liabilities Student name here NWC to total assets Inventory Long-term debt Firm name...
-
Given: MIII; Prove: M Use the definitions and postulates given in Example 2 to prove the theorems in Problems 914. Give both statements and reasons.
-
Go to the Global Economic Crisis Resource Center. Select Global Issues in Context. In the Basic Search box at the top of the page, enter the phrase "Whose Concept Was It, Anyway." On the Results...
-
Multiple-Choice Questions 1. More American law comes from one country than from any other. Which country? (a) France (b) England (c) Germany (d) Spain (e) Canada 2. Under the United States...
-
Discuss the variables of the marketing mix (product, price, promotion, and distribution) as they might relate to each of the following: a. A trucking company b. A mens clothing store c. A skating...
-
On the next page is the net income of Anita Ferreri Instrument Co., a private corporation, computed under the three inventory methods using a periodic system. Instructions (Ignore tax...
-
"Study Says Coffee May Reduce Risk of Liver Disease" was a headline that appeared in USA Today. This conclusion was based on data from 494,000 people in the UK Biobank, a biomedical database The...
-
Neo Airconditioner Sdn Bhd primarily sells and installs air conditioner. As well as supplies air conditioners, it also provide air conditioner repair and services to its customers. The business...
-
Describe a leader that reflects Simon Sinek's philosophy of why leaders eat last. Do you plan on being a leader? Are you one now? Do you exhibit of the ideas shared in the video?
-
. In this scenario, each employee has to travel a lot for a company's business. So, the company decides to have a rule to compensate for the miles they travel. The company will pay 40 cents for the...
-
What does it mean that a corporation is considered a legal person under the law?
-
A company's old machine has a book value of $47,000 and a remaining three-year useful life. The old machine could be sold now for $25,900, and the company could buy a new machine for $68,500. The old...
-
Tasty Meat Inc. uses ABC costing to allocate the manufacturing overhead costs incurred by producing tasty pork ribs. The following activities related to yearly manufacturing overhead costs, and cost...
-
literature review on innovation in logistics , impact on performance
-
Compile data on consumption and expenditures for the following categories in 30 different countries: (1) food and beverages, (2) clothing and footwear, (3) housing and home operations, (4) household...
-
Three bases of position power are ____________. (a) reward, expertise, and coercive power (b) legitimate, experience, and judgment power (c) knowledge, experience, and judgment power (d) reward,...
-
What are power and influence?
-
What are the key sources of power and influence?
Study smarter with the SolutionInn App