IRSA Inversiones y Representaciones Sociedad Anónima (IRS) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
IRSA Inversiones y Representaciones Sociedad Anónima (IRS) Bundle
Designed for accuracy, our (IRS) DCF Calculator empowers you to assess the valuation of IRSA Inversiones y Representaciones Sociedad Anónima using real-world financial data, offering complete flexibility to modify all key parameters for enhanced projections.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 93.6 | 12.7 | 31.4 | 87.3 | 321.1 | 492.5 | 755.4 | 1,158.7 | 1,777.2 | 2,726.0 |
Revenue Growth, % | 0 | -86.45 | 147.23 | 178.28 | 267.97 | 53.39 | 53.39 | 53.39 | 53.39 | 53.39 |
EBITDA | 96.3 | -3.7 | 13.2 | 38.1 | -32.5 | 144.4 | 221.5 | 339.7 | 521.1 | 799.3 |
EBITDA, % | 102.82 | -29.1 | 42.13 | 43.69 | -10.12 | 29.32 | 29.32 | 29.32 | 29.32 | 29.32 |
Depreciation | 105.8 | 10.7 | 19.2 | 58.1 | 6.4 | 309.7 | 475.0 | 728.6 | 1,117.6 | 1,714.2 |
Depreciation, % | 113.05 | 84.67 | 61.18 | 66.57 | 1.99 | 62.88 | 62.88 | 62.88 | 62.88 | 62.88 |
EBIT | -9.6 | -14.4 | -6.0 | -20.0 | -38.9 | -161.8 | -248.2 | -380.7 | -583.9 | -895.6 |
EBIT, % | -10.23 | -113.77 | -19.05 | -22.88 | -12.11 | -32.85 | -32.85 | -32.85 | -32.85 | -32.85 |
Total Cash | 110.6 | 5.0 | 30.5 | 42.2 | 145.6 | 325.3 | 498.9 | 765.2 | 1,173.8 | 1,800.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 55.0 | 13.8 | 22.9 | 96.6 | 75.5 | 350.0 | 536.9 | 823.5 | 1,263.2 | 1,937.5 |
Account Receivables, % | 58.72 | 109.18 | 73.13 | 110.7 | 23.52 | 71.07 | 71.07 | 71.07 | 71.07 | 71.07 |
Inventories | 6.8 | .2 | .3 | .5 | 1.5 | 10.6 | 16.2 | 24.8 | 38.1 | 58.4 |
Inventories, % | 7.31 | 1.43 | 0.99112 | 0.532 | 0.45382 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 |
Accounts Payable | 43.6 | 8.2 | 18.0 | 93.0 | 71.0 | 286.0 | 438.7 | 672.9 | 1,032.2 | 1,583.3 |
Accounts Payable, % | 46.52 | 64.48 | 57.27 | 106.54 | 22.12 | 58.08 | 58.08 | 58.08 | 58.08 | 58.08 |
Capital Expenditure | -8.7 | -.4 | -.4 | -.9 | -4.0 | -15.4 | -23.6 | -36.2 | -55.6 | -85.2 |
Capital Expenditure, % | -9.34 | -2.77 | -1.25 | -1.05 | -1.23 | -3.13 | -3.13 | -3.13 | -3.13 | -3.13 |
Tax Rate, % | 63.66 | 63.66 | 63.66 | 63.66 | 63.66 | 63.66 | 63.66 | 63.66 | 63.66 | 63.66 |
EBITAT | -4.3 | -59.1 | -5.5 | 340.6 | -14.1 | -88.4 | -135.6 | -208.0 | -319.0 | -489.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 74.5 | -36.3 | 13.9 | 399.0 | -13.5 | 137.3 | 276.0 | 423.3 | 649.3 | 996.0 |
WACC, % | 9.29 | 9.47 | 9.45 | 9.14 | 9.26 | 9.32 | 9.32 | 9.32 | 9.32 | 9.32 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,772.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,016 | |||||||||
Terminal Value | 13,874 | |||||||||
Present Terminal Value | 8,885 | |||||||||
Enterprise Value | 10,658 | |||||||||
Net Debt | 341 | |||||||||
Equity Value | 10,317 | |||||||||
Diluted Shares Outstanding, MM | 742 | |||||||||
Equity Value Per Share | 13.90 |
What You Will Get
- Comprehensive IRS Data: Preloaded financial metrics – from revenue to EBIT – based on actual and projected figures for IRSA Inversiones y Representaciones Sociedad Anónima (IRS).
- Full Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates to suit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on the fair value of IRSA (IRS).
- Flexible Excel Template: Designed for quick edits, scenario testing, and in-depth projections tailored to IRSA.
- Time-Saving and Accurate: Eliminate the need to build models from scratch while ensuring precision and adaptability.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and various financial metrics.
- High-Precision Accuracy: Leverages IRSA’s actual financial data for credible valuation results.
- Simplified Scenario Analysis: Evaluate different scenarios and analyze results effortlessly.
- Efficiency Booster: Removes the necessity of creating intricate valuation models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based IRSA DCF Calculator for (IRS).
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh to display IRSA's intrinsic value.
- Test Scenarios: Experiment with various assumptions to see how they impact valuation.
- Analyze and Decide: Leverage the results to inform your investment strategies or financial assessments.
Why Choose This Calculator for IRSA Inversiones y Representaciones Sociedad Anónima (IRS)?
- Designed for Experts: A sophisticated tool tailored for financial analysts, investors, and corporate strategists.
- Accurate Data: Historical and projected financials for IRSA (IRS) preloaded to ensure precision.
- Flexible Scenario Analysis: Easily test various forecasts and assumptions to gauge potential outcomes.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Detailed step-by-step instructions make navigation a breeze.
Who Should Use This Product?
- Finance Students: Explore investment strategies and apply them to real market scenarios involving IRSA Inversiones y Representaciones Sociedad Anónima (IRS).
- Academics: Utilize advanced financial models in your research or educational programs focused on real estate and investment.
- Investors: Validate your investment hypotheses and analyze the financial performance of IRSA Inversiones y Representaciones Sociedad Anónima (IRS).
- Analysts: Enhance your analysis process with a user-friendly, customizable financial model tailored for IRSA Inversiones y Representaciones Sociedad Anónima (IRS).
- Small Business Owners: Understand the evaluation methods used for large investment firms like IRSA Inversiones y Representaciones Sociedad Anónima (IRS).
What the Template Contains
- Pre-Filled Data: Includes IRSA Inversiones y Representaciones Sociedad Anónima’s (IRS) 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 IRSA’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.