G. Willi-Food International Ltd. (WILC) 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
G. Willi-Food International Ltd. (WILC) Bundle
Discover the true value of G. Willi-Food International Ltd. (WILC) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect G. Willi-Food International Ltd. (WILC) valuation – all within a single Excel template.
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 | 107.7 | 123.6 | 123.6 | 135.7 | 147.9 | 160.3 | 173.7 | 188.3 | 204.1 | 221.2 |
| Revenue Growth, % | 0 | 14.78 | 0.02620603 | 9.71 | 9.02 | 8.38 | 8.38 | 8.38 | 8.38 | 8.38 |
| EBITDA | 10.5 | 17.2 | 15.1 | 12.3 | 6.8 | 15.9 | 17.2 | 18.6 | 20.2 | 21.9 |
| EBITDA, % | 9.71 | 13.93 | 12.23 | 9.05 | 4.58 | 9.9 | 9.9 | 9.9 | 9.9 | 9.9 |
| Depreciation | 1.3 | 1.5 | 1.7 | 1.8 | 1.2 | 1.9 | 2.1 | 2.3 | 2.4 | 2.6 |
| Depreciation, % | 1.22 | 1.25 | 1.36 | 1.31 | 0.8368 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
| EBIT | 9.2 | 15.7 | 13.4 | 10.5 | 5.5 | 14.0 | 15.1 | 16.4 | 17.8 | 19.3 |
| EBIT, % | 8.5 | 12.68 | 10.87 | 7.74 | 3.75 | 8.71 | 8.71 | 8.71 | 8.71 | 8.71 |
| Total Cash | 71.7 | 97.1 | 95.2 | 72.8 | 65.2 | 102.5 | 111.1 | 120.5 | 130.6 | 141.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 36.2 | 35.7 | 38.7 | 46.5 | 43.7 | 50.5 | 54.8 | 59.4 | 64.3 | 69.7 |
| Account Receivables, % | 33.63 | 28.91 | 31.29 | 34.31 | 29.52 | 31.53 | 31.53 | 31.53 | 31.53 | 31.53 |
| Inventories | 19.5 | 16.2 | 16.2 | 19.6 | 17.0 | 22.5 | 24.4 | 26.4 | 28.7 | 31.1 |
| Inventories, % | 18.08 | 13.11 | 13.11 | 14.43 | 11.5 | 14.05 | 14.05 | 14.05 | 14.05 | 14.05 |
| Accounts Payable | 6.7 | 6.4 | 5.5 | 6.8 | 5.9 | 8.0 | 8.6 | 9.4 | 10.1 | 11.0 |
| Accounts Payable, % | 6.23 | 5.17 | 4.49 | 4.99 | 3.98 | 4.97 | 4.97 | 4.97 | 4.97 | 4.97 |
| Capital Expenditure | -.5 | -.8 | -1.7 | -3.6 | -6.4 | -3.0 | -3.3 | -3.6 | -3.9 | -4.2 |
| Capital Expenditure, % | -0.45269 | -0.63929 | -1.37 | -2.68 | -4.33 | -1.89 | -1.89 | -1.89 | -1.89 | -1.89 |
| Tax Rate, % | 19.23 | 19.23 | 19.23 | 19.23 | 19.23 | 19.23 | 19.23 | 19.23 | 19.23 | 19.23 |
| EBITAT | 7.2 | 12.1 | 10.5 | 8.1 | 4.5 | 10.9 | 11.9 | 12.8 | 13.9 | 15.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -40.9 | 16.3 | 6.7 | -3.8 | 3.9 | -.5 | 5.2 | 5.6 | 6.1 | 6.6 |
| WACC, % | 8.71 | 8.71 | 8.71 | 8.7 | 8.71 | 8.71 | 8.71 | 8.71 | 8.71 | 8.71 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 17.0 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 7 | |||||||||
| Terminal Value | 81 | |||||||||
| Present Terminal Value | 53 | |||||||||
| Enterprise Value | 70 | |||||||||
| Net Debt | -37 | |||||||||
| Equity Value | 107 | |||||||||
| Diluted Shares Outstanding, MM | 14 | |||||||||
| Equity Value Per Share | 7.72 |
What You Will Get
- Comprehensive WILC Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess G. Willi-Food's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for G. Willi-Food International Ltd. (WILC).
- WACC Calculator: Comes with a pre-built Weighted Average Cost of Capital sheet that allows for customizable inputs specific to G. Willi-Food.
- Adjustable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit G. Willi-Food's financial strategies.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to G. Willi-Food International Ltd. (WILC).
- Interactive Dashboard and Charts: Visual representations provide a summary of key valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file for G. Willi-Food International Ltd. (WILC).
- Step 2: Review the pre-filled financial data and forecasts specific to G. Willi-Food International Ltd. (WILC).
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for G. Willi-Food International Ltd. (WILC)?
- Accurate Data: Utilize real financials from G. Willi-Food for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the effort of starting from the ground up.
- Professional-Grade Tool: Created for investors, analysts, and consultants in the food industry.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing G. Willi-Food International Ltd. (WILC) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Offer clients precise valuation insights related to G. Willi-Food International Ltd. (WILC) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Food Industry Enthusiasts: Gain insights into how food companies like G. Willi-Food International Ltd. (WILC) are assessed in the market.
What the Template Contains
- Preloaded WILC Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.