Masco Financial Model
Building Products Company Financials Example (Free Excel Download)
Masco Corporation is a global leader in the design, manufacture, and distribution of branded home improvement and building products.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and scenario planning tool for Masco Corporation, allowing an analyst to forecast earnings and cash flows based on the cyclicality of the residential repair and remodel market, raw material cost fluctuations, and the company's aggressive capital return programme.
Masco Corporation is a global leader in the design, manufacture, and distribution of branded home improvement and building products. The company operates primarily through two segments: Plumbing Products (approximately 65% of revenue) and Decorative Architectural Products (approximately 35% of revenue). North America accounts for roughly 80% of total sales, with the remainder generated internationally, largely driven by the European presence of its Hansgrohe brand.
Masco operates an asset-light manufacturing and distribution business model that is heavily indexed to the residential Repair and Remodel (R&R) market, which represents about 80% of its total sales. The company holds a dominant competitive position in its key categories, boasting market-leading brands such as Delta and Hansgrohe in plumbing, and Behr in architectural coatings, the latter benefiting from an exclusive distribution relationship with The Home Depot. Recently, Masco appointed Jon Nudi as CEO in July 2025 and announced a restructuring programme in late 2025 to streamline operations, which includes integrating Liberty Hardware into the Delta Faucet Company.
The downloadable Masco financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsMasco financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $8.38B | $8.68B | $7.97B | $7.83B | $7.56B |
| Gross profit | $2.86B | $2.71B | $2.84B | $2.83B | $2.68B |
| Operating income | $1.41B | $1.30B | $1.35B | $1.36B | $1.25B |
| Net income | $410.0M | $844.0M | $908.0M | $822.0M | $810.0M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Masco
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Plumbing Products
- Segment name: Plumbing Products
- Revenue driver formula: Volume x Average Selling Price (ASP)
- Historical growth rate: Low single digits (grew 3% in FY2025)
- Key growth levers and headwinds: Driven by bathroom and kitchen remodel activity, international expansion of the Hansgrohe brand, and pricing actions to offset brass and zinc inflation. Headwinds include foreign exchange volatility and global macroeconomic softness.
- Pricing dynamics: Highly competitive but supported by strong brand equity, allowing for periodic price increases to offset commodity inflation.
- Revenue recognition notes: Recognised upon shipment or delivery to customers.
- Seasonality: Modestly stronger in the second and third quarters aligning with peak construction and remodelling seasons.
Decorative Architectural Products
- Segment name: Decorative Architectural Products
- Revenue driver formula: Volume (Gallons of paint / units of hardware) x Average Selling Price (ASP)
- Historical growth rate: Highly volatile recently (declined 14% in FY2025)
- Key growth levers and headwinds: Heavily dependent on DIY consumer behaviour and foot traffic at The Home Depot. A major headwind has been the normalisation of DIY activity post-pandemic, leading to significant volume declines.
- Pricing dynamics: Pricing is closely tied to the cost of raw materials like titanium dioxide and resins.
- Revenue recognition notes: Recognised upon shipment to retail partners.
- Seasonality: Highly seasonal; the second and third quarters are significantly stronger due to warmer weather facilitating exterior painting projects.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Raw materials (copper, zinc, brass, titanium dioxide, resins), inbound freight, direct manufacturing labour, and overhead.
- Gross margin range: 34.0% to 36.5% (36.2% in 2024, 35.4% in 2025).
- Key input costs and commodity exposures: Highly exposed to metals (copper, zinc) for plumbing and chemicals (titanium dioxide, petroleum-based resins) for paint.
- How COGS scales with revenue: Largely linear with volume, though pricing lags commodity cost spikes, creating temporary margin compression during inflationary periods.
Operating Expenses
- R&D: Not explicitly broken out as a major percentage; typically embedded in SG&A, focusing on water efficiency and paint formulation.
- SG&A: Includes significant marketing and advertising spend to support consumer brands (Behr, Delta), outbound freight, and general administrative headcount.
- Depreciation & Amortisation: Typically runs at 2.0% to 2.5% of revenue.
- Stock-Based Compensation: Relatively small, typically under 1% of revenue.
- Restructuring / one-time charges: Frequent but usually small, though the company incurred an $18 million charge in Q4 2025 and expects an additional $50 million in 2026 for headcount reduction and facility rationalisation.
Margin Profile
- Gross margin: 34.0% to 36.5%.
- Operating margin: 15.0% to 17.5% (adjusted operating margin was 17.5% in 2024 and 16.8% in 2025).
- Net margin: 9.0% to 11.0%.
- Margin trend: Slightly compressing recently due to volume deleverage in the Decorative Architectural segment, though offset by aggressive cost-saving initiatives.
Balance Sheet Structure
- Total assets: Approximately $4.5 billion to $5.0 billion.
- Key asset categories: Inventory, Accounts Receivable, Property, Plant and Equipment (PP&E), and Goodwill.
- Goodwill & intangibles: Represents a significant portion of total assets (over 20%) due to historical acquisitions, though the company has focused more on organic growth recently.
- Working capital profile:
- Days Sales Outstanding (DSO): 45 to 55 days.
- Days Inventory Outstanding (DIO): 70 to 85 days (requires high inventory to meet major retailer fill-rate demands).
- Days Payable Outstanding (DPO): 50 to 65 days.
- Net working capital as % of revenue: Typically 10% to 15%.
- Working capital dynamic: Positive working capital. The company must build inventory in the first quarter to prepare for the spring selling season, making Q1 a heavy use of cash.
- PP&E: Consists of manufacturing facilities and distribution centres. Useful lives are typically 15 to 40 years for buildings and 3 to 10 years for machinery.
- Right-of-use assets: Material but manageable, primarily related to leased distribution and warehouse spaces.
Capital Expenditure & Investment
- Capex as % of revenue: 2.0% to 3.0% (highly asset-light).
- Maintenance capex vs. growth capex: Approximately 70% maintenance and 30% growth/efficiency (automation upgrades).
- Major capex programmes: Investments in manufacturing automation and distribution network optimisation.
- Capitalised software: Minimal impact on overall capex.
- M&A pattern: Historically a serial acquirer, but recent years have focused on portfolio optimisation (divesting cabinetry and windows) and small bolt-on acquisitions.
Debt & Capital Structure
- Total debt: Approximately $2.9 billion in long-term debt.
- Debt/EBITDA ratio: Target is below 2.5x gross debt to EBITDA.
- Credit rating: Investment grade.
- Key debt instruments: Unsecured senior notes and a revolving credit facility.
- Maturity profile: Well-laddered with average maturities exceeding 5 years.
- Interest rate profile: Predominantly fixed-rate bonds.
- Covenants: Standard interest coverage and leverage ratio covenants on the revolving credit facility.
- Share repurchase programme: Highly active. The company returned $832 million to shareholders in 2025 through a combination of dividends and share repurchases.
- Dividend policy: Target payout ratio of approximately 30%. The 2026 annualised dividend is set at $1.28 per share.
Cash Flow Characteristics
- Operating cash flow conversion: Consistently strong, typically >1.0x Net Income.
- Free cash flow margin: 10.0% to 12.0% of revenue.
- Major non-cash items: Depreciation, amortisation, and deferred income taxes.
- Working capital cash flow impact: Significant seasonal use of cash in Q1 for inventory builds, which reverses in Q3 and Q4.
- Capex intensity: Low, supporting high free cash flow generation.
- Cash tax rate: Generally tracks closely with the GAAP effective tax rate of approximately 24.5%.
Sheet Structure
- Assumptions: Hardcoded inputs for macroeconomic drivers, segment growth rates, margin targets, tax rate, and WACC.
- Revenue_Build: Detailed build of Plumbing Products and Decorative Architectural Products, split by volume and price/mix assumptions.
- Income_Statement: Consolidated P&L from Net Sales down to Net Income, EPS, and Adjusted EPS, explicitly breaking out restructuring charges.
- Balance_Sheet: Standard asset, liability, and equity line items mirroring the 10-K.
- Cash_Flow: Indirect method starting with Net Income, adjusting for D&A, working capital changes, capex, debt issuance/repayment, and shareholder returns.
- Debt_Schedule: Tranche-by-tranche breakdown of senior notes, revolver drawdowns, and interest expense calculation.
- Working_Capital: Schedules for Accounts Receivable, Inventory, and Accounts Payable driven by DSO, DIO, and DPO.
- Depreciation_Schedule: Waterfall or roll-forward of PP&E, calculating D&A expense based on capex and historical asset bases.
- DCF: Unlevered free cash flow calculation, discount rate application, and terminal value derivation.
Key Financial Relationships
- `Plumbing Products Revenue = Prior Year Plumbing Revenue * (1 + Plumbing Volume Growth + Plumbing Price/Mix)`
- `Decorative Architectural Revenue = Prior Year Dec Arch Revenue * (1 + Dec Arch Volume Growth + Dec Arch Price/Mix)`
- `Total Net Sales = Plumbing Products Revenue + Decorative Architectural Revenue`
- `Cost of Sales = Total Net Sales * (1 - Gross Margin %)`
- `Gross Profit = Total Net Sales - Cost of Sales`
- `SG&A Expense = Total Net Sales * SG&A Margin %`
- `Operating Profit = Gross Profit - SG&A Expense - Restructuring Charges`
- `Interest Expense = Average Total Debt * Weighted Average Interest Rate`
- `Share Count = Prior Year Share Count - (Share Repurchases / Average Share Price)`
- `Dividends Paid = Share Count * Dividend Per Share`
- `Adjusted EPS = (Net Income + Restructuring Charges * (1 - Tax Rate)) / Share Count`
Cross-Sheet Dependencies
- The Assumptions sheet dictates the growth and margin profiles in the Revenue_Build and Income_Statement.
- The Revenue_Build feeds the top line of the Income_Statement.
- Income_Statement Net Income flows to the top of the Cash_Flow statement and into Retained Earnings on the Balance_Sheet.
- The Working_Capital sheet calculates changes in NWC, which feeds the operating section of the Cash_Flow statement and the current assets/liabilities on the Balance_Sheet.
- The Debt_Schedule calculates interest expense for the Income_Statement and ending debt balances for the Balance_Sheet. A circularity switch must be included here as interest expense impacts net income, which impacts cash available for debt paydown, which in turn impacts interest expense.
- The Cash_Flow statement calculates the net change in cash, which links to the Cash line on the Balance_Sheet.
Sign Convention
- Revenue, Assets, and Equity are represented as positive numbers.
- Expenses (Cost of Sales, SG&A, Interest) are inputted as positive numbers in their respective schedules but subtracted in the Income Statement formulas.
- On the Cash Flow statement, cash inflows are positive. Cash outflows (Capital Expenditures, Share Repurchases, Dividends Paid, Debt Repayment) are negative.
Things Most Likely to Go Wrong
- Customer Concentration: Failing to model the impact of The Home Depot, which accounts for a massive percentage of Masco's sales, particularly for Behr paint.
- Restructuring Charges: Ignoring the specific $50 million restructuring charge guided for 2026, which will artificially inflate GAAP operating profit if missed.
- Segment Divergence: Assuming consolidated growth rates rather than modelling the severe recent divergence (Plumbing growing while Decorative Architectural declined 14% in 2025).
- Working Capital Seasonality: Overlooking the Q1 inventory build, which can cause modelled liquidity shortfalls if looking at quarterly cash flows.
- Share Count Dynamics: Underestimating the EPS accretion from Masco's aggressive share repurchase programme.
- Currency Impacts: Forgetting that the Plumbing segment has heavy European exposure (Hansgrohe), making it sensitive to EUR/USD fluctuations.
- Dividend Target: Misaligning the dividend per share with management's stated target payout ratio of approximately 30%.
- Margin Rigidity: Assuming gross margins expand linearly with price increases, ignoring the lag effect of commodity cost inflation.
Validation Checks
- Gross margin should remain within the 34.0% to 36.5% band based on historical performance.
- Adjusted operating margin should be in the 16.0% to 17.5% range.
- Debt to EBITDA must not exceed the management target of 2.5x.
- Free Cash Flow conversion (FCF / Net Income) should be approximately 100%.
- The calculated dividend payout ratio should hover around 30%.
- Total Assets must equal Total Liabilities plus Shareholders' Equity in every forecast period.
- Capital expenditures should not exceed 3.0% of Total Net Sales.
- The effective tax rate should remain near the normalised guidance of 24.5%.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Plumbing Products Growth | 2.0 | % | Reflects management guidance of flat to low-single-digit growth for 2026. |
| Decorative Arch Growth | -1.0 | % | Assumes stabilisation after a severe 14% decline in 2025. |
| Gross Margin | 35.5 | % | In line with 2025 actuals (35.4%) and recent historical averages. |
| SG&A Margin | 18.5 | % | Based on historical run rates to support consumer brand marketing. |
| Restructuring Charge (2026) | 50.0 | $M | Explicit management guidance provided in the Q4 2025 earnings release. |
| Effective Tax Rate | 24.5 | % | Normalised tax rate provided in company financial exhibits. |
| Capex as % of Revenue | 2.5 | % | Historical average for Masco's asset-light model. |
| Dividend Per Share (2026) | 1.28 | $ | Annualised based on the $0.32 quarterly dividend declared in Feb 2026. |
| Annual Share Repurchases | 500.0 | $M | Assumes continuation of aggressive capital return programme. |
| Target Debt / EBITDA | 2.5 | x | Management's stated maximum leverage target. |
| WACC | 8.5 | % | Standard discount rate for a building products company of this risk profile. |
| Terminal Growth Rate | 2.0 | % | Long-term inflation and GDP growth proxy. |
Data Sources & Benchmarks
- Filings: SEC EDGAR for Masco's 10-K and 10-Q filings; Masco Investor Relations page for earnings presentations.
- Peers: Fortune Brands Innovations (FBIN), Sherwin-Williams (SHW), PPG Industries (PPG), Trane Technologies (TT).
- Industry Data: Leading Indicator of Remodeling Activity (LIRA) published by the Joint Center for Housing Studies of Harvard University.
- Consensus Estimates: FactSet or Bloomberg for validation of top-line and EPS estimates.
Sources
Do more with the Masco model
Frequently asked
What is Masco Corporation's primary business model and product focus?+
Masco Corporation is a global leader in the design, manufacture, and distribution of branded home improvement and building products. The company operates an asset-light manufacturing and distribution business model, primarily focusing on plumbing products and decorative architectural products.
What are the main revenue drivers for Masco Corporation?+
Masco's revenue is heavily indexed to the residential Repair and Remodel (R&R) market, which represents about 80% of its total sales. The company also benefits from its dominant competitive position and market-leading brands such as Delta, Hansgrohe, and Behr.
What is the assumed capital expenditure as a percentage of revenue in the Masco financial model?+
The financial model for Masco assumes a Capital Expenditure (Capex) as a percentage of revenue of approximately 2.2%. This reflects the company's asset-light operations, with about 70% of capex dedicated to maintenance and 30% to growth and efficiency improvements.
What are the key revenue growth and margin assumptions used in the Masco financial model?+
The Masco financial model forecasts revenue growth at approximately 4.4% for the forecast horizon. For profitability, the model assumes a Cost of Goods Sold (COGS) as a percentage of revenue of about 65.5% and Selling, General, and Administrative (SGA) expenses as a percentage of revenue of approximately 17.7%.
What is the purpose of the Masco financial model and what factors does it consider for valuation?+
The Masco financial model provides a comprehensive equity valuation and scenario planning tool for the company. It allows analysts to forecast earnings and cash flows based on the cyclicality of the residential repair and remodel market, raw material cost fluctuations, and the company's capital return program.
How can I access and use the Masco financial model for analysis?+
A downloadable Excel model for Masco is available, allowing users to forecast earnings and cash flows from FY2026 through FY2030. This model provides a detailed framework for understanding the company's financial performance and conducting scenario analysis.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Building Products Company Financial Models
Browse another company in the same sector.
Allegion
Allegion plc is a global provider of security products and access solutions, manufacturing mechanical locks, electronic security devices, and automatic doors for residential and commercial applications.
A. O. Smith
A.
Builders FirstSource
Builders FirstSource is the largest US supplier of building products, prefabricated components, and value-added services to the professional market for new residential construction and repair and remodelling.
Carrier Global
Carrier Global Corporation is a premier global provider of intelligent climate and energy solutions, encompassing heating, ventilation, air conditioning (HVAC), and transport refrigeration.
Johnson Controls
Johnson Controls is a global leader in smart, healthy, and sustainable building technologies, providing HVAC, fire detection, security systems, and building automation controls.
Lennox International
Lennox International is a leading global provider of climate control solutions, designing and manufacturing heating, ventilation, air conditioning, and refrigeration (HVACR) equipment.
Otis Worldwide
Otis Worldwide is the world's largest manufacturer, installer, and maintainer of elevators, escalators, and moving walkways, moving over 2.5 billion people daily.
Trane Technologies
Trane Technologies plc is a global climate innovator that designs, manufactures, and services commercial and residential heating, ventilation, and air conditioning (HVAC) systems, as well as transport refrigeration solutions.
Explore more Manufacturing financial model templates.
