AI prompt cho tài chính không phải là chuyện viết một câu hỏi rồi bấm Enter. Đó là nghệ thuật đặt đúng ngữ cảnh, đúng yêu cầu, và đúng định dạng output, để AI trở thành một đồng nghiệp tài chính thực sự hữu ích, không phải một cỗ máy trả lời ngẫu nhiên.
Trong bài viết hôm nay, UniTrain đã tổng hợp 20 AI prompt thực tế được thiết kế riêng cho dân FP&A (Financial Planning & Analysis). Mỗi prompt đều có thể áp dụng ngay, chỉ cần thay số liệu của bạn vào.
1. Variance Analysis & Monthly Close
Example 1: Revenue Variance Commentary
Prompt:
| Context: Our Q3 revenue was 8% below budget. Drivers: Enterprise (-12% due to two delayed deals), Mid-market (+3% on strong conversion), and SMB (-15% on churn).
Objective: Draft a three-paragraph board-level narrative. Reasoning: Analyse the interplay between these segments. Specifically, think through how the enterprise delays impact our Q4 pipeline and if the Mid-market strength is scalable enough to offset SMB churn. Evaluation: Review your draft. Does it sound too defensive? Ensure it highlights the proactive steps we are taking to mitigate further SMB churn. |
Example 2: Cost Variance Explanation
Prompt: RCTF – Role, Context, Task, Format
| Act as an FP&A manager, explaining variances to department heads (R). Marketing spend was 23% over budget this quarter. The overspend breaks down as: paid acquisition +£X (approved mid-quarter to capture opportunity), events +£Y (unbudgeted trade show), headcount +£Z (earlier-than-planned hire) (C). Write an explanation that acknowledges the overspend while providing context on ROI where applicable (T). Email format, 200 words maximum, constructive tone (F). |
Example 3: Variance Bridge Narrative
Prompt:
| I have an EBITDA bridge showing: Budget £Xm → Volume impact -£A → Price/mix +£B → Cost savings +£C → FX -£D → Actual £Ym. Write a narrative that walks through each bridge component in plain English, suitable for a CFO who wants to understand the story quickly. One sentence per component, then a concluding insight. |
2. Forecasting & Planning
Example 4: Forecast Assumptions Documentation
Prompt: RCTF – Role, Context, Task, Format
| Act as an FP&A director, preparing forecast documentation (R). We’re building the 2026 annual plan for a B2B software company with these characteristics: current ARR growth 25%, gross margin 78%, sales cycle 90 days, NRR 105% (C). Create a structured list of key assumptions I should document for revenue, headcount, and operating expenses (T). Format as a checklist with a brief rationale for why each assumption matters (F). |
Example 5: Rolling Forecast Narrative
Prompt:
| Our rolling forecast shows full-year revenue now expected at index 94 vs the original budget of 100. Q1-Q2 actual was 96; Q3-Q4 forecast is 92. The primary driver is the slower-than-expected conversion of the enterprise pipeline. Write a one-paragraph executive summary explaining the forecast change and its implications for the full year, suitable for the weekly leadership update. |
Example 6: Headcount Planning Framework
Prompt: RCTF – Role, Context, Task, Format
| Act as an FP&A partner supporting HR (R). We need to build a headcount planning model for a 200-person company expecting 30% revenue growth (C). What metrics and ratios should we track to ensure headcount scales appropriately? Include productivity metrics, span of control considerations, and leading indicators (T). Present as a framework with 3-4 metrics per functional area (Sales, Engineering, G&A) (F). |
3. Board & Executive Reporting
Example 7: Executive Summary for Board Pack
Prompt:
| <system_instruction> Draft the opening executive summary page for a quarterly board pack. Write in the voice of a CFO: confident, precise, and balanced. </system_instruction><context> Company: B2B SaaS, Series C, 200 employees. Q3 performance vs plan: – Revenue: 95% of plan (enterprise delays, mid-market strong) – EBITDA: 88% of plan (margin compression from delayed price increase) – Cash: 110% of plan (better working capital management) Major developments: New product line launched, completed bolt-on acquisition (integrated within quarter), CFO transition announced. </context><task> Write four short paragraphs: (1) Financial highlights with the key ‘so what’, (2) Strategic progress and milestones, (3) Key risks and mitigating actions, (4) Outlook and updated guidance, if applicable. </task><constraints> – Use indexed figures only, no absolute revenue or EBITDA numbers – Do not name the acquisition target — refer to it as ‘the bolt-on acquisition’ – Keep total length under 300 words </constraints><bridge> Review your output against the constraints above. Does each paragraph have a clear ‘so what’ rather than just restating the number? Does the risks section pair each risk with a mitigating action? Ensure the summary reads as a polished final product, not a first draft. </bridge> |
Example 8: KPI Dashboard Commentary
Prompt:
| I have a SaaS metrics dashboard showing: ARR growth of 22% (target 30%), Net Revenue Retention of 103% (target 110%), CAC Payback of 18 months (target 15), and Gross Margin of 76% (target 78%). Write a brief commentary for each metric: one sentence on performance; one sentence on the ‘so what’. Format ready to paste each chart in PowerPoint below. |
Example 9: Investor Update Draft
Prompt: RCTF – Role, Context, Task, Format
| Act as a CFO at a Series B startup (R). We need to send our quarterly investor update. Performance summary: revenue ahead of plan, burn slightly higher due to accelerated hiring, 18 months runway, key hire made (VP Sales) (C). Draft the financial section of the investor update (T). Three paragraphs: performance vs plan, use of funds, forward outlook. Confident but not promotional. Investors appreciate candour (F). |
4. Scenario Planning & Sensitivity Analysis
Example 10: Scenario Framework Design (optimised for ChatGPT)
Prompt: CORE framework
| Context: We are a B2B software company with 70% recurring revenue, 200 employees, and ARR of index 100. The board has asked for three planning scenarios: base case, downside, and aggressive growth. We are 18 months from a potential IPO, so the scenarios need to reflect credible investor narratives.
Objective: Define the assumption framework for all three scenarios. Cover: revenue growth rate, gross churn, net revenue retention, pricing changes, hiring pace, and marketing spend as a percentage of revenue. Reasoning: Before setting the numbers, think through the dependencies between assumptions. For example, if the downside scenario assumes higher churn, what does that imply about the required sales capacity to maintain growth? If the aggressive scenario assumes faster hiring, what is the lead time before new hires become productive, and how does that affect near-term margins? Each scenario should tell a coherent economic story, not just move numbers in the same direction. Evaluation: Review the three scenarios. Would a sophisticated investor find each one internally consistent? Flag any assumptions that contradict each other within the same scenario. Present the final output as a comparison table with Base / Downside / Aggressive columns, and add a row at the bottom summarising the narrative theme of each scenario in one sentence. |
Example 11: Recession Planning (Optimised for Gemini)
Prompt: DATA framework
| Data Source: Our current annual cost structure (indexed, budget base = 100): – People costs: 60 (of which 40 is core engineering, 12 is sales, 8 is G&A) – Technology & infrastructure: 25 (of which 15 is committed/contracted) – Discretionary: 15 (marketing 8, travel 3, professional services 4) Current cash runway: 18 months at current burn.Action: Create a tiered cost-reduction framework showing which levers to pull at three revenue shortfall levels: -10%, -20%, and -30% vs forecast. Technical Constraints: Answer Style: A table for each tier showing: specific action, estimated savings (indexed), implementation timeline, and impact on cash runway. Add a summary row showing cumulative savings and resulting runway for each tier. |
Example 12: Sensitivity Analysis Narrative
Prompt:
| I’ve run sensitivity analysis on our 3-year model. Key findings: EBITDA is most sensitive to gross margin (1% change = £Xm impact), followed by revenue growth (1% = £Ym), then headcount timing (1 month delay = £Zm). Write a paragraph explaining these sensitivities to the board, focusing on which variables we have most control over and where risk management should focus. |
5. Stakeholder Communication
Example 13: Budget Feedback to Department Heads (Optimised for ChatGPT)
Prompt:
| Context: I am an FP&A business partner. A department head has submitted a 2027 A budget request that is 40% higher than 2026 actuals. The increase is driven by three new headcount roles and a significant increase in software licensing. Thedepartment has historically delivered strong ROI, but we are in a year of margin improvement focus. I have a good working relationship with this stakeholder.
Objective: Draft an email that pushes back constructively on the budget request without damaging the relationship. Reasoning: Think about the dynamics here. This person believes in their growthplan and has taken time to build a case. A flat rejection will feel dismissive. But rubber-stamping a 40% increase contradicts the company’s focus on margins.The best outcome is a conversation where we jointly prioritise and phase the spend. Structure the email to get to that meeting. Evaluation: Review the draft. Does it acknowledge their ambition genuinely? Does it ask clarifying questions about ROI and phasing rather than just saying ‘no’? Could this email damage the relationship if read uncharitably? Adjust if so. Keep it under 200 words. Tone: partners, not gatekeepers. |
Example 14: Explaining Finance Concepts to Non-Finance Stakeholders
Prompt:
| Act as an FP&A manager who excels at making finance accessible (R). Our Head of Product doesn’t understand why we capitalise software development costs and how it affects their P&L (C). Write a brief explanation using an analogy they’d understand – maybe comparing it to how they think about product features (T). Conversational tone, no jargon, under 150 words (F). |
Example 15: Monthly Business Review Prep
Prompt:
| I’m preparing for monthly business reviews with department heads. For each function (Sales, Marketing, Engineering, Customer Success), suggest 3-4 questions I should ask based on their financial performance. The goal is to understand drivers, not interrogate. Questions should uncover insights that help improve forecasting accuracy. |
6. Modelling & Analysis Support
Example 16: Excel Formula Generation
Prompt: RCTF – Role, Context, Task, Format
| You are an Excel expert specialising in financial modelling (R). I have a revenue model where Column A is month, Column B is starting ARR, Column C is new business, Column D is expansion, Column E is churn (as negative), and Column F should calculate ending ARR (C). Write a formula for Column F that calculates the ending ARR. Also, write a formula for Column G that calculates month-over-month growth rate (T). Provide only the formulas, assuming row 2 is the first data row (F). |
Example 17: Model Structure Review
Prompt: RCTF – Role, Context, Task, Format
| Act as a financial modelling expert (R) I’m building a 3-statement model for a manufacturing company. I have: P&L with revenue build-up by product, balance sheet with working capital assumptions, but I’m struggling with the cash flow statement linkages (C) Walk me through how the three statements should connect, specifically the working capital to cash flow bridge (T) Step-by-step explanation with specific line items (F) |
Example 18: Cohort Analysis Framework
Prompt: RCTF – Role, Context, Task, Format
| Act as a SaaS finance expert (R) I want to build a customer cohort analysis to understand revenue retention over time. We have monthly data on customer start dates and their monthly revenue (C) Describe the structure I need: what the rows and columns should represent, how to calculate retention rates, and what visualisations would be most useful for the board (T) Practical guidance I can implement in Excel (F) |
Example 19: Build System Formulae
Prompt: RCTF – Role, Context, Task, Format
| Act as a Power BI expert specialising in SaaS financial modelling and DAX (R) I am building an ARR Waterfall. I have already loaded my data and created the relationships (C) My fact table is named ‘Subscriptions’ and contains: [CustomerID], [StartDate], [EndDate], and [ARR_Amount]. My date table is named ‘Calendar’ and is marked as a date table. “Opening ARR” is defined as the total ARR active on the very last day of the previous period. Write the DAX measure for [Opening ARR]. The formula needs to calculate the total [ARR_Amount] for subscriptions that started before the selected period and ends after the start of the selected period. Please ensure it handles the time intelligence correctly so it works dynamically, whether I view the report by Month or Quarter. (T) Provide the clean DAX code, with comments that explain the logic step by step. (F) |
Example 20: FP&A Transformation Roadmap
| <background>
I am the Head of FP&A at a £500m manufacturing firm, currently in a “Developing” maturity state </background> |
Đây là ví dụ điển hình của một “mega prompt”, bạn cung cấp toàn bộ bức tranh, AI trả về một kế hoạch chiến lược có cấu trúc. Loại prompt này đặc biệt mạnh khi bạn cần bản phác thảo đầu tiên cho một deliverable phức tạp.
Follow UniTrain để cập nhật thêm nhiều kiến thức hữu ích khác bạn nhé.
XEM THÊM
[Khóa học] Practical AI Literacy
[Kiến thức hữu ích] AI Literacy là gì? Tại sao chỉ biết dùng ChatGPT chưa đủ
