Calculate following ratios and measures for Starbucks and Dunkin Donuts and compare them.

The data you need to make the calculations is on the attached excel sheet in the first 6 tabs. Do not use your own data. The calculations need to be in the excel sheet on the last tab and need to be entered in the form of a formula. Do not copy and paste your answers please. For each ratio, comment on how it would be viewed relative to the competitor. You cannot just say that a ratio is higher than average or lower than average; you must explain WHAT the ratio means and WHY the value would be viewed either positively or negatively.

Here are the ratios that you will need to calculate:

Measuring Financial Leverage - Long term Solvency Measures

1. Long Term Debt Ratio
2. Long Term Debt-Equity Ratio
3. Total Debt Ratio
4. Times Interest Earned
5. Cash Coverage Ratio

Growth measures:

1. Payout Ratio
2. Sustainable Growth

Starbucks Balance Sheet (Values in 000's) Period Ending 10/2/2016 9/27/2015 Current Assets Cash and Cash Equivalents $2,128,800 $1,530,100 Short-term Investments $134,400 $81,300 Net Receivables $768,800 $719,000 Inventory $1,378,500 $1,306,400 Other Current Assets $350,000 $334,200 Total Current Assets $4,760,500 $3,971,000 Long Term Assets Long-Term Investments $1,496,200 $664,500 Fixed Assets $4,533,800 $4,088,300 Goodwill $1,719,600 $1,575,400 Intangible Assets $516,300 $520,400 Other Assets $417,700 $415,900 Deferred Asset Charges $885,400 $1,180,800 Total Assets $14,329,500 $12,416,300 Current Liabilities Accounts Payable $2,975,700 $2,664,300 Short-Term Debt $0 $400,000 Other Current Liabilities $1,171,200 $983,800 Total Current Liabilities $4,546,900 $3,648,100 Long-Term Debt $3,202,200 $2,347,500 Other Liabilities $689,700 $600,900 Deffered Liability Charges $0 $0 Misc Stocks $0 $0 Minority Interest $6,700 $1,800 Total Liabilities $8,445,500 $6,598,300 Stock Holders Equity Common Stocks $1,500 $1,500 Capial Surplus $41,100 $41,100 Retained Earnings $5,949,800 $5,974,800 Treasury Stock $0 $0 Other Equity ($108,400) ($199,400) Total Equity $5,884,000 $5,818,000 Total Liabilities & Equity $14,329,500 $12,416,300 Starbucks Income Statement Period Ending: Total Revenue Cost of Revenue Gross Profit Operating Expenses Research and Development Sales, General and Admin Non-recurring items Other Operating Income Operating Income Add'l Income/expense items Earnings Before Interest and Tax Interest Expense Earning Before Tax Income Tax Minority Interest Equity Earnings/Loss Unconsolidated Subsidary Net Income-Cont. Operations Net Income Net Income Applicable to Common Shareholders (Values in 000's) 10/2/2016 9/27/2015 $21,315,900 $19,162,700 $8,511,100 $7,787,500 $12,804,800 $11,375,200 $0 $0 $7,970,300 $7,130,200 $0 $0 $980,800 $893,900 $4,171,900 $3,601,000 $108,000 $372,500 $4,279,900 $3,973,500 $81,300 $70,500 $4,198,600 $3,903,000 $1,379,700 $1,143,700 ($1,200) ($1,900) $318,200 $249,900 $3,135,900 $2,946,200 $2,817,700 $2,757,400 $2,817,700 $2,757,400 Statement of Cash Flows (Values in 000's) Period Ending: 10/2/2016 9/27/2015 Net Income $2,817,700 $2,757,400 Cash Flows-Operating Activities Depreciation $1,030,100 $933,800 Net Income Adjustments $373,100 ($222,800) Changes in Operating Activities Accounts Receivable ($55,600) ($82,800) Changes in Inventory ($67,500) ($207,900) Other Operating Activities $248,800 $261,500 Liabilities $227,300 $308,000 Net Cash Flow-Operating $4,575,100 $3,749,100 Cash Flows-Investing Activities Capital Expenditures ($1,440,300) ($1,303,700) Investments ($807,500) $60,900 Other Investing Activities $24,900 ($277,500) Net Cash Flow-Investing ($2,222,900) ($1,520,300) Cash Flows-Financing Activities Sale and Purchase of Stock ($1,834,900) ($1,605,100) Net Borrowings $1,254,500 $238,400 Other Financing Activities ($114,400) ($93,600) Net Cash Flows-Financing ($1,750,000) ($2,256,500) Effect of Exchange Rate ($3,500) ($150,600) Net Cash Flow $598,700 ($178,300) Dunkin Donuts Balance Sheet (Values in 000's) Period Ending 12/31/2016 12/26/2015 Current Assets Cash and Cash Equivalents $471,509 $370,901 Short-term Investments $0 $0 Net Receivables $85,184 $128,360 Inventory $0 $0 Other Current Assets $49,665 $58,563 Total Current Assets $606,358 $557,824 Long Term Assets Long-Term Investments $114,738 $106,878 Fixed Assets $176,662 $182,614 Goodwill $888,272 $889,588 Intangible Assets $1,378,720 $1,401,208 Other Assets $62,632 $59,007 Deferred Asset Charges $0 $0 Total Assets $3,227,382 $3,197,119 Current Liabilities Accounts Payable $64,953 $68,852 Short-Term Debt $25,589 $25,546 Other Current Liabilities $333,659 $324,394 Total Current Liabilities $424,201 $418,792 Long-Term Debt $2,409,548 $2,428,097 Other Liabilities $82,927 $78,844 Deffered Liability Charges $473,964 $492,129 Misc Stocks $0 $0 Minority Interest $0 $208 Total Liabilities $3,390,640 $3,417,862 Stock Holders Equity Common Stocks $91 $92 Capial Surplus $807,492 $876,557 Retained Earnings ($945,797) ($1,076,479) Treasury Stock ($1,060) ($1,075) Other Equity ($23,984) ($20,046) Total Equity ($163,258) ($220,951) Total Liabilities & Equity $3,227,382 $3,196,911 Dunkin Donuts Income Statement Period Ending: Total Revenue Cost of Revenue Gross Profit Operating Expenses Research and Development Sales, General and Admin Non-recurring items Other Operating Income Operating Income Add'l Income/expense items Earnings Before Interest and Tax Interest Expense Earning Before Tax Income Tax Minority Interest Equity Earnings/Loss Unconsolidated Subsidary Net Income-Cont. Operations Net Income Net Income Applicable to Common Shareholders (Values in 000's) 12/31/2016 12/26/2015 $828,889 $810,933 $135,017 $131,488 $693,872 $679,445 $0 $0 $251,024 $272,266 $149 $623 $42,537 $45,244 $414,714 $319,567 ($613) ($21,214) $414,101 $298,353 $100,852 $96,765 $313,249 $201,588 $195,576 $105,229 $117,673 $96,359 $0 ($2) $14,552 ($41,745) $210,128 $42,928 $195,576 $105,227 $195,576 $105,227 Dunkin Donuts Statement of Cash Flow (Values in 000's) Period Ending: 12/31/2016 12/26/2015 Net Income $195,576 $105,227 Cash Flows-Operating Activities Depreciation $48,935 $51,213 Net Income Adjustments ($16,153) $66,979 Changes in Operating Activities Accounts Receivable $40,535 ($26,316) Changes in Inventory $0 $0 Other Operating Activities $4,328 ($59,644) Liabilities $2,984 $48,105 Net Cash Flow-Operating $276,205 $185,566 Cash Flows-Investing Activities Capital Expenditures ($15,174) ($30,246) Investments $0 $0 Other Investing Activities $16,517 ($5,221) Net Cash Flow-Investing $1,343 ($35,467) Cash Flows-Financing Activities Sale and Purchase of Stock ($44,353) ($614,688) Net Borrowings ($24,894) $655,406 Other Financing Activities ($122) ($7,211) Net Cash Flows-Financing ($176,337) ($96,856) Effect of Exchange Rate ($216) ($893) Net Cash Flow $100,995 $52,350 Measuring Financial Leverage - Long term Solvency Measures Long Term Debt Ratio Long Term Debt-Equity Ratio Total Debt Ratio Times Interest Earned Cash Coverage Ratio Growth Measures Payout Ratio Sustainable Growth