The Manitowoc Company, Inc. (MTW) 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
The Manitowoc Company, Inc. (MTW) Bundle
Explore The Manitowoc Company, Inc.'s (MTW) financial outlook with our user-friendly DCF Calculator! Simply enter your projections for growth, margins, and expenses to calculate The Manitowoc Company, Inc.'s (MTW) intrinsic value and enhance your investment strategy.
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 | 1,834.1 | 1,443.4 | 1,720.2 | 2,032.5 | 2,227.8 | 2,370.6 | 2,522.5 | 2,684.2 | 2,856.3 | 3,039.4 |
Revenue Growth, % | 0 | -21.3 | 19.18 | 18.15 | 9.61 | 6.41 | 6.41 | 6.41 | 6.41 | 6.41 |
EBITDA | 143.3 | 81.5 | 94.4 | -23.5 | 139.2 | 114.0 | 121.3 | 129.1 | 137.3 | 146.1 |
EBITDA, % | 7.81 | 5.65 | 5.49 | -1.16 | 6.25 | 4.81 | 4.81 | 4.81 | 4.81 | 4.81 |
Depreciation | 35.3 | 37.5 | 46.9 | 63.7 | 59.8 | 62.0 | 65.9 | 70.2 | 74.6 | 79.4 |
Depreciation, % | 1.92 | 2.6 | 2.73 | 3.13 | 2.68 | 2.61 | 2.61 | 2.61 | 2.61 | 2.61 |
EBIT | 108.0 | 44.0 | 47.5 | -87.2 | 79.4 | 52.0 | 55.4 | 58.9 | 62.7 | 66.7 |
EBIT, % | 5.89 | 3.05 | 2.76 | -4.29 | 3.56 | 2.19 | 2.19 | 2.19 | 2.19 | 2.19 |
Total Cash | 199.3 | 128.7 | 75.4 | 64.4 | 34.4 | 136.9 | 145.7 | 155.0 | 165.0 | 175.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 185.7 | 228.7 | 252.8 | 276.9 | 285.5 | 318.2 | 338.5 | 360.2 | 383.3 | 407.9 |
Account Receivables, % | 10.12 | 15.84 | 14.7 | 13.62 | 12.82 | 13.42 | 13.42 | 13.42 | 13.42 | 13.42 |
Inventories | 461.4 | 473.1 | 576.8 | 611.9 | 666.5 | 718.2 | 764.3 | 813.3 | 865.4 | 920.9 |
Inventories, % | 25.16 | 32.78 | 33.53 | 30.11 | 29.92 | 30.3 | 30.3 | 30.3 | 30.3 | 30.3 |
Accounts Payable | 187.1 | 178.1 | 238.8 | 274.6 | 254.7 | 290.9 | 309.6 | 329.4 | 350.6 | 373.0 |
Accounts Payable, % | 10.2 | 12.34 | 13.88 | 13.51 | 11.43 | 12.27 | 12.27 | 12.27 | 12.27 | 12.27 |
Capital Expenditure | -35.1 | -26.3 | -40.4 | -61.8 | -77.4 | -59.7 | -63.6 | -67.6 | -72.0 | -76.6 |
Capital Expenditure, % | -1.91 | -1.82 | -2.35 | -3.04 | -3.47 | -2.52 | -2.52 | -2.52 | -2.52 | -2.52 |
Tax Rate, % | 11.31 | 11.31 | 11.31 | 11.31 | 11.31 | 11.31 | 11.31 | 11.31 | 11.31 | 11.31 |
EBITAT | 85.3 | 420.2 | 30.6 | -89.7 | 70.4 | 44.9 | 47.8 | 50.9 | 54.2 | 57.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -374.5 | 367.7 | -30.0 | -111.2 | -30.3 | -1.0 | 2.4 | 2.6 | 2.7 | 2.9 |
WACC, % | 9.43 | 10.44 | 8.73 | 10.44 | 9.9 | 9.79 | 9.79 | 9.79 | 9.79 | 9.79 |
PV UFCF | ||||||||||
SUM PV UFCF | 6.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 3 | |||||||||
Terminal Value | 38 | |||||||||
Present Terminal Value | 24 | |||||||||
Enterprise Value | 31 | |||||||||
Net Debt | 385 | |||||||||
Equity Value | -354 | |||||||||
Diluted Shares Outstanding, MM | 36 | |||||||||
Equity Value Per Share | -9.85 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios for The Manitowoc Company, Inc. (MTW).
- Real-World Data: The Manitowoc Company’s financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and capital expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Leverages Manitowoc’s actual financial data for credible valuation results.
- Effortless Scenario Analysis: Easily explore various assumptions and assess different outcomes.
- Efficiency Booster: Remove the complexity of developing intricate valuation models from the ground up.
How It Works
- 1. Download the Template: Obtain and open the Excel file featuring The Manitowoc Company, Inc. (MTW)'s preloaded data.
- 2. Adjust Key Assumptions: Modify essential inputs such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically calculates the intrinsic value and NPV in real-time.
- 4. Explore Different Scenarios: Evaluate various forecasts to assess different valuation results.
- 5. Present with Assurance: Share professional valuation insights to bolster your decision-making process.
Why Choose This Calculator for Manitowoc Company (MTW)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one solution.
- Customizable Inputs: Modify the yellow-highlighted cells to explore different scenarios.
- Detailed Insights: Automatically computes Manitowoc's intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points.
- Professional Quality: Perfect for financial analysts, investors, and business consultants.
Who Should Use This Product?
- Investors: Evaluate The Manitowoc Company’s (MTW) valuation prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of established companies like The Manitowoc Company.
- Consultants: Provide comprehensive valuation analyses and reports for clients.
- Students and Educators: Utilize current data to learn and teach valuation principles effectively.
What the Template Contains
- Pre-Filled Data: Includes The Manitowoc Company, Inc.'s (MTW) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze The Manitowoc Company, Inc.'s (MTW) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.