|
PayLocity Holding Corporation (PCTY) DCF Valoración
US | Technology | Software - Application | NASDAQ
|
- ✓ 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
Paylocity Holding Corporation (PCTY) Bundle
¡Simplifique la valoración de PayLocity Holding Corporation (PCTY) con esta calculadora DCF personalizable! Con las finanzas de Paylocity reales y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de PayLocity en minutos.
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 | 561.3 | 635.6 | 852.7 | 1,174.6 | 1,402.5 | 1,769.1 | 2,231.4 | 2,814.6 | 3,550.2 | 4,478.1 |
Revenue Growth, % | 0 | 13.24 | 34.14 | 37.76 | 19.4 | 26.14 | 26.14 | 26.14 | 26.14 | 26.14 |
EBITDA | 104.1 | 101.0 | 134.8 | 215.9 | 336.5 | 327.7 | 413.3 | 521.4 | 657.6 | 829.5 |
EBITDA, % | 18.54 | 15.89 | 15.81 | 18.38 | 23.99 | 18.52 | 18.52 | 18.52 | 18.52 | 18.52 |
Depreciation | 37.9 | 43.0 | 50.2 | 60.9 | 76.4 | 106.3 | 134.0 | 169.1 | 213.3 | 269.0 |
Depreciation, % | 6.75 | 6.76 | 5.89 | 5.18 | 5.45 | 6.01 | 6.01 | 6.01 | 6.01 | 6.01 |
EBIT | 66.2 | 58.0 | 84.6 | 155.0 | 260.1 | 221.4 | 279.3 | 352.3 | 444.4 | 560.5 |
EBIT, % | 11.79 | 9.13 | 9.92 | 13.2 | 18.54 | 12.52 | 12.52 | 12.52 | 12.52 | 12.52 |
Total Cash | 285.4 | 206.7 | 139.8 | 288.8 | 401.8 | 541.3 | 682.8 | 861.2 | 1,086.3 | 1,370.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 4.9 | 6.3 | 15.8 | 25.1 | 33.0 | 29.0 | 36.6 | 46.2 | 58.2 | 73.4 |
Account Receivables, % | 0.87703 | 0.98596 | 1.85 | 2.14 | 2.35 | 1.64 | 1.64 | 1.64 | 1.64 | 1.64 |
Inventories | 1,292.7 | 1,755.2 | 4.5 | 2,699.5 | .0 | 1,063.3 | 1,341.2 | 1,691.7 | 2,133.8 | 2,691.5 |
Inventories, % | 230.3 | 276.14 | 0.52261 | 229.83 | 0 | 60.1 | 60.1 | 60.1 | 60.1 | 60.1 |
Accounts Payable | 1.8 | 4.2 | 8.4 | 6.2 | 8.6 | 11.0 | 13.8 | 17.5 | 22.0 | 27.8 |
Accounts Payable, % | 0.31265 | 0.66548 | 0.98211 | 0.52384 | 0.61589 | 0.62 | 0.62 | 0.62 | 0.62 | 0.62 |
Capital Expenditure | -42.3 | -38.1 | -52.6 | -66.9 | -18.0 | -94.4 | -119.0 | -150.1 | -189.4 | -238.9 |
Capital Expenditure, % | -7.53 | -5.99 | -6.17 | -5.7 | -1.29 | -5.33 | -5.33 | -5.33 | -5.33 | -5.33 |
Tax Rate, % | 25.36 | 25.36 | 25.36 | 25.36 | 25.36 | 25.36 | 25.36 | 25.36 | 25.36 | 25.36 |
EBITAT | 63.5 | 72.0 | 91.9 | 137.6 | 194.1 | 203.5 | 256.7 | 323.7 | 408.3 | 515.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,236.8 | -384.4 | 1,834.9 | -2,575.0 | 2,946.6 | -841.6 | -10.9 | -13.8 | -17.4 | -22.0 |
WACC, % | 8.82 | 8.82 | 8.82 | 8.82 | 8.82 | 8.82 | 8.82 | 8.82 | 8.82 | 8.82 |
PV UFCF | ||||||||||
SUM PV UFCF | -820.1 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -23 | |||||||||
Terminal Value | -474 | |||||||||
Present Terminal Value | -310 | |||||||||
Enterprise Value | -1,130 | |||||||||
Net Debt | -347 | |||||||||
Equity Value | -783 | |||||||||
Diluted Shares Outstanding, MM | 57 | |||||||||
Equity Value Per Share | -13.74 |
What You Will Get
- Real Paylocity Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Paylocity’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Real-Life PCTY Data: Pre-filled with Paylocity’s historical financials and future growth projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop various forecast scenarios to assess different valuation results.
- User-Friendly Design: Intuitive, organized, and suitable for both professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template featuring Paylocity’s data included.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated outcomes, including Paylocity’s intrinsic value.
- Step 5: Make informed investment choices or create reports based on the results.
Why Choose This Calculator for Paylocity Holding Corporation (PCTY)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust variables effortlessly to suit your financial analysis.
- Real-Time Feedback: Monitor immediate shifts in Paylocity’s valuation as you tweak inputs.
- Preloaded Data: Comes equipped with Paylocity’s current financial metrics for swift evaluations.
- Industry Approved: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Human Resources Professionals: Streamline payroll and benefits management for better employee satisfaction.
- Finance Teams: Analyze compensation data to enhance budgeting and forecasting accuracy.
- Consultants and Advisors: Offer clients comprehensive insights into payroll solutions and HR technology.
- Students and Educators: Utilize real-world examples to learn about payroll systems and HR practices.
- Business Leaders: Gain insights into how effective HR solutions can drive company performance.
What the Template Contains
- Pre-Filled DCF Model: Paylocity's financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Paylocity’s 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.