AI for your role

AI for Financial Analysts

Spend less time wrangling spreadsheets and more time explaining what the numbers mean.

Get the Financial Analyst brief
The shift

How AI is changing the Financial Analyst role

AI is taking over the slow parts of the analyst workflow in 2026, including reconciling data sources, drafting variance commentary, and building first-pass models from raw exports. Forecasting tools now suggest scenarios and flag outliers before you open a spreadsheet. The work shifting toward analysts is judgment: choosing assumptions, questioning the data, and translating results for decision makers.

What AI can take off your plate

  • Cleaning, reconciling, and reformatting data exports from multiple systems
  • Drafting first-pass variance and trend commentary for recurring reports
  • Summarizing long filings, transcripts, and contracts into key points
  • Building routine dashboards and refreshing standard monthly reporting
  • Writing and debugging Excel formulas and basic financial calculations

What stays distinctly human

  • Choosing forecast assumptions and defending them to leadership
  • Judging whether the numbers actually make sense in context
  • Understanding business drivers that never appear in the data
  • Recommending decisions and owning the consequences of being wrong
  • Building trust with stakeholders who need to act on your analysis
Tools

Five AI tools for Financial Analysts

Microsoft Copilot in Excel
A Financial Analyst uses it to write and explain formulas, build pivot tables, and summarize trends in a workbook with plain-language requests.
ChatGPT
Used to draft earnings summaries, restructure messy data, write variance commentary, and sanity-check the logic behind a model.
Claude
A Financial Analyst pastes long 10-K filings, transcripts, or contracts and asks for structured summaries and risk callouts with citations to the source text.
Power BI with Copilot
Used to build dashboards from financial data and ask questions of the data in natural language for monthly reporting.
Perplexity
A Financial Analyst uses it to research comparable companies, market sizes, and industry benchmarks with linked sources to verify.
Prompts

Five prompts to try today

Paste these into Claude or ChatGPT and replace the bracketed parts with your own details.

1. Variance commentary draft
Here is my monthly actuals vs budget data for [department]: [paste table]. Write a clear variance commentary explaining the three largest drivers of the difference, in under 200 words, suitable for a management report.
2. Model assumption review
Review the assumptions in this revenue model: [paste assumptions]. List which ones look aggressive or inconsistent, what historical data I should check them against, and which carry the most risk to the forecast.
3. Earnings call summary
Summarize this earnings call transcript for [company]: [paste transcript]. Give me revenue and margin highlights, forward guidance, key analyst concerns, and any changes from prior quarter, with quotes.
4. Formula builder
In Excel, I have [describe columns and data]. Write a formula to [describe calculation], explain how it works, and note any edge cases like blanks or errors I should handle.
5. Scenario comparison
Build a base, upside, and downside scenario for [metric] given these drivers: [list drivers and ranges]. Show the assumptions for each case in a table and explain what would have to be true for each outcome.

A day in your inbox

This is the kind of brief a Financial Analyst gets, every weekday morning.
Weekday morning
✦ Personalized for: Financial Analyst
Today's Tool
Try Claude for filing reviews
Paste a full 10-K or earnings transcript into Claude and ask for a structured summary with risk factors and source quotes. It handles long documents well and points you back to the original text to verify.
Today's Prompt
Get a fast variance draft
Paste your actuals vs budget table and ask the assistant to explain the three largest drivers in under 200 words. You edit for accuracy and context instead of writing from a blank page.
Today's Trick
Always ask for the reasoning
When an AI tool gives you a number or formula, ask it to show the steps and assumptions behind it. This catches silent errors and gives you something you can actually defend in a meeting.

Get the Financial Analyst brief

One AI tool, one prompt, and one trick for Financial Analysts, every weekday morning. Free.

You are in. Your first brief arrives the next weekday morning.
Free forever. Unsubscribe anytime. We use your role only to personalize your brief.