Nordic American Tankers Limited (NAT) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Nordic American Tankers Limited (NAT) Bundle
Designed for accuracy, our (NAT) DCF Calculator enables you to evaluate the valuation of Nordic American Tankers Limited using real-world financial data and offers complete flexibility to modify all essential parameters for improved 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 | 317.2 | 354.6 | 195.8 | 339.3 | 391.7 | 446.3 | 508.5 | 579.4 | 660.2 | 752.2 |
Revenue Growth, % | 0 | 11.79 | -44.8 | 73.35 | 15.43 | 13.94 | 13.94 | 13.94 | 13.94 | 13.94 |
EBITDA | 96.2 | 149.3 | -24.7 | 92.6 | 179.3 | 118.6 | 135.1 | 154.0 | 175.4 | 199.9 |
EBITDA, % | 30.34 | 42.09 | -12.61 | 27.29 | 45.77 | 26.57 | 26.57 | 26.57 | 26.57 | 26.57 |
Depreciation | 64.0 | 67.8 | 68.4 | 50.4 | 51.4 | 91.2 | 103.9 | 118.4 | 134.9 | 153.7 |
Depreciation, % | 20.16 | 19.13 | 34.92 | 14.86 | 13.12 | 20.44 | 20.44 | 20.44 | 20.44 | 20.44 |
EBIT | 32.3 | 81.4 | -93.0 | 42.2 | 127.9 | 27.4 | 31.2 | 35.6 | 40.5 | 46.2 |
EBIT, % | 10.17 | 22.96 | -47.53 | 12.43 | 32.65 | 6.14 | 6.14 | 6.14 | 6.14 | 6.14 |
Total Cash | 49.7 | 57.8 | 34.7 | 59.6 | 31.1 | 67.1 | 76.5 | 87.2 | 99.3 | 113.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 24.6 | 6.3 | 9.4 | 20.5 | 26.3 | 24.2 | 27.5 | 31.4 | 35.7 | 40.7 |
Account Receivables, % | 7.75 | 1.79 | 4.79 | 6.03 | 6.71 | 5.41 | 5.41 | 5.41 | 5.41 | 5.41 |
Inventories | 22.5 | 19.4 | 20.9 | 25.4 | 42.4 | 37.1 | 42.2 | 48.1 | 54.8 | 62.5 |
Inventories, % | 7.08 | 5.47 | 10.66 | 7.49 | 10.82 | 8.31 | 8.31 | 8.31 | 8.31 | 8.31 |
Accounts Payable | 8.4 | 4.1 | 6.6 | 7.0 | 3.4 | 9.0 | 10.3 | 11.7 | 13.3 | 15.2 |
Accounts Payable, % | 2.65 | 1.16 | 3.35 | 2.05 | 0.87978 | 2.02 | 2.02 | 2.02 | 2.02 | 2.02 |
Capital Expenditure | -2.5 | -18.1 | -17.7 | -95.4 | -73.7 | -55.2 | -62.9 | -71.7 | -81.7 | -93.1 |
Capital Expenditure, % | -0.79787 | -5.1 | -9.06 | -28.12 | -18.81 | -12.38 | -12.38 | -12.38 | -12.38 | -12.38 |
Tax Rate, % | 0.12142 | 0.12142 | 0.12142 | 0.12142 | 0.12142 | 0.12142 | 0.12142 | 0.12142 | 0.12142 | 0.12142 |
EBITAT | 32.5 | 81.4 | -93.1 | 42.2 | 127.7 | 27.4 | 31.2 | 35.5 | 40.5 | 46.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 55.3 | 148.2 | -44.5 | -18.1 | 79.2 | 76.3 | 64.9 | 74.0 | 84.3 | 96.0 |
WACC, % | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 |
PV UFCF | ||||||||||
SUM PV UFCF | 320.0 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 99 | |||||||||
Terminal Value | 2,392 | |||||||||
Present Terminal Value | 1,695 | |||||||||
Enterprise Value | 2,015 | |||||||||
Net Debt | 271 | |||||||||
Equity Value | 1,745 | |||||||||
Diluted Shares Outstanding, MM | 209 | |||||||||
Equity Value Per Share | 8.35 |
What You Will Get
- Real NAT Financial Data: Pre-filled with Nordic American Tankers Limited’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See NAT’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Historical Data: Access Nordic American Tankers Limited’s (NAT) past financial statements and detailed forecasts.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Instantly view the recalculated intrinsic value of Nordic American Tankers Limited (NAT).
- Intuitive Visualizations: Engaging dashboard charts illustrate valuation results and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template with Nordic American Tankers Limited’s (NAT) data included.
- Step 2: Explore the pre-filled sheets and understand the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Nordic American Tankers Limited’s (NAT) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Nordic American Tankers Limited (NAT)?
- User-Friendly Interface: Perfectly suited for both novices and seasoned analysts.
- Customizable Inputs: Easily adjust variables to tailor your financial assessments.
- Real-Time Valuation: Instantly observe changes to Nordic American Tankers' valuation as you modify parameters.
- Preloaded Data: Comes equipped with Nordic American Tankers' actual financial figures for swift evaluations.
- Preferred by Experts: Utilized by investors and financial analysts for informed decision-making.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Nordic American Tankers Limited (NAT) stock.
- Financial Analysts: Enhance valuation processes with ready-to-use financial models specific to Nordic American Tankers Limited (NAT).
- Consultants: Provide professional valuation insights on Nordic American Tankers Limited (NAT) to clients efficiently and accurately.
- Business Owners: Gain insights into how companies like Nordic American Tankers Limited (NAT) are valued to inform your own business strategies.
- Finance Students: Study valuation techniques using real-world data and scenarios related to Nordic American Tankers Limited (NAT).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Nordic American Tankers Limited (NAT) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Nordic American Tankers Limited (NAT).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.