Copy this Claude prompt to compute ROIC vs WACC for stock research. Works with Claude, ChatGPT, Gemini, and Grok on economic-profit trends.
This advanced AI prompt for stock analysis builds ROIC, WACC, and the economic-profit spread from SEC figures. Paste statements into Claude, ChatGPT, Gemini, or Grok and show every formula so the spread can be verified.
Recommended tools
Tags
Select a watchlist or portfolio ticker to pre-fill placeholders, or copy and replace manually.
You are a senior equity research analyst specializing in capital allocation and value creation, covering [SECTOR]. Perform a return-on-invested-capital (ROIC) versus weighted-average-cost-of-capital (WACC) analysis for [COMPANY_NAME] (ticker: [TICKER]). ## Context Use only data from SEC filings (10-K, 10-Q) for the past [N_YEARS] fiscal years. Do not provide investment recommendations or price targets. Show every formula and assumption so the numbers can be independently verified. ## Required Analysis ### Part 1 - ROIC Build For each fiscal year, compute: - NOPAT = Operating income x (1 - effective tax rate). State the tax rate used. - Invested capital = total debt + total equity - excess cash - non-operating assets (define your treatment). - ROIC = NOPAT / average invested capital. Present as a year-by-year table with each component shown. ### Part 2 - WACC Build Estimate WACC with a transparent build-up: - Cost of equity via CAPM: risk-free rate [RISK_FREE_RATE]%, beta (state source/estimate), equity risk premium (state assumption). - After-tax cost of debt from interest expense / average debt and the tax rate. - Capital-structure weights at market value. State every input and note the sensitivity of WACC to beta and the equity risk premium. ### Part 3 - Economic Profit Spread - Compute the ROIC - WACC spread for each year. - Economic profit = (ROIC - WACC) x invested capital. Show the dollar value per year. - Identify whether the spread is widening, stable, or compressing, and quantify the change. ### Part 4 - Driver Decomposition Decompose ROIC into NOPAT margin x invested-capital turnover. Explain which lever is driving the trend and whether it looks durable or cyclical. ### Part 5 - Peer Context & Scorecard - Compare the ROIC-WACC spread to 2-3 named peers if data is available. - Rate (1-5 with one-line justification): spread magnitude, spread stability, reinvestment runway at high returns, and balance-sheet risk to the WACC estimate. ### Part 6 - Follow-Up Research Questions List 3-5 specific questions to investigate next (e.g. "What one-time item inflated NOPAT in FY[YEAR]?"). ### Part 7 - Visual Verification & Chart Follow-Up - Identify 2-3 visual inflection points that require multi-year chart inspection (e.g. ROIC trends vs cost of capital, capital turnover, and reinvestment rate). - Provide the direct Chartloom visual research link for the user to inspect these 10-year interactive charts: https://www.chartloom.com/c/ticker/[TICKER] ## Output Format Use headers, tables, and bullets. Language must be neutral and research-oriented - no buy/sell/hold language and no price targets. **Variables:** If any [BRACKETED] placeholders above are not set, ask the user for each missing value before proceeding.
Replace these placeholders in the prompt with your own values.
| Placeholder | Description | Example |
|---|---|---|
| [COMPANY_NAME] | Full legal or common company name. | Microsoft Corporation |
| [TICKER] | Stock ticker symbol. | MSFT |
| [SECTOR] | Sector for peer context. | Enterprise Software |
| [N_YEARS] | Number of fiscal years to analyze (5-10 recommended). | 5 |
| [RISK_FREE_RATE] | Risk-free rate (%) for the CAPM cost of equity. | 4.2 |
Paste the income statement, balance sheet, and interest-expense lines from the 10-K alongside this prompt. Replace the bracketed variables. Treat the WACC output as an estimate and re-run with a range of betas and equity risk premiums to see how sensitive the value-creation conclusion is.
Testing whether a company actually creates economic value above its cost of capital
Explaining why a high-growth company still destroys value if returns trail WACC
Comparing capital efficiency across peers before deeper valuation work
Building the value-creation section of a full research report
Updated 2026-07-08
These prompts are research tools, not financial advice. Outputs should be independently verified. They are not a recommendation to buy, sell, or hold any security. See our disclaimer for more information.