Question

А 12 Months Ended Oct. 01, 2017 Oct 02, 2016 Sep 30, 2018 $ 22,386.8 9,034.3 6,493.3 500.3 1,011.4 1,450.7 153.5 18,643.5 391.4 4,134.7 1 Consolidated Statements of Earnings - USD ($) shares in Millions, $ in Millions 2 3 Net Revenues 4 Revenues 5 Cost of sales including occupancy costs 6 Store operating expenses 7 Other operating expenses 8 Depreciation and amortization expenses 9 General and administrative expenses 10 Restructuring Charges 11 Total operating expenses 12 Income from equity investees 13 Operating income 14 Gain resulting from acquisition of joint venture 15 Gain (Loss) on Disposition of Business 16 Interest Income and other, net 17 Interest expense 18 Earnings before income taxes 19 Income Tax Expense (Benefit) 20 Net earnings including noncontrolling interests 21 Net earnings/(oss) attributable to noncontrolling interests 22 Net earnings attributable to Starbucks 23 Earnings Per Share, Basic 24 Earnings Per Share, Diluted 25 Weighted average shares outstanding 26 Basic 27 Diluted 28 Company operated stores (Member) 29 Net Revenues: 30 Revenues 31 Licensed stores (Member) 32 Net Revenue 33 Revenues 34 Product and Service, Other (Member) 35 Net Revenues: 36 Revenues 37 38 39 40 41 $ 24,719.5 10,174.5 7,193.2 539.3 1,247 1,759 224,4 21,137.4 301.2 3,883.3 1,376.4 499.2 191.4 (170.3) 5,780 1,262 4,518 (0.3) $ 4,518.3 $ 3.27 $ 3.24 $ 21,315.9 8,509 6,064.3 499.2 980.8 1,408.9 0 17,462.2 318.2 4,171.9 0 5.4 102.6 (81.3) 4,198.6 1,379.7 2,818.9 1.2 $ 2,817.7 $1.91 $ 1.90 93.5 181.8 192.5) 4,317.5 1,432.6 2,884.9 0.2 $2,884.7 $ 1.99 $1.97 1,382.7 1,394,6 1,449.5 1,461.5 1,471.6 1,486.7 $ 19,690.3 $ 17,650.7 $ 16,844.1 2,652.2 2,355 2,154.2 + $2,377 $ 2,381.1 $ 2,317.6

create an excel file with worksheet named ratio.

attached in the first picthrw is consolidated statement of earn and in the second pic consolidated balance sheets.

thank you!

need it asap

Answer 1

Since we can't attach an Excel sheet here, I am calculating the ratios as requested in the question for fiscal year 2018.

Current Ratio = Total Current Assets / Total Current Liabilities = 12,494.2 / 5,684.2 = 2.20

Cash Ratio = Cash and Cash Equivalents / Total Current Liabilities = 8,756.3 / 5,684.2 = 1.54

Inventory Turnover = Sales / Average Inventory = 24,719.5 / ((1,400.5 + 1,364) / 2) = 24,719.5 / 1,382.25 = 17.88

Days Sales in Inventory = 365/Inventory Turnover = 365/17.88 = 20.41

Long term debt ratio = Long term debt / Total Equity = 9,090.2 / 1,175.8 = 7.73

Times Interest Earned = Earnings before Interest and Tax / Interest Expense = (5,780 + 170.3) / 170.3 = 34.94

Gross Profit margin = (Revenues - Cost of Sales) / Revenue = (24,719.5 - 10,174.5) / 24,719.5 = 58.84%

Net Profit Margin = Net Earnings / Revenue = 4,518 / 24,719.5 = 18.28%

Return on Equity = Net Earnings / Average Shareholders Equity = 4,518 / ((1,175.8 + 5,457)/2) = 4,518 / 3,316.4 = 136.23%

Return on Assets = Net Earnings / Average Total Assets = 4,518 / ((24,156.4 + 14,365.6)/2) = 4,518 / 19,261 = 23.46%