# McDonald's (MCD) Financial Model Free Excel 3-statement financial model and company analysis for McDonald's. - Canonical: https://finamodel.com/companies/mcdonalds - Industry: Restaurants - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/MCD.xlsx ## Model Purpose This model provides a comprehensive equity valuation and cash flow forecast to determine the intrinsic value and dividend sustainability of McDonald's Corporation, focusing on its highly franchised, real estate-backed business model. ## Company Overview McDonald's is a leading global foodservice retailer operating and franchising over 40,000 restaurants across more than 100 countries. The company operates a heavily franchised business model where approximately 95% of restaurants are owned and operated by independent local business owners, while McDonald's retains ownership or long-term leases on the underlying real estate. Business segments include: * U.S. (approximately 41% of total revenue) * International Operated Markets or IOM (approximately 49% of total revenue) * International Developmental Licensed Markets & Corporate or IDL (approximately 10% of total revenue) The business model is asset-light regarding daily restaurant operations but asset-heavy regarding real estate. McDonald's generates revenue through company-operated restaurant sales and franchise fees, which include rent, royalties, and initial fees. The competitive position is dominant, holding the top market share in the global quick-service restaurant industry, competing primarily with Yum! Brands, Restaurant Brands International, and Starbucks. Recent major events include the "Accelerating the Arches" strategic growth plan, which focuses on digital, delivery, drive-thru, and aggressive new restaurant development. ## Revenue Deep Dive ### U.S. Segment * **Segment name**: U.S. * **Revenue driver formula**: (Beginning Restaurants + Net Additions) x Average Unit Volume x (1 + Comparable Sales Growth) * **Historical growth rate**: 4% to 8% CAGR over the last 3 years. * **Key growth levers and headwinds**: Digital app adoption, loyalty programme growth, menu pricing power, and value-menu promotions. Headwinds include lower-income consumer spending pressure and wage inflation impacting franchisee profitability. * **Pricing dynamics**: Highly competitive and localised. Franchisees set their own prices, but corporate guides national value campaigns. * **Revenue recognition notes**: Franchise royalties are recognised as underlying sales occur. Rent is recognised straight-line over the lease term. * **Seasonality**: Relatively stable, though the second and third quarters typically see slightly higher volumes due to summer travel and weather. ### International Operated Markets (IOM) * **Segment name**: International Operated Markets * **Revenue driver formula**: Systemwide Sales x Blended Franchise Take Rate (for franchised) + Company-Operated Volume (for owned) * **Historical growth rate**: 5% to 9% CAGR, heavily influenced by foreign exchange movements. * **Key growth levers and headwinds**: European consumer confidence, energy costs, and inflation. Key markets include the UK, France, Germany, Australia, and Canada. * **Pricing dynamics**: Similar to the U.S. but subject to stricter local labour and pricing regulations in European markets. * **Revenue recognition notes**: Same as the U.S. segment. * **Seasonality**: Similar to the U.S., with summer months driving higher footfall. ### International Developmental Licensed Markets & Corporate (IDL) * **Segment name**: International Developmental Licensed Markets & Corporate * **Revenue driver formula**: Systemwide Sales x Royalty Rate * **Historical growth rate**: 8% to 12% CAGR. * **Key growth levers and headwinds**: Rapid unit expansion in China and Latin America. Headwinds include geopolitical tensions and macroeconomic volatility in emerging markets. * **Pricing dynamics**: Master franchisees control pricing and capital expenditure. McDonald's receives a top-line royalty. * **Revenue recognition notes**: Primarily royalty income recognised as sales occur. McDonald's generally does not own the real estate in these markets. * **Seasonality**: Varies widely by geography, but generally smooths out on a consolidated basis. ## Cost Structure ### Variable Costs / COGS * **Line-by-line breakdown**: Company-operated restaurant expenses include Food & paper, Payroll & employee benefits, and Occupancy & other operating expenses. Franchised restaurant expenses include Occupancy costs (primarily depreciation and rent for leased properties). * **Gross margin range**: Company-operated margins range from 15% to 17%. Franchised margins range from 82% to 84%. * **Key input costs and commodity exposures**: Beef, chicken, dairy, wheat, and paper products. Labour is a massive input cost for company-operated stores. * **How COGS scales with revenue**: Food and paper scale linearly with company-operated sales. Occupancy costs are largely fixed, providing significant operating leverage when comparable sales rise. ### Operating Expenses * **R&D**: Not material and not separately disclosed. Menu development costs are absorbed into general SG&A. * **SG&A**: Typically 9% to 10% of total revenue. It covers corporate headcount, IT investments, and global marketing funds. * **Depreciation & Amortisation**: Approximately 7% to 8% of total revenue, heavily driven by the massive real estate portfolio and restaurant building capitalisation. * **Stock-Based Compensation**: Not a major driver compared to tech firms, typically running below 1% of revenue. * **Restructuring / one-time charges**: Occasional charges related to corporate headcount reductions or market exits (such as the Russia exit in 2022), usually ranging from $100 million to $500 million when they occur. ### Margin Profile * **Gross margin**: Consolidated restaurant margin typically sits between 52% and 55%, heavily skewed by the highly profitable franchise revenue stream. * **EBITDA margin**: 50% to 53%. * **Operating margin**: 45% to 47%. * **Net margin**: 30% to 33%. * **Margin trend**: Expanding over the long term due to the refranchising strategy completed in the late 2010s, which shifted the revenue mix towards high-margin franchise rent and royalties. ## Balance Sheet Structure * **Total assets**: Approximately $50 billion to $56 billion. * **Key asset categories**: Property and equipment (net) is the largest asset, representing the owned land and buildings leased to franchisees. * **Goodwill & intangibles**: Approximately $2.5 billion to $3.0 billion, representing a small percentage of total assets (around 5%). * **Working capital profile**: * **Days Sales Outstanding (DSO)**: 15 to 20 days (receivables are mostly franchisee rent and royalties). * **Days Inventory Outstanding (DIO)**: 5 to 8 days (inventory turns over extremely fast). * **Days Payable Outstanding (DPO)**: 35 to 45 days. * **Net working capital as % of revenue**: Consistently negative. * **Is working capital positive or negative?**: Negative. McDonald's uses its suppliers to fund its short-term operations, creating a structural cash flow advantage. * **PP&E**: Gross PP&E exceeds $40 billion, primarily land and buildings. Useful lives are typically 30 to 40 years for buildings. Maintenance capex is a smaller portion compared to new site development and remodels. * **Right-of-use assets / operating leases**: Material. Operating lease right-of-use assets typically total $12 billion to $14 billion, reflecting ground leases where McDonald's leases the land and subleases it to franchisees. ## Capital Expenditure & Investment * **Capex as % of revenue**: 9% to 11% (approximately $2.4 billion to $2.7 billion annually). * **Maintenance capex vs. growth capex**: Roughly 40% maintenance and technology reinvestment, 60% growth (new restaurant openings). * **Major capex programmes underway or planned**: The company plans to open thousands of new restaurants globally under its current strategic plan, pushing capex towards the higher end of historical ranges. * **Capitalised software / development costs**: Present for digital app and kiosk development, but minor relative to real estate capex. * **M&A pattern**: Organic grower. McDonald's rarely acquires other brands. * **Typical acquisition multiple paid**: Not applicable. ## Debt & Capital Structure * **Total debt**: Approximately $37 billion to $39 billion. * **Debt/EBITDA ratio**: Typically managed between 2.5x and 3.0x. * **Credit rating**: BBB+ (S&P), Baa1 (Moody's). * **Key debt instruments**: Primarily fixed-rate senior unsecured notes issued in multiple currencies (USD, EUR, GBP) to match cash flows. * **Maturity profile**: Well-laddered over 10 to 30 years. * **Interest rate profile**: Predominantly fixed rate. Weighted average interest rate is typically 3.5% to 4.5%. * **Covenants**: Standard investment-grade covenants. No restrictive financial maintenance covenants that pose near-term risk. * **Share repurchase programme**: Highly active. The company routinely buys back $2 billion to $4 billion of stock annually, resulting in a massive treasury stock balance. * **Dividend policy**: Dividend Aristocrat. The payout ratio targets 50% to 55% of net income, with a yield typically between 2.0% and 2.5%. ## Cash Flow Characteristics * **Operating cash flow conversion**: OCF to Net Income is consistently above 1.1x. * **Free cash flow margin**: 25% to 30% of total revenue. * **Major non-cash items**: Depreciation and amortisation (over $1.8 billion), deferred income taxes, and share-based compensation. * **Working capital cash flow impact**: Generally a slight source of cash as the business grows, due to the negative working capital dynamic. * **Capex intensity**: Moderate. While real estate is expensive, the absolute dollar revenue generated across the system makes the corporate capex intensity manageable. * **Cash tax rate vs. GAAP effective tax rate**: Cash taxes generally track closely to the GAAP effective tax rate of 20% to 22%. ## Sheet Structure 1. **Cover**: Company name, ticker, model builder details, and date of last update. 2. **Assumptions**: All hardcoded inputs, including macroeconomic drivers, segment growth rates, margin profiles, tax rates, and WACC. 3. **Scenarios**: Base, Bull, and Bear case toggles linked to the Assumptions sheet. 4. **Revenue & Margin Build**: Detailed build for U.S., IOM, and IDL segments. Must separate Company-operated sales and Franchised revenues. Must calculate Company-operated margins and Franchised margins separately. 5. **Income Statement**: Consolidated P&L mirroring the 10-K. Line items must include Company-operated sales, Franchised revenues, Total revenues, Company-operated restaurant expenses, Franchised restaurants-occupancy expenses, SG&A, Other operating income/expense, Operating income, Interest expense, and Net income. 6. **Balance Sheet**: Standard format. Must include specific lines for Lease right-of-use assets, Operating lease liabilities, and a massive negative Treasury stock line. 7. **Cash Flow Statement**: Indirect method starting from Net income. Must break out additions to property and equipment, purchases of treasury stock, and dividend payments. 8. **Debt Schedule**: Tranche-by-tranche breakdown of senior notes, calculating interest expense and tracking maturities. 9. **PP&E & Leases**: Roll-forward of gross property, accumulated depreciation, and operating lease liabilities. 10. **DCF**: Unlevered free cash flow calculation, WACC build, terminal value using perpetuity growth, and implied share price. ## Key Financial Relationships 1. Total Revenues = Company-operated sales + Franchised revenues 2. Company-operated sales = Prior Year Company-operated sales x (1 + Company-operated Net Store Growth) x (1 + Company-operated Comparable Sales) 3. Franchised revenues = Prior Year Franchised revenues x (1 + Franchised Net Store Growth) x (1 + Franchised Comparable Sales) 4. Company-operated margin = Company-operated sales - Company-operated restaurant expenses 5. Company-operated margin % = Company-operated margin / Company-operated sales 6. Franchised margin = Franchised revenues - Franchised restaurants-occupancy expenses 7. Franchised margin % = Franchised margin / Franchised revenues 8. Total Restaurant Margin = Company-operated margin + Franchised margin 9. Operating Income = Total Restaurant Margin - SG&A + Other operating income/expense 10. Net Interest Expense = Average Total Debt x Weighted Average Interest Rate 11. Effective Tax Rate = Provision for income taxes / Income before provision for income taxes 12. Free Cash Flow = Cash provided by operations - Capital expenditures 13. Ending Treasury Stock = Beginning Treasury Stock - Share Repurchases 14. Dividends Paid = Prior Quarter Shares Outstanding x Annualised Dividend per Share ## Cross-Sheet Dependencies * The **Assumptions** sheet feeds the **Revenue & Margin Build**, **Income Statement**, and **Balance Sheet**. * The **Revenue & Margin Build** calculates top-line and direct cost figures, which flow directly into the **Income Statement**. * **Income Statement** net income flows to the top of the **Cash Flow Statement** and into Retained Earnings on the **Balance Sheet**. * **PP&E & Leases** calculates depreciation, which feeds the **Income Statement** (within occupancy costs and SG&A) and the **Cash Flow Statement** (non-cash add-back). * The **Debt Schedule** calculates interest expense for the **Income Statement** and ending debt balances for the **Balance Sheet**. Circularity risk exists here if interest expense reduces cash, which increases revolver borrowing, which increases interest expense. A circuit breaker toggle must be included. * The **Cash Flow Statement** generates the net change in cash, which links to the Cash line on the **Balance Sheet** to ensure total assets equal total liabilities and equity. ## Sign Convention * Revenues and income items are entered as positive numbers. * Expenses on the Income Statement are entered as positive numbers and subtracted in subtotal formulas (e.g., Gross Margin = Revenue - COGS). * Assets, Liabilities, and Equity balances are positive numbers. Treasury stock is a negative number within Equity. * On the Cash Flow Statement, cash inflows are positive and cash outflows (such as capital expenditures, dividends, and share repurchases) are negative. ## Things Most Likely to Go Wrong 1. **Negative Equity Confusion**: McDonald's has a massive accumulated deficit and negative total equity due to decades of aggressive share buybacks. The model must allow for negative total equity without triggering balance sheet error flags. 2. **Franchise vs. Company Margin Mix**: Franchised margins are around 83%, while company-operated margins are around 16%. A slight error in forecasting the mix between these two revenue streams will drastically skew consolidated operating income. 3. **Foreign Exchange Volatility**: Over 50% of revenue comes from outside the U.S. Foreign currency translation can swing reported revenue by 3% to 5% year-over-year. The model should ideally forecast on a constant-currency basis and apply an FX overlay. 4. **Real Estate Depreciation**: Franchised occupancy expenses consist almost entirely of depreciation on the buildings McDonald's owns. If PP&E capex is modelled incorrectly, this expense line will drift, distorting franchise margins. 5. **Lease Accounting**: Operating lease liabilities and right-of-use assets are massive. The builder must ensure lease amortisation is handled correctly and does not double-count against standard debt metrics. 6. **G&A Allocation**: SG&A is reported on a consolidated basis. Do not attempt to allocate SG&A down to the segment level, as McDonald's does not report segment-level operating income net of corporate overhead. 7. **Other Operating Income**: This line often includes gains on sales of restaurant businesses (refranchising). It should be modelled as a historical average percentage of revenue but excluded from core adjusted EBITDA. 8. **Share Count Reduction**: The share count decreases steadily every year. Failing to model the declining share count will result in an understated EPS and an overstated total dividend cash outflow. ## Validation Checks 1. "Consolidated Operating Margin should be in the 45% to 47% range; flag if outside this band." 2. "Franchised Margin % must remain between 82% and 85%; flag if it drops below 80%." 3. "Company-Operated Margin % should be between 14% and 18%." 4. "Total Equity must be negative; flag if the model forecasts positive equity in the near term." 5. "Capex as a % of total revenue should run between 9% and 11%." 6. "Free Cash Flow conversion (FCF / Net Income) should be >0.85x." 7. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period." 8. "Debt/EBITDA should remain between 2.5x and 3.2x per rating agency guidance." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | U.S. Comparable Sales Growth | 3.5 | % | Aligns with long-term historical averages and recent normalised pricing power. | | IOM Comparable Sales Growth | 4.0 | % | Reflects steady European demand and inflation-linked pricing. | | IDL Comparable Sales Growth | 5.0 | % | Higher growth expectation for emerging markets. | | Company-Operated Margin | 15.5 | % | Based on recent 3-year historical average, accounting for elevated labour costs. | | Franchised Margin | 83.5 | % | Highly stable historical average driven by fixed rent and percentage royalties. | | SG&A as % of Systemwide Sales | 2.2 | % | Management's long-term target metric for corporate overhead efficiency. | | Effective Tax Rate | 21.0 | % | Blended global statutory rates and historical actuals. | | Capex as % of Revenue | 10.0 | % | Reflects the "Accelerating the Arches" aggressive new store development plan. | | Weighted Average Interest Rate | 4.2 | % | Based on the current debt portfolio and recent refinancing rates. | | Annual Share Repurchases | 3,000 | $ Millions | Consistent with management's historical capital return programme. | | Dividend Payout Ratio | 53.0 | % | Midpoint of management's historical target payout range. | | Days Sales Outstanding (DSO) | 18 | Days | Calculated from historical receivables and total revenue. | | Days Payable Outstanding (DPO) | 40 | Days | Calculated from historical accounts payable and operating costs. | | WACC | 7.5 | % | Reflects low beta, high leverage, and current risk-free rates. | | Terminal Growth Rate | 2.5 | % | Aligns with long-term global GDP and inflation expectations. | ## Data Sources & Benchmarks * **Filings**: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the McDonald's Investor Relations website. * **Key peers for benchmarking**: Yum! Brands (YUM), Restaurant Brands International (QSR), Starbucks (SBUX), Chipotle Mexican Grill (CMG). * **Industry data sources**: Technomic (for systemwide sales rankings), QSR Magazine, Black Box Intelligence (for restaurant traffic and comp sales data). * **Consensus estimates source**: Bloomberg, FactSet, or Yahoo Finance for near-term revenue and EPS consensus. ## Sources * McDonald's Corporation Form 10-K for the fiscal year ended 31 December 2023 and 2024. * McDonald's Investor Relations: "Accelerating the Arches" strategy presentations. * SEC EDGAR database (https://www.sec.gov/edgar). * Standard & Poor's and Moody's credit rating reports for McDonald's Corporation. --- ## Frequently asked questions ### What is McDonald's business model and how does it generate revenue? McDonald's operates a highly franchised business model, with approximately 95% of its over 40,000 restaurants owned by independent local business owners. The company generates revenue through sales from its company-operated restaurants and various franchise fees, including rent, royalties, and initial fees from its franchisees. McDonald's also retains ownership or long-term leases on the underlying real estate for most of its franchised locations. ### What are the primary revenue drivers for McDonald's Corporation? McDonald's revenue is primarily driven by sales from its company-operated restaurants and the fees collected from its vast network of franchised restaurants. These franchise fees encompass rent, royalties, and initial fees, reflecting the company's real estate-backed business model. The U.S. and International Operated Markets segments contribute the largest portions to total revenue. ### What is McDonald's typical capital expenditure as a percentage of revenue? McDonald's typically allocates 9% to 11% of its revenue towards capital expenditures, amounting to approximately $2.4 billion to $2.7 billion annually. This capex is roughly split, with 40% going to maintenance and technology reinvestment, and 60% dedicated to growth initiatives like new restaurant openings. The company plans significant new restaurant development globally, which may push capex towards the higher end of this range. ### What are the key financial assumptions used in the McDonald's financial model? Key assumptions in the McDonald's financial model include a revenue growth rate of approximately 4.5% and a Cost of Goods Sold (COGS) as a percentage of revenue around 55%. Selling, General, and Administrative (SGA) expenses are assumed to be about 11.7% of revenue, while the tax rate is forecast at approximately 21.15%. Capital expenditure is modeled at about 9.2% of revenue. ### What is the purpose of the McDonald's financial model and its valuation focus? The McDonald's financial model aims to provide a comprehensive equity valuation and cash flow forecast for the company. Its primary purpose is to determine the intrinsic value of McDonald's Corporation and assess the sustainability of its dividends. The model specifically focuses on the company's highly franchised, real estate-backed business model. ### Can I download an Excel financial model for McDonald's (MCD)? Yes, an Excel financial model for McDonald's (MCD) is available for download. This model provides a detailed forecast horizon from FY2026 to FY2030, offering insights into the company's financial performance and valuation. It is designed as a general corporate model for comprehensive analysis. [Interactive forecast calculator](https://finamodel.com/companies/mcdonalds/forecast)