We are very glad to let you know that we have created a new Excel Peter Lynch Chart template that illustrates the valuation bands based on the historical median P/E, P/S and P/B ratios.

You can calculate a company's BVPS using Microsoft Excel. First, enter the value of a common stock, retained earnings, and additional paid-in capital into cells A1 through A3.