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