I need help calculating the cash flow ratios for the cash flow statement posted
ID: 2615252 • Letter: I
Question
I need help calculating the cash flow ratios for the cash flow statement posted below. I have attached the company's income statement and balance sheet just in case. I also attached a how-to article for calculating the ratios.
Excel File Edit View Insert Format Tools Data Window Help AAPL Financial model-Saved to my Mac Home Insert Page Layout Formulas Data Review View Conditic Format a Cell Style Calibri (Body) , 12 , A^ A. General Paste Blu, ffice Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updatos Income Statement Dollars % of Sales 9/30/1 7-9/24/16926/15 100% 100% 100% 62% 61%- 60% 38% 39% 40% s Revenue 6 Total Revenue 9/30/17 924/16. 9/26/15 229,234,000 215,639,000 233,715,000 141,048,000 131,376,000 140,089,000 88,186,000 84,263,000 93,626,000 Cost of Revenue 8 Gross Profit Operating Expenses Research Development 11,581,000 10,045,000 8,067,000 15,261,000 14,194.000 14,329,000 3% 7961-6% 5961 5% 596 5% Selling General and Administrative 79% 12 Non Recurring 13 Others 4 Total Operating Expenses 61,344,000 60,024,000 71,230,000 27% 28% 30% Operating Income or Loss 16 Income from Continuing Operations 17 Total Other Income/Expenses Net 18 Eamings Before Interest and Taxes 19 Interest Expense 0 Income Before Tax 2,745,0001,348,000 1,285,000 64.089.00061,372,000| 72,515.000 196 28% 1% 31% 28% . 64.089,000 61.372,000 72,515,000 2896: 28%: 31% isman 15,685.000 19,121,000. 7%-7%-. income Tax Expense .8% 22 Minority Interest 48,351,000 45,687,000 53,394,000 21% 21% 23 Net Income From Continuing Ops 24 Non-recurring Events s Discontinued Operations 26 Extraord nary Items Effect Ot Accounting Changes 28 Other tems 29 Net Income 30 Net lncome 31 Preferred Stock And Other Adjustments 2 Net Income Applicable To Common Shares 48351000 45,087,000 53,394,000 21%? 21%--23% 48,351,000 45,687,000 53,994,000 21% 21% 23% Income Statement Balanoe Sheet Cash Flow+ 15Explanation / Answer
For 2017
Current ratio = Current assets/Current liabilities
= 128,645,000/100,814,000
= 1.276
Quick assets = Cash and cash equivalents + Short term investments + Net receivables
= 20,289,000 + 53,892,000 + 35,673,000
= $109,854,000
Quick ratio = Quick assets/Current liabilities
= 109,854,000/100,814,000
= 1.089
Operating cash flow ratio = Cash flow from operations/Current liabilities
= 63,598,000/100,814,000
= 0.63
Cash turnover ratio = Cash flow from operations/Sales
= 63,598,000/229,234,000
= 0.28
For 2016
Current ratio = Current assets/Current liabilities
= 106,869,000/79,006,000
= 1.35
Quick assets = Cash and cash equivalents + Short term investments + Net receivables
= 20,484,000 + 46,671,000 + 29,299,000
= $96,454,000
Quick ratio = Quick assets/Current liabilities
= 96,454,000/79,006,000
= 1.22
Operating cash flow ratio = Cash flow from operations/Current liabilities
= 65,824,000/79,006,000
= 0.83
Cash turnover ratio = Cash flow from operations/Sales
= 65,824,000/215,639,000
= 0.30
For 2015
Current ratio = Current assets/Current liabilities
= 89,378,000/80,610,000
= 1.11
Quick assets = Cash and cash equivalents + Short term investments + Net receivables
= 21,120,000 + 20,481,000 + 30,343,000
= $71,944,000
Quick ratio = Quick assets/Current liabilities
= 71,944,000/80,610,000
= 0.89
Operating cash flow ratio = Cash flow from operations/Current liabilities
= 81,266,000/80,610,000
= 1.008
Cash turnover ratio = Cash flow from operations/Sales
= 81,266,000/233,715,000
= 0.35
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.