Matrix Service Company (MTRX) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Matrix Service Company (MTRX) Bundle
Optimize your efficiency and improve precision with our (MTRX) DCF Calculator! Utilizing actual data from Matrix Service Company and customizable assumptions, this tool empowers you to forecast, analyze, and evaluate (MTRX) just like a seasoned investor.
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 | 1,100.9 | 673.4 | 707.8 | 795.0 | 728.2 | 674.0 | 623.7 | 577.3 | 534.2 | 494.4 |
Revenue Growth, % | 0 | -38.83 | 5.11 | 12.33 | -8.4 | -7.45 | -7.45 | -7.45 | -7.45 | -7.45 |
EBITDA | -15.9 | -23.8 | -40.1 | -37.0 | -12.9 | -23.0 | -21.3 | -19.7 | -18.2 | -16.9 |
EBITDA, % | -1.45 | -3.54 | -5.66 | -4.66 | -1.77 | -3.42 | -3.42 | -3.42 | -3.42 | -3.42 |
Depreciation | 19.1 | 17.9 | 15.3 | 13.7 | 11.0 | 13.2 | 12.2 | 11.3 | 10.5 | 9.7 |
Depreciation, % | 1.74 | 2.65 | 2.16 | 1.72 | 1.51 | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 |
EBIT | -35.0 | -41.7 | -55.3 | -50.7 | -23.9 | -36.2 | -33.5 | -31.0 | -28.7 | -26.6 |
EBIT, % | -3.18 | -6.19 | -7.82 | -6.38 | -3.28 | -5.37 | -5.37 | -5.37 | -5.37 | -5.37 |
Total Cash | 100.0 | 83.9 | 52.4 | 54.8 | 115.6 | 69.7 | 64.5 | 59.7 | 55.3 | 51.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 224.1 | 195.8 | 212.2 | 191.1 | 173.1 | 171.5 | 158.7 | 146.9 | 135.9 | 125.8 |
Account Receivables, % | 20.36 | 29.07 | 29.98 | 24.04 | 23.77 | 25.44 | 25.44 | 25.44 | 25.44 | 25.44 |
Inventories | 6.5 | 7.3 | 10.0 | 7.4 | 8.8 | 7.1 | 6.5 | 6.0 | 5.6 | 5.2 |
Inventories, % | 0.58677 | 1.09 | 1.41 | 0.93545 | 1.21 | 1.05 | 1.05 | 1.05 | 1.05 | 1.05 |
Accounts Payable | 73.1 | 60.9 | 74.9 | 76.4 | 65.6 | 60.5 | 56.0 | 51.8 | 48.0 | 44.4 |
Accounts Payable, % | 6.64 | 9.05 | 10.58 | 9.61 | 9.01 | 8.98 | 8.98 | 8.98 | 8.98 | 8.98 |
Capital Expenditure | -18.5 | -4.4 | -3.3 | -9.0 | -7.0 | -6.6 | -6.1 | -5.7 | -5.2 | -4.8 |
Capital Expenditure, % | -1.68 | -0.64657 | -0.4726 | -1.13 | -0.96043 | -0.97934 | -0.97934 | -0.97934 | -0.97934 | -0.97934 |
Tax Rate, % | 0.14393 | 0.14393 | 0.14393 | 0.14393 | 0.14393 | 0.14393 | 0.14393 | 0.14393 | 0.14393 | 0.14393 |
EBITAT | -31.6 | -30.1 | -60.7 | -50.4 | -23.8 | -33.4 | -30.9 | -28.6 | -26.5 | -24.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -188.6 | -1.3 | -53.8 | -20.6 | -13.9 | -28.6 | -16.0 | -14.8 | -13.7 | -12.7 |
WACC, % | 9.99 | 9.93 | 10.02 | 10.02 | 10.02 | 9.99 | 9.99 | 9.99 | 9.99 | 9.99 |
PV UFCF | ||||||||||
SUM PV UFCF | -67.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -13 | |||||||||
Terminal Value | -162 | |||||||||
Present Terminal Value | -101 | |||||||||
Enterprise Value | -168 | |||||||||
Net Debt | -93 | |||||||||
Equity Value | -76 | |||||||||
Diluted Shares Outstanding, MM | 27 | |||||||||
Equity Value Per Share | -2.77 |
What You Will Receive
- Comprehensive Financial Model: Matrix Service Company's actual data facilitates accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Real-Time Calculations: Immediate updates ensure you observe results as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Reusable: Designed for versatility, allowing for repeated application in detailed forecasting.
Key Features
- Pre-Loaded Data: Matrix Service Company's historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Customize WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: Observe Matrix Service Company's intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts showcase valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Matrix Service Company (MTRX) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Matrix Service Company’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Matrix Service Company (MTRX)?
- Proven Expertise: Extensive experience in providing top-notch services in the energy and industrial sectors.
- Commitment to Safety: Prioritizing safety in all operations, ensuring a secure environment for employees and clients.
- Innovative Solutions: Utilizing the latest technology to deliver effective and efficient services tailored to client needs.
- Strong Customer Relationships: Building lasting partnerships through exceptional service and support.
- Industry Recognition: A trusted name in the market, known for quality and reliability by industry leaders.
Who Should Use This Product?
- Investors: Assess Matrix Service Company's (MTRX) valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts.
- Startup Founders: Understand the valuation strategies of established firms like Matrix Service Company (MTRX).
- Consultants: Provide detailed valuation analyses and reports for clients in the industry.
- Students and Educators: Utilize current data to learn and teach valuation practices effectively.
What the Template Contains
- Historical Data: Includes Matrix Service Company's (MTRX) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Matrix Service Company's (MTRX) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital specific to Matrix Service Company (MTRX).
- Editable Inputs: Modify key drivers such as growth rates, EBITDA %, and CAPEX assumptions relevant to Matrix Service Company (MTRX).
- Quarterly and Annual Statements: A complete breakdown of Matrix Service Company's (MTRX) financials.
- Interactive Dashboard: Visualize valuation results and projections for Matrix Service Company (MTRX) dynamically.