FCFF DCF Model
Free Cash Flow to Firm — Intrinsic Value Estimator
Units:
$M
$B
Forecast:
5 yrs
7 yrs
10 yrs
↩ Undo
↪ Redo
🌙
Load Company Data
● embedded · FY2020–FY2024
— Select company —
Apple (AAPL)
NVIDIA (NVDA)
Microsoft (MSFT)
Amazon (AMZN)
Alphabet / Google (GOOGL)
Meta Platforms (META)
Taiwan Semiconductor (TSM)
Broadcom (AVGO)
Tesla (TSLA)
Eli Lilly (LLY)
Walmart (WMT)
ExxonMobil (XOM)
Netflix (NFLX)
Costco (COST)
Novo Nordisk (NVO)
Johnson & Johnson (JNJ)
Procter & Gamble (PG)
Home Depot (HD)
ASML (ASML)
Oracle (ORCL)
AbbVie (ABBV)
Palantir (PLTR)
Salesforce (CRM)
Toyota Motor (TM)
AMD (AMD)
▼
⬇ Download Financial Data (CSV)
($M)
Base Year
D&A Margin
%
−
+
For EV/EBITDA implied multiple
Discount Rate
WACC
%
−
+
Terminal Value
Terminal Growth (g)
%
−
+
Sustainable iROIC
%
−
+
Terminal reinv. rate = g ÷ iROIC
Balance Sheet Bridge
Net Debt
($M)
Non-controlling Interests
($M)
Cash & Equivalents
($M)
Marketable Securities
($M)
LT Marketable Securities
($M)
Equity Accounted Investments
($M)
Pension Deficit
($M)
Other Adjustments
($M)
Positive = add value · Negative = deduct value
Equity
Shares Outstanding (M)
Summary
Assumptions
Analysis
Projection
Summary Valuation
Enterprise Value
—
Equity Value
—
Intrinsic Value / Share
—
Per share
● Select a company to load live price
↻ Refresh
Market Price
—
52W High
—
52W Low
—
Intrinsic Value
—
Margin of Safety
—
EV Composition — Explicit FCFFs vs Terminal Value
PVGO Analysis — Steady State Value vs Growth Opportunities
· SSV = Y1 NOPAT ÷ WACC
Scenario Analysis
▼ Bear
—
−0.5σ growth & margin
● Base
—
Current assumptions
▲ Bull
—
+0.5σ growth & margin
Forecast Assumptions
drag nodes to adjust · grey = historical actuals
EV → Equity Bridge
Price / Share Sensitivity
WACC (rows) × Terminal Growth (cols)
Implied Fundamental Multiples
EV-based · LTM and next 3 forecast years
DCF Projection
IMPORTANT DISCLAIMER — FOR EDUCATIONAL PURPOSES ONLY.
This model and all outputs are provided solely for educational and illustrative purposes and do not constitute investment advice, financial advice, or any other form of professional advice regulated under the Financial Services and Markets Act 2000 (FSMA) or the Financial Services Act 2012. This tool is
not authorised or regulated by the Financial Conduct Authority (FCA)
and does not constitute a personal recommendation within the meaning of the FCA's Conduct of Business Sourcebook (COBS). The embedded financial data and any live or indicative market data displayed are
not live, real-time, or guaranteed to be accurate or complete
and may be materially out of date. Nothing in this model should be relied upon to make, or refrain from making, any investment or financial decision. Past financial performance is not a reliable indicator of future results. All valuations are based on user-supplied assumptions and are inherently speculative. Always seek independent, regulated financial advice before making any investment decision. © Educational use only — no reliance should be placed on this output.