Ladder Capital Corp (LADR) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Ladder Capital Corp (LADR) Bundle
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 | 26.5 | 30.1 | 34.2 | 38.8 | 44.1 |
Account Receivables, % | 7.26 | 13.71 | 8.15 | 7.34 | 9.56 | 9.2 | 9.2 | 9.2 | 9.2 | 9.2 |
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.