American Realty Investors, Inc. (ARL) DCF Valuation

American Realty Investors, Inc. (ARL) 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

American Realty Investors, Inc. (ARL) 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:

Save time and improve accuracy with our (ARL) DCF Calculator! With real data from American Realty Investors, Inc. and customizable assumptions, this tool empowers you to forecast, analyze, and value (ARL) just like a seasoned investor.


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 48.0 59.0 42.0 37.5 50.5 57.1 64.6 73.0 82.6 93.4
Revenue Growth, % 0 23.05 -28.78 -10.69 34.51 13.07 13.07 13.07 13.07 13.07
EBITDA 33.7 37.4 29.3 604.1 2.4 35.2 39.8 45.0 50.9 57.5
EBITDA, % 70.26 63.3 69.71 1608.95 4.76 61.61 61.61 61.61 61.61 61.61
Depreciation 59.4 59.1 62.7 46.8 13.6 48.8 55.1 62.4 70.5 79.7
Depreciation, % 123.78 100.19 149.04 124.68 27.02 85.4 85.4 85.4 85.4 85.4
EBIT -25.7 -21.8 -33.4 557.3 -11.2 -10.5 -11.9 -13.4 -15.2 -17.2
EBIT, % -53.52 -36.89 -79.33 1484.27 -22.26 -18.4 -18.4 -18.4 -18.4 -18.4
Total Cash 51.2 36.8 66.7 233.2 127.2 52.8 59.7 67.5 76.3 86.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 242.2 260.0 237.2 247.8 .0
Account Receivables, % 504.89 440.42 564.25 660.01 0
Inventories 344.5 397.2 347.9 703.5 .0 45.7 51.7 58.4 66.0 74.7
Inventories, % 718.11 672.9 827.63 1873.68 0 80 80 80 80 80
Accounts Payable 29.0 27.3 44.5 53.1 11.9 37.7 42.6 48.2 54.5 61.7
Accounts Payable, % 60.48 46.25 105.9 141.43 23.5 66.05 66.05 66.05 66.05 66.05
Capital Expenditure .0 .0 -123.7 -1.2 .0 -11.8 -13.3 -15.1 -17.0 -19.2
Capital Expenditure, % 0 0 -294.29 -3.1 0 -20.62 -20.62 -20.62 -20.62 -20.62
Tax Rate, % 40.84 40.84 40.84 40.84 40.84 40.84 40.84 40.84 40.84 40.84
EBITAT -76.2 -17.7 -40.0 362.8 -6.6 -8.5 -9.6 -10.9 -12.3 -13.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -574.5 -30.7 -11.8 50.9 917.0 -37.0 25.2 28.5 32.2 36.4
WACC, % 6.39 5.96 6.39 5.6 5.46 5.96 5.96 5.96 5.96 5.96
PV UFCF
SUM PV UFCF 64.2
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 37
Terminal Value 670
Present Terminal Value 502
Enterprise Value 566
Net Debt 104
Equity Value 462
Diluted Shares Outstanding, MM 16
Equity Value Per Share 28.63

What You Will Get

  • Real ARL Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for American Realty Investors, Inc. (ARL).
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to ARL.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on American Realty Investors, Inc.'s (ARL) fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for ARL.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for your ARL analysis.

Key Features

  • Comprehensive Data: Access American Realty Investors, Inc.'s (ARL) historical financial reports and pre-filled projections.
  • Customizable Parameters: Modify inputs such as WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
  • Real-Time Insights: Observe the recalculation of American Realty’s intrinsic value instantly.
  • Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics clearly.
  • Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.

How It Works

  • Download: Get the pre-formatted Excel file containing American Realty Investors, Inc. (ARL) financial data.
  • Customize: Tailor your forecasts by adjusting parameters such as revenue growth, EBITDA %, and WACC.
  • Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Develop various projections and evaluate results immediately.
  • Make Decisions: Leverage the valuation insights to inform your investment strategy.

Why Choose This Calculator for American Realty Investors, Inc. (ARL)?

  • User-Friendly Interface: Perfectly suited for both novices and seasoned investors.
  • Customizable Inputs: Adjust parameters effortlessly to tailor your financial analysis.
  • Real-Time Valuation: Instantly observe how changes impact the valuation of American Realty Investors, Inc. (ARL).
  • Preloaded Data: Comes equipped with American Realty Investors, Inc. (ARL)’s historical financial metrics for immediate use.
  • Relied Upon by Experts: Widely utilized by financial analysts and investors for strategic decision-making.

Who Should Use This Product?

  • Real Estate Investors: Develop comprehensive and accurate valuation models for property analysis.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions in real estate.
  • Consultants and Advisors: Offer clients precise valuation insights for American Realty Investors, Inc. (ARL).
  • Students and Educators: Utilize real-world data to practice and teach financial modeling in real estate.
  • Market Analysts: Gain insights into how real estate investment trusts (REITs) like American Realty Investors, Inc. (ARL) are valued.

What the Template Contains

  • Pre-Filled DCF Model: American Realty Investors, Inc.'s (ARL) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate American Realty Investors, Inc.'s (ARL) profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.

No products were found matching.