J.W. Mays, Inc. (MAYS) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
J.W. Mays, Inc. (MAYS) Bundle
Explore the financial prospects of J.W. Mays, Inc. (MAYS) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to determine the intrinsic value of J.W. Mays, Inc. (MAYS) and refine your investment strategy.
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 | 19.5 | 20.2 | 21.4 | 22.6 | 21.6 | 22.2 | 22.7 | 23.3 | 24.0 | 24.6 |
Revenue Growth, % | 0 | 3.49 | 5.85 | 5.52 | -4.35 | 2.63 | 2.63 | 2.63 | 2.63 | 2.63 |
EBITDA | .6 | .9 | 1.0 | 2.4 | 1.3 | 1.3 | 1.3 | 1.4 | 1.4 | 1.4 |
EBITDA, % | 3.09 | 4.69 | 4.64 | 10.48 | 6.1 | 5.8 | 5.8 | 5.8 | 5.8 | 5.8 |
Depreciation | 21.0 | 21.1 | 22.1 | 22.4 | 1.7 | 18.0 | 18.5 | 19.0 | 19.5 | 20.0 |
Depreciation, % | 107.38 | 104.14 | 103.07 | 99.01 | 7.99 | 81.4 | 81.4 | 81.4 | 81.4 | 81.4 |
EBIT | -20.4 | -20.1 | -21.1 | -20.0 | -.4 | -17.2 | -17.7 | -18.1 | -18.6 | -19.1 |
EBIT, % | -104.3 | -99.45 | -98.43 | -88.53 | -1.89 | -77.66 | -77.66 | -77.66 | -77.66 | -77.66 |
Total Cash | 7.0 | 5.5 | 3.8 | 3.5 | 1.2 | 4.5 | 4.6 | 4.8 | 4.9 | 5.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2.2 | 2.4 | 2.8 | 3.0 | 3.6 | 2.9 | 3.0 | 3.1 | 3.2 | 3.3 |
Account Receivables, % | 11.37 | 11.96 | 12.95 | 13.48 | 16.59 | 13.27 | 13.27 | 13.27 | 13.27 | 13.27 |
Inventories | 10.2 | 8.1 | .0 | 6.3 | .0 | 5.3 | 5.5 | 5.6 | 5.7 | 5.9 |
Inventories, % | 52 | 40.17 | 0 | 27.74 | 0 | 23.98 | 23.98 | 23.98 | 23.98 | 23.98 |
Accounts Payable | 2.8 | 2.6 | 2.3 | 1.7 | 2.3 | 2.5 | 2.6 | 2.6 | 2.7 | 2.8 |
Accounts Payable, % | 14.19 | 13.03 | 10.85 | 7.61 | 10.52 | 11.24 | 11.24 | 11.24 | 11.24 | 11.24 |
Capital Expenditure | -6.4 | -2.3 | -1.7 | -1.0 | -2.5 | -3.0 | -3.1 | -3.2 | -3.3 | -3.3 |
Capital Expenditure, % | -32.57 | -11.15 | -8.1 | -4.63 | -11.5 | -13.59 | -13.59 | -13.59 | -13.59 | -13.59 |
Tax Rate, % | 25.2 | 25.2 | 25.2 | 25.2 | 25.2 | 25.2 | 25.2 | 25.2 | 25.2 | 25.2 |
EBITAT | -14.6 | -33.5 | -15.0 | -11.4 | -.3 | -12.9 | -13.2 | -13.6 | -13.9 | -14.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -9.6 | -13.0 | 12.8 | 2.7 | 5.2 | -2.3 | 2.0 | 2.1 | 2.1 | 2.2 |
WACC, % | 4.85 | 5.16 | 4.84 | 4.69 | 4.88 | 4.88 | 4.88 | 4.88 | 4.88 | 4.88 |
PV UFCF | ||||||||||
SUM PV UFCF | 4.9 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 2 | |||||||||
Terminal Value | 120 | |||||||||
Present Terminal Value | 94 | |||||||||
Enterprise Value | 99 | |||||||||
Net Debt | 28 | |||||||||
Equity Value | 71 | |||||||||
Diluted Shares Outstanding, MM | 2 | |||||||||
Equity Value Per Share | 35.33 |
What You Will Get
- Real J.W. Mays, Inc. Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for J.W. Mays, Inc. (MAYS).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit J.W. Mays, Inc. (MAYS).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on J.W. Mays, Inc. (MAYS) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specifically for J.W. Mays, Inc. (MAYS).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for J.W. Mays, Inc. (MAYS).
Key Features
- Accurate Financial Data: Gain access to reliable historical data and future outlooks for J.W. Mays, Inc. (MAYS).
- Adjustable Financial Assumptions: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: View intuitive charts and summaries to better understand your valuation outcomes.
- Designed for All Skill Levels: An accessible and straightforward layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based J.W. Mays, Inc. DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates J.W. Mays, Inc.'s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation changes.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose J.W. Mays, Inc. (MAYS) Calculator?
- Accuracy: Utilizes verified financial data for reliable calculations.
- Flexibility: Allows users to easily adjust and experiment with various inputs.
- Time-Saving: Eliminate the need to create a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and precision expected from industry leaders.
- User-Friendly: Intuitive design makes it accessible for users with any level of financial knowledge.
Who Should Use J.W. Mays, Inc. (MAYS)?
- Real Estate Students: Understand property valuation methods and apply them to real-world scenarios.
- Researchers: Integrate industry-specific models into your academic projects or studies.
- Investors: Evaluate your investment strategies and analyze the performance of J.W. Mays, Inc. (MAYS).
- Financial Analysts: Enhance your analysis with a ready-to-use, customizable financial model.
- Entrepreneurs: Learn how established companies like J.W. Mays, Inc. (MAYS) are assessed in the market.
What the Template Contains
- Historical Data: Includes J.W. Mays, Inc.'s (MAYS) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate J.W. Mays, Inc.'s (MAYS) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of J.W. Mays, Inc.'s (MAYS) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.