|
Marten Transport, Ltd. (MRTN) Valoración de DCF
US | Industrials | Trucking | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Marten Transport, Ltd. (MRTN) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF de Marten Transport, Ltd. (MRTN)! Utilice datos financieros auténticos, ajuste las proyecciones y gastos de crecimiento e inmediatamente observe cómo las alteraciones afectan el valor intrínseco del transporte de Marten, Ltd. (MRTN).
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 | 843.3 | 874.4 | 973.6 | 1,263.9 | 1,131.5 | 1,228.7 | 1,334.3 | 1,448.9 | 1,573.4 | 1,708.6 |
| Revenue Growth, % | 0 | 3.69 | 11.35 | 29.81 | -10.48 | 8.59 | 8.59 | 8.59 | 8.59 | 8.59 |
| EBITDA | 163.0 | 185.7 | 198.0 | 241.0 | 200.4 | 240.0 | 260.6 | 283.0 | 307.4 | 333.8 |
| EBITDA, % | 19.32 | 21.24 | 20.33 | 19.07 | 17.71 | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 |
| Depreciation | 95.1 | 102.9 | 102.6 | 111.0 | 116.7 | 129.5 | 140.6 | 152.7 | 165.8 | 180.0 |
| Depreciation, % | 11.28 | 11.77 | 10.53 | 8.78 | 10.32 | 10.54 | 10.54 | 10.54 | 10.54 | 10.54 |
| EBIT | 67.8 | 82.8 | 95.4 | 130.0 | 83.7 | 110.5 | 120.0 | 130.4 | 141.6 | 153.7 |
| EBIT, % | 8.04 | 9.47 | 9.8 | 10.28 | 7.39 | 9 | 9 | 9 | 9 | 9 |
| Total Cash | 31.5 | 66.1 | 57.0 | 80.6 | 53.2 | 69.4 | 75.3 | 81.8 | 88.8 | 96.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 92.4 | 89.2 | 101.2 | 123.4 | 118.0 | 127.2 | 138.1 | 150.0 | 162.9 | 176.9 |
| Account Receivables, % | 10.96 | 10.2 | 10.4 | 9.77 | 10.43 | 10.35 | 10.35 | 10.35 | 10.35 | 10.35 |
| Inventories | 3.4 | 3.4 | 4.4 | 5.4 | 6.3 | 5.5 | 5.9 | 6.4 | 7.0 | 7.6 |
| Inventories, % | 0.40248 | 0.38565 | 0.44934 | 0.42939 | 0.55557 | 0.44449 | 0.44449 | 0.44449 | 0.44449 | 0.44449 |
| Accounts Payable | 22.9 | 25.7 | 20.2 | 37.3 | 36.5 | 34.2 | 37.1 | 40.3 | 43.8 | 47.5 |
| Accounts Payable, % | 2.72 | 2.94 | 2.07 | 2.95 | 3.23 | 2.78 | 2.78 | 2.78 | 2.78 | 2.78 |
| Capital Expenditure | -189.4 | -173.1 | -199.3 | -176.6 | -240.6 | -240.7 | -261.4 | -283.9 | -308.3 | -334.7 |
| Capital Expenditure, % | -22.46 | -19.79 | -20.47 | -13.97 | -21.26 | -19.59 | -19.59 | -19.59 | -19.59 | -19.59 |
| Tax Rate, % | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 |
| EBITAT | 53.3 | 61.6 | 72.9 | 99.5 | 62.7 | 84.2 | 91.5 | 99.3 | 107.9 | 117.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -113.9 | -2.5 | -42.4 | 27.8 | -57.3 | -37.8 | -37.8 | -41.1 | -44.6 | -48.4 |
| WACC, % | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -164.7 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -50 | |||||||||
| Terminal Value | -956 | |||||||||
| Present Terminal Value | -644 | |||||||||
| Enterprise Value | -809 | |||||||||
| Net Debt | -53 | |||||||||
| Equity Value | -756 | |||||||||
| Diluted Shares Outstanding, MM | 81 | |||||||||
| Equity Value Per Share | -9.29 |
What You Will Get
- Real Marten Transport Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Marten Transport, Ltd. (MRTN).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Marten Transport's fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed financial projections.
- Time-Saving and Accurate: Avoid the hassle of building models from scratch while ensuring precision and flexibility.
Key Features
- 🔍 Real-Life MRTN Financials: Pre-filled historical and projected data for Marten Transport, Ltd.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Marten Transport’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Marten Transport’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file for Marten Transport, Ltd. (MRTN).
- Step 2: Review the pre-filled financial data and forecasts for Marten Transport.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment decisions.
Why Choose This Calculator?
- Accuracy: Utilizes real Marten Transport financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of building a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use Marten Transport, Ltd. (MRTN)?
- Investors: Gain insights into the transportation sector with a reliable investment analysis tool.
- Financial Analysts: Streamline your workflow with a comprehensive financial model tailored for Marten Transport.
- Consultants: Easily modify the framework for client discussions or strategic reports focused on logistics.
- Transportation Enthusiasts: Enhance your knowledge of the industry using real-time data and case studies.
- Educators and Students: Utilize it as a hands-on resource in logistics and transportation management courses.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Marten Transport, Ltd. (MRTN).
- Real-World Data: Marten Transport’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Marten Transport’s performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Marten Transport, Ltd. (MRTN).
- Dashboard with Visual Outputs: Charts and tables designed for clear and actionable results.