Cresud Sociedad Anónima, Comercial, Inmobiliaria, Financiera y Agropecuaria (CRESY) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Cresud Sociedad Anónima, Comercial, Inmobiliaria, Financiera y Agropecuaria (CRESY) Bundle
As an investor or analyst, this (CRESY) DCF Calculator is your go-to resource for accurate valuation. Featuring real data from Cresud Sociedad Anónima, Comercial, Inmobiliaria, Financiera y Agropecuaria, 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 | 80.3 | 146.4 | 201.8 | 186.0 | 694.8 | 1,063.5 | 1,627.8 | 2,491.6 | 3,813.8 | 5,837.7 |
Revenue Growth, % | 0 | 82.3 | 37.82 | -7.85 | 273.61 | 53.07 | 53.07 | 53.07 | 53.07 | 53.07 |
EBITDA | 101.6 | 39.2 | 52.8 | 111.1 | 101.2 | 483.3 | 739.8 | 1,132.4 | 1,733.3 | 2,653.0 |
EBITDA, % | 126.49 | 26.76 | 26.19 | 59.73 | 14.56 | 45.45 | 45.45 | 45.45 | 45.45 | 45.45 |
Depreciation | 4.7 | 2.9 | 2.6 | 2.6 | 10.3 | 25.6 | 39.2 | 59.9 | 91.7 | 140.4 |
Depreciation, % | 5.88 | 1.96 | 1.29 | 1.41 | 1.49 | 2.41 | 2.41 | 2.41 | 2.41 | 2.41 |
EBIT | 96.9 | 36.3 | 50.2 | 108.4 | 90.8 | 470.2 | 719.8 | 1,101.7 | 1,686.3 | 2,581.2 |
EBIT, % | 120.62 | 24.8 | 24.9 | 58.31 | 13.07 | 44.22 | 44.22 | 44.22 | 44.22 | 44.22 |
Total Cash | 179.7 | 46.4 | 113.7 | 80.8 | 254.7 | 570.2 | 872.8 | 1,336.0 | 2,045.0 | 3,130.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 64.6 | 36.7 | 70.3 | 286.5 | 257.8 | 589.9 | 903.0 | 1,382.1 | 2,115.6 | 3,238.2 |
Account Receivables, % | 80.4 | 25.03 | 34.82 | 154.08 | 37.11 | 55.47 | 55.47 | 55.47 | 55.47 | 55.47 |
Inventories | 17.4 | 28.1 | 47.7 | 45.8 | 170.9 | 241.7 | 369.9 | 566.3 | 866.8 | 1,326.7 |
Inventories, % | 21.63 | 19.16 | 23.61 | 24.64 | 24.6 | 22.73 | 22.73 | 22.73 | 22.73 | 22.73 |
Accounts Payable | 52.6 | 31.4 | 65.1 | 275.5 | 242.7 | 540.3 | 827.0 | 1,265.9 | 1,937.7 | 2,965.9 |
Accounts Payable, % | 65.42 | 21.42 | 32.26 | 148.16 | 34.93 | 50.81 | 50.81 | 50.81 | 50.81 | 50.81 |
Capital Expenditure | -3.5 | -7.3 | -8.7 | -18.1 | -78.7 | -73.9 | -113.2 | -173.3 | -265.2 | -405.9 |
Capital Expenditure, % | -4.41 | -4.97 | -4.32 | -9.75 | -11.32 | -6.95 | -6.95 | -6.95 | -6.95 | -6.95 |
Tax Rate, % | -144.36 | -144.36 | -144.36 | -144.36 | -144.36 | -144.36 | -144.36 | -144.36 | -144.36 | -144.36 |
EBITAT | 12.4 | -39.0 | 28.7 | 871.6 | 222.0 | 253.8 | 388.5 | 594.6 | 910.2 | 1,393.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -15.8 | -47.4 | 3.1 | 852.1 | 24.5 | 100.1 | 159.9 | 244.7 | 374.5 | 573.3 |
WACC, % | 9.19 | 9.11 | 9.45 | 9.71 | 9.71 | 9.43 | 9.43 | 9.43 | 9.43 | 9.43 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,038.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 585 | |||||||||
Terminal Value | 7,870 | |||||||||
Present Terminal Value | 5,015 | |||||||||
Enterprise Value | 6,053 | |||||||||
Net Debt | 769 | |||||||||
Equity Value | 5,284 | |||||||||
Diluted Shares Outstanding, MM | 702 | |||||||||
Equity Value Per Share | 7.53 |
What You Will Receive
- Adjustable Forecast Parameters: Effortlessly modify key inputs (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Financial Data: Cresud’s financial information pre-loaded to facilitate your analysis.
- Automated DCF Calculations: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Tailored and Professional Design: A refined Excel model that meets your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Authentic Cresud Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries designed to help you visualize your valuation outcomes.
- Suitable for All Levels: An easy-to-navigate structure tailored for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the comprehensive Excel file containing Cresud Sociedad Anónima’s (CRESY) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare results.
- Make Decisions: Leverage the valuation findings to inform your investment choices.
Why Choose This Calculator for Cresud (CRESY)?
- User-Friendly Interface: Tailored for both novice and experienced users.
- Customizable Inputs: Adjust parameters to suit your financial analysis needs.
- Real-Time Feedback: Observe immediate changes in Cresud’s valuation as you update inputs.
- Pre-Loaded Data: Comes with Cresud’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Employed by investors and analysts for strategic decision-making.
Who Should Use This Product?
- Investors: Accurately assess Cresud’s fair value before making investment decisions in (CRESY).
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis related to (CRESY).
- Consultants: Easily modify the template for valuation reports tailored to clients interested in (CRESY).
- Entrepreneurs: Acquire knowledge of financial modeling techniques employed by leading agricultural companies like (CRESY).
- Educators: Implement it as a teaching resource to illustrate valuation methodologies applicable to (CRESY).
What the Cresud Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: Cresud's (CRESY) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results.