Financial Statements Modeling - Nucor

Overview From 2022 to 2024, Nucor Corporation experienced a normalization in steel demand and pricing following the elevated prices and profitability seen earlier in the cycle. As one of the largest steel producers in North America, Nucor operates a capital-intensive manufacturing business with revenue and profitability influenced by steel shipment volumes, average selling prices, raw material activity, and industry conditions. Nucor generates revenue across three primary segments: Steel Mills, Steel Products, and Raw Materials. Steel Mills represents the largest segment and is driven by outside shipment volumes and average selling prices, making it a useful example of how to build revenue from underlying operating drivers rather than simply applying a top-line growth rate. As a capital-intensive manufacturer, Nucor also requires significant investment in PP&E, resulting in substantial capital expenditures and depreciation. The company also has noncontrolling interests arising from subsidiaries that are not wholly owned, providing an opportunity to model how earnings attributable to noncontrolling shareholders and distributions affect the balance sheet. Financially, Nucor provides a useful example of a large, cyclical industrial company with significant fixed assets, working capital requirements, debt obligations, and multiple operating segments. The model captures the relationships between operating drivers, profitability, capital expenditures, depreciation, working capital, debt, noncontrolling interests, and cash generation. For analysts building a 3-statement model, Nucor is a useful example of a capital-intensive manufacturing company with: Multiple revenue segments driven by different operating factors Revenue influenced by both shipment volumes and average selling prices Significant investment in PP&E and corresponding depreciation Working capital requirements tied to receivables, inventory, and supplier payments Noncontrolling interests that affect both net income and shareholders' equity Debt financing and capital allocation through debt repayments, dividends, and share repurchases This exercise uses 2022–2024 historical financials and projects 2025–2029. It teaches how to build an integrated 3-statement model for a capital-intensive manufacturing company, forecast segment revenue using operating drivers, construct supporting schedules, model noncontrolling interests, and connect operating and financing assumptions across the financial statements. Learning Goals Build an integrated 3-statement financial model using 2022–2024 historical data and 2025–2029 projections. Forecast segment revenue using shipment volumes, average selling prices, and growth assumptions. Create and link supporting schedules for D&A, interest income & expense, PP&E, debt, retained earnings, and noncontrolling interests. Model working capital using operating drivers such as receivable days, inventory days, and payable days. Model capital expenditures and depreciation to connect the PP&E schedule across the three financial statements. Model noncontrolling interests and understand how NCI earnings and distributions affect consolidated financial statements. Model debt maturities, refinancing, and interest expense to connect the debt schedule across the financial statements. Reconcile cash balances so that ending cash from the Cash Flow Statement matches the Balance Sheet. Key Concepts Segment Revenue: Building revenue from operating drivers such as shipment volumes and average selling prices rather than relying solely on aggregate revenue growth. Cyclical Revenue Drivers: Understanding how volume and pricing assumptions affect revenue for a cyclical manufacturing business. Cost of Revenue (COGS) and Operating Expenses: Forecasting costs and operating expenses using margins and normalized relationships to revenue. Gross Profit, EBITDA, EBIT, EBT, and Net Income: Understanding how operating performance, depreciation, interest, and taxes flow through the Income Statement. Working Capital Dynamics: Projecting accounts receivable, inventory, accounts payable, and other operating assets and liabilities using appropriate operating drivers. Non-Cash Adjustments: Incorporating depreciation, amortization, and other non-cash items into cash flow modeling. Investing Activities: Modeling capital expenditures, PP&E additions, and investment activity for a capital-intensive business. Financing Activities: Capturing debt repayments, refinancing, dividends, and share repurchases. Noncontrolling Interests: Understanding how earnings attributable to noncontrolling shareholders and distributions affect NCI balances and consolidated net income. Retained Earnings and Stockholders’ Equity: Linking net income, dividends, stock-based compensation, share repurchases, and noncontrolling interests to equity balances. Balance Sheet Identity: Ensuring assets equal liabilities plus equity after all projections.

Practice Financial Statements Modeling - Nucor with interactive Excel modeling exercises in our Financial Statement Modeling module.

This hands-on modeling exercise helps you master Financial Statements Modeling - Nucor through real-world Excel practice and financial modeling techniques.