Highway Holdings Limited (HIHO) 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
Highway Holdings Limited (HIHO) Bundle
Whether you're an investor or an analyst, this (HIHO) DCF Calculator is the perfect tool for accurate valuation. Preloaded with real data from Highway Holdings Limited, you can adjust forecasts and instantly observe the effects.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 12.6 | 9.2 | 12.4 | 10.2 | 6.3 | 5.6 | 4.9 | 4.3 | 3.8 | 3.4 |
Revenue Growth, % | 0 | -26.99 | 34.87 | -17.17 | -38.28 | -11.89 | -11.89 | -11.89 | -11.89 | -11.89 |
EBITDA | 2.0 | .4 | 1.7 | .7 | .0 | .4 | .4 | .3 | .3 | .3 |
EBITDA, % | 15.66 | 4.19 | 13.46 | 6.48 | -0.17402 | 7.92 | 7.92 | 7.92 | 7.92 | 7.92 |
Depreciation | 1.2 | 1.0 | 1.1 | 1.1 | .8 | .6 | .5 | .5 | .4 | .4 |
Depreciation, % | 9.71 | 10.91 | 8.87 | 11.14 | 11.99 | 10.52 | 10.52 | 10.52 | 10.52 | 10.52 |
EBIT | .7 | -.6 | .6 | -.5 | -.8 | -.1 | -.1 | -.1 | -.1 | -.1 |
EBIT, % | 5.95 | -6.72 | 4.59 | -4.66 | -12.17 | -2.6 | -2.6 | -2.6 | -2.6 | -2.6 |
Total Cash | 8.8 | 7.8 | 7.1 | 7.0 | 6.6 | 4.2 | 3.7 | 3.3 | 2.9 | 2.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2.0 | 1.0 | 2.3 | 1.9 | 1.3 | .9 | .8 | .7 | .6 | .6 |
Account Receivables, % | 15.99 | 10.61 | 18.33 | 18.44 | 19.82 | 16.64 | 16.64 | 16.64 | 16.64 | 16.64 |
Inventories | 2.0 | 2.2 | 2.4 | 1.4 | 1.6 | 1.1 | 1.0 | .8 | .7 | .7 |
Inventories, % | 15.93 | 24.41 | 19.01 | 13.8 | 24.77 | 19.58 | 19.58 | 19.58 | 19.58 | 19.58 |
Accounts Payable | 1.0 | .7 | .8 | .9 | .9 | .5 | .4 | .4 | .3 | .3 |
Accounts Payable, % | 7.94 | 7.12 | 6.7 | 9.06 | 14.79 | 9.12 | 9.12 | 9.12 | 9.12 | 9.12 |
Capital Expenditure | -.1 | -.1 | -.1 | -.1 | -.1 | -.1 | -.1 | .0 | .0 | .0 |
Capital Expenditure, % | -0.72464 | -0.95986 | -1.08 | -0.89826 | -1.87 | -1.11 | -1.11 | -1.11 | -1.11 | -1.11 |
Tax Rate, % | 15.8 | 15.8 | 15.8 | 15.8 | 15.8 | 15.8 | 15.8 | 15.8 | 15.8 | 15.8 |
EBITAT | .6 | -.5 | .4 | -.4 | -.6 | -.1 | -.1 | -.1 | -.1 | -.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1.3 | .9 | .2 | 2.0 | .5 | .8 | .5 | .5 | .4 | .4 |
WACC, % | 5.12 | 5.11 | 5.12 | 5.22 | 5.16 | 5.15 | 5.15 | 5.15 | 5.15 | 5.15 |
PV UFCF | ||||||||||
SUM PV UFCF | 2.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 12 | |||||||||
Present Terminal Value | 9 | |||||||||
Enterprise Value | 12 | |||||||||
Net Debt | -5 | |||||||||
Equity Value | 17 | |||||||||
Diluted Shares Outstanding, MM | 4 | |||||||||
Equity Value Per Share | 3.83 |
What You Will Get
- Genuine Highway Holdings Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Highway Holdings Limited (HIHO).
- Complete Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to evaluate the effects of changes on Highway Holdings Limited’s (HIHO) fair value.
- Flexible Excel Template: Designed for quick modifications, scenario testing, and comprehensive projections.
- Efficient and Accurate: Eliminate the need to build models from the ground up while ensuring accuracy and adaptability.
Key Features
- Customizable Financial Inputs: Adjust essential variables such as sales growth, profit margins, and investment levels.
- Instant DCF Valuation: Automatically computes intrinsic value, net present value, and other key metrics.
- High-Precision Results: Leverages Highway Holdings Limited’s (HIHO) actual financial data for accurate valuation assessments.
- Seamless Scenario Testing: Easily evaluate various assumptions and analyze the resulting impacts.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Highway Holdings Limited’s (HIHO) preloaded data.
- 2. Adjust Key Inputs: Modify essential variables such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically calculates intrinsic value and NPV in real-time.
- 4. Explore Different Scenarios: Evaluate various forecasts to understand diverse valuation results.
- 5. Present with Assurance: Deliver professional valuation insights to reinforce your strategic decisions.
Why Choose This Calculator for Highway Holdings Limited (HIHO)?
- Accurate Data: Utilize real financials from Highway Holdings Limited for trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focusing on (HIHO).
- User-Friendly: Easy-to-navigate design and clear instructions cater to users of all experience levels.
Who Should Use This Product?
- Finance Students: Explore valuation techniques and apply them to real-world data related to Highway Holdings Limited (HIHO).
- Academics: Integrate professional valuation models into your coursework or research focused on Highway Holdings Limited (HIHO).
- Investors: Validate your investment assumptions and analyze valuation outcomes for Highway Holdings Limited (HIHO) stock.
- Analysts: Enhance your efficiency with a customizable DCF model specifically designed for Highway Holdings Limited (HIHO).
- Small Business Owners: Understand how large public companies like Highway Holdings Limited (HIHO) are evaluated in the market.
What the Template Contains
- Pre-Filled DCF Model: Highway Holdings Limited’s (HIHO) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Highway Holdings Limited’s (HIHO) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.