Costco Wholesale: A Union For Consumers (NASDAQ:COST)

Big-Box Retailer Costco To Announce First Quarter Earnings

Scott Olson

Introduction

This will be my initial article on Costco Wholesale (NASDAQ:COST) and I plan to cover it regularly in the future. I first took a look at Costco around 3 years ago, in the middle of 2019. Back then, I wondered

Chart
Data by YCharts

Chart
Data by YCharts

Overview of memberships from 2020

Memberships FY2020-2022 (Costco 10-K)

FY 2016 2017 2018 2019 2020 2021 2022
Reported revenue 118,719 129,025 141,576 152,703 166,761 195,929 226,954
(a) Add: 2% Rewards 1,172 1,281 1,394 1,537 1,707 2,047 2,307
(b) Less: Membership fees -2,646 -2,853 -3,142 -3,352 -3,541 -3,877 -4,224
Less: Merchandise costs -102,901 -111,882 -123,152 -132,886 -144,939 -170,684 -199,382
= Adjusted gross profit 14,344 15,571 16,676 18,002 19,988 23,415 25,655

Comparison of gross margins on a comparable basis

Gross margin comparison FY2016-2022 (Author – Numbers from company reports)

FY 2016 2017 2018 2019 2020 2021 2022
Reported Net Income 2,350 2,679 3,134 3,659 4,002 5,007 5,844
(a) Add: 2% Rewards 1,172 1,281 1,394 1,537 1,707 2,047 2,307
(b) Less: Membership fees -2,646 -2,853 -3,142 -3,352 -3,541 -3,877 -4,224
(c) Add: Tax effect 369 393 437 454 459 458 479
= Adjusted Net Income 1,245 1,500 1,823 2,298 2,627 3,635 4,406

Comparison of net margins on a comparable basis

Net margin comparison FY2016-2022 (Author – Numbers from company reports))

Costco Walmart
Purchases 5,514 5,514
x Net Margin 3-Y average 1.81% 2.88%
= Company net profit before annual reward 100 159
Less: 1.44% Annual Reward on purchases -80 0
= actual company profit 20 159
Add: Membership fee cost 120 0
= Total cost to consumer 140 159

FY 15 16 17 18 19 20 21 Last report
Costco 686 715 741 762 782 795 815 838
Walmart 11,528 11,695 11,718 11,361 11,501 11,443 10,593 10,586
Target 1,792 1,802 1,822 1,844 1,868 1,897 1,926 1,941

FY 15 16 17 18 19 20 21 Last report
Costco 98.7 103.2 107.3 110.7 113.9 116.1 118.9 122.5
Walmart 1,149 1,164 1,158 1,129 1,129 1,121 1,060 1,056
Target 239.5 239.5 239.4 239.6 240.5 241.6 243.3 244.0

Chart comparing revenue per store for Costco, Walmart and Target

Revenue per store FY16-FY22 (Company 10-K reports)

Chart comparing revenue per square feet

Revenue per square feet FY16-FY22 (Company 10-K reports)

Chart comparing percentage of operating costs in regard to revenue

OPEX/revenue FY16-FY22 (Numbers from company 10-K reports)

Overview of store count development NA vs. International

Number of stores (Costco 10-K reports)

Overview of international Costco stores as % of total

International stores as % of total stores (Costco 10-K reports)

Overview of EBIT-Margins for International and NA stores

EBIT-Margin: International vs. North America (Costco 10-K reports)

Chart
Data by YCharts

Locations of Costco stores in Japan

Costco Japan locations (Google Maps)

Locations of Costco stores in Korea

Costco Korea locations (Google Maps)

Table from Seeking Alpha showing net debt position

Costco net debt FY13-FY22 (Seeking Alpha – Financials)

jTable from Seeking Alpha showing Goodwill

Costco Goodwill FY13-FY22 (Seeking Alpha – Financials)

FY 2016 2017 2018 2019 2020 2021 2022 CAGR
Revenue 118,719 129,025 141,576 152,703 166,761 195,929 226,954 11.40%
EBIT 3,672 4,111 4,480 4,737 5,435 6,708 7,793 13.36%
EPS 5.33 6.08 7.09 8.26 9.02 11.27 13.14 16.24%

Overview of Net income/EBIT

Net income divided by EBIT (Author – numbers from Costco 10-K)

FY 2016 2017 2018 2019 2020 2021 2022

Capital employed in $ million

17,335 18,551 19,918 19,622 28,072 29,059 32,025
ROCE 21.2% 22.2% 22.5% 24.1% 19.4% 23.1% 24.3%

FY 2016 2017 2018 2019 2020 2021 2022 CAGR
Capital employed 17,335 18,551 19,918 19,622 28,072 29,059 32,025 10.7%
Revenue 118,719 129,025 141,576 152,703 166,761 195,929 226,954 11.4%

DCF-valuation with outlined assumptions

DCF calculation (moneychimp.com)

Be the first to comment

Leave a Reply

Your email address will not be published.


*