Big-Box Retailer Costco To Announce First Quarter Earnings

Scott Olson

Introduction

This can be my preliminary article on Costco Wholesale (NASDAQ:COST) and I plan to cowl it commonly sooner or later. I first took a take a look at Costco round 3 years in the past, in the course of 2019. Again then, I questioned

Chart
Knowledge by YCharts

Chart
Knowledge by YCharts

Overview of memberships from 2020

Memberships FY2020-2022 (Costco 10-Ok)

FY 2016 2017 2018 2019 2020 2021 2022
Reported income 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) Much less: Membership charges -2,646 -2,853 -3,142 -3,352 -3,541 -3,877 -4,224
Much less: Merchandise prices -102,901 -111,882 -123,152 -132,886 -144,939 -170,684 -199,382
= Adjusted gross revenue 14,344 15,571 16,676 18,002 19,988 23,415 25,655

Comparison of gross margins on a comparable basis

Gross margin comparability FY2016-2022 (Creator – Numbers from firm stories)

FY 2016 2017 2018 2019 2020 2021 2022
Reported Web Revenue 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) Much less: Membership charges -2,646 -2,853 -3,142 -3,352 -3,541 -3,877 -4,224
(c) Add: Tax impact 369 393 437 454 459 458 479
= Adjusted Web Revenue 1,245 1,500 1,823 2,298 2,627 3,635 4,406

Comparison of net margins on a comparable basis

Web margin comparability FY2016-2022 (Creator – Numbers from firm stories))

Costco Walmart
Purchases 5,514 5,514
x Web Margin 3-Y common 1.81% 2.88%
= Firm internet revenue earlier than annual reward 100 159
Much less: 1.44% Annual Reward on purchases -80 0
= precise firm revenue 20 159
Add: Membership charge value 120 0
= Complete value to shopper 140 159

FY 15 16 17 18 19 20 21 Final 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
Goal 1,792 1,802 1,822 1,844 1,868 1,897 1,926 1,941

FY 15 16 17 18 19 20 21 Final 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
Goal 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

Income per retailer FY16-FY22 (Firm 10-Ok stories)

Chart comparing revenue per square feet

Income per sq. ft FY16-FY22 (Firm 10-Ok stories)

Chart comparing percentage of operating costs in regard to revenue

OPEX/income FY16-FY22 (Numbers from firm 10-Ok stories)

Overview of store count development NA vs. International

Variety of shops (Costco 10-Ok stories)

Overview of international Costco stores as % of total

Worldwide shops as % of complete shops (Costco 10-Ok stories)

Overview of EBIT-Margins for International and NA stores

EBIT-Margin: Worldwide vs. North America (Costco 10-Ok stories)

Chart
Knowledge by YCharts

Locations of Costco stores in Japan

Costco Japan places (Google Maps)

Locations of Costco stores in Korea

Costco Korea places (Google Maps)

Table from Seeking Alpha showing net debt position

Costco internet debt FY13-FY22 (Searching for Alpha – Financials)

jTable from Seeking Alpha showing Goodwill

Costco Goodwill FY13-FY22 (Searching for Alpha – Financials)

FY 2016 2017 2018 2019 2020 2021 2022 CAGR
Income 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

Web earnings divided by EBIT (Creator – numbers from Costco 10-Ok)

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%
Income 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)



Source link