Skip to content
Independent analysis for capital decisions
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Wert-Berater Financial · Institutional reporting example

Independent Quarterly Loan Portfolio Monitoring Report

Selected view: 5 loans · 2026 Q3 · outstanding exposure $25,500,000. Every figure and market statement is invented for demonstration.

Full five-loan, full-current-quarter illustrative downloads; independent of the selected viewer filters. Downloads show the complete five-loan current-quarter package even if this interactive view is filtered.

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO. The five projects, borrowers, values, dates, historical periods and market notes are hypothetical. This report is not an actual client portfolio, audit, appraisal, credit decision or forecast.

Executive Summary

This selected view contains 5 hypothetical loans for 2026 Q3. Outstanding balance totals $25,500,000; original loan amounts total $27,600,000. All measures refer to one quarterly period or a stated stock measure.

Selected loans5
Current outstanding exposure$25,500,000
Quarter revenue$4,035,000
Portfolio DSCR · quarter1.33x
Current illustrative risk distribution by loan balance
Internal illustration bandLoan countOutstanding balance
Stable2$12,250,000
Watch2$7,150,000
Elevated0$0
Critical1$6,100,000

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Quarter developments and principal concerns

Model-driven review priorities include the lowest current DSCR (HT-02), liquidity and reporting gaps, scheduled maturity exposure, and any development budget variance. These are prompts for document review, not verified borrower events.

Recommended first actions

  • Confirm reporting dates, source documents and definitions used for the selected quarter.
  • Review model-flagged lowest DSCR and liquidity positions against executed loan terms and current statements.
  • Obtain targeted follow-up support identified in each loan's schedule before forming a credit conclusion.

Risk distribution: Stable: 2 loan(s), $12,250,000; Watch: 2 loan(s), $7,150,000; Elevated: 0 loan(s), $0; Critical: 1 loan(s), $6,100,000. These bands are internal illustrative analytics only, not regulatory classifications or formal credit ratings.

Interactive full-portfolio evidence

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

These two charts always show the full five-loan sample. The trend covers all four quarters; the comparison uses 2026 Q3. The selectors affect the detailed tables, not these clearly labelled reference charts. Hover or tap for values; use the comparison legend to show or hide either series.

Loading interactive charts. All financial values remain available in the report tables and downloads.

Portfolio Dashboard

Exposure is a point-in-time outstanding balance. Revenue, expenses, NOI / EBITDA proxy and debt service below are quarterly flows. Portfolio DSCR is the aggregate quarterly proxy divided by aggregate quarterly debt service.

Outstanding loan balance$25,500,000
Original loan amount$27,600,000
Quarter debt service$830,000
Quarter cash flow after debt / capex$95,000
Loan exposure & performance · 2026 Q3
Loan / assetGeographyAsset / business typeOutstanding balanceQuarter DSCRLTV (where valuation supplied)Illustrative risk band
MF-01 · Illustrative multifamilySoutheastMultifamily$7,400,0001.74x66.1%Stable
HT-02 · Illustrative hotelSouthwestHotel$6,100,0000.91xNot availableCritical
IN-03 · Illustrative industrial propertyMidwestIndustrial$4,850,0001.57x67.4%Stable
HC-04 · Illustrative healthcare businessNortheastHealthcare$3,900,0001.25xNot availableWatch
MN-05 · Illustrative manufacturing businessMidwestManufacturing$3,250,0001.23xNot availableWatch

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Portfolio risk-band totals
BandLoansOutstanding balance
Stable2$12,250,000
Watch2$7,150,000
Elevated0$0
Critical1$6,100,000

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Individual Loan Performance

Each row describes a hypothetical loan. Balances and loan terms are stocks or contractual descriptors; financial measures are quarterly unless noted.

Loan identification, exposure & terms
Loan ID / projectBorrower (hypothetical)Original amountCurrent balanceRate / structureMaturityValuation inputLTV (where supplied)
MF-01 · Illustrative multifamilyHypothetical sponsor A$8,000,000$7,400,0005.8% · fixedJun 30, 2029$11,200,00066.1%
HT-02 · Illustrative hotelHypothetical sponsor B$6,500,000$6,100,0007.5% · floatingSep 30, 2027Not availableNot available
IN-03 · Illustrative industrial propertyHypothetical sponsor C$5,200,000$4,850,0006.0% · fixedDec 31, 2028$7,200,00067.4%
HC-04 · Illustrative healthcare businessHypothetical sponsor D$4,300,000$3,900,0007.0% · floatingMar 31, 2028Not availableNot available
MN-05 · Illustrative manufacturing businessHypothetical sponsor E$3,600,000$3,250,0006.5% · floatingDec 31, 2027Not availableNot available

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Current quarter financial performance
Loan IDRevenueExpensesNOI / EBITDA proxyDebt serviceDSCROccupancy
MF-01$545,000$232,000$313,000$180,0001.74x94.0%
HT-02$740,000$560,000$180,000$198,0000.91x64.0%
IN-03$370,000$132,000$238,000$152,0001.57x98.0%
HC-04$1,020,000$817,000$203,000$162,0001.25xNot applicable
MN-05$1,360,000$1,190,000$170,000$138,0001.23xNot applicable

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Original underwriting metrics, current actual, prior quarter and forward budget are detailed in sections 4, 5, 6 and 17. Borrowers, names, dates and amounts are all hypothetical.

Underwritten Versus Actual Performance

Actual and original underwriting values below are quarterly. “Forward” is a separate illustrative next-quarter budget, not a forecast or commitment. Variance equals selected-quarter actual less original underwriting.

Quarterly comparison · 2026 Q3
Loan IDBasisRevenueOperating expensesNOI / EBITDA proxyDebt serviceDSCROccupancyCapexCash flow after debt / capex
MF-01Original underwriting$520,000$210,000$310,000$180,0001.72x95.0%$20,000$110,000
MF-01Selected-quarter actual$545,000$232,000$313,000$180,0001.74x94.0%$25,000$108,000
MF-01Illustrative forward budget$550,000$235,000$315,000$182,0001.73x94.0%$25,000$108,000
HT-02Original underwriting$800,000$510,000$290,000$190,0001.53x73.0%$35,000$65,000
HT-02Selected-quarter actual$740,000$560,000$180,000$198,0000.91x64.0%$55,000-$73,000
HT-02Illustrative forward budget$755,000$570,000$185,000$201,0000.92x65.0%$50,000-$66,000
IN-03Original underwriting$355,000$120,000$235,000$152,0001.55x98.0%$12,000$71,000
IN-03Selected-quarter actual$370,000$132,000$238,000$152,0001.57x98.0%$15,000$71,000
IN-03Illustrative forward budget$372,000$134,000$238,000$152,0001.57x98.0%$16,000$70,000
HC-04Original underwriting$950,000$730,000$220,000$155,0001.42xNot applicable$18,000$47,000
HC-04Selected-quarter actual$1,020,000$817,000$203,000$162,0001.25xNot applicable$24,000$17,000
HC-04Illustrative forward budget$1,030,000$822,000$208,000$164,0001.27xNot applicable$24,000$20,000
MN-05Original underwriting$1,350,000$1,110,000$240,000$130,0001.85xNot applicable$45,000$65,000
MN-05Selected-quarter actual$1,360,000$1,190,000$170,000$138,0001.23xNot applicable$60,000-$28,000
MN-05Illustrative forward budget$1,380,000$1,200,000$180,000$140,0001.29xNot applicable$65,000-$25,000

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Actual variance from original underwriting · selected quarter
Loan IDRevenue varianceExpense varianceNOI / EBITDA varianceDebt service varianceDSCR varianceCapex varianceCash flow variance
MF-01+$25,000+$22,000+$3,000+$0+0.02x+$5,000−$2,000
HT-02−$60,000+$50,000−$110,000+$8,000−0.62x+$20,000−$138,000
IN-03+$15,000+$12,000+$3,000+$0+0.02x+$3,000+$0
HC-04+$70,000+$87,000−$17,000+$7,000−0.17x+$6,000−$30,000
MN-05+$10,000+$80,000−$70,000+$8,000−0.61x+$15,000−$93,000

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Portfolio quarterly comparison
Measure2025 Q42026 Q12026 Q22026 Q3Original underwritingSelected actualForward budget
Revenue$4,028,000$4,040,000$4,015,000$4,035,000$4,035,000$3,975,000$4,087,000
Operating expenses$2,729,000$2,805,000$2,871,000$2,931,000$2,931,000$2,680,000$2,961,000
NOI / EBITDA proxy$1,299,000$1,235,000$1,144,000$1,104,000$1,104,000$1,295,000$1,126,000
Debt service$807,000$814,000$823,000$830,000$830,000$807,000$839,000

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

DSCR Analysis

DSCR is quarterly NOI / EBITDA proxy divided by quarterly debt service. It is not a lender covenant calculation unless the executed agreement's definitions, permitted adjustments and testing terms are applied.

Loan-level DSCR by comparison point
Loan IDOriginal underwritingPrevious quarterSelected actual · 2026 Q3Forward budgetCovenant input (illustrative)
MF-011.72x1.73x1.74x1.73x1.20x
HT-021.53x1.08x0.91x0.92x1.25x
IN-031.55x1.56x1.57x1.57x1.20x
HC-041.42x1.28x1.25x1.27x1.15x
MN-051.85x1.32x1.23x1.29x1.20x

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Illustrative selected-quarter scenario sensitivity
ScenarioPortfolio DSCRQuarter NOI / EBITDA proxyQuarter debt serviceQuarter cash flow after debt / capex
Revenue −10%0.84x$700,500$830,000-$308,500
Expenses +10%0.98x$810,900$830,000-$198,100
Occupancy −5 percentage points1.20x$998,321$830,000-$10,679
Floating rate +200 basis points1.23x$1,104,000$896,250$28,750
Refinancing at +200 basis points1.15x$1,104,000$957,500-$32,500
Combined downside0.45x$407,400$896,250-$667,850

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Scenarios are conditional calculations, not probability estimates. Rate cases use the model's incremental-interest approximation; see methodology and section 12.

Market and Economic Conditions

The statements below come only from invented model notes. There is no external economic, employment, population, supply, demand, competition, interest-rate or industry research in this sample.

Hypothetical context notes by loan
Loan ID / sectorIllustrative market assumptionContext / scope limit
MF-01 · MultifamilyHypothetical new apartment deliveries increase concessions; no actual local market research is represented.Hypothetical only; no source data or observed local market facts are represented.
HT-02 · HotelHypothetical competitive supply and weaker room demand reduce occupancy; all demand assumptions are illustrative.Hypothetical only; no source data or observed local market facts are represented.
IN-03 · IndustrialHypothetical flat leasing demand; a major tenant expiry in 2027 requires review. No observed leasing data is claimed.Hypothetical only; no source data or observed local market facts are represented.
HC-04 · HealthcareHypothetical wage pressure and slower collections affect margins. Patient utilisation is not property occupancy.Hypothetical only; no source data or observed local market facts are represented.
MN-05 · ManufacturingHypothetical input-cost escalation and customer concentration; no external industry forecast is cited.Hypothetical only; no source data or observed local market facts are represented.

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

A live report should identify data source, geography, as-of date, methodology and limitations for any market evidence used. No external market conclusion is inferred here.

Financial Risk Analysis

The indicators below are model outputs for one hypothetical quarter. Liquidity ratios use supplied current assets and current liabilities; they are not audited balances or comprehensive leverage measures.

Financial indicators · selected quarter
Loan IDCash balance (stock)Current assets (stock)Current liabilities (stock)Current ratioNOI / EBITDA marginDSCRQuarter cash flow after debt / capexMaturity
MF-01$360,000$720,000$400,0001.80x57.4%1.74x$108,000Jun 30, 2029
HT-02$95,000$210,000$300,0000.70x24.3%0.91x-$73,000Sep 30, 2027
IN-03$260,000$410,000$220,0001.86x64.3%1.57x$71,000Dec 31, 2028
HC-04$175,000$460,000$360,0001.28x19.9%1.25x$17,000Mar 31, 2028
MN-05$130,000$620,000$550,0001.13x12.5%1.23x-$28,000Dec 31, 2027

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Interpretation boundaries

Cash-flow proxy equals quarterly NOI / EBITDA proxy less quarterly debt service and capital expenditure. It is not distributable cash. No total debt-to-capital or verified leverage ratio is calculated because complete capital structure information is not provided. Refinance exposure depends on future lender terms and market conditions.

Covenant and Exception Monitoring

The model includes invented example DSCR thresholds only. This is a screening comparison, not a finding of covenant compliance, default or breach.

Illustrative DSCR threshold comparison · selected quarter
Loan IDExample thresholdModeled DSCRArithmetic comparisonInformation needed before covenant conclusion
MF-011.20x1.74xAt / above illustrative threshold by 0.54xExecuted terms, adjustments, test date and waivers not supplied
HT-021.25x0.91xBelow illustrative threshold by 0.34xExecuted terms, adjustments, test date and waivers not supplied
IN-031.20x1.57xAt / above illustrative threshold by 0.37xExecuted terms, adjustments, test date and waivers not supplied
HC-041.15x1.25xAt / above illustrative threshold by 0.10xExecuted terms, adjustments, test date and waivers not supplied
MN-051.20x1.23xAt / above illustrative threshold by 0.03xExecuted terms, adjustments, test date and waivers not supplied

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Missing information and follow-up

  • Obtain the executed credit agreement, all amendments and waiver documents.
  • Confirm covenant definitions, testing period, permitted add-backs and reporting dates.
  • Request current certified statements and any outstanding borrower or property reports.
  • Confirm reporting gaps and source periods before routing an exception to the responsible lender.

Construction and Development Monitoring

Only two hypothetical records in the selected model contain a construction schedule. A blank schedule is not interpreted as zero cost or completed construction.

Illustrative project progress schedules
Loan ID / projectBudgetIncurred to dateCompletion inputDrawsForecast total costForecast over / (under) budgetDelayStabilization assumptionRemaining to forecast total
MF-01 · Illustrative multifamilyNot applicableNot applicableNot applicableNot applicableNot applicableNot applicableNot applicableNot applicableNot applicable
HT-02 · Illustrative hotel$1,200,000$1,080,00080.0%$900,000$1,380,000+$180,00045 daysHypothetical 2027 Q2$300,000
IN-03 · Illustrative industrial propertyNot applicableNot applicableNot applicableNot applicableNot applicableNot applicableNot applicableNot applicableNot applicable
HC-04 · Illustrative healthcare businessNot applicableNot applicableNot applicableNot applicableNot applicableNot applicableNot applicableNot applicableNot applicable
MN-05 · Illustrative manufacturing business$1,800,000$1,100,00055.0%$950,000$2,050,000+$250,00030 daysHypothetical 2027 Q3$950,000

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Remaining amount is the arithmetic difference between hypothetical forecast total and incurred input; it is not a verified remaining funding need. Draw status, physical completion and cost-to-complete require supporting evidence and agreed scope.

Portfolio Concentration Analysis

Outstanding balances are allocated by each model record's sector, geography and borrower label. Maturity grouping uses the model date. Concentration percentages use selected-view outstanding balance as denominator.

Exposure by sector / asset type
Sector / typeOutstanding balanceShare of selected exposure
Multifamily$7,400,00029.0%
Hotel$6,100,00023.9%
Industrial$4,850,00019.0%
Healthcare$3,900,00015.3%
Manufacturing$3,250,00012.7%

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Exposure by geography
GeographyOutstanding balanceShare of selected exposure
Midwest$8,100,00031.8%
Southeast$7,400,00029.0%
Southwest$6,100,00023.9%
Northeast$3,900,00015.3%

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Borrower concentration (hypothetical sponsor labels)
BorrowerOutstanding balanceShare of selected exposure
Hypothetical sponsor A$7,400,00029.0%
Hypothetical sponsor B$6,100,00023.9%
Hypothetical sponsor C$4,850,00019.0%
Hypothetical sponsor D$3,900,00015.3%
Hypothetical sponsor E$3,250,00012.7%

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Maturity-year exposure
Maturity yearOutstanding balanceShare of selected exposure
2027$9,350,00036.7%
2028$8,750,00034.3%
2029$7,400,00029.0%

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Interest Rate and Debt Sensitivity

The model adds outstanding balance × annual rate change ÷ 4 to quarterly debt service for floating-rate loans. The refinancing scenario applies this approximation to all loans. Neither case is an amortization schedule, lender quote or forecast.

Rate and refinancing cases · selected quarter
ScenarioLoan IDBase quarterly debt serviceScenario quarterly debt serviceBase DSCRScenario DSCRChange in debt service
Floating rate +200 basis pointsMF-01$180,000$180,0001.74x1.74x+$0
Refinancing at +200 basis pointsMF-01$180,000$217,0001.74x1.44x+$37,000
Floating rate +200 basis pointsHT-02$198,000$228,5000.91x0.79x+$30,500
Refinancing at +200 basis pointsHT-02$198,000$228,5000.91x0.79x+$30,500
Floating rate +200 basis pointsIN-03$152,000$152,0001.57x1.57x+$0
Refinancing at +200 basis pointsIN-03$152,000$176,2501.57x1.35x+$24,250
Floating rate +200 basis pointsHC-04$162,000$181,5001.25x1.12x+$19,500
Refinancing at +200 basis pointsHC-04$162,000$181,5001.25x1.12x+$19,500
Floating rate +200 basis pointsMN-05$138,000$154,2501.23x1.10x+$16,250
Refinancing at +200 basis pointsMN-05$138,000$154,2501.23x1.10x+$16,250

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Portfolio rate / refinance scenario summary
ScenarioPortfolio quarterly debt servicePortfolio DSCRPortfolio cash flow after debt / capex
Floating rate +200 basis points$896,2501.23x$28,750
Refinancing at +200 basis points$957,5001.15x-$32,500

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Fixed-rate loans receive no floating-rate increment in the standard floating-rate scenario. The refinancing case applies the illustrative increment across all selected balances per model definition; actual debt service depends on amortization, spreads, fees and terms.

Stress Testing

Each scenario changes specified inputs to the selected-quarter record and recalculates NOI / EBITDA proxy, debt service, DSCR and cash flow. These are hypothetical sensitivities, not forecasts, probabilities or default estimates.

Portfolio scenario calculations
ScenarioRevenueExpensesNOI / EBITDA proxyDebt serviceDSCRCash flow after debt / capex
Revenue −10%$3,631,500$2,931,000$700,500$830,0000.84x-$308,500
Expenses +10%$4,035,000$3,224,100$810,900$830,0000.98x-$198,100
Occupancy −5 percentage points$3,929,321$2,931,000$998,321$830,0001.20x-$10,679
Floating rate +200 basis points$4,035,000$2,931,000$1,104,000$896,2501.23x$28,750
Refinancing at +200 basis points$4,035,000$2,931,000$1,104,000$957,5001.15x-$32,500
Combined downside$3,631,500$3,224,100$407,400$896,2500.45x-$667,850

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Loan-level scenario DSCR
Loan IDRevenue −10%Expenses +10%Occupancy −5 ppFloating rate +200 bpRefinance +200 bpCombined downside
MF-011.44x1.61x1.58x1.74x1.44x1.31x
HT-020.54x0.63x0.62x0.79x0.79x0.22x
IN-031.32x1.48x1.44x1.57x1.35x1.24x
HC-040.62x0.75x1.25x1.12x1.12x0.11x
MN-050.25x0.37x1.23x1.10x1.10x-0.55x

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Occupancy stress reduces revenue proportionally only for property records with occupancy input; business occupancy is not applicable. Rate changes use quarterly incremental-interest approximation. Combined downside applies revenue −10%, expenses +10% and +200 basis points as defined by the model.

Risk Classification

These internal illustrative analytical categories use selected-quarter DSCR only. They are not regulatory classifications, formal credit ratings, policy risk grades, a full credit decision or a substitute for human review.

Illustrative internal bands and model count
Internal illustration bandRule applied to current DSCRLoan countOutstanding balance
StableCurrent DSCR ≥ 1.35x2$12,250,000
WatchCurrent DSCR ≥ 1.20x and < 1.35x2$7,150,000
ElevatedCurrent DSCR ≥ 1.00x and < 1.20x0$0
CriticalCurrent DSCR < 1.00x1$6,100,000

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Where DSCR cannot be calculated, the model labels the loan “Not rated”; missing data is not assigned to a numeric band. The banding rule ignores qualitative, collateral, guarantor, covenant and market factors.

Portfolio Outlook

The forward figures are separate hypothetical next-quarter budgets from the model. They are not a forecast, expected return, commitment, or market outlook. No event beyond the model inputs is asserted.

Selected actual and illustrative forward budget
MeasureSelected quarter actualIllustrative forward budgetChange: forward less actual
Revenue$4,035,000$4,087,000+$52,000
Operating expenses$2,931,000$2,961,000+$30,000
NOI / EBITDA proxy$1,104,000$1,126,000+$22,000
Debt service$830,000$839,000+$9,000
DSCR1.33x1.34x+0.01x

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Upcoming maturity dates in hypothetical records
Loan IDMaturity dateCurrent outstanding balanceReview horizon
HT-02Sep 30, 2027$6,100,000Confirm renewal / refinance assumptions with responsible lender
MN-05Dec 31, 2027$3,250,000Confirm renewal / refinance assumptions with responsible lender
HC-04Mar 31, 2028$3,900,000Confirm renewal / refinance assumptions with responsible lender
IN-03Dec 31, 2028$4,850,000Confirm renewal / refinance assumptions with responsible lender
MF-01Jun 30, 2029$7,400,000Confirm renewal / refinance assumptions with responsible lender

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Key assumptions: model forward budget values, current stated balance, supplied floating/fixed designation and stated maturity. Downside exposures include revenue or occupancy pressure, expense escalation, rate reset and development cost variance. Actual market and debt outcomes are unknown.

Supporting Financial Schedules

This section provides the model schedules and formula basis behind the summary. Financial values are quarterly flows unless identified as balances, terms, thresholds or dates.

Per-loan comparison schedule · selected quarter
Loan IDPeriod/basisRevenueExpensesNOI / EBITDA proxyDebt serviceDSCRCapexCash flow after debt / capexOccupancyMargin
MF-01Original underwriting$520,000$210,000$310,000$180,0001.72x$20,000$110,00095.0%59.6%
MF-01Actual · 2026 Q3$545,000$232,000$313,000$180,0001.74x$25,000$108,00094.0%57.4%
MF-01Illustrative forward budget$550,000$235,000$315,000$182,0001.73x$25,000$108,00094.0%57.3%
HT-02Original underwriting$800,000$510,000$290,000$190,0001.53x$35,000$65,00073.0%36.3%
HT-02Actual · 2026 Q3$740,000$560,000$180,000$198,0000.91x$55,000-$73,00064.0%24.3%
HT-02Illustrative forward budget$755,000$570,000$185,000$201,0000.92x$50,000-$66,00065.0%24.5%
IN-03Original underwriting$355,000$120,000$235,000$152,0001.55x$12,000$71,00098.0%66.2%
IN-03Actual · 2026 Q3$370,000$132,000$238,000$152,0001.57x$15,000$71,00098.0%64.3%
IN-03Illustrative forward budget$372,000$134,000$238,000$152,0001.57x$16,000$70,00098.0%64.0%
HC-04Original underwriting$950,000$730,000$220,000$155,0001.42x$18,000$47,000Not applicable23.2%
HC-04Actual · 2026 Q3$1,020,000$817,000$203,000$162,0001.25x$24,000$17,000Not applicable19.9%
HC-04Illustrative forward budget$1,030,000$822,000$208,000$164,0001.27x$24,000$20,000Not applicable20.2%
MN-05Original underwriting$1,350,000$1,110,000$240,000$130,0001.85x$45,000$65,000Not applicable17.8%
MN-05Actual · 2026 Q3$1,360,000$1,190,000$170,000$138,0001.23x$60,000-$28,000Not applicable12.5%
MN-05Illustrative forward budget$1,380,000$1,200,000$180,000$140,0001.29x$65,000-$25,000Not applicable13.0%

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Quarterly history by loan
Loan IDQuarterRevenueExpensesNOI / EBITDA proxyDebt serviceDSCRCapexCash flowOccupancy
MF-012025 Q4$530,000$215,000$315,000$180,0001.75x$20,000$115,00096.0%
MF-012026 Q1$535,000$220,000$315,000$180,0001.75x$22,000$113,00095.0%
MF-012026 Q2$540,000$228,000$312,000$180,0001.73x$26,000$106,00094.0%
MF-012026 Q3$545,000$232,000$313,000$180,0001.74x$25,000$108,00094.0%
HT-022025 Q4$810,000$520,000$290,000$190,0001.53x$35,000$65,00074.0%
HT-022026 Q1$785,000$535,000$250,000$192,0001.30x$42,000$16,00070.0%
HT-022026 Q2$760,000$550,000$210,000$195,0001.08x$48,000-$33,00067.0%
HT-022026 Q3$740,000$560,000$180,000$198,0000.91x$55,000-$73,00064.0%
IN-032025 Q4$358,000$122,000$236,000$152,0001.55x$12,000$72,00098.0%
IN-032026 Q1$360,000$125,000$235,000$152,0001.55x$13,000$70,00098.0%
IN-032026 Q2$365,000$128,000$237,000$152,0001.56x$14,000$71,00098.0%
IN-032026 Q3$370,000$132,000$238,000$152,0001.57x$15,000$71,00098.0%
HC-042025 Q4$970,000$752,000$218,000$155,0001.41x$18,000$45,000Not applicable
HC-042026 Q1$990,000$775,000$215,000$157,0001.37x$20,000$38,000Not applicable
HC-042026 Q2$1,000,000$795,000$205,000$160,0001.28x$22,000$23,000Not applicable
HC-042026 Q3$1,020,000$817,000$203,000$162,0001.25x$24,000$17,000Not applicable
MN-052025 Q4$1,360,000$1,120,000$240,000$130,0001.85x$45,000$65,000Not applicable
MN-052026 Q1$1,370,000$1,150,000$220,000$133,0001.65x$50,000$37,000Not applicable
MN-052026 Q2$1,350,000$1,170,000$180,000$136,0001.32x$55,000-$11,000Not applicable
MN-052026 Q3$1,360,000$1,190,000$170,000$138,0001.23x$60,000-$28,000Not applicable

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Variance calculations: actual less original underwriting
Loan IDRevenueExpensesNOI / EBITDA proxyDebt serviceDSCRCapexCash flowOccupancy
MF-01+$25,000+$22,000+$3,000+$0+0.02x+$5,000−$2,000−1.0%
HT-02−$60,000+$50,000−$110,000+$8,000−0.62x+$20,000−$138,000−9.0%
IN-03+$15,000+$12,000+$3,000+$0+0.02x+$3,000+$0+0.0%
HC-04+$70,000+$87,000−$17,000+$7,000−0.17x+$6,000−$30,000Not applicable
MN-05+$10,000+$80,000−$70,000+$8,000−0.61x+$15,000−$93,000Not applicable

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Model calculation and interpretation definitions
MeasureDefinition / limitation
NOI / EBITDA proxyQuarterly revenue less stated operating expenses; excludes depreciation, income tax and interest and does not include lender-specific adjustments.
DSCRQuarterly NOI / EBITDA proxy divided by quarterly debt service. Portfolio DSCR is total proxy divided by total debt service, not an average of loan ratios.
Cash flow after debt / capexQuarterly NOI / EBITDA proxy less debt service and capital expenditure. Not distributable cash or an equity return.
MarginNOI / EBITDA proxy divided by revenue; not a normalized or audited margin.
Rate scenarioIncremental quarterly interest approximation: balance × annual rate change ÷ 4 for floating loans; refinancing case applies the same increment to all loans.
Occupancy sensitivityRevenue proportional adjustment only where property occupancy is provided; business occupancy is not applicable.
VarianceSelected-quarter actual minus original underwriting; values are not annualized.
Not available / not applicableUnavailable input remains not available; a measure that does not apply to a business record remains not applicable. Neither is interpreted as zero.

ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.

Methodology disclosure: Every value, place, borrower, market condition and date is hypothetical. Reporting-period selection does not create real observations. Quarterly property NOI and business EBITDA proxies equal revenue less the stated operating expenses. They exclude depreciation, income tax and interest; detailed lender cash-flow adjustments are not modelled. DSCR = quarterly NOI/EBITDA proxy ÷ quarterly debt service. Portfolio DSCR = total quarterly proxy ÷ total debt service, not an average of loan ratios. After-debt/capex cash flow = NOI/EBITDA proxy − debt service − capital expenditure. It is not investor distributable cash or an equity return. Rate scenarios add outstanding balance × annual rate change ÷ 4 to quarterly debt service for floating loans; the refinancing scenario applies to all loans. These are incremental-interest approximations, not amortisation quotes. Occupancy stress reduces revenue proportionally only for property records with an occupancy input; business occupancy is not applicable. It assumes unchanged rates and expenses and is not a demand forecast. Risk bands use current DSCR alone to make the example reproducible. They are illustrative internal analytical categories, not regulatory classifications, formal credit ratings or a full credit decision. Covenant comparisons use invented example thresholds. Actual compliance requires the executed agreement, permitted adjustments, testing dates, waivers and reliable financial statements. Projected figures are a separate illustrative next-quarter budget. Valuation-based leverage is shown only where a hypothetical valuation is supplied; missing values are not zero.

Interpretation and scope

Illustrative data only. The calculations demonstrate a reporting method; they do not constitute regulated investment advice, audit assurance, appraisal, servicing, legal advice or lender credit judgment. Actual use requires agreed scope, source documentation, definitions, reliance and intended recipients.

Engagements Completed
4,000+
SBA Studies Accepted by Lenders
1,300+
USDA Studies in Agency Financing
950+
Project Value Evaluated
$43.8B
Feasibility Consultants Since
1998

Thousands of real estate, business, and machinery appraisal and litigation assignments.