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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!