DealSheet

Underwrite Rental, BRRRR, STR & Flip Deals in 90 Seconds.

Test purchase price, rehab scope, refinance LTV, STR nightly rates, DSCR coverage, and 70% MAO directly below, then inspect all 49 interest-rate and vacancy shock scenarios side by side.

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.

Built for the Walkthrough, Not a $240/yr Subscription Wall

Real estate software routinely locks Lender PDF exports, refinance modeling, and multi-property comparisons behind $120 to $390 annual plans while forcing account logins and third-party data connections.

DealSheet keeps every calculation deterministic and strictly on your device: zero cloud lock-in, zero bank credentials, and clean archival PDF credit sheets ready to share with lenders or partners.

Capability DealSheet (iOS & iPad) Typical Investor SaaS
Annual Cost $39.99/yr (or $89.99 Lifetime) $120 to $390/yr recurring
Offline Property Walkthroughs 100% offline, zero login wall Account required, cloud dependent
Rehab Scope Estimator 28-item catalog + Light/Cosmetic/Full Gut Often gated to highest tier
Downside & Offer Modeling Dual 7x7 stress grids, Reverse Offer Solver & 30-Yr Charts Single-point static slider only
Lender & Partner Exports One-Pager PDF + Pro-Forma CSV Watermarked or top-tier add-on
Privacy & Permissions Zero camera, location, or bank logins Bank account logins & cross-app tracking

20 Real Estate Underwriting Calculators & Formula Guides

Each guide opens pre-calibrated in the interactive underwriting workbench with exact formula breakdowns and real benchmark comparisons.

01 / Debt Service Coverage Ratio

DSCR 1.25 Threshold Math

Most investment property lenders require a minimum Debt Service Coverage Ratio of 1.20x to 1.25x so net operating income covers principal and interest with a 25% margin of safety.

02 / Maximum Allowable Offer

70% Rule Fix & Flip MAO

The 70% rule screens residential flips rapidly by allocating 30% of After-Repair Value to acquisition closing, holding carry, resale commissions, and target operator profit.

03 / Cash Left in Deal

BRRRR Refi LTV Tables

Five percentage points of refinance LTV can swing cash left in a BRRRR project by $15,000 to $25,000 while tightening post-refinance monthly debt service coverage.

04 / Rent-to-Price Ratio

1% vs 2% Rule Breakdown

Quick rent-to-price ratios filter out obvious non-starters in seconds, but high property taxes or HOA dues can turn a 1.1% rule property cash-flow negative.

05 / Unlevered vs Levered Yield

Cap Rate vs Cash-on-Cash

Cap Rate measures the unlevered yield of the property itself regardless of mortgage terms, while Cash-on-Cash measures the return on your actual out-of-pocket dollars.

06 / Balloon Payoff Check

Seller Finance Balloon

Seller financing lets buyers trade a fair purchase price for flexible interest rates and down payments, provided the balloon maturity leaves ample equity for refinancing.

07 / Subject-To Entry Basis

Subject-To Mortgage Math

Taking over an existing 3.25% to 4.25% fixed-rate mortgage can create strong monthly cash flow when entry fees and arrears stay disciplined relative to equity.

08 / Stabilized Full-Duplex NOI

Duplex House Hack DSCR

Smart house-hackers underwrite a duplex twice: first for reduced monthly living cost today, and second at full two-unit market rent after moving out.

09 / 4-Plex Vacancy Buffer

4-Plex Underwriting

Four-unit properties sit at the sweet spot of residential 30-year fixed lending while spreading single-tenant vacancy across four independent rent checks.

10 / Operating Expense Ratio

NOI & 50% Rule vs Itemized

The 50% rule is a quick napkin filter, but itemized expense underwriting catches high-tax counties, coastal insurance jumps, and HOA fees before you lock earnest money.

11 / Itemized Rehab Basis

Rehab Cost per Sq Ft

Flat per-square-foot guesses miss major mechanical tickets like a $6,800 HVAC unit, a $2,800 200A panel, or a $10,000 roof. Itemizing 28 core trades protects your spread.

12 / Dual-Shock Sensitivity

Rate vs Vacancy Stress Test

Single-point spreadsheets look reassuring until rates climb 0.75% before refinance closing and a tenant moves out mid-winter. A 7x7 stress grid exposes thin deals instantly.

13 / Refinance Payback Formula

Refi Break-Even Monitor

Chasing a lower interest rate without dividing closing costs by monthly payment savings can destroy equity if you sell or refinance again before breaking even.

14 / 100% Capital Recycle Condition

BRRRR Infinite Return Math

An infinite Cash-on-Cash return happens when net cash-out refinance proceeds equal or exceed total acquisition, rehab, closing, and holding costs while the property still cash-flows.

15 / Total Flip Soft-Cost Drag

Flip Holding & Selling Costs

Most amateur flip spreadsheets underestimate soft costs by $15,000 to $30,000 because they ignore monthly hard-money carry and full exit commissions plus transfer taxes.

16 / Gross Rent Multiplier

Gross Rent Multiplier (GRM)

Gross Rent Multiplier compares asking price against annual gross scheduled rent in a single ratio, making it ideal for ranking 10 listings in under two minutes.

17 / Internal Rate of Return (NPV = 0)

5-Year Rental IRR Guide

Cash-on-Cash only captures Year-1 cash flow; 5-Year IRR captures all four wealth engines together: cash flow, principal amortization, rent growth, and net resale equity.

18 / Debt Yield vs DSCR

Debt Yield vs DSCR

While DSCR shifts with interest rates and 30-year amortization, Debt Yield measures raw collateral protection (NOI divided by loan balance) independent of rate manipulation.

19 / Break-Even Occupancy

Vacancy & Break-Even Buffer

Higher gross revenue on furnished stays carries higher turnover vacancy, utilities, and management fees. Testing 0% to 20% vacancy in one grid keeps underwriting honest.

20 / Credit Memo Core Sections

Lender One-Pager Checklist

Private lenders, DSCR brokers, and equity partners review dozens of messy spreadsheets every week. A disciplined one-page credit memo gets funded faster.