Lender & Partner One-Pager Underwriting Packet Checklist
Private lenders, DSCR brokers, and equity partners review dozens of messy spreadsheets every week. A disciplined one-page credit memo gets funded faster.
Credit Memo Core Sections
KPI Bar + Basis & Financing + NOI Pro-Forma + Itemized Rehab + 7x7 Stress Matrix
Calibration Deals:
Post-Refi DSCR
1.33x
>= 1.25x Pass
Monthly Cash Flow
+$565
+$6,780/yr
Cap Rate
11.43%
NOI $27,438/yr
70% Flip MAO
$203,500
$36,500 over
Cash Left in Deal
$39,788
Refi Net $252,281
1% Rule / GRM
1.46%
GRM 5.7x
Deal Assumptions
$
$
$
$
7x7 Interest Rate vs Vacancy Stress Matrix
26/49 cells pass DSCR >= 1.25xClick any scenario cell to inspect exact monthly cash flow and lender coverage. Emerald cells clear both positive cash flow and your DSCR bar.
| Rate \ Vac | 0% | 3% | 5% | 8% | 10% | 15% | 20% |
|---|---|---|---|---|---|---|---|
| 5.50% | |||||||
| 6.00% | |||||||
| 6.50% | |||||||
| 7.00% | |||||||
| 7.50% | |||||||
| 8.00% | |||||||
| 8.50% |
Annual Operating Statement & Debt Service
- Gross Scheduled Income
- $42,000
- Effective Gross Income
- $39,900
- Operating Expenses
- -$12,462
- Net Operating Income
- $27,438
- Monthly Debt (P&I)
- $1,277.38
- Total Cash Required
- $93,200
Educational mathematical modeling worksheet only; not financial, tax, lending, or legal advice.
Reference Scenario Benchmarks
| Scenario | Inputs | Result | Underwriting Note |
|---|---|---|---|
| Executive KPI Strip | DSCR, Cash Flow, Cap, IRR | 5-Second Read | Lenders verify coverage ratio before anything else |
| 28-Item Rehab Summary | Grouped by Trade Category | Draw Schedule Ready | Proves scope was walked rather than guessed |
| 7x7 Sensitivity Grid | Rate +/-1.5% x Vac 0%-20% | Downside Proof | Shows exact margin of safety under stress |
Field Verification Checklist
- 1 State clear purchase price, ARV comps basis, itemized rehab totals, and exit refinance assumptions.
- 2 Show Year 1, Year 5, and Year 10 remaining loan balances cleanly.
- 3 Include a clear modeling notice reminding partners that projections are mathematical estimates.