Stock Market Valuation

Excel Stock Market Valuation for Business Valuation

Submit an Excel Solution
Submit Solution [Guide]

Recently Added:
Bezier Curve Fitting
Yellow Pages Data Mining
Multiple Workbook Control
Loan Amortization Calculator and Schedule
Geographical Data Mapping
More Resources:
Excel Help Forum




Follow Business Spreadsheets On:
 
Find Excel Solutions:
Select suggested text to load results or icon to view solution.
Browse Main Categories: Business Finance | Financial Markets | Operations Management | Excel Productivity
 

Stock Market Valuation
Rate this solution:
(3/5 from 1 vote)
Buy Now
Stock Market Valuation screenshot
Pin It
 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

Buy Now
Price: USD 29.95

Related Excel Solutions:Investment and Business Valuation (Business Valuation) | Financial Investment Analysis (Portfolio Management) | Equity Valuation Model (Business Valuation) | WACC Calculator (Financial Analysis) | Economic Simulations (Risk Analysis)

Share your thoughts with other users: Create your own review
 

Download Stock Market Valuation Reference
For iTunes & iOS Device


Popular Searches
1.
2.
3.
4.
5.
Add Economic Data to Excel Reports and Dashboards
See How Here

       
  © 2013 Business Spreadsheets. All Rights Reserved. Legal | About Us