Home > Excel Business Solutions > Business Finance > Business Valuation > Stock Market Valuation Share

Stock Market Valuation

Excel stock market valuation for business valuation

Excel Stock Market Valuation

Rate this solution:
(4/5 from 3 votes)
This Stock Market Valuation spreadsheet template for Excel contains the 'Fed Valuation Model' method of stock market valuation that has long been used by the Federal Reserve Board of Governors to measure stock market overvaluation or undervaluation.

The stock market valuation template can easily analyze up to ten quarters of market performance at a time. Just enter the reporting date and a presentation quality report and chart are automatically generated.

Stock Market Valuation for Excel is preloaded with data from 1988 and contains room for additional data and/or estimates through to 2025. Hyperlinks to data sources are also included.

Reporting fields per date observation include:
  • Index code or name (e.g. SPX)
  • Forward Price/Earnings ratio (P/E)
  • 10 Year Treasury Yield
  • Fair Value P/E
  • Percent of Fair Value
  • Over/Under Valuation

Get It

(Pricing is available on the next page)
(Updated on 2023-09-01)

Related Excel Solutions for Stock Market Valuation

Investment and Business ValuationBusiness Valuation  Equity Valuation ModelBusiness Valuation  Financial Valuation and Modeling CourseBusiness Valuation

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.