Kimbell Royalty Partners, LP (KRP) DCF Valuation

Kimbell Royalty Partners, LP (KRP) 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

Kimbell Royalty Partners, LP (KRP) 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:

Streamline Kimbell Royalty Partners, LP (KRP) valuation with this customizable DCF Calculator! With real Kimbell Royalty Partners, LP (KRP) financial data and adjustable forecast parameters, you can explore various scenarios and determine Kimbell Royalty Partners, LP (KRP) fair value in just minutes.


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 110.0 92.9 178.4 285.0 273.2 363.4 483.4 643.1 855.4 1,137.9
Revenue Growth, % 0 -15.48 91.97 59.77 -4.16 33.02 33.02 33.02 33.02 33.02
EBITDA -99.2 -202.3 88.8 197.8 209.5 4.1 5.4 7.2 9.6 12.8
EBITDA, % -90.24 -217.66 49.77 69.38 76.7 1.12 1.12 1.12 1.12 1.12
Depreciation 52.3 48.3 37.1 50.4 96.8 126.0 167.6 223.0 296.6 394.6
Depreciation, % 47.54 51.94 20.79 17.68 35.44 34.68 34.68 34.68 34.68 34.68
EBIT -151.5 -250.5 51.7 147.4 112.7 -56.7 -75.5 -100.4 -133.6 -177.7
EBIT, % -137.78 -269.6 28.98 51.7 41.26 -15.61 -15.61 -15.61 -15.61 -15.61
Total Cash 14.2 9.8 7.1 24.6 31.0 34.5 45.8 61.0 81.1 107.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 19.2 18.5 38.2 50.6 60.7
Account Receivables, % 17.43 19.94 21.41 17.74 22.23
Inventories -19,934.9 -18,526.7 -38,364.9 -50,556.6 .0 -290.7 -386.7 -514.4 -684.3 -910.3
Inventories, % -18129.7 -19935.56 -21504.13 -17736.8 0 -80 -80 -80 -80 -80
Accounts Payable 1.2 .9 .8 1.2 6.6 3.9 5.2 6.9 9.1 12.2
Accounts Payable, % 1.1 0.95632 0.45459 0.42462 2.41 1.07 1.07 1.07 1.07 1.07
Capital Expenditure -12.7 -88.6 -56.1 -141.5 -490.8 -209.3 -278.4 -370.3 -492.7 -655.3
Capital Expenditure, % -11.57 -95.33 -31.43 -49.63 -179.66 -57.59 -57.59 -57.59 -57.59 -57.59
Tax Rate, % 23.42 23.42 23.42 23.42 23.42 23.42 23.42 23.42 23.42 23.42
EBITAT -152.4 -249.7 41.2 123.5 86.3 -49.9 -66.4 -88.3 -117.5 -156.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 19,804.1 -1,697.9 19,840.6 12,212.2 -50,869.1 143.8 -103.6 -137.7 -183.2 -243.8
WACC, % 9.6 9.6 9.3 9.36 9.26 9.42 9.42 9.42 9.42 9.42
PV UFCF
SUM PV UFCF -343.4
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) -254
Terminal Value -4,674
Present Terminal Value -2,979
Enterprise Value -3,323
Net Debt 265
Equity Value -3,588
Diluted Shares Outstanding, MM 93
Equity Value Per Share -38.55

What You Will Get

  • Real KRP Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Kimbell Royalty Partners, LP (KRP).
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to KRP.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Kimbell Royalty Partners, LP’s fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for KRP.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Kimbell Royalty Partners, LP (KRP).

Key Features

  • Comprehensive KRP Data: Pre-filled with Kimbell Royalty Partners' historical performance metrics and future revenue forecasts.
  • Customizable Financial Inputs: Modify royalty income, operating expenses, tax rates, and capital allocation as needed.
  • Interactive Valuation Tool: Real-time adjustments to Net Asset Value (NAV) and intrinsic value based on user-defined parameters.
  • Flexible Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
  • Intuitive User Interface: Designed to be accessible for both industry veterans and newcomers.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Kimbell Royalty Partners, LP's (KRP) preloaded data.
  • 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures as needed.
  • 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
  • 4. Evaluate Scenarios: Analyze various forecasts to understand different valuation outcomes.
  • 5. Present with Assurance: Deliver professional valuation insights to back your strategic decisions.

Why Choose This Calculator for Kimbell Royalty Partners, LP (KRP)?

  • User-Friendly Interface: Perfectly crafted for both novices and seasoned users.
  • Customizable Inputs: Adjust parameters easily to suit your financial analysis.
  • Real-Time Valuation: Observe immediate changes in KRP’s valuation as you modify inputs.
  • Preloaded Data: Comes equipped with KRP’s actual financial metrics for swift evaluations.
  • Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.

Who Should Use Kimbell Royalty Partners, LP (KRP)?

  • Energy Finance Students: Understand royalty structures and apply valuation methods using real-world data.
  • Academics: Integrate industry-specific models into research or educational programs.
  • Investors: Evaluate your investment strategies and assess valuation metrics for Kimbell Royalty Partners, LP (KRP).
  • Financial Analysts: Enhance your analysis with a tailored, user-friendly DCF model for royalty interests.
  • Real Estate Investors: Discover insights into how energy companies like Kimbell Royalty Partners, LP (KRP) are evaluated.

What the Template Contains

  • Pre-Filled Data: Includes Kimbell Royalty Partners, LP’s (KRP) historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Analyze Kimbell Royalty Partners, LP’s (KRP) profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.

No products were found matching.