Insider Mortgage Logo
Insider Mortgage Underwriting Engine

Rental Property Investment Analyzer | 1–4 Units & ADU Calculator

Underwrite Single Family, Condos, and 2 - 4 unit properties with dynamic unit-level rent schedules, 5-year & 10-year Newton-Raphson IRR, future refinance scenarios, and California ADU value-add projections.

⭐ Featured Investor Deals — Curated by David, Rakesh & Partner Agents:
1

Property Details & Unit Rents

2-Unit Multi-Family
Unit Rent Schedule (2 Units)Values preserved when switching unit count
Total Scheduled Gross Rent
Annual Gross Scheduled Rent (GSR): $57,600/yr
$4,800 /mo
2

Acquisition & Financing

Loan Amount: $660,000
Closing + initial turn-key reserves
25% ($220,000)
15%25% Standard Investor50%
%
4.000%7.500% Default10.000%
Ready Immediately (0 mos)
0 mos (Immediate)12 mos (1 Yr)24 mos (2 Yrs)
3

Operating Expense Ratios

3.0%
5%
2.0%
Default 2.0% (CA Prop 13)
5.0%
Default 5.0% inflation
4

10-Year Growth & Exit Engine

3.0%/yr
4.0%/yr
5.0%
5

Interactive “What-If” Value-Add Modules

VIP / Full Report Feature
🔄 What-If: Future Rate-and-Term Refinance
Model a future rate-and-term or cash-out refinance once interest rates drop.
Investment Overview

535 Tam O Shanter Dr, San Marcos, CA 92069

⭐ Curated Deal · Identified by David Sider(Insider Mortgage · NMLS #254108)
“San Marcos duplex with dual income streams and multi-family CA ADU eligibility for up to 2 detached ADUs.”
Cash on Cash (COC)
-8.16%
∑ Math
-$18,779/yr on $230,000
DSCR
0.83%
∑ Math
$4,800/mo Rent ÷ $5,788/mo PITIA
Net Operating Income (NOI)
$36,598/yr
∑ Math
$55,872 EGI - $19,274 Operating Exp.
Cap Rate
4.11%
∑ Math
$36,598 on $890,000
Monthly Housing Payment Breakdown

Initial Monthly PITIA

$5,788/mo
Principal & Interest (P&I)($660,000 @ 7.5%)$4,615/mo
Property Taxes (1.25%)$917/mo
Home Insurance (0.35%)$257/mo
HOA / Association Fees$0/mo
Medium-Term Exit

5-Year Horizon Returns

Projected Year 5 Value:$1,070,655
Remaining Loan Balance:$624,475
Net Sale Proceeds (after 5% cost):$392,647
5-Yr Cumulative Cash Flow:-$82,094
Net 5-Yr Lifetime Profit: ∑ Math
$80,553
35.0% ROI
Long-Term Wealth Horizon

10-Year Horizon Returns

Projected Year 10 Value:$1,302,615
Remaining Loan Balance:$572,847
Net Sale Proceeds (after 5% cost):$664,637
10-Yr Cumulative Cash Flow:-$131,994
Net 10-Yr Lifetime Profit: ∑ Math
$302,644
131.6% ROI
5-Year & 10-Year IRR + Equity Projection Ready

Unlock Full 10-Year Pro-Forma, IRR & ADU/Refi Report

See your exact 5-year and 10-year Internal Rate of Return (IRR), net sale proceeds, and interactive ADU & Refinance scenarios.

6

Investment Underwriting Analysis

Holding cost, break-even levers, and appreciation stress test
✦ Appreciation-Dependent / Negative Cash Flow (-$1,565/mo)
1. Verdict: What It Costs to Hold
Never breaks even — ~$131,994 carried over 10 years

Cash flow stays negative through Year 10. 83% of projected gains come from appreciation, so the outcome depends on the sale price. Works only with a lower price, more down, or a value-add plan. At 0% appreciation the 10-year result is a $98,841 loss.

2. What It Would Take to Break Even on Day 1
Break-even rent$6,498/moRent needs to increase by 35% (+$1,698/mo) to cash-flow break even.
Max price for 1.00x DSCR$729,767Purchase price would need to drop from $880,000 to $729,767 (a $150,233 reduction) for rent to cover PITIA.
Down payment for 1.00x DSCR41.1% downDown payment needs to be $361,323 instead of 25% ($220,000) today.
Interest rate to break even3.73%Interest rate would need to drop from 7.50% to 3.73% to break even.
3. Stress Test: How Much Depends on Appreciation

10-year gains: appreciation $422,615, loan paydown $87,153, cash flow -$131,994, less selling & make-ready costs -$75,131. 83% of gains come from appreciation.

Annual appreciation10-yr profit10-yr IRR
4.0% (base case)$302,6447.37%
2.0% appreciation$84,2392.53%
0.0% appreciation-$98,841-3.85%
4. Value-Add Opportunities
  • Rate-Drop Refinance Upside: Enabling a Year 3 refinance at 6.25% (in Box 5) would boost 10-Year Total Profit by +$48,850 and lift 10-Year IRR from 7.37% to 8.48%.
Explore Financing Scenarios with Insider Mortgage

The right financing can change the investment.

Real estate investors have different financing needs depending on the property, ownership structure, income documentation, and investment strategy.

✓Conventional investment property financing
✓DSCR loans
✓Bank statement programs for self-employed investors
✓Financing for 2–4 unit properties
✓Cash-out refinancing for existing rental properties
✓ADU and value-add financing opportunities
Speak directly with David Sider (NMLS #254108) & Rakesh Jain (NMLS #240594 / CA DRE #01336748) at Insider Mortgage
(858) 848-5653

10-Year Annual Operating & Equity Pro-Forma Schedule

Compounding 3.0% annual rent growth & 4.0% property appreciation.

YearGross Rent
(Monthly)
Effective
Gross (EGI)
Operating
Expenses
Net Operating
Income (NOI)
Annual Debt
Service
Annual Net
Cash Flow
Monthly
Cash Flow
Property
Value
Loan
Balance
Net Equity
(After 5%)
Year 1$4,800$55,872-$19,274$36,598-$55,378-$18,779-$1,565/mo$915,200$653,916$215,524
Year 2$4,944$57,548-$19,803$37,745-$55,378-$17,633-$1,469/mo$951,808$647,359$256,858
Year 3$5,092$59,275-$20,350$38,925-$55,378-$16,453-$1,371/mo$989,880$640,294$300,092
Year 4$5,245$61,053-$20,914$40,139-$55,378-$15,239-$1,270/mo$1,029,476$632,680$345,322
Year 5$5,402$62,884-$21,496$41,388-$55,378-$13,989-$1,166/mo$1,070,655$624,475$392,647
Year 6$5,565$64,771-$22,097$42,674-$55,378-$12,703-$1,059/mo$1,113,481$615,633$442,174
Year 7$5,731$66,714-$22,717$43,997-$55,378-$11,380-$948/mo$1,158,020$606,105$494,014
Year 8$5,903$68,716-$23,357$45,359-$55,378-$10,019-$835/mo$1,204,341$595,837$548,287
Year 9$6,080$70,777-$24,018$46,759-$55,378-$8,619-$718/mo$1,252,514$584,771$605,117
Year 10$6,263$72,900-$24,701$48,200-$55,378-$7,178-$598/mo$1,302,615$572,847$664,637
Pro-Forma Term Index & Formula Definitions
∑ Tap any number below to see its step-by-step calculation
Effective Gross Income (EGI): Annual Gross Scheduled Rent across all units minus the 3.0% vacancy allowance. Represents actual collected rental income.
Operating Expenses (OpEx): Annual Property Taxes (1.25%, escalating +2%/yr), Home Insurance (0.35%, escalating +5%/yr), Monthly Maintenance Budget ( $200/mo), Property Management Fee (5% of EGI), and HOA dues. Excludes mortgage payments.
Net Operating Income (NOI): EGI − Operating Expenses. Measures the property's pure unlevered operating income before debt service.
Annual Debt Service:Total annual principal & interest (P&I) mortgage payments (Monthly P&I × 12). Subtracting Annual Debt Service from NOI yields Annual Net Cash Flow.