DealSheet

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.25x

Click any scenario cell to inspect exact monthly cash flow and lender coverage. Emerald cells clear both positive cash flow and your DSCR bar.

Rate \ Vac0%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.

Related Underwriting Guides