Axos Financial, Inc. (AX) DCF Valuation

Axos Financial, Inc. (AX) 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

Axos Financial, Inc. (AX) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 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

  1. Step 1: Download the Excel file.
  2. Step 2: Review Axos Financial's pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust assumptions.
  5. 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.