# Ford Motor (F) Financial Model Free Excel 3-statement financial model and company analysis for Ford Motor. - Canonical: https://finamodel.com/companies/ford-motor - Industry: Automotive - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/F.xlsx ## Model Purpose This model evaluates Ford Motor Company's sum-of-the-parts equity valuation and credit profile, enabling an analyst to assess the cash flow generation of its legacy and commercial businesses against the capital requirements and restructuring costs of its electric vehicle transition. ## Company Overview Ford Motor Company designs, manufactures, markets, and services a full line of connected, increasingly electrified passenger and commercial vehicles. The company operates through distinct customer-centred business segments, alongside a captive finance arm that supports dealer and consumer purchasing. Business segments include: - Ford Blue (approx. 54% of revenue): Internal combustion engine (ICE) and hybrid vehicles. - Ford Pro (approx. 35% of revenue): Commercial vehicles, software, and services. - Ford Model e (approx. 4% of revenue): Fully electric vehicles. - Ford Credit (approx. 7% of revenue): Vehicle financing and leasing. Key geographies include North America (over 65% of revenue), Europe, South America, and the International Markets Group. The business model is an asset-heavy manufacturing operation combined with a captive finance arm and a growing high-margin commercial software subscription business. Ford holds a strong competitive position as a top three automaker in the US and the market leader in commercial vans (Transit) and heavy-duty trucks (Super Duty). In late 2025, Ford announced a major strategic pivot, recording a $19.5 billion special charge to rationalise EV assets, shifting focus to hybrids, commercial vehicles, and a new battery energy storage business called Ford Energy. ## Revenue Deep Dive **Ford Blue** - Segment name: Ford Blue - Revenue driver formula: Wholesale Units x Average Net Transaction Price - Historical growth rate: Flat to low single-digit decline (0% to -2% CAGR) - Key growth levers and headwinds: Strong hybrid demand (up 30%+ YoY) offsetting ICE volume declines as low-margin vehicles are discontinued. - Pricing dynamics: Highly competitive, sensitive to dealer inventory levels and incentive spending. - Revenue recognition notes: Recognised when vehicles are shipped to dealers (wholesales), not when sold to end consumers. - Seasonality: Q2 and Q4 are typically stronger for wholesale shipments. **Ford Pro** - Segment name: Ford Pro - Revenue driver formula: (Commercial Wholesale Units x Average Price) + (Software Subscriptions x ARPU) - Historical growth rate: 10% to 15% CAGR - Key growth levers and headwinds: Super Duty truck demand, Transit van fleet renewals, and high-margin telematics/software subscription growth (over 600,000 paid subscribers). - Pricing dynamics: Contractual fleet pricing and recurring software revenue. - Revenue recognition notes: Vehicle sales upfront; software subscriptions deferred and recognised over the contract term. - Seasonality: Less seasonal than retail, driven by corporate fleet purchasing cycles. **Ford Model e** - Segment name: Ford Model e - Revenue driver formula: EV Wholesale Units x Average Net Transaction Price - Historical growth rate: Highly volatile, recent volume growth offset by severe pricing compression. - Key growth levers and headwinds: Transition to next-generation affordable EV platform, offset by intense price wars and slower-than-expected consumer adoption. - Pricing dynamics: Spot pricing with heavy discounting and reliance on government tax credits. - Revenue recognition notes: Upfront upon shipment to dealers. - Seasonality: Aligned with broader retail auto trends. **Ford Credit** - Segment name: Ford Credit - Revenue driver formula: Average Finance Receivables x Average Yield - Historical growth rate: 3% to 5% CAGR - Key growth levers and headwinds: Interest rate spreads, lease residual values, and consumer credit health. - Pricing dynamics: Regulated consumer lending rates and wholesale dealer floorplan rates. - Revenue recognition notes: Interest income recognised over the life of the loan using the effective interest method. - Seasonality: Tracks retail sales volume. ## Cost Structure ### Variable Costs / COGS - Direct materials (steel, aluminium, batteries), direct labour, freight, and warranty costs sit in COGS. - Gross margin range has historically been 10% to 14% on a consolidated basis. - Key input costs include battery minerals (lithium, nickel) for Model e, and steel and semiconductors for Blue and Pro. - COGS exhibits step-function scaling due to the high fixed costs of assembly plants, resulting in significant operating leverage when running at full capacity utilisation. ### Operating Expenses - R&D typically runs at 4% to 5% of revenue, heavily skewed towards Model e and software development, and is mostly expensed as incurred. - SG&A includes advertising, marketing, and administrative headcount. - Depreciation and amortisation are high, reflecting the asset-heavy manufacturing base and vehicle tooling costs. - Restructuring and one-time charges are highly material. Ford recorded a $19.5 billion charge in late 2025 for EV asset rationalisation. ### Margin Profile - Consolidated gross margin ranges from 10% to 14%. - Consolidated Adjusted EBIT margin ranges from 3.5% to 5.5%. - Segment margins vary wildly: Ford Pro generates 10% to 13% EBIT margins, Ford Blue generates 3% to 6%, and Ford Model e is deeply negative. - The overall margin trend has been pressured by EV losses and warranty costs, though Ford Pro remains highly profitable. ## Balance Sheet Structure - Total assets are approximately $270 billion. - Key asset categories include finance receivables (Ford Credit), inventory, and PP&E. - Goodwill and intangibles are minimal (under 5% of assets) due to an organic growth focus. - Working capital profile: - Days Sales Outstanding (DSO): 15 to 25 days (excluding Ford Credit). - Days Inventory Outstanding (DIO): 45 to 55 days. - Days Payable Outstanding (DPO): 60 to 75 days. - Net working capital is typically negative for the automotive business, providing a source of cash as the company grows. - PP&E consists of assembly plants, tooling, and machinery. Tooling is amortised over the life of the vehicle platform. - Right-of-use assets are material but manageable, primarily representing real estate and equipment leases. ## Capital Expenditure & Investment - Capex as a percentage of revenue ranges from 4.5% to 5.5%. - The split is roughly 40% maintenance and 60% growth. - Major capex programmes include BlueOval City, BlueOval SK battery plants, and the new Ford Energy battery storage business ($1.5 billion initial investment). - Capitalised software is increasing due to Ford Pro Intelligence and autonomous driving investments. - Ford is primarily an organic grower, using M&A for small bolt-on acquisitions in software and mobility tech. ## Debt & Capital Structure - Total consolidated debt is approximately $164 billion. - Automotive debt is approximately $18 billion to $20 billion, while Ford Credit debt is approximately $140 billion to $145 billion (asset-backed). - Automotive leverage is low (under 1.5x Debt/EBITDA), but consolidated leverage is high due to the captive finance arm. - The company holds a BBB (low) / Baa3 credit rating with a stable trend. - Key debt instruments include unsecured corporate bonds, asset-backed securities for Ford Credit, and a revolving credit facility. - The maturity profile is heavy in the near term for Ford Credit (over $50 billion in 2025/2026), requiring constant refinancing. - The interest rate profile is a mix of fixed and floating, heavily dependent on capital market access for Ford Credit. - Share repurchases are minimal, as capital is prioritised for dividends and the EV transition. - The dividend policy includes a regular dividend plus supplemental dividends, targeting 40% to 50% of adjusted free cash flow. ## Cash Flow Characteristics - Operating cash flow conversion is highly volatile due to non-cash special items (such as the $19.5 billion EV charge in 2025). - Adjusted Free Cash Flow margin (Adjusted FCF / Automotive Revenue) is typically 1.5% to 3.5%. - Major non-cash items include depreciation, tooling amortisation, pension remeasurement gains or losses, and asset impairments. - Favourable timing differences between paying suppliers and collecting from dealers can generate billions in working capital cash flow in Q4. - Capex intensity is high, requiring $9.5 billion to $10.5 billion annually. - The cash tax rate often differs from the GAAP effective tax rate due to US Inflation Reduction Act tax credits and deferred tax asset valuation allowances. ## Sheet Structure 1. **Assumptions**: Hardcoded inputs for macroeconomic drivers, segment volumes, pricing, and cost inflation. 2. **Segment Revenue**: Granular build for Ford Blue, Ford Model e, Ford Pro, and Ford Credit based on volume and pricing. 3. **Segment EBIT**: Operating profit build by segment, allocating corporate costs and reconciling to consolidated Adjusted EBIT. 4. **Consolidated Income Statement**: GAAP income statement including special items, interest expense, and taxes. 5. **Ford Credit Balance Sheet**: Standalone balance sheet for the finance arm, tracking receivables and asset-backed debt. 6. **Automotive Balance Sheet**: Standalone balance sheet for the manufacturing business, tracking working capital and PP&E. 7. **Consolidated Balance Sheet**: Aggregation of Automotive and Ford Credit, matching the 10-K presentation. 8. **Cash Flow Statement**: Operating, investing, and financing cash flows, with a clear bridge to Adjusted Free Cash Flow. 9. **Debt Schedule**: Tranche-by-tranche tracking of Automotive debt and aggregate tracking of Ford Credit debt maturities. 10. **Valuation**: Sum-of-the-parts DCF valuing Automotive on cash flow and Ford Credit on a price-to-book or dividend discount model. ## Key Financial Relationships 1. Ford Blue Revenue = Ford Blue Wholesale Units x Ford Blue Average Net Pricing 2. Ford Pro Revenue = (Ford Pro Wholesale Units x Commercial Vehicle Pricing) + (Paid Software Subscriptions x Annual Subscription Fee) 3. Ford Model e Revenue = Ford Model e Wholesale Units x EV Average Net Pricing 4. Ford Credit Revenue = Average Finance Receivables x Average Portfolio Yield 5. Consolidated Automotive Revenue = Ford Blue Revenue + Ford Pro Revenue + Ford Model e Revenue 6. Segment Adjusted EBIT = Segment Revenue x Segment Adjusted EBIT Margin 7. Consolidated Adjusted EBIT = Sum of Segment Adjusted EBIT + Corporate Other EBIT 8. Automotive Gross Margin = (Consolidated Automotive Revenue - Automotive COGS) / Consolidated Automotive Revenue 9. Ford Credit EBT = Ford Credit Revenue - Interest Expense on Ford Credit Debt - Provision for Credit Losses - Operating Expenses 10. Adjusted Free Cash Flow = Automotive Operating Cash Flow - Automotive Capital Expenditures + Ford Credit Distributions 11. Automotive Net Cash = Automotive Cash and Equivalents - Automotive Debt 12. Tooling Amortisation = Beginning Tooling Balance x Blended Amortisation Rate ## Cross-Sheet Dependencies The **Assumptions** sheet feeds **Segment Revenue** and **Segment EBIT**. The **Segment Revenue** sheet feeds the top line of the **Consolidated Income Statement**. The **Segment EBIT** sheet feeds the operating profit lines and bridges to GAAP net income on the **Consolidated Income Statement**. The **Consolidated Income Statement** generates net income, which feeds the top of the **Cash Flow Statement** and retained earnings on the **Consolidated Balance Sheet**. The **Ford Credit Balance Sheet** determines the debt balance, which feeds interest expense for Ford Credit on the **Consolidated Income Statement**. The **Cash Flow Statement** determines the ending cash balance, which feeds the **Automotive Balance Sheet** and **Consolidated Balance Sheet**. Circularity risk exists between Automotive Debt, Interest Expense, and Net Income; a toggle must be included to break the circularity during model calculation. ## Sign Convention Revenue and asset balances are positive. Expenses, capital expenditures, and liability balances are positive. Cash outflows on the cash flow statement are negative. Margins and growth rates are positive or negative based on the mathematical result. The builder must subtract expenses from revenue in the income statement formulas. ## Things Most Likely to Go Wrong 1. Consolidating Ford Credit with the Automotive business distorts leverage and margin metrics; the model must evaluate Automotive cash flows separately from Ford Credit. 2. The $19.5 billion special charge in 2025 includes $5.5 billion in cash effects to be paid in 2026 and 2027; the model must capture these cash outflows separately from operating expenses. 3. Pension and OPEB remeasurement gains or losses are recorded annually in Q4 and can swing GAAP net income by billions; these should be excluded from Adjusted EBIT. 4. Warranty costs have historically plagued Ford Blue; failing to model warranty reserves accurately will overstate near-term profitability. 5. Ford Model e operates at a massive loss; applying a generic consolidated margin assumption will fail to capture the drag of the EV business. 6. Transactions between segments (e.g. Ford Pro buying vehicles from Ford Blue) must be eliminated in consolidation to prevent double-counting revenue. 7. Ford Credit requires constant debt refinancing; the model must assume new debt issuance to replace the $50+ billion maturing in the near term. 8. Adjusted Free Cash Flow excludes Ford Credit operating cash flows but includes distributions from Ford Credit to the parent company. ## Validation Checks 1. Consolidated Adjusted EBIT should reconcile to the sum of the segments and fall within the $8.0 billion to $10.0 billion guidance range for 2026. 2. Adjusted Free Cash Flow should be between $5.0 billion and $6.0 billion for 2026. 3. Ford Pro EBIT margin should remain in the double digits (10% to 14%). 4. Ford Model e EBIT should show a loss of $4.0 billion to $4.5 billion in 2026. 5. Total Capital Expenditures should be between $9.5 billion and $10.5 billion. 6. The Consolidated Balance Sheet must balance: Total Assets = Total Liabilities + Equity in every period. 7. Automotive Debt to Adjusted EBITDA should remain below 2.0x. 8. Ford Credit EBT should be approximately $2.5 billion in 2026. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Ford Blue Wholesale Volume Growth | -2.0 | % | Reflects discontinuation of low-margin ICE vehicles | | Ford Pro Wholesale Volume Growth | 5.0 | % | Continued strong demand for Super Duty and Transit | | Ford Model e Wholesale Volume Growth | 10.0 | % | Growth from new platforms, offset by market saturation | | Ford Blue Adjusted EBIT Margin | 4.2 | % | Based on 2025 actuals and 2026 guidance | | Ford Pro Adjusted EBIT Margin | 11.5 | % | Sustained double-digit profitability per management | | Ford Model e Adjusted EBIT | -4,250 | $ Millions | Midpoint of 2026 guidance loss | | Ford Credit EBT | 2,500 | $ Millions | 2026 management guidance | | Automotive Capital Expenditures | 10,000 | $ Millions | Midpoint of 2026 guidance ($9.5B to $10.5B) | | Effective Tax Rate | 18.0 | % | Historical average adjusted for EV tax credits | | Dividend per Share (Regular) | 0.60 | $ | Annualised based on $0.15 quarterly dividend | | WACC (Automotive) | 9.5 | % | Reflects cyclicality and EV transition risk | | Terminal Growth Rate | 1.5 | % | Long-term mature industry growth | ## Data Sources & Benchmarks - SEC EDGAR: Ford Motor Company 10-K and 10-Q filings. - Investor Relations: Ford shareholder website for earnings presentations and Ford+ strategic updates. - Peers for Benchmarking: General Motors (GM), Stellantis (STLA), Tesla (TSLA), Toyota (TM). - Industry Data: WardsAuto for production volumes, Cox Automotive for pricing and inventory data, J.D. Power for quality metrics. ## Sources - Ford Motor Company Q4 2025 Earnings Release and Presentation (February 2026). - Ford Motor Company 2024 and 2025 10-K Filings. - Morningstar DBRS Credit Rating Report on Ford Motor Company (May 2025). - Ford Strategic Update Press Release (EV rationalisation and battery storage pivot). --- ## Frequently asked questions ### What does Ford Motor Company do? Ford Motor Company designs, manufactures, markets, and services a full line of connected, increasingly electrified passenger and commercial vehicles. It operates through distinct customer-centered business segments, alongside a captive finance arm that supports dealer and consumer purchasing. ### What are the primary revenue drivers for Ford Motor Company's main business segments? Ford Blue's revenue is driven by wholesale units and average net transaction price, while Ford Pro's revenue comes from commercial wholesale units, average price, and growing software subscriptions. Ford Credit generates revenue through vehicle financing and leasing activities. ### What is the assumed revenue growth rate for Ford Motor Company in its financial model? The financial model for Ford Motor Company assumes a revenue growth rate of approximately 3.11%. This assumption helps project the company's future top-line performance over the forecast horizon. ### What is the purpose of the financial model for Ford Motor Company? The model evaluates Ford Motor Company's sum-of-the-parts equity valuation and credit profile. It enables an analyst to assess the cash flow generation of its legacy and commercial businesses against the capital requirements and restructuring costs of its electric vehicle transition. ### Is there a downloadable Excel financial model available for Ford Motor Company? Yes, an Excel financial model for Ford Motor Company is available for download. This model provides a detailed forecast horizon from FY2026 to FY2030 for analysis. ### What is Ford Motor Company's capital expenditure strategy? Ford's capital expenditure as a percentage of revenue ranges from 4.5% to 5.5%, with approximately 60% allocated to growth initiatives. Major programs include BlueOval City, BlueOval SK battery plants, and the new Ford Energy battery storage business. [Interactive forecast calculator](https://finamodel.com/companies/ford-motor/forecast)