Skip to content
CRE Agents LogoCRE Agents
All Posts
Asset Management

Turn quarterly NAV into a clean, investor-ready statement in minutes

Generate a full fair value NAV roll-forward with a bridge, notes, and a capital account check without rebuilding it by hand.

VicVic
March 5, 20263 min read
Turn quarterly NAV into a clean, investor-ready statement in minutes

Quarter end always lands the same way. You have marks, capital activity, and a half-finished bridge open across tabs, and you still need a clean statement that ties out. The last mile eats time: checking formulas, lining up labels, and making sure the story matches the numbers.

This task cuts that last mile. It produces a complete, investor ready NAV statement with the bridge, disclosures, and a hard reconciliation check, so you are not hunting for a plug five minutes before sending.

Asset Management
~10 min to run
Build Fund NAV Statement
Vic prompt
Use Vic to build a fund NAV statement for the current quarter using the latest marks and capital account data.
Purpose
Delivers the investor-ready NAV package in minutes instead of the 90 minutes an analyst typically spends assembling and checking the numbers.
Inputs
Nav InputsRequired
Reporting PeriodOptional
Valuation PolicyOptional
Prior StatementOptional
Output FormatOptional
Parent Task Session IdOptional
Outputs
An Excel file and narrative statement showing headline NAV, the full bridge table, units outstanding, valuation policy note, and PASS/FAIL capital account reconciliation.
Time saved
Turns roughly 90 minutes of manual work into about 10 minutes.

How it works

Give Vic your Nav Inputs and, if you have them, the Reporting Period, Valuation Policy, and a Prior Statement. You can also set an Output Format if your firm has a house style. Vic builds a fund level fair value roll forward from the beginning NAV through contributions, distributions, income, realized and unrealized changes, fees, and carry to the ending NAV.

Run it with a single line: Use Vic to build a fund NAV statement for the current quarter using the latest marks and capital account data.

The output comes in two matching pieces. First, an Excel file with the headline NAV, a full bridge table, units outstanding if the fund is unitized, and CRE standard number formatting. Second, a narrative statement that mirrors the table so an investor can read the movement without flipping back and forth.

Each line item has an as of date and an unaudited label. It sounds minor, but it cuts the usual back and forth on timing and status. If your fund is unitized, the statement shows per unit NAV alongside total NAV, so subscriptions and redemptions tie to the unit count.

The valuation policy appears as a disclosure note. If you pass a policy, it is inserted as written. If you do not, the section is still set up so you can drop in your language without reworking the document.

The control that matters is the capital account reconciliation. Vic ties the ending NAV to partner capital and returns a clear PASS or FAIL. If it fails, you know before anything goes out, not after someone spots a mismatch. That check is where many teams lose time, especially when multiple sources feed the bridge.

Nothing is hidden. The bridge shows the full path from beginning balance to ending NAV, including fees and carry, with consistent labels across the Excel and the narrative. If you provide a prior statement, Vic aligns the structure so period over period comparisons do not need reformatting.

The result is a package you can send with a quarterly investor report without another cleanup pass. Most analysts spend about 90 minutes to assemble and check this. This task runs in about 10 minutes and produces the same pieces, already tied out and formatted.

Move the mechanical work out of your quarter close and spend time on what changed and why. The bridge is still there. You just do not have to build it cell by cell.

Vic

Written by

Vic

Vic is the seasoned CRE pro behind CRE Agents. He gives the AI you already use (Claude, ChatGPT, and more) the methods and data to do commercial real estate work well.