Axos Financial, Inc. (AX) DCF Valuation
- ✓ 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
Axos Financial, Inc. (AX) Bundle
Whether you’re an investor or analyst, this (AX) DCF Calculator is your go-to tool for accurate valuation. Loaded with real data from Axos Financial, Inc., you can adjust forecasts and observe the effects in real time.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 572.4 | 632.9 | 705.3 | 890.2 | 1,059.2 | 1,237.2 | 1,445.0 | 1,687.8 | 1,971.4 | 2,302.7 |
Revenue Growth, % | 0 | 10.56 | 11.45 | 26.21 | 18.99 | 16.8 | 16.8 | 16.8 | 16.8 | 16.8 |
EBITDA | 297.6 | 340.5 | 375.5 | 455.1 | 662.6 | 674.8 | 788.1 | 920.6 | 1,075.2 | 1,255.9 |
EBITDA, % | 52 | 53.8 | 53.23 | 51.13 | 62.55 | 54.54 | 54.54 | 54.54 | 54.54 | 54.54 |
Depreciation | 35.0 | 34.7 | 35.5 | 23.4 | 27.1 | 54.0 | 63.0 | 73.6 | 86.0 | 100.5 |
Depreciation, % | 6.11 | 5.49 | 5.03 | 2.63 | 2.56 | 4.36 | 4.36 | 4.36 | 4.36 | 4.36 |
EBIT | 262.6 | 305.7 | 340.0 | 431.7 | 635.5 | 620.8 | 725.1 | 846.9 | 989.2 | 1,155.4 |
EBIT, % | 45.88 | 48.31 | 48.2 | 48.5 | 60 | 50.18 | 50.18 | 50.18 | 50.18 | 50.18 |
Total Cash | 1,944.1 | 903.0 | 1,465.1 | 2,465.4 | 2,121.6 | 1,237.2 | 1,445.0 | 1,687.8 | 1,971.4 | 2,302.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | -2,399.7 | -2,035.4 | -2,388.1 | -2,899.4 | .0 | -989.7 | -1,156.0 | -1,350.3 | -1,577.1 | -1,842.1 |
Inventories, % | -419.24 | -321.63 | -338.57 | -325.71 | 0 | -80 | -80 | -80 | -80 | -80 |
Accounts Payable | 347.6 | 535.4 | 511.7 | 445.5 | 301.1 | 733.3 | 856.5 | 1,000.4 | 1,168.5 | 1,364.8 |
Accounts Payable, % | 60.73 | 84.61 | 72.54 | 50.04 | 28.43 | 59.27 | 59.27 | 59.27 | 59.27 | 59.27 |
Capital Expenditure | -12.3 | -10.4 | -21.5 | -30.2 | -36.0 | -33.8 | -39.4 | -46.1 | -53.8 | -62.8 |
Capital Expenditure, % | -2.15 | -1.65 | -3.05 | -3.39 | -3.4 | -2.73 | -2.73 | -2.73 | -2.73 | -2.73 |
Tax Rate, % | 29.19 | 29.19 | 29.19 | 29.19 | 29.19 | 29.19 | 29.19 | 29.19 | 29.19 | 29.19 |
EBITAT | 183.4 | 215.7 | 240.7 | 307.2 | 450.0 | 438.5 | 512.2 | 598.2 | 698.7 | 816.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2,953.4 | 63.6 | 583.6 | 745.4 | -2,602.6 | 1,880.6 | 825.3 | 963.9 | 1,125.9 | 1,315.1 |
WACC, % | 20.54 | 20.65 | 20.68 | 20.73 | 20.68 | 20.66 | 20.66 | 20.66 | 20.66 | 20.66 |
PV UFCF | ||||||||||
SUM PV UFCF | 3,719.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,341 | |||||||||
Terminal Value | 7,190 | |||||||||
Present Terminal Value | 2,812 | |||||||||
Enterprise Value | 6,531 | |||||||||
Net Debt | -1,564 | |||||||||
Equity Value | 8,096 | |||||||||
Diluted Shares Outstanding, MM | 59 | |||||||||
Equity Value Per Share | 137.85 |
What You Will Get
- Real Axos Financial Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Axos Financial, Inc. (AX).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Axos Financial.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Axos Financial, Inc.'s (AX) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections relevant to Axos Financial, Inc. (AX).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Axos Financial, Inc. (AX).
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Axos Financial, Inc. (AX).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates specific to Axos Financial.
- Integrated Financial Ratios: Assess profitability, leverage, and efficiency ratios for Axos Financial, Inc. (AX).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Axos Financial's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Analyze the outputs and utilize the results for your investment decisions.
Why Choose This Calculator for Axos Financial, Inc. (AX)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Monitor immediate changes to Axos Financial’s valuation with each input modification.
- Preconfigured Data: Comes with Axos Financial’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing portfolios related to Axos Financial, Inc. (AX).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Offer clients precise valuation insights for Axos Financial, Inc. (AX) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Finance Enthusiasts: Gain insights into how financial institutions like Axos Financial, Inc. (AX) are valued in the marketplace.
What the Template Contains
- Preloaded AX Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.