arse Costco Common Size Balance Sheet & Income Statement Assignment Due 2/3/2021 by 5PM Submit Assignmer...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
arse Costco Common Size Balance Sheet & Income Statement Assignment Due 2/3/2021 by 5PM Submit Assignmer Due Wednesday by 5pm Points 125 Submitting a file upload File Types xls, pdf, and xlsx Here is a link to Costco's 2020 Annual Report: Link To Costco 2020 10-K/Annual Report e Here is a video that shows you how to find the financial statements needed for Costco: Link You can always find the financial statements in Item 8 "Financial Statements" of a Form 10-K. 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 678 7 REVENUE 8 Net sales 9 Membership fees 10 Total revenue 11 OPERATING EXPENSES 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 21 Net income including noncontrolling interests 22 Net income attributable to noncontrolling interests 23 NET INCOME ATTRIBUTABLE TO COSTCO 24 NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO: 25 Basic 26 Diluted 27 Shares used in calculation (000's) 28 Basic 29 Diluted 30 31 32 Check To See If You Did It Correctly (Must add to 100%) 33 34 35 36 52 Weeks Ended August 30, 2020 $ $ $ $ 163,220 3,541 166,761 144,939 16,332 55 5,435 (160) 92 5,367 1,308 4,059 (57) 4,002 9.05 9.02 442,297 443,901 100.0% 3.2% 52 Weeks Ended September 1, 2019 0% $ 2.4% $ $ $ 149,351 3,352 152,703 132,886 14,994 86 4,737 (150) 178 4,765 1,061 3,704 (45) 3,659 8.32 8.26 439,755 442,923 100.0% 3.1% 52 Weeks Ended 0% September 2, 2018 $ 2,4% $ $ $ 138,434 3,142 141,576 123,152 13,876 68 4,480 (159) 121 4,442 1,263 3,179 (45) 3,134 7.15 7.09 438,515 441,834 100.0% 3.1% 2.2% 0% 1 CONSOLIDATED BALANCE SHEETS 2 3 ASSETS 4 CURRENT ASSETS 5 Cash and cash equivalents 6 Short-term investments 7 Receivables, net 8 Merchandise inventories 9 Other current assets 10 Total current assets 11 OTHER ASSETS 12 Property and equipment, net 13 Operating lease right-of-use assets 14 Other long-term assets 15 TOTAL ASSETS 16 LIABILITIES AND EQUITY 17 CURRENT LIABILITIES 18 ounts payabl 19 Accrued salaries and benefits 20 Accrued member rewards 21 Deferred membership fees 22 Current portion of long term debt 23 Other current liabilities 24 Total current liabilities 25 OTHER LIABILITIES 26 Long term debt, excluding current portion 27 Long-term operating lease liabilities 28 Other long-term liabilities 29 TOTAL LIABILITIES 30 COMMITMENTS AND CONTINGENCIES 31 EQUITY 32 Preferred stock $0.01 par value; 100,000,000 shares authorized, no shares issued and outstanding 33 Common stock $0.01 par value, 900,000,000 shares authorized; 441,255,000 and 439,625,000 shares issued a 34 Additional paid-in capital 35 Accumulated other comprehensive loss 36 Retained earnings 37 Total Costco stockholders' equity 38 Noncontrolling interests 39 Total equity 40 TOTAL LIABILITIES AND EQUITY 41 Must add up to 100% 42 43 August 30, 2020 $ $ S $ 12,277 1,028 1,550 12,242 1,023 28,120 21,807 2,788 2,841 55,556 14,172 3,605 1,393 1,851 95 3,728 24,844 7,514 2,558 1,935 36,851 6 0 4 698 (1,297) 12,879 18,284 421 18,705 55,556 51% 45% 51% $ 45% 33% September 1, 2020 33% 78% 5 $ $ 8,384 1,060 1,535 11,395 1,111 23,485 20,890 0 1,025 45,400 11,679 3,176 1,180 1,711 1,699 3,792 23,237 5,124 0 1,455) 29,816 0 4 6,417 (1.436) 10,258 15,243 341 15,584 45,400 18% 2% 3% 25% 2% 52% 52% 51% 51% 34% 34% 855 REVENUE Net sales Membership fees Total revenue OPERATING EXPENSES Merchandise costs Selling, general and administrative Preopening expenses Operating income OTHER INCOME (EXPENSE) Interest expense Interest income and other, net INCOME BEFORE INCOME TAXES Provision for income taxes Net income including noncontrolling interests Net income attributable to noncontrolling interests COSTCO WHOLESALE CORPORATION CONSOLIDATED STATEMENTS OF INCOME (amounts in millions, except per share data) NET INCOME ATTRIBUTABLE TO COSTCO NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO: Basic Diluted Shares used in calculation (000's) Basic Diluted 52 Weeks Ended August 30, 2020 163,220 3,541 166,761 144,939 16,332 55 5,435 (160) 92 5,367 1,308 4.059 (57) 4,002 9.05 9.02 442,297 443,901 $ $ $ $ 52 Weeks Ended September 1, 2019 149,351 3,352 152,703 132,886 14,994 86 4,737 (150) 178 4,765 1,061 3,704 (45) 3,659 $ 8.32 $ 8.26 $ 439,755 442,923 52 Weeks Ended September 2, 2018 138,434 3,142 141,576 123,152 13,876 68 4,480 (159) 121 4,442 1,263 3,179 (45) 3,134 7.15 7.09 438,515 441,834 arse Costco Common Size Balance Sheet & Income Statement Assignment Due 2/3/2021 by 5PM Submit Assignmer Due Wednesday by 5pm Points 125 Submitting a file upload File Types xls, pdf, and xlsx Here is a link to Costco's 2020 Annual Report: Link To Costco 2020 10-K/Annual Report e Here is a video that shows you how to find the financial statements needed for Costco: Link You can always find the financial statements in Item 8 "Financial Statements" of a Form 10-K. 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 678 7 REVENUE 8 Net sales 9 Membership fees 10 Total revenue 11 OPERATING EXPENSES 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 21 Net income including noncontrolling interests 22 Net income attributable to noncontrolling interests 23 NET INCOME ATTRIBUTABLE TO COSTCO 24 NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO: 25 Basic 26 Diluted 27 Shares used in calculation (000's) 28 Basic 29 Diluted 30 31 32 Check To See If You Did It Correctly (Must add to 100%) 33 34 35 36 52 Weeks Ended August 30, 2020 $ $ $ $ 163,220 3,541 166,761 144,939 16,332 55 5,435 (160) 92 5,367 1,308 4,059 (57) 4,002 9.05 9.02 442,297 443,901 100.0% 3.2% 52 Weeks Ended September 1, 2019 0% $ 2.4% $ $ $ 149,351 3,352 152,703 132,886 14,994 86 4,737 (150) 178 4,765 1,061 3,704 (45) 3,659 8.32 8.26 439,755 442,923 100.0% 3.1% 52 Weeks Ended 0% September 2, 2018 $ 2,4% $ $ $ 138,434 3,142 141,576 123,152 13,876 68 4,480 (159) 121 4,442 1,263 3,179 (45) 3,134 7.15 7.09 438,515 441,834 100.0% 3.1% 2.2% 0% 1 CONSOLIDATED BALANCE SHEETS 2 3 ASSETS 4 CURRENT ASSETS 5 Cash and cash equivalents 6 Short-term investments 7 Receivables, net 8 Merchandise inventories 9 Other current assets 10 Total current assets 11 OTHER ASSETS 12 Property and equipment, net 13 Operating lease right-of-use assets 14 Other long-term assets 15 TOTAL ASSETS 16 LIABILITIES AND EQUITY 17 CURRENT LIABILITIES 18 ounts payabl 19 Accrued salaries and benefits 20 Accrued member rewards 21 Deferred membership fees 22 Current portion of long term debt 23 Other current liabilities 24 Total current liabilities 25 OTHER LIABILITIES 26 Long term debt, excluding current portion 27 Long-term operating lease liabilities 28 Other long-term liabilities 29 TOTAL LIABILITIES 30 COMMITMENTS AND CONTINGENCIES 31 EQUITY 32 Preferred stock $0.01 par value; 100,000,000 shares authorized, no shares issued and outstanding 33 Common stock $0.01 par value, 900,000,000 shares authorized; 441,255,000 and 439,625,000 shares issued a 34 Additional paid-in capital 35 Accumulated other comprehensive loss 36 Retained earnings 37 Total Costco stockholders' equity 38 Noncontrolling interests 39 Total equity 40 TOTAL LIABILITIES AND EQUITY 41 Must add up to 100% 42 43 August 30, 2020 $ $ S $ 12,277 1,028 1,550 12,242 1,023 28,120 21,807 2,788 2,841 55,556 14,172 3,605 1,393 1,851 95 3,728 24,844 7,514 2,558 1,935 36,851 6 0 4 698 (1,297) 12,879 18,284 421 18,705 55,556 51% 45% 51% $ 45% 33% September 1, 2020 33% 78% 5 $ $ 8,384 1,060 1,535 11,395 1,111 23,485 20,890 0 1,025 45,400 11,679 3,176 1,180 1,711 1,699 3,792 23,237 5,124 0 1,455) 29,816 0 4 6,417 (1.436) 10,258 15,243 341 15,584 45,400 18% 2% 3% 25% 2% 52% 52% 51% 51% 34% 34% 855 REVENUE Net sales Membership fees Total revenue OPERATING EXPENSES Merchandise costs Selling, general and administrative Preopening expenses Operating income OTHER INCOME (EXPENSE) Interest expense Interest income and other, net INCOME BEFORE INCOME TAXES Provision for income taxes Net income including noncontrolling interests Net income attributable to noncontrolling interests COSTCO WHOLESALE CORPORATION CONSOLIDATED STATEMENTS OF INCOME (amounts in millions, except per share data) NET INCOME ATTRIBUTABLE TO COSTCO NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO: Basic Diluted Shares used in calculation (000's) Basic Diluted 52 Weeks Ended August 30, 2020 163,220 3,541 166,761 144,939 16,332 55 5,435 (160) 92 5,367 1,308 4.059 (57) 4,002 9.05 9.02 442,297 443,901 $ $ $ $ 52 Weeks Ended September 1, 2019 149,351 3,352 152,703 132,886 14,994 86 4,737 (150) 178 4,765 1,061 3,704 (45) 3,659 $ 8.32 $ 8.26 $ 439,755 442,923 52 Weeks Ended September 2, 2018 138,434 3,142 141,576 123,152 13,876 68 4,480 (159) 121 4,442 1,263 3,179 (45) 3,134 7.15 7.09 438,515 441,834
Expert Answer:
Answer rating: 100% (QA)
52 week ended 52 week ended 52 week ended August 312020 September 12019 September 12018 REVENUE Sales 163220 9788 149351 9780 138434 9778 Membership f... View the full answer
Related Book For
Financial Management Theory And Practice
ISBN: 978-0176583057
3rd Canadian Edition
Authors: Eugene Brigham, Michael Ehrhardt, Jerome Gessaroli, Richard Nason
Posted Date:
Students also viewed these accounting questions
-
The financial statement column should be identified as Balance Sheet Income Statement or Retained Earnings The classification column should be identified as current liabilities noncurrent liabilities...
-
Find the financial statements of a publicly traded company and review its statement of cash flows. Of the company's cash flows from operating activities, investing activities, and financing...
-
Consider the following financial statement data: Balance Sheet Income Statement Sales $100 Cost of goods sold 50 Gross profit 50 Operating expenses 14 Income from operations 36 Less: Interest 6...
-
trade on the common stock of Taz, Inc. that have a strike price of $ 51.00 and a premium of $ 1.00 . In each of the next four parts, calculate the net profit (or loss) on the option position. Note:...
-
Palm has many types of costs. What is an out-of-pocket cost? What is an opportunity cost? Are opportunity costs recorded in the accounting records?
-
If the $3 trillion the United States had spent in the stimulus package after the 2008 recession had gone into a safety net for the least well off, how much of a safety net could be provided? See the...
-
What steps to take in planning the litigation?
-
What macroenvironmental factors have affected Targets performance during that period? When you hear the term discount retail, two names that usually come to mind: Walmart and Target. The two have...
-
Question 6 (7 points) Three people are standing on a plane (the flat surface kind). The first person is standing at the origin. The second person is standing at an elevation of 3m higher, 6m [E] and...
-
Explain why errors in the valuation of inventory at the end of the year are sometimes called counterbalancing or self-correcting.
-
When calculating statistics from data, it is important to recognize when you are working with a population or a sample. In general, a population means you are working with all possible outcomes/...
-
1)What is the difference between Thread and Process? 2)What is Multi-tasking? 3)Multi-Threading? 4)Thread priority? 5)Setting and Getting Name of a thread Q) In how many ways we can prevent a thread...
-
Consider ABC stock with the following returns over the past five years: 17%, -15%, 19%, 29%, and 10%. a. What was the arithmetic average return on ABC stock over this five-year period? b-1. What was...
-
Calculate the weighted average cost of capital for Adobe Inc. based on the following weights and costs. Adobe's capital structure is 40% debt,10% preferred stock and 50% from retained earnings. The...
-
Answers to this business plan worksheet for athlete pharmacy supply store, Production How will you will produce your product or deliver your service? Describe your production methods, the equipment...
-
1) Draw a PPC and show points that are a)efficient b)unattainable and c) underutilised I 2) Your resource is 10 hrs to study, two subjects econ and English If you allocate all your time to econ you...
-
Would the world be a better place if more people adopted HAIL as their speaking mantra? What is the strength of your vocal toolbox? What vocal tool do you need to work on? What filler do you use too...
-
What is the back work ratio? What are typical back work ratio values for gas-turbine engines?
-
Qbit Technology is considering changes in its working capital policies to improve its cash flow cycle. Qbit's sales last year were $3,250,000 (all on credit), and its net profit margin was 7%. Its...
-
The market and Stock J have the following probability distributions: a. Calculate the expected rates of return for the market and Stock J. b. Calculate the standard deviations for the market and...
-
a. Describe briefly the legal rights and privileges of common shareholders. b. 1. Write out a formula that can be used to value any stock, regardless of its dividend pattern. 2. What is a constant...
-
In an audit of a corporation that has a bond issue outstanding, the trust indenture is reviewed and confirmation as to the issue is obtained from the trustee. List eight matters of importance to the...
-
Robertson Company had accounts receivable of \(\$ 200,000\) at December 31, 200X, and had provided an allowance for uncollectible accounts of \(\$ 6,000\). After performing all normal auditing...
-
Elizabeth Cole, the senior auditor-in-charge of the audit of Thorne Company, a small manufacturer, was busy writing the audit report for another engagement. Accordingly, she sent Martin Joseph, a...
Study smarter with the SolutionInn App