Indraprastha Gas Limited (IGLNS) DCF Valuation

Indraprastha Gas Limited (IGL.NS) DCF -Bewertung

IN | Utilities | Regulated Gas | NSE
Indraprastha Gas Limited (IGLNS) 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

Indraprastha Gas Limited (IGL.NS) Bundle

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

TOTAL:

Unser (IGLNS) DCF-Taschenrechner (IGLNS) ermöglicht es Ihnen, die Bewertung von Indraprastha Gas Limited mithilfe realer Finanzdaten zu bewerten und vollständige Flexibilität zu bieten, um alle wesentlichen Parameter für verbesserte Projektionen zu ändern.


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 64,510.7 49,110.3 76,680.6 141,458.5 140,000.2 136,618.1 133,317.7 130,097.0 126,954.1 123,887.2
Revenue Growth, % 0 -23.87 56.14 84.48 -1.03 -2.42 -2.42 -2.42 -2.42 -2.42
EBITDA 16,612.4 16,060.6 20,650.4 22,589.4 29,632.7 33,476.9 32,668.2 31,879.0 31,108.8 30,357.3
EBITDA, % 25.75 32.7 26.93 15.97 21.17 24.5 24.5 24.5 24.5 24.5
Depreciation 2,522.5 2,903.9 3,170.6 3,633.6 4,139.6 5,323.6 5,195.0 5,069.5 4,947.0 4,827.5
Depreciation, % 3.91 5.91 4.13 2.57 2.96 3.9 3.9 3.9 3.9 3.9
EBIT 14,089.9 13,156.7 17,479.8 18,955.8 25,493.1 28,153.3 27,473.2 26,809.5 26,161.8 25,529.8
EBIT, % 21.84 26.79 22.8 13.4 18.21 20.61 20.61 20.61 20.61 20.61
Total Cash 21,677.0 26,891.0 30,607.2 31,972.1 30,096.6 47,098.5 45,960.7 44,850.4 43,766.9 42,709.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 2,372.9 3,298.3 6,116.7 10,481.3 11,308.4
Account Receivables, % 3.68 6.72 7.98 7.41 8.08
Inventories 511.1 455.5 455.2 491.7 522.3 829.0 809.0 789.4 770.4 751.8
Inventories, % 0.79227 0.9275 0.59363 0.34759 0.37307 0.60681 0.60681 0.60681 0.60681 0.60681
Accounts Payable 2,249.6 4,186.0 7,861.1 9,013.3 9,843.1 9,745.0 9,509.6 9,279.8 9,055.7 8,836.9
Accounts Payable, % 3.49 8.52 10.25 6.37 7.03 7.13 7.13 7.13 7.13 7.13
Capital Expenditure -9,632.2 -8,829.2 -13,369.5 -11,220.5 -12,290.5 -18,322.0 -17,879.4 -17,447.5 -17,026.0 -16,614.7
Capital Expenditure, % -14.93 -17.98 -17.44 -7.93 -8.78 -13.41 -13.41 -13.41 -13.41 -13.41
Tax Rate, % 21.92 21.92 21.92 21.92 21.92 21.92 21.92 21.92 21.92 21.92
EBITAT 11,306.2 10,849.5 13,444.3 16,123.0 19,903.9 22,677.6 22,129.7 21,595.1 21,073.4 20,564.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 3,562.1 5,990.8 4,102.4 5,287.2 11,725.1 11,331.4 9,453.4 9,225.0 9,002.2 8,784.7
WACC, % 7.55 7.56 7.55 7.56 7.55 7.56 7.56 7.56 7.56 7.56
PV UFCF
SUM PV UFCF 38,951.9
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 9,048
Terminal Value 198,627
Present Terminal Value 137,999
Enterprise Value 176,951
Net Debt -1,379
Equity Value 178,330
Diluted Shares Outstanding, MM 700
Equity Value Per Share 254.76

What You Will Receive

  • Authentic IGLNS Financial Data: Access to historical and projected figures for precise valuation.
  • Customizable Parameters: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
  • Dynamic Calculations: Intrinsic value and NPV are computed automatically.
  • Scenario Testing: Assess various scenarios to forecast Indraprastha Gas Limited's future performance.
  • User-Friendly Interface: Designed for professionals, yet easy for newcomers to navigate.

Key Features

  • 🔍 Real-Life IGLNS Financials: Pre-filled historical and projected data for Indraprastha Gas Limited.
  • ✏️ Fully Customizable Inputs: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Utilizes built-in formulas to determine Indraprastha Gas’s intrinsic value via the Discounted Cash Flow method.
  • ⚡ Instant Results: View Indraprastha Gas’s valuation immediately after adjustments.
  • Scenario Analysis: Evaluate and contrast outcomes for different financial assumptions side-by-side.

How It Works

  • Download: Get the pre-configured Excel file featuring Indraprastha Gas Limited's (IGLNS) financial data.
  • Customize: Modify projections such as revenue growth, EBITDA %, and WACC to suit your analysis.
  • Update Automatically: Enjoy real-time updates on intrinsic value and NPV calculations as you make changes.
  • Test Scenarios: Generate various forecasts and immediately compare the results side by side.
  • Make Decisions: Leverage the valuation insights to inform your investment choices.

Why Opt for IGLNS Calculator?

  • Precision: Utilizes authentic Indraprastha Gas Limited financials for reliable data.
  • Adaptability: Built to allow users to experiment and alter inputs as needed.
  • Efficiency: Avoid the complexities of creating a DCF model from the ground up.
  • Corporate-Standard: Crafted with the accuracy and functionality expected at the CFO level.
  • Intuitive: Simple to navigate, making it accessible for users without advanced financial expertise.

Who Should Use This Product?

  • Individual Investors: Make informed choices about trading Indraprastha Gas Limited (IGLNS) shares.
  • Financial Analysts: Enhance valuation procedures with comprehensive financial models tailored for IGLNS.
  • Consultants: Provide clients with accurate and prompt valuation insights for Indraprastha Gas Limited (IGLNS).
  • Business Owners: Gain insights into how large firms like Indraprastha Gas Limited (IGLNS) are valued to inform your own business strategies.
  • Finance Students: Acquire valuation skills using real-world data and case studies related to Indraprastha Gas Limited (IGLNS).

Contents of the Template

  • Historical Data: Encompasses IGLNS's previous financial performance and initial forecasts.
  • DCF and Levered DCF Models: Comprehensive templates designed to determine IGLNS's intrinsic value.
  • WACC Sheet: Ready-to-use calculations for the Weighted Average Cost of Capital.
  • Editable Inputs: Adjust essential parameters such as growth rates, EBITDA percentages, and CAPEX estimates.
  • Quarterly and Annual Statements: An in-depth overview of IGLNS's financial statements.
  • Interactive Dashboard: Dynamically visualize valuation outcomes and forecasts.


Disclaimer

All information, articles, and product details provided on this website are for general informational and educational purposes only. We do not claim any ownership over, nor do we intend to infringe upon, any trademarks, copyrights, logos, brand names, or other intellectual property mentioned or depicted on this site. Such intellectual property remains the property of its respective owners, and any references here are made solely for identification or informational purposes, without implying any affiliation, endorsement, or partnership.

We make no representations or warranties, express or implied, regarding the accuracy, completeness, or suitability of any content or products presented. Nothing on this website should be construed as legal, tax, investment, financial, medical, or other professional advice. In addition, no part of this site—including articles or product references—constitutes a solicitation, recommendation, endorsement, advertisement, or offer to buy or sell any securities, franchises, or other financial instruments, particularly in jurisdictions where such activity would be unlawful.

All content is of a general nature and may not address the specific circumstances of any individual or entity. It is not a substitute for professional advice or services. Any actions you take based on the information provided here are strictly at your own risk. You accept full responsibility for any decisions or outcomes arising from your use of this website and agree to release us from any liability in connection with your use of, or reliance upon, the content or products found herein.

Es wurden keine passenden Produkte gefunden.