|
Afya Limited (AFYA) DCF Valuation
BR | Consumer Defensive | Education & Training Services | NASDAQ
|
- ✓ 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
Afya Limited (AFYA) Bundle
Designed for accuracy, our (AFYA) DCF Calculator enables you to evaluate Afya Limited's valuation using real-world financial data and offers complete flexibility to modify all essential parameters for improved forecasts.
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 | 121.1 | 193.8 | 277.5 | 375.8 | 464.1 | 517.8 | 577.7 | 644.6 | 719.2 | 802.4 |
Revenue Growth, % | 0 | 60.02 | 43.14 | 35.46 | 23.48 | 11.57 | 11.57 | 11.57 | 11.57 | 11.57 |
EBITDA | 41.6 | 69.9 | 87.4 | 138.2 | 178.4 | 183.4 | 204.6 | 228.3 | 254.8 | 284.2 |
EBITDA, % | 34.34 | 36.06 | 31.51 | 36.77 | 38.44 | 35.42 | 35.42 | 35.42 | 35.42 | 35.42 |
Depreciation | 12.0 | 17.7 | 25.8 | 34.2 | 46.7 | 49.2 | 54.9 | 61.2 | 68.3 | 76.2 |
Depreciation, % | 9.94 | 9.12 | 9.28 | 9.1 | 10.07 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 |
EBIT | 29.6 | 52.2 | 61.7 | 104.0 | 131.7 | 134.2 | 149.8 | 167.1 | 186.4 | 208.0 |
EBIT, % | 24.4 | 26.94 | 22.23 | 27.67 | 28.37 | 25.92 | 25.92 | 25.92 | 25.92 | 25.92 |
Total Cash | 152.2 | 168.6 | 120.8 | 176.4 | 89.2 | 307.3 | 342.8 | 382.5 | 426.8 | 476.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 20.2 | 48.8 | 61.1 | 73.1 | 88.2 | 106.0 | 118.2 | 131.9 | 147.2 | 164.2 |
Account Receivables, % | 16.71 | 25.17 | 22.01 | 19.44 | 19 | 20.47 | 20.47 | 20.47 | 20.47 | 20.47 |
Inventories | .6 | 1.2 | 1.9 | 2.0 | .2 | 2.5 | 2.8 | 3.1 | 3.5 | 3.9 |
Inventories, % | 0.52383 | 0.62513 | 0.68787 | 0.52339 | 0.0480543 | 0.48165 | 0.48165 | 0.48165 | 0.48165 | 0.48165 |
Accounts Payable | 2.8 | 5.8 | 9.5 | 11.5 | 17.5 | 16.1 | 18.0 | 20.1 | 22.4 | 25.0 |
Accounts Payable, % | 2.35 | 2.98 | 3.44 | 3.07 | 3.76 | 3.12 | 3.12 | 3.12 | 3.12 | 3.12 |
Capital Expenditure | -19.6 | -22.2 | -44.7 | -47.9 | -39.6 | -67.4 | -75.2 | -83.9 | -93.6 | -104.4 |
Capital Expenditure, % | -16.21 | -11.45 | -16.1 | -12.75 | -8.53 | -13.01 | -13.01 | -13.01 | -13.01 | -13.01 |
Tax Rate, % | 10.07 | 10.07 | 10.07 | 10.07 | 10.07 | 10.07 | 10.07 | 10.07 | 10.07 | 10.07 |
EBITAT | 24.3 | 45.5 | 50.4 | 90.7 | 118.4 | 115.0 | 128.3 | 143.1 | 159.7 | 178.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1.3 | 14.8 | 22.3 | 66.9 | 118.1 | 75.4 | 97.3 | 108.6 | 121.1 | 135.2 |
WACC, % | 9.5 | 9.66 | 9.48 | 9.66 | 9.75 | 9.61 | 9.61 | 9.61 | 9.61 | 9.61 |
PV UFCF | ||||||||||
SUM PV UFCF | 401.6 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 136 | |||||||||
Terminal Value | 1,491 | |||||||||
Present Terminal Value | 943 | |||||||||
Enterprise Value | 1,344 | |||||||||
Net Debt | 342 | |||||||||
Equity Value | 1,002 | |||||||||
Diluted Shares Outstanding, MM | 91 | |||||||||
Equity Value Per Share | 11.07 |
What You Will Get
- Real AFYA Financial Data: Pre-filled with Afya 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 Afya Limited’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 DCF Model: Offers detailed unlevered and levered DCF valuation frameworks.
- WACC Tool: Pre-configured Weighted Average Cost of Capital calculator with adjustable parameters.
- Customizable Forecast Inputs: Adjust growth projections, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Afya Limited (AFYA).
- Interactive Dashboard and Graphs: Visual representations highlight essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Afya Limited’s (AFYA) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view the recalculated results, including Afya Limited’s intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Afya Limited (AFYA)?
- Accurate Data: Utilizes real Afya Limited financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the healthcare sector.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing Afya Limited (AFYA) stocks.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Afya Limited (AFYA).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Healthcare Sector Enthusiasts: Gain insights into how companies like Afya Limited (AFYA) are valued within the healthcare market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Afya Limited 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 Afya Limited (AFYA).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.