FlexShopper, Inc. (FPAY) 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
FlexShopper, Inc. (FPAY) Bundle
Discover the true potential of FlexShopper, Inc. (FPAY) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how changes affect FlexShopper, Inc. (FPAY) valuation – all within one convenient Excel template.
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 | 88.8 | 102.1 | 125.4 | 113.1 | 117.0 | 126.2 | 136.1 | 146.8 | 158.3 | 170.8 |
Revenue Growth, % | 0 | 14.97 | 22.87 | -9.86 | 3.47 | 7.86 | 7.86 | 7.86 | 7.86 | 7.86 |
EBITDA | 5.1 | 4.6 | 90.8 | 71.0 | 13.7 | 39.7 | 42.8 | 46.2 | 49.8 | 53.7 |
EBITDA, % | 5.75 | 4.53 | 72.43 | 62.82 | 11.7 | 31.45 | 31.45 | 31.45 | 31.45 | 31.45 |
Depreciation | 88.0 | 127.5 | 115.6 | 117.4 | .0 | 98.7 | 106.5 | 114.9 | 123.9 | 133.6 |
Depreciation, % | 99.11 | 124.91 | 92.16 | 103.88 | 0 | 78.25 | 78.25 | 78.25 | 78.25 | 78.25 |
EBIT | -82.9 | -122.9 | -24.7 | -46.4 | 13.7 | -61.2 | -66.0 | -71.2 | -76.8 | -82.8 |
EBIT, % | -93.36 | -120.37 | -19.73 | -41.06 | 11.7 | -48.49 | -48.49 | -48.49 | -48.49 | -48.49 |
Total Cash | 6.9 | 8.5 | 5.1 | 6.1 | 4.4 | 7.4 | 8.0 | 8.6 | 9.3 | 10.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 8.3 | 10.0 | 29.9 | 68.5 | 80.6 | 43.5 | 46.9 | 50.6 | 54.6 | 58.9 |
Account Receivables, % | 9.32 | 9.83 | 23.84 | 60.57 | 68.89 | 34.49 | 34.49 | 34.49 | 34.49 | 34.49 |
Inventories | 31.1 | 42.8 | 40.9 | 31.6 | 29.1 | 41.0 | 44.2 | 47.7 | 51.4 | 55.5 |
Inventories, % | 34.98 | 41.95 | 32.64 | 27.91 | 24.9 | 32.48 | 32.48 | 32.48 | 32.48 | 32.48 |
Accounts Payable | 4.6 | 7.9 | 8.0 | 6.5 | 7.1 | 7.9 | 8.5 | 9.1 | 9.9 | 10.6 |
Accounts Payable, % | 5.14 | 7.75 | 6.36 | 5.76 | 6.1 | 6.22 | 6.22 | 6.22 | 6.22 | 6.22 |
Capital Expenditure | -2.2 | -3.1 | -4.9 | -6.5 | -6.3 | -5.2 | -5.6 | -6.1 | -6.5 | -7.1 |
Capital Expenditure, % | -2.52 | -3.03 | -3.95 | -5.75 | -5.42 | -4.13 | -4.13 | -4.13 | -4.13 | -4.13 |
Tax Rate, % | 18.95 | 18.95 | 18.95 | 18.95 | 18.95 | 18.95 | 18.95 | 18.95 | 18.95 | 18.95 |
EBITAT | -60.3 | 129.3 | -20.0 | 210.7 | 11.1 | -28.7 | -30.9 | -33.4 | -36.0 | -38.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -9.3 | 243.5 | 72.8 | 291.0 | -4.3 | 90.8 | 63.9 | 68.9 | 74.3 | 80.2 |
WACC, % | 11.69 | 1.86 | 12.76 | 1.86 | 12.82 | 8.2 | 8.2 | 8.2 | 8.2 | 8.2 |
PV UFCF | ||||||||||
SUM PV UFCF | 301.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 82 | |||||||||
Terminal Value | 1,320 | |||||||||
Present Terminal Value | 890 | |||||||||
Enterprise Value | 1,191 | |||||||||
Net Debt | 111 | |||||||||
Equity Value | 1,080 | |||||||||
Diluted Shares Outstanding, MM | 16 | |||||||||
Equity Value Per Share | 66.42 |
What You Will Get
- Real FlexShopper Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for FlexShopper, Inc. (FPAY).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates tailored for FlexShopper, Inc. (FPAY).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on FlexShopper, Inc. (FPAY)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specifically for FlexShopper, Inc. (FPAY).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for FlexShopper, Inc. (FPAY).
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation frameworks tailored for FlexShopper, Inc. (FPAY).
- WACC Calculator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Adjust growth projections, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to FlexShopper, Inc. (FPAY).
- Interactive Dashboard and Charts: Visual representations provide a summary of essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the comprehensive Excel file featuring FlexShopper, Inc.'s (FPAY) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose FlexShopper, Inc. (FPAY) Calculator?
- Accuracy: Utilizes real FlexShopper financial data for precise calculations.
- Flexibility: Allows users to experiment with and adjust inputs effortlessly.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users with varying financial backgrounds.
Who Should Use This Product?
- Individual Consumers: Make informed choices about utilizing FlexShopper's financing options for purchases.
- Retail Analysts: Enhance market assessments with comprehensive data on consumer finance trends.
- Financial Advisors: Provide clients with effective financing solutions and insights into FlexShopper's offerings.
- Small Business Owners: Learn how FlexShopper can help improve sales through flexible payment options.
- Finance Students: Gain practical knowledge of consumer finance and credit models using real-world examples.
What the Template Contains
- Preloaded FPAY 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.