Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Construct a common size balance sheet using the following data in excel. Sep. 01, 2019 Sep. 02, 2018 Sep. 03, 2017 Aug 28,201 Aug 30,2015
Construct a common size balance sheet using the following data in excel.
Sep. 01, 2019 Sep. 02, 2018 Sep. 03, 2017 Aug 28,201 Aug 30,2015 $ 8,384 1,060 1,535 11,395 1,111 23,485 $6,055 1,204 1,669 11,040 321 20,289 $ 4,546 $ 1,233 $ 1,432 $9,834 $ 272 $ 17,317 $ 3,379 1,350 1,252 8,969 268 15,218 $ 4,801 1,618 1,224 8.908 228 16,779 4,961 12,618 5,274 6,417 17,136 7,801 1,272 32,626 (11,736) 20,890 1,025 45,400 811 6,193 16,107 7,274 1,140 30,714 ( 11,033) 19,681 860 40,830 $5,690 $ 15,127 $ 6,681 $ 843 $ 28,341 $(10,180) $ 18,161 $ 8,690 $36,347 5,395 13,994 6,077 701 26,167 19,124) 17,043 23,664 18,263) 15,401 837 33,017 902 33,163 Consolidated Balance Sheets - USD ($) $ in Millions CURRENT ASSETS Cash and cash equivalents Short-term investments Receivables, net Merchandise inventories Other current assets Total current assets PROPERTY AND EQUIPMENT Land Buildings and improvements Equipment and fixtures Construction in progress Gross property and equipment Less accumulated depreciation and amortization Net property and equipment OTHER ASSETS TOTAL ASSETS CURRENT LIABILITIES Accounts payable Accrued salaries and benefits Accrued member rewards Deferred membership fees Current portion of long-term debt Other current liabilities Total current liabilities LONG-TERM DEBT, excluding current portion OTHER LIABILITIES Total liabilities EQUITY Preferred stock $.01 par value; 100,000,000 shares authorized; no shares issued and outstanding Common stock $0.01 par value: 900,000,000 shares authorized; 439,625,000 and 438,189,000 shares issued and outstanding Additional paid-in capital Accumulated other comprehensive loss Retained earnings Total Costco stockholders' equity Noncontrolling interests Total equity TOTAL LIABILITIES AND EQUITY 11,679 3,176 1,180 1,711 1,699 3,792 23,237 5,124 1,455 29,816 11,237 2.994 1.057 1624 90 2.924 19,926 6,487 1,314 27.727 $ 9,608 $ 2,703 $ 9.610 $ 1,498 $ 860 $ 17,495 $ 6,573 $ 5,673 $ 1,200 $ 25,268 7,612 2,629 869 1,362 1,100 2003 15,575 4,061 1,195 20,831 9,011 2,468 813 1,269 1,283 1,695 16,539 4,852 783 22.174 $4 2 2 6,417 (1,436) 10,258 15,243 341 15,584 $ 45,400 6,107 (1.199) 7,887 12.799 304 13,103 $ 40,830 $5,800 $ 11,014) $ 5,988 $ 10,778 $ 301,000,000 $ 11,079 $36,347 5,490 (1,099) 7,686 12,079 253 12,332 $ 33,163 5,218 (1.121 6,518 10,617 226 10,843 $33,017Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started