Weyerhaeuser Company (WY) DCF Valuation

Weyerhaeuser Company (WY) 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

Weyerhaeuser Company (WY) 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:

Explore Weyerhaeuser Company's (WY) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Weyerhaeuser Company (WY) 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 6,554.0 7,532.0 10,201.0 10,184.0 7,674.0 8,164.1 8,685.4 9,240.1 9,830.2 10,458.0
Revenue Growth, % 0 14.92 35.44 -0.16665 -24.65 6.39 6.39 6.39 6.39 6.39
EBITDA 755.0 1,716.0 4,021.0 3,526.0 1,717.0 2,134.4 2,270.7 2,415.7 2,570.0 2,734.1
EBITDA, % 11.52 22.78 39.42 34.62 22.37 26.14 26.14 26.14 26.14 26.14
Depreciation 5,880.0 5,924.0 6,636.0 7,083.0 500.0 5,053.3 5,376.0 5,719.4 6,084.6 6,473.2
Depreciation, % 89.72 78.65 65.05 69.55 6.52 61.9 61.9 61.9 61.9 61.9
EBIT -5,125.0 -4,208.0 -2,615.0 -3,557.0 1,217.0 -2,919.0 -3,105.4 -3,303.7 -3,514.6 -3,739.1
EBIT, % -78.2 -55.87 -25.63 -34.93 15.86 -35.75 -35.75 -35.75 -35.75 -35.75
Total Cash 139.0 495.0 1,879.0 1,581.0 1,164.0 943.8 1,004.1 1,068.2 1,136.5 1,209.0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 407.0 532.0 507.0 399.0 364.0
Account Receivables, % 6.21 7.06 4.97 3.92 4.74
Inventories 416.0 443.0 520.0 550.0 566.0 491.5 522.9 556.3 591.8 629.6
Inventories, % 6.35 5.88 5.1 5.4 7.38 6.02 6.02 6.02 6.02 6.02
Accounts Payable 246.0 204.0 281.0 247.0 287.0 251.2 267.2 284.3 302.4 321.7
Accounts Payable, % 3.75 2.71 2.75 2.43 3.74 3.08 3.08 3.08 3.08 3.08
Capital Expenditure -384.0 -706.0 -590.0 -763.0 -680.0 -610.2 -649.1 -690.6 -734.7 -781.6
Capital Expenditure, % -5.86 -9.37 -5.78 -7.49 -8.86 -7.47 -7.47 -7.47 -7.47 -7.47
Tax Rate, % 10.46 10.46 10.46 10.46 10.46 10.46 10.46 10.46 10.46 10.46
EBITAT -1,828.6 -3,415.3 -2,055.9 -2,901.2 1,089.7 -2,140.0 -2,276.6 -2,422.0 -2,576.7 -2,741.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 3,090.4 1,608.7 4,015.1 3,462.8 968.7 2,266.5 2,406.9 2,560.6 2,724.1 2,898.1
WACC, % 9.36 9.85 9.83 9.86 9.94 9.77 9.77 9.77 9.77 9.77
PV UFCF
SUM PV UFCF 9,693.6
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 2,985
Terminal Value 44,111
Present Terminal Value 27,681
Enterprise Value 37,375
Net Debt 3,924
Equity Value 33,451
Diluted Shares Outstanding, MM 732
Equity Value Per Share 45.68

What You Will Get

  • Authentic WY Financials: Provides historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Real-Time Calculations: Intrinsic value and NPV are computed automatically.
  • Scenario Analysis: Evaluate various scenarios to assess Weyerhaeuser's future performance.
  • User-Friendly Design: Designed for industry professionals while remaining accessible for newcomers.

Key Features

  • Customizable Timber Metrics: Adjust essential factors like lumber prices, production volume, and operating costs.
  • Instant DCF Valuation: Quickly determines intrinsic value, NPV, and other financial outputs.
  • Industry-Leading Precision: Incorporates Weyerhaeuser’s actual financial data for accurate valuation results.
  • Effortless Scenario Analysis: Evaluate various assumptions and assess outcomes with ease.
  • Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.

How It Works

  • Download: Obtain the pre-configured Excel file featuring Weyerhaeuser Company's (WY) financial data.
  • Customize: Modify projections such as revenue growth, EBITDA %, and WACC to fit your analysis.
  • Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Generate various forecasts and instantly compare the results.
  • Make Decisions: Leverage the valuation insights to inform your investment choices.

Why Choose Weyerhaeuser Company (WY)?

  • Save Time: Access ready-to-use resources without the hassle of starting from scratch.
  • Enhance Accuracy: Dependable data and methodologies minimize errors in your assessments.
  • Fully Customizable: Adjust models to align with your specific assumptions and forecasts.
  • Easy to Understand: Intuitive visuals and outputs simplify the analysis of results.
  • Trusted by Professionals: Crafted for those who prioritize precision and functionality.

Who Should Use Weyerhaeuser Company (WY)?

  • Investors: Gain insights into sustainable forestry practices and long-term growth potential.
  • Environmental Analysts: Access data on Weyerhaeuser's commitment to responsible land management and conservation.
  • Consultants: Utilize the company's performance metrics for strategic planning and client advisories.
  • Industry Enthusiasts: Explore innovative timber products and their impact on the market.
  • Educators and Students: Employ case studies from Weyerhaeuser in environmental science and business courses.

What the Template Contains

  • Historical Data: Includes Weyerhaeuser Company’s (WY) past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Weyerhaeuser Company’s (WY) 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 Weyerhaeuser Company’s (WY) financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.