Question: Using Excel, how do you calculate WACC for Starbucks using data from their Form 10-K? Consolidated Balance Sheets - USD ($) $ in Millions Sep.
Using Excel, how do you calculate WACC for Starbucks using data from their Form 10-K?
| Consolidated Balance Sheets - USD ($) $ in Millions | Sep. 30, 2018 | Oct. 01, 2017 |
| Current assets: | ||
| Cash and cash equivalents | $ 8,756.3 | $ 2,462.3 |
| Short-term investments | 181.5 | 228.6 |
| Accounts receivable, net | 693.1 | 870.4 |
| Inventories | 1,400.5 | 1,364 |
| Prepaid Expense and Other Assets, Current | 1,462.8 | 358.1 |
| Total current assets | 12,494.2 | 5,283.4 |
| Long-term investments | 267.7 | 542.3 |
| Equity and cost investments | 334.7 | 481.6 |
| Property, plant and equipment, net | 5,929.1 | 4,919.5 |
| Deferred income taxes, net | 134.7 | 795.4 |
| Other long-term assets | 412.2 | 362.8 |
| Other intangible assets | 1,042.2 | 441.4 |
| Goodwill | 3,541.6 | 1,539.2 |
| TOTAL ASSETS | 24,156.4 | 14,365.6 |
| Current liabilities: | ||
| Accounts payable | 1,179.3 | 782.5 |
| Accrued liabilities | 2,298.4 | 1,934.5 |
| Insurance reserves | 213.7 | 215.2 |
| Stored value card liability | 1,642.9 | 1,288.5 |
| Current portion of long-term debt | 349.9 | 0 |
| Total current liabilities | 5,684.2 | 4,220.7 |
| Long-term debt | 9,090.2 | 3,932.6 |
| Deferred Revenue, Noncurrent | 6,775.7 | 4.4 |
| Deferred Tax and Other Liabilities, Noncurrent | 1,430.5 | 750.9 |
| Total liabilities | 22,980.6 | 8,908.6 |
| Shareholders' equity: | ||
| Common stock ($0.001 par value) - authorized, 2,400.0 shares; issued and outstanding, 1,460.5 and 1,485.1 shares, respectively | 1.3 | 1.4 |
| Additional paid-in capital | 41.1 | 41.1 |
| Retained earnings | 1,457.4 | 5,563.2 |
| Accumulated other comprehensive income/(loss) | (330.3) | (155.6) |
| Total shareholders' equity | 1,169.5 | 5,450.1 |
| Noncontrolling interests | 6.3 | 6.9 |
| Total equity | 1,175.8 | 5,457 |
| TOTAL LIABILITIES AND EQUITY | $ 24,156.4 | $ 14,365.6 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
