|
Onto Innovation Inc. (ONTO) DCF Valuation
US | Technology | Semiconductors | NYSE
|
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Onto Innovation Inc. (ONTO) Bundle
Gain insight into your Onto Innovation Inc. (ONTO) valuation analysis with our cutting-edge DCF Calculator! Equipped with real (ONTO) data, this Excel template enables you to adjust forecasts and assumptions to accurately compute Onto Innovation Inc.'s intrinsic value.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 305.9 | 556.5 | 788.9 | 1,005.2 | 815.9 | 1,085.6 | 1,444.6 | 1,922.3 | 2,558.0 | 3,403.8 |
| Revenue Growth, % | 0 | 81.92 | 41.76 | 27.42 | -18.83 | 33.07 | 33.07 | 33.07 | 33.07 | 33.07 |
| EBITDA | 11.4 | 94.3 | 222.2 | 301.4 | 183.3 | 219.9 | 292.6 | 389.3 | 518.1 | 689.4 |
| EBITDA, % | 3.72 | 16.94 | 28.17 | 29.98 | 22.47 | 20.25 | 20.25 | 20.25 | 20.25 | 20.25 |
| Depreciation | 16.4 | 67.6 | 65.8 | 64.7 | 67.2 | 88.0 | 117.1 | 155.8 | 207.3 | 275.8 |
| Depreciation, % | 5.36 | 12.14 | 8.34 | 6.43 | 8.24 | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 |
| EBIT | -5.0 | 26.7 | 156.4 | 236.7 | 116.1 | 131.9 | 175.5 | 233.6 | 310.8 | 413.6 |
| EBIT, % | -1.65 | 4.79 | 19.83 | 23.55 | 14.23 | 12.15 | 12.15 | 12.15 | 12.15 | 12.15 |
| Total Cash | 320.2 | 373.7 | 511.3 | 547.8 | 697.8 | 807.7 | 1,074.8 | 1,430.2 | 1,903.1 | 2,532.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 123.7 | 149.3 | 177.2 | 241.4 | 226.6 | 307.2 | 408.8 | 544.0 | 723.9 | 963.2 |
| Account Receivables, % | 40.42 | 26.82 | 22.46 | 24.02 | 27.77 | 28.3 | 28.3 | 28.3 | 28.3 | 28.3 |
| Inventories | 176.1 | 191.2 | 243.1 | 324.3 | 327.8 | 423.8 | 564.0 | 750.5 | 998.6 | 1,328.8 |
| Inventories, % | 57.58 | 34.36 | 30.82 | 32.26 | 40.17 | 39.04 | 39.04 | 39.04 | 39.04 | 39.04 |
| Accounts Payable | 27.7 | 40.2 | 53.3 | 54.5 | 49.9 | 75.1 | 99.9 | 133.0 | 176.9 | 235.5 |
| Accounts Payable, % | 9.07 | 7.22 | 6.76 | 5.42 | 6.11 | 6.92 | 6.92 | 6.92 | 6.92 | 6.92 |
| Capital Expenditure | -6.8 | -3.8 | -12.0 | -18.4 | -22.6 | -19.6 | -26.1 | -34.7 | -46.2 | -61.5 |
| Capital Expenditure, % | -2.22 | -0.68806 | -1.53 | -1.83 | -2.77 | -1.81 | -1.81 | -1.81 | -1.81 | -1.81 |
| Tax Rate, % | 8.62 | 8.62 | 8.62 | 8.62 | 8.62 | 8.62 | 8.62 | 8.62 | 8.62 | 8.62 |
| EBITAT | 16.1 | 30.8 | 143.0 | 218.8 | 106.1 | 99.0 | 131.7 | 175.3 | 233.3 | 310.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -246.3 | 66.3 | 130.1 | 120.9 | 157.4 | 15.9 | 5.8 | 7.7 | 10.3 | 13.7 |
| WACC, % | 10.89 | 10.9 | 10.9 | 10.9 | 10.9 | 10.9 | 10.9 | 10.9 | 10.9 | 10.9 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 39.6 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 14 | |||||||||
| Terminal Value | 206 | |||||||||
| Present Terminal Value | 123 | |||||||||
| Enterprise Value | 162 | |||||||||
| Net Debt | -214 | |||||||||
| Equity Value | 376 | |||||||||
| Diluted Shares Outstanding, MM | 49 | |||||||||
| Equity Value Per Share | 7.63 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Onto Innovation Inc.’s financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Data Access: Onto Innovation Inc.’s historical financial records and projected forecasts are readily available.
- Customizable Parameters: Adjust inputs such as WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Valuation: Instantly view the recalculated intrinsic value of Onto Innovation Inc. as you modify inputs.
- Intuitive Visuals: Interactive dashboard charts present valuation outcomes and essential metrics clearly.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based ONTO DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional factors.
- Instant Calculations: The model automatically recalculates Onto Innovation's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial strategy.
Why Choose This Calculator for Onto Innovation Inc. (ONTO)?
- Accurate Data: Up-to-date Onto Innovation financials provide dependable valuation outcomes.
- Customizable: Tailor key inputs such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Ready-made calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the tech sector.
- User-Friendly: Simple design and clear, step-by-step guidance ensure accessibility for all users.
Who Should Use This Product?
- Investors: Accurately assess Onto Innovation Inc.'s (ONTO) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and analysis specific to Onto Innovation Inc. (ONTO).
- Consultants: Swiftly customize the template for valuation reports tailored to Onto Innovation Inc. (ONTO) clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading technology firms like Onto Innovation Inc. (ONTO).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to Onto Innovation Inc. (ONTO).
What the Template Contains
- Preloaded ONTO Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.