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 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%