- Home
- Skills
- Finance & Accounting
- roic capital allocation analyzer
Works with the AI Agents you already use
roic capital allocation analyzer
Financial analysis often suffers from inconsistent definitions and manual calculation errors when measuring performance.
$1
roic capital allocation analyzer
Example session with this skill installed
Analyze ROIC for 2024. Op income 500, tax 20%. Invested capital components: Net PPE 1200, NWC 300. WACC is 8%. Compare this to a scenario: invest 200 for 50 incremental NOPAT over 5 years.
- Read your context and instructions
- Compiled the roic capital allocation
Processed the financial data for the 2024 fiscal year and simulated the requested investment scenario.
ROIC and Capital Allocation Analysis — Analysis Corp, 2025-05-20
1. Scope, sources and assumptions
Sources: E1 (User provided operating figures).
Period: 2024-FY.
Currency: USD (Scale: 1).
Basis: Operating approach, closing capital.
Tax Rate: 20.00% (User supplied).
2. NOPAT, invested capital and ROIC
| Period | NOPAT | Invested capital (closing) | Denominator | ROIC | ROIC ex goodwill | NOPAT margin | Capital turnover |
|---|---|---|---|---|---|---|---|
| 2024-FY | 400.00 | 1500.00 | 1500.00 | 0.2667 | 0.2667 | null | null |
3. Return versus cost of capital
| Period | ROIC | WACC | Spread | Spread (pp) | Economic profit | Signal |
|---|---|---|---|---|---|---|
| 2024-FY | 0.2667 | 0.0800 | 0.1867 | 18.67 | 280.05 | return above WACC |
4. Capital efficiency trends and ROIC bridge
No comparable consecutive periods.
5. Segment returns
No segment data was supplied.
6. Allocation scenarios
| Scenario | Pro-forma ROIC | Incremental Return | Spread | Incremental Econ Profit | Economic Life |
|---|---|---|---|---|---|
| Project A | 0.2647 | 0.2500 | 0.1700 | 34.00 | 5.0 |
7. Undefined metrics and data gaps
- NOPAT margin: Missing revenue input.
- Capital turnover: Missing revenue input.
8. Comparability and warnings
- W01: Analysis based on single-period closing capital rather than average capital.
9. Interpretation and items for human review
- The computed ROIC of 26.67% significantly exceeds the 8.00% WACC, resulting in an indicative economic profit of 280.05.
- The proposed scenario shows an incremental return of 25.00%, which is accretive to the spread but slightly dilutes the current aggregate ROIC.
Analytical estimate — validation required: The 20% tax rate is assumed to be the effective cash tax rate for NOPAT.
- This analysis supports, and does not replace, professional judgment and management's decision.
Next steps
- Provide revenue figures to enable margin and turnover bridge analysis.
- Supply 2023 balance sheet data to calculate ROIC based on average invested capital.
- Confirm if the 8% WACC accounts for recent changes in the risk-free rate.
Connects securely to your tools. The creator never sees your data.
About this skill
Financial analysis often suffers from inconsistent definitions and manual calculation errors when measuring performance. This skill provides a deterministic framework for evaluating how efficiently capital is being deployed by computing NOPAT, Invested Capital, and ROIC using explicit, user-defined methodologies. It eliminates the guesswork in performance tracking by bridging ROIC changes into margin and turnover effects while comparing returns against the Weighted Average Cost of Capital (WACC).
What it does
- Calculates NOPAT and Invested Capital using direct, operating, or financing approaches based on supplied financial statements.
- Benchmarks ROIC against WACC to derive the spread and indicative economic profit for specific periods.
- Decomposes performance trends by bridging ROIC fluctuations into specific margin and capital-turnover effects.
- Tests capital allocation scenarios by evaluating incremental ROIC, pro-forma returns, and economic life for proposed investments.
- Analyzes segment returns to identify which business units are driving or diluting overall capital efficiency.
How it works
- Data ingestion: You provide operating income, tax rates, and balance sheet components (PPE, working capital, debt, equity) for one or more periods.
- Configuration: You specify the invested capital approach (closing vs. average) and how to treat goodwill or impairments.
- Execution: The skill generates a precise JSON request and executes a Python script to perform all arithmetic with exact decimals.
- Validation: It reviews the result envelope for warnings, data gaps, or unreconciled segments before generating the report.
Frameworks & tools
The skill utilizes a dedicated Python calculation engine for deterministic arithmetic. It maps inputs to a strict JSON schema to ensure data integrity across multi-period and multi-segment analyses.
Why this beats prompting it yourself
Generic prompts often struggle with the precise sign conventions of invested capital and NOPAT adjustments. This skill uses a self-contained execution script that prevents hallucinated calculations and enforces a rigorous bridge between margin and turnover.
Use cases
- Performance Audits: Auditing historical ROIC trends to see if a company is truly earning above its cost of capital.
- M&A Due Diligence: Evaluating the incremental impact of acquisitions on pro-forma ROIC and capital turnover.
- Internal Capital Rationing: Ranking different investment scenarios based on ramp-up years and economic life.
- Segment Analysis: Identifying which specific divisions require capital restructuring or divestment.
Known limitations
Does not support currency conversion within a single request. Cannot look up external market data like betas or risk premiums. Decision support only, not for regulatory filings or tax compliance.
No internal currency conversion. Does not estimate WACC inputs (beta, risk premium). Decision support only; not for tax, GAAP, or IFRS compliance. Requires user-supplied financial data.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 5 days ago