ROI Analysis Builder — Free M365 Copilot AI Prompt

Free advanced AI prompt for finance teams: calculate ROI for a proposed initiative. Works in M365 Copilot. Tag: finance.

Tested by a human Advanced 👤 Finance 👤 Manager
Calculate ROI for [INITIATIVE]. Include: total investment, quantified benefits, payback period, 3-year NPV, IRR, break-even, sensitivity analysis, risk-adjusted ROI. Present with recommendation.

Works on

⭐ M365 Copilot (Best) 🟢 ChatGPT

Copy & Open in

ChatGPT

Prompt is copied to your clipboard when you click

Tips for Best Results

  • Be conservative with benefit estimates
  • Include non-financial benefits separately
  • State discount rate assumptions

📎 More Prompts

Budget Planning Template — Free M365 Copilot AI Prompt

●●
Create a budget planning template for [DEPARTMENT] for [FISCAL YEAR]. Include: (1) Revenue categories with line items, (2) Operating expenses by category (personnel, software, travel, training), (3) Capital expenditure section, (4) Monthly and quarterly breakdowns, (5) Variance tracking columns (budget vs actual), (6) Summary dashboard row with key ratios. Add formulas for totals, percentages, and year-over-year comparison.
⭐ M365 🟢 GPT

Cost Reduction Opportunity Analysis — Free AI Prompt

●●●
Analyse our spending data and identify cost reduction opportunities. Review: (1) Subscriptions and recurring costs (look for unused or duplicate tools), (2) Vendor consolidation potential, (3) Process automation savings, (4) Licence right-sizing, (5) Contract renegotiation opportunities. For each opportunity estimate: annual savings, implementation effort, and risk. Rank by ROI.
⭐ M365 🟢 GPT

Expense Variance Analysis — Free M365 Copilot AI Prompt

●●
Analyse the expense variance between budget and actual for [PERIOD]. For each line item that varies by more than [THRESHOLD — 5% / 10% / ]: (1) State the variance amount and percentage, (2) Classify as favourable or unfavourable, (3) Explain the likely cause, (4) Recommend whether it is a one-time variance or a trend, (5) Suggest corrective action if needed. Summarise total impact.
⭐ M365