# Equifax (EFX) Financial Model Free Excel 3-statement financial model and company analysis for Equifax. - Canonical: https://finamodel.com/companies/equifax - Industry: Business Services - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/EFX.xlsx ## Model Purpose This model provides a comprehensive equity valuation and scenario planning tool for Equifax, enabling an analyst to forecast earnings and cash flows based on the company's sensitivity to U.S. mortgage origination volumes, non-mortgage hiring trends, and the operational leverage gained from its recent cloud technology transformation. ## Company Overview Equifax is a global data, analytics, and technology company that provides information solutions and human resources business process outsourcing services. The company aggregates demographic, credit, and employment data to help financial institutions, employers, and government agencies make critical risk and verification decisions. Business segments include: * Workforce Solutions (approx. 43% of revenue) * U.S. Information Solutions (approx. 33% of revenue) * International (approx. 24% of revenue) The company operates primarily in North America, Latin America, Europe, and the Asia Pacific region. Equifax runs an asset-light, highly scalable data business model characterised by high barriers to entry and an oligopolistic market structure alongside Experian and TransUnion. Its competitive position is uniquely strengthened by "The Work Number" database within Workforce Solutions, which holds proprietary income and employment records. Recent major events include the near-completion of a massive multi-year "Equifax Cloud" migration and the acquisitions of Appriss Insights and Boa Vista Serviços. ## Revenue Deep Dive ### Workforce Solutions (WS) * **Segment name:** Workforce Solutions (comprising Verification Services and Employer Services) * **Revenue driver formula:** (Mortgage Inquiries x Verification Hit Rate x Price per Verification) + (Non-Mortgage Hiring Volumes x Price) + Subscription Fees * **Historical growth rate:** 7% to 15% CAGR (highly volatile based on the U.S. mortgage cycle) * **Key growth levers and headwinds:** Growth is driven by expanding the number of active records in The Work Number and penetrating non-mortgage verticals like government and talent solutions. Headwinds include elevated interest rates depressing U.S. mortgage originations and slower U.S. hiring. * **Pricing dynamics:** High pricing power due to the proprietary nature of the data. Pricing is a mix of per-transaction fees and subscription minimums. * **Revenue recognition notes:** Transaction fees are recognised at the point of data delivery. Subscription revenues are recognised rateably over the contract term. * **Seasonality:** Modestly stronger in Q2 and Q3 due to peak homebuying seasons. ### U.S. Information Solutions (USIS) * **Segment name:** U.S. Information Solutions (comprising Online Information Solutions, Mortgage Solutions, and Financial Marketing Services) * **Revenue driver formula:** Consumer Credit Pulls x Price per Report + Batch Marketing Subscriptions * **Historical growth rate:** 3% to 8% CAGR * **Key growth levers and headwinds:** Driven by auto loans, credit card issuance, and personal loan originations. Mortgage Solutions relies heavily on tri-merge credit report volumes. * **Pricing dynamics:** Regulated but stable pricing. Equifax frequently passes through price increases on mortgage credit reports. * **Revenue recognition notes:** Predominantly transaction-based, recognised upon delivery of the credit report or score. * **Seasonality:** Tracks general consumer lending and mortgage seasonality (stronger in spring and summer). ### International * **Segment name:** International (comprising Asia Pacific, Europe, Latin America, and Canada) * **Revenue driver formula:** Regional Credit Inquiries x Local Currency Price * **Historical growth rate:** 5% to 10% constant currency CAGR * **Key growth levers and headwinds:** Driven by financial inclusion trends in Latin America and Asia, offset by foreign exchange translation headwinds. * **Pricing dynamics:** Competitive pricing against local bureaus and global peers like Experian. * **Revenue recognition notes:** Standard transaction and subscription recognition. * **Seasonality:** Varies by region, but generally stable throughout the year. ## Cost Structure ### Variable Costs / COGS * **Line-by-line breakdown:** Equifax reports "Cost of services", which includes data acquisition costs, royalties, cloud infrastructure hosting (AWS/GCP), and customer support personnel. * **Gross margin range:** 55% to 60% historically (implied by subtracting Cost of Services from Revenue). * **Key input costs and commodity exposures:** Data acquisition fees paid to third-party data furnishers and cloud computing costs. * **How COGS scales with revenue:** High operating leverage. Once a database is built and hosted in the cloud, the marginal cost of delivering an additional credit report or employment verification is near zero. ### Operating Expenses * **R&D:** Equifax does not report R&D as a separate line item; technology development costs are embedded in Cost of Services and SG&A, with a significant portion capitalised as software development costs. * **SG&A:** Typically 26% to 30% of revenue. This includes sales, marketing, and corporate administrative functions. It is largely headcount-driven. * **Depreciation & Amortisation:** Typically 13% to 15% of revenue. This is unusually high due to heavy amortisation of acquired intangible assets (from M&A) and depreciation of capitalised software related to the Equifax Cloud migration. * **Stock-Based Compensation:** Typically 2% to 3% of revenue. * **Restructuring / one-time charges:** Frequent adjustments for acquisition-related integration costs and legacy legal/cybersecurity accruals stemming from the 2017 data breach. ### Margin Profile * **Gross margin:** 55% to 60%. * **EBITDA margin:** Adjusted EBITDA margin ranges from 32% to 36%. * **Operating margin:** GAAP operating margin ranges from 18% to 22%. * **Margin trend:** Expanding. The completion of the cloud migration is expected to reduce legacy IT costs and expand margins by approximately 50 basis points annually. * **Segment-level margins:** Workforce Solutions is the most profitable segment with operating margins exceeding 43%. USIS operates in the low 30% range, and International in the mid 20% range. ## Balance Sheet Structure * **Total assets:** Approximately $11 billion to $12 billion. * **Key asset categories:** Goodwill, Purchased Intangible Assets, and Property and Equipment (which includes capitalised software). * **Goodwill & intangibles as % of total assets:** Extremely high (typically 60% to 70% of total assets) due to a history of serial acquisitions. * **Working capital profile:** * **Days Sales Outstanding (DSO):** 50 to 60 days. * **Days Inventory Outstanding (DIO):** Not applicable (data business). * **Days Payable Outstanding (DPO):** 30 to 40 days. * **Net working capital as % of revenue:** Slightly negative or near zero. * **Is working capital positive or negative?** The company operates with very lean working capital, often funding growth through operations rather than requiring working capital build-outs. * **PP&E:** Dominated by computer equipment and capitalised internal-use software. Useful lives for software are typically 3 to 7 years. * **Right-of-use assets / operating leases:** Material but not dominant, representing office space and legacy data centres. ## Capital Expenditure & Investment * **Capex as % of revenue:** 7% to 10% historically, though expected to normalise downward as the cloud migration concludes. * **Maintenance capex vs. growth capex:** Heavily skewed towards growth capex (capitalised software for new product innovation). * **Major capex programmes underway or planned:** The "Equifax Cloud" transformation is the primary driver, migrating legacy on-premise databases to public cloud infrastructure. * **Capitalised software / development costs:** Highly material. Equifax capitalises a significant portion of its internal engineering labour. * **M&A pattern:** Serial acquirer. Equifax frequently executes bolt-on acquisitions to acquire unique data assets (e.g., Appriss Insights for criminal justice data). * **Typical acquisition multiple paid:** Often 15x to 20x EBITDA for high-growth, proprietary data assets. ## Debt & Capital Structure * **Total debt:** Approximately $5.5 billion to $6.0 billion. * **Debt/EBITDA ratio:** Target leverage is around 2.5x to 3.0x Net Debt to Adjusted EBITDA. * **Credit rating:** Investment grade (BBB/Baa2). * **Key debt instruments:** Senior unsecured notes, a commercial paper programme, and a revolving credit facility. * **Maturity profile:** Well-laddered with maturities spread over the next 10 to 15 years. * **Interest rate profile:** Predominantly fixed-rate senior notes, with floating exposure on commercial paper. * **Covenants:** Standard interest coverage and maximum leverage covenants on the revolving credit facility. * **Share repurchase programme:** Active, though often paused or slowed during periods of heavy M&A to prioritise debt paydown. * **Dividend policy:** Consistent dividend payer, though the yield is typically low (under 1.5%) with a conservative payout ratio. ## Cash Flow Characteristics * **Operating cash flow conversion:** Strong. OCF to Net Income is typically greater than 1.5x due to massive non-cash D&A charges. * **Free cash flow margin:** 10% to 15%, with management targeting acceleration as cloud capex rolls off. * **Major non-cash items:** Depreciation, amortisation of acquired intangibles, and stock-based compensation. * **Working capital cash flow impact:** Minimal impact year-over-year. * **Capex intensity:** Elevated in recent years (up to 10% of revenue) but expected to decline to historical norms (6% to 7%). * **Cash tax rate vs. GAAP effective tax rate:** Cash taxes are often lower than GAAP taxes due to accelerated depreciation and amortisation of goodwill for tax purposes in certain jurisdictions. ## Sheet Structure 1. **Assumptions**: Contains all hardcoded inputs for segment growth, pricing, margins, tax rates, and WACC. 2. **Summary**: A dashboard displaying total revenue, Adjusted EBITDA, Adjusted EPS, and leverage metrics. 3. **Revenue Build**: Projects revenue for Workforce Solutions (Verification Services, Employer Services), USIS (Online Information Solutions, Mortgage Solutions, Financial Marketing Services), and International (Asia Pacific, Europe, Latin America, Canada). 4. **Income Statement**: Projects GAAP financials from Revenue down to Net Income, including Cost of Services, SG&A, and D&A. 5. **Non-GAAP Reconciliation**: Bridges GAAP Net Income to Adjusted EBITDA and Adjusted EPS by adding back acquisition-related amortisation and restructuring charges. 6. **Balance Sheet**: Forecasts Assets (highlighting Goodwill and Capitalised Software) and Liabilities (Debt, Deferred Revenue). 7. **Cash Flow Statement**: Bridges Net Income to OCF, tracks capitalised software additions in CFI, and debt/dividend movements in CFF. 8. **Debt Schedule**: Tracks balances, interest expense, and maturities for the revolver, commercial paper, and senior notes. 9. **Working Capital Schedule**: Forecasts receivables, payables, and deferred revenue based on days outstanding metrics. 10. **PP&E and Intangibles Schedule**: Rolls forward capitalised software, acquired intangibles, and calculates D&A. 11. **DCF**: Calculates Unlevered Free Cash Flow, applies the WACC, and determines the implied share price. ## Key Financial Relationships 1. Total Revenue = Workforce Solutions Revenue + USIS Revenue + International Revenue 2. Workforce Solutions Revenue = Verification Services Revenue + Employer Services Revenue 3. USIS Revenue = Online Information Solutions Revenue + Mortgage Solutions Revenue + Financial Marketing Services Revenue 4. Gross Profit = Total Revenue - Cost of Services 5. GAAP Operating Income = Gross Profit - SG&A - D&A 6. Adjusted EBITDA = GAAP Net Income + Provision for Income Taxes + Interest Expense + D&A + Acquisition-Related Amortisation + Restructuring Charges 7. Capitalised Software Additions = Total Capex x Capitalised Software % (historically 60-70% of total capex) 8. Free Cash Flow = Operating Cash Flow - Total Capital Expenditures (including capitalised software) 9. Net Debt = Total Short-Term Debt + Total Long-Term Debt - Cash and Cash Equivalents 10. Interest Expense = (Beginning Debt Balance + Ending Debt Balance) / 2 x Weighted Average Interest Rate 11. Adjusted EPS = (Adjusted Net Income) / Diluted Weighted Average Shares Outstanding ## Cross-Sheet Dependencies * The **Assumptions** sheet feeds drivers into the **Revenue Build** and **Income Statement**. * The **Revenue Build** feeds the top line of the **Income Statement**. * The **Income Statement** generates Net Income, which is the starting point for the **Cash Flow Statement** and **Non-GAAP Reconciliation**. * The **PP&E and Intangibles Schedule** calculates D&A, which feeds back into the **Income Statement** and is added back on the **Cash Flow Statement**. * The **Cash Flow Statement** determines the ending cash balance and debt paydown capacity, which feed the **Balance Sheet** and **Debt Schedule**. * The **Debt Schedule** calculates interest expense, creating a circular reference with the **Income Statement** (Net Income -> Cash Flow -> Debt Balance -> Interest Expense -> Net Income). A circularity breaker toggle must be included. ## Sign Convention * Revenue and asset balances are entered as positive numbers. * Expenses (Cost of Services, SG&A, D&A, Interest, Taxes) are entered as positive numbers and subtracted in subtotal formulas (e.g., Gross Profit = Revenue - Cost of Services). * On the Cash Flow Statement, cash inflows are positive and cash outflows (including Capex and dividends) are negative. * Liability and Equity balances are positive numbers. ## Things Most Likely to Go Wrong * Failing to isolate the U.S. mortgage market impact. Mortgage revenue spans both Workforce Solutions and USIS; the model must allow the user to flex mortgage origination assumptions independently of general economic growth. * Mishandling capitalised software. Equifax capitalises a massive amount of internal development cost. If this is modelled purely as an operating expense, EBITDA will be severely understated. * Confusing GAAP Operating Income with Adjusted EBITDA. Equifax's valuation is entirely based on Adjusted EBITDA and Adjusted EPS. The model must explicitly build the reconciliation. * Ignoring foreign exchange translation in the International segment. The model should include a constant-currency toggle or explicitly forecast FX headwinds. * Underestimating the amortisation burden. Because of serial acquisitions, acquisition-related amortisation is a huge non-cash drag on GAAP earnings. * Miscalculating the tax rate. The cash tax rate differs materially from the GAAP effective tax rate due to the tax deductibility of certain goodwill amortisation. * Double-counting cloud savings. Management has promised margin expansion from the cloud migration; ensure these savings are modelled in Cost of Services, not just assumed as a generic EBITDA bump. * Overlooking deferred revenue. Employer Services involves subscription contracts that create deferred revenue liabilities; this must be linked to working capital cash flows. ## Validation Checks * Adjusted EBITDA margin should remain in the 32% to 36% range; flag if it drops below 30% or exceeds 40%. * Workforce Solutions operating margin should be greater than 40%. * Total Capex as a percentage of revenue should not exceed 10% in the terminal year (management targets a return to 6-8%). * Debt/Adjusted EBITDA should remain below 3.5x to maintain the investment-grade credit rating. * The Balance Sheet must balance exactly: Total Assets = Total Liabilities + Shareholders' Equity. * Free Cash Flow conversion (FCF / Adjusted Net Income) should be between 70% and 100%. * The effective tax rate should remain between 23% and 26%. * Total revenue growth should align with management's long-term framework of 8% to 12% in a normalised mortgage environment. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | WS Verification Services Growth | 8.0 | % | Blended rate assuming flat mortgage market and strong non-mortgage hiring growth. | | WS Employer Services Growth | 5.0 | % | Steady subscription growth in HR outsourcing. | | USIS Online Info Solutions Growth | 6.0 | % | Stable consumer credit demand and pricing power. | | USIS Mortgage Solutions Growth | 10.0 | % | Assumes a modest rebound from cyclical lows in U.S. mortgage originations. | | International Segment Growth | 7.0 | % | Constant currency growth driven by LatAm and APAC expansion. | | Cost of Services (% of Revenue) | 42.0 | % | Historical average, reflecting cloud hosting and data acquisition costs. | | SG&A (% of Revenue) | 28.0 | % | Historical average, reflecting sales and corporate overhead. | | D&A (% of Revenue) | 14.0 | % | Elevated due to capitalised software and acquisition intangibles. | | Effective Tax Rate | 24.5 | % | Based on recent historical GAAP tax rates. | | Capex (% of Revenue) | 8.0 | % | Reflects the tail end of the Equifax Cloud migration spend. | | Capitalised Software (% of Capex) | 65.0 | % | Historical average of internal-use software development. | | Target Debt / EBITDA | 2.75 | x | Midpoint of management's stated leverage target. | | Weighted Average Interest Rate | 4.5 | % | Based on the current mix of fixed senior notes and floating commercial paper. | | Dividend Payout Ratio | 25.0 | % | Conservative payout policy to prioritise debt reduction and M&A. | | WACC | 8.5 | % | Standard discount rate for an investment-grade data services company. | | Terminal Growth Rate | 3.0 | % | Aligns with long-term GDP growth and pricing power. | ## Data Sources & Benchmarks * **Filings:** SEC EDGAR (Form 10-K, 10-Q, 8-K) and the Equifax Investor Relations website. * **Key Peers:** Experian (EXPN.L), TransUnion (TRU), Fair Isaac Corporation (FICO), Verisk Analytics (VRSK). * **Industry Data:** Mortgage Bankers Association (MBA) origination forecasts, U.S. Bureau of Labor Statistics (BLS) non-farm payroll data. * **Consensus Estimates:** Bloomberg, FactSet, or Refinitiv for forward-looking revenue and EBITDA estimates. * **Proprietary Data:** Credit card issuance data from the Federal Reserve, auto loan origination volumes. ## Sources * Equifax Inc. Form 10-K for the fiscal year ended December 31, 2024 (SEC EDGAR). * Equifax Q4 2024 Earnings Release and Investor Presentation (February 2025). * Equifax Investor Relations Website (investor.equifax.com). --- ## Frequently asked questions ### What does Equifax do and what are its main business segments? Equifax is a global data, analytics, and technology company that provides information solutions and human resources business process outsourcing services. It aggregates demographic, credit, and employment data to help financial institutions, employers, and government agencies make critical risk and verification decisions across its Workforce Solutions, U.S. Information Solutions, and International segments. ### What are the key factors driving Equifax's revenue growth? Equifax's revenue is primarily influenced by U.S. mortgage origination volumes, non-mortgage hiring trends, and the operational leverage gained from its cloud technology transformation. The company's competitive position is also strengthened by proprietary data assets like "The Work Number" database within Workforce Solutions. ### How does Equifax's capital expenditure profile relate to its cloud migration? Equifax's capital expenditure historically ranges from 7% to 10% of revenue, heavily skewed towards growth capex, particularly capitalized software for new product innovation. The "Equifax Cloud" transformation, which involves migrating legacy systems to public cloud infrastructure, is a primary driver of this capex, though it is expected to normalize downward as the migration concludes. ### What are some key assumptions used in the Equifax financial model? The financial model for Equifax includes key assumptions such as a revenue growth rate of approximately 10.7% and a COGS percentage of revenue around 42.5%. Additionally, Selling, General & Administrative expenses are assumed to be about 33.6% of revenue, while the tax rate is set at approximately 20.2%. ### How do acquisitions impact Equifax's balance sheet and valuation? Equifax is a serial acquirer, frequently executing bolt-on acquisitions to acquire unique data assets, often paying 15x to 20x EBITDA for high-growth targets. This strategy results in a balance sheet with extremely high goodwill and purchased intangible assets, typically representing 60% to 70% of total assets. ### What is the purpose of the downloadable Equifax financial model? The downloadable Equifax financial model provides a comprehensive equity valuation and scenario planning tool for the company. It enables an analyst to forecast earnings and cash flows based on Equifax's sensitivity to U.S. mortgage origination volumes, non-mortgage hiring trends, and operational leverage. [Interactive forecast calculator](https://finamodel.com/companies/equifax/forecast)