Dorian LPG Ltd. (LPG) DCF Valuation

Dorian LPG Ltd. (LPG) 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

Dorian LPG Ltd. (LPG) 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:

Explore the financial outlook of Dorian LPG Ltd. (LPG) with our user-friendly DCF Calculator! Enter your projections for growth, profit margins, and expenses to calculate the intrinsic value of Dorian LPG Ltd. (LPG) and enhance your investment approach.


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, % 7.64 7.64 7.64 7.64 7.64 7.64 7.64 7.64 7.64 7.64
PV UFCF
SUM PV UFCF 2,036.2
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 706
Terminal Value 9,876
Present Terminal Value 6,834
Enterprise Value 8,870
Net Debt 514
Equity Value 8,356
Diluted Shares Outstanding, MM 40
Equity Value Per Share 206.56

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.

No products were found matching.