Carrier Global Corporation (CARR) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Carrier Global Corporation (CARR) Bundle
Evaluate Carrier Global Corporation's financial prospects like an expert! This (CARR) DCF Calculator provides you with pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 18,608.0 | 17,456.0 | 20,613.0 | 20,421.0 | 22,098.0 | 23,157.3 | 24,267.5 | 25,430.8 | 26,649.9 | 27,927.4 |
| Revenue Growth, % | 0 | -6.19 | 18.09 | -0.93145 | 8.21 | 4.79 | 4.79 | 4.79 | 4.79 | 4.79 |
| EBITDA | 2,978.0 | 2,411.0 | 2,906.0 | 2,901.0 | 2,988.0 | 3,318.0 | 3,477.1 | 3,643.8 | 3,818.5 | 4,001.5 |
| EBITDA, % | 16 | 13.81 | 14.1 | 14.21 | 13.52 | 14.33 | 14.33 | 14.33 | 14.33 | 14.33 |
| Depreciation | 335.0 | 336.0 | 338.0 | 380.0 | 542.0 | 448.3 | 469.7 | 492.3 | 515.9 | 540.6 |
| Depreciation, % | 1.8 | 1.92 | 1.64 | 1.86 | 2.45 | 1.94 | 1.94 | 1.94 | 1.94 | 1.94 |
| EBIT | 2,643.0 | 2,075.0 | 2,568.0 | 2,521.0 | 2,446.0 | 2,869.8 | 3,007.4 | 3,151.5 | 3,302.6 | 3,460.9 |
| EBIT, % | 14.2 | 11.89 | 12.46 | 12.35 | 11.07 | 12.39 | 12.39 | 12.39 | 12.39 | 12.39 |
| Total Cash | 952.0 | 3,115.0 | 2,987.0 | 3,520.0 | 10,015.0 | 4,631.9 | 4,854.0 | 5,086.7 | 5,330.5 | 5,586.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3,164.0 | 3,437.0 | 2,906.0 | 3,370.0 | 2,787.0 | 3,700.8 | 3,878.2 | 4,064.1 | 4,258.9 | 4,463.1 |
| Account Receivables, % | 17 | 19.69 | 14.1 | 16.5 | 12.61 | 15.98 | 15.98 | 15.98 | 15.98 | 15.98 |
| Inventories | 1,332.0 | 1,629.0 | 1,970.0 | 2,640.0 | 2,217.0 | 2,269.8 | 2,378.6 | 2,492.6 | 2,612.1 | 2,737.3 |
| Inventories, % | 7.16 | 9.33 | 9.56 | 12.93 | 10.03 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 |
| Accounts Payable | 1,701.0 | 1,936.0 | 2,334.0 | 2,833.0 | 2,742.0 | 2,678.7 | 2,807.1 | 2,941.6 | 3,082.7 | 3,230.4 |
| Accounts Payable, % | 9.14 | 11.09 | 11.32 | 13.87 | 12.41 | 11.57 | 11.57 | 11.57 | 11.57 | 11.57 |
| Capital Expenditure | -243.0 | -312.0 | -344.0 | -353.0 | -469.0 | -398.9 | -418.0 | -438.1 | -459.1 | -481.1 |
| Capital Expenditure, % | -1.31 | -1.79 | -1.67 | -1.73 | -2.12 | -1.72 | -1.72 | -1.72 | -1.72 | -1.72 |
| Tax Rate, % | 35.27 | 35.27 | 35.27 | 35.27 | 35.27 | 35.27 | 35.27 | 35.27 | 35.27 | 35.27 |
| EBITAT | 2,093.0 | 1,440.5 | 1,780.5 | 2,075.8 | 1,583.3 | 2,095.0 | 2,195.5 | 2,300.7 | 2,411.0 | 2,526.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -610.0 | 1,129.5 | 2,362.5 | 1,467.8 | 2,571.3 | 1,114.5 | 2,089.4 | 2,189.5 | 2,294.5 | 2,404.5 |
| WACC, % | 8.84 | 8.76 | 8.75 | 8.87 | 8.71 | 8.79 | 8.79 | 8.79 | 8.79 | 8.79 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 7,707.0 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 2,489 | |||||||||
| Terminal Value | 47,072 | |||||||||
| Present Terminal Value | 30,894 | |||||||||
| Enterprise Value | 38,601 | |||||||||
| Net Debt | 4,669 | |||||||||
| Equity Value | 33,932 | |||||||||
| Diluted Shares Outstanding, MM | 853 | |||||||||
| Equity Value Per Share | 39.78 |
What You Will Get
- Real Carrier Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Carrier’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- 🔍 Real-Life CARR Financials: Pre-filled historical and projected data for Carrier Global Corporation (CARR).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Carrier's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Carrier'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 CARR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Carrier Global Corporation’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation variations.
- Analyze and Decide: Utilize the findings to inform your investment or financial analysis.
Why Choose This Calculator for Carrier Global Corporation (CARR)?
- Accuracy: Utilizes real Carrier financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling knowledge.
Who Should Use Carrier Global Corporation (CARR) Products?
- Investors: Make informed investment choices with industry-leading HVAC solutions.
- Facility Managers: Enhance operational efficiency with advanced building management systems.
- Contractors: Easily integrate Carrier products into your projects for optimal performance.
- Homeowners: Improve comfort and energy efficiency with smart heating and cooling systems.
- Students and Educators: Utilize Carrier's resources to explore innovative technologies in HVAC education.
What the Template Contains
- Historical Data: Includes Carrier Global Corporation’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Carrier Global Corporation’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Carrier Global Corporation’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.