Financial modeling · Chicago, IL

I will do
your DCF.

A portfolio of financial models — DCFs, trading comps, transaction comps, and LBOs — built from scratch on public filings. Want one done on a specific company? Ask below.

View models → Request a model →
4
Companies modeled
5yr
Projection horizon
10-K
Primary source
WACC
Discount methodology

Financial models

4 models
TTD · Nasdaq  ·  May 16, 2026
The Trade Desk

Trading comps on The Trade Desk using FY2025 financials. 5-company peer set (DV, MGNI, PUBM, CRTO, APP), LTM multiples across EV/Revenue, EV/Gross Profit, EV/EBITDA, P/FCF, and P/E, with implied share price range and football field chart.

Trading Comps Ad Tech Nasdaq
Implied Share Price Range
$9.90 – $14.94
vs. $21.15 market−29%–53%
Download Excel ↓
DG · NYSE  ·  May 14, 2026
Dollar General

LBO model on Dollar General using FY2025 financials. 5-year hold, 4.5x Debt/EBITDA entry leverage, 8.5% interest rate, cash sweep mechanics, and IRR/MOIC sensitivity tables across exit multiples and acquisition premiums.

LBO Consumer Staples NYSE
IRR  /  MOIC
13.2% / 1.9x
9.7x entry · 25% premium
Download Excel ↓
PEP · Nasdaq  ·  May 10, 2026
PepsiCo, Inc.

DCF built on PepsiCo's FY2025 10-K. 5-year projection with WACC-derived discount rate, exit multiple terminal value, and sensitivity analysis on implied share price.

DCF Consumer Staples S&P 500
Implied Share Price
$172.36
vs. $154.62 market+11.48%
Download Excel ↓

Want a model
on your company?

Drop a ticker and some context. I’ll build a DCF, comps set, or LBO — from scratch, using public filings — and post it to the site.

Public companies only (need 10-K or 20-F)
U.S. or international equities welcome
Turnaround typically 1–2 weeks
Free — this is practice, not consulting
Request received — I’ll follow up at your email once the model is underway. Usually within a few days.

Built to learn.
Shown to prove it.

This site is a live record of financial models I build while studying for investment banking and buy-side roles. Every model starts from a public filing and is built from scratch in Excel — no templates.

troy@iwilldoyourdcf.com
troyrshen.com →
School
University of Chicago — B.A. Economics & Computer Science, 2026
Experience
Greenridge Capital Partners — Senior Analyst
Tools
Yahoo Finance, 10-K filings, Excel, Pitchbook