|
Valoración de DCF Sunrun Inc. (Run)
US | Energy | Solar | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Sunrun Inc. (RUN) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF Sunrun Inc. (Run)! Utilice datos financieros reales de SunRun, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de Sunrun Inc. (Run).
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 | 858.6 | 922.2 | 1,610.0 | 2,321.4 | 2,259.8 | 2,957.7 | 3,871.1 | 5,066.5 | 6,631.1 | 8,678.9 |
Revenue Growth, % | 0 | 7.41 | 74.58 | 44.19 | -2.65 | 30.88 | 30.88 | 30.88 | 30.88 | 30.88 |
EBITDA | -26.0 | -214.0 | -268.7 | 60.2 | -1,457.6 | -620.1 | -811.6 | -1,062.3 | -1,390.3 | -1,819.7 |
EBITDA, % | -3.03 | -23.2 | -16.69 | 2.59 | -64.5 | -20.97 | -20.97 | -20.97 | -20.97 | -20.97 |
Depreciation | 199.0 | 257.3 | 396.4 | 459.3 | 531.7 | 704.0 | 921.4 | 1,206.0 | 1,578.4 | 2,065.8 |
Depreciation, % | 23.17 | 27.91 | 24.62 | 19.79 | 23.53 | 23.8 | 23.8 | 23.8 | 23.8 | 23.8 |
EBIT | -225.0 | -471.3 | -665.1 | -399.1 | -1,989.3 | -1,324.1 | -1,733.0 | -2,268.2 | -2,968.7 | -3,885.5 |
EBIT, % | -26.21 | -51.11 | -41.31 | -17.19 | -88.03 | -44.77 | -44.77 | -44.77 | -44.77 | -44.77 |
Total Cash | 269.6 | 520.0 | 617.6 | 740.5 | 678.8 | 1,112.6 | 1,456.2 | 1,905.8 | 2,494.4 | 3,264.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 76.7 | 95.1 | 146.0 | 214.3 | 172.0 | 267.2 | 349.7 | 457.7 | 599.0 | 784.0 |
Account Receivables, % | 8.94 | 10.32 | 9.07 | 9.23 | 7.61 | 9.03 | 9.03 | 9.03 | 9.03 | 9.03 |
Inventories | 260.6 | 283.0 | 506.8 | 783.9 | 459.7 | 867.4 | 1,135.3 | 1,485.9 | 1,944.7 | 2,545.3 |
Inventories, % | 30.35 | 30.69 | 31.48 | 33.77 | 20.34 | 29.33 | 29.33 | 29.33 | 29.33 | 29.33 |
Accounts Payable | 223.4 | 207.4 | 288.1 | 339.2 | 230.7 | 539.6 | 706.3 | 924.4 | 1,209.8 | 1,583.5 |
Accounts Payable, % | 26.01 | 22.49 | 17.9 | 14.61 | 10.21 | 18.24 | 18.24 | 18.24 | 18.24 | 18.24 |
Capital Expenditure | -840.5 | -969.7 | -1,686.2 | -2,011.1 | -2,608.1 | -2,866.2 | -3,751.3 | -4,909.7 | -6,425.9 | -8,410.4 |
Capital Expenditure, % | -97.9 | -105.15 | -104.73 | -86.63 | -115.41 | -96.91 | -96.91 | -96.91 | -96.91 | -96.91 |
Tax Rate, % | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 |
EBITAT | -220.4 | -429.8 | -671.4 | -400.2 | -1,184.1 | -1,188.2 | -1,555.1 | -2,035.3 | -2,663.9 | -3,486.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -975.9 | -1,198.9 | -2,155.2 | -2,246.2 | -3,002.6 | -3,544.2 | -4,568.7 | -5,979.5 | -7,826.1 | -10,242.9 |
WACC, % | 7.54 | 7.21 | 7.65 | 7.65 | 5.65 | 7.14 | 7.14 | 7.14 | 7.14 | 7.14 |
PV UFCF | ||||||||||
SUM PV UFCF | -25,346.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -10,448 | |||||||||
Terminal Value | -203,321 | |||||||||
Present Terminal Value | -144,030 | |||||||||
Enterprise Value | -169,376 | |||||||||
Net Debt | 10,408 | |||||||||
Equity Value | -179,784 | |||||||||
Diluted Shares Outstanding, MM | 217 | |||||||||
Equity Value Per Share | -829.87 |
What You Will Get
- Editable Forecast Inputs: Easily adjust assumptions (growth %, margins, WACC) to generate various scenarios.
- Real-World Data: Sunrun Inc.’s (RUN) financial data pre-filled 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 tailors to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive RUN Data: Pre-filled with Sunrun’s historical performance metrics and future projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, discount rates, tax assumptions, and capital expenditures.
- Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your custom inputs.
- Scenario Testing: Develop various forecasting scenarios to evaluate different valuation possibilities.
- User-Friendly Interface: Intuitive, organized, and suitable for both professionals and novices.
How It Works
- Download the Template: Gain immediate access to the Excel-based RUN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Sunrun 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 strategies.
Why Choose This Calculator for Sunrun Inc. (RUN)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for renewable energy investments.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios for Sunrun.
- In-Depth Analysis: Automatically computes Sunrun’s intrinsic value and Net Present Value for informed decision-making.
- Data-Rich Environment: Comes with historical and projected data to provide reliable starting points for analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and energy sector consultants focusing on Sunrun Inc. (RUN).
Who Should Use This Product?
- Renewable Energy Students: Explore solar energy systems and apply concepts using real-world data.
- Researchers: Integrate industry models into studies or academic projects related to solar energy.
- Investors: Evaluate your investment strategies and assess valuation scenarios for Sunrun Inc. (RUN).
- Financial Analysts: Enhance your analysis with a customizable financial model tailored for solar companies.
- Homeowners: Understand how major solar providers like Sunrun Inc. (RUN) are evaluated in the market.
What the Template Contains
- Historical Data: Includes Sunrun Inc.’s (RUN) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Sunrun Inc.’s (RUN) 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 Sunrun Inc.’s (RUN) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.