Corning logo
Corning Financial Model

Electronics Company Financials Example (Free Excel Download)

Corning Incorporated is a global leader in materials science, specialising in specialty glass, ceramics, and optical physics.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model evaluates Corning's equity valuation and cash flow generation capacity, focusing on the impact of the "Springboard" growth plan and the surging demand for Generative AI optical connectivity on consolidated margins and capital expenditure requirements.

Corning Incorporated is a global leader in materials science, specialising in specialty glass, ceramics, and optical physics. The company manufactures components that enable high-technology systems for consumer electronics, mobile emissions control, optical communications, and life sciences.

Business segments (based on 2025 recast reporting):

  • Optical Communications (~38% of revenue)
  • Display Technologies (~23% of revenue)
  • Specialty Materials (~13% of revenue)
  • Automotive (~11% of revenue)
  • Life Sciences & Hemlock/Emerging (~15% of revenue)

Corning operates an asset-heavy manufacturing business model with high fixed costs, requiring significant R&D and capital expenditure, but yielding strong operating leverage at scale. The company holds a dominant competitive position in display glass and optical fibre, competing with firms like AGC, Nippon Electric Glass, and Prysmian. Recently, Corning launched its "Springboard" plan targeting $11 billion in incremental annualised sales by 2028 and restructured its segments on 1 January 2025 by combining Automotive Glass Solutions and Environmental Technologies into a single Automotive segment.

The downloadable Corning 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 & AssumptionsCorning financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$14.08B$14.19B$12.59B$13.12B$15.63B
Gross profit$5.06B$4.51B$3.93B$4.28B$5.62B
Operating income$2.11B$1.44B$890.0M$1.14B$2.28B
Net income$1.91B$1.32B$581.0M$506.0M$1.60B

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
2.3%
COGS % of revenue
66.9%
R&D % of revenue
7.0%
SG&A % of revenue
14.0%
D&A % of revenue
10.7%
Effective tax rate
20.5%
See 8 more
Capex % of revenue
2.9%
Net working capital % of revenue
24.4%
Other assets % of revenue
81.7%
Other liabilities % of revenue
75.1%
Annual debt paydown
5.0%
Interest rate on debt
4.5%
Dividend payout ratio
0.0%
Buybacks % of net income
35.6%

How to build a detailed financial model for Corning

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

Optical Communications

  • Driver formula: (Carrier Network Miles Deployed x Price per Mile) + (Enterprise/Data Centre Ports x Price per Port)
  • Historical growth rate: 15% to 35% (grew 35% YoY in 2025 to $6.27 billion)
  • Key levers: Generative AI data centre buildouts, broadband infrastructure funding, 5G deployment.
  • Pricing dynamics: Contractual with major telecom and hyperscale cloud providers.

Display Technologies

  • Driver formula: Total Glass Market Volume (Square Metres) x Corning Market Share x Average Selling Price per Square Metre
  • Historical growth rate: -5% to +5% (declined 5% YoY in 2025 to $3.70 billion)
  • Key levers: TV and IT monitor retail demand, average screen size growth.
  • Pricing dynamics: Historically subject to moderate price declines; volume growth must offset price compression.

Specialty Materials

  • Driver formula: Premium Smartphone/IT Device Shipments x Gorilla Glass Content per Device
  • Historical growth rate: 5% to 10% (grew 10% YoY in 2025 to $2.21 billion)
  • Key levers: Smartphone replacement cycles, adoption of augmented reality optics, semiconductor equipment demand.
  • Pricing dynamics: Premium pricing based on proprietary formulations (e.g., Gorilla Glass Armor).

Automotive

  • Driver formula: Global Auto Production x Content per Vehicle (Gas Particulate Filters + Auto Glass)
  • Historical growth rate: -3% to +5% (declined 3% YoY in 2025 to $1.79 billion)
  • Key levers: Internal combustion engine regulations, adoption of large automotive interior displays.
  • Pricing dynamics: Long-term OEM contracts.

Life Sciences

  • Driver formula: Lab Consumables Volume x Price per Unit
  • Historical growth rate: 0% to 5%
  • Key levers: Bioproduction demand, cell and gene therapy research funding.
  • Pricing dynamics: Competitive but sticky due to validated manufacturing processes.

Cost Structure

Variable Costs / COGS

  • Breakdown: Raw materials (sand, chemicals), energy (natural gas and electricity for glass melting tanks), direct manufacturing labour, freight, and heavy depreciation of manufacturing equipment.
  • Gross margin range: 33% to 39% (Core gross margin reached 38.4% in 2025).
  • Input costs: Highly sensitive to energy prices and precious metals (used in glass manufacturing processes).
  • Scaling: High operating leverage. Because glass tanks must run continuously, incremental volume drops straight to the bottom line, while volume declines severely compress margins.

Operating Expenses

  • R&D: Typically 8% to 10% of revenue, covering materials science research and process engineering.
  • SG&A: Typically 12% to 14% of revenue, largely headcount-driven and corporate overhead.
  • Depreciation & Amortisation: Very high (often 10% to 12% of revenue) due to the capital intensity of glass fabrication plants.
  • Restructuring: Frequent non-GAAP adjustments for capacity realignments and severance.

Margin Profile

  • Gross margin: 35% to 39% (Core).
  • Operating margin: 14% to 21% (Core operating margin expanded to 19.3% in 2025, hitting 20.2% in Q4).
  • Net margin: 10% to 14% (Core).
  • Trend: Expanding rapidly due to the Springboard plan, pricing actions, and high-margin Optical Communications volume growth.

Balance Sheet Structure

  • Total assets: Approximately $31 billion.
  • Key asset categories: Property, Plant, and Equipment (PP&E) is the largest component, reflecting the heavy manufacturing footprint.
  • Goodwill & intangibles: Moderate, stemming from historical acquisitions (e.g., 3M Communication Markets Division).
  • Working capital profile:
  • DSO: 60 to 70 days.
  • DIO: 90 to 110 days (inventory is high due to continuous manufacturing requirements).
  • DPO: 50 to 65 days.
  • Net working capital: Positive, requiring cash absorption to fund growth.
  • PP&E: Glass melting tanks have specific useful lives and require expensive periodic rebuilds, creating a baseline of maintenance capital expenditure.

Capital Expenditure & Investment

  • Capex as % of revenue: 10% to 13% historically.
  • Maintenance vs growth: Approximately 40% maintenance (tank rebuilds, facility upkeep) and 60% growth (new optical fibre plants, Gen AI capacity expansion).
  • Major programmes: Expanding optical cable manufacturing capacity to meet Meta and other hyperscaler demand.
  • M&A pattern: Primarily organic grower with occasional bolt-on acquisitions in Optical and Life Sciences.

Debt & Capital Structure

  • Total debt: Approximately $8.4 billion ($7.6 billion long-term).
  • Net debt: Approximately $6.9 billion (against ~$1.5 billion in cash).
  • Debt/EBITDA: Approximately 2.5x to 3.0x.
  • Key debt instruments: Unsecured notes and debentures, many denominated in foreign currencies (Yen, Euro) to align with global cash flows.
  • Interest rate profile: Weighted average cost of debt is approximately 4.65%.
  • Share repurchase: Active programme, reducing share count to approximately 858 million by late 2025.
  • Dividend policy: Consistent payer, yielding around 1.3% with a quarterly payout of approximately $0.22 to $0.28 per share.

Cash Flow Characteristics

  • OCF conversion: Strong, generating $2.70 billion in operating cash flow in 2025.
  • FCF margin: Adjusted free cash flow margin is roughly 10% to 12% ($1.72 billion on $16.41 billion core sales in 2025).
  • Non-cash items: Massive D&A add-backs, plus significant non-cash mark-to-market adjustments on translated earnings contracts and foreign-denominated debt.
  • Capex intensity: High capital intensity limits free cash flow conversion relative to asset-light peers.
  • Tax rate: Effective tax rate runs around 15.1%, benefiting from foreign tax credits and R&D incentives.

Sheet Structure

  1. Assumptions: Hardcoded drivers for macroeconomic inputs, segment growth rates, pricing assumptions, and margin targets.
  2. Revenue_Build: Segment-level volume and pricing schedules for Optical Communications, Display, Specialty Materials, Automotive, and Life Sciences.
  3. GAAP_to_Core_Rec: Reconciliation engine translating GAAP figures to Core metrics (adjusting for translated earnings contracts and constant currency).
  4. IS: Consolidated Income Statement, driven by the Revenue Build and Core margin assumptions.
  5. BS: Balance Sheet, projecting working capital, PP&E, and debt balances.
  6. CFS: Cash Flow Statement, bridging net income to OCF and FCF.
  7. Capex_and_Depreciation: Waterfall schedule for glass tank rebuilds, new capacity capex, and D&A.
  8. Debt_Schedule: Tranche-by-tranche debt roll-forward, interest expense calculation, and foreign currency debt translation impacts.
  9. Working_Capital: DSO, DIO, and DPO schedules driving the cash flow impact of inventory and receivables.
  10. DCF: Unlevered free cash flow calculation, WACC derivation, and terminal value calculation.

Key Financial Relationships

  1. `Optical Communications Revenue = (Carrier Network Volume x Carrier ASP) + (Enterprise Volume x Enterprise ASP)`
  2. `Display Technologies Revenue = Global Glass Market Square Metres x Corning Market Share x Blended ASP`
  3. `Automotive Revenue = Global Light Vehicle Build Rate x Corning Content per Vehicle`
  4. `Core Net Sales = GAAP Net Sales + Constant Currency Adjustments`
  5. `Core Gross Profit = GAAP Gross Profit + Translated Earnings Contract Adjustments + Restructuring Charges`
  6. `Segment Net Income = Segment Net Sales x Segment Net Margin`
  7. `Consolidated Core Net Income = Sum of Segment Net Income - Unallocated Corporate Expenses`
  8. `Ending PP&E = Beginning PP&E + Capital Expenditures - Depreciation Expense - Asset Retirements`
  9. `Adjusted Free Cash Flow = Operating Cash Flow - Capital Expenditures + Cash Received from Translated Earnings Contracts`
  10. `Interest Expense = Average Debt Balance x Weighted Average Interest Rate`

Cross-Sheet Dependencies

  • The Revenue_Build sheet dictates the top line on the IS and drives the volume metrics required in the Capex_and_Depreciation sheet.
  • The GAAP_to_Core_Rec sheet sits between the IS and the CFS, as non-cash mark-to-market adjustments must be stripped out of GAAP Net Income to calculate true operating cash flow.
  • The Capex_and_Depreciation sheet feeds depreciation into the IS (split between COGS and SG&A) and capital expenditures into the CFS.
  • The Debt_Schedule creates a circularity: Interest expense on the IS reduces Net Income, which lowers cash on the BS, which may trigger revolver drawdowns on the Debt_Schedule, increasing Interest expense. A circuit breaker switch must be included.

Sign Convention

  • Revenue, Assets, and Equity are positive.
  • Expenses (COGS, SG&A, Interest, Taxes) are entered as positive numbers in their build schedules but subtracted in the Income Statement totals.
  • Liabilities are positive on the Balance Sheet.
  • Cash Flow Statement: Cash inflows are positive; cash outflows (e.g., Capital Expenditures, Dividends Paid, Share Repurchases) are negative.

Things Most Likely to Go Wrong

  • Segment Restructuring: Corning changed its segment reporting on 1 January 2025, merging Automotive Glass and Environmental Technologies into "Automotive". Historical data prior to 2025 must be recast to match this structure.
  • Translated Earnings Contracts: Corning uses complex derivative contracts to hedge Yen and Euro exposure. The non-cash mark-to-market swings on these contracts distort GAAP earnings massively. The model must focus on Core (Non-GAAP) earnings for operational forecasting.
  • Display Glass Pricing: Analysts often model flat pricing, but display glass ASPs historically decline. The model must explicitly forecast volume growth offsetting ASP compression.
  • Capital Intensity Underestimation: Glass melting tanks require periodic, expensive rebuilds. Modelling capex as a flat percentage of revenue will miss the lumpy nature of maintenance capex.
  • Yen Exposure: A significant portion of Display revenue is denominated in Japanese Yen. Failure to account for constant-currency adjustments will result in inaccurate margin forecasts.
  • Equity Earnings: Corning has joint ventures (e.g., Hemlock Semiconductor). Equity earnings from affiliated companies must be modelled below operating income but above net income.
  • Share Count Drift: Corning aggressively buys back stock. Holding the share count flat will understate EPS growth.
  • Deferred Revenue: Customer deposits for future capacity (especially in Optical Communications) sit in liabilities and are recognised over time. This must be tracked to bridge cash flow to revenue.

Validation Checks

  • "Core Gross Margin should be in the 36% to 39% range; flag if outside this band."
  • "Core Operating Margin should not exceed 22% without explicit justification of unprecedented operating leverage."
  • "Capex as a % of revenue should run between 10% and 13%."
  • "Adjusted Free Cash Flow conversion (Adjusted FCF / Core Net Income) should be between 70% and 90%."
  • "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
  • "Optical Communications revenue growth should not exceed 35% YoY without flagging."
  • "Effective tax rate should remain between 14% and 16% based on historical foreign tax credit utilisation."
  • "Debt/EBITDA should remain below 3.5x to maintain investment-grade rating metrics."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Optical Communications Growth15.0%Continued strong Gen AI and data centre demand, normalising from 2025 peak
Display Technologies Growth-2.0%Flat volume offset by slight ASP compression
Specialty Materials Growth6.0%Steady smartphone replacement cycle and premium glass adoption
Automotive Growth2.0%Modest global auto production growth and higher display content per vehicle
Core Gross Margin38.4%Aligns with full-year 2025 actuals
Core Operating Margin19.3%Aligns with full-year 2025 actuals
R&D as % of Sales8.5%Historical average required to maintain materials science leadership
SG&A as % of Sales12.5%Historical average, reflecting recent cost reduction initiatives
Capex as % of Sales11.0%Blended rate of maintenance tank rebuilds and optical capacity expansion
Effective Tax Rate15.1%2025 actual effective tax rate
Weighted Average Cost of Debt4.65%Current blended interest rate on outstanding debt
WACC8.16%Calculated based on current risk-free rate, beta of 1.06, and ERP
Diluted Shares Outstanding858MillionsQ4 2025 actual share count
Annual Dividend per Share1.12$Based on recent quarterly payouts of ~$0.28
Terminal Growth Rate2.0%Standard long-term GDP growth proxy

Data Sources & Benchmarks

  • Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and Corning Investor Relations page for quarterly Core vs GAAP reconciliation tables.
  • Peers for Benchmarking: Amphenol (APH), CommScope (COMM), Coherent (COHR), Nippon Electric Glass, AGC Inc.
  • Industry Data: Dell'Oro Group (for telecom and data centre capex trends), Omdia (for display panel shipments and glass area demand), WardsAuto (for global light vehicle production).
  • Consensus Estimates: Bloomberg or FactSet for forward-looking segment revenue consensus.

Sources

Frequently asked

What does Corning Inc. (GLW) do, and what are its main business segments?+

Corning Incorporated is a global leader in materials science, specializing in specialty glass, ceramics, and optical physics. The company manufactures high-technology components for consumer electronics, mobile emissions control, optical communications, and life sciences, with key segments including Optical Communications, Display Technologies, and Specialty Materials.

What are the primary revenue drivers for Corning's Optical Communications segment?+

The Optical Communications segment's revenue is primarily driven by carrier network miles deployed and enterprise/data center ports, along with their respective pricing. Key levers for growth include Generative AI data center buildouts, broadband infrastructure funding, and 5G deployment.

What is Corning's historical capital expenditure as a percentage of revenue, and what drives it?+

Historically, Corning's capital expenditure has ranged from 10% to 13% of revenue. This significant investment is split between approximately 40% for maintenance, such as glass melting tank rebuilds, and 60% for growth, including new optical fiber plants and Gen AI capacity expansion.

What are the key assumptions used in the Corning financial model for forecasting purposes?+

The financial model for Corning uses key assumptions such as revenue growth, COGS as a percentage of revenue, R&D as a percentage of revenue, and SGA as a percentage of revenue. Other important inputs include depreciation and amortization, tax rate, capital expenditure, and net working capital, all expressed as percentages of revenue.

Can I download an Excel financial model for Corning Inc. (GLW)?+

Yes, an Excel financial model for Corning Inc. (GLW) is available for download. This model evaluates Corning's equity valuation and cash flow generation capacity, with a forecast horizon from FY2026 to FY2030.

How does Corning's "Springboard" growth plan impact its financial outlook?+

Corning's "Springboard" plan targets $11 billion in incremental annualised sales by 2028. This strategy is expected to impact consolidated margins and capital expenditure requirements, particularly due to surging demand for Generative AI optical connectivity.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

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 Electronics Company Financial Models

Browse another company in the same sector.

APH.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Amphenol logo

Amphenol

Amphenol Corporation is one of the world's largest designers and manufacturers of electrical, electronic, and fibre optic connectors, interconnect systems, antennas, sensors, and coaxial cables.

AXON.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Axon Enterprise logo

Axon Enterprise

Axon Enterprise is the global leader in public safety technology, providing a connected ecosystem of hardware and cloud software to law enforcement, military, and enterprise customers.

COHR.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Coherent logo

Coherent

Coherent is a vertically integrated global leader in engineered materials, optoelectronic components, and laser systems, providing optical solutions for cloud computing, AI datacenters, telecommunications, and precision lasers for industrial and consumer electronics applications.

JBL.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Jabil logo

Jabil

Jabil is a leading global electronic manufacturing services provider, offering comprehensive electronics design, production, and product management services and end-to-end supply chain solutions across industries.

KEYS.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Keysight Technologies logo

Keysight Technologies

Keysight Technologies provides electronic design and test solutions, including hardware instruments, software, and related services used in the simulation, design, validation, and manufacture of electronic systems.

LITE.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Lumentum logo

Lumentum

Lumentum is a market-leading designer and manufacturer of innovative optical and photonic products that enable optical networking and commercial laser applications worldwide.

MSI.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Motorola Solutions logo

Motorola Solutions

Motorola Solutions is a leading global provider of mission-critical communications, video security, and command centre software for public safety and enterprise customers.

TDY.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Teledyne Technologies logo

Teledyne Technologies

Teledyne Technologies Incorporated is an industrial conglomerate that provides enabling technologies for industrial growth markets, including aerospace, defence, factory automation, and environmental monitoring.

Explore more Tech & Software financial model templates.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview