Patria Investments Limited (PAX) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Patria Investments Limited (PAX) Bundle
Gain insights into your Patria Investments Limited (PAX) valuation analysis with our state-of-the-art DCF Calculator! Equipped with real-time data for (PAX), this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of Patria Investments Limited.
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 | 123.2 | 115.0 | 235.5 | 258.9 | 329.4 | 436.9 | 579.4 | 768.5 | 1,019.3 | 1,351.8 |
Revenue Growth, % | 0 | -6.65 | 104.77 | 9.92 | 27.25 | 32.63 | 32.63 | 32.63 | 32.63 | 32.63 |
EBITDA | 72.8 | 72.8 | 130.9 | 132.8 | 146.4 | 239.2 | 317.2 | 420.7 | 558.0 | 740.0 |
EBITDA, % | 59.08 | 63.31 | 55.59 | 51.3 | 44.43 | 54.74 | 54.74 | 54.74 | 54.74 | 54.74 |
Depreciation | 58.6 | 47.9 | 101.3 | 137.4 | 27.1 | 169.1 | 224.2 | 297.4 | 394.5 | 523.2 |
Depreciation, % | 47.57 | 41.65 | 42.99 | 53.06 | 8.23 | 38.7 | 38.7 | 38.7 | 38.7 | 38.7 |
EBIT | 14.2 | 24.9 | 29.7 | -4.5 | 119.2 | 70.1 | 93.0 | 123.3 | 163.5 | 216.9 |
EBIT, % | 11.51 | 21.66 | 12.6 | -1.76 | 36.2 | 16.04 | 16.04 | 16.04 | 16.04 | 16.04 |
Total Cash | 37.2 | 24.0 | 167.1 | 312.4 | 33.2 | 202.8 | 268.9 | 356.7 | 473.0 | 627.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 11.0 | 24.0 | 110.7 | 126.6 | 130.6 | 144.5 | 191.6 | 254.2 | 337.1 | 447.1 |
Account Receivables, % | 8.93 | 20.89 | 47.02 | 48.89 | 39.64 | 33.07 | 33.07 | 33.07 | 33.07 | 33.07 |
Inventories | 7.8 | 4.1 | 6.6 | 12.1 | 24.3 | 21.6 | 28.6 | 38.0 | 50.4 | 66.8 |
Inventories, % | 6.29 | 3.57 | 2.79 | 4.67 | 7.38 | 4.94 | 4.94 | 4.94 | 4.94 | 4.94 |
Accounts Payable | .5 | 3.0 | 7.2 | 3.3 | 4.8 | 7.7 | 10.2 | 13.6 | 18.0 | 23.9 |
Accounts Payable, % | 0.3993 | 2.64 | 3.07 | 1.26 | 1.46 | 1.77 | 1.77 | 1.77 | 1.77 | 1.77 |
Capital Expenditure | -.2 | -.7 | -1.8 | -6.7 | -15.0 | -7.6 | -10.1 | -13.3 | -17.7 | -23.5 |
Capital Expenditure, % | -0.17611 | -0.57383 | -0.78254 | -2.59 | -4.56 | -1.74 | -1.74 | -1.74 | -1.74 | -1.74 |
Tax Rate, % | -0.33983 | -0.33983 | -0.33983 | -0.33983 | -0.33983 | -0.33983 | -0.33983 | -0.33983 | -0.33983 | -0.33983 |
EBITAT | 12.9 | 23.9 | 29.9 | -4.1 | 119.6 | 66.9 | 88.7 | 117.7 | 156.1 | 207.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 53.0 | 64.3 | 44.3 | 101.2 | 117.1 | 220.1 | 251.2 | 333.2 | 441.9 | 586.1 |
WACC, % | 7.19 | 7.2 | 7.2 | 7.19 | 7.2 | 7.2 | 7.2 | 7.2 | 7.2 | 7.2 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,443.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 598 | |||||||||
Terminal Value | 11,508 | |||||||||
Present Terminal Value | 8,131 | |||||||||
Enterprise Value | 9,574 | |||||||||
Net Debt | 0 | |||||||||
Equity Value | 9,574 | |||||||||
Diluted Shares Outstanding, MM | 149 | |||||||||
Equity Value Per Share | 64.40 |
What You Will Get
- Real PAX Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Patria Investments' future performance.
- User-Friendly Design: Designed for professionals, yet easy to navigate for beginners.
Key Features
- Comprehensive DCF Model: Features both unlevered and levered DCF valuation frameworks tailored for Patria Investments Limited (PAX).
- WACC Analysis Tool: Ready-to-use Weighted Average Cost of Capital calculator with adjustable parameters.
- Customizable Forecast Inputs: Easily adjust growth projections, capital investments, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Patria Investments Limited (PAX).
- Interactive Dashboard and Visuals: Graphical representations provide a clear overview of essential valuation indicators for quick insights.
How It Works
- Download: Obtain the pre-formatted Excel file containing Patria Investments Limited’s (PAX) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and analyze results instantly.
- Make Decisions: Leverage the valuation insights to inform your investment strategy.
Why Choose This Calculator?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Patria Investments Limited’s (PAX) valuation as you tweak inputs.
- Pre-Loaded Data: Comes equipped with Patria Investments Limited’s (PAX) latest financial information for swift evaluations.
- Relied Upon by Experts: A go-to tool for investors and analysts to make well-informed choices.
Who Should Use Patria Investments Limited (PAX)?
- Investors: Make informed decisions with a reliable investment platform tailored for growth.
- Portfolio Managers: Streamline your asset management with comprehensive tools and analytics.
- Financial Advisors: Customize strategies for clients using our robust investment frameworks.
- Market Analysts: Enhance your research capabilities with in-depth market insights and data.
- Students and Educators: Utilize our resources for hands-on learning in investment and finance courses.
What the Template Contains
- Pre-Filled DCF Model: Patria Investments Limited’s (PAX) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Patria Investments Limited’s (PAX) 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.