Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please review the statements, and solve for the accounts. Forecast the Income Statement, Balance Sheet, and Statement of Cash Flows Following are fiscal year financial

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

please review the statements, and solve for the accounts.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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) Sept 1, 2019 Sep. 2, 2018 Net sales $74,676 $69,217 Membership fees 1,676 1,571 Total revenue 76,352 70,788 Merchandise costs 66,443 61,576 Selling, general and administrative 7,497 6,938 Preopening expenses 7 V N N 437 7 N N V 34 Operating incorne 7 7 7 7' 7' 7 7 7' 2,369 2,240 Interest expense (75) (80) Interest income and other, net 89 61 Income before income taxes 2,383 2,221 Provision for income taxes 531 632 Net income including noncontrolling interests 1,852 1,589 Net income attributable to noncontrolling interests (23) (23) Net income attributable to Costco $1,829 $1,566 COSTCO WHOLESALE CORP Consolidated Balance Sheets In millions, except par value Sep. 1, 2019 Sep. 2, 2018 Current Assets ' ' Cash and cash equivalents ' $4,192 ' $3,028 Short-term investments ' 530 l 602 Receivables, net ' 768 l 835 Merchandise inventories ' 5,698 ' 5,520 Other current assets ' 556 l 161 Total current assets ' 11,744 ' 10,146 Property and Equipment ' ' Land i 3,209 i 3,097 Buildings and improvements i 8,568 i 8.054 Equipment and fixtures 3,901 3,637 Construction in progress 636 570 Gross property and equipment 16,314 15,358 Less accumulated depreciation and amortization (5,868) (5,517) Net property and equipment 10,446 9,841 Other assets 513 430 Total assets $22,703 $20,417 Current Liabilities Accounts payable $5,840 $5,619 Accrued salaries and benefits 1,588 1,497 Accrued member rewards 590 529 Deferred membership fees 856 812 Current portion of long-term debt 850 45 Other current liabilities 1,896 1,462 Total current liabilities 11,620 9,964 Long-term debt, excluding current portion 2,562 3,244 Other liabilities 728 657 Total liabilities 14,910 13,865 Equity Preferred stock $.01 par value; 100,000,000 shares authorized" Common stock $0.01 par value; 900,000,000 shares authorizedM 2 2 Additional paid-in capital 3,209 3,054 Accumulated other comprehensive loss (718) (600) Retained earnings 5,129 3,944 Total Costco stockholders' equity 7,622 6,400 Noncontrolling interests 171 152 Total equity 7,793 6,552 Total liabilities and equity $22,703 $20,417 *no shares issued and outstanding ** 219,812,500 and 219,094,500 shares issued and outstanding Required Forecast Costco's 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 $850 million and $547 million, respectively. The company anticipates repurchasing $125 million in common stock in scal 2020. The 2019 statement of cash flows reports the following: - Depreciation expense of $746 million - Dividends of $519 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 $298 million ' CAPEX of $1,499 million Forecast all other items as a percentage of total revenues. Note: Round historical rates used in calculations to three decimal places. For example, round 0.04556 to 0.046 or 4.6%. Nnre' Rnllnd \\mlir final answer: helnw tn the nearest whnle rlnllar Note: Round historical rates used in calculations to three decimal places. For example, round 0.04556 to 0.046 or 4.6%. Note: Round your final answers below to the nearest whole dollar. COSTCO WHOLESALE CORP Forecasted Income Statement For the year ended Sep. 01, 2020 $ m Forecast Net sales $ 0 Membership fees 0 Total revenues 0 Expenses Merchandisecost 7 r 7 r 7 0 Selling, general and administrative 7 0 Preopening expenses 0 Operating income 0 Interest expense 0 Interest income and other, net 0 Income before income taxes 0 Provision for income taxes 0 Net income including noncontrolling interests 0 Net income attributable to noncontrolling 0 Net income attributable to Costco $ 0 COSTCO WHOLESALE CORP Balance Sheet Sep. 01, 2020 Forecast Cash and cash equivalents $ Short-term investments ' Receivables, net ' Merchandise inventories Other current assets 000000 Total cu rrent assets Net property and equipment Other assets Total assets Accounts payable Accrued salaries and benefits Accrued member rewards Deferred memberships fees Current portion of long-term debt Other current liabilities Total current liabilities Long term debt, excluding current portion Other liabilities Total liabilities Preferred stock Common stock Additional paidin capital Accumulated other comprehensive loss Retained earnings Treasury stock Total Costco stockholders' equity Noncontrolling interests Total equity Total liabilities and equity $ oooooooooooo'ooooooooooo COSTCO WHOLESALE CORP Forecasted Statement of Cash Flow Sep. 01, 2020 For the year ended 5 millions Net income including noncontrolling interests Forecast Add: Depreciation Add: Stock-based compensation Receivables, net Merchandise inventories Other current assets oooooo Other current assets Other assets Accounts payable Accrued salaries and benefits Accrued member rewards Deferred membership fees Other current liabilities Other liabilities Net cash from operating activities Capital Expenditures Net cash from investing activities Dividends Change in current maturities of L-T debt Change in L-T Debt Stock repurchases Net cash from financing activities Net change in cash Beginning cash Ending cash ooooooooooooooooooo

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

Payroll Accounting 2018

Authors: Jeanette Landin, Paulette Schirmer

4th edition

1260005127, 1259742514, 1260005165, 126000516X, 978-1259742514

More Books

Students also viewed these Accounting questions

Question

2. The purpose of the acquisition of the information.

Answered: 1 week ago

Question

1. What is the meaning of the information we are collecting?

Answered: 1 week ago