Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    capital budgeting appraisal

    1

    Capital budgeting is prone to manual calculation errors and inconsistent metric application.

    $10

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    capital budgeting appraisal

    capital budgeting appraisal

    Example session with this skill installed

    Evaluate two projects with a 10% discount rate. Project A: -$100k initial, $40k/year for 3 years. Project B: -$150k initial, $60k/year for 3 years. Compare them and check NPV sensitivity to the rate.

    • Read your context and instructions
    • Compiled the capital budgeting appraisal

    I have processed the appraisal for Project A and Project B using a 10.00% discount rate. The deterministic engine has computed all metrics and identified the ranking based on Net Present Value.

    Capital Budgeting Appraisal — Internal Review, 2023-10-27

    1. Scope, sources and assumptions

    • Sources: E1 (User supplied project data)
    • Currency: USD (Scale: 1)
    • Discount Rate: 10.00% (Annual)
    • Timing: End-of-period
    • Assumptions: 3-year horizon, no tax applied.

    2. Project cash flows

    PeriodProject AProject B
    0-100,000-150,000
    140,00060,000
    240,00060,000
    340,00060,000

    3. Appraisal metrics

    ProjectNPVIRRMIRRPaybackPIMeets hurdle
    Project A9,474.080.09700.09822.501.0947Yes
    Project B14,211.120.09700.09822.501.0947Yes

    4. Project comparison

    • NPV Ranking: 1. Project B, 2. Project A
    • IRR Ranking: Tie (9.70%)
    • Incremental NPV: Project B provides $4,737.04 additional value over Project A.

    Explanation: Both projects share the same IRR and PI, but Project B is the preferred investment due to higher absolute NPV, assuming capital is available.

    5. Sensitivity and break-even

    NPV Sensitivity to Discount Rate

    RateProject AProject B
    8%13,24419,866
    10%9,47414,211
    12%5,9268,889

    6. Undefined results and data gaps

    • No information gaps identified.

    7. Warnings and comparability

    • W_SCALE_CHECK: Scale is consistent across projects.

    8. Interpretation and items for human review

    • Project B yields a higher NPV ($14,211.12) compared to Project A ($9,474.08) at the 10% hurdle rate.
    • Both projects have an IRR of 9.70%, which is below the 10% discount rate if cash flows were slightly lower; however, based on the specific inputs, NPV remains positive.

    Analytical estimate — validation required.

    • This analysis supports, and does not replace, professional judgment and management's decision.

    Management decision required.

    Next steps

    1. Confirm if the $150k initial outlay for Project B is within the current period's CAPEX budget.
    2. Review the 10% discount rate assumption against current WACC benchmarks.
    3. Validate the stability of the $60k annual operating cash flow for Project B.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Capital budgeting is prone to manual calculation errors and inconsistent metric application. This skill offloads investment appraisal to a deterministic Python script, ensuring NPV, IRR, and payback periods are computed with exact decimals rather than LLM estimation. It handles the transition from raw capex and operating assumptions to after-tax cash flows while identifying mathematical edge cases like multiple internal rates of return.

    What it does

    • Deterministic calculation uses a dedicated script to compute NPV, IRR, MIRR, and profitability indexes without rounding errors.
    • After-tax modeling builds cash flow profiles from capex, depreciation shields, working capital changes, and salvage values.
    • Comparative analysis ranks mutually exclusive projects and calculates crossover rates to resolve NPV and IRR conflicts.
    • Sensitivity testing generates data tables for NPV across varying discount rates and operating cash flow scenarios.
    • Error flagging identifies missing inputs, undefined metrics, or mathematical warnings like non-conventional cash flows.

    How it works

    1. Data extraction parses your dated or periodic cash flows and financial assumptions into a structured request.
    2. Script execution runs the run.py engine to process metrics, break-evens, and sensitivities.
    3. Result validation checks the output envelope for warnings regarding unequal project lives or multiple IRRs.
    4. Appraisal reporting generates a structured Markdown report with formatted tables and analytical observations.

    Frameworks & tools

    The skill utilizes a self-contained Python arithmetic engine for all financial logic. It follows a strict JSON schema for input validation and output reporting.

    Why this beats prompting it yourself

    Standard LLM prompts often hallucinate IRR values or fail to account for the mid-period timing convention. This skill forces all arithmetic through a deterministic script, providing exact traces and flagging mathematical impossibilities that a typical prompt would ignore.

    Use cases

    • Evaluating multi-year infrastructure projects with staged capex and terminal salvage.
    • Comparing two competing software tools with different lifespans and maintenance costs.
    • Finding the break-even operating cash flow for a new product line launch.
    • Identifying why a high-IRR project might actually be inferior to a lower-IRR project in NPV terms.

    Known limitations

    Does not perform WACC estimation, company valuations, or lease vs. buy schedules. Requires user-supplied discount rates and does not support currency conversion or tax law compliance audits.

    No WACC estimation or company valuation. Requires user-supplied discount rates. No currency conversion. Decision support only, not tax or GAAP compliant.

    How to use

    1. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Environment Variables
    Listed5 days ago

    What's inside

    Frequently Asked Questions

    Unlike standard LLMs that estimate numbers based on patterns, this skill routes all data through a deterministic Python arithmetic engine. This ensures your NPV and IRR values are mathematically exact and free from the calculation drift or 'hallucinations' common in general-purpose prompting.

    The skill is designed for any AI agent or platform that supports external tool execution and script processing. It uses a standardized JSON input/output schema, making it compatible with most modern LLM frameworks and autonomous agent workflows.

    You receive the core Python execution logic, the JSON schema for structured data input, and a pre-configured prompt template that instructs your agent on how to handle investment appraisal workflows. It is ready for immediate integration into your existing agentic environment.

    Yes, the skill is specifically designed to handle 'non-conventional' cash flows. It will identify mathematical edge cases, such as multiple internal rates of return or undefined results, and provide a warning in the appraisal report rather than an incorrect estimate.

    The skill focuses on the mathematical appraisal of cash flows you provide. It does not perform market research, estimate your Weighted Average Cost of Capital (WACC), or provide specific tax law advice; you must input your own discount rates and tax assumptions for the calculation.

    New in Finance & Accounting