Ladder Capital Corp (LADR) DCF Valuation

Ladder Capital Corp (LADR) 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

Ladder Capital Corp (LADR) 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:

Designed for accuracy, our (LADR) DCF Calculator empowers you to evaluate Ladder Capital Corp's valuation using real-world financial data, while offering complete flexibility to modify all key parameters for enhanced projections.


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 293.4 121.0 167.5 339.7 253.5 287.9 327.0 371.4 421.8 479.0
Revenue Growth, % 0 -58.76 38.42 102.77 -25.37 13.57 13.57 13.57 13.57 13.57
EBITDA .0 14.4 .0 398.2 .0 64.4 73.2 83.1 94.4 107.2
EBITDA, % 0 11.86 0 117.22 0 22.37 22.37 22.37 22.37 22.37
Depreciation 363.2 173.9 119.0 180.0 28.1 193.0 219.2 248.9 282.7 321.1
Depreciation, % 123.79 143.74 71.05 52.99 11.09 67.03 67.03 67.03 67.03 67.03
EBIT -363.2 -159.6 -119.0 218.2 -28.1 -125.5 -142.5 -161.9 -183.8 -208.8
EBIT, % -123.79 -131.88 -71.05 64.23 -11.09 -43.58 -43.58 -43.58 -43.58 -43.58
Total Cash 1,779.5 1,487.1 1,252.0 615.3 1,015.7 287.9 327.0 371.4 421.8 479.0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 21.3 16.6 13.6 24.9 24.2
Account Receivables, % 7.26 13.71 8.15 7.34 9.56
Inventories -.7 -.3 -.4 -2.0 .0 -.8 -.9 -1.0 -1.1 -1.3
Inventories, % -0.23617 -0.24708 -0.23999 -0.60001 0 -0.26465 -0.26465 -0.26465 -0.26465 -0.26465
Accounts Payable .2 .0 .0 .0 .0 .0 .0 .1 .1 .1
Accounts Payable, % 0.07599716 0 0 0 0 0.01519943 0.01519943 0.01519943 0.01519943 0.01519943
Capital Expenditure -7.6 -6.1 -4.9 -6.9 .0 -7.2 -8.2 -9.3 -10.6 -12.1
Capital Expenditure, % -2.59 -5.04 -2.91 -2.05 0 -2.52 -2.52 -2.52 -2.52 -2.52
Tax Rate, % 3.46 3.46 3.46 3.46 3.46 3.46 3.46 3.46 3.46 3.46
EBITAT -319.0 -78.4 -116.3 182.3 -27.1 -104.1 -118.2 -134.3 -152.5 -173.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 16.2 93.5 .8 345.7 -.4 80.2 89.2 101.3 115.1 130.7
WACC, % 8.94 6.87 9.47 8.71 9.41 8.68 8.68 8.68 8.68 8.68
PV UFCF
SUM PV UFCF 396.9
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 133
Terminal Value 1,995
Present Terminal Value 1,316
Enterprise Value 1,713
Net Debt 2,162
Equity Value -449
Diluted Shares Outstanding, MM 125
Equity Value Per Share -3.59

What You Will Get

  • Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: Ladder Capital Corp's (LADR) financial data pre-filled to facilitate your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
  • Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and saving time.

Key Features

  • Customizable Financial Inputs: Adjust essential metrics such as interest rates, loan-to-value ratios, and property valuations.
  • Instant DCF Analysis: Quickly computes intrinsic values, net present value, and other financial metrics.
  • High Precision Estimates: Leverages Ladder Capital Corp’s (LADR) actual financial data for accurate valuation results.
  • Effortless Scenario Testing: Easily evaluate various scenarios and analyze the resulting impacts.
  • Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Ladder Capital Corp's (LADR) financial data.
  • 2. Adjust Assumptions: Modify key parameters such as growth projections, WACC, and capital expenditures.
  • 3. See Results Immediately: The DCF model automatically computes intrinsic value and NPV based on your inputs.
  • 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation possibilities.
  • 5. Present with Assurance: Deliver professional valuation insights to back your financial decisions.

Why Choose This Calculator for Ladder Capital Corp (LADR)?

  • Accuracy: Utilizes real Ladder Capital financial data to ensure precision.
  • Flexibility: Allows users to easily test and adjust inputs as needed.
  • Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
  • Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
  • User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.

Who Should Use Ladder Capital Corp (LADR)?

  • Real Estate Investors: Leverage insights from a trusted source for making informed property investments.
  • Financial Analysts: Access comprehensive data to streamline your analysis of real estate markets.
  • Consultants: Tailor reports and presentations quickly using our detailed market research.
  • Finance Enthusiasts: Explore the intricacies of real estate finance with practical examples and case studies.
  • Educators and Students: Utilize our resources as a hands-on learning tool in real estate finance courses.

What the Template Contains

  • Pre-Filled Data: Contains Ladder Capital Corp's historical financials and projections.
  • Discounted Cash Flow Model: Customizable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on user-defined inputs.
  • Key Financial Ratios: Evaluate Ladder Capital Corp's profitability, efficiency, and leverage.
  • Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
  • Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.