I need the times interest earned ratio, Dividend yield, free cash flow ratio, and price earning ratio for both Apple and Google using their 2017 10K Sec form. 

https://abc.xyz/investor/static/pdf/20171231_alphabet_10K.pdf

https://thequarterly.org/sec-filings/aapl/2017/10-k.html

Transcribed Image Text:

Use this Excel apreadshcet to compute raties, ahow your computations for dl rados on dris tab, end abo inchde your commentary. The 2017 financial statements used to calculate these ratias are available in the Investor Relations sections of Alphabet and Apple websites. ALPHABET APPLE 12/31/2017 12/31/2014 Eamings per Share of Common Stock (basic - common) Ae given in the income staterment 318.27 59.27 Current Rutio Current sesels $124,308 574,183 5.14 3128,845 $100,814 1.28 Curent lahiites Grosa profit S65,272 Gross Proftr Rate 58 EW $88 186 38.5% Net sales S110.856 $110,655 $229,234 S12,862 $110,685 Profit Margin Net neame Net sales 11.4% $44 351 $220,231 21.1% Inventory Turnover $14,100,000 Cost of goods sald Average inventory S155,000 40.4 35.085 3549.400 365 daye Invantory turnaver Deys in Inventory 385 4 365 days 40 4 days $110,855 S16,237 $779.234 $18.914 Accounts Recelvable Tumover Nat oradit salas 136 Average net accaurts recervable Average Collection Period 365 days 365 53 365 27 Accounts receivable turnaver 6.8 days 13.8 days Asset turnover Net salas $110,855 $163,396 $229,234 $318,503 0.B0 d.68 Average total asseis Return on Assets (ROA) Net incame $12,862 $182,389 8.9% $40,351 13.0%. Average total assete 3348,503 Debt to ussets retio Totel Liabiities $44,793 $197,295 22.7% 3241.272 $375,318 64.3% Tata Assats 66 412 2.323 Times-Interest Eamad Ratto Nat incomet interest expanse t ineome tax apanse $184,183 1.2 28 5 interest expsnse $157,000 Use this Excel apreadshcet to compute raties, ahow your computations for dl rados on dris tab, end abo inchde your commentary. The 2017 financial statements used to calculate these ratias are available in the Investor Relations sections of Alphabet and Apple websites. ALPHABET APPLE 12/31/2017 12/31/2014 Eamings per Share of Common Stock (basic - common) Ae given in the income staterment 318.27 59.27 Current Rutio Current sesels $124,308 574,183 5.14 3128,845 $100,814 1.28 Curent lahiites Grosa profit S65,272 Gross Proftr Rate 58 EW $88 186 38.5% Net sales S110.856 $110,655 $229,234 S12,862 $110,685 Profit Margin Net neame Net sales 11.4% $44 351 $220,231 21.1% Inventory Turnover $14,100,000 Cost of goods sald Average inventory S155,000 40.4 35.085 3549.400 365 daye Invantory turnaver Deys in Inventory 385 4 365 days 40 4 days $110,855 S16,237 $779.234 $18.914 Accounts Recelvable Tumover Nat oradit salas 136 Average net accaurts recervable Average Collection Period 365 days 365 53 365 27 Accounts receivable turnaver 6.8 days 13.8 days Asset turnover Net salas $110,855 $163,396 $229,234 $318,503 0.B0 d.68 Average total asseis Return on Assets (ROA) Net incame $12,862 $182,389 8.9% $40,351 13.0%. Average total assete 3348,503 Debt to ussets retio Totel Liabiities $44,793 $197,295 22.7% 3241.272 $375,318 64.3% Tata Assats 66 412 2.323 Times-Interest Eamad Ratto Nat incomet interest expanse t ineome tax apanse $184,183 1.2 28 5 interest expsnse $157,000

Answer rating: 100% (QA)

Answer Interest earned ratio earnings before interest and taxes EBIT divided by the tota... View the full answer