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
-
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.
-
Calculate the present value of each of the following future payments. (For some of these problems you may wish to use the online calculator available at...
-
Green Co . issued $ 4 0 0 , 0 0 0 of 1 2 % , 1 0 year bonds on January 1 at 9 8 . Interest is payable semiannually on July 1 and January 1 . What would be included in the accrual journal entry on...
-
The axes of the pipes are in a vertical plane. The flow rate is \(2.83 \mathrm{~m}^{3} / \mathrm{s}\) of water. Calculate the magnitude, direction, and location of the resultant force of the water on...
-
In August 2010, Michael Dell, Dell Inc.'s CEO and chairman of the board, was reelected to Dell's board of directors by Dell's shareholders. However, not all of the shareholders were happy with Mr....
-
A virtual directory is a directory used in a Web site that corresponds to a physical directory elsewhere on the server, on another server, or on a Web site. This allows you to reuse the same folder...
-
Garry is a partner in an accounting firm in Sydney. Garry is currently looking at his portfolio of new Australian clients which include: 1. ABC Superannuation Fund, a corporate fund that manages...
-
Describe the procedure for examining a hypothesis related to proportions of two independent samples.
-
How can the strength of association be measured in a multiple regression model?
-
You are calling on a very large company that has the potential to become your largest customer. How could your sales manager help you be successful in negotiations with this potential customer?
-
What are the advantages of systematic sampling over simple random sampling?
-
What is the major advantage of snowball sampling?
-
In the hope of high returns, venture capitalists provide funds to finance new (start up) companies. However, potential competitors and structures of the market into which the new firm enters are...
-
Define a traverse in Surveying?
-
The damping ratio for a SDOF system with viscous damping is always positive. Indicate whether the statement presented is true or false. If true, state why. If false, rewrite the statement to make it...
-
A critically damped system has a natural frequency of \(10 \mathrm{rad} / \mathrm{s}\). Which of the following sets of initial conditions leads to the system overshooting the equilibrium position?...
-
Consider the differential equation \[ \ddot{x}+2 \zeta \omega_{n} \dot{x}+\omega_{n}^{2} x=0 \] Define in words and in terms of system parameters \(m\), \(c\), and \(k\) for (a) \(\omega_{n}\) and...
Study smarter with the SolutionInn App