Nomad Foods Limited (NOMD) 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
Nomad Foods Limited (NOMD) Bundle
Whether you’re an investor or an analyst, this (NOMD) DCF Calculator is your go-to tool for accurate valuation. Loaded with real data from Nomad Foods Limited, you can adjust forecasts and immediately observe the effects.
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,422.3 | 2,622.0 | 2,716.5 | 3,063.7 | 3,172.9 | 3,396.5 | 3,635.9 | 3,892.2 | 4,166.5 | 4,460.2 |
Revenue Growth, % | 0 | 8.24 | 3.61 | 12.78 | 3.56 | 7.05 | 7.05 | 7.05 | 7.05 | 7.05 |
EBITDA | 376.6 | 447.9 | 479.1 | 513.0 | 500.8 | 562.4 | 602.1 | 644.5 | 689.9 | 738.6 |
EBITDA, % | 15.55 | 17.08 | 17.64 | 16.74 | 15.78 | 16.56 | 16.56 | 16.56 | 16.56 | 16.56 |
Depreciation | 71.0 | 65.6 | 77.6 | 90.7 | 99.0 | 97.6 | 104.5 | 111.9 | 119.7 | 128.2 |
Depreciation, % | 2.93 | 2.5 | 2.86 | 2.96 | 3.12 | 2.87 | 2.87 | 2.87 | 2.87 | 2.87 |
EBIT | 305.7 | 382.3 | 401.5 | 422.3 | 401.8 | 464.8 | 497.6 | 532.6 | 570.2 | 610.4 |
EBIT, % | 12.62 | 14.58 | 14.78 | 13.78 | 12.66 | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 |
Total Cash | 887.0 | 435.8 | 264.9 | 385.3 | 430.1 | 605.4 | 648.1 | 693.8 | 742.7 | 795.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 149.7 | 147.2 | 190.5 | 220.1 | 217.1 | 223.0 | 238.7 | 255.6 | 273.6 | 292.9 |
Account Receivables, % | 6.18 | 5.61 | 7.01 | 7.18 | 6.84 | 6.57 | 6.57 | 6.57 | 6.57 | 6.57 |
Inventories | 336.8 | 357.7 | 427.9 | 476.4 | 465.2 | 499.4 | 534.6 | 572.2 | 612.6 | 655.7 |
Inventories, % | 13.91 | 13.64 | 15.75 | 15.55 | 14.66 | 14.7 | 14.7 | 14.7 | 14.7 | 14.7 |
Accounts Payable | 381.3 | 472.5 | 528.4 | 517.6 | 496.2 | 582.5 | 623.6 | 667.5 | 714.5 | 764.9 |
Accounts Payable, % | 15.74 | 18.02 | 19.45 | 16.9 | 15.64 | 17.15 | 17.15 | 17.15 | 17.15 | 17.15 |
Capital Expenditure | -49.3 | -61.2 | -82.5 | -82.4 | -85.9 | -87.0 | -93.1 | -99.7 | -106.7 | -114.2 |
Capital Expenditure, % | -2.04 | -2.33 | -3.04 | -2.69 | -2.71 | -2.56 | -2.56 | -2.56 | -2.56 | -2.56 |
Tax Rate, % | 24.01 | 24.01 | 24.01 | 24.01 | 24.01 | 24.01 | 24.01 | 24.01 | 24.01 | 24.01 |
EBITAT | 223.8 | 291.3 | 307.0 | 328.6 | 305.3 | 353.0 | 377.9 | 404.5 | 433.0 | 463.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 140.4 | 368.7 | 244.3 | 248.1 | 311.1 | 409.9 | 379.4 | 406.1 | 434.8 | 465.4 |
WACC, % | 6.54 | 6.62 | 6.62 | 6.66 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,728.0 | |||||||||
Long Term Growth Rate, % | 1.00 | |||||||||
Free cash flow (T + 1) | 470 | |||||||||
Terminal Value | 8,381 | |||||||||
Present Terminal Value | 6,086 | |||||||||
Enterprise Value | 7,814 | |||||||||
Net Debt | 1,809 | |||||||||
Equity Value | 6,005 | |||||||||
Diluted Shares Outstanding, MM | 171 | |||||||||
Equity Value Per Share | 35.07 |
What You Will Receive
- Adjustable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Nomad Foods Limited’s (NOMD) financial data pre-loaded to facilitate your analysis.
- Automated DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that tailors to your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing efficiency.
Key Features
- Real-Life NOMD Data: Pre-filled with Nomad Foods Limited's historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop various forecasting scenarios to evaluate different valuation possibilities.
- User-Friendly Design: Intuitive layout, crafted for both professionals and newcomers.
How It Functions
- Download the Template: Gain immediate access to the Excel-based NOMD DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Nomad Foods' intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial decisions.
Why Choose This Calculator for Nomad Foods Limited (NOMD)?
- Accuracy: Utilizes real Nomad Foods financial data to ensure precision.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Designed for simplicity, making it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Assess Nomad Foods Limited's (NOMD) valuation prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts.
- Startup Founders: Understand the valuation approaches of established companies like Nomad Foods Limited.
- Consultants: Provide comprehensive valuation analyses and reports for clients.
- Students and Educators: Utilize real-time data to enhance learning and instruction in valuation practices.
What the Template Contains
- Pre-Filled Data: Includes Nomad Foods Limited’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 Nomad Foods Limited’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.