Q-SBA Suite · Portfolio Analyzer

From loan tape
to fair value.

Upload an SBA 7(a) GIC/COOF pool and turn it into institutional-grade analytics in one session — stratifications, payment and prepayment history, three credit models, cash-flow projections, and a pricing calculator, all the way to a board-ready Excel report.

Upload your own pool · Loan-level detail · Excel & batch export
3
Credit Curve Models
6
Analytics Modules
7
Strat Dimensions
13
Portfolio Metrics
1-Click
Excel Reporting
Why Teams Choose the Portfolio Analyzer

Your pool, fully modeled — from upload to pricing.

Everything an SBA desk needs to understand, defend, and price a GIC/COOF portfolio, without stitching together spreadsheets, valuation models, and reporting tools.

01

From CSV to analytics in minutes

Drop in a loan-list CSV, set your cutoff and settlement dates, pick your pools, and get summary cards and lender, industry, and state concentration tables instantly — no modeling setup.

02

Three credit models, one decision

Run the same pool through a Baseline curve, the Q-SBA Repline, and an ML/XGBoost model — and see how prepayment and default assumptions move value before you commit to a number.

03

Price with scenario conviction

Project monthly cash flows with CPR/CDR sensitivity and a built-in pricing calculator that solves yields across rate and spread scenarios — walk into a bid knowing your number holds.

04

See every loan, not just averages

A full loan tape with search, sort, and CSV export sits beside stratifications across seven dimensions — deal, term, balance, industry, lender, state, and loan status.

05

Track CRA attribution

Community Reinvestment Act credit attributed by segment and ZIP code, so the compliance view comes out of the same analysis as the valuation — not a separate scramble.

06

Board-ready in one click

Export a formatted Excel workbook with every analytics tab, or run the whole pipeline headless in batch mode to refresh reporting on a schedule.

Inside the Product

One workflow — upload, analyze, price.

Six analytics modules carry a single uploaded pool from raw loan tape all the way to a defensible valuation and a board-ready report.

01 — Portfolio Upload & Overview

Drop in a tape, see the pool.

Upload a loan-list CSV, set your cutoff and settlement dates, and select pools. Instantly get summary cards for balances, rates, and term profile, plus lender, industry, and state concentration tables. Active loans missing at the cutoff are carried forward at their last known balance, and per-loan strip-rate overrides flow straight from the upload.

Why it matters

The work that used to mean a morning of spreadsheet wrangling becomes a 30-second upload — with the concentration view your risk team asks for already built.

OVERVIEW
Portfolio Overview
Total Balance
$124.6M
Loans
1,284
WA Gross
9.41%
WA Term
221
Lender Concentration
Live Oak Banking
14.2%
Readycap Lending
10.3%
Byline Bank
7.4%
Huntington National
5.6%
02 — Stratifications & Loan Tape

Every cut of the pool, plus every loan.

Stratification tables across seven dimensions — deal, term, original balance, industry, lender, state, and loan status — sit alongside a full loan-level tape with search, sort, pagination, and one-click CSV download. Move from the portfolio summary to a single loan without leaving the screen.

Why it matters

Due diligence questions don't stop at averages. When a buyer asks about your sub-$150K, 25-year bucket, the answer is one click away.

STRATS
Stratification — By Term
TermLoansBalanceWACWAM
≤ 120 mo186$9.2M10.12%74
121–180241$22.8M9.64%132
181–240372$41.5M9.33%196
241–300318$36.1M9.08%248
> 300 mo167$15.0M8.81%289
Loan tape · 1,284 rowsDownload CSV ↓
03 — Payment & Prepayment History

Read how the pool actually behaves.

Pool and loan-level payment summaries, payoff reasons, and payoff history come with CPR and SMM analytics rendered as stacked-area and line charts. See voluntary versus involuntary prepayment over time so your forward assumptions are anchored to your pool's own track record — not a generic curve.

Why it matters

A pool that prepays faster than the market is worth a different price. Now you can prove it with its own payment history.

PREPAYMENT
CPR / SMM — Trailing 12 Months
24%12%0%
Total CPRInvoluntary SMM
04 — Valuation & Pricing

Three models, monthly cash flows, a price.

Choose among three credit-curve models — a Baseline curve, the Q-SBA Repline, and an ML/XGBoost model — then project monthly cash flows with CPR/CDR sensitivity. The pricing calculator solves yields across rate and spread scenarios, so you can move from assumptions to a defensible number in the same view.

Why it matters

Comparing model outputs side by side turns "what's it worth?" from a debate into a documented, scenario-tested answer.

VALUATION
Cash Flow & Pricing
BaselineQ-SBA ReplineML / XGBoost
Pool Price102.50
Yield @ 100 PPC7.84%
Yield @ 150 PPC7.21%
WAL4.6 yrs
What You Get

A full portfolio analytics stack, out of the box.

Six modules, three credit models, and two export paths — everything needed to take a GIC/COOF pool from upload to a defensible price.

01

Portfolio Upload & Strats

CSV upload with cutoff/settlement config, summary cards, concentration tables, and stratifications across seven dimensions.

02

Loan Tape

Full loan-level data with search, sort, pagination, and one-click CSV download — every loan in the pool.

03

Payment & Prepayment History

Pool and loan-level payment detail, payoff reasons, and payoff history with CPR/SMM analytics and charts.

04

CRA Tracker

Community Reinvestment Act attribution tracking by segment and ZIP code, ready for compliance reporting.

05

Valuation & Pricing

Three credit models (Baseline, Q-SBA Repline, ML/XGBoost), monthly cash flows with CPR/CDR sensitivity, and a scenario pricing calculator.

06

Excel & Batch Export

Formatted Excel workbook with every analytics tab, plus headless batch execution for scheduled reporting.

Ready to see what your pool is worth?

Request a walkthrough of the Q-SBA Portfolio Analyzer and take a pool from loan tape to priced in one session.

Request a Demo