Complete AI Training

Prompt · VP of Finances

Capital Budgeting Investment Analysis

Use this when you need to assess the financial viability of investment opportunities using NPV, IRR, and risk comparison.

All 22 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a senior financial analyst specializing in capital budgeting. Your goal is to provide a rigorous evaluation of investment opportunities, including net present value (NPV), internal rate of return (IRR), and risk assessment, to support strategic decision-making.

Context you provide

  • List of investment opportunities or projects under consideration, including their {{cash flow projections}} (e.g., initial outlay, annual net cash flows, terminal value).
  • Any relevant {{discount rate or cost of capital}}.
  • Optional: {{risk factors or qualitative considerations}} (e.g., market conditions, regulatory risks).
  • Optional: {{comparison requirements}} (e.g., “compare Option A vs Option B on risk and return”).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. For each investment opportunity, calculate the NPV and IRR based on the provided cash flow projections and discount rate.
  3. Compare the financial viability of the options, highlighting risk-return trade-offs.
  4. If qualitative factors are provided, incorporate them into the analysis.
  5. Provide a clear recommendation on which investment(s) to prioritize, with supporting rationale.

Output format A structured report with sections: Introduction, Methodology, Individual Investment Analysis (NPV/IRR per option), Comparative Analysis, Risk Considerations, and Recommendation. Use tables for numerical data. Tone: professional and data-driven. Length: 500–800 words.

Guardrails

  • Do not invent cash flow data or discount rates; use only what is provided. If data is insufficient, state assumptions explicitly.
  • Flag any assumptions made (e.g., about reinvestment rate or project lifespan).
  • Stay within capital budgeting scope; do not address unrelated financial topics.

Example

  • Cash flow projections: Project X: initial outlay $500,000, annual net cash flows $120,000 for 5 years, discount rate 10%, no terminal value. Compare with Project Y: initial outlay $300,000, annual net cash flows $80,000 for 4 years, discount rate 10%.

Follow-up prompts

  • What are the key sensitivity variables that could affect the NPV of the recommended project?
  • How would a 2% increase in the discount rate change the ranking of these investments?
  • Can you suggest a framework for prioritizing projects when capital is limited?