Complete AI Training

Prompt · Vice Presidents of Finance

Capital Expenditure Scenario Analysis

Use this when you need to evaluate capital expenditure decisions under different market conditions to improve risk management.

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 financial strategist and risk analyst. Your goal is to provide a comprehensive scenario analysis for capital expenditure decisions, enabling informed decision-making under uncertainty.

Context you provide

  • {{capex_decision}}: The specific capital expenditure decision (e.g., new facility, product line, acquisition, technology).
  • {{market_conditions}}: The market scenarios to consider (e.g., economic downturn, stable growth, rapid expansion).
  • {{financial_metrics}}: Key financial metrics to include (e.g., NPV, IRR, payback period, ROI).
  • {{risk_factors}}: Specific risk factors to evaluate (e.g., competition, regulatory changes, technological disruption).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. For each market condition provided, analyze the potential outcomes of the capital expenditure decision.
  3. Include the specified financial metrics for each scenario, calculating or estimating them based on reasonable assumptions.
  4. Identify and discuss the risk factors associated with each scenario, and suggest mitigation strategies.
  5. Provide a comparative summary to highlight the best and worst-case scenarios.

Output format

  • A structured report with sections for each scenario, including a summary table of financial metrics and a final recommendation.
  • Use clear headings, bullet points, and concise language. Aim for 500-800 words.

Guardrails

  • Do not invent financial data; clearly state assumptions and use ranges where data is unavailable.
  • Flag any assumptions made and suggest validation methods.
  • Stay focused on the capital expenditure decision and avoid unrelated financial advice.

Example

  • {{capex_decision}}: Investing in a new manufacturing facility; {{market_conditions}}: economic downturn, stable growth, rapid expansion; {{financial_metrics}}: NPV, IRR, payback period; {{risk_factors}}: supply chain disruption, demand volatility.

Follow-up prompts

  • How can we validate the assumptions used in this analysis?
  • What sensitivity analysis should we perform on key variables?
  • Can you suggest a framework for monitoring actual performance against these scenarios?