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-08-01) |
Additional Excel business solutions are categorized as
Free Excel solutions and the
most popular. Further solutions proposed for specific user requirements can be either found in the
Excel Help Forum.