Microsoft Excel LibreOffice Calc

Starbucks Corp. (SBUX)

Short-term (Operating) Activity Analysis
Quarterly Data

Difficulty: Beginner

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Ratios (Summary)

Starbucks Corp., short-term (operating) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Jan 1, 2017 Oct 2, 2016 Jun 26, 2016 Mar 27, 2016 Dec 27, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013 Dec 30, 2012
Turnover Ratios
Inventory turnover 7.70 7.26 7.15 6.99 7.04 6.63 6.59 6.61 7.07 6.17 6.22 6.29 6.42 5.96 6.46 6.87 6.93 6.29 6.60 6.97 6.95 5.74 – – –
Receivables turnover 35.04 35.67 28.21 26.98 26.68 25.72 28.31 27.78 25.06 27.73 27.46 27.11 25.82 26.65 27.39 27.00 25.58 26.07 27.65 26.53 26.00 26.53 – – –
Payables turnover 9.48 8.63 10.78 11.06 10.85 11.55 12.73 12.74 13.01 11.65 12.19 12.27 12.32 11.38 12.48 12.12 12.88 12.85 14.27 14.08 14.76 12.98 – – –
Working capital turnover 11.24 3.63 758.31 49.93 536.03 21.07 15.11 23.91 99.02 99.79 33.58 – 64.15 27.41 25.90 24.44 17.21 14.56 33.96 18.51 19.01 158.26 – – –
Average No. of Days
Average inventory processing period 47 50 51 52 52 55 55 55 52 59 59 58 57 61 57 53 53 58 55 52 53 64 – – –
Add: Average receivable collection period 10 10 13 14 14 14 13 13 15 13 13 13 14 14 13 14 14 14 13 14 14 14 – – –
Operating cycle 57 60 64 66 66 69 68 68 67 72 72 71 71 75 70 67 67 72 68 66 67 78 – – –
Less: Average payables payment period 39 42 34 33 34 32 29 29 28 31 30 30 30 32 29 30 28 28 26 26 25 28 – – –
Cash conversion cycle 18 18 30 33 32 37 39 39 39 41 42 41 41 43 41 37 39 44 42 40 42 50 – – –

Based on: 10-Q (filing date: 2019-01-29), 10-K (filing date: 2018-11-16), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-Q (filing date: 2018-01-31), 10-K (filing date: 2017-11-17), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-02), 10-Q (filing date: 2017-01-31), 10-K (filing date: 2016-11-18), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-26), 10-Q (filing date: 2016-01-26), 10-K (filing date: 2015-11-12), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-Q (filing date: 2015-01-27), 10-K (filing date: 2014-11-14), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-Q (filing date: 2014-01-28), 10-K (filing date: 2013-11-18), 10-Q (filing date: 2013-07-30), 10-Q (filing date: 2013-04-30), 10-Q (filing date: 2013-01-29).

Ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Starbucks Corp.’s inventory turnover improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.
Receivables turnover An activity ratio equal to revenue divided by receivables. Starbucks Corp.’s receivables turnover improved from Q3 2018 to Q4 2018 but then slightly deteriorated from Q4 2018 to Q1 2019.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Starbucks Corp.’s payables turnover declined from Q3 2018 to Q4 2018 but then slightly increased from Q4 2018 to Q1 2019.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Starbucks Corp.’s working capital turnover deteriorated from Q3 2018 to Q4 2018 but then slightly improved from Q4 2018 to Q1 2019.
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. Starbucks Corp.’s average inventory processing period improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Starbucks Corp.’s operating cycle improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Starbucks Corp.’s average payables payment period increased from Q3 2018 to Q4 2018 but then slightly declined from Q4 2018 to Q1 2019.
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period.

Inventory Turnover

Starbucks Corp., inventory turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Jan 1, 2017 Oct 2, 2016 Jun 26, 2016 Mar 27, 2016 Dec 27, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013 Dec 30, 2012
Selected Financial Data (USD $ in thousands)
Cost of sales including occupancy costs 2,758,700  2,600,700  2,554,900  2,516,000  2,502,900  2,352,900  2,249,100  2,141,200  2,295,000  2,254,300  2,060,300  2,010,300  2,186,200  1,982,600  1,953,900  1,859,800  1,991,200  1,723,000  1,711,500  1,629,200  1,795,100  1,633,600  1,597,600  1,530,400  1,620,700 
Inventories 1,354,600  1,400,500  1,387,400  1,375,900  1,313,200  1,364,000  1,357,300  1,323,600  1,218,700  1,378,500  1,325,100  1,293,100  1,242,600  1,306,400  1,166,000  1,061,100  1,018,300  1,090,900  1,025,800  954,700  943,300  1,111,200  1,173,800  1,124,500  1,093,200 
Ratio
Inventory turnover1 7.70 7.26 7.15 6.99 7.04 6.63 6.59 6.61 7.07 6.17 6.22 6.29 6.42 5.96 6.46 6.87 6.93 6.29 6.60 6.97 6.95 5.74 – – –

Based on: 10-Q (filing date: 2019-01-29), 10-K (filing date: 2018-11-16), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-Q (filing date: 2018-01-31), 10-K (filing date: 2017-11-17), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-02), 10-Q (filing date: 2017-01-31), 10-K (filing date: 2016-11-18), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-26), 10-Q (filing date: 2016-01-26), 10-K (filing date: 2015-11-12), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-Q (filing date: 2015-01-27), 10-K (filing date: 2014-11-14), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-Q (filing date: 2014-01-28), 10-K (filing date: 2013-11-18), 10-Q (filing date: 2013-07-30), 10-Q (filing date: 2013-04-30), 10-Q (filing date: 2013-01-29).

Q1 2019 Calculations

1 Inventory turnover = (Cost of sales including occupancy costsQ1 2019 + Cost of sales including occupancy costsQ4 2018 + Cost of sales including occupancy costsQ3 2018 + Cost of sales including occupancy costsQ2 2018) ÷ Inventories
= (2,758,700 + 2,600,700 + 2,554,900 + 2,516,000) ÷ 1,354,600 = 7.70

Ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Starbucks Corp.’s inventory turnover improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.

Receivables Turnover

Starbucks Corp., receivables turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Jan 1, 2017 Oct 2, 2016 Jun 26, 2016 Mar 27, 2016 Dec 27, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013 Dec 30, 2012
Selected Financial Data (USD $ in thousands)
Net revenues 6,632,700  6,303,700  6,310,300  6,031,800  6,073,700  5,698,400  5,661,500  5,294,000  5,732,900  5,711,200  5,238,000  4,993,200  5,373,500  4,914,800  4,881,200  4,563,500  4,803,200  4,180,700  4,153,700  3,873,800  4,239,600  3,795,000  3,741,700  3,555,900  3,799,600 
Accounts receivable, net 721,400  693,100  854,800  869,600  851,800  870,400  791,100  791,000  865,100  768,800  747,300  743,700  764,400  719,000  672,700  655,600  664,900  631,000  580,900  590,000  589,800  561,400  506,800  520,000  469,200 
Ratio
Receivables turnover1 35.04 35.67 28.21 26.98 26.68 25.72 28.31 27.78 25.06 27.73 27.46 27.11 25.82 26.65 27.39 27.00 25.58 26.07 27.65 26.53 26.00 26.53 – – –

Based on: 10-Q (filing date: 2019-01-29), 10-K (filing date: 2018-11-16), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-Q (filing date: 2018-01-31), 10-K (filing date: 2017-11-17), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-02), 10-Q (filing date: 2017-01-31), 10-K (filing date: 2016-11-18), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-26), 10-Q (filing date: 2016-01-26), 10-K (filing date: 2015-11-12), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-Q (filing date: 2015-01-27), 10-K (filing date: 2014-11-14), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-Q (filing date: 2014-01-28), 10-K (filing date: 2013-11-18), 10-Q (filing date: 2013-07-30), 10-Q (filing date: 2013-04-30), 10-Q (filing date: 2013-01-29).

Q1 2019 Calculations

1 Receivables turnover = (Net revenuesQ1 2019 + Net revenuesQ4 2018 + Net revenuesQ3 2018 + Net revenuesQ2 2018) ÷ Accounts receivable, net
= (6,632,700 + 6,303,700 + 6,310,300 + 6,031,800) ÷ 721,400 = 35.04

Ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Starbucks Corp.’s receivables turnover improved from Q3 2018 to Q4 2018 but then slightly deteriorated from Q4 2018 to Q1 2019.

Payables Turnover

Starbucks Corp., payables turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Jan 1, 2017 Oct 2, 2016 Jun 26, 2016 Mar 27, 2016 Dec 27, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013 Dec 30, 2012
Selected Financial Data (USD $ in thousands)
Cost of sales including occupancy costs 2,758,700  2,600,700  2,554,900  2,516,000  2,502,900  2,352,900  2,249,100  2,141,200  2,295,000  2,254,300  2,060,300  2,010,300  2,186,200  1,982,600  1,953,900  1,859,800  1,991,200  1,723,000  1,711,500  1,629,200  1,795,100  1,633,600  1,597,600  1,530,400  1,620,700 
Accounts payable 1,100,500  1,179,300  921,100  869,700  852,100  782,500  702,200  686,900  662,500  730,600  675,700  662,700  648,000  684,200  603,200  601,300  547,700  533,700  474,500  472,600  444,200  491,700  415,200  355,700  380,800 
Ratio
Payables turnover1 9.48 8.63 10.78 11.06 10.85 11.55 12.73 12.74 13.01 11.65 12.19 12.27 12.32 11.38 12.48 12.12 12.88 12.85 14.27 14.08 14.76 12.98 – – –

Based on: 10-Q (filing date: 2019-01-29), 10-K (filing date: 2018-11-16), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-Q (filing date: 2018-01-31), 10-K (filing date: 2017-11-17), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-02), 10-Q (filing date: 2017-01-31), 10-K (filing date: 2016-11-18), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-26), 10-Q (filing date: 2016-01-26), 10-K (filing date: 2015-11-12), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-Q (filing date: 2015-01-27), 10-K (filing date: 2014-11-14), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-Q (filing date: 2014-01-28), 10-K (filing date: 2013-11-18), 10-Q (filing date: 2013-07-30), 10-Q (filing date: 2013-04-30), 10-Q (filing date: 2013-01-29).

Q1 2019 Calculations

1 Payables turnover = (Cost of sales including occupancy costsQ1 2019 + Cost of sales including occupancy costsQ4 2018 + Cost of sales including occupancy costsQ3 2018 + Cost of sales including occupancy costsQ2 2018) ÷ Accounts payable
= (2,758,700 + 2,600,700 + 2,554,900 + 2,516,000) ÷ 1,100,500 = 9.48

Ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Starbucks Corp.’s payables turnover declined from Q3 2018 to Q4 2018 but then slightly increased from Q4 2018 to Q1 2019.

Working Capital Turnover

Starbucks Corp., working capital turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Jan 1, 2017 Oct 2, 2016 Jun 26, 2016 Mar 27, 2016 Dec 27, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013 Dec 30, 2012
Selected Financial Data (USD $ in thousands)
Current assets 7,676,300  12,494,200  5,583,400  5,657,000  6,883,500  5,283,400  5,509,300  4,919,400  4,616,200  4,760,500  4,856,200  3,883,500  4,727,700  4,352,700  4,760,700  4,245,400  4,546,100  4,168,700  3,356,900  3,579,000  3,759,400  5,471,400  4,239,700  3,810,200  4,416,000 
Less: Current liabilities 5,427,500  5,684,200  5,551,600  5,187,000  6,841,100  4,220,700  4,026,500  4,000,100  4,397,300  4,546,900  4,245,200  4,351,200  4,420,100  3,653,500  4,049,200  3,521,200  3,557,500  3,038,700  2,883,900  2,733,500  2,953,000  5,377,300  2,424,400  2,269,700  2,390,900 
Working capital 2,248,800  6,810,000  31,800  470,000  42,400  1,062,700  1,482,800  919,300  218,900  213,600  611,000  (467,700) 307,600  699,200  711,500  724,200  988,600  1,130,000  473,000  845,500  806,400  94,100  1,815,300  1,540,500  2,025,100 
Net revenues 6,632,700  6,303,700  6,310,300  6,031,800  6,073,700  5,698,400  5,661,500  5,294,000  5,732,900  5,711,200  5,238,000  4,993,200  5,373,500  4,914,800  4,881,200  4,563,500  4,803,200  4,180,700  4,153,700  3,873,800  4,239,600  3,795,000  3,741,700  3,555,900  3,799,600 
Ratio
Working capital turnover1 11.24 3.63 758.31 49.93 536.03 21.07 15.11 23.91 99.02 99.79 33.58 – 64.15 27.41 25.90 24.44 17.21 14.56 33.96 18.51 19.01 158.26 – – –

Based on: 10-Q (filing date: 2019-01-29), 10-K (filing date: 2018-11-16), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-Q (filing date: 2018-01-31), 10-K (filing date: 2017-11-17), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-02), 10-Q (filing date: 2017-01-31), 10-K (filing date: 2016-11-18), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-26), 10-Q (filing date: 2016-01-26), 10-K (filing date: 2015-11-12), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-Q (filing date: 2015-01-27), 10-K (filing date: 2014-11-14), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-Q (filing date: 2014-01-28), 10-K (filing date: 2013-11-18), 10-Q (filing date: 2013-07-30), 10-Q (filing date: 2013-04-30), 10-Q (filing date: 2013-01-29).

Q1 2019 Calculations

1 Working capital turnover = (Net revenuesQ1 2019 + Net revenuesQ4 2018 + Net revenuesQ3 2018 + Net revenuesQ2 2018) ÷ Working capital
= (6,632,700 + 6,303,700 + 6,310,300 + 6,031,800) ÷ 2,248,800 = 11.24

Ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Starbucks Corp.’s working capital turnover deteriorated from Q3 2018 to Q4 2018 but then slightly improved from Q4 2018 to Q1 2019.

Average Inventory Processing Period

Starbucks Corp., average inventory processing period calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Jan 1, 2017 Oct 2, 2016 Jun 26, 2016 Mar 27, 2016 Dec 27, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013 Dec 30, 2012
Selected Financial Data
Inventory turnover 7.70 7.26 7.15 6.99 7.04 6.63 6.59 6.61 7.07 6.17 6.22 6.29 6.42 5.96 6.46 6.87 6.93 6.29 6.60 6.97 6.95 5.74 – – –
Ratio (no. of days)
Average inventory processing period1 47 50 51 52 52 55 55 55 52 59 59 58 57 61 57 53 53 58 55 52 53 64 – – –

Based on: 10-Q (filing date: 2019-01-29), 10-K (filing date: 2018-11-16), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-Q (filing date: 2018-01-31), 10-K (filing date: 2017-11-17), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-02), 10-Q (filing date: 2017-01-31), 10-K (filing date: 2016-11-18), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-26), 10-Q (filing date: 2016-01-26), 10-K (filing date: 2015-11-12), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-Q (filing date: 2015-01-27), 10-K (filing date: 2014-11-14), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-Q (filing date: 2014-01-28), 10-K (filing date: 2013-11-18), 10-Q (filing date: 2013-07-30), 10-Q (filing date: 2013-04-30), 10-Q (filing date: 2013-01-29).

Q1 2019 Calculations

1 Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 7.70 = 47

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. Starbucks Corp.’s average inventory processing period improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.

Average Receivable Collection Period

Starbucks Corp., average receivable collection period calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Jan 1, 2017 Oct 2, 2016 Jun 26, 2016 Mar 27, 2016 Dec 27, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013 Dec 30, 2012
Selected Financial Data
Receivables turnover 35.04 35.67 28.21 26.98 26.68 25.72 28.31 27.78 25.06 27.73 27.46 27.11 25.82 26.65 27.39 27.00 25.58 26.07 27.65 26.53 26.00 26.53 – – –
Ratio (no. of days)
Average receivable collection period1 10 10 13 14 14 14 13 13 15 13 13 13 14 14 13 14 14 14 13 14 14 14 – – –

Based on: 10-Q (filing date: 2019-01-29), 10-K (filing date: 2018-11-16), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-Q (filing date: 2018-01-31), 10-K (filing date: 2017-11-17), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-02), 10-Q (filing date: 2017-01-31), 10-K (filing date: 2016-11-18), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-26), 10-Q (filing date: 2016-01-26), 10-K (filing date: 2015-11-12), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-Q (filing date: 2015-01-27), 10-K (filing date: 2014-11-14), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-Q (filing date: 2014-01-28), 10-K (filing date: 2013-11-18), 10-Q (filing date: 2013-07-30), 10-Q (filing date: 2013-04-30), 10-Q (filing date: 2013-01-29).

Q1 2019 Calculations

1 Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 35.04 = 10

Ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover.

Operating Cycle

Starbucks Corp., operating cycle calculation (quarterly data)

No. of days

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Jan 1, 2017 Oct 2, 2016 Jun 26, 2016 Mar 27, 2016 Dec 27, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013 Dec 30, 2012
Selected Financial Data
Average inventory processing period 47 50 51 52 52 55 55 55 52 59 59 58 57 61 57 53 53 58 55 52 53 64 – – –
Average receivable collection period 10 10 13 14 14 14 13 13 15 13 13 13 14 14 13 14 14 14 13 14 14 14 – – –
Ratio
Operating cycle1 57 60 64 66 66 69 68 68 67 72 72 71 71 75 70 67 67 72 68 66 67 78 – – –

Based on: 10-Q (filing date: 2019-01-29), 10-K (filing date: 2018-11-16), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-Q (filing date: 2018-01-31), 10-K (filing date: 2017-11-17), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-02), 10-Q (filing date: 2017-01-31), 10-K (filing date: 2016-11-18), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-26), 10-Q (filing date: 2016-01-26), 10-K (filing date: 2015-11-12), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-Q (filing date: 2015-01-27), 10-K (filing date: 2014-11-14), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-Q (filing date: 2014-01-28), 10-K (filing date: 2013-11-18), 10-Q (filing date: 2013-07-30), 10-Q (filing date: 2013-04-30), 10-Q (filing date: 2013-01-29).

Q1 2019 Calculations

1 Operating cycle = Average inventory processing period + Average receivable collection period
= 47 + 10 = 57

Ratio Description The company
Operating cycle Equal to average inventory processing period plus average receivables collection period. Starbucks Corp.’s operating cycle improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.

Average Payables Payment Period

Starbucks Corp., average payables payment period calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Jan 1, 2017 Oct 2, 2016 Jun 26, 2016 Mar 27, 2016 Dec 27, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013 Dec 30, 2012
Selected Financial Data
Payables turnover 9.48 8.63 10.78 11.06 10.85 11.55 12.73 12.74 13.01 11.65 12.19 12.27 12.32 11.38 12.48 12.12 12.88 12.85 14.27 14.08 14.76 12.98 – – –
Ratio (no. of days)
Average payables payment period1 39 42 34 33 34 32 29 29 28 31 30 30 30 32 29 30 28 28 26 26 25 28 – – –

Based on: 10-Q (filing date: 2019-01-29), 10-K (filing date: 2018-11-16), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-Q (filing date: 2018-01-31), 10-K (filing date: 2017-11-17), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-02), 10-Q (filing date: 2017-01-31), 10-K (filing date: 2016-11-18), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-26), 10-Q (filing date: 2016-01-26), 10-K (filing date: 2015-11-12), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-Q (filing date: 2015-01-27), 10-K (filing date: 2014-11-14), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-Q (filing date: 2014-01-28), 10-K (filing date: 2013-11-18), 10-Q (filing date: 2013-07-30), 10-Q (filing date: 2013-04-30), 10-Q (filing date: 2013-01-29).

Q1 2019 Calculations

1 Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 9.48 = 39

Ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Starbucks Corp.’s average payables payment period increased from Q3 2018 to Q4 2018 but then slightly declined from Q4 2018 to Q1 2019.

Cash Conversion Cycle

Starbucks Corp., cash conversion cycle calculation (quarterly data)

No. of days

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Jan 1, 2017 Oct 2, 2016 Jun 26, 2016 Mar 27, 2016 Dec 27, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013 Dec 30, 2012
Selected Financial Data
Average inventory processing period 47 50 51 52 52 55 55 55 52 59 59 58 57 61 57 53 53 58 55 52 53 64 – – –
Average receivable collection period 10 10 13 14 14 14 13 13 15 13 13 13 14 14 13 14 14 14 13 14 14 14 – – –
Average payables payment period 39 42 34 33 34 32 29 29 28 31 30 30 30 32 29 30 28 28 26 26 25 28 – – –
Ratio
Cash conversion cycle1 18 18 30 33 32 37 39 39 39 41 42 41 41 43 41 37 39 44 42 40 42 50 – – –

Based on: 10-Q (filing date: 2019-01-29), 10-K (filing date: 2018-11-16), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-Q (filing date: 2018-01-31), 10-K (filing date: 2017-11-17), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-02), 10-Q (filing date: 2017-01-31), 10-K (filing date: 2016-11-18), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-26), 10-Q (filing date: 2016-01-26), 10-K (filing date: 2015-11-12), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-Q (filing date: 2015-01-27), 10-K (filing date: 2014-11-14), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-Q (filing date: 2014-01-28), 10-K (filing date: 2013-11-18), 10-Q (filing date: 2013-07-30), 10-Q (filing date: 2013-04-30), 10-Q (filing date: 2013-01-29).

Q1 2019 Calculations

1 Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 47 + 10 – 39 = 18

Ratio Description The company
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period.