# Lennar (LEN) Financial Model Free Excel 3-statement financial model and company analysis for Lennar. - Canonical: https://finamodel.com/companies/lennar - Industry: Construction - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/LEN.xlsx ## Model Purpose This model evaluates Lennar's equity valuation and cash flow generation capacity by forecasting home deliveries, average sales prices, and land acquisition costs under varying macroeconomic and interest rate scenarios to determine the intrinsic value of the stock for an equity investor. ## Company Overview Lennar Corporation is one of the largest homebuilders in the United States, constructing affordable, move-up, and active adult homes across 30 states. The business operates through four primary segments: Homebuilding (approximately 95% of revenue, split geographically into East, Central, Texas, and West), Financial Services (approximately 3% of revenue, providing mortgage financing and title services), Multifamily (approximately 1% of revenue, developing rental properties), and Lennar Other (approximately 1% of revenue, housing technology investments via LENX). Lennar employs an asset-light business model, utilising land options and third-party land banks to control homesites without holding heavy land inventory on its balance sheet. The company holds a top-two market share position in the US homebuilding industry alongside D.R. Horton, benefiting from massive scale and geographic diversification. In early 2025, Lennar executed a major strategic move by spinning off Millrose Properties, a transaction that removed over $1.1 billion in land inventory from its balance sheet to further accelerate its transition to a pure-play, asset-light manufacturer of homes. ## Revenue Deep Dive - **Homebuilding (East, Central, Texas, West)** - Driver formula: "Deliveries (Homes) x Average Sales Price (ASP)" - Historical growth rate: Deliveries have grown at a 3-5% CAGR, reaching over 82,500 homes in FY2025, though revenue growth has been offset by recent ASP declines. - Key growth levers and headwinds: Community count expansion and absorption pace per community drive volume, while high mortgage rates and affordability constraints act as headwinds. - Pricing dynamics: Highly competitive and spot-market driven. Lennar frequently uses sales incentives, such as buying down the customer's mortgage rate, which effectively lowers the net ASP (dropping to $386,000 in Q4 2025 from $430,000 in Q4 2024). - Revenue recognition notes: Recognised at a point in time when the home closing occurs and title passes to the buyer. - Seasonality: The third and fourth fiscal quarters (ending August and November) are typically the strongest for deliveries and revenue generation. - **Financial Services** - Driver formula: "Origination Volume x Profit per Loan" - Historical growth rate: Highly cyclical, fluctuating between -10% and +15% annually based on the broader mortgage market and Lennar's delivery volume. - Key growth levers and headwinds: Capture rate (the percentage of Lennar homebuyers using Lennar Mortgage) is the primary lever, while rising interest rates compress origination volumes and margins. - Pricing dynamics: Regulated and tied to secondary mortgage market spreads. - Revenue recognition notes: Recognised when the loan is sold into the secondary market or when title services are completed. - Seasonality: Mirrors the Homebuilding segment's seasonality. ## Cost Structure ### Variable Costs / COGS - COGS for the Homebuilding segment includes land acquisition costs, direct construction materials (lumber, concrete), direct labour, and capitalised interest. - Gross margin range: 17.0% to 23.0% over the last 5 years (compressing to 17.0% in late 2025 due to heavy use of mortgage buy-down incentives and higher land costs). - Key input costs and commodity exposures: Lumber, concrete, copper, and skilled trades labour. - COGS scales linearly with deliveries, though land costs reflect historical purchase prices, creating a timing mismatch when current home prices fall but land was purchased during peak markets. ### Operating Expenses - R&D: Not material for homebuilders. - SG&A: Typically 6.5% to 7.5% of home sales revenue. This includes broker commissions, advertising, and corporate overhead. It is highly efficient and headcount-driven. - Depreciation & Amortisation: Less than 1% of revenue, as the business is not PP&E intensive. - Stock-Based Compensation: Approximately 0.5% of revenue. - Restructuring / one-time charges: Infrequent, though the company recently recorded a $156 million one-time loss related to the Millrose exchange offer in Q4 2025. ### Margin Profile - Gross margin: 17.0% to 23.0%. - EBITDA margin: 13.0% to 19.0%. - Operating margin: 12.0% to 18.0%. - Net margin: 8.0% to 13.0%. - Margin trend: Compressing significantly in 2024 and 2025 as the company prioritised volume over price, using margin-dilutive incentives to maintain sales pace in a high-interest-rate environment. ## Balance Sheet Structure - Total assets: Approximately $34 billion. - Key asset categories: Homebuilding inventory (finished homes, construction in progress, land and land under development) is the largest asset. Consolidated inventory not owned (Variable Interest Entities) is also material due to the land-light strategy. - Goodwill & intangibles: Minimal as a percentage of total assets. - Working capital profile: - Days Sales Outstanding (DSO): Minimal (under 10 days) as homes are paid for in cash or via mortgage at closing. - Days Inventory Outstanding (DIO): High (typically 150 to 200 days), representing the time to acquire land, develop it, and build the home. - Days Payable Outstanding (DPO): 30 to 45 days. - Net working capital as % of revenue: High, driven entirely by inventory. - Working capital is positive. The company consumes cash to grow inventory during expansion phases and generates cash when liquidating inventory during downturns. - PP&E: Minimal, consisting mostly of corporate offices and design studios. - Right-of-use assets / operating leases: Not a material driver of the balance sheet. ## Capital Expenditure & Investment - Capex as % of revenue: Less than 1.0% (historically $100 million to $150 million annually). - Maintenance capex vs. growth capex: Almost entirely maintenance for corporate IT and office facilities. - Major capex programmes: None. The true "investment" for a homebuilder is land acquisition, which flows through inventory and operating cash flow, not capex. - Capitalised software / development costs: Minimal. - M&A pattern: Historically transformational (acquired CalAtlantic in 2018), but recently focused on organic growth and strategic land spin-offs (Millrose in 2025). ## Debt & Capital Structure - Total debt: Approximately $2.8 billion in Homebuilding debt. - Net debt: Often negative, as cash balances (approximately $3.4 billion in late 2025) frequently exceed total Homebuilding debt. - Debt/Capital ratio: Net homebuilding debt to total capital fluctuates between -10% and +10%. - Credit rating: Investment grade (Baa2 / BBB). - Key debt instruments: Unsecured senior notes and a revolving credit facility. - Maturity profile: Well-laddered with average maturities exceeding 5 years. - Interest rate profile: Primarily fixed-rate senior notes with a weighted average cost of approximately 4.5% to 5.5%. - Covenants: Standard maximum leverage and minimum tangible net worth covenants, which the company clears with massive headroom. - Share repurchase programme: Highly active, frequently repurchasing $1.0 billion to $2.0 billion annually. - Dividend policy: Modest yield (under 2%), with a focus on share repurchases for capital return. ## Cash Flow Characteristics - Operating cash flow conversion: Highly variable. OCF can be lower than net income during rapid growth phases (due to land purchases) and significantly higher than net income during slowdowns (as inventory converts to cash). - Free cash flow margin: 5.0% to 10.0%, heavily dependent on the rate of inventory accumulation. - Major non-cash items: Mark-to-market gains/losses on technology investments (LENX), equity in earnings of unconsolidated entities, and stock-based compensation. - Working capital cash flow impact: Inventory is the primary use of cash for growth. - Capex intensity: Extremely low. - Cash tax rate vs. GAAP effective tax rate: Closely aligned, typically around 24% to 27%, benefiting slightly from energy-efficient home tax credits. ## Sheet Structure 1. **Assumptions**: Macroeconomic drivers, segment delivery growth, ASP trends, margin targets, tax rate, and share repurchase volumes. 2. **Homebuilding_Revenue**: Backlog roll-forward (Beginning Backlog + New Orders - Deliveries = Ending Backlog) and revenue calculation (Deliveries x ASP) broken out by East, Central, Texas, and West segments. 3. **Financial_Services**: Origination volume, capture rate, and operating profit for the mortgage and title business. 4. **Consolidated_Income_Statement**: Aggregation of Homebuilding, Financial Services, Multifamily, and Lennar Other revenues and operating profits, down to consolidated Net Income. 5. **Working_Capital**: Detailed inventory roll-forward (Land, Construction in Progress, Finished Homes), consolidated VIE inventory, and accounts payable. 6. **Debt_Schedule**: Senior notes, revolving credit facility balances, interest expense, and the critical capitalised interest calculation. 7. **Balance_Sheet**: Assets, Liabilities, and Stockholders' Equity, mirroring the 10-K presentation. 8. **Cash_Flow_Statement**: Net income reconciliation to CFO (highlighting inventory changes), CFI, and CFF. 9. **Valuation**: DCF model, WACC calculation, and historical EV/EBITDA and P/B multiple tracking. ## Key Financial Relationships 1. "Ending Backlog (Homes) = Beginning Backlog + New Orders - Deliveries" 2. "Segment Homebuilding Revenue = Segment Deliveries x Segment Average Sales Price" 3. "Homebuilding COGS = Homebuilding Revenue x (1 - Homebuilding Gross Margin %)" 4. "Financial Services Revenue = Deliveries x Capture Rate % x Average Loan Size x Origination Fee %" 5. "Land & Construction Inventory Purchases = Homebuilding COGS + Ending Inventory - Beginning Inventory" 6. "Capitalised Interest = Average Construction Inventory x Capitalisation Rate" 7. "SG&A Expense = Homebuilding Revenue x SG&A Margin (historically 6.5% to 7.5%)" 8. "Net Homebuilding Debt = Total Homebuilding Debt - Homebuilding Cash and Cash Equivalents" 9. "Homebuilding Debt to Capital = Total Homebuilding Debt / (Total Homebuilding Debt + Stockholders' Equity)" 10. "Interest Expense Recognised = (Average Debt Outstanding x Interest Rate) - Capitalised Interest + Previously Capitalised Interest Released to COGS" ## Cross-Sheet Dependencies - The **Homebuilding_Revenue** sheet is the primary engine; it feeds the top line of the **Consolidated_Income_Statement** and drives inventory depletion in the **Working_Capital** sheet. - The **Working_Capital** sheet calculates inventory additions, which directly feeds the Operating Cash Flow section of the **Cash_Flow_Statement**. - The **Debt_Schedule** feeds interest expense to the **Consolidated_Income_Statement** and capitalised interest additions to the **Working_Capital** sheet. - The **Cash_Flow_Statement** outputs the ending cash balance, which feeds the **Balance_Sheet** to ensure the model balances. - A circularity risk exists between the **Debt_Schedule** (revolver borrowing), **Cash_Flow_Statement** (cash shortfall), and **Consolidated_Income_Statement** (interest expense). A circuit breaker toggle must be included. ## Sign Convention - Revenues, asset balances, and equity balances are entered and displayed as positive numbers. - Expenses (COGS, SG&A, Interest) and liability balances are entered as positive numbers in their respective schedules but subtracted in aggregation formulas. - The Cash Flow Statement follows standard convention: cash inflows are positive, and cash outflows (such as increases in inventory or decreases in accounts payable) are negative. ## Things Most Likely to Go Wrong - Misunderstanding capitalised interest: Homebuilders capitalise interest into inventory and expense it through COGS when the home is delivered. Failing to model this timing difference will distort gross margins and interest expense. - Ignoring the backlog roll-forward: Revenue must tie mathematically to deliveries, which must tie to the backlog equation. Disconnecting these will break the model's logic. - Misinterpreting Variable Interest Entities (VIEs): Lennar consolidates certain land banking VIEs. This inflates assets and liabilities but has no recourse to the company. The model must separate owned inventory from VIE inventory. - Treating land purchases as Capex: Land acquisition is an operating cash flow item (inventory), not an investing cash flow item. Putting land spend in CFI will ruin the Free Cash Flow calculation. - Overestimating gross margins: Margins have compressed to approximately 17% due to mortgage buy-downs. Using peak 2022 margins (23%) will drastically overstate profitability. - Forgetting the Millrose spin-off: Historical land inventory figures will look artificially high compared to 2025 onwards due to the $1.1 billion reduction from the Millrose exchange. The model requires a pro-forma adjustment for the base year. - Lennar Other mark-to-market volatility: Tech investments (LENX) cause lumpy, non-core EPS swings (e.g., $123 million gain in Q4 2025). These must be excluded when forecasting core operating earnings. - Financial Services sensitivity: This segment's profit is highly sensitive to mortgage rates. Flat-lining this growth without linking it to delivery volume and rate assumptions will yield inaccurate results. ## Validation Checks - Homebuilding Gross Margin should remain between 15.0% and 20.0%; flag if outside this band. - SG&A as a percentage of Home Sales should remain between 6.5% and 8.0%. - Net Homebuilding Debt to Total Capital should remain below 15.0% (currently around 7.0%). - Ending Backlog (Homes) must be greater than or equal to zero in all periods. - The Balance Sheet must balance exactly: Total Assets = Total Liabilities + Equity in every period. - Capex as a percentage of revenue should not exceed 1.0%. - The effective tax rate should remain between 24.0% and 27.0%. - Operating Cash Flow must turn negative if inventory growth exceeds net income by a significant margin. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Deliveries Growth | 3.0 | % | Modest volume growth reflecting market share gains despite macro headwinds | | Average Sales Price (ASP) | 386,000 | $ | Based on Q4 2025 actuals, reflecting increased use of sales incentives | | Homebuilding Gross Margin | 17.0 | % | Based on Q4 2025 actuals, compressed due to mortgage buy-downs and land costs | | SG&A % of Home Sales | 7.0 | % | Historical average, reflecting strong operating leverage and scale | | Financial Services Op. Margin | 35.0 | % | Historical average for the mortgage and title segment | | Effective Tax Rate | 25.0 | % | Blended statutory and state rate, adjusted for energy credits | | Share Repurchases | 1,000 | $M | Annual run-rate based on recent capital return programmes | | Dividend per Share | 2.00 | $ | Annualised based on recent quarterly declarations | | Cost of Debt | 5.0 | % | Weighted average interest rate on outstanding senior notes | | WACC | 9.5 | % | Standard cost of capital for a cyclical, large-cap homebuilder | | Terminal Growth Rate | 2.0 | % | Long-term GDP growth proxy for terminal value calculation | ## Data Sources & Benchmarks - SEC EDGAR for Lennar's 10-K and 10-Q filings. - Lennar Investor Relations website (investors.lennar.com) for quarterly earnings presentations and supplemental financial data. - Key peers for benchmarking: D.R. Horton (DHI), PulteGroup (PHM), Toll Brothers (TOL), and NVR Inc. (NVR). - Industry data sources: US Census Bureau (New Residential Sales data) and Freddie Mac (Primary Mortgage Market Survey). - Consensus estimates source: Bloomberg or FactSet for validation of near-term delivery and ASP expectations. ## Sources - Lennar Corporation Form 10-K for the fiscal years ended November 30, 2024, and 2025. - Lennar Corporation Q4 2025 Earnings Release and Supplemental Financial Information. - Lennar Corporation Q2 2025 Earnings Release. - Lennar Investor Relations Corporate Profile and Financial Summaries. --- ## Frequently asked questions ### What is Lennar Corporation's primary business model? Lennar Corporation is one of the largest homebuilders in the United States, constructing affordable, move-up, and active adult homes across 30 states. The company employs an asset-light business model, utilizing land options and third-party land banks to control homesites without holding heavy land inventory on its balance sheet. This strategy allows them to focus on manufacturing homes while minimizing land-related capital intensity. ### How does Lennar generate its revenue? Lennar primarily generates revenue through its Homebuilding segment, which accounts for approximately 95% of total revenue, driven by home deliveries and average sales prices. Additional revenue comes from Financial Services, providing mortgage financing and title services, and Multifamily, developing rental properties. Revenue is recognized at the point in time when the home closing occurs and title passes to the buyer. ### What is Lennar's capital expenditure strategy? Lennar maintains a minimal capital expenditure strategy, with capex typically less than 1.0% of revenue, primarily for maintenance of corporate IT and office facilities. The true "investment" for a homebuilder like Lennar is land acquisition, which flows through inventory and operating cash flow rather than capital expenditures. This approach supports their asset-light operating model. ### What is a typical gross margin assumption for Lennar in financial models? In financial models for Lennar, a common assumption for Cost of Goods Sold (COGS) is approximately 55% of revenue. This implies a gross margin of around 45% for the company. Understanding this key percentage is crucial for projecting Lennar's profitability and cash flow generation. ### What are the main inputs for valuing Lennar stock using a DCF model? Key inputs for valuing Lennar stock using a Discounted Cash Flow (DCF) model include forecasts for home deliveries, average sales prices, and land acquisition costs. These drivers help determine the company's future cash flow generation capacity. The model also considers varying macroeconomic and interest rate scenarios to assess the intrinsic value of the stock for an equity investor. ### Can I download an Excel financial model for Lennar? Yes, an Excel financial model for Lennar is available for download. This model evaluates Lennar's equity valuation and cash flow generation capacity by forecasting key operational metrics from FY2026 to FY2030. It incorporates top assumptions like revenue growth and cost percentages to project future financial results. [Interactive forecast calculator](https://finamodel.com/companies/lennar/forecast)