L3VLUP
Valuation and returns · in 1 model

LTM build

Last fiscal year, plus the stub, less the prior stub.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: ltm build.Updated 30 September 2026

What it does

The trailing period every trading multiple is quoted on. The last audited year is rolled forward by the current year to date and rolled back by the same months of the prior year, so the result is the most recent twelve months the company has reported. The stub length is carried beside it so the arithmetic can be checked against the quarterly filings.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Comparable companies model
  • Assumptions, rows 31–37: Months reported in the current fiscal year, Revenue, year to date, Revenue, same period last year, EBITDA, year to date…
  • LTM, rows 6–9: Months in the stub, Revenue, LTM, EBITDA, LTM, Net income, LTM
  • LTM, rows 12–15: Revenue growth in the stub, year on year, EBITDA margin, LTM, LTM revenue over last fiscal year, Check: the prior-year stub is inside the prior fiscal year

What a reviewer looks for

  • Adding the current stub without subtracting the prior one.
  • A stub from the wrong number of months on one side of the subtraction.
  • Quoting an LTM multiple on a price that has moved since the stub was reported without saying so.

Learn it, then build it

Vocabulary: LTM (Last Twelve Months).

Other valuation and returns