FinanceAI

Build INSANE Financial Models With This AI Tool

Kenji Explains
Kenji Explains•Mar 8, 2026

Why It Matters

By automating tedious modeling steps, Trace Light lets analysts focus on insight generation, shortening project timelines and improving accuracy for high‑stakes finance work.

Key Takeaways

  • •Trace Light integrates as free Excel add‑in for instant formatting.
  • •AI creates scenario‑driven income statements with dynamic dropdown selectors.
  • •Cohort analysis generated automatically, applying best‑practice rounding and formulas.
  • •Tool extracts full financial statements from 10‑K PDFs with accurate formulas.
  • •Limitations include complex visual dashboards and non‑finance general tasks.

Summary

Trace Light is an AI‑powered Excel add‑in designed for consulting, banking and private‑equity professionals, promising to turn raw spreadsheets into polished financial models in seconds. The video walks through five escalating use‑cases—from basic formatting to a full discounted cash‑flow valuation—showcasing how natural‑language prompts drive the tool’s output.

Across the demos, the AI formats headers, applies percentage and thousand‑separator styles, builds multi‑scenario income statements with dropdown selectors, constructs cohort analyses that respect rounding conventions, and even extracts the three core statements from a 100‑page Nike 10‑K PDF. Users can save prompts as reusable workflows, streamlining repetitive model‑building tasks.

The presenter highlights concrete results: a correctly colored header, a dynamic scenario switch that updates all linked cells, a cohort table that rounds customer counts, and a DCF that automatically adjusts for share‑count units. The audit feature also flags intentional formula errors, while the trace function explains cell logic in plain language.

For finance teams, Trace Light accelerates model creation, reduces manual formatting errors, and embeds best‑practice formulas, though it still lags on complex visual dashboards and non‑finance applications. Its early adoption by six of the world’s top consulting firms signals a shift toward AI‑augmented spreadsheet workflows.

Original Description

Get Tracelight Pro for free with the exclusive code KENJIFREEMONTH here: https://tracelight.link/UALbI9E
Just click "Get Pro" and use the code at checkout to join analysts at 6 of the top 10 consultancies.
If your team is interested in trying Tracelight, you can Book Your Demo today here: https://tracelight.link/irZGIUa
In this video, we test out Tracelight, an AI tool specifically for corporate roles like Consulting, Banking, or Private Equity. Tracelight is completely free to install as an Excel add-in, and in level one we go over its formatting capabilities by converting a raw sheet into a fully formatted worksheet. Second, in level two, we go over a scenario analysis where it creates a profit and loss statement based off of a set of assumptions for a best case, a base case, and the worst case. In level three, we test Tracelight by asking it to create a cohort analysis from scratch. In level four, we go over how well it imports data by importing Nike's 10K PDF file and asking it to extract the three main financial statements. In level 5, we go over a discounted cash flow, asking Tracelight to calculate the Enterprise value, the Equity value, and a sensitivity table. Then we go over some of the limitations of Tracelight and its bonus features, like the audit and the trace feature.
You can follow Tracelight for the latest in AI for financial modelling here:
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/hpvupl4qj4
LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Setup
0:45​ - Level 1
2:35​ - Level 2
4:59​ - Level 3
7:14​ - Level 4
9:05​ - Level 5
11:09​ - Limitations
11:40​ - Bonus

Comments

Want to join the conversation?

Loading comments...