Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with forecasted income statement, balance sheet, and statement of cash flows. In millions, except par value Sep. 1, 2019 Sep. 2, 2018 Current

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

Please help with forecasted income statement, balance sheet, and statement of cash flows.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
In millions, except par value Sep. 1, 2019 Sep. 2, 2018 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 6.417 (1.436) 10,258 15,243 341 15.584 $45,400 4 6.107 (1.199) In millions, except par value Sep. 1, 2019 Sep. 2, 2018 Current Assets Cash and cash equivalents .................................. $ 8.384 $ 6,055 Short-term investments ..................................... 1 .060 1,204 Receivables, net .......................................... 1 .535 1 ,669 Merchandise inventories .................................... 11 .395 11,040 Other current assets ....................................... 1,111 321 Total current assets ........................................ 23,485 20,289 Property and Equipment Land ..................................................... 6,417 6,193 Buildings and improvements .................................. 17,136 16,107 Equipment and fixtures ....................................... 7.801 7,274 Construction in progress ...................................... 1 .272 1,140 Gross property and equipment ................................. 32,626 30,714 Less accumulated depreciation and amortization .................. (11,736) (11,033) Net property and equipment ................................... 20,890 19,681 Other assets ............................................... 1,025 860 Total assets ............................................... $45,400 $40,830 Consolidated Statements of Income For Year Ended ($ millions) Sep. 1, 2019 Sep. 2, 2018 Net sales .................................................. $149,351 $138,434 Membership fees ........................................... 3,352 3,142 Total revenue .............................................. 152.703 141.576 Merchandise costs .......................................... 132.886 123.152 Selling. general and administrative .............................. 14.994 13.876 Preopening expenses ........................................ 86 68 Operating income ........................................... 4.737 4.480 Interest expense ............................................ (150) (159) Interest income and other, net ................................. 178 121 Income before income taxes .................................. 4.765 4.442 Provision for income taxes .................................... 1,061 1,263 Net income including noncontrolling interests ..................... 3,704 3,179 Net income attributable to noncontrolling interests .................. (45) (45) Net income attributable to Costco .............................. $ 3.659 $ 3.134 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. What do the forecasts imply about Costco's nancing needs in 2020? 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 - Merchandise inventories - Accrued member rewards - Receivables, net - Accounts payable - 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 - Short-tenn investments - Interest expense - Preferred stock 0 interest income - Common stock - Net income attributable to noncontrolling - Accumulated other comprehensive loss interest Debt maturing in scal 2020 and 2021 is $1,699 million and $1,094 million, respectively. The company anticipates repurchasing $250 million in common stock in scal 2020. The 2019 statement of cash ows reports the following: o Depreciation expense of $1,492 million - Dividends of $1,038 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 $595 million 0 CAPEX of $2,998 million Forecast all other items as a percentage of total revenues. Nora: Round historical rates to three decimal places. For example, round 0.04556 to 4.6%

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 Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

9th edition

1-119-49356-3, 1119493633, 1119493560, 978-1119493631

More Books

Students also viewed these Accounting questions

Question

1. What does this mean for me?

Answered: 1 week ago