Phoenix New Media Limited (FENG) DCF Valuation

Phoenix New Media Limited (FENG) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Phoenix New Media Limited (FENG) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 43.45 58.59 49.89 60.43 50.76
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

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Phoenix New Media Limited (FENG) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Phoenix New Media Limited’s intrinsic value.
  5. 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.

No products were found matching.