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.
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.
| Internal illustration band | Loan count | Outstanding balance |
|---|---|---|
| Stable | 2 | $12,250,000 |
| Watch | 2 | $7,150,000 |
| Elevated | 0 | $0 |
| Critical | 1 | $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.
| Loan / asset | Geography | Asset / business type | Outstanding balance | Quarter DSCR | LTV (where valuation supplied) | Illustrative risk band |
|---|---|---|---|---|---|---|
| MF-01 · Illustrative multifamily | Southeast | Multifamily | $7,400,000 | 1.74x | 66.1% | Stable |
| HT-02 · Illustrative hotel | Southwest | Hotel | $6,100,000 | 0.91x | Not available | Critical |
| IN-03 · Illustrative industrial property | Midwest | Industrial | $4,850,000 | 1.57x | 67.4% | Stable |
| HC-04 · Illustrative healthcare business | Northeast | Healthcare | $3,900,000 | 1.25x | Not available | Watch |
| MN-05 · Illustrative manufacturing business | Midwest | Manufacturing | $3,250,000 | 1.23x | Not available | Watch |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Band | Loans | Outstanding balance |
|---|---|---|
| Stable | 2 | $12,250,000 |
| Watch | 2 | $7,150,000 |
| Elevated | 0 | $0 |
| Critical | 1 | $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 ID / project | Borrower (hypothetical) | Original amount | Current balance | Rate / structure | Maturity | Valuation input | LTV (where supplied) |
|---|---|---|---|---|---|---|---|
| MF-01 · Illustrative multifamily | Hypothetical sponsor A | $8,000,000 | $7,400,000 | 5.8% · fixed | Jun 30, 2029 | $11,200,000 | 66.1% |
| HT-02 · Illustrative hotel | Hypothetical sponsor B | $6,500,000 | $6,100,000 | 7.5% · floating | Sep 30, 2027 | Not available | Not available |
| IN-03 · Illustrative industrial property | Hypothetical sponsor C | $5,200,000 | $4,850,000 | 6.0% · fixed | Dec 31, 2028 | $7,200,000 | 67.4% |
| HC-04 · Illustrative healthcare business | Hypothetical sponsor D | $4,300,000 | $3,900,000 | 7.0% · floating | Mar 31, 2028 | Not available | Not available |
| MN-05 · Illustrative manufacturing business | Hypothetical sponsor E | $3,600,000 | $3,250,000 | 6.5% · floating | Dec 31, 2027 | Not available | Not available |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Loan ID | Revenue | Expenses | NOI / EBITDA proxy | Debt service | DSCR | Occupancy |
|---|---|---|---|---|---|---|
| MF-01 | $545,000 | $232,000 | $313,000 | $180,000 | 1.74x | 94.0% |
| HT-02 | $740,000 | $560,000 | $180,000 | $198,000 | 0.91x | 64.0% |
| IN-03 | $370,000 | $132,000 | $238,000 | $152,000 | 1.57x | 98.0% |
| HC-04 | $1,020,000 | $817,000 | $203,000 | $162,000 | 1.25x | Not applicable |
| MN-05 | $1,360,000 | $1,190,000 | $170,000 | $138,000 | 1.23x | Not 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.
| Loan ID | Basis | Revenue | Operating expenses | NOI / EBITDA proxy | Debt service | DSCR | Occupancy | Capex | Cash flow after debt / capex |
|---|---|---|---|---|---|---|---|---|---|
| MF-01 | Original underwriting | $520,000 | $210,000 | $310,000 | $180,000 | 1.72x | 95.0% | $20,000 | $110,000 |
| MF-01 | Selected-quarter actual | $545,000 | $232,000 | $313,000 | $180,000 | 1.74x | 94.0% | $25,000 | $108,000 |
| MF-01 | Illustrative forward budget | $550,000 | $235,000 | $315,000 | $182,000 | 1.73x | 94.0% | $25,000 | $108,000 |
| HT-02 | Original underwriting | $800,000 | $510,000 | $290,000 | $190,000 | 1.53x | 73.0% | $35,000 | $65,000 |
| HT-02 | Selected-quarter actual | $740,000 | $560,000 | $180,000 | $198,000 | 0.91x | 64.0% | $55,000 | -$73,000 |
| HT-02 | Illustrative forward budget | $755,000 | $570,000 | $185,000 | $201,000 | 0.92x | 65.0% | $50,000 | -$66,000 |
| IN-03 | Original underwriting | $355,000 | $120,000 | $235,000 | $152,000 | 1.55x | 98.0% | $12,000 | $71,000 |
| IN-03 | Selected-quarter actual | $370,000 | $132,000 | $238,000 | $152,000 | 1.57x | 98.0% | $15,000 | $71,000 |
| IN-03 | Illustrative forward budget | $372,000 | $134,000 | $238,000 | $152,000 | 1.57x | 98.0% | $16,000 | $70,000 |
| HC-04 | Original underwriting | $950,000 | $730,000 | $220,000 | $155,000 | 1.42x | Not applicable | $18,000 | $47,000 |
| HC-04 | Selected-quarter actual | $1,020,000 | $817,000 | $203,000 | $162,000 | 1.25x | Not applicable | $24,000 | $17,000 |
| HC-04 | Illustrative forward budget | $1,030,000 | $822,000 | $208,000 | $164,000 | 1.27x | Not applicable | $24,000 | $20,000 |
| MN-05 | Original underwriting | $1,350,000 | $1,110,000 | $240,000 | $130,000 | 1.85x | Not applicable | $45,000 | $65,000 |
| MN-05 | Selected-quarter actual | $1,360,000 | $1,190,000 | $170,000 | $138,000 | 1.23x | Not applicable | $60,000 | -$28,000 |
| MN-05 | Illustrative forward budget | $1,380,000 | $1,200,000 | $180,000 | $140,000 | 1.29x | Not applicable | $65,000 | -$25,000 |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Loan ID | Revenue variance | Expense variance | NOI / EBITDA variance | Debt service variance | DSCR variance | Capex variance | Cash 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.
| Measure | 2025 Q4 | 2026 Q1 | 2026 Q2 | 2026 Q3 | Original underwriting | Selected actual | Forward 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 ID | Original underwriting | Previous quarter | Selected actual · 2026 Q3 | Forward budget | Covenant input (illustrative) |
|---|---|---|---|---|---|
| MF-01 | 1.72x | 1.73x | 1.74x | 1.73x | 1.20x |
| HT-02 | 1.53x | 1.08x | 0.91x | 0.92x | 1.25x |
| IN-03 | 1.55x | 1.56x | 1.57x | 1.57x | 1.20x |
| HC-04 | 1.42x | 1.28x | 1.25x | 1.27x | 1.15x |
| MN-05 | 1.85x | 1.32x | 1.23x | 1.29x | 1.20x |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Scenario | Portfolio DSCR | Quarter NOI / EBITDA proxy | Quarter debt service | Quarter 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 points | 1.20x | $998,321 | $830,000 | -$10,679 |
| Floating rate +200 basis points | 1.23x | $1,104,000 | $896,250 | $28,750 |
| Refinancing at +200 basis points | 1.15x | $1,104,000 | $957,500 | -$32,500 |
| Combined downside | 0.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.
Historical Performance Trends
All observations are hypothetical quarterly model values, not real borrower reporting. Portfolio series sum the selected loans for each quarter; no annualized or trailing-period values are implied.
| Measure | 2025 Q4 | 2026 Q1 | 2026 Q2 | 2026 Q3 |
|---|---|---|---|---|
| Revenue | $4,028,000 | $4,040,000 | $4,015,000 | $4,035,000 |
| Operating expenses | $2,729,000 | $2,805,000 | $2,871,000 | $2,931,000 |
| NOI / EBITDA proxy | $1,299,000 | $1,235,000 | $1,144,000 | $1,104,000 |
| Debt service | $807,000 | $814,000 | $823,000 | $830,000 |
| DSCR | 1.61x | 1.52x | 1.39x | 1.33x |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Loan ID | 2025 Q4 | 2026 Q1 | 2026 Q2 | 2026 Q3 |
|---|---|---|---|---|
| MF-01 | 1.75x | 1.75x | 1.73x | 1.74x |
| HT-02 | 1.53x | 1.30x | 1.08x | 0.91x |
| IN-03 | 1.55x | 1.55x | 1.56x | 1.57x |
| HC-04 | 1.41x | 1.37x | 1.28x | 1.25x |
| MN-05 | 1.85x | 1.65x | 1.32x | 1.23x |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
Occupancy is shown in the loan schedules where provided. Portfolio occupancy is not aggregated because the assets and business types do not share a meaningful weighted denominator in the supplied model.
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.
| Loan ID / sector | Illustrative market assumption | Context / scope limit |
|---|---|---|
| MF-01 · Multifamily | Hypothetical 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 · Hotel | Hypothetical 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 · Industrial | Hypothetical 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 · Healthcare | Hypothetical 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 · Manufacturing | Hypothetical 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.
| Loan ID | Cash balance (stock) | Current assets (stock) | Current liabilities (stock) | Current ratio | NOI / EBITDA margin | DSCR | Quarter cash flow after debt / capex | Maturity |
|---|---|---|---|---|---|---|---|---|
| MF-01 | $360,000 | $720,000 | $400,000 | 1.80x | 57.4% | 1.74x | $108,000 | Jun 30, 2029 |
| HT-02 | $95,000 | $210,000 | $300,000 | 0.70x | 24.3% | 0.91x | -$73,000 | Sep 30, 2027 |
| IN-03 | $260,000 | $410,000 | $220,000 | 1.86x | 64.3% | 1.57x | $71,000 | Dec 31, 2028 |
| HC-04 | $175,000 | $460,000 | $360,000 | 1.28x | 19.9% | 1.25x | $17,000 | Mar 31, 2028 |
| MN-05 | $130,000 | $620,000 | $550,000 | 1.13x | 12.5% | 1.23x | -$28,000 | Dec 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.
| Loan ID | Example threshold | Modeled DSCR | Arithmetic comparison | Information needed before covenant conclusion |
|---|---|---|---|---|
| MF-01 | 1.20x | 1.74x | At / above illustrative threshold by 0.54x | Executed terms, adjustments, test date and waivers not supplied |
| HT-02 | 1.25x | 0.91x | Below illustrative threshold by 0.34x | Executed terms, adjustments, test date and waivers not supplied |
| IN-03 | 1.20x | 1.57x | At / above illustrative threshold by 0.37x | Executed terms, adjustments, test date and waivers not supplied |
| HC-04 | 1.15x | 1.25x | At / above illustrative threshold by 0.10x | Executed terms, adjustments, test date and waivers not supplied |
| MN-05 | 1.20x | 1.23x | At / above illustrative threshold by 0.03x | Executed 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.
| Loan ID / project | Budget | Incurred to date | Completion input | Draws | Forecast total cost | Forecast over / (under) budget | Delay | Stabilization assumption | Remaining to forecast total |
|---|---|---|---|---|---|---|---|---|---|
| MF-01 · Illustrative multifamily | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable |
| HT-02 · Illustrative hotel | $1,200,000 | $1,080,000 | 80.0% | $900,000 | $1,380,000 | +$180,000 | 45 days | Hypothetical 2027 Q2 | $300,000 |
| IN-03 · Illustrative industrial property | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable |
| HC-04 · Illustrative healthcare business | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable |
| MN-05 · Illustrative manufacturing business | $1,800,000 | $1,100,000 | 55.0% | $950,000 | $2,050,000 | +$250,000 | 30 days | Hypothetical 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.
| Sector / type | Outstanding balance | Share of selected exposure |
|---|---|---|
| Multifamily | $7,400,000 | 29.0% |
| Hotel | $6,100,000 | 23.9% |
| Industrial | $4,850,000 | 19.0% |
| Healthcare | $3,900,000 | 15.3% |
| Manufacturing | $3,250,000 | 12.7% |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Geography | Outstanding balance | Share of selected exposure |
|---|---|---|
| Midwest | $8,100,000 | 31.8% |
| Southeast | $7,400,000 | 29.0% |
| Southwest | $6,100,000 | 23.9% |
| Northeast | $3,900,000 | 15.3% |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Borrower | Outstanding balance | Share of selected exposure |
|---|---|---|
| Hypothetical sponsor A | $7,400,000 | 29.0% |
| Hypothetical sponsor B | $6,100,000 | 23.9% |
| Hypothetical sponsor C | $4,850,000 | 19.0% |
| Hypothetical sponsor D | $3,900,000 | 15.3% |
| Hypothetical sponsor E | $3,250,000 | 12.7% |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Maturity year | Outstanding balance | Share of selected exposure |
|---|---|---|
| 2027 | $9,350,000 | 36.7% |
| 2028 | $8,750,000 | 34.3% |
| 2029 | $7,400,000 | 29.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.
| Scenario | Loan ID | Base quarterly debt service | Scenario quarterly debt service | Base DSCR | Scenario DSCR | Change in debt service |
|---|---|---|---|---|---|---|
| Floating rate +200 basis points | MF-01 | $180,000 | $180,000 | 1.74x | 1.74x | +$0 |
| Refinancing at +200 basis points | MF-01 | $180,000 | $217,000 | 1.74x | 1.44x | +$37,000 |
| Floating rate +200 basis points | HT-02 | $198,000 | $228,500 | 0.91x | 0.79x | +$30,500 |
| Refinancing at +200 basis points | HT-02 | $198,000 | $228,500 | 0.91x | 0.79x | +$30,500 |
| Floating rate +200 basis points | IN-03 | $152,000 | $152,000 | 1.57x | 1.57x | +$0 |
| Refinancing at +200 basis points | IN-03 | $152,000 | $176,250 | 1.57x | 1.35x | +$24,250 |
| Floating rate +200 basis points | HC-04 | $162,000 | $181,500 | 1.25x | 1.12x | +$19,500 |
| Refinancing at +200 basis points | HC-04 | $162,000 | $181,500 | 1.25x | 1.12x | +$19,500 |
| Floating rate +200 basis points | MN-05 | $138,000 | $154,250 | 1.23x | 1.10x | +$16,250 |
| Refinancing at +200 basis points | MN-05 | $138,000 | $154,250 | 1.23x | 1.10x | +$16,250 |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Scenario | Portfolio quarterly debt service | Portfolio DSCR | Portfolio cash flow after debt / capex |
|---|---|---|---|
| Floating rate +200 basis points | $896,250 | 1.23x | $28,750 |
| Refinancing at +200 basis points | $957,500 | 1.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.
| Scenario | Revenue | Expenses | NOI / EBITDA proxy | Debt service | DSCR | Cash flow after debt / capex |
|---|---|---|---|---|---|---|
| Revenue −10% | $3,631,500 | $2,931,000 | $700,500 | $830,000 | 0.84x | -$308,500 |
| Expenses +10% | $4,035,000 | $3,224,100 | $810,900 | $830,000 | 0.98x | -$198,100 |
| Occupancy −5 percentage points | $3,929,321 | $2,931,000 | $998,321 | $830,000 | 1.20x | -$10,679 |
| Floating rate +200 basis points | $4,035,000 | $2,931,000 | $1,104,000 | $896,250 | 1.23x | $28,750 |
| Refinancing at +200 basis points | $4,035,000 | $2,931,000 | $1,104,000 | $957,500 | 1.15x | -$32,500 |
| Combined downside | $3,631,500 | $3,224,100 | $407,400 | $896,250 | 0.45x | -$667,850 |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Loan ID | Revenue −10% | Expenses +10% | Occupancy −5 pp | Floating rate +200 bp | Refinance +200 bp | Combined downside |
|---|---|---|---|---|---|---|
| MF-01 | 1.44x | 1.61x | 1.58x | 1.74x | 1.44x | 1.31x |
| HT-02 | 0.54x | 0.63x | 0.62x | 0.79x | 0.79x | 0.22x |
| IN-03 | 1.32x | 1.48x | 1.44x | 1.57x | 1.35x | 1.24x |
| HC-04 | 0.62x | 0.75x | 1.25x | 1.12x | 1.12x | 0.11x |
| MN-05 | 0.25x | 0.37x | 1.23x | 1.10x | 1.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.
| Internal illustration band | Rule applied to current DSCR | Loan count | Outstanding balance |
|---|---|---|---|
| Stable | Current DSCR ≥ 1.35x | 2 | $12,250,000 |
| Watch | Current DSCR ≥ 1.20x and < 1.35x | 2 | $7,150,000 |
| Elevated | Current DSCR ≥ 1.00x and < 1.20x | 0 | $0 |
| Critical | Current DSCR < 1.00x | 1 | $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.
Recommended Actions
The following are model-linked questions to validate, not instructions to a lender, servicer, borrower or investment manager.
| Loan ID | Current model observation | Illustrative follow-up question |
|---|---|---|
| MF-01 | Stable band; DSCR 1.74x; maturity Jun 30, 2029 | Obtain the next certified rent roll, concession schedule and trailing operating statement. |
| HT-02 | Critical band; DSCR 0.91x; maturity Sep 30, 2027 | Request a liquidity plan, debt reset terms, renovation cost-to-complete and updated booking pace. |
| IN-03 | Stable band; DSCR 1.57x; maturity Dec 31, 2028 | Review tenant concentration, lease expiry dates and renewal assumptions. |
| HC-04 | Watch band; DSCR 1.25x; maturity Mar 31, 2028 | Obtain receivables ageing, payer mix and evidence supporting staffing assumptions. |
| MN-05 | Watch band; DSCR 1.23x; maturity Dec 31, 2027 | Review backlog conversion, inventory ageing, customer concentration and the expansion funding gap. |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
Portfolio review sequence
- Confirm late or missing reporting and request source-period support.
- Reconcile the model's figures to borrower statements and executed terms.
- Prioritize loans with DSCR pressure, liquidity shortfall, near-term maturity or development variance for responsible-team review.
- Determine whether additional market, collateral, covenant or cash-flow analysis is warranted.
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.
| Measure | Selected quarter actual | Illustrative forward budget | Change: 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 |
| DSCR | 1.33x | 1.34x | +0.01x |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Loan ID | Maturity date | Current outstanding balance | Review horizon |
|---|---|---|---|
| HT-02 | Sep 30, 2027 | $6,100,000 | Confirm renewal / refinance assumptions with responsible lender |
| MN-05 | Dec 31, 2027 | $3,250,000 | Confirm renewal / refinance assumptions with responsible lender |
| HC-04 | Mar 31, 2028 | $3,900,000 | Confirm renewal / refinance assumptions with responsible lender |
| IN-03 | Dec 31, 2028 | $4,850,000 | Confirm renewal / refinance assumptions with responsible lender |
| MF-01 | Jun 30, 2029 | $7,400,000 | Confirm 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.
| Loan ID | Period/basis | Revenue | Expenses | NOI / EBITDA proxy | Debt service | DSCR | Capex | Cash flow after debt / capex | Occupancy | Margin |
|---|---|---|---|---|---|---|---|---|---|---|
| MF-01 | Original underwriting | $520,000 | $210,000 | $310,000 | $180,000 | 1.72x | $20,000 | $110,000 | 95.0% | 59.6% |
| MF-01 | Actual · 2026 Q3 | $545,000 | $232,000 | $313,000 | $180,000 | 1.74x | $25,000 | $108,000 | 94.0% | 57.4% |
| MF-01 | Illustrative forward budget | $550,000 | $235,000 | $315,000 | $182,000 | 1.73x | $25,000 | $108,000 | 94.0% | 57.3% |
| HT-02 | Original underwriting | $800,000 | $510,000 | $290,000 | $190,000 | 1.53x | $35,000 | $65,000 | 73.0% | 36.3% |
| HT-02 | Actual · 2026 Q3 | $740,000 | $560,000 | $180,000 | $198,000 | 0.91x | $55,000 | -$73,000 | 64.0% | 24.3% |
| HT-02 | Illustrative forward budget | $755,000 | $570,000 | $185,000 | $201,000 | 0.92x | $50,000 | -$66,000 | 65.0% | 24.5% |
| IN-03 | Original underwriting | $355,000 | $120,000 | $235,000 | $152,000 | 1.55x | $12,000 | $71,000 | 98.0% | 66.2% |
| IN-03 | Actual · 2026 Q3 | $370,000 | $132,000 | $238,000 | $152,000 | 1.57x | $15,000 | $71,000 | 98.0% | 64.3% |
| IN-03 | Illustrative forward budget | $372,000 | $134,000 | $238,000 | $152,000 | 1.57x | $16,000 | $70,000 | 98.0% | 64.0% |
| HC-04 | Original underwriting | $950,000 | $730,000 | $220,000 | $155,000 | 1.42x | $18,000 | $47,000 | Not applicable | 23.2% |
| HC-04 | Actual · 2026 Q3 | $1,020,000 | $817,000 | $203,000 | $162,000 | 1.25x | $24,000 | $17,000 | Not applicable | 19.9% |
| HC-04 | Illustrative forward budget | $1,030,000 | $822,000 | $208,000 | $164,000 | 1.27x | $24,000 | $20,000 | Not applicable | 20.2% |
| MN-05 | Original underwriting | $1,350,000 | $1,110,000 | $240,000 | $130,000 | 1.85x | $45,000 | $65,000 | Not applicable | 17.8% |
| MN-05 | Actual · 2026 Q3 | $1,360,000 | $1,190,000 | $170,000 | $138,000 | 1.23x | $60,000 | -$28,000 | Not applicable | 12.5% |
| MN-05 | Illustrative forward budget | $1,380,000 | $1,200,000 | $180,000 | $140,000 | 1.29x | $65,000 | -$25,000 | Not applicable | 13.0% |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Loan ID | Quarter | Revenue | Expenses | NOI / EBITDA proxy | Debt service | DSCR | Capex | Cash flow | Occupancy |
|---|---|---|---|---|---|---|---|---|---|
| MF-01 | 2025 Q4 | $530,000 | $215,000 | $315,000 | $180,000 | 1.75x | $20,000 | $115,000 | 96.0% |
| MF-01 | 2026 Q1 | $535,000 | $220,000 | $315,000 | $180,000 | 1.75x | $22,000 | $113,000 | 95.0% |
| MF-01 | 2026 Q2 | $540,000 | $228,000 | $312,000 | $180,000 | 1.73x | $26,000 | $106,000 | 94.0% |
| MF-01 | 2026 Q3 | $545,000 | $232,000 | $313,000 | $180,000 | 1.74x | $25,000 | $108,000 | 94.0% |
| HT-02 | 2025 Q4 | $810,000 | $520,000 | $290,000 | $190,000 | 1.53x | $35,000 | $65,000 | 74.0% |
| HT-02 | 2026 Q1 | $785,000 | $535,000 | $250,000 | $192,000 | 1.30x | $42,000 | $16,000 | 70.0% |
| HT-02 | 2026 Q2 | $760,000 | $550,000 | $210,000 | $195,000 | 1.08x | $48,000 | -$33,000 | 67.0% |
| HT-02 | 2026 Q3 | $740,000 | $560,000 | $180,000 | $198,000 | 0.91x | $55,000 | -$73,000 | 64.0% |
| IN-03 | 2025 Q4 | $358,000 | $122,000 | $236,000 | $152,000 | 1.55x | $12,000 | $72,000 | 98.0% |
| IN-03 | 2026 Q1 | $360,000 | $125,000 | $235,000 | $152,000 | 1.55x | $13,000 | $70,000 | 98.0% |
| IN-03 | 2026 Q2 | $365,000 | $128,000 | $237,000 | $152,000 | 1.56x | $14,000 | $71,000 | 98.0% |
| IN-03 | 2026 Q3 | $370,000 | $132,000 | $238,000 | $152,000 | 1.57x | $15,000 | $71,000 | 98.0% |
| HC-04 | 2025 Q4 | $970,000 | $752,000 | $218,000 | $155,000 | 1.41x | $18,000 | $45,000 | Not applicable |
| HC-04 | 2026 Q1 | $990,000 | $775,000 | $215,000 | $157,000 | 1.37x | $20,000 | $38,000 | Not applicable |
| HC-04 | 2026 Q2 | $1,000,000 | $795,000 | $205,000 | $160,000 | 1.28x | $22,000 | $23,000 | Not applicable |
| HC-04 | 2026 Q3 | $1,020,000 | $817,000 | $203,000 | $162,000 | 1.25x | $24,000 | $17,000 | Not applicable |
| MN-05 | 2025 Q4 | $1,360,000 | $1,120,000 | $240,000 | $130,000 | 1.85x | $45,000 | $65,000 | Not applicable |
| MN-05 | 2026 Q1 | $1,370,000 | $1,150,000 | $220,000 | $133,000 | 1.65x | $50,000 | $37,000 | Not applicable |
| MN-05 | 2026 Q2 | $1,350,000 | $1,170,000 | $180,000 | $136,000 | 1.32x | $55,000 | -$11,000 | Not applicable |
| MN-05 | 2026 Q3 | $1,360,000 | $1,190,000 | $170,000 | $138,000 | 1.23x | $60,000 | -$28,000 | Not applicable |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Loan ID | Revenue | Expenses | NOI / EBITDA proxy | Debt service | DSCR | Capex | Cash flow | Occupancy |
|---|---|---|---|---|---|---|---|---|
| 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,000 | Not applicable |
| MN-05 | +$10,000 | +$80,000 | −$70,000 | +$8,000 | −0.61x | +$15,000 | −$93,000 | Not applicable |
ILLUSTRATIVE DATA — NOT AN ACTUAL CLIENT PORTFOLIO.
| Measure | Definition / limitation |
|---|---|
| NOI / EBITDA proxy | Quarterly revenue less stated operating expenses; excludes depreciation, income tax and interest and does not include lender-specific adjustments. |
| DSCR | Quarterly 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 / capex | Quarterly NOI / EBITDA proxy less debt service and capital expenditure. Not distributable cash or an equity return. |
| Margin | NOI / EBITDA proxy divided by revenue; not a normalized or audited margin. |
| Rate scenario | Incremental quarterly interest approximation: balance × annual rate change ÷ 4 for floating loans; refinancing case applies the same increment to all loans. |
| Occupancy sensitivity | Revenue proportional adjustment only where property occupancy is provided; business occupancy is not applicable. |
| Variance | Selected-quarter actual minus original underwriting; values are not annualized. |
| Not available / not applicable | Unavailable 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.
