FINANCE COURSE PROJECT

profilevictoria.32
ratio_analysis.xlsx

Sheet1

Starbucks Corporation
Current assets:
Cash and cash equivalents 1,708.40
Short-term investments 135.4
Accounts receivable, net 631
Inventories 1,090.90
Prepaid expenses and other current assets 285.6
Deferred income taxes, net 317.4
Total current assets 4,168.70
Long-term investments 318.4
Equity and cost investments 514.9
Property, plant and equipment, net 3,519.00
Deferred income taxes, net 903.3
Other assets 198.9
Other intangible assets 273.5
Goodwill 862.9 856.2
TOTAL ASSETS 10,752.90
LIABILITIES AND EQUITY
Current liabilities:
Accounts payable $ 533.7
Accrued litigation charge
Accrued liabilities 1,514.40
Insurance reserves 196.1
Deferred revenue 794.5
Total current liabilities 3,038.70
Long-term debt, 2,048.30
Other long-term liabilities 392.2
Total liabilities 5,479.20
Shareholders’ equity:
Common stock ($0.001 par value) — authorized, 1,200.0 shares; issued and
outstanding, 749.5 and 753.2 shares, respectively 0.7 0.8
Additional paid-in capital 39.4 282.1
Retained earnings 5,206.60
Accumulated other comprehensive income 25.3 67.0
Total shareholders’ equity 5272.4
Noncontrolling interest 1.7 2.1
Total equity 5,273.7 4,482.3
TOTAL LIABILITIES AND EQUITY $ 10,752.9 $ 11,516.7
income statement
Net revenues:
Company-operated stores 11793.2
Licensed stores 1360.5
CPG, foodservice and other 1713.1
Total net revenues 14866.8
net sales 6382.3
Store operating expenses 4286.1
Other operating expenses 431.8
Depreciation and amortization expenses 621.4
General and administrative expenses 9379
Litigation charge 27841
Total operating expenses 15443.6
Income from equity investees 251.4
Operating income/(loss) 325.4
Interest income and other, net 123.6
Interest expense 28.1
Earnings/(loss) before income taxes 299.9
Income tax expense/(benefit) 238.7
Net earnings/(loss) including noncontrolling interests 8.8
Net earnings/(loss) attributable to noncontrolling interests 0.5
Net earnings/(loss) attributable to Starbucks 8.3
curent ratio 1.3718695495
quick ratio 1.1288708987
inventory turnover ratio 5.8504904208
Receivables Turnover 3.2461172742
Days Sales Outstanding 112.442025094
Fixed Asset Turnover 1.8136686559
Total Asset Turnover 0.5935422072
Gross Profit Margin 0.7381978183
Operating Profit Margin 0.0509847547
Net Profit Margin 0.1471413127
Return on Assets 0.2252740663
Return on Equity 0.1781162279
Debt/Net Worth 5,000.20
Debt Ratio 0.5095555618
Times-Interest-Earned 4.3985765125
DUNKIN’ BRANDS GROUP, INC.
Assets
Current assets:
Cash and cash equivalents
Accounts receivable, net 47,162
Notes and other receivables, net 32,603
Assets held for sale 1,663
Deferred income taxes, net 46,461
Restricted assets of advertising funds 31,493
Prepaid income taxes 25,699
Prepaid expenses and other current assets 19,746
Total current assets 461,760
Property and equipment, net 182,858
Equity method investments 170,644
Goodwill 891,598
Other intangible assets, net 1,452,205
Restricted cash 305 367
Other assets 75,320
Total assets 3,234,690
Liabilities, Redeemable Noncontrolling Interests, and Stockholders’ Equity
Current liabilities:
Current portion of long-term debt 5,000
Capital lease obligations 432
Accounts payable 12,445
Liabilities of advertising funds 49,077
Deferred income 28,426
Other current liabilities 248,918
Total current liabilities 344,298
Long-term debt, net 1,818,609
Capital lease obligations 6,996
Unfavorable operating leases acquired 16,834
Deferred income 11,135
Deferred income taxes, 561,714
Other long-term liabilities 62,816
Total long-term liabilities 2,478,104
Commitments and contingencies (note 17)
Redeemable noncontrolling interests 4,930
Stockholders’ equity:
Total liabilities, redeemable noncontrolling interests, and stockholders' equity $ 3,234,690 3,217,513
Additional paid-in capital 1,196,426
Treasury stock, at cost 10,773
Accumulated deficit 779,741
Accumulated other comprehensive income 1,339
Total stockholders’ equity of Dunkin' Brands 407,358
Noncontrolling interests -
Total stockholders' equity 407,358
Total liabilities, redeemable noncontrolling interests, and stockholders' equity 3,234,690
Revenues:
Franchise fees and royalty income 418,940
Rental income 96,816
Sales of ice cream products 94,659
Sales at company-owned restaurants 22,922
Other revenues 24,844
Total revenues 658,181
Operating costs and expenses:
Occupancy expenses—franchised restaurants 52,072
Cost of ice cream products 69,019
Company-owned restaurant expenses 23,133
General and administrative expenses, net 239,574
Depreciation 29,084
Amortization of other intangible assets 26,943
Long-lived asset impairment charges 1,278
Total operating costs and expenses 441,103
Net income (loss) of equity method investments:
Net income, excluding impairment 22,351
Impairment charge, net of tax
Total net income (loss) of equity method investments 22,351
Other operating income, net — -
Operating income 239,429
Other income (expense):
Interest income 543
Interest expense 74,031
Loss on debt extinguishment and refinancing transactions 3,963
Other gains (losses), net 23 175
Total other expense 77,428
Income before income taxes 162,001
Provision for income taxes 54,377
Net income including noncontrolling interests 107,624
Net loss attributable to noncontrolling interests 684
Net income attributable to Dunkin' Brands 108,308
curent ratio 1.3411637593
quick ratio 0.1418102922
inventory turnover ratio 41.5027059531
Receivables Turnover 2.4931300623
Days Sales Outstanding 9.4655475696
Fixed Asset Turnover 3.5994104715
Total Asset Turnover 0.0363500057
Gross Profit Margin 0.9471946147
Operating Profit Margin 1.3777821247
Net Profit Margin 0.915317951
Return on Assets 0.0332718128
Return on Equity 0.265879153
Debt/Net Worth -695,619
Debt Ratio 0.7661024704
Times-Interest-Earned 2.1882859883