Investment Research & Financial Modeling
User-Entered Data — Unverified — Not Actual Investment Advice
Data StatusManual entry — no verified data source connectedSearch a public company above to load real SEC EDGAR filings.Data & Sources

About This Model

Scope, methodology and limitations.

Purpose

This project is a simplified financial modeling and valuation framework designed for educational and analytical purposes. Outputs are estimates generated from user-defined assumptions and should not be interpreted as guaranteed investment returns or financial advice.

Historical data should be sourced from company filings or other reliable financial sources. The dataset loaded by default describes a fictional company and is labelled “Illustrative / Example Data” throughout the application. No figure in the example dataset represents any real company’s reported results.

Live Company Data

Searching a company in the header loads reported annual financial statements directly from the U.S. Securities and Exchange Commission’s EDGAR XBRL company-facts service. Every loaded fiscal year records the form type, filing date and accession number it came from, and links back to the original filing on SEC.gov.

  • Reported figures are actuals. Forecasts, valuations and returns remain analyst estimates built on editable assumptions.
  • XBRL tagging varies between filers. Where a statement line cannot be mapped, the field is reported as “data unavailable / mapping required” rather than filled with a substitute value.
  • Current share price, market capitalization and the 52-week range require a separate market-data provider. When none is configured, the application states that live market data is unavailable instead of showing a stale or invented price.
  • Data & Sources shows the retrieval timestamp and lets you refresh the filings on demand.

Analytical Workflow

  1. Historical financial statements are entered by the analyst and checked for internal consistency.
  2. A driver-based five-year forecast projects the income statement, working capital and capex.
  3. Unlevered free cash flow is derived from EBIT, taxes, D&A, capex and the change in net working capital.
  4. A DCF discounts those cash flows at WACC and adds a Gordon-growth terminal value.
  5. Trading comparables provide a market-based cross-check on the intrinsic valuation.
  6. A simplified LBO tests whether the asset can support a financial-sponsor return.
  7. Scenario and sensitivity analysis stress-tests the conclusions across the key drivers.
  8. The analyst records a recommendation and writes it up in the investment memo.
  • No real company financial data is fabricated; the default dataset is explicitly fictional and labelled.
  • Historical actuals and forecast years are visually distinguished in every table.
  • Assumptions (editable inputs) are distinguished from calculated outputs.
  • No calculated result is hard-coded — every output recalculates from its inputs.
  • Major outputs expose a “View Calculation” panel showing inputs, formula and result.
  • Missing or invalid inputs produce an explicit error rather than a silent substitution.

Projections and valuations shown here are estimates generated from user-defined assumptions. They are not guaranteed investment returns, not a forecast of actual results, and not investment advice. Historical data should be sourced from company filings or other reliable financial sources.