Systems

Systems that hold together

AI has made finance tools easy to build. Keeping them well-structured, documented and maintainable is another matter, especially on a leaner team. Arc & Bearing builds, reviews and maintains the models, plans and tools real estate teams depend on, and hands them over so the team can run them.

Audit & Stabilize

A structural review of the models, plans and AI-built tools a team already runs, especially the ones nobody fully understands any more.

  • An inventory of every model, report and tool, and what feeds what
  • Where the structure is fragile, duplicated or hard to change
  • Repairs to formulas, links and logic
  • Documentation the team can follow and maintain

FIXED FEE · THE STARTING POINT

Ongoing support

Technical upkeep for a leaner team: changes to the system as the business changes, while the team keeps ownership of its data and figures.

  • Changes for new deals, funds, properties and structures
  • Upkeep of formulas, connections and reports
  • Review of tools the team builds with AI
  • Training so the team can make changes itself

MONTHLY

Build

When something is missing, a new piece built to fit the system already in place.

  • Underwriting, development pro formas and capital stacks
  • Distribution waterfalls and fund analytics
  • Budgets, forecasts and planning platforms, including Workday Adaptive Planning
  • Reporting, data pipelines and AI tools over your own data

FIXED FEE

The client owns its data, its inputs and every figure the system produces, and reviews and signs off the numbers. Arc & Bearing looks after how the system is built and works.

Helm · demo

How a custom system works

Helm is an example of a custom system that can be built: commercial property operations and business operations in one comprehensive model, on a single platform. A system like it takes data from the sources a team already uses, keeps it in one place, runs the firm's own calculations on it and puts the results on screens and in reports. This one runs on an invented portfolio; every name and number is made up.

  • 5 kinds of data source
  • 6 calculation engines
  • 100+ measures in the cube
  • 60 months modeled

The system, end to end

Because the platform is custom, it fits the data stack a team already has instead of the other way round. The calculations are the firm's own, and the same screens work whichever sources are connected.

01 Data sources

02 Data layer

03 Calculation engine

04 Screens & outputs

Point at any part of the system, or tap it, to see what it does and what it connects to.

Follow one number

September 2026 at Summit Commons, a retail property in A Portfolio, from the rent roll to the investors' return. Each figure is calculated from the one before it, not typed in.

  1. 01Rent$119,16510 spaces × $11,916 a month
  2. 02Revenue$140,372+ $30,805 recoveries, parking & other− $9,598 vacancy & credit loss
  3. 03NOI$101,770− $38,602 operating expensesincl. $3,509 fee revenue to the manager
  4. 04Value$19.98M$1.25M forward NOI÷ 6.25% cap rate
  5. 05Equity$9.68M− $10.30M debt$48,496 interest this month
  6. 06A Portfolio$336,066net income, last 12 months12.65% IRR to investors

Under the hood

Three layers, each replaceable on its own, so the system can grow with the business.

  1. ScreensNext.js web appStatements, maps, pro formas, the cube and the bridge, on desktop and phone. Every value shows whether it is an actual, a model or an override.
  2. Calculation servicePython · FastAPIRuns the P&Ls, fees, pro formas and waterfalls, and recalculates what depends on an input the moment it changes.
  3. DatabasePostgreSQLEvery entity, actual and plan by month, with row-level security so each person sees exactly what they should.
  • ScenariosRun a downside next to the baseline without copying a workbook.
  • Overrides with a trailPlug any modeled value; the model's number stays visible beside it.
  • Access by designSign-in on every screen and permissions enforced in the database.
  • Exports & APICSV, Excel and PowerPoint out of the box, and an API for anything else.

Explore the screens

Helm's real screens on the invented portfolio. Change anything; nothing is saved.

FROM A STUDY