Amplify Energy Corp. (AMPY) 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
Amplify Energy Corp. (AMPY) Bundle
Explore Amplify Energy Corp.'s (AMPY) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Amplify Energy Corp. (AMPY) 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 | 275.6 | 202.1 | 342.9 | 458.5 | 307.6 | 341.3 | 378.6 | 420.1 | 466.0 | 517.0 |
Revenue Growth, % | 0 | -26.65 | 69.64 | 33.69 | -32.91 | 10.95 | 10.95 | 10.95 | 10.95 | 10.95 |
EBITDA | 43.0 | -444.4 | 14.9 | 104.1 | 197.4 | 4.7 | 5.2 | 5.8 | 6.4 | 7.1 |
EBITDA, % | 15.61 | -219.84 | 4.35 | 22.7 | 64.19 | 1.37 | 1.37 | 1.37 | 1.37 | 1.37 |
Depreciation | 61.4 | 46.5 | 34.7 | 31.0 | 36.0 | 50.4 | 55.9 | 62.0 | 68.8 | 76.4 |
Depreciation, % | 22.28 | 22.99 | 10.11 | 6.77 | 11.69 | 14.77 | 14.77 | 14.77 | 14.77 | 14.77 |
EBIT | -18.4 | -490.9 | -19.8 | 73.0 | 161.5 | -30.0 | -33.3 | -37.0 | -41.0 | -45.5 |
EBIT, % | -6.67 | -242.83 | -5.76 | 15.93 | 52.5 | -8.8 | -8.8 | -8.8 | -8.8 | -8.8 |
Total Cash | -16.2 | 10.4 | 18.8 | -12.6 | 20.7 | 5.9 | 6.6 | 7.3 | 8.1 | 9.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 33.1 | 30.9 | 92.0 | 80.5 | 39.1 | 57.6 | 63.9 | 70.9 | 78.7 | 87.3 |
Account Receivables, % | 12.03 | 15.29 | 26.82 | 17.55 | 12.71 | 16.88 | 16.88 | 16.88 | 16.88 | 16.88 |
Inventories | 22.4 | .0 | .0 | 12.6 | .0 | 7.4 | 8.2 | 9.2 | 10.2 | 11.3 |
Inventories, % | 8.14 | 0 | 0 | 2.75 | 0 | 2.18 | 2.18 | 2.18 | 2.18 | 2.18 |
Accounts Payable | 8.3 | .8 | 33.8 | 38.4 | 23.6 | 20.0 | 22.2 | 24.6 | 27.3 | 30.3 |
Accounts Payable, % | 3.02 | 0.39477 | 9.86 | 8.38 | 7.68 | 5.87 | 5.87 | 5.87 | 5.87 | 5.87 |
Capital Expenditure | -73.8 | -35.9 | -29.8 | -34.8 | -31.4 | -48.5 | -53.8 | -59.7 | -66.2 | -73.4 |
Capital Expenditure, % | -26.78 | -17.75 | -8.7 | -7.6 | -10.2 | -14.21 | -14.21 | -14.21 | -14.21 | -14.21 |
Tax Rate, % | -173.18 | -173.18 | -173.18 | -173.18 | -173.18 | -173.18 | -173.18 | -173.18 | -173.18 | -173.18 |
EBITAT | -18.4 | -491.0 | -27.2 | 72.9 | 441.2 | -30.0 | -33.3 | -36.9 | -41.0 | -45.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -78.0 | -463.2 | -50.4 | 72.6 | 484.9 | -57.6 | -36.1 | -40.0 | -44.4 | -49.3 |
WACC, % | 14 | 14.01 | 14.01 | 14 | 14.01 | 14 | 14 | 14 | 14 | 14 |
PV UFCF | ||||||||||
SUM PV UFCF | -157.3 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | -50 | |||||||||
Terminal Value | -367 | |||||||||
Present Terminal Value | -191 | |||||||||
Enterprise Value | -348 | |||||||||
Net Debt | 101 | |||||||||
Equity Value | -449 | |||||||||
Diluted Shares Outstanding, MM | 39 | |||||||||
Equity Value Per Share | -11.52 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Amplify Energy Corp.’s (AMPY) financial data pre-loaded to enhance your analysis.
- Automatic DCF Outputs: The template automatically computes Net Present Value (NPV) and intrinsic value.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and optimizing efficiency.
Key Features
- Pre-Loaded Data: Amplify Energy Corp.'s (AMPY) historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: View Amplify Energy Corp.'s (AMPY) intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts present valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Amplify Energy Corp. (AMPY) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Amplify Energy Corp.'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Amplify Energy Corp. (AMPY) Calculator?
- Accuracy: Utilizes real Amplify Energy financial data for precise calculations.
- Flexibility: Allows users to easily adjust and test various input parameters.
- Time-Saving: Eliminate the complexities of constructing a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and precision expected from industry leaders.
- User-Friendly: Intuitive design ensures accessibility for users of all financial backgrounds.
Who Should Use Amplify Energy Corp. (AMPY)?
- Professional Investors: Develop comprehensive and trustworthy valuation models for energy sector analysis.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Amplify Energy Corp. (AMPY).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insight into how companies like Amplify Energy Corp. (AMPY) are valued in the marketplace.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Amplify Energy Corp. (AMPY).
- Real-World Data: Amplify Energy's historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Graphs and tables providing clear, actionable results for decision-making.