Farmland Partners Inc. (FPI) DCF Valuation

Farmland Partners Inc. (FPI) 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

Farmland Partners Inc. (FPI) 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 (FPI) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from Farmland Partners Inc., you can adjust forecasts and instantly 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 53.6 50.7 51.7 61.2 57.5 58.7 60.0 61.4 62.7 64.1
Revenue Growth, % 0 -5.37 2.07 18.31 -6.12 2.22 2.22 2.22 2.22 2.22
EBITDA 34.7 30.3 33.8 32.1 60.9 40.2 41.1 42.0 43.0 43.9
EBITDA, % 64.71 59.8 65.36 52.44 105.98 68.46 68.46 68.46 68.46 68.46
Depreciation 27.2 28.4 34.9 36.2 7.5 29.0 29.6 30.3 30.9 31.6
Depreciation, % 50.83 55.95 67.5 59.2 13.05 49.31 49.31 49.31 49.31 49.31
EBIT 7.4 2.0 -1.1 -4.1 53.4 12.0 12.2 12.5 12.8 13.1
EBIT, % 13.88 3.85 -2.14 -6.76 92.93 20.35 20.35 20.35 20.35 20.35
Total Cash 12.6 27.2 30.2 7.7 5.5 18.5 18.9 19.3 19.8 20.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 10.3 6.5 11.0 29.0 38.9
Account Receivables, % 19.2 12.76 21.28 47.34 67.75
Inventories 1.6 1.1 3.1 2.8 2.3 2.3 2.4 2.4 2.5 2.5
Inventories, % 2.89 2.2 5.91 4.59 4.06 3.93 3.93 3.93 3.93 3.93
Accounts Payable .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Accounts Payable, % 0 0 0 0 0 0 0 0 0 0
Capital Expenditure -6.6 -2.7 -2.7 -4.2 .0 -3.5 -3.6 -3.6 -3.7 -3.8
Capital Expenditure, % -12.29 -5.24 -5.24 -6.94 0 -5.94 -5.94 -5.94 -5.94 -5.94
Tax Rate, % 1.91 1.91 1.91 1.91 1.91 1.91 1.91 1.91 1.91 1.91
EBITAT -3.0 -2.7 .7 -4.0 52.4 4.6 4.7 4.8 5.0 5.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 5.8 27.2 26.4 10.3 50.4 49.3 30.3 31.0 31.7 32.4
WACC, % 5.03 5.03 5.03 7.13 7.18 5.88 5.88 5.88 5.88 5.88
PV UFCF
SUM PV UFCF 149.1
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 34
Terminal Value 1,788
Present Terminal Value 1,343
Enterprise Value 1,492
Net Debt 356
Equity Value 1,137
Diluted Shares Outstanding, MM 58
Equity Value Per Share 19.50

What You Will Get

  • Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: Farmland Partners Inc. (FPI) financial data pre-filled to kickstart your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
  • Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and optimizing time.

Key Features

  • Real-Life FPI Data: Pre-filled with Farmland Partners Inc.'s historical performance and future projections.
  • Fully Customizable Inputs: Modify revenue growth, operating expenses, cap rates, tax implications, and land acquisitions.
  • Dynamic Valuation Model: Automatic adjustments to Net Present Value (NPV) and intrinsic value based on your parameters.
  • Scenario Testing: Develop various forecast scenarios to evaluate different valuation possibilities.
  • User-Friendly Design: Intuitive, organized, and tailored for both professionals and newcomers.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Farmland Partners Inc. (FPI)'s preloaded data.
  • 2. Modify Assumptions: Adjust key variables such as growth rates, WACC, and capital expenditures.
  • 3. Analyze Results Immediately: The DCF model automatically calculates the intrinsic value and NPV.
  • 4. Explore Scenarios: Evaluate multiple forecasts to assess various valuation outcomes.
  • 5. Present with Assurance: Showcase professional valuation insights to back your decisions.

Why Choose This Calculator for Farmland Partners Inc. (FPI)?

  • Accurate Data: Utilize real financials from Farmland Partners Inc. for dependable valuation outcomes.
  • Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
  • Professional-Grade Tool: Tailored for investors, analysts, and consultants in the agricultural sector.
  • User-Friendly: An intuitive design and step-by-step guidance make it accessible for all users.

Who Should Use This Product?

  • Individual Investors: Gain insights to make informed decisions about investing in Farmland Partners Inc. (FPI).
  • Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for Farmland Partners Inc. (FPI).
  • Consultants: Provide clients with expert valuation analyses of Farmland Partners Inc. (FPI) swiftly and accurately.
  • Business Owners: Learn how agricultural REITs like Farmland Partners Inc. (FPI) are valued to inform your own business strategies.
  • Finance Students: Explore valuation methodologies using real-world data and case studies related to Farmland Partners Inc. (FPI).

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring detailed valuation calculations specific to Farmland Partners Inc. (FPI).
  • Real-World Data: Historical and projected financials for Farmland Partners Inc. (FPI) preloaded for in-depth analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into the company's performance.
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage tailored to Farmland Partners Inc. (FPI).
  • Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results regarding Farmland Partners Inc. (FPI).

No products were found matching.