Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

McDonald’s Corp. (NYSE:MCD)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Beginner level

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

Long-term Activity Ratios (Summary)

McDonald’s Corp., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Net fixed asset turnover 0.81 0.88 0.87 0.90 0.89 0.90 0.92 0.94 0.97 0.98 1.02 1.07 1.11 1.15 1.16 1.08 1.10 1.08 1.10 — — —
Net fixed asset turnover (including operating lease, right-of-use asset) 0.52 0.57 0.56 0.58 0.58 0.59 0.92 0.94 0.97 0.98 1.02 1.07 1.11 1.15 1.16 1.08 1.10 1.08 1.10 — — —
Total asset turnover 0.39 0.41 0.44 0.46 0.45 0.45 0.64 0.62 0.66 0.66 0.68 0.72 0.74 0.76 0.79 0.77 0.76 0.75 0.67 — — —
Equity turnover — — — — — — — — — — — — — — — — 39.26 6.56 3.59 — — —

Based on: 10-Q (filing date: 2020-08-10), 10-Q (filing date: 2020-05-07), 10-K (filing date: 2020-02-26), 10-Q (filing date: 2019-11-04), 10-Q (filing date: 2019-08-06), 10-Q (filing date: 2019-05-08), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-11-01), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-08), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-08), 10-Q (filing date: 2017-05-08), 10-K (filing date: 2017-03-01), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-06), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-11-04), 10-Q (filing date: 2015-08-05), 10-Q (filing date: 2015-05-07).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. McDonald’s Corp.’s net fixed asset turnover ratio improved from Q4 2019 to Q1 2020 but then deteriorated significantly from Q1 2020 to Q2 2020.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). McDonald’s Corp.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q4 2019 to Q1 2020 but then deteriorated significantly from Q1 2020 to Q2 2020.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. McDonald’s Corp.’s total asset turnover ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity.

Net Fixed Asset Turnover

McDonald’s Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Revenues 3,761,500  4,714,400  5,349,000  5,430,600  5,341,300  4,955,600  5,163,000  5,369,400  5,353,900  5,138,900  5,340,200  5,754,600  6,049,700  5,675,900  6,028,900  6,424,100  6,265,000  5,903,900  6,341,300  6,615,100  6,497,700  5,958,900 
Net property and equipment 23,830,000  23,595,900  24,160,000  23,325,300  23,504,200  23,283,500  22,842,700  22,613,600  22,361,200  22,704,000  22,448,300  21,978,600  21,689,300  21,214,100  21,257,600  22,985,700  22,849,900  23,421,800  23,117,600  23,239,400  23,691,200  23,301,700 
Long-term Activity Ratio
Net fixed asset turnover1 0.81 0.88 0.87 0.90 0.89 0.90 0.92 0.94 0.97 0.98 1.02 1.07 1.11 1.15 1.16 1.08 1.10 1.08 1.10 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
Booking Holdings Inc. 15.35 20.16 20.41 21.16 20.60 20.77 22.14 21.96 22.34 23.02 26.41 26.72 27.01 28.89 30.96 30.59 30.60 31.79 33.57 — — —
Starbucks Corp. 4.17 4.22 4.12 4.21 4.16 4.19 4.17 4.24 4.21 4.23 4.55 4.77 4.81 4.84 4.70 4.71 4.75 4.79 4.69 4.63 4.54 4.45

Based on: 10-Q (filing date: 2020-08-10), 10-Q (filing date: 2020-05-07), 10-K (filing date: 2020-02-26), 10-Q (filing date: 2019-11-04), 10-Q (filing date: 2019-08-06), 10-Q (filing date: 2019-05-08), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-11-01), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-08), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-08), 10-Q (filing date: 2017-05-08), 10-K (filing date: 2017-03-01), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-06), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-11-04), 10-Q (filing date: 2015-08-05), 10-Q (filing date: 2015-05-07).

1 Q2 2020 Calculation
Net fixed asset turnover = (RevenuesQ2 2020 + RevenuesQ1 2020 + RevenuesQ4 2019 + RevenuesQ3 2019) ÷ Net property and equipment
= (3,761,500 + 4,714,400 + 5,349,000 + 5,430,600) ÷ 23,830,000 = 0.81

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. McDonald’s Corp.’s net fixed asset turnover ratio improved from Q4 2019 to Q1 2020 but then deteriorated significantly from Q1 2020 to Q2 2020.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

McDonald’s Corp., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Revenues 3,761,500  4,714,400  5,349,000  5,430,600  5,341,300  4,955,600  5,163,000  5,369,400  5,353,900  5,138,900  5,340,200  5,754,600  6,049,700  5,675,900  6,028,900  6,424,100  6,265,000  5,903,900  6,341,300  6,615,100  6,497,700  5,958,900 
 
Net property and equipment 23,830,000  23,595,900  24,160,000  23,325,300  23,504,200  23,283,500  22,842,700  22,613,600  22,361,200  22,704,000  22,448,300  21,978,600  21,689,300  21,214,100  21,257,600  22,985,700  22,849,900  23,421,800  23,117,600  23,239,400  23,691,200  23,301,700 
Lease right-of-use asset, net 13,002,300  13,029,600  13,261,200  12,465,600  12,522,800  12,325,200  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Net property and equipment (including operating lease, right-of-use asset) 36,832,300  36,625,500  37,421,200  35,790,900  36,027,000  35,608,700  22,842,700  22,613,600  22,361,200  22,704,000  22,448,300  21,978,600  21,689,300  21,214,100  21,257,600  22,985,700  22,849,900  23,421,800  23,117,600  23,239,400  23,691,200  23,301,700 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 0.52 0.57 0.56 0.58 0.58 0.59 0.92 0.94 0.97 0.98 1.02 1.07 1.11 1.15 1.16 1.08 1.10 1.08 1.10 — — —
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Booking Holdings Inc. 8.60 11.03 11.09 11.35 10.88 10.85 22.14 21.96 22.34 23.02 26.41 26.72 27.01 28.89 30.96 30.59 30.60 31.79 33.57 — — —
Starbucks Corp. 1.82 1.83 4.12 4.21 4.16 4.19 4.17 4.24 4.21 4.23 4.55 4.77 4.81 4.84 4.70 4.71 4.75 4.79 4.69 4.63 4.54 4.45

Based on: 10-Q (filing date: 2020-08-10), 10-Q (filing date: 2020-05-07), 10-K (filing date: 2020-02-26), 10-Q (filing date: 2019-11-04), 10-Q (filing date: 2019-08-06), 10-Q (filing date: 2019-05-08), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-11-01), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-08), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-08), 10-Q (filing date: 2017-05-08), 10-K (filing date: 2017-03-01), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-06), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-11-04), 10-Q (filing date: 2015-08-05), 10-Q (filing date: 2015-05-07).

1 Q2 2020 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (RevenuesQ2 2020 + RevenuesQ1 2020 + RevenuesQ4 2019 + RevenuesQ3 2019) ÷ Net property and equipment (including operating lease, right-of-use asset)
= (3,761,500 + 4,714,400 + 5,349,000 + 5,430,600) ÷ 36,832,300 = 0.52

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). McDonald’s Corp.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q4 2019 to Q1 2020 but then deteriorated significantly from Q1 2020 to Q2 2020.

Total Asset Turnover

McDonald’s Corp., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Revenues 3,761,500  4,714,400  5,349,000  5,430,600  5,341,300  4,955,600  5,163,000  5,369,400  5,353,900  5,138,900  5,340,200  5,754,600  6,049,700  5,675,900  6,028,900  6,424,100  6,265,000  5,903,900  6,341,300  6,615,100  6,497,700  5,958,900 
Total assets 49,938,900  50,568,000  47,510,800  45,805,000  46,199,800  46,466,600  32,811,200  34,053,700  32,708,400  33,722,900  33,803,700  32,559,600  32,785,200  32,120,300  31,023,900  32,486,900  33,146,500  33,795,400  37,938,700  32,959,500  34,947,900  32,155,600 
Long-term Activity Ratio
Total asset turnover1 0.39 0.41 0.44 0.46 0.45 0.45 0.64 0.62 0.66 0.66 0.68 0.72 0.74 0.76 0.79 0.77 0.76 0.75 0.67 — — —
Benchmarks
Total Asset Turnover, Competitors2
Booking Holdings Inc. 0.54 0.81 0.70 0.70 0.69 0.65 0.64 0.58 0.54 0.53 0.50 0.47 0.49 0.50 0.54 0.52 0.50 0.52 0.53 — — —
Starbucks Corp. 0.97 0.97 1.38 1.25 1.45 1.27 1.02 1.40 1.34 1.23 1.56 1.54 1.54 1.55 1.49 1.48 1.61 1.52 1.54 1.43 1.45 1.38

Based on: 10-Q (filing date: 2020-08-10), 10-Q (filing date: 2020-05-07), 10-K (filing date: 2020-02-26), 10-Q (filing date: 2019-11-04), 10-Q (filing date: 2019-08-06), 10-Q (filing date: 2019-05-08), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-11-01), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-08), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-08), 10-Q (filing date: 2017-05-08), 10-K (filing date: 2017-03-01), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-06), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-11-04), 10-Q (filing date: 2015-08-05), 10-Q (filing date: 2015-05-07).

1 Q2 2020 Calculation
Total asset turnover = (RevenuesQ2 2020 + RevenuesQ1 2020 + RevenuesQ4 2019 + RevenuesQ3 2019) ÷ Total assets
= (3,761,500 + 4,714,400 + 5,349,000 + 5,430,600) ÷ 49,938,900 = 0.39

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. McDonald’s Corp.’s total asset turnover ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Equity Turnover

McDonald’s Corp., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Revenues 3,761,500  4,714,400  5,349,000  5,430,600  5,341,300  4,955,600  5,163,000  5,369,400  5,353,900  5,138,900  5,340,200  5,754,600  6,049,700  5,675,900  6,028,900  6,424,100  6,265,000  5,903,900  6,341,300  6,615,100  6,497,700  5,958,900 
Shareholders’ equity (deficit) (9,463,100) (9,293,400) (8,210,300) (8,599,200) (6,808,800) (6,550,900) (6,258,400) (6,792,600) (5,851,000) (4,718,800) (3,268,000) (3,477,600) (2,000,600) (2,030,800) (2,204,300) (1,624,100) 640,000  3,863,000  7,087,900  8,309,800  10,560,900  11,403,300 
Long-term Activity Ratio
Equity turnover1 — — — — — — — — — — — — — — — — 39.26 6.56 3.59 — — —
Benchmarks
Equity Turnover, Competitors2
Booking Holdings Inc. 2.82 3.79 2.54 2.51 2.78 2.09 1.65 1.42 1.31 1.24 1.13 0.95 0.99 1.02 1.09 1.06 1.06 1.05 1.05 — — —
Starbucks Corp. — — — — — — 21.14 6.04 4.98 3.95 4.11 3.83 3.92 3.74 3.62 3.59 3.96 3.30 3.29 3.15 2.95 2.95

Based on: 10-Q (filing date: 2020-08-10), 10-Q (filing date: 2020-05-07), 10-K (filing date: 2020-02-26), 10-Q (filing date: 2019-11-04), 10-Q (filing date: 2019-08-06), 10-Q (filing date: 2019-05-08), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-11-01), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-08), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-08), 10-Q (filing date: 2017-05-08), 10-K (filing date: 2017-03-01), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-06), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-11-04), 10-Q (filing date: 2015-08-05), 10-Q (filing date: 2015-05-07).

1 Q2 2020 Calculation
Equity turnover = (RevenuesQ2 2020 + RevenuesQ1 2020 + RevenuesQ4 2019 + RevenuesQ3 2019) ÷ Shareholders’ equity (deficit)
= (3,761,500 + 4,714,400 + 5,349,000 + 5,430,600) ÷ -9,463,100 = —

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity.