DCF Valuation Workstation

Institutional Discounted Cash Flow & Comps WACC Suite

Step 1 of 6 • Company Selection & 3-Year Historical Verification

Select Target Company & Verify Historical Financials

Pull 3 years of historical statements via the Financial Modeling Prep (FMP) API, or upload/paste directly from S&P Capital IQ. No figures are ever fabricated—any missing API field is flagged for your confirmation.

Verification Required: 21 Required Fields Could Not Be Accessed or Verified

To guarantee institutional accuracy and never fabricate financial numbers, please input or upload from CapIQ the highlighted fields below before finalizing your valuation:

Market Snapshot: Current Share PriceMarket Snapshot: Diluted Shares OutstandingMarket Snapshot: Market CapitalizationMarket Snapshot: Total Debt (ST + LT)Market Snapshot: Cash & Short-Term InvestmentsMarket Snapshot: Raw Levered Beta (5Y)FY 2023: Total Revenue ($M)FY 2023: Operating Income / EBIT ($M)FY 2023: Depreciation & Amortization (D&A) ($M)FY 2023: Capital Expenditures (CapEx) ($M)+11 more fields

Current Market & Balance Sheet Bridge Data

Used for WACC capital structure weights and bridging from Enterprise Value to Implied Equity Value & Share Price.

All monetary values in $ Millions (except Share Price & Beta)
Needs Input
$ / sh
Needs Input
Millions
Needs Input
$ Millions
Needs Input
$ Millions
Needs Input
$ Millions
Verified
$ Millions
Verified
$ Millions
Needs Input
Beta

3-Year Historical Financials ($ in Millions)

Verify each historical line item. Any cell can be edited directly or populated via CapIQ upload.

FMPCapIQVerifiedNeeds Input
Line Item ($ in Millions)
FY
FY
FY
Income Statement
Total Revenue ($M)Core
Gross Profit ($M)
R&D Expense ($M)
SG&A Expense ($M)
Operating Income / EBIT ($M)Core
EBITDA ($M)
Interest Expense ($M)
Pre-Tax Income / EBT ($M)
Income Tax Expense ($M)
Cash Flow & UFCF Drivers
Depreciation & Amortization (D&A) ($M)Core
Capital Expenditures (CapEx) ($M)Core
Stock-Based Compensation (SBC) ($M)
Non-Cash Working Capital Balance ($M)
Change in Net Working Capital (ΔNWC) ($M)Core

Computed Historical Ratios & 3-Year Averages (% of Revenue)

These historical averages automatically seed your UFCF drivers (D&A, CapEx, Tax Rate, NWC, and SBC) in Step 4 for your confirmation.

Historical Ratio / MetricFY 2023FY 2024FY 20253-Year Average / CAGR
Revenue YoY Growth / 3-Yr CAGR (%)———— (CAGR)
Gross Margin (%)———45.0%
Operating (EBIT) Margin (%)———20.0%
EBITDA Margin (%)———25.0%
Effective Tax Rate (% of EBT)———21.0%
D&A (% of Revenue)———4.0%
CapEx (% of Revenue)———4.5%
Change in NWC (% of Revenue)———0.8%
Stock-Based Comp (% of Revenue)———2.0%