Category: Equity Research, Fundamental Modeling, and Valuation [US Companies]
Objective: Build reusable Excel templates aligned with institutional research workflows and publication standards.
Scope: Three-statement projection models with driver-based revenue and margin logic, segment build capability where relevant, working capital and capital expenditure schedules, cash flow reconciliation, and share count and capital structure mechanics (dilution, buybacks, stock-based compensation, and net debt). Valuation modules should include public and private comparables, transaction comparables, and DCF frameworks with explicit cost of capital inputs, terminal value methods, and sensitivity analysis across discount rate, terminal multiple or growth, and key operating drivers.
Deliverables: Structured workbooks that separate inputs, operating drivers, financial statements, and valuation outputs, with standardized tables and charts suitable for research notes, banker packs, and investment committee materials. Embed audit checks for balance sheet balancing, cash flow tie-outs, circularity management, and reasonableness tests. Include optional modules such as price-target bridge sheets, quarterly preview and review templates, and alternative-data trackers with reconciliation checks.
Standards: Defensible methodology, consistent formatting, and repeatability across sectors.
... Show more