Here's the prompt I used (which gpt4o wrote this for me). Would welcome any feedback for how to tweak the next run.

Conduct an in-depth analysis to identify the most undervalued companies in the S&P 500 based on fundamental valuation metrics. The goal is to determine which stocks currently present the best value for purchase.

Key Criteria for Valuation:

• Price-to-Earnings (P/E) Ratio: Identify companies with below-average P/E ratios compared to their sector peers and historical averages.
• Price-to-Book (P/B) Ratio: Look for stocks trading below their book value, particularly in asset-heavy industries.
• Discounted Cash Flow (DCF) Analysis: Estimate the intrinsic value of stocks using a DCF model and compare it to their current market price.
• Enterprise Value-to-EBITDA (EV/EBITDA): Identify companies with low EV/EBITDA ratios relative to historical norms and competitors.
• Free Cash Flow Yield: Prioritize stocks with strong free cash flow (FCF) and high FCF yield, indicating sustainable profitability.
• Dividend Yield & Stability: Consider companies offering attractive dividend yields with a history of consistent payouts.
• Debt Levels & Financial Health: Analyze debt-to-equity and interest coverage ratios to assess financial stability.

Additional Considerations:

• Exclude companies experiencing severe financial distress, regulatory issues, or major earnings declines.
• Favor companies with strong revenue growth, increasing margins, and improving operational efficiency.
• Take into account macroeconomic factors (interest rates, inflation, industry trends) that may affect valuations.

Deliverables:

• A ranked list of the top 10 undervalued S&P 500 stocks based on the criteria above.
• A brief summary for each company explaining why it is considered undervalued.
• Key risks and potential catalysts for stock appreciation.