Here is a link to Costco's 2020 Annual Report: Link To Costco 2020 10-K/Annual Report (Links to an external site.)

Here is a video that shows you how to find the financial statements needed for Costco: Link (Links to an external site.)

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

A B D G H 1 K M N 0 Q R S T V August 30, 2020 September 1. 2019 September 2, 2018 $ 163,220 3,541 156,760 57.95 2.1% 100.0% 149,351 97.80% 3,352 2.2% 152,703 100.0% 138,434 97.80 3.142 2.2% 141,576 100.0% Input formulato calculate the of each items as a X af Total Revenues Formulas or amounts if done with a calculator should only be entered in the yellow highlighted cells 123,152 13,976) 144,939 16,332 55 5,435 132,885 14,994 85 4,737 4,490 REVENUE Net sales Membership fees Total revenue OPERATING EXPENSES Merchandise COATS Selling general and acministrative Preceningerne Operating income OTHER INCOME (EXPENSE) Interest cxparse Interest income and other, ne INCOME BEFORE INCOME TAXES Provision for income taxes Net Income including noncontrolling interest Net income attributable to noncontrolling interests NET INCOME ATTRIBUTABLE TO COSTCO NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO Basic Diluted Shares used in calculation (00051 Basic 3.2% 3.19 (150) 92 5,357 1,308 4,055 (57) 4,002 1501 17B 4,765 1,061 3,704 145 3,659 (159) 121 4,442 1,263 3,179 145) 3,134 $ 2.4% 24 $ 2.2% $ 7.15 9.05 9.02 5 S R.32 9.26 $ $ $ 7.09 442,297 143,901 439,735 112,323 439,513 441,834 Dilute! Check To Sce If You Did it correctly Must add to 100%) 0% Conton Innamma Stotomont hon Blanche A B D G H 1 K M N 0 Q R S T V August 30, 2020 September 1. 2019 September 2, 2018 $ 163,220 3,541 156,760 57.95 2.1% 100.0% 149,351 97.80% 3,352 2.2% 152,703 100.0% 138,434 97.80 3.142 2.2% 141,576 100.0% Input formulato calculate the of each items as a X af Total Revenues Formulas or amounts if done with a calculator should only be entered in the yellow highlighted cells 123,152 13,976) 144,939 16,332 55 5,435 132,885 14,994 85 4,737 4,490 REVENUE Net sales Membership fees Total revenue OPERATING EXPENSES Merchandise COATS Selling general and acministrative Preceningerne Operating income OTHER INCOME (EXPENSE) Interest cxparse Interest income and other, ne INCOME BEFORE INCOME TAXES Provision for income taxes Net Income including noncontrolling interest Net income attributable to noncontrolling interests NET INCOME ATTRIBUTABLE TO COSTCO NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO Basic Diluted Shares used in calculation (00051 Basic 3.2% 3.19 (150) 92 5,357 1,308 4,055 (57) 4,002 1501 17B 4,765 1,061 3,704 145 3,659 (159) 121 4,442 1,263 3,179 145) 3,134 $ 2.4% 24 $ 2.2% $ 7.15 9.05 9.02 5 S R.32 9.26 $ $ $ 7.09 442,297 143,901 439,735 112,323 439,513 441,834 Dilute! Check To Sce If You Did it correctly Must add to 100%) 0% Conton Innamma Stotomont hon Blanche