Algonquin Power & Utilities Corp. (AQN) 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
Algonquin Power & Utilities Corp. (AQN) Bundle
Simplify Algonquin Power & Utilities Corp. (AQN) valuation with this customizable DCF Calculator! Featuring real Algonquin Power & Utilities Corp. (AQN) financials and adjustable forecast inputs, you can test scenarios and uncover Algonquin Power & Utilities Corp. (AQN) fair value in just minutes.
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 | 1,127.8 | 1,164.0 | 1,586.2 | 1,919.1 | 1,872.5 | 2,144.3 | 2,455.5 | 2,811.8 | 3,219.8 | 3,687.1 |
| Revenue Growth, % | 0 | 3.21 | 36.28 | 20.99 | -2.43 | 14.51 | 14.51 | 14.51 | 14.51 | 14.51 |
| EBITDA | 514.6 | 513.5 | 519.2 | 242.9 | 495.5 | 693.0 | 793.6 | 908.7 | 1,040.6 | 1,191.6 |
| EBITDA, % | 45.63 | 44.11 | 32.73 | 12.66 | 26.46 | 32.32 | 32.32 | 32.32 | 32.32 | 32.32 |
| Depreciation | 201.9 | 229.5 | 277.2 | 303.6 | 324.1 | 378.4 | 433.3 | 496.2 | 568.2 | 650.6 |
| Depreciation, % | 17.9 | 19.72 | 17.48 | 15.82 | 17.31 | 17.65 | 17.65 | 17.65 | 17.65 | 17.65 |
| EBIT | 312.7 | 283.9 | 242.0 | -60.7 | 171.4 | 314.6 | 360.3 | 412.6 | 472.4 | 541.0 |
| EBIT, % | 27.72 | 24.39 | 15.26 | -3.16 | 9.15 | 14.67 | 14.67 | 14.67 | 14.67 | 14.67 |
| Total Cash | 43.4 | 70.5 | 86.9 | 40.0 | 39.0 | 83.8 | 96.0 | 109.9 | 125.9 | 144.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 179.9 | 225.5 | 280.0 | 366.5 | 363.8 | 392.4 | 449.3 | 514.5 | 589.2 | 674.7 |
| Account Receivables, % | 15.95 | 19.37 | 17.65 | 19.1 | 19.43 | 18.3 | 18.3 | 18.3 | 18.3 | 18.3 |
| Inventories | 63.2 | 93.4 | 123.4 | 156.1 | 157.6 | 162.8 | 186.4 | 213.5 | 244.5 | 280.0 |
| Inventories, % | 5.61 | 8.03 | 7.78 | 8.13 | 8.42 | 7.59 | 7.59 | 7.59 | 7.59 | 7.59 |
| Accounts Payable | 104.3 | 133.4 | 128.6 | 129.1 | 146.0 | 185.9 | 212.9 | 243.8 | 279.1 | 319.6 |
| Accounts Payable, % | 9.25 | 11.46 | 8.11 | 6.73 | 7.8 | 8.67 | 8.67 | 8.67 | 8.67 | 8.67 |
| Capital Expenditure | -403.5 | -545.5 | -933.5 | -755.8 | -712.2 | -938.8 | -1,075.1 | -1,231.1 | -1,409.7 | -1,614.3 |
| Capital Expenditure, % | -35.78 | -46.87 | -58.85 | -39.38 | -38.03 | -43.78 | -43.78 | -43.78 | -43.78 | -43.78 |
| Tax Rate, % | 123.97 | 123.97 | 123.97 | 123.97 | 123.97 | 123.97 | 123.97 | 123.97 | 123.97 | 123.97 |
| EBITAT | 299.0 | 280.4 | 315.9 | -50.6 | -41.1 | 237.7 | 272.2 | 311.7 | 356.9 | 408.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -41.3 | -82.4 | -429.6 | -621.5 | -411.1 | -316.7 | -423.2 | -484.6 | -554.9 | -635.5 |
| WACC, % | 5.17 | 5.26 | 5.3 | 4.81 | 2.38 | 4.58 | 4.58 | 4.58 | 4.58 | 4.58 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -2,085.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -648 | |||||||||
| Terminal Value | -25,083 | |||||||||
| Present Terminal Value | -20,047 | |||||||||
| Enterprise Value | -22,132 | |||||||||
| Net Debt | 5,872 | |||||||||
| Equity Value | -28,003 | |||||||||
| Diluted Shares Outstanding, MM | 691 | |||||||||
| Equity Value Per Share | -40.54 |
What You Will Get
- Real AQN 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 in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Algonquin's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Real-Life AQN Data: Pre-filled with Algonquin Power & Utilities Corp.'s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based AQN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Algonquin’s intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Algonquin Power & Utilities Corp. (AQN)?
- Accurate Data: Utilize real Algonquin financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations streamline the process, saving you from starting anew.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the utilities sector.
- User-Friendly: Designed with an intuitive interface and clear instructions for all users.
Who Should Use Algonquin Power & Utilities Corp. (AQN)?
- Investors: Make informed decisions with reliable insights into sustainable energy investments.
- Financial Analysts: Streamline your analysis with comprehensive data on utility performance and growth projections.
- Consultants: Efficiently tailor reports and presentations focusing on renewable energy trends and market strategies.
- Energy Enthusiasts: Enhance your knowledge of the utilities sector and its impact on the environment and economy.
- Educators and Students: Utilize it as a valuable resource for coursework related to energy management and finance.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations specific to Algonquin Power & Utilities Corp. (AQN).
- Real-World Data: Algonquin's historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.