Find the right AI tools for any job, task or industry.

AI SKILLS · Finance, accounting & investment

Build and check financial models with AI

Use AI to draft three-statement, DCF and budget models, then test their structure, formulas and assumptions.

Applied

Why this skill matters

Spreadsheet errors are common and an AI-built model can look complete while hard-coding numbers or breaking links.

What to learn

  • Separate inputs, calculations and outputs and label every assumption
  • Check that statements balance and cash ties across periods
  • Stress-test key drivers and document sensitivities

Before you begin

Accounting statements and intermediate Excel

PUT IT INTO PRACTICE

Build a work sample

Have an AI tool draft a three-statement model for a fictional company, then audit it for hard-codes, broken links and balance errors before running sensitivities.

Evidence of progress

A corrected model with an error log, checks tab and sensitivity table.

This exercise is an original ToolGrail suggestion. Use public, synthetic, or approved data.

LEARNING RESOURCE

ICAEW Excel Community (background on spreadsheet good practice)

ICAEW · Resource checked 2026-11-13

Open learning resource ↗

This may be documentation, a framework, or a training path. Product access, accounts, or paid licenses may be needed for hands-on exercises.

Tools you could practice with

Chosen by an editor because they support this exercise. They are examples, not requirements or endorsements: use a tool you already have access to, with synthetic or approved data, and check its evidence level.

ToolPricing not verified
ShortcutAI Excel agent

AI agent for Excel that builds and edits spreadsheets, formulas and LBO, DCF and three-statement models.

Analysts and finance students building Excel models.
Details ↗
ToolPricing not verified
MacabacusExcel and PowerPoint add-in

Excel and PowerPoint add-in for financial modelling and presentation workflows, with AI deck review and writing help.

Bankers and PE professionals building models and pitch books.
Details ↗
Tool + MCPPricing not verified
DaloopaFinancial data automation

Financial data and AI automation for the public-equity investment research cycle.

Equity research and buy-side analysts maintaining models.
Details ↗
Tool + MCPPricing not verified
CubeFP&A

AI financial intelligence platform for FP&A teams working in spreadsheets, browsers and chat.

FP&A teams that want to keep working in Excel or Google Sheets.
Details ↗

Skill descriptions, exercises, and priorities are editorial. They are not professional qualifications or guarantees of employment. Read our skills methodology →