A18 Labs
SAMPLE ANNUAL CREDIT REVIEW

See the kind of analysis your credit team receives.

One fictional commercial relationship, analyzed the way a lender would scrutinize it: a documented credit view, reconciliation of debt service, explicit open conditions, and downloadable editable Word and formula-linked Excel files. The figures are illustrative, not verified borrower evidence.

A18 LABS · COMMERCIAL CREDIT MONITORING REVIEW

Juniper Valley Service Group

Field-services operating company + related real-estate holding company

FICTIONAL · SENIOR-REVIEWED
Senior-reviewed fictional example. All borrower information and supporting records are illustrative. This is not an actual lending decision.
Credit-union exposure$1.554MTwo assumed facilities
FY2025 group revenue$6.780M+7.1% year over year
FY2025 borrower-group DSCR1.45xIncludes identified lease service; guarantor excluded
Illustrative internal target1.25xNot an institution rule
What the review identifiedIllustrative credit questions

$60K of lease service omittedComplete modeled debt service reduces borrower-group coverage from 1.78x to 1.45x. [S-04, S-05]

Working capital is deteriorating22.8% of year-end A/R is over 60 days; ending-balance DSO proxy rose to 53.0 days. [S-03]

Decision-critical evidence missingFull guarantor cash flow, current collateral values, signed loan covenants and the lender risk-rating rubric remain unverified. [S-08 to S-10]

ILLUSTRATIVE CREDIT ASSESSMENTOPEN CREDIT QUESTIONS

Repayment is adequate on modeled FY2025 borrower-group cash flow, but a clean monitoring conclusion is not supported yet.

After correcting the omitted lease obligation, indicative borrower-group DSCR is 1.45x, above the fictional 1.25x monitoring floor. However, a 10% EBITDA downside reduces coverage to 1.19x, below that floor. Rising overdue receivables and weaker 9M2026 EBITDA warrant heightened attention. This is not a verified global guarantor DSCR or a contractual covenant certification.

Credit strengths

  • Three years of modeled positive operating EBITDA and revenue expansion
  • Illustrative 2025 debt coverage above the assumed internal floor
  • Assumed 2025 payment record is satisfactory, subject to confirmation
  • Assumed CRE collateral indicates 62.4% LTV, subject to updated valuation

Key weaknesses

  • Omitted equipment-lease service materially changes repayment assessment
  • 22.8% of receivables aged beyond 60 days and assumed customer concentration
  • 2026 margin softening, stale guarantor liquidity and missing debt detail
  • Contractual covenant and institution policy not independently verified
Illustrative analyst disposition: For an actual borrower, confirm source evidence and complete the institution-specific risk-grade review before a credit decision. Consider enhanced A/R and earnings monitoring while seven open issues are resolved. Only the institution may determine whether the existing assumed Pass-4 rating remains appropriate or approve any renewal, waiver or credit action.

Both files use the same senior-reviewed fictional case, with transparent calculations and open questions. They are examples, not real borrower workpapers.

Read the complete credit reviewFinancial spreads, repayment, collateral, covenants and evidence register
01

Relationship overview and facility status

Juniper Valley Field Services, Inc. is assumed to operate a regional commercial facility-maintenance business. Its commonly owned affiliate, Juniper Valley Property Holdings, LLC, owns and leases the principal service yard to the operating company. Morgan Vale is assumed to control both entities. Rent is internal to the consolidated relationship, so it must not be treated as an additional third-party repayment source. Entity ownership, management tenure, workforce, signed guarantees, customer contracts and competitive positioning are not evidenced in this constructed file; no unsupported positive conclusion is drawn on those factors. [S-01, S-02]

Assumed credit union facilities at 31 December 2025; amounts in dollars unless specified
FacilityOriginalCurrent balance2025 debt serviceStructure / repayment source
CRE mortgage · JV-101$1,450,000$1,216,000$133,000Related property company; operating-group cash flow
Equipment term loan · JV-205$525,000$338,000$114,000Operating company; business cash flow and equipment
CREDIT UNION TOTAL$1,975,000$1,554,000$247,000Two facilities; commitments and maturities require confirmation

Additional assumed outside obligations are a $240,000 operating revolver and $150,000 of finance-lease liabilities. Total modeled relationship debt and leases are $1,944,000; the credit union's own outstanding balance is $1,554,000. Outside lines and leases are included for economic repayment analysis, not as credit-union exposure. [S-04, S-05]

Borrower statusThe lender loan terms, maturities, lien positions, payment status after 2025 and any unfunded commitments must be obtained before release. The fictional 2025 payment ledger reports timely scheduled payments on the two credit-union loans. Payment history after the ledger cut-off and a current lender payment-status confirmation remain open. [S-11]
02

Operating performance and related-entity analysis

Third-party operating revenue grew 7.1% in 2025 while group EBITDA rose 6.7%. Gross margin increased modestly, but higher receivables and work-in-process balances absorbed cash. Group EBITDA combines the operating company's earnings with property operations after recognizing that the $180,000 intercompany rent is not external revenue. [S-01, S-02, S-03]

Illustrative consolidated performance; USD $000
Operating metricFY2023FY2024FY2025
Third-party revenue5,8406,3306,780
Cost of services(3,340)(3,600)(3,840)
Gross profit2,5002,7302,940
Field Services cash operating expense(1,870)(2,030)(2,192)
Field Services EBITDA630700748
Property Holdings net cash EBITDA108115122
Eliminated group EBITDA738815870
Group EBITDA margin12.6%12.9%12.8%

Consolidation check: in FY2025 the holding company received $180,000 of intercompany rent and incurred $58,000 of outside property operating costs, generating $122,000 of EBITDA. The operating company had already deducted the $180,000 rent; eliminating both sides does not create incremental cash. The modeled group EBITDA is therefore $748,000 + $122,000 = $870,000. [S-01, S-02]

Interim watch itemThe synthetic nine months to September 2026 show revenue rising from $4.91M to $5.22M (+6.3%) while EBITDA falls from $650,000 to $610,000 (−6.2%). This is not a full-year DSCR test. Obtain trailing-twelve-month results and a job-margin bridge. [S-12]
03

Borrower-group repayment analysis and debt reconciliation

The illustrative borrower-group monitoring method starts with eliminated group EBITDA, then deducts cash taxes, recurring unfinanced capital expenditures, working-capital investment and owner distributions. It includes economic debt service for the two credit-union facilities, an outside revolver and an equipment finance lease. The guarantor is excluded because other personal income, debt, guarantees and contingent obligations cannot be verified. Accordingly, this is not a complete global guarantor DSCR. This is a constructed lender-monitoring method, not a contractual or regulatory formula. [S-01, S-02, S-05, S-07]

Cash available for debt service; USD $000
CalculationFY2023FY2024FY2025
Group EBITDA738815870
Cash taxes(100)(112)(120)
Recurring unfinanced capital expense(95)(104)(121)
Operating working-capital investment(70)(75)(90)
Owner distributions(55)(62)(65)
Modeled cash available for debt service418462474
Identified payments before omitted lease231250266
Comparable all-in coverageNot establishedNot established1.45x
FY2025 obligations and source differences; USD $000
Payment streamManagement summaryModeled all-inEvidence
Credit-union mortgage principal and interest133133S-04
Credit-union equipment term principal and interest114114S-04
Outside revolver interest1919S-05
Finance lease paymentsNot listed60S-05
TOTAL ANNUAL SERVICE266326S-04, S-05
BORROWER-GROUP DSCR (474 ÷ total)1.78x1.45xS-01, S-02, S-05

The missing $60,000 finance-lease obligation reduces the indicative coverage ratio from 1.78x to 1.45x. This is a completeness issue, not evidence of intentional misstatement. Historical lease schedules are unavailable in this fictional file, so FY2023–24 coverage should not be characterized as comparable all-in DSCR. [S-04, S-05]

Downside testHolding modeled cash uses and $326,000 debt service constant, a 10% reduction in FY2025 group EBITDA lowers cash available for debt service to $387,000 and borrower-group DSCR to 1.19x. This simple sensitivity is not a probability of default or cash-flow forecast.
04

Balance sheet, liquidity and receivables

Group current assets and current liabilities; USD $000
MetricFY2023FY2024FY20259M2026
Unrestricted cash220240205172
Trade accounts receivable7208109851,145
Work in progress150175220242
Inventory9095100116
Total current assets1,1801,3201,5101,675
Total current liabilities8028921,0851,197
Working capital378428425478
Current ratio1.47x1.48x1.39x1.40x

Receivables increased 21.6% during FY2025, significantly ahead of 7.1% revenue growth. The ending-A/R-to-revenue collection proxy increased from 46.7 days in FY2024 to 53.0 days in FY2025 (not a true average-balance DSO). Cash declined from $240,000 to $205,000 despite positive modeled earnings. A complete cash-flow statement and post-year-end collections report would be needed to validate conversion of earnings into cash. [S-03]

Illustrative FY2025 A/R aging; USD $000
Aging bucketBalanceShare of A/R
0–30 days57057.9%
31–60 days19019.3%
61–90 days12012.2%
Over 90 days10510.7%
TOTAL985100.0%

Receivables above 60 days total $225,000 (22.8%). The largest customer accounts for an assumed 29% of annual revenue and 33% of the year-end A/R ledger. Require customer-specific aging, disputed items and subsequent collections before concluding on collectability. [S-03]

05

Collateral, borrowing-base availability and guarantor support

Collateral estimates; assumptions are not current validated appraisals
Secured loanBalanceIndicated collateral valueIndicative leverageAction
CRE mortgage$1,216,000$1,950,00062.4% LTVObtain appraisal update and title status
Equipment term$338,000$450,00075.1% loan-to-valueConfirm machinery value and lien priority

The real-estate value is assumed from a 2023 appraisal and the equipment value from a 2024 estimate. Neither valuation is represented as current, independently verified or realizable liquidation value. Collateral is a secondary recovery source, not a substitute for repayment capacity. [S-09]

Outside revolver borrowing-base illustration; USD $000
Eligibility itemAmount
Gross A/R985
Less: >90 days(105)
Less: 61–90 days(120)
Less: concentration exclusion(65)
Less: contra accounts(15)
Eligible A/R680
Advance rate (75%)510
Less: lender reserve(75)
Estimated borrowing base435
Outside revolver balance(240)
Modeled availability195

The $195,000 indicated borrowing-base availability is not verified without a current signed certificate, underlying account eligibility definitions, reserves and lender approval. It applies to the outside revolver and does not offset the credit union's facility exposure. [S-05, S-06]

Guarantor: the assumed 2024 personal financial summary reports $2.35M net worth and $88,000 liquid assets for Morgan Vale. The information is stale and is not supported by current bank statements, tax returns, a complete debt/guarantee schedule or an examination of other interests. No guarantor cash flow is included in borrower-group CFADS and no fully global coverage ratio is claimed. [S-10]

06

Monitoring tests, contractual covenant and borrower risk

Hypothetical definitions are intentionally separate
TestCalculationIllustrative thresholdDisposition
Internal borrower-group DSCR$474k / $326k = 1.45x1.25x minimumAbove monitoring target
Mortgage agreement FCCR($870k − $120k − $121k − $65k) / $326k = 1.73x1.30x minimumPass under invented agreement
Management DSCR$474k / $266k = 1.78xNot comparableLease service excluded

The hypothetical executed-agreement FCCR excludes modeled working-capital investment, while the separately defined internal monitoring DSCR deducts it. Neither represents a real bank's policy; actual signed agreements, permitted adjustments, test dates and amendments control covenant findings. [S-07, S-08]

Illustrative analyst assessmentRepayment coverage remains above the fictional internal threshold, but the unreported lease stream, increasing aged receivables and interim margin contraction warrant increased monitoring. A prior Pass-4 grade is assumed, not authenticated; it cannot be reaffirmed based solely on this example. A credit officer must evaluate rating migration under the institution’s policy before final approval.
07

Prioritized exceptions and information requests

Exception register: status of every material credit question
Priority / IDIssueAction / ownerStatus
HIGH · E01$60K annual finance lease payment missing from management debt-service summaryObtain executed lease, amortization/payment proof and prior-year debt completeness; reconcile all service. Owner: Analyst and credit officerOPEN
HIGH · E02Guarantor global cash flow and contingent obligations not establishedObtain current personal financial statement, tax returns, cash verification, debt and guarantee schedule. Owner: Borrower and reviewerOPEN
HIGH · E03$225K (22.8%) of receivables over 60 days and assumed 29% customer revenue concentrationObtain subsequent receipts, dispute/retention details, customer-by-customer aging and concentration plan. Owner: Borrower and credit officerOPEN
MEDIUM · E049M2026 earnings down while sales roseRequest trailing-twelve-month financials, job margin bridge and management explanation. Owner: Borrower and analystOPEN
MEDIUM · E05Collateral values stale and revolver borrowing base unverifiedRefresh valuation as policy requires; verify liens, insurance and eligibility certificate. Owner: LenderOPEN
MEDIUM · E06Related-entity/owner ownership and guarantees unsupported by executed recordsConfirm entity structure, lease, guaranties and cross-default/cross-collateral terms. Owner: LenderOPEN
MEDIUM · E07Covenant calculations use fictional definitions; policy status cannot be certifiedRead executed credit agreements, amendments, lender policy and applicable test date. Owner: Credit officerOPEN

All seven items remain open. High-priority items are not cleared because sample arithmetic balances. This is a work-in-progress review with explicit conditions, not an approval recommendation.

08

Monitoring plan, rating review and release conditions

Analyst's provisional risk view: Assume a prior Pass-4 rating for illustration only, with no claim that the historical grade was institution-approved. The mix of acceptable modeled borrower-group coverage and negative cash-conversion trends requires lender consideration of a watch designation or rating migration. Neither rating nor exception approval can be determined without the credit union’s actual rubric and verified facts.

Proposed monitoring and release controls; all pending lender acceptance
Condition / timingRequired evidence and actionCurrent state
Before sample can represent a production releaseAuthenticate original borrower financials, tax returns and debt service; complete financial-source reconciliationNOT DONE
Before covenant or rating signoffObtain executed agreements and lender credit policy; calculate covenant and risk rating using their actual rulesNOT DONE
Before guarantor support is creditedReview signed guarantees, current PFS, personal income taxes, verified liquidity, debt and contingent commitmentsNOT DONE
Before collateral relianceRefresh appraisal or valuation per lender policy, confirm lien perfection, taxes, insurance and eligibilityNOT DONE
Next monthly/quarterly monitoring cadence (illustrative)Track A/R >60 days, collections, top customer concentration, EBITDA margins and debt service changesPROPOSED
Before a real institutional credit decisionDocument case-specific senior review and authorized credit-officer dispositionNOT APPLICABLE TO FICTIONAL SAMPLE

There is no new-money loan request in this example. The proposed response is an analyst escalation and monitoring workplan rather than an approval, waiver, recommendation to extend credit or confirmation of existing covenant compliance.

09

Evidence register, reviewer controls and release status

Fictional source register; no lender files, tax returns or executed contracts were uploaded
RefModeled sourceAnalysis useEvidence status
S-01Field Services FY2023–25 hypothetical operating statementsModeled earnings and cash costsConstructed, not authenticated
S-02Property Holdings FY2023–25 hypothetical operating statementsIntercompany rent elimination, property costsConstructed, not authenticated
S-03Hypothetical balance sheets and A/R ledgerCurrent ratio, aging, collection proxyConstructed; no full cash flow statement
S-04Assumed CU mortgage and equipment notesExposure, repayment requirementsIllustrative; signed terms unavailable
S-05Outside revolver and finance lease scenarioGlobal group obligations and omitted leaseIllustrative; lender confirmation outstanding
S-06Constructed A/R eligibility worksheetBorrowing-base scenario, not certifiedNo signed borrowing-base certificate
S-07Fictional CU monitoring standardIllustrative 1.25x monitoring thresholdNot a real institution policy
S-08Fictional contractual covenantIllustrative 1.30x FCCR thresholdNo executed agreement
S-09Hypothetical 2023 CRE and 2024 equipment valuesIndicative LTV onlyNo current independent valuation
S-10Assumed 2024 guarantor personal financial summaryReported liquidity/net worthStale, no verified global obligations
S-11Fictional 2025 payment ledgerHistoric performance indicatorRecent payment status unverified
S-12Constructed 9M2025 and 9M2026 comparisonMargin deterioration questionNot a current verified interim package
Review-control record for this synthetic public example
ControlDisposition
Mathematical crosschecksChecked against the constructed financial model
Professional source verificationNOT DONE: all source schedules are constructed examples
Senior review of fictional sampleReviewed and approved for illustrative use; formal reviewer signoff is not included in this public example
Institution policy and legal covenant verificationNOT DONE: illustrative definitions only
Credit risk rating and lending decisionReserved to institution; not made by A18
Release statusPublished as a senior-reviewed fictional demonstration, not for an actual credit decision

This sample is an independently written, fictional illustration structured around ordinary commercial-loan periodic-review practices. It is not copied from or approved by any published bank or third-party credit provider. The fictional case was reviewed for demonstration; source verification against a real borrower's records has not occurred.

A18 Labs · Illustrative annual review · No real borrower information, current collateral evidence or customer credit decision.

Discuss an annual review engagement