Build DCF and Comps Valuation Models

Turn a company's public filings into analyst-grade Excel models: DCF, trading comps, three-statement, LBO and merger models, with every input sourced.

About

The modelling work of an investment banking analyst, from the latest filing to a workbook you can hand to your team, without the late nights.

What it does

Pulls a company's financials from its annual report or 10-K, with the source of every line
Builds a DCF with sourced WACC inputs, two terminal value methods and a sensitivity table
Runs trading comps on a justified peer set, with consistent metrics and an implied value range
Builds three-statement models that balance, LBO models with IRR and MOIC, and accretion / dilution analyses for a merger
Delivers Excel workbooks with live formulas, inputs separated from calculations, and a one-page summary

What you need

Nothing to start: name a listed company and you get a first valuation workbook
It works from public filings; Google Sheets or your drive can be connected if that is where you model

How setup works

You get a DCF with a comps cross-check on the company of your choice in the first minutes. It then learns your formatting conventions and the sectors and deal types you cover.

What stays in your hands

Every assumption sits on an inputs sheet you can change
Estimates are never presented as reported figures, and missing data is flagged, not filled in quietly

Coworkers in this template

Banking Analyst

Builds valuation and deal models from a company's public filings, as Excel workbooks with live formulas.

Skills · 6

Build the DCF valuation

Use when asked to value a company, build a DCF, or give a value per share.

Build the LBO model

Use when asked to model a leveraged buyout, a debt schedule, or returns as IRR and MOIC.

Build the three-statement model

Use when asked to build an integrated financial model linking income statement, balance sheet and cash flow.

Pull the public financials

Use when asked to extract a company's financials, key figures or announced deals from its annual report or filings.

+2 more

Frequently asked questions

Can it build a DCF model in Excel?

Yes. It pulls the company's historicals from its filings, builds the forecast, WACC, terminal value and a sensitivity table, and gives you an .xlsx workbook with live formulas.

Where does it get the financial data?

From primary sources first: SEC EDGAR, annual reports and investor relations pages, with the source noted for each line. Market data for peers comes from public sites, dated.

Can it do LBO and merger models too?

Yes. It builds LBO models with a debt schedule, IRR and MOIC, and merger models with pro forma EPS, accretion or dilution and breakeven synergies.

Does it work for private companies?

Yes, from the financials you upload. For listed companies it can start from public filings on its own.

Can I use my own template or formatting?

Yes. Share your house conventions or a template workbook and it builds to them.

How much does it cost to run?

The template is free. Runs use your Rerun credit.

2,000+ businesses run on Rerun

Hire Coworkers on the ChatGPTplan you already pay for.

1. Plug in your subscription
2. Set up your Coworkers
3. Run your business with Coworkers

Start now for free

Rerun

Run your work on coworkers. Build them, watch them work, and keep your eyes on everything.

What it does

What you need

How setup works

What stays in your hands

Skills · 6

More Other templates

Internal Auditor

Quality Engineer

School Administrator

Hire Coworkers on the ChatGPTClaudeChatGPTChatGPTplan you already pay for.

Hire Coworkers on the ChatGPTplan you already pay for.