Example data

Step 6 · Lender package

What an underwriter receives

Every figure with its rule, the documents still missing, the owner’s explanations and the consent record. It saves underwriters time; it does not make their decision.

Documents

7/12
Gaps

Interview answers

0/5
Open

Consents on record

0
None

The document

Underwriting memo
Generated from the workspace. Markdown, so it pastes cleanly into a credit memo template.
# Application package — Juniper Ridge Inn (synthetic sample)
Generated 2026-10-11 by CactusCapital. Figures are computed from borrower-permissioned bank data with published rules; the readiness and risk results are not credit decisions.

## Request
- Amount: $850,000 — PIP / renovation (includes payoff of daily-debit obligations)
- Business: 64-room independent lodging property, Flagstaff, AZ; NAICS 721110; 9 years in business
- Owner credit (self-reported band): 680–719
- Real estate: value $5,400,000, existing mortgage $3,150,000

## Cash flow (bank data)
- Coverage: 24 complete months (2024-10-01 to 2026-09-30)
- T12 operating deposits: $1,809,716 (0.1% vs prior 12)
- T12 cash NOI before debt service: $445,212 (24.6% of deposits)
- Existing debt service, last 3 months annualized: $589,800 (of which daily debits $303,600)
- Proposed debt service at 8% / 300 mo: $78,725
- DSCR existing: 0.75x; pro forma: 1.22x
- Days cash on hand: 75; NSF events T12: 0
- Seasonality (peak/trough month): 3.48; OTA share 32%
- Deposit-based RevPAR (incl. taxes collected): $77
- AZ TPT remitted / deposits: 12.2%

## Funding readiness: 68/100
- [x] Business bank statements (24 months) — provided (24 complete months found)
- [x] Statements current within 60 days — provided (latest transaction 2026-09-30)
- [x] Business tax returns (3 years) — provided
- [ ] YTD P&L and balance sheet — partial
- [ ] Business debt schedule — partial (daily debits found in bank data — confirm they are on the schedule)
- [x] Occupancy / ADR history (PMS or STR report) — provided
- [ ] Use of funds (PIP scope, bids, budget) — partial
- [ ] Appraisal or broker opinion of value + title — missing
- [ ] Personal financial statement, 20%+ owners — missing
- [x] Entity documents and ownership chart — provided
- [x] Arizona TPT filing history — provided
- [-] Franchise agreement and PIP letter — na

## Repayment-risk indicator: 62/100 (Adequate) — rule-based, not calibrated to defaults
- Pro forma debt service coverage: 1.22x → 10/25
- Revenue trend (T12 vs prior 12): 0.1% → 11/15
- Days cash on hand: 75 days → 15/15
- NSF / overdraft events (T12): 0 → 10/10
- Daily-debit financing positions: 1 active (to be refinanced) → 6/10
- Weakest-month coverage: -0.83x → 0/10
- Loan-to-value incl. request: 74.1% → 10/15

Principal factors:
1. Seasonal low months do not cover monthly debt payments
2. Cash flow is thin relative to existing plus proposed debt payments
3. Existing merchant-cash-advance or daily-debit obligations
4. High leverage against the property value

## Product fit (published criteria)
- SBA 7(a) loan: eligible (5/5 criteria met)
- SBA 504 loan: eligible (5/5 criteria met)
- Private credit bridge / PIP loan: eligible (5/5 criteria met)
- Equipment / FF&E financing: eligible (3/3 criteria met)
- C-PACE: needs info (2/4 criteria met)
- Conventional hotel bank loan: not fit (4/6 criteria met)
- Revenue-based financing / MCA: not fit (2/3 criteria met)
- Bank line of credit: not fit (3/5 criteria met)

## Borrower explanations
**Funding purpose.** Break down how the $850,000 would be spent (scope, contractor bids, timeline) and what changes for the property afterward.
> Evidence: Stated purpose: pip renovation
> Answer: (not yet answered)

**Unusual deposit.** What was this deposit, is it likely to recur, and is there supporting paperwork?
> Evidence: 2025-03-17: $38,500 "INSURANCE CLAIM PMT HAIL ROOF" is not operating revenue
> Answer: (not yet answered)

**Unusual deposit.** What was this deposit, is it likely to recur, and is there supporting paperwork?
> Evidence: 2026-02-11: $25,000 "TRANSFER FROM OWNER SAVINGS" is not operating revenue
> Answer: (not yet answered)

**Unusual deposit.** What was this deposit, is it likely to recur, and is there supporting paperwork?
> Evidence: 2026-05-06: $120,000 "ADVANCE FUNDING DESERTLINE CAPITAL" is not operating revenue
> Answer: (not yet answered)

**Daily debits.** Is this a merchant cash advance or similar? Share the agreement, the remaining balance and whether this request should pay it off.
> Evidence: Recurring daily debits to "DESERTLINE CAPITAL" starting 2026-05
> Answer: (not yet answered)

## Consent record
- Not yet shared with any provider.