IRSA Inversiones y Representaciones Sociedad Anónima (IRS) DCF Valuation

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

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 58.72 109.18 73.13 110.7 23.52
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

  1. Download the Template: Gain immediate access to the Excel-based IRSA DCF Calculator for (IRS).
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
  3. Instant Calculations: The model will automatically refresh to display IRSA's intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to see how they impact valuation.
  5. 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.