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 $134,416 $124,591
Membership fees 3,017 2,828
Total revenue 137,433 127,419
Merchandise costs 119,597 110,837
Selling, general and administrative 13,495 12,488
Preopening expenses 77 61
Operating income 4,264 4,033
Interest expense (135) (143)
Interest income and other, net 160 109
Income before income taxes 4,289 3,999
Provision for income taxes 955 1,137
Net income including noncontrolling interests 3,334 2,862
Net income attributable to noncontrolling interests (41) (41)
Net income attributable to Costco $3,293 $2,821

COSTCO WHOLESALE CORP
Consolidated Balance Sheets
In millions, except par value Sep. 1, 2019 Sep. 2, 2018
Current Assets
Cash and cash equivalents $7,545 $5,450
Short-term investments 954 1,084
Receivables, net 1,382 1,502
Merchandise inventories 10,256 9,936
Other current assets 1,000 289
Total current assets 21,137 18,261
Property and Equipment
Land 5,775 5,574
Buildings and improvements 15,422 14,496
Equipment and fixtures 7,021 6,547
Construction in progress 1,145 1,026
Gross property and equipment 29,363 27,643
Less accumulated depreciation and amortization (10,562) (9,930)
Net property and equipment 18,801 17,713
Other assets 923 774
Total assets $40,861 $36,748
Current Liabilities
Accounts payable $10,511 $10,113
Accrued salaries and benefits 2,858 2,695
Accrued member rewards 1,062 951
Deferred membership fees 1,540 1,462
Current portion of long-term debt 1,529 81
Other current liabilities 3,413 2,632
Total current liabilities 20,913 17,934
Long-term debt, excluding current portion 4,612 5,838
Other liabilities 1,310 1,183
Total liabilities 26,835 24,955
Equity
Preferred stock $.01 par value;
100,000,000 shares authorized*
Common stock $0.01 par value;
900,000,000 shares authorized** 4 4
Additional paid-in capital 5,775 5,496
Accumulated other comprehensive loss (1,292) (1,079)
Retained earnings 9,232 7,098
Total Costco stockholders' equity 13,719 11,519
Noncontrolling interests 307 274
Total equity 14,026 11,793
Total liabilities and equity $40,861 $36,748

*no shares issued and outstanding ** 395,662,500 and 394,370,100 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 $1,529 million and $985 million, respectively. The company anticipates repurchasing $225 million in common stock in fiscal 2020. The 2019 statement of cash flows reports the following: Depreciation expense of $1,343 million Dividends of $934 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 $536 million CAPEX of $2,698 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.

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

Please insert answer where it says "Answer"

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Intermediate Accounting

Authors: J. David Spiceland, James Sepe, Mark Nelson

6th edition

978-0077400163

Students also viewed these Accounting questions