Lument Finance Trust, Inc. (LFT) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Lument Finance Trust, Inc. (LFT) Bundle
Whether you’re an investor or an analyst, this (LFT) DCF Calculator is your go-to resource for accurate valuation. Preloaded with real data from Lument Finance Trust, Inc., you can adjust forecasts and immediately observe the effects.
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 | 16.3 | 19.1 | 21.1 | 24.2 | 32.1 | 38.1 | 45.3 | 53.8 | 63.9 | 75.9 |
Revenue Growth, % | 0 | 17.66 | 10.07 | 14.98 | 32.43 | 18.78 | 18.78 | 18.78 | 18.78 | 18.78 |
EBITDA | 6.2 | 8.0 | 10.6 | 5.2 | 94.5 | 19.2 | 22.8 | 27.0 | 32.1 | 38.2 |
EBITDA, % | 38.15 | 41.66 | 50.34 | 21.36 | 294.66 | 50.3 | 50.3 | 50.3 | 50.3 | 50.3 |
Depreciation | 33.0 | 11.2 | 8.4 | 14.3 | 72.5 | 27.3 | 32.4 | 38.5 | 45.7 | 54.3 |
Depreciation, % | 202.93 | 58.34 | 40.07 | 59.23 | 226.13 | 71.53 | 71.53 | 71.53 | 71.53 | 71.53 |
EBIT | -26.8 | -3.2 | 2.2 | -9.2 | 22.0 | -5.8 | -6.9 | -8.1 | -9.7 | -11.5 |
EBIT, % | -164.78 | -16.68 | 10.27 | -37.87 | 68.53 | -15.15 | -15.15 | -15.15 | -15.15 | -15.15 |
Total Cash | 10.9 | 11.4 | 14.7 | 1,120.0 | 51.2 | 30.2 | 35.9 | 42.7 | 50.7 | 60.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2.3 | 2.0 | 26.4 | 5.8 | 8.6 | 13.4 | 15.9 | 18.9 | 22.4 | 26.6 |
Account Receivables, % | 14.4 | 10.53 | 125.21 | 23.94 | 26.77 | 35.13 | 35.13 | 35.13 | 35.13 | 35.13 |
Inventories | 18.4 | 71.4 | 44.7 | 53.2 | .0 | 30.5 | 36.2 | 43.0 | 51.1 | 60.7 |
Inventories, % | 112.83 | 372.99 | 211.98 | 219.48 | 0 | 80 | 80 | 80 | 80 | 80 |
Accounts Payable | .8 | .4 | .7 | 2.4 | 4.1 | 2.5 | 3.0 | 3.6 | 4.2 | 5.0 |
Accounts Payable, % | 4.95 | 2.26 | 3.34 | 9.75 | 12.76 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 |
Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Tax Rate, % | 0.02902098 | 0.02902098 | 0.02902098 | 0.02902098 | 0.02902098 | 0.02902098 | 0.02902098 | 0.02902098 | 0.02902098 | 0.02902098 |
EBITAT | -27.0 | -3.4 | 2.1 | -9.2 | 22.0 | -5.8 | -6.8 | -8.1 | -9.7 | -11.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -13.9 | -45.3 | 13.2 | 18.9 | 146.6 | -15.4 | 17.8 | 21.1 | 25.1 | 29.8 |
WACC, % | 6.64 | 6.64 | 6.6 | 6.63 | 6.64 | 6.63 | 6.63 | 6.63 | 6.63 | 6.63 |
PV UFCF | ||||||||||
SUM PV UFCF | 59.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 30 | |||||||||
Terminal Value | 656 | |||||||||
Present Terminal Value | 476 | |||||||||
Enterprise Value | 536 | |||||||||
Net Debt | 1,142 | |||||||||
Equity Value | -607 | |||||||||
Diluted Shares Outstanding, MM | 52 | |||||||||
Equity Value Per Share | -11.61 |
What You Will Get
- Real LFT Financial Data: Pre-filled with Lument Finance Trust, Inc.’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See LFT’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Lument Finance Trust, Inc. (LFT).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to LFT.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit LFT’s financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Lument Finance Trust, Inc. (LFT).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for streamlined analysis of LFT.
How It Works
- Step 1: Download the Excel file for Lument Finance Trust, Inc. (LFT).
- Step 2: Review LFT’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 your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for Lument Finance Trust, Inc. (LFT)?
- Designed for Experts: A sophisticated tool tailored for analysts, financial managers, and investors.
- Up-to-Date Financials: LFT’s historical and projected financial data preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Clear, step-by-step guidance ensures a smooth experience.
Who Should Use This Product?
- Investors: Accurately assess Lument Finance Trust, Inc.'s (LFT) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for client valuation reports.
- Entrepreneurs: Acquire insights into financial modeling practices of leading finance firms.
- Educators: Employ it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Pre-Filled DCF Model: Lument Finance Trust, Inc.’s (LFT) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Lument Finance Trust, Inc.’s (LFT) 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.