Universal Stainless & Alloy Products, Inc. (USAP) DCF Valuation
- ✓ 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
Universal Stainless & Alloy Products, Inc. (USAP) Bundle
Whether you’re an investor or analyst, this (USAP) DCF Calculator is your ultimate tool for accurate valuation. Preloaded with real data from Universal Stainless & Alloy Products, Inc., you can adjust forecasts and instantly see the effects.
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 | 243.0 | 179.7 | 155.9 | 202.1 | 285.9 | 308.7 | 333.2 | 359.7 | 388.3 | 419.2 |
| Revenue Growth, % | 0 | -26.04 | -13.24 | 29.62 | 41.48 | 7.95 | 7.95 | 7.95 | 7.95 | 7.95 |
| EBITDA | 24.6 | -3.7 | 15.6 | 13.1 | 33.2 | 22.3 | 24.1 | 26.0 | 28.0 | 30.3 |
| EBITDA, % | 10.12 | -2.08 | 9.99 | 6.47 | 11.59 | 7.22 | 7.22 | 7.22 | 7.22 | 7.22 |
| Depreciation | 16.8 | 17.5 | 17.4 | 17.4 | 19.4 | 26.7 | 28.8 | 31.1 | 33.6 | 36.3 |
| Depreciation, % | 6.93 | 9.76 | 11.16 | 8.61 | 6.8 | 8.65 | 8.65 | 8.65 | 8.65 | 8.65 |
| EBIT | 7.8 | -21.3 | -1.8 | -4.3 | 13.7 | -4.4 | -4.8 | -5.2 | -5.6 | -6.0 |
| EBIT, % | 3.2 | -11.84 | -1.17 | -2.14 | 4.8 | -1.43 | -1.43 | -1.43 | -1.43 | -1.43 |
| Total Cash | .2 | .2 | .1 | 2.0 | .4 | .8 | .9 | 1.0 | 1.1 | 1.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 35.6 | 18.1 | 21.2 | 31.0 | 39.0 | 41.5 | 44.8 | 48.4 | 52.3 | 56.4 |
| Account Receivables, % | 14.65 | 10.07 | 13.59 | 15.32 | 13.65 | 13.46 | 13.46 | 13.46 | 13.46 | 13.46 |
| Inventories | 147.4 | 111.4 | 140.7 | 154.2 | 144.7 | 209.7 | 226.4 | 244.4 | 263.9 | 284.9 |
| Inventories, % | 60.66 | 61.97 | 90.22 | 76.29 | 50.6 | 67.95 | 67.95 | 67.95 | 67.95 | 67.95 |
| Accounts Payable | 40.9 | 12.6 | 24.0 | 38.2 | 34.9 | 43.4 | 46.9 | 50.6 | 54.6 | 59.0 |
| Accounts Payable, % | 16.84 | 7.03 | 15.39 | 18.89 | 12.19 | 14.07 | 14.07 | 14.07 | 14.07 | 14.07 |
| Capital Expenditure | -17.4 | -9.2 | -11.1 | -12.1 | -13.0 | -18.5 | -19.9 | -21.5 | -23.2 | -25.1 |
| Capital Expenditure, % | -7.14 | -5.09 | -7.12 | -5.98 | -4.56 | -5.98 | -5.98 | -5.98 | -5.98 | -5.98 |
| Tax Rate, % | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 |
| EBITAT | 8.8 | -16.7 | -.3 | -3.3 | 12.7 | -3.2 | -3.5 | -3.8 | -4.1 | -4.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -133.8 | 16.9 | -15.1 | -7.1 | 17.2 | -54.0 | -11.1 | -12.0 | -13.0 | -14.0 |
| WACC, % | 9 | 8.63 | 7.61 | 8.58 | 8.87 | 8.54 | 8.54 | 8.54 | 8.54 | 8.54 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -87.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -14 | |||||||||
| Terminal Value | -218 | |||||||||
| Present Terminal Value | -145 | |||||||||
| Enterprise Value | -232 | |||||||||
| Net Debt | 85 | |||||||||
| Equity Value | -317 | |||||||||
| Diluted Shares Outstanding, MM | 9 | |||||||||
| Equity Value Per Share | -34.21 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-filled real USAP financials.
- Authentic Data: Historical figures and forward-looking projections (as indicated in the highlighted cells).
- Assumption Flexibility: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Universal Stainless & Alloy Products, Inc.'s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Real-Life USAP Data: Pre-filled with Universal Stainless & Alloy Products, Inc.'s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to evaluate different valuation outcomes.
- User-Friendly Design: Intuitive, structured interface suitable for both professionals and beginners.
How It Works
- Download: Obtain the comprehensive Excel file featuring Universal Stainless & Alloy Products, Inc.'s (USAP) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment choices.
Why Choose Universal Stainless & Alloy Products, Inc. (USAP)?
- Quality Assurance: Our products meet the highest industry standards for stainless and alloy materials.
- Expertise in the Field: Decades of experience ensure reliable solutions tailored to your needs.
- Wide Product Range: A comprehensive selection of stainless and alloy products to suit various applications.
- Customer-Centric Approach: We prioritize your requirements and provide personalized support throughout the process.
- Industry Recognition: Trusted by leading manufacturers for our commitment to excellence and innovation.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about investing in Universal Stainless & Alloy Products, Inc. (USAP).
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for USAP.
- Consultants: Provide clients with accurate and timely valuation analyses of USAP.
- Business Owners: Learn about the valuation of companies like Universal Stainless to inform your own business strategies.
- Finance Students: Explore valuation methodologies using real data and case studies related to USAP.
What the Template Contains
- Pre-Filled DCF Model: Universal Stainless & Alloy Products, Inc. (USAP) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Universal Stainless & Alloy Products, Inc. (USAP) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.