A scoring tool that ranks assets for one fund

Before each allocation review, analysts rebuilt a ranked asset list from separate leasing, capex and debt schedules held in different spreadsheets. Rolling up net operating income, upcoming lease expiries and planned capital spend into one comparable score took two analysts most of a week, and the ranking logic varied slightly between cycles, making quarter-over-quarter comparisons unreliable.

We built a scoring model that pulls net operating income, lease expiry schedules and capex forecasts into Supabase, then calculates a weighted score per asset using fixed, versioned rules the team can see and adjust. A Next.js dashboard shows the ranked list, a breakdown of each asset's three sub-scores and a trend view against the prior three quarters, so analysts walk into allocation meetings with one agreed number per asset.

Quarterly allocation review preparation, which now starts from one ranked list instead of five spreadsheets, lease rollover tracking, where upcoming expiries are flagged automatically against the score, and capital planning discussions, where the capex sub-score gives a consistent basis for comparing requests across assets of different sizes.