Permian Basin Royalty Trust (PBT) DCF Valuation

Permian Basin Royalty Trust (PBT) 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

Permian Basin Royalty Trust (PBT) 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:

Gain insight into your Permian Basin Royalty Trust (PBT) valuation analysis with our sophisticated DCF Calculator! Equipped with real PBT data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of Permian Basin Royalty Trust (PBT).


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 20.5 12.0 11.8 54.5 29.1 28.3 27.5 26.7 26.0 25.3
Revenue Growth, % 0 -41.25 -1.99 361.16 -46.58 -2.78 -2.78 -2.78 -2.78 -2.78
EBITDA 19.4 11.0 10.7 53.5 28.0 26.6 25.9 25.2 24.5 23.8
EBITDA, % 94.69 90.94 90.78 98.31 96.16 94.18 94.18 94.18 94.18 94.18
Depreciation 1.1 1.1 1.1 .9 .0 1.4 1.4 1.4 1.3 1.3
Depreciation, % 5.31 9.06 9.22 1.69 0 5.06 5.06 5.06 5.06 5.06
EBIT 18.3 9.9 9.6 52.6 28.0 25.2 24.5 23.8 23.2 22.5
EBIT, % 89.38 81.89 81.56 96.61 96.16 89.12 89.12 89.12 89.12 89.12
Total Cash 2.9 1.7 2.2 2.9 6.1 4.1 4.0 3.9 3.8 3.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 .0 .0 .0 .0
Account Receivables, % 0 0 0 0 0
Inventories .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0 0 0 0 0 0 0 0 0
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 .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 0 0 0 0 0 0 0 0 0
EBITAT 18.3 9.9 9.6 52.6 28.0 25.2 24.5 23.8 23.2 22.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 19.4 11.0 10.7 53.5 28.0 26.6 25.9 25.2 24.5 23.8
WACC, % 7.27 7.27 7.27 7.27 7.27 7.27 7.27 7.27 7.27 7.27
PV UFCF
SUM PV UFCF 103.0
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 24
Terminal Value 353
Present Terminal Value 249
Enterprise Value 352
Net Debt -6
Equity Value 358
Diluted Shares Outstanding, MM 47
Equity Value Per Share 7.67

What You Will Get

  • Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled financial data for Permian Basin Royalty Trust (PBT).
  • Accurate Market Data: Access to historical performance data and future projections (highlighted in the yellow cells).
  • Flexible Forecasting: Adjust key assumptions such as revenue growth, EBITDA %, and WACC as needed.
  • Instant Calculations: Quickly observe how your inputs affect the valuation of Permian Basin Royalty Trust (PBT).
  • Professional-Grade Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Centric Design: Organized for simplicity and ease of navigation, complete with step-by-step guidance.

Key Features

  • Comprehensive Royalty Analysis Tool: Offers detailed insights into royalty income and distributions for Permian Basin Royalty Trust (PBT).
  • Revenue Projection Models: Pre-configured models to forecast future revenue based on current market trends.
  • Customizable Assumptions: Adjust parameters such as oil prices, production rates, and operational costs.
  • Integrated Financial Metrics: Evaluate key financial indicators including yield, payout ratios, and return on equity for PBT.
  • Interactive Dashboard and Visualizations: Dynamic charts and graphs that present essential financial data for straightforward interpretation.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Permian Basin Royalty Trust (PBT) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Permian Basin Royalty Trust’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose the PBT Calculator?

  • Accuracy: Utilizes authentic Permian Basin Royalty Trust (PBT) financial data for precise calculations.
  • Flexibility: Allows users to easily modify and test various input scenarios.
  • Time-Saving: Eliminate the need to create a financial model from the ground up.
  • Professional-Grade: Crafted with the expertise and attention to detail expected at the CFO level.
  • User-Friendly: Intuitive interface designed for users at all experience levels, including beginners.

Who Should Use This Product?

  • Energy Students: Understand royalty trust structures and apply them to real-world scenarios.
  • Researchers: Utilize data from PBT (PBT) for studies on energy markets and investment strategies.
  • Investors: Evaluate your investment strategies by analyzing the performance of PBT (PBT) and similar trusts.
  • Financial Analysts: Enhance your analysis with a comprehensive model tailored for royalty trusts like PBT (PBT).
  • Small Investors: Discover how royalty trusts operate and how they can fit into your investment portfolio.

What the Template Contains for Permian Basin Royalty Trust (PBT)

  • Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for PBT.
  • Real-World Data: Historical and projected financials for Permian Basin Royalty Trust (PBT) 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 to gain deeper insights into PBT's performance.
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Permian Basin Royalty Trust (PBT).
  • Dashboard with Visual Outputs: Charts and tables designed for clear, actionable insights regarding PBT.

No products were found matching.