Stock Analysis on Net

Baxter International Inc. (NYSE:BAX)

This company has been moved to the archive! The financial data has not been updated since August 4, 2016.

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Baxter International Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011
Turnover Ratios
Inventory turnover 3.78 3.48 3.63 3.86 1.88 2.27 2.39 2.34 2.19 2.12 2.19 1.98 2.26 2.33 2.46 2.43 2.53 2.53 2.61
Receivables turnover 5.54 5.43 5.76 6.68 4.75 5.86 5.95 5.83 5.54 5.78 5.24 5.29 6.13 6.14 5.85 6.04 6.31 5.98 5.74
Working capital turnover 3.24 2.37 1.65 2.30 1.66 4.16 3.87 4.55 4.37 4.18 3.72 3.18 1.87 3.53 3.15 3.02 4.42 4.29 3.66
Average No. Days
Average inventory processing period 97 105 101 95 194 161 153 156 167 173 167 184 161 157 149 150 144 145 140
Add: Average receivable collection period 66 67 63 55 77 62 61 63 66 63 70 69 60 59 62 60 58 61 64
Operating cycle 163 172 164 150 271 223 214 219 233 236 237 253 221 216 211 210 202 206 204

Based on: 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31), 10-K (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-Q (reporting date: 2011-03-31).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Baxter International Inc. inventory turnover ratio deteriorated from Q4 2015 to Q1 2016 but then improved from Q1 2016 to Q2 2016 exceeding Q4 2015 level.
Receivables turnover An activity ratio equal to revenue divided by receivables. Baxter International Inc. receivables turnover ratio deteriorated from Q4 2015 to Q1 2016 but then slightly improved from Q1 2016 to Q2 2016.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Baxter International Inc. working capital turnover ratio improved from Q4 2015 to Q1 2016 and from Q1 2016 to Q2 2016.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Baxter International Inc. number of days of inventory outstanding deteriorated from Q4 2015 to Q1 2016 but then improved from Q1 2016 to Q2 2016 exceeding Q4 2015 level.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Baxter International Inc. number of days of receivables outstanding deteriorated from Q4 2015 to Q1 2016 but then slightly improved from Q1 2016 to Q2 2016.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Baxter International Inc. operating cycle deteriorated from Q4 2015 to Q1 2016 but then improved from Q1 2016 to Q2 2016 exceeding Q4 2015 level.

Inventory Turnover

Baxter International Inc., inventory turnover calculation (quarterly data)

Microsoft Excel
Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011
Selected Financial Data (US$ in millions)
Cost of sales 1,613 1,410 1,531 1,453 1,454 1,384 2,248 2,124 2,185 1,957 2,414 1,828 1,730 1,692 1,848 1,667 1,700 1,674 1,829 1,708 1,701 1,609
Inventories 1,591 1,682 1,604 1,696 3,842 3,501 3,559 3,704 3,836 3,748 3,499 3,581 3,069 2,963 2,803 2,831 2,730 2,737 2,628 2,621 2,648 2,517
Short-term Activity Ratio
Inventory turnover1 3.78 3.48 3.63 3.86 1.88 2.27 2.39 2.34 2.19 2.12 2.19 1.98 2.26 2.33 2.46 2.43 2.53 2.53 2.61
Benchmarks
Inventory Turnover, Competitors2
Abbott Laboratories
Cigna Group
CVS Health Corp.
Intuitive Surgical Inc.
Medtronic PLC
Shockwave Medical Inc.

Based on: 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31), 10-K (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-Q (reporting date: 2011-03-31).

1 Q2 2016 Calculation
Inventory turnover = (Cost of salesQ2 2016 + Cost of salesQ1 2016 + Cost of salesQ4 2015 + Cost of salesQ3 2015) ÷ Inventories
= (1,613 + 1,410 + 1,531 + 1,453) ÷ 1,591 = 3.78

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Baxter International Inc. inventory turnover ratio deteriorated from Q4 2015 to Q1 2016 but then improved from Q1 2016 to Q2 2016 exceeding Q4 2015 level.

Receivables Turnover

Baxter International Inc., receivables turnover calculation (quarterly data)

Microsoft Excel
Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011
Selected Financial Data (US$ in millions)
Net sales 2,585 2,375 2,603 2,487 2,475 2,403 4,472 4,197 4,154 3,848 4,368 3,774 3,669 3,448 3,753 3,477 3,572 3,388 3,594 3,479 3,536 3,284
Accounts and other current receivables, net 1,813 1,830 1,731 1,772 2,852 2,599 2,803 2,842 2,914 2,708 2,911 2,766 2,342 2,319 2,425 2,324 2,225 2,341 2,420 2,347 2,491 2,399
Short-term Activity Ratio
Receivables turnover1 5.54 5.43 5.76 6.68 4.75 5.86 5.95 5.83 5.54 5.78 5.24 5.29 6.13 6.14 5.85 6.04 6.31 5.98 5.74
Benchmarks
Receivables Turnover, Competitors2
Abbott Laboratories
CVS Health Corp.
Elevance Health Inc.
Humana Inc.
Intuitive Surgical Inc.
Medtronic PLC
Shockwave Medical Inc.
UnitedHealth Group Inc.

Based on: 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31), 10-K (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-Q (reporting date: 2011-03-31).

1 Q2 2016 Calculation
Receivables turnover = (Net salesQ2 2016 + Net salesQ1 2016 + Net salesQ4 2015 + Net salesQ3 2015) ÷ Accounts and other current receivables, net
= (2,585 + 2,375 + 2,603 + 2,487) ÷ 1,813 = 5.54

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Baxter International Inc. receivables turnover ratio deteriorated from Q4 2015 to Q1 2016 but then slightly improved from Q1 2016 to Q2 2016.

Working Capital Turnover

Baxter International Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011
Selected Financial Data (US$ in millions)
Current assets 6,823 8,017 11,796 11,138 14,497 9,734 10,351 9,631 9,487 9,388 10,004 9,597 12,185 8,814 9,260 9,105 8,048 8,117 8,650 8,002 7,809 7,761
Less: Current liabilities 3,723 3,823 5,750 5,981 6,312 6,074 6,042 5,990 5,795 5,645 5,906 4,996 4,516 4,778 4,759 4,458 4,870 4,857 4,857 4,165 4,031 3,889
Working capital 3,100 4,194 6,046 5,157 8,185 3,660 4,309 3,641 3,692 3,743 4,098 4,601 7,669 4,036 4,501 4,647 3,178 3,260 3,793 3,837 3,778 3,872
 
Net sales 2,585 2,375 2,603 2,487 2,475 2,403 4,472 4,197 4,154 3,848 4,368 3,774 3,669 3,448 3,753 3,477 3,572 3,388 3,594 3,479 3,536 3,284
Short-term Activity Ratio
Working capital turnover1 3.24 2.37 1.65 2.30 1.66 4.16 3.87 4.55 4.37 4.18 3.72 3.18 1.87 3.53 3.15 3.02 4.42 4.29 3.66
Benchmarks
Working Capital Turnover, Competitors2
Abbott Laboratories
Cigna Group
CVS Health Corp.
Elevance Health Inc.
Humana Inc.
Intuitive Surgical Inc.
Medtronic PLC
Shockwave Medical Inc.
UnitedHealth Group Inc.

Based on: 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31), 10-K (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-Q (reporting date: 2011-03-31).

1 Q2 2016 Calculation
Working capital turnover = (Net salesQ2 2016 + Net salesQ1 2016 + Net salesQ4 2015 + Net salesQ3 2015) ÷ Working capital
= (2,585 + 2,375 + 2,603 + 2,487) ÷ 3,100 = 3.24

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Baxter International Inc. working capital turnover ratio improved from Q4 2015 to Q1 2016 and from Q1 2016 to Q2 2016.

Average Inventory Processing Period

Baxter International Inc., average inventory processing period calculation (quarterly data)

Microsoft Excel
Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011
Selected Financial Data
Inventory turnover 3.78 3.48 3.63 3.86 1.88 2.27 2.39 2.34 2.19 2.12 2.19 1.98 2.26 2.33 2.46 2.43 2.53 2.53 2.61
Short-term Activity Ratio (no. days)
Average inventory processing period1 97 105 101 95 194 161 153 156 167 173 167 184 161 157 149 150 144 145 140
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Abbott Laboratories
Cigna Group
CVS Health Corp.
Intuitive Surgical Inc.
Medtronic PLC
Shockwave Medical Inc.

Based on: 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31), 10-K (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-Q (reporting date: 2011-03-31).

1 Q2 2016 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 3.78 = 97

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Baxter International Inc. number of days of inventory outstanding deteriorated from Q4 2015 to Q1 2016 but then improved from Q1 2016 to Q2 2016 exceeding Q4 2015 level.

Average Receivable Collection Period

Baxter International Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel
Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011
Selected Financial Data
Receivables turnover 5.54 5.43 5.76 6.68 4.75 5.86 5.95 5.83 5.54 5.78 5.24 5.29 6.13 6.14 5.85 6.04 6.31 5.98 5.74
Short-term Activity Ratio (no. days)
Average receivable collection period1 66 67 63 55 77 62 61 63 66 63 70 69 60 59 62 60 58 61 64
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Abbott Laboratories
CVS Health Corp.
Elevance Health Inc.
Humana Inc.
Intuitive Surgical Inc.
Medtronic PLC
Shockwave Medical Inc.
UnitedHealth Group Inc.

Based on: 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31), 10-K (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-Q (reporting date: 2011-03-31).

1 Q2 2016 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 5.54 = 66

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Baxter International Inc. number of days of receivables outstanding deteriorated from Q4 2015 to Q1 2016 but then slightly improved from Q1 2016 to Q2 2016.

Operating Cycle

Baxter International Inc., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011
Selected Financial Data
Average inventory processing period 97 105 101 95 194 161 153 156 167 173 167 184 161 157 149 150 144 145 140
Average receivable collection period 66 67 63 55 77 62 61 63 66 63 70 69 60 59 62 60 58 61 64
Short-term Activity Ratio
Operating cycle1 163 172 164 150 271 223 214 219 233 236 237 253 221 216 211 210 202 206 204
Benchmarks
Operating Cycle, Competitors2
Abbott Laboratories
CVS Health Corp.
Intuitive Surgical Inc.
Medtronic PLC
Shockwave Medical Inc.

Based on: 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31), 10-K (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-Q (reporting date: 2011-03-31).

1 Q2 2016 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 97 + 66 = 163

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Operating cycle Equal to average inventory processing period plus average receivables collection period. Baxter International Inc. operating cycle deteriorated from Q4 2015 to Q1 2016 but then improved from Q1 2016 to Q2 2016 exceeding Q4 2015 level.