Phoenix New Media Limited (FENG) DCF Valuation
- ✓ 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
Phoenix New Media Limited (FENG) Bundle
Designed for accuracy, our (FENG) DCF Calculator empowers you to evaluate Phoenix New Media Limited's valuation using up-to-date financial data and complete flexibility to modify all essential parameters for improved 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 | 209.8 | 165.6 | 141.2 | 107.6 | 94.8 | 77.9 | 64.0 | 52.5 | 43.1 | 35.4 |
Revenue Growth, % | 0 | -21.05 | -14.77 | -23.74 | -11.92 | -17.87 | -17.87 | -17.87 | -17.87 | -17.87 |
EBITDA | -37.4 | -9.0 | -37.0 | -18.7 | -11.4 | -12.3 | -10.1 | -8.3 | -6.8 | -5.6 |
EBITDA, % | -17.81 | -5.41 | -26.21 | -17.4 | -12.01 | -15.77 | -15.77 | -15.77 | -15.77 | -15.77 |
Depreciation | 15.4 | 10.8 | 9.0 | 7.5 | 5.8 | 5.2 | 4.3 | 3.5 | 2.9 | 2.4 |
Depreciation, % | 7.34 | 6.53 | 6.41 | 6.97 | 6.15 | 6.68 | 6.68 | 6.68 | 6.68 | 6.68 |
EBIT | -52.8 | -19.8 | -46.0 | -26.2 | -17.2 | -17.5 | -14.4 | -11.8 | -9.7 | -8.0 |
EBIT, % | -25.15 | -11.94 | -32.62 | -24.36 | -18.16 | -22.45 | -22.45 | -22.45 | -22.45 | -22.45 |
Total Cash | 221.0 | 224.4 | 205.2 | 156.9 | 148.8 | 77.9 | 64.0 | 52.5 | 43.1 | 35.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 91.1 | 97.0 | 70.4 | 65.1 | 48.1 | 41.0 | 33.7 | 27.6 | 22.7 | 18.6 |
Account Receivables, % | 43.45 | 58.59 | 49.89 | 60.43 | 50.76 | 52.62 | 52.62 | 52.62 | 52.62 | 52.62 |
Inventories | 11.4 | 4.3 | 2.1 | 1.2 | .0 | 1.7 | 1.4 | 1.1 | .9 | .8 |
Inventories, % | 5.42 | 2.57 | 1.52 | 1.15 | 0 | 2.13 | 2.13 | 2.13 | 2.13 | 2.13 |
Accounts Payable | 34.1 | 30.3 | 29.8 | 24.2 | 16.7 | 14.9 | 12.3 | 10.1 | 8.3 | 6.8 |
Accounts Payable, % | 16.26 | 18.3 | 21.08 | 22.52 | 17.65 | 19.16 | 19.16 | 19.16 | 19.16 | 19.16 |
Capital Expenditure | -11.5 | -1.7 | -2.3 | -4.7 | -1.3 | -2.2 | -1.8 | -1.5 | -1.2 | -1.0 |
Capital Expenditure, % | -5.48 | -1 | -1.63 | -4.32 | -1.4 | -2.77 | -2.77 | -2.77 | -2.77 | -2.77 |
Tax Rate, % | -6.61 | -6.61 | -6.61 | -6.61 | -6.61 | -6.61 | -6.61 | -6.61 | -6.61 | -6.61 |
EBITAT | -51.6 | -16.8 | -49.8 | -25.0 | -18.4 | -16.7 | -13.7 | -11.3 | -9.3 | -7.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -116.1 | -10.3 | -14.9 | -21.4 | -3.2 | -10.0 | -6.3 | -5.2 | -4.2 | -3.5 |
WACC, % | 6.75 | 6.61 | 6.77 | 6.72 | 6.77 | 6.72 | 6.72 | 6.72 | 6.72 | 6.72 |
PV UFCF | ||||||||||
SUM PV UFCF | -24.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -4 | |||||||||
Terminal Value | -75 | |||||||||
Present Terminal Value | -54 | |||||||||
Enterprise Value | -79 | |||||||||
Net Debt | -63 | |||||||||
Equity Value | -16 | |||||||||
Diluted Shares Outstanding, MM | 12 | |||||||||
Equity Value Per Share | -1.35 |
What You Will Receive
- Pre-Filled Financial Model: Phoenix New Media Limited’s (FENG) actual data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling repeated application for in-depth forecasts.
Key Features
- 🔍 Real-Life FENG Financials: Pre-filled historical and projected data for Phoenix New Media Limited (FENG).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Phoenix New Media’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Phoenix New Media’s 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 Phoenix New Media Limited (FENG) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Phoenix New Media Limited’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Phoenix New Media Limited (FENG)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for (FENG).
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value for (FENG).
- Preloaded Information: Includes historical and projected data for reliable analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focusing on (FENG).
Who Should Use This Product?
- Finance Students: Explore valuation methods and apply them using data from Phoenix New Media Limited (FENG).
- Academics: Integrate professional valuation models into your teaching or research projects.
- Investors: Evaluate your investment strategies and analyze valuation results for Phoenix New Media Limited (FENG) stock.
- Analysts: Enhance your analysis process with a customizable DCF model tailored for Phoenix New Media Limited (FENG).
- Small Business Owners: Understand the evaluation techniques used for large public companies like Phoenix New Media Limited (FENG).
What the Template Contains
- Pre-Filled Data: Contains Phoenix New Media Limited's historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet to compute WACC based on user-defined inputs.
- Key Financial Ratios: Assess Phoenix New Media Limited's profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
- Clear Dashboard: Visualizations and tables summarizing essential valuation outcomes.