AI for Finance Capstone Exercise
Deliberate Academy Editorial Team
Reviewed for accuracy and professional relevance
You're 10 lessons in — don't lose your progress.
Sign up free to save where you are and earn a verified certificate when you pass.
- Apply skills from across this course in a single realistic professional scenario
- Produce a concrete, role-relevant deliverable using AI tools
- Self-assess your output against professional quality criteria
You have worked through AI-assisted financial analysis, reporting, forecasting, audit and compliance, data interpretation, risk limitations, month-end acceleration, business partnering, and tax. The capstone brings those skills into a single high-stakes scenario: a board pack deadline.
Finance professionals live in deadline cycles. The test of any tool is not how it performs on a clean dataset but how much it helps when time is tight, the data is imperfect, and the output has to be signed off by a CFO. This exercise places you in exactly that situation.
Capstone Exercise
Q1 Variance Analysis: From Data Extract to CFO Commentary
Context
You are a finance analyst at a professional services firm with 120 employees. It is 6pm on a Wednesday. The board pack goes to print tomorrow morning at 9am. Your CFO has asked you to prepare the Q1 variance analysis against budget, write the CFO commentary section (approximately 200 words), and flag any data quality issues in the source extract before the pack is finalised. The source extract you have is a standard management accounts export: revenue by service line, headcount costs, direct costs, overhead allocations, and a budget comparison column. Three of the revenue lines have unusually large positive variances that the CFO will be asked about by the board.
Your Task
Draft a five-step prompt sequence you would use to guide an AI assistant through this workflow. Step 1: a prompt to review the data extract structure and surface any obvious data quality issues. Step 2: a prompt to identify and rank the top five budget-versus-actual variances by materiality. Step 3: a prompt to draft 200 words of CFO commentary covering the top three variances, using a formal but direct register appropriate for a board audience. Step 4: a prompt to produce a data quality checklist the analyst can run through before the pack goes to print. Step 5: for each of the four AI output steps, write one annotation describing the verification check a competent analyst must perform before relying on that output.
Your notes (optional)
Deliverable
A five-step prompt sequence with a brief description of the expected AI output at each step, plus a verification annotation for each of the four analytical steps. The sequence should demonstrate understanding of where AI accelerates finance work and where the analyst must apply professional judgment the AI cannot supply.
The capstone tells you to specify in Step 2 that variances are ranked by absolute value rather than by percentage. Why does it single that instruction out?
Select one answer.
- AI-assisted financial analysis is fastest when you invest time in describing the data structure and output constraints before asking for analysis, not after the first draft disappoints you
- CFO commentary quality depends on the brief quality: an AI told the register, audience, and the difference between description and explanation will produce better output than one given only the data
- Verification annotations are the analyst's professional accountability record: they show what human judgment was applied to each AI output step before it entered the board pack
- Data quality checking is a step AI can support but cannot own: the analyst must recognise when an anomaly reflects a genuine business event versus a processing error, and AI cannot make that call without context the analyst holds
Complete all lessons to take the free exam
Pass the exam to earn your AI for Finance — Certified AI Practitioner — a verifiable certificate you can share on LinkedIn.