Textron Inc. (TXT) 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
Textron Inc. (TXT) Bundle
Looking to determine the intrinsic value of Textron Inc.? Our TXT DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts and enhance your investment choices.
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 | 13,630.0 | 11,651.0 | 12,382.0 | 12,869.0 | 13,683.0 | 13,751.9 | 13,821.1 | 13,890.6 | 13,960.5 | 14,030.8 |
| Revenue Growth, % | 0 | -14.52 | 6.27 | 3.93 | 6.33 | 0.50328 | 0.50328 | 0.50328 | 0.50328 | 0.50328 |
| EBITDA | 1,518.0 | 827.0 | 1,391.0 | 1,515.0 | 1,556.0 | 1,447.1 | 1,454.4 | 1,461.7 | 1,469.0 | 1,476.4 |
| EBITDA, % | 11.14 | 7.1 | 11.23 | 11.77 | 11.37 | 10.52 | 10.52 | 10.52 | 10.52 | 10.52 |
| Depreciation | 405.0 | 379.0 | 376.0 | 392.0 | 395.0 | 417.9 | 420.0 | 422.1 | 424.2 | 426.4 |
| Depreciation, % | 2.97 | 3.25 | 3.04 | 3.05 | 2.89 | 3.04 | 3.04 | 3.04 | 3.04 | 3.04 |
| EBIT | 1,113.0 | 448.0 | 1,015.0 | 1,123.0 | 1,161.0 | 1,029.2 | 1,034.4 | 1,039.6 | 1,044.8 | 1,050.1 |
| EBIT, % | 8.17 | 3.85 | 8.2 | 8.73 | 8.48 | 7.48 | 7.48 | 7.48 | 7.48 | 7.48 |
| Total Cash | 1,181.0 | 2,146.0 | 1,922.0 | 1,963.0 | 2,181.0 | 2,029.8 | 2,040.0 | 2,050.2 | 2,060.6 | 2,070.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 921.0 | 787.0 | 838.0 | 855.0 | 1,381.0 | 1,018.1 | 1,023.2 | 1,028.4 | 1,033.5 | 1,038.7 |
| Account Receivables, % | 6.76 | 6.75 | 6.77 | 6.64 | 10.09 | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 |
| Inventories | 4,069.0 | 3,513.0 | 3,468.0 | 3,550.0 | 3,914.0 | 3,966.1 | 3,986.1 | 4,006.2 | 4,026.3 | 4,046.6 |
| Inventories, % | 29.85 | 30.15 | 28.01 | 27.59 | 28.6 | 28.84 | 28.84 | 28.84 | 28.84 | 28.84 |
| Accounts Payable | 1,378.0 | 776.0 | 786.0 | 1,018.0 | 1,023.0 | 1,059.0 | 1,064.4 | 1,069.7 | 1,075.1 | 1,080.5 |
| Accounts Payable, % | 10.11 | 6.66 | 6.35 | 7.91 | 7.48 | 7.7 | 7.7 | 7.7 | 7.7 | 7.7 |
| Capital Expenditure | -339.0 | -317.0 | -375.0 | -354.0 | -402.0 | -383.0 | -384.9 | -386.9 | -388.8 | -390.8 |
| Capital Expenditure, % | -2.49 | -2.72 | -3.03 | -2.75 | -2.94 | -2.79 | -2.79 | -2.79 | -2.79 | -2.79 |
| Tax Rate, % | 15.27 | 15.27 | 15.27 | 15.27 | 15.27 | 15.27 | 15.27 | 15.27 | 15.27 | 15.27 |
| EBITAT | 962.9 | 490.9 | 867.3 | 951.7 | 983.7 | 908.7 | 913.2 | 917.8 | 922.4 | 927.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -2,583.1 | 640.9 | 872.3 | 1,122.7 | 91.7 | 1,290.3 | 928.5 | 933.2 | 937.9 | 942.6 |
| WACC, % | 9.03 | 9.15 | 9.02 | 9.02 | 9.02 | 9.05 | 9.05 | 9.05 | 9.05 | 9.05 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,958.3 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 971 | |||||||||
| Terminal Value | 16,052 | |||||||||
| Present Terminal Value | 10,409 | |||||||||
| Enterprise Value | 14,368 | |||||||||
| Net Debt | 1,693 | |||||||||
| Equity Value | 12,675 | |||||||||
| Diluted Shares Outstanding, MM | 202 | |||||||||
| Equity Value Per Share | 62.82 |
What You Will Get
- Real TXT Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate multiple scenarios to assess Textron’s future performance.
- User-Friendly Interface: Designed for professionals while remaining accessible to newcomers.
Key Features
- Comprehensive Textron Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells for WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Suitable for All Skill Levels: An easy-to-navigate structure designed for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based TXT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Textron Inc.'s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial strategy.
Why Choose This Calculator for Textron Inc. (TXT)?
- Accurate Data: Utilizes real Textron financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the field.
- User-Friendly: Easy-to-navigate design and clear instructions simplify the process for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing Textron Inc. (TXT) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic planning within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Textron Inc. (TXT) stock.
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Aerospace and Defense Enthusiasts: Gain insights into how companies like Textron Inc. (TXT) are valued in the aerospace and defense sector.
What the Template Contains
- Preloaded TXT Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.