Plexus Corp. (PLXS) 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
Plexus Corp. (PLXS) Bundle
Designed for accuracy, our [PLXS] DCF Calculator enables you to evaluate Plexus Corp. valuation using authentic financial data and offers complete flexibility to modify all essential parameters for enhanced projections.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 3,390.4 | 3,368.9 | 3,811.4 | 4,210.3 | 3,960.8 | 4,129.6 | 4,305.5 | 4,488.9 | 4,680.2 | 4,879.6 |
Revenue Growth, % | 0 | -0.635 | 13.14 | 10.47 | -5.93 | 4.26 | 4.26 | 4.26 | 4.26 | 4.26 |
EBITDA | 216.2 | 240.3 | 243.1 | 288.5 | 167.7 | 255.8 | 266.7 | 278.1 | 289.9 | 302.3 |
EBITDA, % | 6.38 | 7.13 | 6.38 | 6.85 | 4.23 | 6.19 | 6.19 | 6.19 | 6.19 | 6.19 |
Depreciation | 56.7 | 61.0 | 62.7 | 69.8 | .0 | 56.0 | 58.4 | 60.9 | 63.5 | 66.2 |
Depreciation, % | 1.67 | 1.81 | 1.64 | 1.66 | 0 | 1.36 | 1.36 | 1.36 | 1.36 | 1.36 |
EBIT | 159.5 | 179.3 | 180.4 | 218.8 | 167.7 | 199.8 | 208.3 | 217.2 | 226.4 | 236.1 |
EBIT, % | 4.7 | 5.32 | 4.73 | 5.2 | 4.23 | 4.84 | 4.84 | 4.84 | 4.84 | 4.84 |
Total Cash | 385.8 | 270.2 | 274.8 | 256.2 | 345.1 | 342.0 | 356.6 | 371.8 | 387.6 | 404.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 596.0 | 635.0 | 876.2 | 803.8 | 742.9 | 803.3 | 837.6 | 873.3 | 910.5 | 949.2 |
Account Receivables, % | 17.58 | 18.85 | 22.99 | 19.09 | 18.76 | 19.45 | 19.45 | 19.45 | 19.45 | 19.45 |
Inventories | 763.5 | 972.3 | 1,602.8 | 1,562.0 | 1,311.4 | 1,351.6 | 1,409.1 | 1,469.2 | 1,531.8 | 1,597.0 |
Inventories, % | 22.52 | 28.86 | 42.05 | 37.1 | 33.11 | 32.73 | 32.73 | 32.73 | 32.73 | 32.73 |
Accounts Payable | 516.3 | 635.0 | 805.6 | 617.7 | 606.4 | 703.6 | 733.6 | 764.9 | 797.4 | 831.4 |
Accounts Payable, % | 15.23 | 18.85 | 21.14 | 14.67 | 15.31 | 17.04 | 17.04 | 17.04 | 17.04 | 17.04 |
Capital Expenditure | -50.1 | -57.1 | -101.6 | -104.0 | -95.2 | -88.5 | -92.2 | -96.2 | -100.3 | -104.5 |
Capital Expenditure, % | -1.48 | -1.69 | -2.67 | -2.47 | -2.4 | -2.14 | -2.14 | -2.14 | -2.14 | -2.14 |
Tax Rate, % | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 |
EBITAT | 138.4 | 155.2 | 157.5 | 189.0 | 144.8 | 173.2 | 180.6 | 188.2 | 196.3 | 204.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -698.2 | 30.0 | -582.5 | 80.0 | 349.8 | 137.4 | 84.9 | 88.5 | 92.3 | 96.2 |
WACC, % | 8.6 | 8.6 | 8.61 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 |
PV UFCF | ||||||||||
SUM PV UFCF | 397.7 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 99 | |||||||||
Terminal Value | 1,769 | |||||||||
Present Terminal Value | 1,171 | |||||||||
Enterprise Value | 1,569 | |||||||||
Net Debt | -66 | |||||||||
Equity Value | 1,634 | |||||||||
Diluted Shares Outstanding, MM | 28 | |||||||||
Equity Value Per Share | 58.55 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real Plexus Corp. (PLXS) financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Immediately observe the impact of your inputs on Plexus Corp.'s (PLXS) valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive PLXS Data: Pre-loaded with Plexus Corp.’s historical performance metrics and future projections.
- Customizable Assumptions: Modify revenue growth rates, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Model: Instantaneous updates to Net Present Value (NPV) and intrinsic value based on user-defined parameters.
- Scenario Analysis: Develop various forecasting scenarios to evaluate distinct valuation results.
- Intuitive Interface: Clean, organized, and suitable for both industry experts and newcomers.
How It Works
- 1. Access the Model: Download and open the Excel template featuring Plexus Corp.'s (PLXS) financial data.
- 2. Adjust Inputs: Modify essential parameters such as revenue growth, discount rate, and capital investments.
- 3. Analyze Results in Real-Time: The DCF model automatically computes the intrinsic value and net present value.
- 4. Explore Different Scenarios: Evaluate various projections to understand a range of valuation possibilities.
- 5. Make Informed Decisions: Deliver expert valuation analyses to back your strategic choices.
Why Choose Plexus Corp. (PLXS)?
- Innovative Solutions: Cutting-edge technology that meets your manufacturing needs.
- Quality Assurance: Rigorous testing processes ensure top-notch product reliability.
- Scalable Services: Flexible solutions that grow with your business requirements.
- Expert Support: Dedicated professionals ready to assist you at every step.
- Proven Track Record: Trusted by leading companies for exceptional performance and value.
Who Should Use This Product?
- Finance Students: Master valuation methodologies and apply them using real data from Plexus Corp. (PLXS).
- Academics: Integrate industry-standard models into your curriculum or research focused on Plexus Corp. (PLXS).
- Investors: Validate your investment hypotheses and evaluate valuation scenarios for Plexus Corp. (PLXS).
- Analysts: Enhance your analysis process with a customizable DCF model tailored for Plexus Corp. (PLXS).
- Small Business Owners: Understand the analytical approaches used for large public companies like Plexus Corp. (PLXS).
What the Template Contains
- Preloaded PLXS 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.