AAR Corp. (AIR) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
AAR Corp. (AIR) Bundle
Evaluate AAR Corp.'s financial outlook like an expert! This (AIR) DCF Calculator comes with pre-filled financial data and allows you to easily modify revenue growth, WACC, margins, and other crucial assumptions to align with your predictions.
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 | 2,072.0 | 1,652.3 | 1,820.0 | 1,990.5 | 2,318.9 | 2,410.3 | 2,505.2 | 2,603.9 | 2,706.5 | 2,813.2 |
Revenue Growth, % | 0 | -20.26 | 10.15 | 9.37 | 16.5 | 3.94 | 3.94 | 3.94 | 3.94 | 3.94 |
EBITDA | 87.4 | 73.1 | 144.2 | 161.3 | 142.7 | 148.6 | 154.4 | 160.5 | 166.8 | 173.4 |
EBITDA, % | 4.22 | 4.42 | 7.92 | 8.1 | 6.15 | 6.16 | 6.16 | 6.16 | 6.16 | 6.16 |
Depreciation | 43.7 | 36.3 | 33.1 | 27.9 | 41.2 | 44.8 | 46.6 | 48.4 | 50.4 | 52.3 |
Depreciation, % | 2.11 | 2.2 | 1.82 | 1.4 | 1.78 | 1.86 | 1.86 | 1.86 | 1.86 | 1.86 |
EBIT | 43.7 | 36.8 | 111.1 | 133.4 | 101.5 | 103.7 | 107.8 | 112.1 | 116.5 | 121.1 |
EBIT, % | 2.11 | 2.23 | 6.1 | 6.7 | 4.38 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 |
Total Cash | 404.7 | 51.8 | 53.5 | 68.4 | 85.8 | 157.8 | 164.1 | 170.5 | 177.2 | 184.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 221.2 | 238.6 | 287.6 | 328.2 | 410.4 | 362.0 | 376.3 | 391.1 | 406.5 | 422.6 |
Account Receivables, % | 10.68 | 14.44 | 15.8 | 16.49 | 17.7 | 15.02 | 15.02 | 15.02 | 15.02 | 15.02 |
Inventories | 623.1 | 540.6 | 550.5 | 574.1 | 733.1 | 739.9 | 769.1 | 799.4 | 830.9 | 863.6 |
Inventories, % | 30.07 | 32.72 | 30.25 | 28.84 | 31.61 | 30.7 | 30.7 | 30.7 | 30.7 | 30.7 |
Accounts Payable | 191.6 | 127.2 | 156.4 | 158.5 | 238.0 | 211.0 | 219.3 | 227.9 | 236.9 | 246.2 |
Accounts Payable, % | 9.25 | 7.7 | 8.59 | 7.96 | 10.26 | 8.75 | 8.75 | 8.75 | 8.75 | 8.75 |
Capital Expenditure | -23.6 | -11.3 | -17.3 | -29.5 | -29.7 | -26.7 | -27.7 | -28.8 | -30.0 | -31.1 |
Capital Expenditure, % | -1.14 | -0.6839 | -0.95055 | -1.48 | -1.28 | -1.11 | -1.11 | -1.11 | -1.11 | -1.11 |
Tax Rate, % | 20.58 | 20.58 | 20.58 | 20.58 | 20.58 | 20.58 | 20.58 | 20.58 | 20.58 | 20.58 |
EBITAT | 35.7 | 20.4 | 83.2 | 99.3 | 80.6 | 75.9 | 78.9 | 82.0 | 85.2 | 88.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -597.0 | 46.1 | 69.3 | 35.6 | -69.6 | 108.6 | 62.7 | 65.1 | 67.7 | 70.4 |
WACC, % | 9.1 | 8.71 | 9 | 8.99 | 9.06 | 8.97 | 8.97 | 8.97 | 8.97 | 8.97 |
PV UFCF | ||||||||||
SUM PV UFCF | 296.5 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 72 | |||||||||
Terminal Value | 1,213 | |||||||||
Present Terminal Value | 790 | |||||||||
Enterprise Value | 1,086 | |||||||||
Net Debt | 980 | |||||||||
Equity Value | 106 | |||||||||
Diluted Shares Outstanding, MM | 35 | |||||||||
Equity Value Per Share | 3.00 |
What You Will Get
- Real AAR Corp. Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for AAR Corp. (AIR).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to AAR Corp. (AIR).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on AAR Corp.'s (AIR) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for AAR Corp. (AIR).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for AAR Corp. (AIR).
Key Features
- 🔍 Real-Life AAR Financials: Pre-filled historical and projected data for AAR Corp. (AIR).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate AAR’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize AAR’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-built Excel file featuring AAR Corp.'s (AIR) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly evaluate different outcomes.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for AAR Corp. (AIR)?
- User-Friendly Interface: Tailored for both novice and experienced users.
- Customizable Inputs: Adjust parameters to suit your financial analysis needs.
- Real-Time Valuation: Monitor immediate updates to AAR Corp.’s valuation as you change inputs.
- Preloaded Data: Comes equipped with AAR Corp.'s actual financial metrics for swift evaluations.
- Widely Endorsed: Favored by industry professionals for informed investment decisions.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling AAR Corp. (AIR) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for AAR Corp. (AIR).
- Consultants: Deliver professional valuation insights on AAR Corp. (AIR) to clients quickly and accurately.
- Business Owners: Understand how companies like AAR Corp. (AIR) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to AAR Corp. (AIR).
What the Template Contains
- Pre-Filled Data: Includes AAR Corp.'s 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 AAR Corp.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.