West Fraser Timber Co. Ltd. (WFG) 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
West Fraser Timber Co. Ltd. (WFG) Bundle
Simplify West Fraser Timber Co. Ltd. (WFG) valuation with this customizable DCF Calculator! Featuring real West Fraser Timber Co. Ltd. (WFG) financials and adjustable forecast inputs, you can test scenarios and uncover West Fraser Timber Co. Ltd. (WFG) fair value in 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 | 2,589.6 | 3,182.0 | 7,295.4 | 6,728.7 | 4,476.5 | 5,390.2 | 6,490.3 | 7,815.0 | 9,410.0 | 11,330.5 |
| Revenue Growth, % | 0 | 22.88 | 129.27 | -7.77 | -33.47 | 20.41 | 20.41 | 20.41 | 20.41 | 20.41 |
| EBITDA | 66.9 | 748.5 | 3,142.0 | 2,223.7 | 233.7 | 1,158.3 | 1,394.7 | 1,679.3 | 2,022.1 | 2,434.8 |
| EBITDA, % | 2.58 | 23.52 | 43.07 | 33.05 | 5.22 | 21.49 | 21.49 | 21.49 | 21.49 | 21.49 |
| Depreciation | 137.5 | 140.8 | 405.1 | 408.5 | 374.5 | 320.5 | 385.9 | 464.6 | 559.4 | 673.6 |
| Depreciation, % | 5.31 | 4.42 | 5.55 | 6.07 | 8.37 | 5.95 | 5.95 | 5.95 | 5.95 | 5.95 |
| EBIT | -70.6 | 607.7 | 2,737.0 | 1,815.2 | -140.8 | 837.8 | 1,008.8 | 1,214.7 | 1,462.6 | 1,761.2 |
| EBIT, % | -2.73 | 19.1 | 37.52 | 26.98 | -3.15 | 15.54 | 15.54 | 15.54 | 15.54 | 15.54 |
| Total Cash | 8.5 | 319.3 | 1,087.6 | 806.0 | 624.2 | 551.9 | 664.5 | 800.1 | 963.4 | 1,160.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 210.2 | 215.3 | 381.5 | 343.3 | 280.2 | 339.3 | 408.6 | 491.9 | 592.3 | 713.2 |
| Account Receivables, % | 8.12 | 6.77 | 5.23 | 5.1 | 6.26 | 6.29 | 6.29 | 6.29 | 6.29 | 6.29 |
| Inventories | 387.1 | 399.8 | 735.9 | 715.8 | 590.3 | 662.2 | 797.3 | 960.0 | 1,156.0 | 1,391.9 |
| Inventories, % | 14.95 | 12.56 | 10.09 | 10.64 | 13.19 | 12.28 | 12.28 | 12.28 | 12.28 | 12.28 |
| Accounts Payable | 111.0 | 149.6 | 285.1 | 298.3 | 289.2 | 256.4 | 308.8 | 371.8 | 447.7 | 539.1 |
| Accounts Payable, % | 4.29 | 4.7 | 3.91 | 4.43 | 6.46 | 4.76 | 4.76 | 4.76 | 4.76 | 4.76 |
| Capital Expenditure | -217.7 | -131.1 | -440.4 | -330.9 | -330.9 | -332.8 | -400.7 | -482.5 | -581.0 | -699.6 |
| Capital Expenditure, % | -8.41 | -4.12 | -6.04 | -4.92 | -7.39 | -6.17 | -6.17 | -6.17 | -6.17 | -6.17 |
| Tax Rate, % | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 |
| EBITAT | -48.4 | 437.3 | 2,069.2 | 1,382.6 | -103.1 | 612.4 | 737.4 | 887.9 | 1,069.1 | 1,287.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -614.8 | 467.7 | 1,667.1 | 1,531.7 | 120.2 | 436.3 | 570.5 | 686.9 | 827.1 | 995.9 |
| WACC, % | 13.6 | 13.61 | 13.61 | 13.61 | 13.61 | 13.61 | 13.61 | 13.61 | 13.61 | 13.61 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,317.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,016 | |||||||||
| Terminal Value | 8,751 | |||||||||
| Present Terminal Value | 4,624 | |||||||||
| Enterprise Value | 6,941 | |||||||||
| Net Debt | -251 | |||||||||
| Equity Value | 7,192 | |||||||||
| Diluted Shares Outstanding, MM | 83 | |||||||||
| Equity Value Per Share | 86.44 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled financials for West Fraser Timber Co. Ltd. (WFG).
- Real-World Insights: Access to historical data and forward-looking projections (highlighted in the yellow cells).
- Forecast Adaptability: Modify key assumptions such as revenue growth, EBITDA %, and WACC as needed.
- Instant Calculations: Quickly observe how your inputs affect West Fraser's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Centric Layout: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as lumber prices, production costs, and market demand.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages West Fraser's actual financial data for credible valuation results.
- Simplified Scenario Analysis: Easily explore various assumptions and evaluate different outcomes.
- Efficiency Booster: Avoid the complexities of constructing detailed valuation models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based WFG DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically computes West Fraser’s intrinsic value.
- Test Scenarios: Simulate various assumptions to assess potential valuation changes.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for West Fraser Timber Co. Ltd. (WFG)?
- All-in-One Solution: Features DCF, WACC, and financial ratio evaluations tailored for the timber industry.
- Flexible Parameters: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes West Fraser's intrinsic value and Net Present Value.
- Preloaded Information: Access to historical and projected data for reliable analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and forestry consultants.
Who Should Use West Fraser Timber Co. Ltd. (WFG)?
- Investors: Gain insights and make informed decisions with a trusted timber industry leader.
- Financial Analysts: Utilize comprehensive data to enhance timber valuation and market analysis.
- Consultants: Leverage industry reports and trends for impactful client presentations and recommendations.
- Environmental Enthusiasts: Explore sustainable forestry practices and their implications on the market.
- Educators and Students: Incorporate real-world case studies into forestry and business education.
What the Template Contains
- Pre-Filled Data: Includes West Fraser Timber Co. Ltd.'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 West Fraser Timber Co. Ltd.'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.