Two Harbors Investment Corp. (TWO) DCF Valuation

Two Harbors Investment Corp. (TWO) 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

Two Harbors Investment Corp. (TWO) 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 (TWO) DCF Calculator is the perfect tool for accurate valuation. Equipped with real data from Two Harbors Investment Corp., 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 427.6 -1,562.0 255.2 407.2 257.1 143.1 79.7 44.4 24.7 13.7
Revenue Growth, % 0 -465.34 -116.34 59.54 -36.86 -44.33 -44.33 -44.33 -44.33 -44.33
EBITDA 310.4 -1,665.8 191.4 629.2 .0 99.5 55.4 30.8 17.2 9.6
EBITDA, % 72.6 106.64 75 154.52 0 69.52 69.52 69.52 69.52 69.52
Depreciation 1,573.9 516.3 -423.5 -570.2 .0 -38.1 -21.2 -11.8 -6.6 -3.7
Depreciation, % 368.11 -33.05 -165.94 -140.05 0 -26.61 -26.61 -26.61 -26.61 -26.61
EBIT -1,263.5 -2,182.1 614.9 1,199.4 .0 57.2 31.9 17.7 9.9 5.5
EBIT, % -295.51 139.7 240.94 294.57 0 40 40 40 40 40
Total Cash 31,964.5 16,035.7 8,315.6 8,462.2 794.8 85.9 47.8 26.6 14.8 8.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 411.6 193.6 194.7 289.4 358.6
Account Receivables, % 96.27 -12.39 76.29 71.07 139.48
Inventories 2,046.0 1,578.4 1,348.6 1,162.5 .0 57.2 31.9 17.7 9.9 5.5
Inventories, % 478.52 -101.05 528.4 285.51 0 40 40 40 40 40
Accounts Payable 149.6 21.7 18.4 94.0 141.8 34.1 19.0 10.6 5.9 3.3
Accounts Payable, % 35 -1.39 7.2 23.09 55.15 23.81 23.81 23.81 23.81 23.81
Capital Expenditure -613.7 -622.4 -742.2 -629.8 .0 -85.9 -47.8 -26.6 -14.8 -8.2
Capital Expenditure, % -143.53 39.85 -290.79 -154.68 0 -60 -60 -60 -60 -60
Tax Rate, % -27.55 -27.55 -27.55 -27.55 -27.55 -27.55 -27.55 -27.55 -27.55 -27.55
EBITAT -1,318.7 -2,135.4 601.5 814.2 .0 53.1 29.5 16.4 9.2 5.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -2,666.4 -1,683.9 -338.8 -218.9 1,141.1 27.9 12.8 7.1 4.0 2.2
WACC, % 26.3 25.85 25.84 19.45 26.3 24.75 24.75 24.75 24.75 24.75
PV UFCF
SUM PV UFCF 36.7
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 2
Terminal Value 10
Present Terminal Value 3
Enterprise Value 40
Net Debt 1,163
Equity Value -1,123
Diluted Shares Outstanding, MM 96
Equity Value Per Share -11.74

What You Will Get

  • Real TWO Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
  • Scenario Analysis: Evaluate various scenarios to assess Two Harbors' future performance.
  • User-Friendly Design: Designed for industry professionals but easy for newcomers to navigate.

Key Features

  • Customizable Investment Metrics: Adjust essential parameters such as dividend yield, net asset value, and leverage ratios.
  • Instant DCF Analysis: Quickly computes intrinsic value, NPV, and other financial metrics with ease.
  • High-Precision Results: Leverages Two Harbors' actual financial data for accurate investment valuations.
  • Effortless Scenario Testing: Evaluate varying investment strategies and assess their potential outcomes effortlessly.
  • Efficiency Booster: Avoid the complexities of creating detailed valuation models from the ground up.

How It Works

  • Step 1: Download the prebuilt Excel template with Two Harbors Investment Corp.'s (TWO) data included.
  • Step 2: Explore the pre-filled sheets and understand the key metrics related to (TWO).
  • Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins) for (TWO).
  • Step 4: Instantly view recalculated results, including Two Harbors Investment Corp.'s (TWO) intrinsic value.
  • Step 5: Make informed investment decisions or generate reports using the outputs for (TWO).

Why Choose This Calculator for Two Harbors Investment Corp. (TWO)?

  • Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for Two Harbors Investment Corp. (TWO).
  • Customizable Inputs: Modify the yellow-highlighted cells to explore different investment scenarios.
  • Detailed Insights: Automatically calculates Two Harbors’ intrinsic value and Net Present Value.
  • Preloaded Data: Historical and projected data provide reliable starting points for analysis.
  • Professional Quality: Perfect for financial analysts, investors, and consultants focusing on Two Harbors Investment Corp. (TWO).

Who Should Use This Product?

  • Investors: Gain insights and make informed decisions with Two Harbors Investment Corp. (TWO) valuation resources.
  • Financial Analysts: Streamline your analysis with customizable financial models tailored for Two Harbors Investment Corp. (TWO).
  • Consultants: Effortlessly modify templates for client reports or presentations focused on Two Harbors Investment Corp. (TWO).
  • Finance Enthusiasts: Expand your knowledge of investment strategies through case studies involving Two Harbors Investment Corp. (TWO).
  • Educators and Students: Utilize this tool as a hands-on resource in finance courses centered around Two Harbors Investment Corp. (TWO).

What the Template Contains

  • Pre-Filled DCF Model: Two Harbors Investment Corp.'s (TWO) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital tailored to (TWO).
  • Financial Ratios: Assess Two Harbors' (TWO) profitability, leverage, and efficiency metrics.
  • Editable Inputs: Modify assumptions such as growth rates, margins, and CAPEX to suit your analysis.
  • Financial Statements: Access annual and quarterly reports for comprehensive evaluation.
  • Interactive Dashboard: Visualize key valuation metrics and results for Two Harbors Investment Corp. (TWO) effortlessly.

No products were found matching.