Agilysys, Inc. (AGYS) 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
Agilysys, Inc. (AGYS) Bundle
Evaluate Agilysys, Inc. (AGYS) financial prospects like an expert! This (AGYS) DCF Calculator offers pre-filled financial data along with the freedom to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 160.8 | 137.2 | 162.6 | 198.1 | 237.5 | 264.5 | 294.6 | 328.2 | 365.6 | 407.3 |
Revenue Growth, % | 0 | -14.67 | 18.56 | 21.78 | 19.89 | 11.39 | 11.39 | 11.39 | 11.39 | 11.39 |
EBITDA | -16.2 | -16.4 | 10.4 | 19.3 | 25.9 | 2.7 | 3.0 | 3.3 | 3.7 | 4.1 |
EBITDA, % | -10.07 | -11.95 | 6.39 | 9.73 | 10.93 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 |
Depreciation | 17.7 | 4.8 | 3.9 | 3.5 | 5.3 | 11.0 | 12.3 | 13.7 | 15.2 | 17.0 |
Depreciation, % | 11 | 3.49 | 2.38 | 1.77 | 2.22 | 4.17 | 4.17 | 4.17 | 4.17 | 4.17 |
EBIT | -33.9 | -21.2 | 6.5 | 15.8 | 20.7 | -8.4 | -9.3 | -10.4 | -11.6 | -12.9 |
EBIT, % | -21.06 | -15.45 | 4.01 | 7.96 | 8.71 | -3.17 | -3.17 | -3.17 | -3.17 | -3.17 |
Total Cash | 46.7 | 99.2 | 97.0 | 112.8 | 144.9 | 147.6 | 164.4 | 183.1 | 204.0 | 227.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 38.0 | 28.1 | 26.8 | 24.6 | 31.7 | 45.7 | 50.9 | 56.7 | 63.2 | 70.4 |
Account Receivables, % | 23.63 | 20.48 | 16.51 | 12.43 | 13.36 | 17.28 | 17.28 | 17.28 | 17.28 | 17.28 |
Inventories | 3.9 | 1.2 | 6.9 | 9.8 | 4.6 | 7.6 | 8.5 | 9.5 | 10.5 | 11.7 |
Inventories, % | 2.42 | 0.85802 | 4.27 | 4.93 | 1.93 | 2.88 | 2.88 | 2.88 | 2.88 | 2.88 |
Accounts Payable | 13.4 | 6.3 | 9.8 | 9.4 | 9.4 | 14.6 | 16.3 | 18.2 | 20.2 | 22.6 |
Accounts Payable, % | 8.34 | 4.63 | 6 | 4.76 | 3.97 | 5.54 | 5.54 | 5.54 | 5.54 | 5.54 |
Capital Expenditure | -3.4 | -1.4 | -1.2 | -7.2 | -8.1 | -5.8 | -6.5 | -7.2 | -8.0 | -8.9 |
Capital Expenditure, % | -2.13 | -1.01 | -0.736 | -3.65 | -3.42 | -2.19 | -2.19 | -2.19 | -2.19 | -2.19 |
Tax Rate, % | -316.72 | -316.72 | -316.72 | -316.72 | -316.72 | -316.72 | -316.72 | -316.72 | -316.72 | -316.72 |
EBITAT | -34.1 | -21.0 | 6.5 | 14.6 | 86.2 | -8.2 | -9.2 | -10.2 | -11.4 | -12.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -48.3 | -12.0 | 8.1 | 9.9 | 81.4 | -14.8 | -7.7 | -8.6 | -9.6 | -10.7 |
WACC, % | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 |
PV UFCF | ||||||||||
SUM PV UFCF | -41.0 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -11 | |||||||||
Terminal Value | -251 | |||||||||
Present Terminal Value | -167 | |||||||||
Enterprise Value | -208 | |||||||||
Net Debt | -121 | |||||||||
Equity Value | -87 | |||||||||
Diluted Shares Outstanding, MM | 27 | |||||||||
Equity Value Per Share | -3.26 |
What You Will Get
- Real AGYS Financial Data: Pre-filled with Agilysys, Inc.'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 Agilysys, Inc.'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 Agilysys Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Tailorable Forecast Inputs: Modify highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic adjustments to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help you interpret your valuation outcomes.
- Designed for All Skill Levels: An easy-to-navigate structure created for investors, CFOs, and consultants alike.
How It Functions
- Download the Template: Gain immediate access to the Excel-based AGYS DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Agilysys’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Agilysys, Inc. (AGYS)?
- Precision: Utilizes real Agilysys financial data for reliable outcomes.
- Versatility: Crafted for users to easily adjust and test various inputs.
- Efficiency: Avoid the complexities of constructing a DCF model from the ground up.
- Expert-Level: Designed with the accuracy and functionality expected by CFOs.
- Intuitive: Simple interface, perfect for users without extensive financial modeling skills.
Who Should Use Agilysys, Inc. (AGYS)?
- Hospitality Management Students: Discover industry-specific financial models and apply them to real-world scenarios.
- Researchers: Utilize Agilysys' data to enrich studies on technology in the hospitality sector.
- Investors: Analyze market trends and evaluate the performance of Agilysys, Inc. (AGYS) in the tech space.
- Financial Analysts: Optimize your analysis with tailored financial models specific to the hospitality industry.
- Hotel Owners: Understand how technology investments can impact operational efficiency and profitability.
What the Template Contains
- Preloaded AGYS Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.