From essays to dissertations, we have experts for all of your assignments!

dot
  • 1.provide your instructions
  • 2.choose an expert in your field
  • 3.track the order progress

Costco.xlsx

Sheet1

Consolidated Statements Of Income – USD ($) shares in Thousands, $ in MillionsCOSTCO Wholesales CorporationConsolidated Balance Sheets – USD ($) $ in Millions202120202019
202120202019CURRENT ASSETS
REVENUECash and cash equivalents$ 11,258$ 12,277$ 8,384
Total revenue$ 195,929$ 166,761$ 152,703Short-term investments9171,028$ 1,060
OPERATING EXPENSESReceivables, net1,8031,550$ 1,535
Merchandise costs170,684144,939132,886Merchandise inventories14,21512,242$ 11,395
Selling, general and administrative18,46116,33214,994Other current assets1,3121,023$ 1,111
Preopening expenses765586Total current assets29,50528,120$ 23,485
Operating Income6,7085,4354,737OTHER ASSETS
OTHER INCOME (EXPENSE)Property and Equipment, net23,49221,80720,890
Interest expense(171)(160)(150)Operating lease right-of-use assets2,8902,7880
Interest income and other, net14392178Other long-term assets3,3812,8411,025
INCOME BEFORE INCOME TAXES6,6805,3674,765TOTAL ASSETS59,26855,55645,400
Income Tax Expense1,6011,3081,061CURRENT LIABILITIES
Net income including noncontrolling interests5,0794,0593,704Accounts payable16,27814,17211,679
Net income attributable to noncontrolling interests(72)(57)(45)Accrued salaries and benefits4,0903,6053,176
NET INCOME ATTRIBUTABLE TO COSTCO$ 5,007$ 4,002$ 3,659Accrued member rewards1,6711,3931,180
NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO:Deferred membership fees2,0421,8511,711
Basic (in dollars per share)$ 11.30$ 9.05$ 8.32Current portion of long-term debt799951,699
Diluted (in dollars per share)$ 11.27$ 9.02$ 8.26Other current liabilities4,5613,7283,792
Weighted Average Number of Shares Outstanding, Diluted [Abstract]Total current liabilities29,44124,84423,237
Basic (shares)443,089442,297439,755OTHER LIABILITIES
Diluted (shares)444,346443,901442,923Long-term debt, excluding current portion6,6927,5145,124
Net salesLong-term operating lease liabilities2,6422,558
REVENUEOther long-term liabilities2,4151,9351455
Total revenue$ 192,052$ 163,220$ 149,351Total liabilities41,19036,85129,816
Membership feesEQUITY
REVENUEPreferred stock000
Total revenue$ 3,877$ 3,541$ 3,352Common Stock444
Additional paid-in capital7,0316,6986,417
Accumulated other comprehensive loss(1,137)(1,297)(1,436)
Retained earnings11,66612,87910,258
Total Costco stockholders' equity17,56418,28415,243
Noncontrolling interests514421341
Total equity18,07818,70515,584
TOTAL LIABILITIES AND EQUITY$ 59,268$ 55,556$ 45,400
COSTCO WHOLESALE CORPORATION
DATA FROM STATEMENTS OF INCOME ( in million )
202120202019Change % in 2021Change in amount 2021Change % in 2020Change in amount in 2022
Net Sales$192,052$163,220$149,35118%$28,8329%$13,869
Less merchandise costs$170,684$144,939$132,88618%$25,7459%$12,053
Gross Profit$21,368$18,281$16,465
Gross Profit Margin11.13%11.20%11.02%-1%-$02%$0
Total Revenue$195,929$166,761$152,70317%$29,1689%$14,058
Net Profit Margin2.6%2.4%2.4%6%0.000%0.00
Operating Income$195,929$166,761$152,70317%$29,1689%$14,058
Interest Expenses-$171-$160-$1507%-$117%-$10
Interest Income and other$143$92$17855%$51-48%-$86
Non operating Income-$28-$68$28-59%$40-343%-$96
Net Income Before Taxes$6,680$5,367$4,76524%$1,31313%$602
Net Income$5,007$4,002$3,65925%$1,0059%$343
Earing per Share$11.27$9.05$8.2625%$2.2210%$0.79
Income tax rate24%24%22%-2%0.099%0.02
COSTCO WHOLESALE CORPORATION
DATA FROM BALANCE SHEETS ( in million )
202120202019Change % in 2021Change in amount 2021Change % in 2020Change in amount in 2022
Current Assets$29,505$28,120$23,4854.9%$1,38519.7%$4,635
Total Assets$59,268$55,556$45,4006.7%$3,71222.4%$10,156
Current Liabilities$29,441$24,844$23,23718.5%$4,5976.9%$1,607
Total Liabilities$41,190$36,851$29,81611.8%$4,33923.6%$7,035
Debt to Total Assets Ratio0.690.660.664.8%0.031.0%0.01
Book Value$18,078$18,705$15,584-3.4%-$627.0020.0%$3,121.00
Current Ratio1.001.131.01-11.5%-0.1312.0%$0.12
You can leave a response, or trackback from your own site.

Leave a Reply

Powered by WordPress | Designed by: Premium WordPress Themes | Thanks to Themes Gallery, Bromoney and Wordpress Themes