Ardmore Shipping Corporation (ASC) 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
Ardmore Shipping Corporation (ASC) Bundle
Engineered for accuracy, our (ASC) DCF Calculator empowers you to assess Ardmore Shipping Corporation's valuation using up-to-date financial data and offers comprehensive flexibility to modify all essential parameters for enhanced projections.
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 | 230.0 | 220.1 | 192.5 | 445.7 | 396.0 | 418.9 | 443.3 | 469.0 | 496.2 | 524.9 |
Revenue Growth, % | 0 | -4.34 | -12.53 | 131.57 | -11.16 | 5.8 | 5.8 | 5.8 | 5.8 | 5.8 |
EBITDA | 40.5 | 50.6 | 11.8 | 187.8 | 157.8 | 107.9 | 114.2 | 120.8 | 127.8 | 135.2 |
EBITDA, % | 17.63 | 23.01 | 6.15 | 42.14 | 39.86 | 25.76 | 25.76 | 25.76 | 25.76 | 25.76 |
Depreciation | 37.1 | 38.4 | 36.9 | 33.4 | 27.8 | 56.4 | 59.6 | 63.1 | 66.7 | 70.6 |
Depreciation, % | 16.14 | 17.44 | 19.16 | 7.5 | 7.02 | 13.45 | 13.45 | 13.45 | 13.45 | 13.45 |
EBIT | 3.4 | 12.2 | -25.0 | 154.4 | 130.0 | 51.5 | 54.5 | 57.7 | 61.0 | 64.6 |
EBIT, % | 1.49 | 5.56 | -13.01 | 34.64 | 32.84 | 12.3 | 12.3 | 12.3 | 12.3 | 12.3 |
Total Cash | 51.7 | 58.4 | 55.4 | 50.6 | 46.8 | 84.6 | 89.5 | 94.7 | 100.2 | 106.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 30.1 | 17.8 | 20.3 | 79.8 | 56.2 | 53.5 | 56.6 | 59.9 | 63.3 | 67.0 |
Account Receivables, % | 13.08 | 8.09 | 10.55 | 17.91 | 14.2 | 12.77 | 12.77 | 12.77 | 12.77 | 12.77 |
Inventories | 10.2 | 10.3 | 11.1 | 15.7 | 12.6 | 18.1 | 19.1 | 20.2 | 21.4 | 22.6 |
Inventories, % | 4.42 | 4.67 | 5.76 | 3.53 | 3.17 | 4.31 | 4.31 | 4.31 | 4.31 | 4.31 |
Accounts Payable | 4.8 | 9.1 | 8.6 | 8.8 | 2.0 | 11.0 | 11.7 | 12.4 | 13.1 | 13.8 |
Accounts Payable, % | 2.08 | 4.15 | 4.46 | 1.98 | 0.50912 | 2.63 | 2.63 | 2.63 | 2.63 | 2.63 |
Capital Expenditure | -2.6 | -20.9 | -2.6 | -3.8 | -25.4 | -16.1 | -17.1 | -18.1 | -19.1 | -20.2 |
Capital Expenditure, % | -1.13 | -9.5 | -1.37 | -0.85431 | -6.41 | -3.85 | -3.85 | -3.85 | -3.85 | -3.85 |
Tax Rate, % | 1.24 | 1.24 | 1.24 | 1.24 | 1.24 | 1.24 | 1.24 | 1.24 | 1.24 | 1.24 |
EBITAT | 3.4 | 12.7 | -25.1 | 153.9 | 128.4 | 51.4 | 54.4 | 57.5 | 60.9 | 64.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2.5 | 46.6 | 5.2 | 119.6 | 150.8 | 97.9 | 93.4 | 98.8 | 104.6 | 110.6 |
WACC, % | 7.16 | 7.16 | 7.16 | 7.16 | 7.14 | 7.16 | 7.16 | 7.16 | 7.16 | 7.16 |
PV UFCF | ||||||||||
SUM PV UFCF | 410.6 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 111 | |||||||||
Terminal Value | 1,670 | |||||||||
Present Terminal Value | 1,182 | |||||||||
Enterprise Value | 1,593 | |||||||||
Net Debt | 47 | |||||||||
Equity Value | 1,546 | |||||||||
Diluted Shares Outstanding, MM | 42 | |||||||||
Equity Value Per Share | 36.96 |
What You Will Get
- Real ASC Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Ardmore Shipping's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Financial Metrics: Adjust essential factors such as fleet utilization, operating costs, and revenue projections.
- Instant DCF Valuation: Provides immediate calculations for intrinsic value, net present value (NPV), and additional financial metrics.
- Industry-Leading Precision: Incorporates Ardmore Shipping Corporation's (ASC) actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Easily evaluate various scenarios and analyze their impacts on financial outcomes.
- Efficiency Booster: Streamlines the valuation process, removing the necessity for intricate model development from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based ASC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Ardmore Shipping Corporation’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial analysis.
Why Choose This Calculator for Ardmore Shipping Corporation (ASC)?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for the shipping industry.
- Customizable Inputs: Modify yellow-highlighted cells to explore different operational scenarios.
- Detailed Insights: Automatically computes Ardmore Shipping's intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable foundations for analysis.
- Professional Quality: Perfect for financial analysts, investors, and maritime business consultants.
Who Should Use This Product?
- Investors: Accurately assess Ardmore Shipping Corporation’s (ASC) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Ardmore Shipping Corporation.
- Consultants: Easily modify the template for valuation reports tailored to clients interested in Ardmore Shipping Corporation.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading shipping companies.
- Educators: Employ it as a teaching resource to illustrate valuation techniques relevant to the shipping industry.
What the Template Contains
- Pre-Filled Data: Includes Ardmore Shipping Corporation’s (ASC) 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 Ardmore Shipping Corporation’s (ASC) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.