DCF & WACC Valuation Dashboard

CSV CSV Data Import

CSV files are processed entirely in your browser. No data is uploaded to any server.

1 Select CSV File(s)

Drag & drop CSV files here, or

2 Import Type & Action

01 Company Information

Company Name

Ticker

Current Share Price ($)

Shares Outstanding (M) 3528M = 3.528B shares

Cash & Short-term Investments ($M)

Total Debt ($M)

Corporate Tax Rate (%)

02 Historical Financials Most Recent Fiscal Year · $M

Revenue ($M)

EBIT ($M)

Depreciation & Amortization ($M)

CAPEX ($M)

Change in NWC ($M)

Operating Cash Flow ($M)

ROIC — Return on Invested Capital (%) Optional · used in Investment Checklist

Free Cash Flow — Two Methods

Method 1 · OCF − CAPEX

—

FCF = Operating Cash Flow − Capital Expenditure

Method 2 · NOPAT + D&A − CAPEX − ΔNWC

—

FCF = EBIT×(1−t) + D&A − CAPEX − ΔNWC

03 WACC — Weighted Average Cost of Capital

Risk-free Rate (%) 10-yr US Treasury yield

Equity Risk Premium (%)

Beta (β)

Pre-tax Cost of Debt (%)

Market Value of Equity ($M)

Override manually

Auto = Share Price × Shares Outstanding

Market Value of Debt ($M)

Computed Components

Cost of Equity (Ke)

—

Rf + β × ERP

After-tax Cost of Debt

—

Kd × (1 − Tax Rate)

Equity Weight (wE)

—

MVE / (MVE + MVD)

Debt Weight (wD)

—

MVD / (MVE + MVD)

WACC

Weighted Avg. Cost of Capital

—

Ke·wE + Kd(1−t)·wD

WACC — INPUTS & INTERMEDIATE STEPS

04 Forecast Assumptions

Forecast Period (years)

Revenue Growth — Year 1 (%)

Revenue Growth — Year 2 (%)

Revenue Growth — Year 3 (%)

Revenue Growth — Year 4 (%)

Revenue Growth — Year 5 (%)

Long-term Growth (Yr 6+) (%)

EBIT Margin — Year 1 (%)

EBIT Margin — Year 10 Target (%) Optional · model expands margin linearly to this target

D&A as % of Revenue

CAPEX as % of Revenue

ΔNWC as % of Revenue

Terminal Growth Rate (%) Must be below WACC

Annual Share Dilution (%) Optional · e.g. 2.0 for 2% annual dilution

05 Free Cash Flow Forecast FCF = NOPAT + D&A − CAPEX − ΔNWC

Year	Revenue ($M)	Growth	EBIT ($M)	NOPAT ($M)	D&A ($M)	CAPEX ($M)	ΔNWC ($M)	FCF ($M)	Disc. Factor	PV of FCF ($M)
Run valuation to generate forecast ▶

06 Terminal Value & PV Bridge Gordon Growth Model

Terminal Value ($M)

—

FCF_n × (1 + g) / (WACC − g)

PV of Terminal Value ($M)

—

TV / (1 + WACC)^n

Sum of PV of FCFs ($M)

—

TV as % of Enterprise Value

—

FCF Value vs Terminal Value split

—

07 Valuation Summary

Enterprise Value

—

∑PV(FCF) + PV(TV)

Net Debt

—

Total Debt − Cash

Equity Value

—

EV − Net Debt

Fair Value / Share

—

Equity Value ÷ Shares (M)

Current Share Price

—

As entered

Implied Upside / Downside

—

DCF Calculation Audit — Step-by-Step Verification

08 Sensitivity Analysis Fair Value / Share · WACC × Terminal Growth

Fair Value per Share — WACC vs Terminal Growth Rate

Higher than base

Base case

Lower than base

Invalid (TGR ≥ WACC)

Run valuation to generate sensitivity table ▶

09 Scenario Analysis Bear ×0.70 Rev Growth / ×0.80 EBIT Margin / +100bps WACC / −0.5pp TGR · Bull ×1.30 Rev Growth / ×1.20 EBIT Margin / −100bps WACC / +0.5pp TGR

Bear Case Stress

Rev. Growth (Y1)—

EBIT Margin—

WACC—

Terminal Growth—

FAIR VALUE / SHARE

—

Base Case Primary

Rev. Growth (Y1)—

EBIT Margin—

WACC—

Terminal Growth—

FAIR VALUE / SHARE

—

Bull Case Upside

Rev. Growth (Y1)—

EBIT Margin—

WACC—

Terminal Growth—

FAIR VALUE / SHARE

—

Scenario Comparison

Scenario	WACC	Terminal Growth	Fair Value / Share	Upside / Downside	Investment View
Run valuation to populate scenario comparison ▶

10 Custom Scenario Analysis Manually edit Bear / Base / Bull assumptions

Scenario Assumptions — Edit any cell, then click Calculate Scenarios

Assumption	Bear Case	Base Case	Bull Case
Revenue Growth — Year 1 (%)
Revenue Growth — Year 2 (%)
Revenue Growth — Year 3 (%)
Revenue Growth — Year 4 (%)
Revenue Growth — Year 5 (%)
Long-term Growth After Year 5 (%)

EBIT Margin (%)
D&A as % of Revenue
CAPEX as % of Revenue
Change in NWC as % of Revenue

WACC (%)
Terminal Growth Rate (%)

Metric	Bear Case	Base Case	Bull Case
Click "Calculate Scenarios" to run ▶

11 Margin of Safety Buy Price = Fair Value × (1 − MoS%)

Custom Margin of Safety: % Updates automatically after running valuation

Margin of Safety	Fair Value / Share	Buy Price	vs. Current Price	Status
Run valuation to calculate buy zones ▶

Margin of safety helps avoid overpaying. The higher the uncertainty in the business or assumptions, the larger the margin of safety should be. A 20–30% margin of safety is common for moderately predictable businesses; 40%+ is appropriate for highly uncertain or cyclical companies.

12 Company Comparison

Compare up to 3 companies using DCF-derived upside, quality metrics, and balance sheet strength.

Company A

Name
Ticker
Fair Value / Share ($)
Current Price ($)
Revenue Growth (%) Y1
FCF Margin (%)
ROIC (%)
Gross Margin (%)
Net Debt / Equity (%)
Interest Coverage (x)
P/E Ratio
EV / EBITDA
Dividend Yield (%)
Beta
Quality Score (/ 10)
Risk Score (/ 10)	Lower = less risky

Company B

Name
Ticker
Fair Value / Share ($)
Current Price ($)
Revenue Growth (%) Y1
FCF Margin (%)
ROIC (%)
Gross Margin (%)
Net Debt / Equity (%)
Interest Coverage (x)
P/E Ratio
EV / EBITDA
Dividend Yield (%)
Beta
Quality Score (/ 10)
Risk Score (/ 10)	Lower = less risky

Company C

Name
Ticker
Fair Value / Share ($)
Current Price ($)
Revenue Growth (%) Y1
FCF Margin (%)
ROIC (%)
Gross Margin (%)
Net Debt / Equity (%)
Interest Coverage (x)
P/E Ratio
EV / EBITDA
Dividend Yield (%)
Beta
Quality Score (/ 10)
Risk Score (/ 10)	Lower = less risky

13 Investment Checklist

Run valuation to generate investment checklist ►

14 Moat & Quality Score

5.0

/ 10

50 / 100

Average / Some Moat

Adjust the 10 factor sliders below — score updates live

—

Top ≥ 7

Brand Strength

How strong and recognizable is the company's brand?

1510

Pricing Power

Can the company raise prices without losing significant demand?

1510

Revenue Predictability

How stable and recurring are the company's revenues?

1510

Margin Stability

How stable are gross, EBIT, and FCF margins over time?

1510

Competitive Advantage

Does the company have a durable edge over competitors?

1510

Market Position

Is the company a leader in its industry or niche?

1510

Balance Sheet Strength

Does the company have low debt, strong cash, and financial flexibility?

1510

Capital Efficiency

Does the company generate high returns without requiring excessive reinvestment?

1510

Innovation Capability

Can the company keep launching valuable products, services, or technology?

1510

Management Execution

Does management allocate capital and execute strategy effectively?

1510

Adjust the factor sliders above to generate the moat & quality analysis.

15 Red Flag Checker

Run valuation to check assumptions for red flags ►

16 Equity Research — Investment Analysis

Run valuation to generate equity research analysis ▶

Field	What it is & where to find it
Company Name	Full legal name of the company (e.g. Tesla, Inc.)
Ticker	Stock exchange symbol — e.g. TSLA, AAPL, MSFT
Current Share Price ($)	Today's share price in USD. Yahoo Finance → Quote
Shares Outstanding (M)	Total diluted shares in millions. Yahoo Finance → Statistics → Shares Outstanding or 10-K cover page.
Cash & Short-term Investments ($M)	Cash, equivalents, and short-term investments. Balance sheet → Cash & Cash Equivalents + Short-term Investments.
Total Debt ($M)	All interest-bearing debt (short + long term). Balance sheet → Total Debt (or Short-term Debt + Long-term Debt).
Corporate Tax Rate (%)	Effective tax rate. Income statement → Income Tax / Pre-tax Income. Typical 15–28%. Used across all sections.

Field	What it is & where to find it
Revenue	Total net revenue / sales. Income statement → Revenue
EBIT	Earnings Before Interest & Tax = Operating Income. Income statement → Operating Income
D&A	Depreciation & Amortization. Cash flow statement → D&A or income statement footnotes.
CapEx	Capital Expenditures (enter as positive). Cash flow statement → Capital expenditures
Change in NWC	Increase in net working capital (positive = cash outflow). Cash flow statement → Changes in working capital
Tax Rate (%)	Effective tax rate. Income statement → Income tax / Pre-tax income. Typical range 15–28%.

Field	What it is & where to find it
Risk-Free Rate (%)	Yield on 10-year US Treasury. finance.yahoo.com → ^TNX or FRED. Typical: 4–5%.
Equity Risk Premium (%)	Extra return investors demand above the risk-free rate. Use Damodaran's current US ERP. Typical: 4.5–6%.
Beta (β)	Stock's sensitivity to the market (1.0 = market). Yahoo Finance → Statistics → Beta (5Y monthly).
Pre-tax Cost of Debt (%)	Interest rate the company pays on its debt. Estimate: Interest Expense ÷ Total Debt, or look up the bond yield. Macrotrends → Interest Expense ÷ Total Debt.
Market Value of Equity ($M)	Auto-calculated: Share Price × Shares Outstanding (M). No need to enter manually — updates when you fill in Company Information.
Market Value of Debt ($M)	Book value of total debt is a common proxy. Balance sheet → Total Debt. Same as the "Total Debt" you entered above.

Field	What it is & where to find it
Revenue Growth Yr 1 (%)	Expected revenue growth next year. Use analyst consensus or your own estimate. Yahoo Finance → Analysis → Revenue Estimate
Revenue Growth Yr 2–5 (%)	Average annual growth for years 2 through 5. Often company guidance or sector average.
EBIT Margin (%)	Target operating profit margin. Use historical average or analyst estimate. Macrotrends → Operating Margin
Terminal Growth Rate (%)	Perpetuity growth rate after yr 10. Should not exceed long-run GDP growth (~2–3%). Conservative default: 2.5%.

Source	Best for
Yahoo Finance	Price, shares, beta, income statement, cash flow
Macrotrends.net	10-year historical margins, revenue, CapEx charts
SEC EDGAR (10-K)	Full audited financials — most accurate source
Damodaran Online	ERP, betas by sector, country risk premiums
FRED (St. Louis Fed)	Current 10-year Treasury yield (risk-free rate)