Deal Scorecard
Enter a deal's numbers — get an underwriting verdictThis page is a live calculator. Every figure below is computed from the inputs you enter — nothing on this page is placeholder data. Assumptions are yours to change; the underwriting standards the deal is graded against are editable at the bottom of the form.
—
Enter a purchase price to begin
— / 100
Weighted underwriting score
Underwriting scorecard
7 tests · 100 points| Test | This deal | Standard | Result | Points | Score |
|---|
Net operating income & cash flow after debt
By year of hold, in dollarsNet operating incomeCash flow after debt service
Equity build-up
Value vs. loan balanceProperty valueLoan balanceEquity
Where the operating dollar goes
Year 1 expensesAnnual projection
The table behind the charts above| Year | Effective income | Operating expenses | NOI | Debt service | Cash flow | Cumulative | Loan balance | Value | Equity |
|---|
IRR sensitivity
Exit cap rate vs. rent growthBelow hurdleAbove hurdleOutlined cell = your assumptions
Downside tests
Does the deal survive?| Scenario | DSCR | Monthly cash flow | IRR |
|---|
Portfolio Performance
Consolidated operating and investment metricsPORTFOLIO VALUE
$24.8M
▲ 6.8% YoY
TOTAL EQUITY
$10.6M
▲ $1.2M YoY
MONTHLY RENTAL REVENUE
$263K
▲ 4.2% vs. prior month
NET OPERATING INCOME
$1.91M
▲ 5.4% TTM
DEBT OUTSTANDING
$14.2M
57.3% portfolio LTV
DEBT-SERVICE COVERAGE
1.46×
Healthy coverage
OCCUPANCY
94.7%
▼ 0.6 pts MoM
CASH-ON-CASH RETURN
8.3%
▲ 0.4 pts YoY
NOI & Rental Revenue Trend
12 monthsRental revenueNOI
Geographic Exposure
% portfolio valueProperty Performance
Top operating assets| Property | Type | Value | Occupancy | NOI | IRR |
|---|---|---|---|---|---|
| Meridian Apartments | Multifamily | $6.4M | 97% | $510K | 14.2% |
| Northgate Medical | Healthcare | $4.8M | 100% | $392K | 12.6% |
| Commerce Flex I | Industrial | $5.2M | 95% | $431K | 13.8% |
| Westfield Commons | Mixed Use | $4.1M | 91% | $319K | 11.1% |
Executive Alerts
Needs attentionLease rollover concentration
12.4% of annual base rent expires within 180 days.
Capital project variance
Westfield roof project is 8% above approved budget.
Refinance opportunity
Meridian Apartments reached target stabilization.
Property Portfolio
Asset-level operating metrics| Property | Market | Asset Class | Value | Debt | Equity | Occupancy | CoC | IRR | Status |
|---|
Debt & Equity
Capital structure, maturities and coverageWEIGHTED LTV
57.3%
Within policy
WEIGHTED RATE
5.62%
Portfolio debt
AVG. DSCR
1.46×
Above 1.30× target
12-MO MATURITIES
$1.9M
Review refinance plan
Debt Maturity Schedule
Outstanding principalLease Expiration Schedule
Revenue at risk and renewal visibility| Property | Tenant / Units | Expiration | Annual Rent | % Portfolio Rent | Renewal Probability | Action |
|---|---|---|---|---|---|---|
| Northgate Medical | Women’s Health Center | Jan 2027 | $182K | 5.8% | High | Renewal discussion |
| Commerce Flex I | Logistics tenant | Mar 2027 | $121K | 3.9% | High | Prepare extension |
| Westfield Commons | Retail Suite 104 | Apr 2027 | $84K | 2.7% | Medium | Market suite |
Maintenance Trends
Work orders, response time and capital planningOPEN WORK ORDERS
31
▲ 4 this week
AVG RESPONSE TIME
4.8h
▼ 0.9h MoM
YTD CAPEX
$486K
62% of annual plan
PREVENTIVE COMPLETION
96%
Above target
Work Orders by Category
Capital Budget
Annual plan: $780,000
$486,000 spent & committed
Acquisition Pipeline
Opportunity management from sourcing through closingSourced 3
Oakridge Apartments
Charlotte, NC • Multifamily • 48 units
$7.2M asking
Medical Plaza East
Raleigh, NC • Healthcare • 22K SF
$5.6M asking
Commerce Flex II
Greensboro, NC • Industrial • 41K SF
$4.4M asking
Underwriting 2
Parkview Residences
Durham, NC • Multifamily • 72 units
$10.8M
Northline Storage
Richmond, VA • Industrial
$6.1M
LOI / Due Diligence 1
Summit Medical Center
Winston-Salem, NC • Healthcare
$8.9M
Closing 1
Meridian II
Charlotte, NC • Multifamily • 36 units
$5.3M