Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started