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
Skip the chat. Check the valuation.
Search a company to view valuation charts, multiples, and a free AI report in one place.
Pick a ticker above to pre-fill symbols, or copy and replace placeholders 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.