|
Modine Manufacturing Company (MOD) DCF Valuation
US | Consumer Cyclical | Auto - Parts | 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
Modine Manufacturing Company (MOD) Bundle
Evaluate Modine Manufacturing Company's financial outlook like an expert! This (MOD) DCF Calculator offers pre-filled financial data and full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your 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 | 1,975.5 | 1,808.4 | 2,050.1 | 2,297.9 | 2,407.8 | 2,538.9 | 2,677.1 | 2,822.9 | 2,976.5 | 3,138.6 |
| Revenue Growth, % | 0 | -8.46 | 13.37 | 12.09 | 4.78 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 |
| EBITDA | 132.6 | -31.3 | 147.8 | 208.0 | 294.8 | 170.0 | 179.3 | 189.1 | 199.3 | 210.2 |
| EBITDA, % | 6.71 | -1.73 | 7.21 | 9.05 | 12.24 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 |
| Depreciation | 77.1 | 68.6 | 54.8 | 54.5 | 56.1 | 76.5 | 80.7 | 85.1 | 89.7 | 94.6 |
| Depreciation, % | 3.9 | 3.79 | 2.67 | 2.37 | 2.33 | 3.01 | 3.01 | 3.01 | 3.01 | 3.01 |
| EBIT | 55.5 | -99.9 | 93.0 | 153.5 | 238.7 | 93.5 | 98.6 | 104.0 | 109.6 | 115.6 |
| EBIT, % | 2.81 | -5.52 | 4.54 | 6.68 | 9.91 | 3.68 | 3.68 | 3.68 | 3.68 | 3.68 |
| Total Cash | 70.9 | 37.8 | 45.2 | 67.1 | 60.1 | 67.5 | 71.2 | 75.1 | 79.2 | 83.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 314.2 | 273.6 | 406.6 | 428.2 | 435.8 | 444.8 | 469.0 | 494.6 | 521.5 | 549.9 |
| Account Receivables, % | 15.9 | 15.13 | 19.83 | 18.63 | 18.1 | 17.52 | 17.52 | 17.52 | 17.52 | 17.52 |
| Inventories | 207.4 | 195.6 | 281.2 | 324.9 | 357.9 | 325.2 | 342.9 | 361.5 | 381.2 | 402.0 |
| Inventories, % | 10.5 | 10.82 | 13.72 | 14.14 | 14.86 | 12.81 | 12.81 | 12.81 | 12.81 | 12.81 |
| Accounts Payable | 227.4 | 233.9 | 325.8 | 332.8 | 283.4 | 338.1 | 356.5 | 375.9 | 396.4 | 418.0 |
| Accounts Payable, % | 11.51 | 12.93 | 15.89 | 14.48 | 11.77 | 13.32 | 13.32 | 13.32 | 13.32 | 13.32 |
| Capital Expenditure | -71.3 | -32.7 | -40.3 | -50.7 | -88.5 | -67.4 | -71.0 | -74.9 | -79.0 | -83.3 |
| Capital Expenditure, % | -3.61 | -1.81 | -1.97 | -2.21 | -3.68 | -2.65 | -2.65 | -2.65 | -2.65 | -2.65 |
| Tax Rate, % | 24.74 | 24.74 | 24.74 | 24.74 | 24.74 | 24.74 | 24.74 | 24.74 | 24.74 | 24.74 |
| EBITAT | -10.7 | -175.4 | 78.1 | 187.6 | 179.6 | 67.2 | 70.8 | 74.7 | 78.8 | 83.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -299.1 | -80.6 | -34.1 | 133.1 | 57.2 | 154.8 | 57.0 | 60.1 | 63.4 | 66.8 |
| WACC, % | 13.93 | 14.28 | 14.23 | 14.28 | 14.2 | 14.18 | 14.18 | 14.18 | 14.18 | 14.18 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 291.3 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 69 | |||||||||
| Terminal Value | 647 | |||||||||
| Present Terminal Value | 333 | |||||||||
| Enterprise Value | 625 | |||||||||
| Net Debt | 449 | |||||||||
| Equity Value | 176 | |||||||||
| Diluted Shares Outstanding, MM | 53 | |||||||||
| Equity Value Per Share | 3.29 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled real MOD financials.
- Accurate Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly view how your inputs affect Modine's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and ease of use, complete with step-by-step guidance.
Key Features
- 🔍 Real-Life MOD Financials: Pre-filled historical and projected data for Modine Manufacturing Company (MOD).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Modine’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Modine’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based MOD DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Modine Manufacturing Company's intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation impacts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis decisions.
Why Choose This Calculator for Modine Manufacturing Company (MOD)?
- Accuracy: Utilizes real Modine financial data for precise calculations.
- Flexibility: Allows users to easily adjust and test various inputs.
- Time-Saving: Eliminates the need to construct a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Modine Manufacturing Company (MOD) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Modine Manufacturing Company (MOD).
- Consultants: Deliver professional valuation insights on Modine Manufacturing Company (MOD) to clients quickly and accurately.
- Business Owners: Understand how companies like Modine Manufacturing Company (MOD) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Modine Manufacturing Company (MOD).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Modine Manufacturing Company (MOD).
- Real-World Data: Modine's historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.