Dorian LPG Ltd. (LPG) DCF Valuation

Dorian LPG Ltd. (GLP) DCF Valoración

US | Energy | Oil & Gas Midstream | NYSE
Dorian LPG Ltd. (LPG) 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

Compatible con MAC / PC, completamente desbloqueado

No Se Necesita Experiencia; Fáciles De Seguir

Dorian LPG Ltd. (LPG) Bundle

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

TOTAL:

¡Explore las perspectivas financieras de Dorian LPG Ltd. (GLP) con nuestra calculadora DCF fácil de usar! Ingrese sus proyecciones para el crecimiento, los márgenes de beneficio y los gastos para calcular el valor intrínseco de Dorian LPG Ltd. (GLP) y mejorar su enfoque de inversión.


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 333.4 315.9 274.2 389.7 560.7 655.4 766.1 895.4 1,046.6 1,223.4
Revenue Growth, % 0 -5.25 -13.2 42.13 43.87 16.89 16.89 16.89 16.89 16.89
EBITDA 216.1 197.8 151.6 261.8 397.5 420.4 491.4 574.4 671.4 784.8
EBITDA, % 64.81 62.62 55.27 67.16 70.89 64.15 64.15 64.15 64.15 64.15
Depreciation 68.1 77.7 66.4 63.4 68.7 128.1 149.8 175.1 204.6 239.2
Depreciation, % 20.44 24.59 24.23 16.27 12.25 19.55 19.55 19.55 19.55 19.55
EBIT 147.9 120.2 85.1 198.4 328.8 292.3 341.7 399.4 466.8 545.6
EBIT, % 44.37 38.03 31.05 50.89 58.64 44.6 44.6 44.6 44.6 44.6
Total Cash 30.8 63.3 79.3 236.8 294.0 224.7 262.6 307.0 358.8 419.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 67.7 56.4 58.6 76.4 53.0
Account Receivables, % 20.29 17.85 21.38 19.59 9.45
Inventories 2.1 2.0 2.0 2.3 2.4 3.9 4.6 5.4 6.3 7.4
Inventories, % 0.63331 0.63183 0.73206 0.58149 0.42684 0.60111 0.60111 0.60111 0.60111 0.60111
Accounts Payable 13.6 9.8 9.5 10.8 10.2 20.0 23.4 27.3 31.9 37.3
Accounts Payable, % 4.06 3.11 3.48 2.77 1.82 3.05 3.05 3.05 3.05 3.05
Capital Expenditure -4.0 -20.0 -9.5 -23.2 -32.9 -29.9 -35.0 -40.9 -47.8 -55.8
Capital Expenditure, % -1.21 -6.34 -3.47 -5.95 -5.86 -4.56 -4.56 -4.56 -4.56 -4.56
Tax Rate, % 0 0 0 0 0 0 0 0 0 0
EBITAT 147.9 120.2 85.1 198.4 328.8 292.3 341.7 399.4 466.8 545.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 155.8 185.5 139.5 221.9 387.2 335.7 439.6 513.8 600.6 702.0
WACC, % 6.6 6.6 6.6 6.6 6.6 6.6 6.6 6.6 6.6 6.6
PV UFCF
SUM PV UFCF 2,101.1
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 706
Terminal Value 11,569
Present Terminal Value 8,405
Enterprise Value 10,506
Net Debt 515
Equity Value 9,991
Diluted Shares Outstanding, MM 40
Equity Value Per Share 247.00

What You Will Get

  • Accurate LPG Financials: Access to historical data and future projections for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
  • Real-Time Calculations: Dynamic calculations for intrinsic value and NPV at your fingertips.
  • Scenario Testing: Evaluate various scenarios to assess Dorian LPG Ltd.'s (LPG) future performance.
  • User-Friendly Interface: Designed for industry professionals while remaining approachable for newcomers.

Key Features

  • Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Dorian LPG Ltd. (LPG).
  • WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to the LPG sector.
  • Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates to fit Dorian LPG Ltd. (LPG) projections.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Dorian LPG Ltd. (LPG).
  • Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Dorian LPG Ltd.'s (LPG) financial data.
  • 2. Modify Assumptions: Adjust key variables such as growth projections, WACC, and capital expenditures.
  • 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV based on your inputs.
  • 4. Explore Scenarios: Evaluate different forecasts to understand various valuation possibilities.
  • 5. Present with Assurance: Share professional valuation analyses to back your strategic decisions.

Why Choose This Calculator for Dorian LPG Ltd. (LPG)?

  • Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one convenient package.
  • Customizable Inputs: Modify yellow-highlighted cells to explore various financial scenarios.
  • Detailed Insights: Automatically computes Dorian LPG’s intrinsic value and Net Present Value.
  • Preloaded Data: Historical and projected data provide reliable starting points for analysis.
  • Professional Quality: Perfect for financial analysts, investors, and business consultants focused on the LPG sector.

Who Should Use Dorian LPG Ltd. (LPG)?

  • Maritime Students: Explore shipping industry dynamics and apply theoretical knowledge using real-world data.
  • Researchers: Integrate industry-specific models into academic projects or studies.
  • Investors: Evaluate your investment strategies and analyze valuation metrics for Dorian LPG Ltd. (LPG).
  • Market Analysts: Enhance your analysis with a ready-to-use, customizable financial model tailored for the shipping sector.
  • Entrepreneurs: Understand how publicly traded companies like Dorian LPG Ltd. (LPG) are assessed and valued in the market.

What the Template Contains

  • Pre-Filled Data: Includes Dorian LPG Ltd.'s 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 Dorian LPG Ltd.'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.


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.