Work Interactive Excel Model Generator

Interactive Excel Model Generator

Hand an AI assistant the history and your assumptions in plain language, and get back an eight-sheet Excel valuation where every cell is a real formula you can trace.

Type
Model + AI skill
Year
2026
Output
8 sheets · .xlsx + .xlsm
Build time
About 2 minutes

Summary

Question
A downloaded valuation template is a black box with your numbers pasted in. Can a model be generated that you can audit cell by cell?
What I built
An AI skill that writes an eight-sheet workbook from your drivers: cover, assumptions, historicals, forecast, DCF, a WACC-against-terminal-growth grid, scenarios and a one-screen dashboard.
Why it matters
Every number is a live formula that traces back to an input. Turn macros off and the plain .xlsx gives identical numbers.

The question

Somewhere in a borrowed template a growth rate is hard-coded, or a subtotal skips a row, or a macro quietly computes something the sheets never show. You find out when the answer is wrong and you can't say why.

What I did

Click a step to see what happens there.

  1. The assistant scaffolds the project, writes the driver engine and builds the workbook from the history and assumptions you give it.

  2. Nothing is hard-coded and nothing is computed in VBA. The macros only move inputs and read outputs.

  3. Every sheet is scanned for formula errors before the file is handed over, and any broken cell is named exactly.

  4. A smoke test presses each dashboard button and checks that the cells it should move did move.

  5. A restyle has to reproduce the previous numbers exactly before it is accepted.

What I found

It checks itself before you trust it

The dashboard has Bear, Base, Bull and Live scenario pills, one-step driver nudges, a "Price implies?" solver that backs out the growth the market is assuming, Save case for side-by-side snapshots, and Reset.

  • 8Sheets
  • 0Formula errors, checked before hand-over
  • 100%Live formulas, no maths in any macro
  • ~2 minFrom prompt to workbook

Skills on show

  • Financial modelling
  • DCF valuation
  • Excel & VBA
  • AI tooling
  • Model testing

Limits

  • Windows and Excel only, plus Python and two packages, with one Excel setting ticked for macro access.
  • The model is only as good as the drivers you give it. It makes them visible; it doesn't choose them.

The skill is free. Get the skill