About this video
Trenmoor Partners' underwriting of Verrand House lives in a workbook of 4,800 formulas that one person understands. MicroModeller rebuilds it as a program of standard bricks.
Full description
A product demo of MicroModeller, Fifth Dimension's brick-and-DAG financial model engine, told through one synthetic underwriting: Trenmoor Partners buying Verrand House, a multi-let office in Leeds. The spreadsheet that only one person understands becomes a program of standard bricks: imported from Excel with every answer matching to the pound, written from a one-paragraph brief into the same bricks, swept across five hold periods into five complete workbooks in seconds with no language model in the maths, and assembled from a library of 104 bricks that grows every day.
Key points
- The underwriting workbook: thousands of formulas one person can read, scenario tabs that go stale
- Import the spreadsheet: decompiled and rebuilt as 53 standard bricks, every answer identical to the pound
- Build the same model from a one-paragraph brief and land in the same bricks
- Scenarios: hold period 1 to 5 years, five complete workbooks in seconds, no language model in the maths
- One library of 104 bricks: every model reads, audits and runs the same way
Transcript
This is how an acquisition gets underwritten today. Trenmoor partners are buying Verrand House 168,000 square ft of multi-let office in Leeds and the whole case lives in one workbook. 57.5 million pounds, a 6.67% initial yield, a geared return of 15.6%. Every number on this page is the end of a chain of formulas that nobody has read end to end. Six tenants. Caldwyn leaves in September 2028. 9 months void, 18 months rent-free, then a relet at market.
That one row carries a quarter of the income. The cash flow sheet repeats a nine row block for every tenant, 60 months across. 4,600 formulas on this tab alone. Here is one of them. Contracted rent. A nest of ifs 300 characters long, reaching into three other sheets. One person wrote it and one person understands it. Now add a seventh tenant. Insert the rows. Extend the totals. Repoint the annual summary, the exit and the returns and hope. And every scenario the committee asks for is a copy of a tab stale from the day it is made.
MicroModeller takes a different view of what a model is. Not a grid of cells, but a short program, a list of standard bricks, a lease, a loan, a valuation, a return wired together in the order the engine can evaluate them. A language model is used once to write that program. After that nothing is generated. Building the workbook, moving a driver, running a scenario, all of it is the same deterministic maths every time. There are two ways in describe the deal in plain English or start from the model somebody already built.
Let's start from Trenmoor's workbook. Drop it in 6 seconds to decompile it. Eight sheets, 4,800 formulas. read into code the model can reason about. Then the program is composed. The model reads that code and writes a first draft in bricks. The engine checks it, rejects what does not fit, and the draft is refined. The weight is trimmed here. 53 bricks, a lease brick for every letting, the debt, the exit valuation, the returns, and every annual rollup and debt metric.
The sheet reports the whole underwriting as a diagram you can read left to right and the answers ungeared IRR 10.77% geared 15.57 exit value 89.2 million identical to the spreadsheet to the pound. The other way in is a brief, one paragraph. The price, the six leases, the void and the rent free, the loan, the exit, and what we want back. Build the model. The same bricks composed from words instead of cells. 40 bricks this time. Because a brief only asks for what you want back. the same shape, the same answers.
Whether the model arrives as a spreadsheet or as a sentence, it lands in the same language. Now the question the committee actually asks, what if we hold it for less time? Scenarios one figure a range the hold period from one year in steps of one five values. Build them. No language model runs. The program already exists. Five complete workbooks built in seconds. 1 year 30% geared. 2 years 19. Five the base case 15.6. Each row is a full model you can open, audit, and download.
Nobody copied a tab. All of this rests on one library. 104 bricks in 27 families, leases, debt, valuation, returns, and it grows every day. Every model, imported or written, is assembled from the same parts. So, every model reads the same way, audits the same way, and runs the same way. MicroModeller, the deterministic, consistent way to build a model, and the engine that lets an agent run yours safely.
From data room to cited IC memo
Video details
- Roles
- Owner
- Processes
- Acquisitions
- Geographies
- Europe
- Markets
- United Kingdom
- Tags
- micromodeller-verrand-house, micromodeller