AI Prompt and Tool Gallery

What it does: Instantly identifies trends, calculates key ratios, and flags anomalies across multiple periods. Prompt: Analyze these financial statements for [Company Name] from [Period]. Calculate and interpret: 1) YoY growth rates for all line items 2) Key ratios (liquidity, leverage, profitability, efficiency) with industry benchmarks 3) Trend analysis over 3-5 years 4) Red flags or unusual items 5) Quality of earnings assessment. Create an Excel file with all calculations and a visual dashboard. Format: Executive summary first, then detailed analysis with charts.

What it does: Builds multi-scenario financial models with sensitivity analysis in minutes. Prompt: Create a 3-statement financial model for [Company] with these scenarios: Base (current growth), Bull (+X% growth), Bear (-Y% growth). Include: 1) Revenue drivers and assumptions table 2) Working capital projections 3) CapEx requirements 4) Debt schedule 5) Sensitivity analysis on key variables. Build this as a working Excel model with all formulas linked. Add Monte Carlo simulation for probability weights.

What it does: Explains budget variances with root cause analysis and actionable recommendations. Prompt: Analyze budget vs actual for [Department/Company] for [Period]. For each variance >5%: 1) Calculate price vs volume impact 2) Identify root causes 3) Assess if temporary or structural 4) Recommend corrective actions 5) Project full-year impact. Create waterfall charts showing variance bridges and heat map for quick identification of problem areas.

What it does: Generates comprehensive KPI dashboards with drill-down capabilities. Prompt: Design a CFO dashboard tracking: Revenue (by segment/geography), Gross Margin trends, EBITDA margin, Cash conversion cycle, DSO/DPO/DIO, Working capital metrics, Debt ratios, Employee productivity metrics. Include: 1) Current vs Prior Period 2) vs Budget 3) vs Forecast 4) Sparklines for trends 5) RAG status indicators. Output as interactive Excel with slicers.

What it does: Creates dynamic 13-week cash flow models with daily granularity. Prompt: Build a 13-week rolling cash flow forecast incorporating: 1) AR aging and collection patterns 2) AP payment terms and schedules 3) Payroll and fixed costs timing 4) CapEx commitments 5) Debt service requirements 6) Seasonal patterns from historical data. Include daily cash position, credit line usage, and early warning triggers. Create stress test scenarios for 20% revenue decline.

What it does: Identifies cash trapped in working capital with specific improvement actions. Prompt: Analyze working capital efficiency for [Company]: 1) Calculate CCC by component and trend 2) Benchmark against industry peers 3) Identify top 10 customers/vendors impacting DSO/DPO 4) Quantify cash release opportunity 5) Create implementation roadmap with quick wins. Model the P&L and cash impact of improving each metric by 5, 10, and 15 days.

What it does: Categorizes costs, identifies savings opportunities, and benchmarks efficiency. Prompt: Perform zero-based cost analysis on P&L data: 1) Categorize all costs (fixed/variable/semi-variable) 2) Calculate cost per unit/transaction/employee 3) Identify outliers and anomalies 4) Benchmark against industry standards 5) Recommend optimization initiatives with ROI calculations. Create Pareto analysis showing 80/20 rule applications and cost driver tree.

What it does: Builds complete DCF models with sensitivity tables and football field valuations. Prompt: Create a comprehensive DCF valuation for [Company]: 1) Project FCF for 5-10 years based on historical performance 2) Calculate WACC using current market data 3) Determine terminal value using both growth and exit multiple methods 4) Run sensitivity analysis on key assumptions 5) Create football field chart comparing DCF, comps, and precedent transactions. Include LBO analysis at various return thresholds.

What it does: Creates executive-ready board decks with compelling narratives and visuals. Prompt: Draft a board presentation covering Q[X] performance: 1) Executive summary with key achievements/challenges 2) Financial performance vs plan with bridge analysis 3) Business unit deep dives 4) Strategic initiative updates with KPIs 5) Risk dashboard 6) Capital allocation decisions 7) Forward outlook and guidance. Use pyramid principle structure, include speaker notes, and create appendix with detailed backup.

What it does: Generates comprehensive investor materials with regulatory compliance. Prompt: Create quarterly investor package including: 1) Earnings release with key metrics 2) MD&A narrative explaining performance 3) Supplemental financial schedules 4) KPI trending analysis 5) Guidance bridge and assumptions 6) FAQ addressing likely investor questions. Ensure SOX compliance, include regulation FD considerations, and create both detailed and summary versions.

What it does: Creates comprehensive due diligence checklists and identifies key risks. Prompt: Develop due diligence framework for [Target Company] acquisition: 1) Financial quality of earnings analysis 2) Working capital normalization 3) EBITDA adjustments identification 4) Customer/supplier concentration analysis 5) Legal/regulatory compliance review 6) Integration cost estimation 7) Synergy quantification 8) Deal model with returns analysis. Flag top 10 risks and create 100-day integration plan.

What it does: Tracks debt covenants and provides early warning of potential breaches. Prompt: Monitor debt covenant compliance for [Company]: 1) Calculate all financial covenants per credit agreement 2) Show historical trending and headroom 3) Project next 4 quarters based on forecast 4) Run stress scenarios for revenue/EBITDA decline 5) Identify remediation actions if breach likely. Create dashboard with traffic light system and automatic email alerts for <20% headroom.

What it does: Compares operational metrics against industry best practices. Prompt: Benchmark [Company] operational efficiency: 1) Gather industry KPIs for peer group 2) Calculate performance gaps by metric 3) Quantify financial impact of reaching median/top quartile 4) Identify specific improvement initiatives 5) Create implementation roadmap with milestones. Include SG&A as % of revenue breakdown, spans and layers analysis, and automation opportunities.

What it does: Creates sophisticated sensitivity models showing impact of multiple variables. Prompt: Build sensitivity analysis for [Business/Project]: 1) Identify top 10 value drivers 2) Create tornado diagram showing impact 3) Run Monte Carlo simulation with probability distributions 4) Calculate value at risk (VaR) metrics 5) Develop hedging strategies for key risks. Include correlation matrix between variables and scenario probability weighting.

What it does: Drafts comprehensive investment memos for acquisition decisions. Prompt: Draft investment committee memo for [Target] acquisition: 1) Executive summary with recommendation 2) Strategic rationale and synergies 3) Financial analysis with returns (IRR, MOIC, payback) 4) Market analysis and competitive positioning 5) Due diligence findings 6) Risk assessment with mitigants 7) Transaction structure and financing 8) Exit strategy options. Include base/upside/downside cases with probability weighting.

What it does: Uses AI to identify expense anomalies and savings opportunities. Prompt: Analyze expense data to identify optimization opportunities: 1) Flag unusual transactions or amounts 2) Identify duplicate payments or vendors 3) Find contract consolidation opportunities 4) Benchmark rates against market 5) Recommend policy changes 6) Calculate potential savings by category. Create vendor rationalization plan and expense policy recommendations with expected ROI.

What it does: Creates sophisticated workforce planning models linked to business drivers. Prompt: Build headcount planning model for [Company]: 1) Link headcount to revenue/operational drivers 2) Calculate fully-loaded costs by role/level 3) Model hiring plan with ramp time 4) Include attrition and backfill assumptions 5) Create org chart visualization 6) Calculate productivity metrics 7) Benchmark spans of control. Include scenario planning for different growth rates and hiring freeze impact analysis.

What it does: Builds comprehensive risk matrices with quantified financial impact. Prompt: Create enterprise risk assessment for [Company]: 1) Identify top 20 risks across categories (financial, operational, strategic, compliance) 2) Score probability and impact 3) Quantify potential financial exposure 4) Map current controls and gaps 5) Recommend mitigation strategies with cost/benefit 6) Create risk appetite framework. Include emerging risks, black swan scenarios, and board-ready heat map.

What it does: Writes executive-quality financial commentary explaining performance. Prompt: Write financial commentary for [Period] results: 1) Explain key variances vs prior year and budget 2) Discuss underlying business drivers 3) Address one-time vs recurring items 4) Explain margin changes 5) Discuss outlook and risks 6) Use clear, concise executive language. Follow pyramid principle, quantify all claims, and include forward-looking statements disclaimer.

What it does: Creates comprehensive finance policies with controls and procedures. Prompt: Design [specific] finance policy for [Company]: 1) Define policy objectives and scope 2) Detail approval matrix and thresholds 3) Document procedures and controls 4) Include compliance requirements 5) Create exception handling process 6) Define KPIs and monitoring 7) Include training requirements 8) Add forms and templates. Ensure SOX compliance and include RACI matrix for all processes.