Frankfor Excel
An add-in for Windows Excel

Understand any model. Find what’s wrong with it.

Frank reads a formula back to you in plain words, finds every hardcode and broken pattern in one pass, and formats to house style from the keyboard. It never leaves your laptop.

WindowsExcel 2016 or Microsoft 365No admin rights

Summary!C5Precedents · Equity IRR
=IRR(C13:H13)
IRR of Equity cash flow (2026 to 2031)
ElementReads asValue
'Cash flow'!C13Equity cash flow (2026)(41,481)
 =SUM(C5:C12)sum of EBITDA to Selling costs (2026)(41,481)
'Cash flow'!D13Equity cash flow (2027)1,650
'Cash flow'!E13Equity cash flow (2028)6,627
Excel follows the highlight as you arrow throughCtrl+Shift+[ on any cell

Three things you do by hand today

You inherited the model. Someone wants to know what drives the IRR by Thursday. Reading someone else’s model is most of the job, and nobody teaches it.

Explore

See what a number depends on, in words

Ctrl+Shift+[ opens the Explorer: the formula as a tree, every reference labelled from the sheet itself — Revenue (2027), not D10. Arrow through it and Excel jumps with you.

Trace to inputs takes an output all the way back to the typed-in assumptions in one keypress, so “what’s driving this?” takes a keypress, not an afternoon.

Frank Explorer showing the precedents of an equity IRR as a tree, with each cash-flow cell labelled by year

Precedents of an IRR on the fictional demo model. Green rows are links to other sheets.

Audit

Find what's wrong in one pass

The health check lists consistency breaks, numbers typed inside formulas, error cells, broken and unused names, hidden rows and formulas nothing depends on — each with the pattern it expected to see.

Export the list to a review sheet with a link to every cell and hand it to whoever built the model. The checks dashboard reads your own OK / CHECK table and tells you which one fails.

Frank's model health check listing consistency breaks, hardcoded numbers, a broken name, an unused name and a hidden row, with one row selected

A 2028 total that skips the interest row, caught with the fix suggested.

Format

House style with one hand

Cycle font colour, fill, number and date formats; flip a range between units, thousands and millions; AutoColor a sheet — inputs blue, formulas black, links green.

Add-ins usually destroy Excel's own Undo when they write to cells. Frank Undo puts back exactly what it changed, one step at a time.

A
B
C
D
4
Year
2026
2027
2028
5
Keys
180
180
180
6
Occupancy
55.0%
63.0%
71.0%
7
ADR (USD)
320
330
339
10
Rooms revenue
11,563
13,642
15,836
12
Total revenue
15,610
18,417
21,379
Frank: AutoColor applied to C5:H20 (Ctrl+Shift+Z undoes) input formula link

AutoColor on a revenue block: typed-in numbers turn blue, formulas black, links to other sheets green.

Built for the keyboard

Every command has a key and every key can be changed. If another add-in already owns one, reassign it in Settings — the Ctrl+Alt combinations are rarely taken.

Explorer: what this cell reads fromCtrl+Shift+[
Explorer: what reads this cellCtrl+Shift+]
Trace to inputsCtrl+Alt+I
Model health checkCtrl+Alt+C
Consistency check on the selectionCtrl+Shift+Q
Hardcoded numbersCtrl+Shift+H
Cycle font colourCtrl+Shift+C
Units / thousands / millionsCtrl+Alt+M
Frank UndoCtrl+Shift+Z
Jump back to where you wereCtrl+Backspace
Go to a defined nameCtrl+Alt+N
Every tool, with its keyCtrl+Alt+H opens the Frank window

Works alongside Capital IQ, Macabacus, FactSet and Arixcel. Settings › Add-ins shows which of them are installed and which keys they hold.

Built for locked-down laptops

Most analysts don’t get to choose their software; IT does. Frank is built so the answer to every question on IT’s form is “no”.

No network, ever

No telemetry, no update checks, no account, no server. The licence is a signed file you install once. You can put the laptop in flight mode and nothing changes.

Installs per user

No admin rights. The installer puts one file in your own profile and registers it with Excel the same way Excel's own Add-ins dialog does. Uninstall removes it cleanly.

Reads, unless you ask it to write

The Explorer, audits, compare and navigation only read. Only formatting commands write to cells, and Frank Undo reverses each one.

Plain-text settings

Keys, colours and settings are plain-text files you can open in Notepad. A one-page security note for your IT team is available on request: ask for it.

Pricing

One licence, one person, every machine you use. Try it free for 14 days first — no card, and nothing to cancel.

Founding licence · first 100
S$45 / year
  • Locked at S$45 for three years
  • Every feature, every update
  • Licensed to you, not to one computer
  • Email the person who built it
Get a founding licence
Individual
S$99 / year
  • Every feature, every update
  • Licensed to you, not to one computer
  • Email support
Buy a licence
Teams
Ask · per seat
  • One invoice, one licence file per person
  • Security note and file list for IT
  • Roll-out help for the first week
Talk to us

Prices in Singapore dollars. A licence is tied to your name and email, so it works on your work laptop and your own. When the trial ends the tools stop and your settings stay; install the licence file from Settings › About to carry on.

Questions

Before you install.

Windows says "Windows protected your PC" when I run the installer.

That's SmartScreen, and it says that about any new program that hasn't yet been downloaded by many people. Frank isn't code-signed yet — a certificate is on the list for the first signed release. Click More info, then Run anyway. If you'd rather wait for the signed build, email us and we'll tell you when it's out.

Does it work with Capital IQ, Macabacus or other add-ins installed?

Yes. If two add-ins want the same key, whichever registered last usually wins, so a Frank key that does nothing is almost always owned by one of them. Reassign it on the Shortcuts page in Settings.

Does it change my workbook?

Only the formatting commands write to cells — colour, number format, scaling, AutoColor — and Frank Undo reverses them. Everything else reads. Exporting an audit adds a "Frank review" sheet, which you can delete like any other.

What happens when the trial ends?

The tools stop running. Your keys, colours and settings stay exactly as they were. Install a licence file from Settings › About and everything comes back.

Mac?

Not yet. Frank is Windows Excel only — desktop Excel 2016 or later, including Microsoft 365. It doesn't run in Excel for the web.

Why "Frank"?

Because that’s the job: to be frank about a model. Frank says what a model actually does, including the parts someone typed over.

Who made this

Frank is built in Singapore by Averyl Seah. The last few years were deal teams and internships at Lazard, Novo Holdings, UOB Investment Banking, Temasek’s GenZero and PwC — mostly inheriting other people’s models. Frank is the tool I wanted on the desk. If something in it is wrong or missing, tell me; I read every email.