Answered step by step
Verified Expert Solution
Link Copied!

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.image text in transcribed

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,017

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategy, Value And RiskThe Real Options Approach

Authors: J. Rogers

2nd Edition

0230577377, 9780230577374

More Books

Students also viewed these Accounting questions

Question

Describe briefly how a digital camera operates.

Answered: 1 week ago

Question

What was the positive value of Max Weber's model of "bureaucracy?"

Answered: 1 week ago