A loan portfolio dashboard with real-time rates is the screen a commercial real estate owner opens to see the portfolio’s debt today: balances after last night’s amortization, floating-rate interest at this morning’s SOFR, hedge values at today’s curve, prepayment costs at today’s Treasuries, covenant ratios on the latest close, and the critical dates in the next ninety days. Most dashboards in this category show last quarter’s snapshot with a live rate ticker beside it. The rate is live; nothing it should change has changed. A dashboard earns its place by recalculating the numbers that move with rates every day, and by leaving alone the things it does not own.
What live rates actually change
The reason to refresh rates daily is that specific numbers depend on them:
- Floating-rate interest and projected debt service. Every SOFR and Term SOFR reset flows through balance times rate times daycount, and on agency floaters through re-amortization. See floating-rate re-amortization and SOFR tracking.
- Hedge mark-to-market. Cap and swap values move with the curve and with volatility. See hedge requirements.
- Replacement cap cost. What the next required cap costs at today’s pricing.
- Prepayment cost. Yield maintenance, make-whole and defeasance are functions of today’s Treasuries. See real-time prepayment calculations.
- Rate exposure. Portfolio sensitivity to a 100 basis point move, net of caps, floors and swaps.
- DSCR on floaters where the covenant tests actual debt service, and hypothetical tests keyed to Treasury-plus-spread. See DSCR and debt yield tests.
- Refinancing proceeds under current underwriting at current rates. See the maturity wall refinancing playbook.
A dashboard that shows today’s SOFR next to last quarter’s debt service has not used the rate for anything.
What belongs on the dashboard
Portfolio header
Total debt, weighted average rate and remaining term, fixed versus floating split net of hedges, next twelve months’ maturities, total hedge value, total restricted cash.
Rates
SOFR, 1-month and 3-month Term SOFR, 5- and 10-year Treasuries, the Fed funds target, with the day’s change. This site’s Debt Stack shows the same set, sourced from Pensford, for the same reason.
Exposure
Floating balance by index, floors and caps in the money, projected interest under the forward curve and under stress, and the effect of a 100 basis point move on annual debt service and on portfolio DSCR.
Compliance
Every loan’s DSCR and debt yield on the lender’s definition, distance to threshold, trend, and the next test date. Triggers and extension tests in the same view. See cash management triggers and cash sweeps.
Critical dates
The next ninety days: maturities, extension notice windows, cap replacements, IO expiries, step-downs, repair deadlines, reporting deadlines. See loan critical date tracking.
Prepayment
Cost to exit each loan today, and the total, so that a sale conversation can start with a number.
Hedges
Each instrument’s value, expiry, replacement deadline and replacement cost.
Ranked attention list
The five loans that need action this week, with the reason. See AI-powered debt portfolio surveillance.
A worked example: what changed overnight
Tuesday morning. The 10-year Treasury rose 12 basis points on Monday, 1-month Term SOFR rose 3, and cap volatility rose after a Fed communication. A 28-loan portfolio’s dashboard, refreshed at 6 a.m., shows the following changes from Monday:
Illustrative example:
| Dashboard number | Change from Monday |
|---|---|
| Portfolio prepayment cost to exit today | Down $410,000, because higher Treasuries reduce yield maintenance on the 15 fixed-rate loans; two loans moved from above the floor to the floor |
| Hedge value | Up $95,000 across nine caps, from the rate and volatility moves |
| Replacement cap costs | Up $60,000 in aggregate on the four caps due for replacement in the next year, from volatility |
| Projected next-twelve-month interest on floaters | Up $84,000, from the SOFR move flowing through the forward curve |
| Lender DSCR on floaters tested on actual debt service | Two loans moved closer to threshold by a basis point each; none crossed |
| Hypothetical DSCR tests keyed to Treasury plus spread | Three bank loans’ hypothetical debt service rose; one moved from 1.28x to 1.26x against 1.25x. Flagged |
| Refinancing proceeds on the four loans maturing within 24 months | Down $1.3 million in aggregate under current underwriting |
| Critical dates | Unchanged; one cap replacement deadline moved into the 90-day window |
Eight numbers moved because the market moved. On a dashboard with a rate ticker and quarterly data, one number would have moved: the ticker.
What the dashboard should not do
Replace the reports. The lender still gets the package; the board still gets the page. The dashboard is for the team. See automating the SREO and debt summary.
Show operational metrics it does not own. Occupancy and leasing velocity belong to the property management and BI layer; the dashboard needs the rent roll only as an input to the tests. See Lobby CRE alternatives for the BI-versus-debt distinction.
Pretend precision it lacks. Every number carries an as-of: the rate date, the accounting close date, the servicer reconciliation date. Show them.
What it needs underneath
Loans abstracted to full depth, balances from an amortization engine reconciled to servicers, financials from accounting on a schedule, live market data, and a calculation engine that reruns everything when any input changes. See single source of truth for CRE debt. A dashboard on top of a spreadsheet is a prettier spreadsheet.
How this looks in LoanBoss
Your entire portfolio, one click away. LoanBoss unifies loan abstracts, accounting feeds and live rates to refresh DSCR, balances, rates, mark-to-markets and cash flows automatically, running 600 million-plus calculations daily. Rates come from Pensford’s market data. Every number on the dashboard is derived from the abstracted loan terms under each loan’s conventions, so the live rate changes what it should and nothing it should not. Critical dates and the compliance view sit on the same screen as exposure and prepayment, and any view exports to Excel.
Frequently Asked Questions
How often should rates refresh?
Daily at minimum; SOFR and Treasuries publish daily. Intraday refresh matters only on the day a prepayment or hedge is executed.
Can we set our own stress scenarios?
Yes. Parallel shifts and custom curves, applied across the portfolio, with the effect on interest, DSCR and hedge values.
Who should have access?
Capital markets fully; the CFO and asset management with views scoped to their needs; the board through the reports rather than the dashboard.
Does the dashboard replace the Debt Stack brief?
No. The brief is market context. The dashboard is your portfolio under that context.
Which numbers on the dashboard change when rates move?
Floating-rate interest and projected debt service, hedge mark-to-market, replacement cap cost, prepayment cost, rate exposure, DSCR on floaters and hypothetical tests, and refinancing proceeds under current underwriting. Each one is recalculated when the rate refreshes; a ticker beside stale data recalculates nothing.
Key takeaways
- Live rates matter because specific numbers depend on them: floating interest, hedge values, replacement cap costs, prepayment costs, rate exposure, DSCR on floaters and hypothetical tests, and refinancing proceeds.
- A dashboard that shows today’s SOFR beside last quarter’s debt service has used the rate for nothing.
- The screen should carry portfolio totals, rates, exposure, compliance with distance to threshold, ninety days of critical dates, exit costs, hedge status and a ranked attention list.
- It should not replace lender reports, absorb operational metrics it does not own, or hide its as-of dates.
- Underneath it needs abstracted loans, engine-calculated balances reconciled to servicers, integrated financials, live market data and a recalculation engine.
- A dashboard on a spreadsheet is a prettier spreadsheet.
Related reading
- Portfolio cash flow projections and hold/sell scenarios
- Caps in your debt portfolio
- Loan portfolio management for private equity real estate funds
- The Debt Stack, this week’s rates brief
- SOFR and basis point in the glossary
Complete portfolio visibility without the manual updates. The rate is live, and so is everything it touches.
Sources
- Federal Reserve Bank of New York and CME Group, SOFR and Term SOFR publication
- US Treasury, daily yield curve
- Pensford Capital, daily rate commentary (2026)
- LoanBoss dashboard documentation, loanboss.com