Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compute the 2015 common size income statement and the common size balance sheet for Starbucks and dunkin Donuts in excel. Use the inancial statements from

Compute the 2015 common size income statement and the common size balance sheet for Starbucks and dunkin Donuts in excel. Use the inancial statements from market watch.

Sales/Revenue 810.93M
Cost of Goods Sold (COGS) incl. D&A 206.63M
COGS excluding D&A 161.39M
Depreciation & Amortization Expense 45.24M
Depreciation 20.56M
Amortization of Intangibles 24.69M
Gross Income 604.3M
2015
SG&A Expense 246.6M
Research & Development -
Other SG&A 246.6M
Other Operating Expense -
Unusual Expense 72.68M
EBIT after Unusual Expense 285.03M
Non Operating Income/Expense 2.49M
Non-Operating Interest Income 424,000
Equity in Affiliates (Pretax) 12.56M
Interest Expense 98.91M
Gross Interest Expense 98.91M
Interest Capitalized -
Pretax Income 201.59M
Income Tax 96.36M
Income Tax - Current Domestic 114.28M
Income Tax - Current Foreign 3.19M
Income Tax - Deferred Domestic (22.09M)
Income Tax - Deferred Foreign 987,000
Income Tax Credits -
Equity in Affiliates -
Other After Tax Income (Expense) -
Consolidated Net Income 105.23M
Minority Interest Expense 2,000
Net Income 105.23M
Extraordinaries & Discontinued Operations -
Extra Items & Gain/Loss Sale Of Assets -
Cumulative Effect - Accounting Chg -
Discontinued Operations -
Net Income After Extraordinaries 105.23M
Preferred Dividends -
Net Income Available to Common 105.23M
EPS (Basic) 1.1
Basic Shares Outstanding 96.05M
EPS (Diluted) 1.08
Diluted Shares Outstanding 97.13M
EBITDA 402.95M

Assets
Fiscal year is January-December. All values USD millions. 2015
Cash & Short Term Investments 332.35M
Cash Only 332.35M
Short-Term Investments -
Total Accounts Receivable 128.36M
Accounts Receivables, Net 53.14M
Accounts Receivables, Gross 59.78M
Bad Debt/Doubtful Accounts (6.63M)
Other Receivables 75.22M
Inventories -
Finished Goods -
Work in Progress -
Raw Materials -
Progress Payments & Other -
Other Current Assets 97.12M
Miscellaneous Current Assets 73.22M
Total Current Assets 557.82M
2015
Net Property, Plant & Equipment 182.61M
Property, Plant & Equipment - Gross 294.24M
Buildings 49.3M
Land & Improvements 33.35M
Computer Software and Equipment -
Other Property, Plant & Equipment 154.48M
Accumulated Depreciation 111.63M
Total Investments and Advances 106.88M
Other Long-Term Investments -
Long-Term Note Receivable -
Intangible Assets 2.29B
Net Goodwill 889.59M
Net Other Intangibles 1.4B
Other Assets 59.01M
Tangible Other Assets 53.21M
Total Assets 3.2B
Liabilities & Shareholders' Equity
2015
ST Debt & Current Portion LT Debt 25.55M
Short Term Debt -
Current Portion of Long Term Debt 25.55M
Accounts Payable 18.66M
Income Tax Payable -
Other Current Liabilities 374.58M
Dividends Payable -
Accrued Payroll 29.54M
Miscellaneous Current Liabilities 345.04M
Total Current Liabilities 418.79M
Long-Term Debt 2.43B
Long-Term Debt excl. Capitalized Leases 2.42B
Non-Convertible Debt 2.42B
Convertible Debt -
Capitalized Lease Obligations 7.5M
Provision for Risks & Charges 9.1M
Deferred Taxes 476.51M
Deferred Taxes - Credit 476.51M
Deferred Taxes - Debit -
Other Liabilities 85.36M
Other Liabilities (excl. Deferred Income) 69.74M
Deferred Income 15.62M
Total Liabilities 3.42B
Non-Equity Reserves -
Preferred Stock (Carrying Value) -
Redeemable Preferred Stock -
Non-Redeemable Preferred Stock -
Common Equity (Total) (220.95M)
Common Stock Par/Carry Value 92,000
Retained Earnings (1.08B)
ESOP Debt Guarantee -
Cumulative Translation Adjustment/Unrealized For. Exch. Gain (20.46M)
Unrealized Gain/Loss Marketable Securities -
Revaluation Reserves -
Treasury Stock (1.08M)
Total Shareholders' Equity (220.95M)
Accumulated Minority Interest 208,000
Total Equity (220.74M)
Liabilities & Shareholders' Equity 3.2B

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

The Complete Guide To Spotting Accounting Fraud And Cover-Ups

Authors: Martha Maeda

1st Edition

160138212X, 978-1601382122

More Books

Students also viewed these Accounting questions