Sonic Automotive, Inc. (SAH) 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
Sonic Automotive, Inc. (SAH) Bundle
Explore Sonic Automotive, Inc.'s (SAH) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine Sonic Automotive, Inc.'s (SAH) intrinsic value and enhance your investment approach.
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 | 10,454.3 | 9,767.0 | 12,396.4 | 14,001.1 | 14,372.4 | 15,663.9 | 17,071.4 | 18,605.4 | 20,277.3 | 22,099.3 |
| Revenue Growth, % | 0 | -6.57 | 26.92 | 12.94 | 2.65 | 8.99 | 8.99 | 8.99 | 8.99 | 8.99 |
| EBITDA | 397.2 | 125.4 | 622.5 | 441.0 | 558.6 | 537.0 | 585.2 | 637.8 | 695.1 | 757.6 |
| EBITDA, % | 3.8 | 1.28 | 5.02 | 3.15 | 3.89 | 3.43 | 3.43 | 3.43 | 3.43 | 3.43 |
| Depreciation | 93.2 | 91.0 | 101.1 | 127.5 | 142.3 | 142.2 | 155.0 | 168.9 | 184.1 | 200.6 |
| Depreciation, % | 0.89125 | 0.93194 | 0.81556 | 0.91064 | 0.99009 | 0.9079 | 0.9079 | 0.9079 | 0.9079 | 0.9079 |
| EBIT | 304.0 | 34.4 | 521.4 | 313.5 | 416.3 | 394.8 | 430.2 | 468.9 | 511.0 | 557.0 |
| EBIT, % | 2.91 | 0.35195 | 4.21 | 2.24 | 2.9 | 2.52 | 2.52 | 2.52 | 2.52 | 2.52 |
| Total Cash | 29.1 | 170.3 | 299.4 | 229.2 | 28.9 | 196.6 | 214.3 | 233.5 | 254.5 | 277.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 432.7 | 371.7 | 401.1 | 462.4 | 528.1 | 568.8 | 619.9 | 675.6 | 736.4 | 802.5 |
| Account Receivables, % | 4.14 | 3.81 | 3.24 | 3.3 | 3.67 | 3.63 | 3.63 | 3.63 | 3.63 | 3.63 |
| Inventories | 1,517.9 | 1,247.3 | 1,261.2 | 1,216.8 | 1,578.3 | 1,789.9 | 1,950.8 | 2,126.0 | 2,317.1 | 2,525.3 |
| Inventories, % | 14.52 | 12.77 | 10.17 | 8.69 | 10.98 | 11.43 | 11.43 | 11.43 | 11.43 | 11.43 |
| Accounts Payable | 135.2 | 105.1 | 133.3 | 138.4 | 149.8 | 171.5 | 187.0 | 203.7 | 222.1 | 242.0 |
| Accounts Payable, % | 1.29 | 1.08 | 1.08 | 0.98849 | 1.04 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
| Capital Expenditure | -125.6 | -127.2 | -298.2 | -227.1 | -203.6 | -249.0 | -271.4 | -295.7 | -322.3 | -351.3 |
| Capital Expenditure, % | -1.2 | -1.3 | -2.41 | -1.62 | -1.42 | -1.59 | -1.59 | -1.59 | -1.59 | -1.59 |
| Tax Rate, % | 26.33 | 26.33 | 26.33 | 26.33 | 26.33 | 26.33 | 26.33 | 26.33 | 26.33 | 26.33 |
| EBITAT | 219.5 | 50.1 | 397.0 | 146.0 | 306.7 | 291.0 | 317.2 | 345.7 | 376.7 | 410.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,628.3 | 315.5 | 184.7 | 34.6 | -170.4 | -46.4 | 4.3 | 4.7 | 5.1 | 5.5 |
| WACC, % | 6.61 | 7.43 | 6.73 | 5.86 | 6.65 | 6.66 | 6.66 | 6.66 | 6.66 | 6.66 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -27.9 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 6 | |||||||||
| Terminal Value | 156 | |||||||||
| Present Terminal Value | 113 | |||||||||
| Enterprise Value | 85 | |||||||||
| Net Debt | 3,834 | |||||||||
| Equity Value | -3,749 | |||||||||
| Diluted Shares Outstanding, MM | 36 | |||||||||
| Equity Value Per Share | -104.44 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore different scenarios.
- Real-World Data: Sonic Automotive, Inc. (SAH)’s financial data pre-loaded 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 assessing projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Access reliable pre-loaded historical figures and future forecasts for Sonic Automotive, Inc. (SAH).
- Adjustable Forecast Parameters: Customize highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help you visualize valuation outcomes effectively.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based SAH DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Sonic Automotive’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Sonic Automotive, Inc. (SAH)?
- Designed for Industry Experts: A sophisticated tool utilized by automotive analysts, CFOs, and financial consultants.
- Accurate Financial Data: Sonic Automotive's historical and projected financials preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance to navigate through the calculation process.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Sonic Automotive stock (SAH).
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Sonic Automotive (SAH).
- Consultants: Deliver professional valuation insights on Sonic Automotive (SAH) to clients quickly and accurately.
- Business Owners: Understand how automotive companies like Sonic Automotive (SAH) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Sonic Automotive (SAH).
What the Template Contains
- Historical Data: Includes Sonic Automotive’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Sonic Automotive’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 Sonic Automotive’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.