Newmont Corporation (NEM) 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
Newmont Corporation (NEM) Bundle
Looking to determine the intrinsic value of Newmont Corporation? Our NEM (NEM) DCF Calculator integrates real-world data with extensive customization options, allowing you to adjust your forecasts and make more informed investment choices.
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 | 9,740.0 | 11,497.0 | 12,222.0 | 11,915.0 | 11,812.0 | 12,431.2 | 13,082.9 | 13,768.7 | 14,490.5 | 15,250.1 |
Revenue Growth, % | 0 | 18.04 | 6.31 | -2.51 | -0.86446 | 5.24 | 5.24 | 5.24 | 5.24 | 5.24 |
EBITDA | 6,245.0 | 6,100.0 | 5,543.0 | 3,282.0 | -166.0 | 4,690.7 | 4,936.6 | 5,195.4 | 5,467.7 | 5,754.4 |
EBITDA, % | 64.12 | 53.06 | 45.35 | 27.55 | -1.41 | 37.73 | 37.73 | 37.73 | 37.73 | 37.73 |
Depreciation | 2,240.0 | 2,666.0 | 4,169.0 | 3,106.0 | 2,108.0 | 3,088.2 | 3,250.1 | 3,420.5 | 3,599.8 | 3,788.5 |
Depreciation, % | 23 | 23.19 | 34.11 | 26.07 | 17.85 | 24.84 | 24.84 | 24.84 | 24.84 | 24.84 |
EBIT | 4,005.0 | 3,434.0 | 1,374.0 | 176.0 | -2,274.0 | 1,602.5 | 1,686.5 | 1,774.9 | 1,868.0 | 1,965.9 |
EBIT, % | 41.12 | 29.87 | 11.24 | 1.48 | -19.25 | 12.89 | 12.89 | 12.89 | 12.89 | 12.89 |
Total Cash | 2,480.0 | 5,830.0 | 5,074.0 | 3,757.0 | 3,025.0 | 4,346.6 | 4,574.5 | 4,814.3 | 5,066.7 | 5,332.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 373.0 | 449.0 | 337.0 | 366.0 | 1,227.0 | 595.5 | 626.7 | 659.6 | 694.1 | 730.5 |
Account Receivables, % | 3.83 | 3.91 | 2.76 | 3.07 | 10.39 | 4.79 | 4.79 | 4.79 | 4.79 | 4.79 |
Inventories | 1,826.0 | 1,790.0 | 1,787.0 | 1,753.0 | 2,642.0 | 2,138.6 | 2,250.7 | 2,368.7 | 2,492.9 | 2,623.6 |
Inventories, % | 18.75 | 15.57 | 14.62 | 14.71 | 22.37 | 17.2 | 17.2 | 17.2 | 17.2 | 17.2 |
Accounts Payable | 539.0 | 493.0 | 518.0 | 633.0 | 960.0 | 683.7 | 719.6 | 757.3 | 797.0 | 838.8 |
Accounts Payable, % | 5.53 | 4.29 | 4.24 | 5.31 | 8.13 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 |
Capital Expenditure | -1,463.0 | -1,302.0 | -1,653.0 | -2,131.0 | -2,666.0 | -1,997.1 | -2,101.8 | -2,211.9 | -2,327.9 | -2,449.9 |
Capital Expenditure, % | -15.02 | -11.32 | -13.52 | -17.89 | -22.57 | -16.07 | -16.07 | -16.07 | -16.07 | -16.07 |
Tax Rate, % | -24.13 | -24.13 | -24.13 | -24.13 | -24.13 | -24.13 | -24.13 | -24.13 | -24.13 | -24.13 |
EBITAT | 3,042.0 | 3,090.9 | 12.4 | 1,746.2 | -2,822.6 | 1,175.8 | 1,237.5 | 1,302.3 | 1,370.6 | 1,442.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2,159.0 | 4,368.9 | 2,668.4 | 2,841.2 | -4,803.6 | 3,125.6 | 2,278.3 | 2,397.7 | 2,523.4 | 2,655.7 |
WACC, % | 6.14 | 6.28 | 5.37 | 6.38 | 6.38 | 6.11 | 6.11 | 6.11 | 6.11 | 6.11 |
PV UFCF | ||||||||||
SUM PV UFCF | 10,940.1 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 2,762 | |||||||||
Terminal Value | 130,764 | |||||||||
Present Terminal Value | 97,199 | |||||||||
Enterprise Value | 108,139 | |||||||||
Net Debt | 6,434 | |||||||||
Equity Value | 101,705 | |||||||||
Diluted Shares Outstanding, MM | 841 | |||||||||
Equity Value Per Share | 120.93 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real NEM financials.
- Authentic Data: Historical performance metrics and forward-looking projections (highlighted in the yellow cells).
- Flexible Forecasting: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Newmont Corporation’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
- Real-Time NEM Data: Pre-loaded with Newmont Corporation’s historical financials and future projections.
- Comprehensive Customization: Modify inputs such as production rates, gold prices, operating costs, and capital investments.
- Interactive Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecast scenarios to evaluate different valuation results.
- Intuitive Interface: Designed to be accessible and efficient for both seasoned professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Newmont Corporation’s (NEM) pre-filled financial data and forecasts.
- Step 3: Adjust key inputs such as gold production estimates, operating costs, and capital expenditures (highlighted cells).
- Step 4: Observe the DCF model refresh in real-time as you change your assumptions.
- Step 5: Evaluate the results and utilize the findings for your investment strategies.
Why Choose Newmont Corporation (NEM)?
- Proven Track Record: A leader in the gold mining industry with a history of successful operations.
- Commitment to Sustainability: Focused on responsible mining practices and environmental stewardship.
- Strong Financial Performance: Consistent revenue growth and robust cash flow generation.
- Innovative Technology: Utilizing advanced mining techniques to enhance efficiency and productivity.
- Experienced Leadership: Guided by a team of industry veterans dedicated to driving value for shareholders.
Who Should Use This Product?
- Mining Students: Understand resource valuation techniques and apply them to real-world mining data.
- Researchers: Integrate industry-standard models into your academic projects or studies.
- Investors: Evaluate your investment strategies and assess valuation outcomes for Newmont Corporation (NEM).
- Financial Analysts: Enhance your analysis with a customizable DCF model tailored for mining companies.
- Industry Professionals: Learn how large mining firms like Newmont Corporation (NEM) are evaluated in the market.
What the Template Contains
- Pre-Filled DCF Model: Newmont Corporation’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Newmont Corporation’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.