What do you estimate the Starbuck's WACC based on the attached financial excel spreadsheet?

Starbucks Introduction: Prepared By Travis Martin Prepared By Zachary Reed Prepared By Shakila Reid Prepared by Whitney Stewart Pertinent Data for Calculating Financial Ratios prepared by Janet O'Hallaron 2013 2014 2015 Book Value per Share 0.8 1.5 0.7 Common Equity 4,480,200 5,272,000 5,818,000 6,382,800 6,858,800 7,787,500 Cost of Goods Sold Current Assets 4,168,700.00 4,352,700 5,471,400 Current Liabilities 5,377,300 3,038,700 3,653,500 Earnings Before Interest and Taxes -257,100 3,223,800 3,973,500 See page 25 of 2015 annual re Earnings per share diluted 0.01 1.35 1.82 basic 0.01 1.37 1.84 Interest Charges 28,100 64,100 70,500 Inventories 1,111,200 1,090,900 1,306,400 Market price per share See below Price per share 4th Quarter High 39.41 40.32 59.32 4th Quarter Low 38.93 36.89 42.05 Net Fixed Assets 3,200,500 3,519,000 4,088,300 Net Income Available to Common Stockholders 8,300,000 2,068,100 2,757,400 Pulled from http://www.nasdaq.com/symbol/sbux/financials?query=income-statement Net Revenues/Sales 14,892,200 16,447,800 19,162,700 See page 19,30 & 46 of 2015 A Receivables 561,400 631,000 719,000 Total Assets Total Debts 11,516,700 10,752,900 7,034,400 5,479,200 12,446,100 See page 19 of 2015 Annual R 6,626,300 Assumptions *Interest expense is the same thing as interest charges. *To compute EBIT, I added the interest expense to the Earning before income taxes on Starbucks Consolidated Statement of Ea *I am assuming that net fixed assets is the same as property, plant, and equipment,net *Cost of Goods sold was taken from NSDAQ information on the market watch website. *I am assuming total liabilities is the same as total debt. * I am assuming that common equity is the same as shareholder's equity. * I am assuming that net earnings is the same as sales and annual sales. * I am assuming that comprehensive income attributable to Starbucks is the same as Net Income Available to Shareholders Financial Ratios for Starbucks based on 2013-2015 Financial Data 2013 2014 2015 Indstry '15 Liquidity Ratios Current Current Assets/Current Liabilities 0.775240362 1.43242176 1.497577665 1.13 Data for industry average obtained from Starbucks 2013 data of concern because it is a figure less than 1. https://www.stock-analysis-on.net/NASDAQ/Company/Starbucks-Corp/Ratios/Liquidity Quick Ratio Current Assets - Inventories/Current Liabilities 0.568593904 1.07341955 1.140002737 0.58 Data for industry average obtained from The higher the quick ratio the better the company's liquidity position. https://www.stock-analysis-on.net/NASDAQ/Company/Starbucks-Corp/Ratios/Liquidity Asset Management Ratios Total Assets Turnover 1.293096113 1.52961527 1.539654992 1.44 Sales/Total Assets Starbuck's yearly increase in this ratio is a good sign because it indicates they are earning m Data for industry average obtained from revenue from their assets, thus operating m https://www.stock-analysis-on.net/NASDAQ/Company/Starbucks-Corp/Ratios/Long-term-Investment-Activity Fixed Assets Turnover 4.653085455 4.67399829 4.687204951 4.52 Sales/Net Fixed Assets Data for industry average obtained from https://www.stock-analysis-on.net/NASDAQ/Company/Starbucks-Corp/Ratios/Long-term-Investment-Activity Days Sales Outstanding (DSO) Receivables/Annual Sales/365 Data for industry average obtained from http://www.creditguru.com/ratios/inr.htm 0.000103281 0.00010511 0.000102797 1 industry average so Starbucks collects its receivables fas average. Inventory Turnover 5.744060475 6.28728573 5.961037967 8.56 Cost of Goods Sold/Inventories industry average indicates that Starbucks is slower than Data for industry average obtained from turning over its inventory. https://www.stock-analysis-on.net/NASDAQ/Company/Starbucks-Corp/Ratios/Short-term-Operating-Activity Debt Management Ratios Debt to Assets Ratio Total Debt/Total Assets 0.610799969 0.50955556 0.532399708 3.69 Data for industry average obtained from http://csimarket.com/Industry/industry_Financial_Strength_Ratios.php?ind=914 See Leverage ratio data Times Interest Earned (TIE) -9.149466192 50.2932917 51.82269504 22.59 Earnings Before Interest & Taxes/Interest charges Starbucks 2014 & 2015 figures are good as they are high Data for industry average obtained from industry average which means a lower burden on Starbu http://csimarket.com/Industry/industry_Financial_Strength_Ratios.php?ind=914 debt expenses (i.e.-principal & Identified as interest coverage ratio on this site Profitability Ratios Profit Margin on Sales Net Income Available to Common Stockholders/Sales 0.557338741 0.12573718 0.143894128 5.01 Data for industry average obtained from Profit margin is lower than the industry average which i https://www.zacks.com/stock/research/SBUX/industry-comparison Basic Earning Power (BEP) Earnings Before Interests and Taxes/Assets -0.022324103 50.2932917 51.82269504 Unable to find an industry comparison 2014 and 2015 ratios are encouraging highe show that the company is more effective at increasing ea their assets. Return on Total Assets (ROA) Net Income Available to Common Stockholders/Total Assets 0.72069256 0.19232951 0.143894128 4% Data for industry average obtained from industry average. http://csimarket.com/Industry/industry_ManagementEffectiveness.php?ind=914 Return on Common Equity (ROE) Net Income Available to Common Stockholders/Common Equity 1.852595866 0.39227997 0.473942936 9.95 18.52 39.23 47.39 Data for industry average obtained from https://www.zacks.com/stock/research/SBUX/industry-comparison Market Value Ratios 29.4306569 32.23913043 Price/Earnings (P/E) Ratio 3941 29.4306569 32.23913043 Price per Share/ Earning per share 39.41 29.43 32.23 Used Basic earnings per share and 4th quarter high price Data for industry average obtained from https://www.zacks.com/stock/research/SBUX/industry-comparison Market Book (M/B) Ratio Market Price per Share/Book Value per Share 48.6625 24.5933333 60.07142857 Used 4th quarter low price Data for industry average obtained from https://www.zacks.com/stock/research/SBUX/industry-comparison 28.35 3.01 ee page 25 of 2015 annual report ee page 19,30 & 46 of 2015 Annual Report ee page 19 of 2015 Annual Report Consolidated Statement of Earnings. Available to Shareholders Comments/Comparison to Industry Ratio Good higher than industry average is a figure less than 1. Good higher than industry average ompany's liquidity position. Good higher than industry average indicates they are earning more heir assets, thus operating more efficiencly. ment-Activity Good higher than industry average. rm-Investment-Activity Good because it is lower than the ks collects its receivables faster than the industry Poor a lower turnover ratio than hat Starbucks is slower than average in ting-Activity Good lower ratios indicates lower debt res are good as they are higher than ans a lower burden on Starbucks for their debt expenses (i.e.-principal & interest payments. the industry average which is not a good sign. ratios are encouraging higher ratios more effective at increasing earnings from ders/Total Assets Poor since lower than ndustry average. ders/Common Equity Good since higher than industry average. Good since higher than industry average. Good since higher than industry average