Cardlytics, Inc. (CDLX) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Cardlytics, Inc. (CDLX) Bundle
Evaluate Cardlytics, Inc.'s (CDLX) financial outlook like an expert! This (CDLX) DCF Calculator provides pre-filled financial information along with the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 210.4 | 186.9 | 267.1 | 298.5 | 309.2 | 345.6 | 386.3 | 431.7 | 482.5 | 539.3 |
Revenue Growth, % | 0 | -11.19 | 42.93 | 11.76 | 3.57 | 11.77 | 11.77 | 11.77 | 11.77 | 11.77 |
EBITDA | -12.8 | -39.5 | -89.9 | -419.0 | -99.0 | -133.3 | -149.0 | -166.6 | -186.2 | -208.1 |
EBITDA, % | -6.08 | -21.14 | -33.66 | -140.34 | -32.02 | -38.58 | -38.58 | -38.58 | -38.58 | -38.58 |
Depreciation | 7.4 | 12.4 | 33.7 | 43.7 | 29.5 | 32.5 | 36.3 | 40.6 | 45.3 | 50.7 |
Depreciation, % | 3.52 | 6.65 | 12.6 | 14.65 | 9.55 | 9.39 | 9.39 | 9.39 | 9.39 | 9.39 |
EBIT | -20.2 | -51.9 | -123.6 | -462.7 | -128.5 | -155.7 | -174.0 | -194.5 | -217.3 | -242.9 |
EBIT, % | -9.6 | -27.79 | -46.26 | -154.99 | -41.56 | -45.04 | -45.04 | -45.04 | -45.04 | -45.04 |
Total Cash | 104.5 | 293.2 | 233.5 | 121.9 | 91.8 | 212.6 | 237.6 | 265.6 | 296.8 | 331.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 85.4 | 86.6 | 117.2 | 120.1 | 126.0 | 146.3 | 163.6 | 182.8 | 204.3 | 228.4 |
Account Receivables, % | 40.56 | 46.31 | 43.87 | 40.22 | 40.75 | 42.34 | 42.34 | 42.34 | 42.34 | 42.34 |
Inventories | .1 | .1 | .1 | .1 | .0 | .1 | .1 | .2 | .2 | .2 |
Inventories, % | 0.06130305 | 0.05885752 | 0.03556507 | 0.0267969 | 0 | 0.03650451 | 0.03650451 | 0.03650451 | 0.03650451 | 0.03650451 |
Accounts Payable | 1.2 | 1.4 | 4.6 | 3.8 | 4.4 | 4.0 | 4.4 | 5.0 | 5.5 | 6.2 |
Accounts Payable, % | 0.58404 | 0.7293 | 1.73 | 1.26 | 1.43 | 1.15 | 1.15 | 1.15 | 1.15 | 1.15 |
Capital Expenditure | -11.0 | -10.1 | -12.6 | -13.5 | -12.4 | -16.5 | -18.4 | -20.6 | -23.0 | -25.8 |
Capital Expenditure, % | -5.24 | -5.41 | -4.7 | -4.52 | -4.01 | -4.78 | -4.78 | -4.78 | -4.78 | -4.78 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -20.8 | -54.8 | -116.4 | -461.3 | -128.5 | -153.8 | -171.9 | -192.1 | -214.7 | -240.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -108.7 | -53.5 | -122.7 | -434.8 | -116.6 | -158.7 | -170.8 | -190.9 | -213.4 | -238.5 |
WACC, % | 7.03 | 7.03 | 6.86 | 7.03 | 7.03 | 7 | 7 | 7 | 7 | 7 |
PV UFCF | ||||||||||
SUM PV UFCF | -786.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -243 | |||||||||
Terminal Value | -4,867 | |||||||||
Present Terminal Value | -3,470 | |||||||||
Enterprise Value | -4,256 | |||||||||
Net Debt | 174 | |||||||||
Equity Value | -4,431 | |||||||||
Diluted Shares Outstanding, MM | 36 | |||||||||
Equity Value Per Share | -121.43 |
What You Will Get
- Real CDLX Financial Data: Pre-filled with Cardlytics’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Cardlytics’ 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
- 🔍 Real-Life CDLX Financials: Pre-filled historical and projected data for Cardlytics, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Cardlytics’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Cardlytics’ valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Cardlytics data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Cardlytics’ intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Cardlytics, Inc. (CDLX)?
- Accuracy: Utilizes real Cardlytics financial data for precise calculations.
- Flexibility: Tailored for users to easily adjust and test various inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design allows even novices to navigate financial modeling effortlessly.
Who Should Use Cardlytics, Inc. (CDLX)?
- Marketers: Leverage advanced analytics to optimize advertising strategies and drive customer engagement.
- Data Analysts: Utilize robust data insights to enhance campaign performance and ROI.
- Business Strategists: Adapt the platform to create tailored reports for stakeholders and decision-makers.
- Finance Professionals: Gain a deeper understanding of consumer behavior and market trends through actionable data.
- Students and Educators: Employ it as a hands-on resource for learning about digital marketing and analytics.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Cardlytics, Inc. (CDLX).
- Real-World Data: Cardlytics' historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into Cardlytics' performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Cardlytics, Inc. (CDLX).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to Cardlytics, Inc. (CDLX).