Public-company models without rebuilding the workbook
Editable Excel models for forecasting, valuation, and public-company comps. Compare companies faster with DCF and comps templates built from real fundamentals.
Used by professionals from
Financial Models for Equity Analysts
Select and download any template to begin customizing your projections.
DCF Model
Discounted cash flow valuation model with explicit forecast, terminal value, and WACC.
Comparable Companies Analysis
Pull trading multiples from peer companies and calculate implied valuation ranges.
3 Statement Model
Integrated income statement, balance sheet, and cash flow forecasts.
EBITDA Bridge
Year-over-year EBITDA bridge decomposing variance across volume, price, variable costs, FX, and opex drivers.
Gross Margin Bridge
PY to CY gross profit walk across Volume, Price, Mix, Cost, FX for a 5-SKU portfolio.
Sum of Parts Valuation
Value a diversified company by valuing each business segment independently and summing the parts.
Free public-company model templates for equity analysts
Public-company models without rebuilding the workbook. Move faster from historicals to a valuation view, with DCF, comps, and 3-statement structures for company analysis that needs to hold up.
Every free download is a fully editable .xlsx model with live formulas, built to the same visual standard and compatible with Microsoft Excel, Google Sheets, and Apple Numbers.
Start from a public-company forecast, DCF model, comparable company analysis, 3-statement model, revenue forecast, EBITDA bridge, gross-margin bridge, or sum-of-the-parts model and build a cleaner research model.
Calculate your time savings
See how many hours your team can reclaim by using pre-made templates and automating Excel. Time spent actually closing deals rather than troubleshooting your model.
How many employees are using Excel every week?
Based on 5 hours/week in Excel, 30 min/day saved, and $100/hour rate.
Frequently asked questions
Are these equity research models pre-populated with company actuals?+
Our public-company models (accessible via the company search) are pre-built using real historicals from SEC EDGAR filings. The templates on this page provide the clean, reusable structural formulas for your own valuations.
How flexible is the terminal value calculation in the DCF model?+
The DCF templates let you toggle between the Gordon Growth Model (Perpetual Growth) and the Exit Multiple Method dynamically, with built-in sensitivity tables for WACC and growth rate inputs.
Can I use these models for equity valuation pitches or research reports?+
Yes. They are built to investment research standards, with structured output summaries and chart layouts suitable for investment committee decks or client deliverables.
Are the formulas transparent for auditing?+
Absolutely. All cells contain transparent, native formulas. We do not use password-protected sheets or compiled add-ins, making every cell fully auditable for your reports.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
