- Home
- Skills
- Finance & Accounting
- capital budgeting appraisal
Works with the AI Agents you already use
capital budgeting appraisal
Capital budgeting is prone to manual calculation errors and inconsistent metric application.
$10
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
| Period | Project A | Project B |
|---|---|---|
| 0 | -100,000 | -150,000 |
| 1 | 40,000 | 60,000 |
| 2 | 40,000 | 60,000 |
| 3 | 40,000 | 60,000 |
3. Appraisal metrics
| Project | NPV | IRR | MIRR | Payback | PI | Meets hurdle |
|---|---|---|---|---|---|---|
| Project A | 9,474.08 | 0.0970 | 0.0982 | 2.50 | 1.0947 | Yes |
| Project B | 14,211.12 | 0.0970 | 0.0982 | 2.50 | 1.0947 | Yes |
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
| Rate | Project A | Project B |
|---|---|---|
| 8% | 13,244 | 19,866 |
| 10% | 9,474 | 14,211 |
| 12% | 5,926 | 8,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
- Confirm if the $150k initial outlay for Project B is within the current period's CAPEX budget.
- Review the 10% discount rate assumption against current WACC benchmarks.
- 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
- Data extraction parses your dated or periodic cash flows and financial assumptions into a structured request.
- Script execution runs the
run.pyengine to process metrics, break-evens, and sensitivities. - Result validation checks the output envelope for warnings regarding unequal project lives or multiple IRRs.
- 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
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