Microsoft Excel LibreOffice Calc

McDonald’s Corp. (MCD)


Analysis of Operating Leases

Advanced level


Present Value of Future Operating Lease Payments (before Adoption of FASB Topic 842)

McDonald’s Corp., future operating lease payments (before adoption of FASB Topic 842)

US$ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Total undiscounted future operating lease payments 12,266,300  11,856,900  12,252,500  12,514,800  13,160,200 
Discount rate1 3.15% 3.11% 3.19% 3.55% 3.98%
 
Total present value of future operating lease payments 9,938,824  9,673,356  10,093,270  10,084,719  10,332,652 

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-03-01), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-24).

1 Weighted-average interest rate for McDonald’s Corp.’s debt

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 3.15%
2019 1,144,700  2019 1,144,700  1,109,743 
2020 1,083,100  2020 1,083,100  1,017,959 
2021 1,001,200  2021 1,001,200  912,248 
2022 909,500  2022 909,500  803,389 
2023 830,600  2023 830,600  711,288 
2024 and thereafter 7,297,200  2024 830,600  689,567 
2025 830,600  668,509 
2026 830,600  648,094 
2027 830,600  628,303 
2028 830,600  609,115 
2029 830,600  590,514 
2030 830,600  572,481 
2031 830,600  554,999 
2032 652,400  422,615 
Total: 12,266,300  12,266,300  9,938,824 

Based on: 10-K (filing date: 2019-02-22).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 3.11%
2018 1,151,900  2018 1,151,900  1,117,156 
2019 1,087,000  2019 1,087,000  1,022,417 
2020 996,700  2020 996,700  909,206 
2021 903,500  2021 903,500  799,328 
2022 805,500  2022 805,500  691,133 
2023 and thereafter 6,912,300  2023 805,500  670,287 
2024 805,500  650,070 
2025 805,500  630,462 
2026 805,500  611,446 
2027 805,500  593,004 
2028 805,500  575,118 
2029 805,500  557,771 
2030 805,500  540,948 
2031 468,300  305,009 
Total: 11,856,900  11,856,900  9,673,356 

Based on: 10-K (filing date: 2018-02-23).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 3.19%
2017 1,303,000  2017 1,303,000  1,262,719 
2018 1,199,900  2018 1,199,900  1,126,860 
2019 1,102,500  2019 1,102,500  1,003,381 
2020 1,000,800  2020 1,000,800  882,667 
2021 891,900  2021 891,900  762,304 
2022 and thereafter 6,754,400  2022 891,900  738,738 
2023 891,900  715,901 
2024 891,900  693,770 
2025 891,900  672,323 
2026 891,900  651,538 
2027 891,900  631,397 
2028 891,900  611,878 
2029 511,100  339,795 
Total: 12,252,500  12,252,500  10,093,270 

Based on: 10-K (filing date: 2017-03-01).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 3.55%
2016 1,349,900  2016 1,349,900  1,303,621 
2017 1,235,100  2017 1,235,100  1,151,866 
2018 1,112,500  2018 1,112,500  1,001,958 
2019 1,001,100  2019 1,001,100  870,717 
2020 894,800  2020 894,800  751,580 
2021 and thereafter 6,921,400  2021 894,800  725,814 
2022 894,800  700,931 
2023 894,800  676,901 
2024 894,800  653,695 
2025 894,800  631,284 
2026 894,800  609,642 
2027 894,800  588,742 
2028 657,800  417,968 
Total: 12,514,800  12,514,800  10,084,719 

Based on: 10-K (filing date: 2016-02-25).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 3.98%
2015 1,381,800  2015 1,381,800  1,328,909 
2016 1,288,900  2016 1,288,900  1,192,119 
2017 1,163,200  2017 1,163,200  1,034,677 
2018 1,044,100  2018 1,044,100  893,188 
2019 946,700  2019 946,700  778,867 
2020 and thereafter 7,335,500  2020 946,700  749,055 
2021 946,700  720,383 
2022 946,700  692,810 
2023 946,700  666,291 
2024 946,700  640,788 
2025 946,700  616,261 
2026 946,700  592,672 
2027 708,600  426,632 
Total: 13,160,200  13,160,200  10,332,652 

Based on: 10-K (filing date: 2015-02-24).


Adjustments to Financial Statements for Operating Leases

McDonald’s Corp., adjustments to financial statements

US$ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Adjustment to Total Assets
Total assets (as reported) 32,811,200  33,803,700  31,023,900  37,938,700  34,281,400 
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 9,938,824  9,673,356  10,093,270  10,084,719  10,332,652 
Total assets (adjusted) 42,750,024  43,477,056  41,117,170  48,023,419  44,614,052 
Adjustment to Total Debt
Total debt (as reported) 31,075,300  29,536,400  25,955,700  24,122,100  14,989,700 
Add: Operating lease liability (before adoption of FASB Topic 842)2 9,938,824  9,673,356  10,093,270  10,084,719  10,332,652 
Total debt (adjusted) 41,014,124  39,209,756  36,048,970  34,206,819  25,322,352 

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-03-01), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-24).

1, 2 Equal to total present value of future operating lease payments.


McDonald’s Corp., Financial Data: Reported vs. Adjusted


Adjusted Financial Ratios for Operating Leases (Summary)

McDonald’s Corp., adjusted financial ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Total Asset Turnover1
Reported total asset turnover 0.64 0.68 0.79 0.67 0.80
Adjusted total asset turnover 0.49 0.52 0.60 0.53 0.62
Debt to Equity2
Reported debt to equity 3.40 1.17
Adjusted debt to equity 4.83 1.97
Return on Assets3 (ROA)
Reported ROA 18.06% 15.36% 15.11% 11.94% 13.88%
Adjusted ROA 13.86% 11.94% 11.40% 9.43% 10.66%

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-03-01), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-24).

Financial ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. McDonald’s Corp.’s adjusted total asset turnover ratio deteriorated from 2016 to 2017 and from 2017 to 2018.
Adjusted debt to equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. McDonald’s Corp.’s adjusted ROA improved from 2016 to 2017 and from 2017 to 2018.

McDonald’s Corp., Financial Ratios: Reported vs. Adjusted


Adjusted Total Asset Turnover

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Selected Financial Data (US$ in thousands)
Revenues 21,025,200  22,820,400  24,621,900  25,413,000  27,441,300 
Total assets 32,811,200  33,803,700  31,023,900  37,938,700  34,281,400 
Activity Ratio
Total asset turnover1 0.64 0.68 0.79 0.67 0.80
Adjusted for Operating Leases
Selected Financial Data (US$ in thousands)
Revenues 21,025,200  22,820,400  24,621,900  25,413,000  27,441,300 
Adjusted total assets 42,750,024  43,477,056  41,117,170  48,023,419  44,614,052 
Activity Ratio
Adjusted total asset turnover2 0.49 0.52 0.60 0.53 0.62

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-03-01), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-24).

2018 Calculations

1 Total asset turnover = Revenues ÷ Total assets
= 21,025,200 ÷ 32,811,200 = 0.64

2 Adjusted total asset turnover = Revenues ÷ Adjusted total assets
= 21,025,200 ÷ 42,750,024 = 0.49

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. McDonald’s Corp.’s adjusted total asset turnover ratio deteriorated from 2016 to 2017 and from 2017 to 2018.

Adjusted Debt to Equity

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Selected Financial Data (US$ in thousands)
Total debt 31,075,300  29,536,400  25,955,700  24,122,100  14,989,700 
Shareholders’ equity (deficit) (6,258,400) (3,268,000) (2,204,300) 7,087,900  12,853,400 
Solvency Ratio
Debt to equity1 3.40 1.17
Adjusted for Operating Leases
Selected Financial Data (US$ in thousands)
Adjusted total debt 41,014,124  39,209,756  36,048,970  34,206,819  25,322,352 
Shareholders’ equity (deficit) (6,258,400) (3,268,000) (2,204,300) 7,087,900  12,853,400 
Solvency Ratio
Adjusted debt to equity2 4.83 1.97

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-03-01), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-24).

2018 Calculations

1 Debt to equity = Total debt ÷ Shareholders’ equity (deficit)
= 31,075,300 ÷ -6,258,400 =

2 Adjusted debt to equity = Adjusted total debt ÷ Shareholders’ equity (deficit)
= 41,014,124 ÷ -6,258,400 =

Solvency ratio Description The company
Adjusted debt-to-equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity.

Adjusted Return on Assets (ROA)

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Selected Financial Data (US$ in thousands)
Net income 5,924,300  5,192,300  4,686,500  4,529,300  4,757,800 
Total assets 32,811,200  33,803,700  31,023,900  37,938,700  34,281,400 
Profitability Ratio
ROA1 18.06% 15.36% 15.11% 11.94% 13.88%
Adjusted for Operating Leases
Selected Financial Data (US$ in thousands)
Net income 5,924,300  5,192,300  4,686,500  4,529,300  4,757,800 
Adjusted total assets 42,750,024  43,477,056  41,117,170  48,023,419  44,614,052 
Profitability Ratio
Adjusted ROA2 13.86% 11.94% 11.40% 9.43% 10.66%

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-03-01), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-24).

2018 Calculations

1 ROA = 100 × Net income ÷ Total assets
= 100 × 5,924,300 ÷ 32,811,200 = 18.06%

2 Adjusted ROA = 100 × Net income ÷ Adjusted total assets
= 100 × 5,924,300 ÷ 42,750,024 = 13.86%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. McDonald’s Corp.’s adjusted ROA improved from 2016 to 2017 and from 2017 to 2018.