Natural Resource Partners L.P. (NRP) 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
Natural Resource Partners L.P. (NRP) Bundle
Enhance your investment strategies with the Natural Resource Partners L.P. (NRP) DCF Calculator! Explore authentic financial data, adjust growth projections and expenses, and instantly observe how modifications affect the intrinsic value of NRP.
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 | 210.3 | 129.0 | 194.2 | 328.1 | 293.7 | 345.3 | 406.0 | 477.3 | 561.2 | 659.8 |
Revenue Growth, % | 0 | -38.67 | 50.57 | 68.9 | -10.49 | 17.58 | 17.58 | 17.58 | 17.58 | 17.58 |
EBITDA | 37.0 | -34.7 | 166.9 | 317.3 | 311.0 | 188.7 | 221.9 | 260.9 | 306.8 | 360.7 |
EBITDA, % | 17.58 | -26.86 | 85.9 | 96.71 | 105.92 | 54.66 | 54.66 | 54.66 | 54.66 | 54.66 |
Depreciation | 14.9 | 9.2 | 19.1 | 22.5 | 18.5 | 25.7 | 30.2 | 35.5 | 41.8 | 49.1 |
Depreciation, % | 7.1 | 7.13 | 9.82 | 6.86 | 6.3 | 7.44 | 7.44 | 7.44 | 7.44 | 7.44 |
EBIT | 22.0 | -43.9 | 147.8 | 294.8 | 292.5 | 167.1 | 196.5 | 231.0 | 271.7 | 319.4 |
EBIT, % | 10.48 | -33.99 | 76.08 | 89.84 | 99.62 | 48.41 | 48.41 | 48.41 | 48.41 | 48.41 |
Total Cash | 98.3 | 99.8 | 135.5 | 39.1 | 12.0 | 144.9 | 170.4 | 200.3 | 235.5 | 276.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 30.9 | 12.3 | 24.5 | 42.7 | 41.1 | 44.1 | 51.9 | 61.0 | 71.7 | 84.3 |
Account Receivables, % | 14.68 | 9.55 | 12.63 | 13.02 | 13.99 | 12.77 | 12.77 | 12.77 | 12.77 | 12.77 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0.000000775 | 0.000000515 | 0 | 0 | 0.000000258 | 0.000000258 | 0.000000258 | 0.000000258 | 0.000000258 |
Accounts Payable | 1.2 | 1.4 | 2.0 | 2.0 | .9 | 2.5 | 2.9 | 3.4 | 4.0 | 4.7 |
Accounts Payable, % | 0.5605 | 1.07 | 1.01 | 0.60716 | 0.30137 | 0.70991 | 0.70991 | 0.70991 | 0.70991 | 0.70991 |
Capital Expenditure | .0 | .0 | .0 | -.1 | .0 | .0 | .0 | .0 | -.1 | -.1 |
Capital Expenditure, % | -0.01045886 | 0 | 0 | -0.03596629 | -0.00340535 | -0.0099661 | -0.0099661 | -0.0099661 | -0.0099661 | -0.0099661 |
Tax Rate, % | 1.44 | 1.44 | 1.44 | 1.44 | 1.44 | 1.44 | 1.44 | 1.44 | 1.44 | 1.44 |
EBITAT | 103.2 | -70.6 | 65.3 | 294.8 | 288.3 | 148.0 | 174.0 | 204.6 | 240.6 | 282.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 88.4 | -42.6 | 72.8 | 299.0 | 307.3 | 172.2 | 196.9 | 231.5 | 272.1 | 320.0 |
WACC, % | 6.87 | 6.87 | 6.45 | 6.87 | 6.86 | 6.79 | 6.79 | 6.79 | 6.79 | 6.79 |
PV UFCF | ||||||||||
SUM PV UFCF | 963.7 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 322 | |||||||||
Terminal Value | 5,114 | |||||||||
Present Terminal Value | 3,683 | |||||||||
Enterprise Value | 4,646 | |||||||||
Net Debt | 143 | |||||||||
Equity Value | 4,503 | |||||||||
Diluted Shares Outstanding, MM | 16 | |||||||||
Equity Value Per Share | 279.77 |
What You Will Get
- Authentic NRP Financial Data: Pre-filled with Natural Resource Partners L.P.'s historical and projected data for accurate analysis.
- Completely Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Observe NRP's intrinsic value update immediately based on your modifications.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Straightforward layout and clear guidance suitable for all experience levels.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Natural Resource Partners L.P. (NRP).
- WACC Calculator: Comes with a pre-configured Weighted Average Cost of Capital sheet that allows for customizable inputs.
- Adjustable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Natural Resource Partners L.P. (NRP).
- Interactive Dashboard and Charts: Visual representations that summarize key valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the pre-prepared Excel file featuring Natural Resource Partners L.P. (NRP) financial data.
- Customize: Tailor your forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to shape your investment approach.
Why Choose This Calculator for Natural Resource Partners L.P. (NRP)?
- User-Friendly Interface: Perfect for both novice users and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your specific analysis needs.
- Real-Time Adjustments: Witness immediate updates to NRP’s valuation as you change inputs.
- Preloaded Data: Comes equipped with NRP’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Natural Resource Students: Explore the intricacies of resource valuation and apply methodologies using real-world data.
- Researchers: Integrate industry-standard models into your academic studies or environmental research.
- Investors: Validate your investment strategies and evaluate the performance metrics for Natural Resource Partners L.P. (NRP).
- Industry Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for resource companies.
- Entrepreneurs: Understand how large resource firms like Natural Resource Partners L.P. (NRP) are assessed in the market.
What the Template Contains
- Historical Data: Includes Natural Resource Partners L.P.'s (NRP) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Natural Resource Partners L.P.'s (NRP) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Natural Resource Partners L.P.'s (NRP) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.