Rayonier Inc. (RYN) 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
Rayonier Inc. (RYN) Bundle
Looking to assess the intrinsic value of Rayonier Inc.? Our RYN DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust forecasts and enhance your investment decisions.
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 | 711.6 | 859.2 | 1,109.6 | 909.1 | 1,056.9 | 1,184.0 | 1,326.3 | 1,485.7 | 1,664.3 | 1,864.3 |
Revenue Growth, % | 0 | 20.74 | 29.14 | -18.07 | 16.26 | 12.02 | 12.02 | 12.02 | 12.02 | 12.02 |
EBITDA | 237.7 | 275.7 | 411.3 | 303.8 | 378.2 | 406.7 | 455.6 | 510.4 | 571.7 | 640.4 |
EBITDA, % | 33.4 | 32.09 | 37.07 | 33.42 | 35.78 | 34.35 | 34.35 | 34.35 | 34.35 | 34.35 |
Depreciation | 605.8 | 764.1 | 851.6 | 758.8 | 158.2 | 827.0 | 926.4 | 1,037.7 | 1,162.5 | 1,302.2 |
Depreciation, % | 85.13 | 88.94 | 76.75 | 83.46 | 14.97 | 69.85 | 69.85 | 69.85 | 69.85 | 69.85 |
EBIT | -368.1 | -488.4 | -440.3 | -454.9 | 220.0 | -420.3 | -470.8 | -527.4 | -590.8 | -661.8 |
EBIT, % | -51.73 | -56.84 | -39.68 | -50.04 | 20.81 | -35.5 | -35.5 | -35.5 | -35.5 | -35.5 |
Total Cash | 68.7 | 84.6 | 362.2 | 114.3 | 207.7 | 199.8 | 223.8 | 250.7 | 280.8 | 314.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 27.1 | 49.1 | 30.0 | 42.5 | 40.2 | 49.0 | 54.9 | 61.5 | 68.9 | 77.2 |
Account Receivables, % | 3.81 | 5.71 | 2.71 | 4.68 | 3.8 | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 |
Inventories | 14.5 | 10.6 | 28.5 | 23.7 | 31.0 | 27.0 | 30.2 | 33.8 | 37.9 | 42.5 |
Inventories, % | 2.04 | 1.23 | 2.57 | 2.61 | 2.93 | 2.28 | 2.28 | 2.28 | 2.28 | 2.28 |
Accounts Payable | 18.2 | 24.8 | 23.4 | 22.1 | 26.6 | 29.6 | 33.1 | 37.1 | 41.6 | 46.6 |
Accounts Payable, % | 2.55 | 2.89 | 2.11 | 2.43 | 2.51 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 |
Capital Expenditure | -206.3 | -91.2 | -255.1 | -533.3 | -95.5 | -308.5 | -345.6 | -387.2 | -433.7 | -485.8 |
Capital Expenditure, % | -28.99 | -10.61 | -22.99 | -58.66 | -9.04 | -26.06 | -26.06 | -26.06 | -26.06 | -26.06 |
Tax Rate, % | 5.51 | 5.51 | 5.51 | 5.51 | 5.51 | 5.51 | 5.51 | 5.51 | 5.51 | 5.51 |
EBITAT | -269.9 | -492.2 | -411.8 | -368.5 | 207.8 | -371.8 | -416.5 | -466.5 | -522.6 | -585.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 106.1 | 169.4 | 184.6 | -152.1 | 270.1 | 144.9 | 158.7 | 177.8 | 199.2 | 223.1 |
WACC, % | 7.79 | 8.11 | 8.03 | 7.88 | 8.04 | 7.97 | 7.97 | 7.97 | 7.97 | 7.97 |
PV UFCF | ||||||||||
SUM PV UFCF | 710.3 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 232 | |||||||||
Terminal Value | 5,848 | |||||||||
Present Terminal Value | 3,986 | |||||||||
Enterprise Value | 4,696 | |||||||||
Net Debt | 1,246 | |||||||||
Equity Value | 3,450 | |||||||||
Diluted Shares Outstanding, MM | 151 | |||||||||
Equity Value Per Share | 22.84 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Rayonier Inc.'s (RYN) financial data pre-loaded to expedite your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Rayonier Inc. (RYN).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with customizable parameters specific to Rayonier Inc. (RYN).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Rayonier Inc. (RYN) projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Rayonier Inc. (RYN).
- Interactive Dashboard and Charts: Visual representations summarize key valuation metrics for straightforward analysis of Rayonier Inc. (RYN).
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Rayonier Inc. (RYN) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Rayonier Inc.'s (RYN) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Rayonier Inc. (RYN)?
- Precise Information: Up-to-date Rayonier financials guarantee trustworthy valuation outcomes.
- Flexible Options: Modify essential factors such as growth rates, WACC, and tax rates to align with your forecasts.
- Efficient: Built-in calculations save you the hassle of starting from ground zero.
- Expert-Level Tool: Tailored for investors, analysts, and industry professionals.
- Easy to Use: User-friendly design and clear, step-by-step guidance cater to all experience levels.
Who Should Use Rayonier Inc. (RYN)?
- Environmental Science Students: Explore sustainable forestry practices and their impact on valuation.
- Researchers: Integrate real-world data on timberland management into studies or projects.
- Investors: Evaluate your investment strategies and analyze the market performance of Rayonier Inc. (RYN).
- Financial Analysts: Enhance your analysis with a tailored DCF model specific to the forestry sector.
- Real Estate Developers: Understand how land valuation and timber resources affect property investments.
What the Template Contains
- Pre-Filled Data: Includes Rayonier Inc.'s 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 Rayonier Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.