Calculate the following financial ratios for fiscal year 2018 only using the "Consolidated Statements of Earn" and "Consolidated Balance Sheets" worksheets in Starbucks 2017 and 2018 Annual Financial Statements: Current Ratio, Cash Ratio, Inventory Turnover, Days Sales in Inventory, Long Term Debt Ratio, Times Interest Earned, Gross Profit Margin, Net Profit Margin, Return on Equity, Return on Assets.
Answers :-
a) Calculation of current ratio
current ratio = Current Asset / Current Liabilities
Current asset = $12494.2
Current liabilities = $5684.2
Calculation of current ratio = $12494.2 / $5684.2
current ratio =2.1981%
..
b) Calculation of Cash ratio
Cash ratio = Cash & Cash equivalents / Current liabilities
Cash & Cash equivalants = $8756.3
Current liabilities = $5684.2
Cash ratio = $8756.3 / $5684.2
Cash ratio = 1.5405 %
..
c) Calculation of Inventory Turn over Ratio
Inventory Turn over Ratio = Cost of Goods sold / Avarage inventory
Cost of good sold = $10174.5
Avarage invenory = (Inventory of current year + Inventory of previous year) / 2
= ($1400.5 + $1364) / 2
= $2764.5 / 2
= $1382.25
Inventory Turn over Ratio = $10174.5 / $1382.25
Inventory Turn over Ratio = 7.3608 times
..
d) Days sales in inventory = 365 / Inventory Turn over Ratio
= 365 / 7.3608
Days sales in inventory = 49.587 Days
..
e) Calculation of Long-term Debt Ratio
Long Term debt Ratio = Long Term Debt / Total Assets
Total Long Term Debt = $9090.2
Total Asset = $24156.4
Long Term debt Ratio = $9090.2 / $24156.4
Long Term debt Ratio = 0.3763 or 37.63%
..
f) Calculation of Time Intrest Earned
Time Intrest Earned ratio = Earnings before intrest and Taxes / Interest expenses
Earnings before intrest and Taxes (Operating profit ) = $3883.3
Interest expenses = $170.3
Time Intrest Earned ratio = $3883.3 / $170.3
Time Intrest Earned = 22.80 Times
..
g) Calculation of Gross profit ratio
Gross profit ratio = Gross profit / Net sales
Gross profit = sales - cost of goods sold
= $24,719.5 - $10,174.5
= $14545
Net sales = $24,719.5
Gross profit Ratio = $14,545 / $24,719.5
Gross profit Ratio = 0.5884 or 58.84%
..
h)Calculation of Net Profit ratio
Net Profit ratio = Net Profit / Net sales
Net Profit = $3883.3
Net sales = $24,719.5
Net Profit ratio = $3883.3 / $24,719.5
Net Profit ratio = 0.1570 or 15.70%
..
i)Calculation of Return on equity
Return on Equity = Net income / Avarage Equity
Net Income (Net Profit) = $3883.3
Avarage Equity = (Total Equity of Current Year + Total Equity of Previous Year) / 2
= ($1175.8 + $5457 ) / 2
= $6632.8 / 2 = $3316.4
Return on Equity = $3883.3 / $3316.4
Return on Equity = 1.1709
..
j)Calculation of Return on Asset
Return on Asset = Net income / Avarage Asset
Net Income (Net Profit) = $3883.3
Avarage Asset = (Total Asset of Current Year + Total Asset of Previous Year) / 2
= ($24156.4 + $14365.6) / 2
= $38522 / 2
Avarage Asset = $19261
Return on Asset = $3883.3 / $19261
Return on Asset = 0.2016 or 20.16%
Calculate the following financial ratios for fiscal year 2018 only using the "Consolidated Statements of Earn"...
Calculate the following financial ratios for fiscal year 2018 only using the "Consolidated Statements of Earn" and "Consolidated Balance Sheets" worksheets in Starbucks 2017 and 2018 Annual Financial Statements : Current Ratio, Cash Ratio, Inventory Turnover, Days Sales in Inventory, Long Term Debt Ratio, Times Interest Earned, Gross Profit Margin, Net Profit Margin, Return on Equity, Return on Assets. 12 Months Ended Oct. 01, 2017 Sep. 30, 2018 Oct. 02, 2016 $ 22,386.8 9,034,3 6,493.3 500.3 1,011.4 1,450.7 153.5 18,643.5...
Calculate the following financial ratios for fiscal year 2018 only using the "Consolidated Statements of Earn" and "Consolidated Balance Sheets" worksheets in Starbucks 2017 and 2018 Annual Financial Statements: Current Ratio, Cash Ratio, Inventory Turnover, Days Sales in Inventory, Long Term Debt Ratio, Times Interest Earned, Gross Profit Margin, Net Profit Margin, Return on Equity, Return on Assets. 12 Months Ended Oct. 01, 2017 Sep. 30, 2018 Oct. 02, 2016 $ 22,386.8 9,034,3 6,493.3 500.3 1,011.4 1,450.7 153.5 18,643.5 $...
Calculate the following financial ratios for fiscal year 2018 only using the "Consolidated Statements of Earn" and "Consolidated Balance Sheets" worksheets in Starbucks 2017 and 2018 Annual Financial Statements : Current Ratio, Cash Ratio, Inventory Turnover, Days Sales in Inventory, Long Term Debt Ratio, Times Interest Earned, Gross Profit Margin, Net Profit Margin, Return on Equity, Return on Assets. 12 Months Ended Oct. 01, 2017 Sep. 30, 2018 Oct. 02, 2016 $ 22,386.8 9,034,3 6,493.3 500.3 1,011.4 1,450.7 153.5 18,643.5...
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 А 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...
This is Starbuck’s 2019 10-K data. Please make a common size balance sheet and a common size income statement. Thank you! A B D E F G С 12 Months Ended Sep. 30, 2018 Sep. 29, 2019 Oct. 01, 2017 1 Consolidated Statements of Earnings - USD ($) shares in Millions, $ in Millions 2 3 Net Revenues: 4 Revenues 5 Cost of sales 6 Store operating expenses 7 Other operating expenses 8 Depreciation and amortization expenses 9 General and...
ratios for consolidated balance sheet Starbucks how do i solve for the ratio template? Consolidated Statements of Earn Consolidated Balance Sheets Ratios Template Sep 30, 2018 O . 2017 Consolidated Balance Sheets - USD (S) Sin Millions Current Cash and cash equivalents Short-term in Prepaid Expand Other Ass, Cut Equity and cost investments Property, plant and equipment Deferred income Other long-term acts Other intangible assets TOTAL ASSETS Accued liabili Stowalue and liability Current pro long-term de Long-term debe Deed Revenue...
What is the net balance of "above the line" items on the Starbucks financials for the Fiscal year ended Oct. 1, 2017 (in millions)? STARBUCKS CORPORATION CONSOLIDATED STATEMENTS OF EARNINGS in millions, except per share data) Sep 30, 2018 Oct 1. 2017 Oct 2, 2016 al Year Ended et revenues: Company-operated stores 19,690.3 $ 17,650.7 S 355.0 652.2 2,377.0 24,719.5 10,174.5 7,193.2 539.3 16,844.1 2,154.2 2,317.6 21,315.9 8,509.0 064.3 499.2 980.8 1,408.9 stores Other 2,381.1 net revenues 386.8 Cost of...
Instructions: By using the above information, please calculate the ROA, show all work and your interpretation. [1] Return on Asset: ROA = (net income) + ( 1 – tax rate)(interest exp) + minority interest in earning / Average Total Assets EXXON MOBIL CORPORATION CONDENSED CONSOLIDATED BALANCE SHEET (millions of dollars) Sept. 30, 2018 5,669 27,880 Assets Current assets Cash and cash equivalents Notes and accounts receivable -- net Inventories Crude oil, products and merchandise Materials and supplies Other current assets...
Balance sheets and income statements for Costco Wholesale Corporation follow. Costco Wholesale Corporation Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) August 28, 2016 August 30, 2015 August 31, 2014 Revenue Net Sales $116,073 $113,666 $110,212 Membership fees 2,646 2,533 2,428 Total revenue 118,719 116,199 112,640 Operating expenses Merchandise costs 102,901 101,065 98,458 Selling, general and administrative 12,068 11,445 10,899 Preopening expenses 78 65 63 Operating Income 3,672 3,624 3,220 Other income (expense) Interest expense (133) (124) (113)...
Analyzing Starbucks's Balance Sheet Disclosures Keview the financial statements and related notes of Starbucks in Appendix A. Required: Answer the following questions pertaining to Starbucks's balance sheet as of October 1, 2017, and related information. (Note: You do not need to make any calculations. All answers may be found in the financial report.) If required, round your answers to one decimal place. 1. What was the amount of the current assets and current liabilities? Current assets $ 14,365,6 X million...