Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Forecast the Income Statement, Balance Sheet, and Statement of Cash Flows Following are fiscal year financial statements of Costco. COSTCO WHOLESALE CORP Consolidated Statements of

Forecast the Income Statement, Balance Sheet, and Statement of Cash Flows Following are fiscal year financial statements of Costco.

COSTCO WHOLESALE CORP
Consolidated Statements of Income
For Year Ended ($ millions) Sep. 1, 2019 Sep. 2, 2018
Net sales $179,221 $166,121
Membership fees 4,022 3,770
Total revenue 183,243 169,891
Merchandise costs 159,463 147,782
Selling, general and administrative 17,993 16,651
Preopening expenses 103 82
Operating income 5,684 5,376
Interest expense (180) (191)
Interest income and other, net 214 145
Income before income taxes 5,718 5,330
Provision for income taxes 1,273 1,516
Net income including noncontrolling interests 4,445 3,814
Net income attributable to noncontrolling interests (54) (54)
Net income attributable to Costco $4,391 $3,760

COSTCO WHOLESALE CORP
Consolidated Balance Sheets
In millions, except par value Sep. 1, 2019 Sep. 2, 2018
Current Assets
Cash and cash equivalents $10,062 $7,265
Short-term investments 1,272 1,445
Receivables, net 1,842 2,003
Merchandise inventories 13,674 13,248
Other current assets 1,333 385
Total current assets 28,183 24,346
Property and Equipment
Land 7,700 7,432
Buildings and improvements 20,563 19,328
Equipment and fixtures 9,361 8,729
Construction in progress 1,526 1,368
Gross property and equipment 39,150 36,857
Less accumulated depreciation and amortization (14,083) (13,240)
Net property and equipment 25,067 23,617
Other assets 1,230 1,032
Total assets $54,480 $48,995
Current Liabilities
Accounts payable $14,015 $13,484
Accrued salaries and benefits 3,811 3,593
Accrued member rewards 1,416 1,268
Deferred membership fees 2,053 1,949
Current portion of long-term debt 2,039 108
Other current liabilities 4,550 3,509
Total current liabilities 27,884 23,911
Long-term debt, excluding current portion 6,149 7,784
Other liabilities 1,746 1,577
Total liabilities 35,779 33,272
Equity
Preferred stock $.01 par value;
100,000,000 shares authorized*
Common stock $0.01 par value;
900,000,000 shares authorized** 5 5
Additional paid-in capital 7,700 7,328
Accumulated other comprehensive loss (1,723) (1,439)
Retained earnings 12,310 9,464
Total Costco stockholders' equity 18,292 15,358
Noncontrolling interests 409 365
Total equity 18,701 15,723
Total liabilities and equity $54,480 $48,995

*no shares issued and outstanding ** 527,550,000 and 525,826,800 shares issued and outstanding

Required Forecast Costcos income statement, balance sheet, and statement of cash flows for the year ended September 1, 2020. Combine all property and equipment accounts into Net property and equipment. Forecasts assumptions Forecast Net sales and Membership fees using their respective historical growth rates (2018 to 2019). Forecast the following as a percentage of Net sales: Merchandise costs Receivables, net Merchandise inventories Accounts payable Accrued member rewards Forecast income tax as 23% of pretax income Forecast Deferred membership fees as a percentage of Membership fees. Assume no change in the balance of the following: Preopening expenses Interest expense Interest income Net income attributable to noncontrolling interest Short-term investments Preferred stock Common stock Accumulated other comprehensive loss Debt maturing in fiscal 2020 and 2021 is $2,039 million and $1,313 million, respectively. The company anticipates repurchasing $300 million in common stock in fiscal 2020. The 2019 statement of cash flows reports the following: Depreciation expense of $1,790 million Dividends of $1,246 million (to forecast 2020 dividends, use the 2019 dividend payout ratio as a percentage of net income attributable to Costco shareholders) Stock-based compensation (a noncash expense that is included in SG&A expense and is added to Additional paid-in capital) of $714 million CAPEX of $3,598 million Forecast all other items as a percentage of total revenues. Note: Round historical rates used in calculations to three decimal places. For example, assume that Actual Merchandise inventories divided Actual Net sales equals 0.076297. This factor should be rounded to 7.6% before computing your forecasted amount for Merchandise inventories. Note: Round your final answers below to the nearest whole dollar.

NOTE: No additional information has been provided.

COSTCO WHOLESALE CORP
Forecasted Income Statement
For the year ended
Sep. 01, 2020
$ millions Forecast
Net sales Answer
Membership fees Answer
Total revenues Answer
Expenses
Merchandise cost Answer
Selling, general and administrative Answer
Preopening expenses Answer
Operating income Answer
Interest expense Answer
Interest income and other, net Answer
Income before income taxes Answer
Provision for income taxes Answer
Net income including noncontrolling interests Answer
Net income attributable to noncontrolling Answer
Net income attributable to Costco Answer

COSTCO WHOLESALE CORP
Balance Sheet
Sep. 01, 2020
$ millions Forecast
Cash and cash equivalents Answer
Short-term investments Answer
Receivables, net Answer
Merchandise inventories Answer
Other current assets Answer
Total current assets Answer
Net property and equipment Answer
Other assets Answer
Total assets Answer
Accounts payable Answer
Accrued salaries and benefits Answer
Accrued member rewards Answer
Deferred memberships fees Answer
Current portion of long-term debt Answer
Other current liabilities Answer
Total current liabilities Answer
Long term debt, excluding current portion Answer
Other liabilities Answer
Total liabilities Answer
Preferred stock Answer
Common stock Answer
Additional paid-in capital Answer
Accumulated other comprehensive loss Answer
Retained earnings Answer
Treasury stock Answer
Total Costco stockholders' equity Answer
Noncontrolling interests Answer
Total equity Answer
Total liabilities and equity Answer

COSTCO WHOLESALE CORP
Forecasted Statement of Cash Flow
For the year ended Sep. 01, 2020
$ millions Forecast
Net income including noncontrolling interests Answer
Add: Depreciation Answer
Add: Stock-based compensation Answer
Receivables, net Answer
Merchandise inventories Answer
Other current assets Answer
Other assets Answer
Accounts payable Answer
Accrued salaries and benefits Answer
Accrued member rewards Answer
Deferred membership fees Answer
Other current liabilities Answer
Other liabilities Answer
Net cash from operating activities Answer
Capital Expenditures Answer
Net cash from investing activities Answer
Dividends Answer
Change in current maturities of L-T debt Answer
Change in L-T Debt Answer
Stock repurchases Answer
Net cash from financing activities Answer
Net change in cash Answer
Beginning cash Answer
Ending cash Answer

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

Financial And Managerial Accounting For MBAs

Authors: Peter D. Easton

6th Edition

1618533592, 9781618533593

More Books

Students also viewed these Accounting questions

Question

Describe the Gestalt approach to the mind brain problem.

Answered: 1 week ago

Question

Determine the derivative of the following functi y = 3 +9vx dy dx

Answered: 1 week ago