Avis Budget Group, Inc. (CAR) 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
Avis Budget Group, Inc. (CAR) Bundle
Evaluate Avis Budget Group, Inc.'s (CAR) financial outlook like an expert! This (CAR) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 9,172.0 | 5,402.0 | 9,313.0 | 11,994.0 | 12,008.0 | 13,815.2 | 15,894.4 | 18,286.5 | 21,038.7 | 24,205.0 |
Revenue Growth, % | 0 | -41.1 | 72.4 | 28.79 | 0.11673 | 15.05 | 15.05 | 15.05 | 15.05 | 15.05 |
EBITDA | 3,958.0 | 2,174.0 | 4,735.0 | 7,147.0 | 6,433.0 | 6,835.8 | 7,864.6 | 9,048.2 | 10,410.0 | 11,976.7 |
EBITDA, % | 43.15 | 40.24 | 50.84 | 59.59 | 53.57 | 49.48 | 49.48 | 49.48 | 49.48 | 49.48 |
Depreciation | 3,142.0 | 2,561.0 | 2,480.0 | 2,811.0 | 3,450.0 | 4,433.6 | 5,100.9 | 5,868.6 | 6,751.8 | 7,767.9 |
Depreciation, % | 34.26 | 47.41 | 26.63 | 23.44 | 28.73 | 32.09 | 32.09 | 32.09 | 32.09 | 32.09 |
EBIT | 816.0 | -387.0 | 2,255.0 | 4,336.0 | 2,983.0 | 2,402.2 | 2,763.7 | 3,179.6 | 3,658.2 | 4,208.7 |
EBIT, % | 8.9 | -7.16 | 24.21 | 36.15 | 24.84 | 17.39 | 17.39 | 17.39 | 17.39 | 17.39 |
Total Cash | 686.0 | 692.0 | 534.0 | 570.0 | 555.0 | 978.0 | 1,125.2 | 1,294.6 | 1,489.4 | 1,713.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,084.0 | 794.0 | 1,013.0 | 952.0 | 1,092.0 | 1,503.8 | 1,730.1 | 1,990.5 | 2,290.1 | 2,634.7 |
Account Receivables, % | 11.82 | 14.7 | 10.88 | 7.94 | 9.09 | 10.89 | 10.89 | 10.89 | 10.89 | 10.89 |
Inventories | 234.0 | 161.0 | 205.0 | 252.0 | .0 | 271.7 | 312.6 | 359.7 | 413.8 | 476.1 |
Inventories, % | 2.55 | 2.98 | 2.2 | 2.1 | 0 | 1.97 | 1.97 | 1.97 | 1.97 | 1.97 |
Accounts Payable | 378.0 | 394.0 | 407.0 | 466.0 | 487.0 | 655.6 | 754.2 | 867.7 | 998.3 | 1,148.6 |
Accounts Payable, % | 4.12 | 7.29 | 4.37 | 3.89 | 4.06 | 4.75 | 4.75 | 4.75 | 4.75 | 4.75 |
Capital Expenditure | -2,677.0 | 3,258.0 | -6,085.0 | -4,131.0 | -15,458.0 | -6,326.5 | -7,278.6 | -8,374.0 | -9,634.3 | -11,084.3 |
Capital Expenditure, % | -29.19 | 60.31 | -65.34 | -34.44 | -128.73 | -45.79 | -45.79 | -45.79 | -45.79 | -45.79 |
Tax Rate, % | 14.73 | 14.73 | 14.73 | 14.73 | 14.73 | 14.73 | 14.73 | 14.73 | 14.73 | 14.73 |
EBITAT | 858.6 | -276.9 | 1,696.5 | 3,296.1 | 2,543.5 | 1,960.5 | 2,255.5 | 2,595.0 | 2,985.6 | 3,434.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 383.6 | 5,921.1 | -2,158.5 | 2,049.1 | -9,331.5 | -447.3 | -90.7 | -104.4 | -120.1 | -138.2 |
WACC, % | 5.52 | 4.39 | 4.54 | 4.57 | 4.93 | 4.79 | 4.79 | 4.79 | 4.79 | 4.79 |
PV UFCF | ||||||||||
SUM PV UFCF | -809.2 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | -139 | |||||||||
Terminal Value | -3,237 | |||||||||
Present Terminal Value | -2,562 | |||||||||
Enterprise Value | -3,371 | |||||||||
Net Debt | 25,898 | |||||||||
Equity Value | -29,269 | |||||||||
Diluted Shares Outstanding, MM | 39 | |||||||||
Equity Value Per Share | -754.36 |
What You Will Get
- Real Avis Budget Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Avis Budget Group, Inc. (CAR).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Avis Budget Group’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specifically for Avis Budget Group, Inc. (CAR).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility in your financial assessments.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as fleet utilization rates, revenue per rental, and operating costs.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics with ease.
- High-Precision Accuracy: Leverages Avis Budget Group's real-world financial data for precise valuation results.
- Effortless Scenario Analysis: Explore various assumptions and evaluate outcomes without hassle.
- Efficiency Booster: Streamlines the valuation process, removing the need for complex model creation from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Avis Budget Group data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Avis Budget Group’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Avis Budget Group, Inc. (CAR)?
- Designed for Industry Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Financial Data: Avis Budget Group's historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions to evaluate different outcomes.
- Comprehensive Outputs: Instantly computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Detailed step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Investors: Accurately estimate Avis Budget Group’s fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Avis Budget Group (CAR).
- Consultants: Quickly customize the template for valuation reports tailored to Avis Budget Group (CAR) clients.
- Entrepreneurs: Gain insights into financial modeling practices employed by leading rental car companies.
- Educators: Use it as a teaching resource to illustrate valuation methodologies in the automotive rental industry.
What the Template Contains
- Pre-Filled Data: Includes Avis Budget Group’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 Avis Budget Group’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.