← Back to Templates

PE Band Valuation Method

Description

PE Band Valuation Method thumbnail

Plots a price to earnings band chart: historical closing prices drawn against multiples of trailing earnings per share, so each line on the chart is what the stock would have cost at a given multiple. Where price sits inside its own band is the read, which tells you more than an absolute multiple for companies that have always traded rich or always traded cheap. Closing prices and quarterly EPS are pulled per date, sector labels frame the peer comparison, and last price marks the current position on the band.

Template Screenshots

PE Band Valuation Method screenshot 1

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
How does MarketXLS work?
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found