Eric Lawrence Frazier Advisory Services seal
Real Estate Compass · Property financing

Ways to finance your property

Current property · $700,000 · 10-year projection

Step 3 · Scenarios

Same property, ways to buy it

Uses your property, rents and expenses from Inputs. Owner-occupied rates start at your base rate (7%) plus each program's adjustment.

Side-by-side comparison

Metric3% owner-occ.3.5% FHA5% owner-occ.10% owner-occ.20% investor25% investor
Eligibility2 gap(s)2 gap(s)1 gap(s)1 gap(s)1 gap(s)1 gap(s)
ProgramConventionalFHAConventionalConventionalInvestorInvestor
Interest rate7.000%6.750%7.000%7.000%7.750%7.750%
Down payment$21,000$24,500$35,000$70,000$140,000$175,000
Closing costs$21,000$24,500$21,000$21,000$21,000$21,000
Upfront MI (financed)$0$11,821$0$0$0$0
Cash to close$42,000$49,000$56,000$91,000$161,000$196,000
Loan amount$679,000$687,321$665,000$630,000$560,000$525,000
Principal & interest /mo$4,517$4,458$4,424$4,191$4,012$3,761
Mortgage insurance /mo$509$315$499$315$0$0
PITI /mo$6,403$6,150$6,300$5,883$5,389$5,138
Total interest (life of loan)$947,265$917,542$927,734$878,906$884,287$829,019
Monthly cash flow-$1,511-$1,257-$1,407-$991$454$705
Net housing cost /mo (owner)$1,511$1,257$1,407$991——
Cash-on-cash-43.17%-30.79%-30.15%-13.06%3.38%4.31%
DSCR0.89x0.94x0.91x0.99x1.11x1.19x
IRR (10 yr)11.47%12.56%11.15%11.53%15.35%14.41%
Back-end DTI16.9%14.8%16.0%12.6%4.2%4.2%

Ratios used in this comparison

Open any term for its meaning, calculation, and how to read the result.

PITI

The core monthly housing payment: principal, interest, property taxes, and insurance.

Calculation: Principal + interest + taxes + insurance.

How to read it: Mortgage insurance, HOA, maintenance, and utilities may be additional.

Cash-on-cash return

The year-one cash profit earned by the actual cash you invest.

Calculation: Annual cash flow ÷ cash invested.

How to read it: A negative result means the deal consumes cash after debt service.

Debt-service coverage ratio (DSCR)

How many times property income covers annual loan payments.

Calculation: NOI ÷ annual debt service.

How to read it: 1.00 means exact coverage; many lenders look for about 1.20–1.25 or more.

Internal rate of return (IRR)

The annualized return over the full hold, including cash flow, loan paydown, and sale proceeds.

Calculation: Rate that makes all dated cash flows equal today.

How to read it: It is very sensitive to appreciation and the assumed sale price.

Back-end debt-to-income (DTI)

All monthly debts, including housing and allowed rent credit, compared with gross income.

Calculation: Net monthly debts ÷ gross monthly income.

How to read it: Lenders use this broader ratio for qualification limits.

Take-home housing & debt ratio

The share of real income committed before living expenses or savings.

Calculation: (Housing + required monthly debts) ÷ (take-home pay + eligible net rental income) × 100.

How to read it: This is not the lender's gross-income DTI. Use the full budget to judge what remains.

Unallocated cash ratio

The share of real income remaining after the complete budget and savings.

Calculation: (Real income − housing − debts − living expenses − paycheck savings − additional goals) ÷ real income × 100.

How to read it: Negative is a shortfall; zero is fully allocated. Positive goes to the emergency gap before becoming discretionary.

Your real-life affordability

Budget incomplete

Bank approval is separate. Your emergency fund stays untouched after purchase.

Lender DTI · gross income
15.75%
Take-home housing & debt ratio
48.10%
Unallocated cash ratio
—
Take-home pay / month
$9,000
Net rental income / month
$5,064
Current monthly budget
$4,400
Post-purchase monthly budget
$10,664
Pay yourself first · 10%
$900
Planned goal savings / month
$0
Unallocated cash before emergency top-up
—
Surplus directed to emergency fund
$3,399
Spendable remainder
—
Protected emergency fund
$0
Six-month emergency target
$63,987
Emergency shortfall
$63,987
Purchase funds available
$0
Purchase + moving + furnishings needed
$45,500
Itemized monthly expenses & savings
Previous unitemized expenses
$3,000

Emergency target = 6 × (housing + required debts + living expenses + 10% or higher paycheck savings + planned goals). Emergency top-ups are excluded.

Tenant rent $6,500 → after vacancy $6,175 → less management $494, maintenance $309 and CapEx $309. Property payment and owner-paid utilities $6,264 are counted once in housing expenses.

FHA · Conventional · VA · USDA

Same property, four loan types. Edit any assumption — these are typical starting points, not lender quotes.

Slides every loan's rate up or down together, so you can see how a rate change moves each option's payment, lifetime interest, and whether it still fits your income and budget.

Rule of thumb: set aside about 1% of the price per year for repairs (≈ $583/mo here). Utilities = whatever tenants don't pay (water, trash, common-area power, your own unit).

Cash-to-close assumptions

Earnest money is paid when your offer is accepted and counts toward what you owe at closing. Seller concessions and lender credits can only pay closing costs and prepaids — never the down payment — so they're capped at those amounts. Typical seller concession limits: FHA 6%, USDA 6%, VA 4%, Conventional 3% (under 10% down) to 6%. Lender credits usually come with a slightly higher rate.

Lenders collect prepaid taxes and insurance up front to seed your escrow account, and many require reserves — savings left over after closing. Typical: 6 months of taxes, first year's insurance plus a small escrow cushion (≈14 months), and 2 months of payments in reserve.

Comparison summary (printable)

Price $700,000 · base rate 7.000% · 30-yr term · 11/22/2026

ItemFHAConventionalVAUSDA
Down payment %3.5%5%0%0%
Rate7.000%7.125%6.750%7.000%
Down payment$24,500$35,000$0$0
Closing costs$21,000$21,000$21,000$21,000
Prepaid taxes$5,635$5,635$5,635$5,635
Prepaid insurance$6,125$6,125$6,125$6,125
Gross cash to close$57,260$67,760$32,760$32,760
Less earnest money−$0−$0−$0−$0
Less seller concessions−$0−$0−$0−$0
Less lender credits−$0−$0−$0−$0
Cash due at closing$57,260$67,760$32,760$32,760
Estimated reserves$12,529$12,268$12,029$12,573
Total cash needed$69,789$80,028$44,789$45,333
Upfront fee (financed)$11,821$0$15,050$7,000
Mortgage insurance /mo$315$277$0$206
All-in monthly$7,097$6,967$6,847$7,120

Assumptions: prepaid taxes 6 mo, prepaid insurance 14 mo, reserves 2 mo of payment, earnest / concessions / lender credits — FHA $0 / $0 / $0, Conventional $0 / $0 / $0, VA $0 / $0 / $0 (credits capped at closing costs + prepaids). FHA: 1.75% upfront MIP added to loan + 0.55%/yr MIP; lasts the life of the loan when under 10% down. Conventional: PMI ~0.5%/yr while loan is above 80% of value; drops off at 78%. 2–4 units usually need 15–25% down. VA: No monthly mortgage insurance. 2.15% funding fee (first use, 0% down) added to loan; waived for many disabled veterans. Eligible service members/veterans only. USDA: USDA Guaranteed: 0% down, illustrative 1% financed upfront guarantee fee + 0.35% annual fee. Primary-residence single-family homes only; eligible rural address and household income limits must be verified by the lender. No investment or 2–4 unit properties. Educational estimates only — not a loan quote.

What-if: cash due at closing

Each row changes one thing from your current setup on every loan card. Green = less cash needed than now.

ScenarioFHA due · monthlyConventional due · monthlyVA due · monthlyUSDA due · monthly
Current$57,260 (+$0) · $7,097$67,760 (+$0) · $6,967$32,760 (+$0) · $6,847$32,760 (+$0) · $7,120
Down −5 pts$32,760 (-$24,500) · $7,275$32,760 (-$35,000) · $7,217$32,760 (+$0) · $6,847$32,760 (+$0) · $7,120
Down +5 pts$92,260 (+$35,000) · $6,844$102,760 (+$35,000) · $6,717$67,760 (+$35,000) · $6,616$67,760 (+$35,000) · $6,874
Concessions +$5,000$52,260 (-$5,000) · $7,097$62,760 (-$5,000) · $6,967$27,760 (-$5,000) · $6,847$27,760 (-$5,000) · $7,120
Lender credit +$2,500$54,760 (-$2,500) · $7,097$65,260 (-$2,500) · $6,967$30,260 (-$2,500) · $6,847$30,260 (-$2,500) · $7,120
Concessions + credit$49,760 (-$7,500) · $7,097$60,260 (-$7,500) · $6,967$25,260 (-$7,500) · $6,847$25,260 (-$7,500) · $7,120

Ranked by total cash needed = cash due at closing + earnest money + reserves. This is lender screening only; it does not establish real-life affordability. Protected emergency savings are never available for closing. The separate purchase balance must also cover moving and furnishings. The CSV export includes every line item, reserves, and the assumptions behind each option.

  1. #1 VA$44,789= due $32,760 + earnest $0 + reserves $12,029$32,760 purchase funds short · protected emergency $0 / $67,485 incompleteAssumes 0% down, 6.750% rate, closing 3%, 6 mo taxes + 14 mo insurance prepaid, 2 mo reserves ($6,014/mo), concessions $0, lender credit $0, upfront fee $15,050 financed. Emergency funds stay untouched; lender reserves above are not the six-month full-budget emergency target.
  2. #2 USDA$45,333= due $32,760 + earnest $0 + reserves $12,573 · $544 more than #1$32,760 purchase funds short · protected emergency $0 / $69,117 incompleteAssumes 0% down, 7.000% rate, closing 3%, 6 mo taxes + 14 mo insurance prepaid, 2 mo reserves ($6,287/mo), concessions $0, lender credit $0, upfront fee $7,000 financed. Emergency funds stay untouched; lender reserves above are not the six-month full-budget emergency target.
  3. #3 FHA$69,789= due $57,260 + earnest $0 + reserves $12,529 · $25,000 more than #1$57,260 purchase funds short · protected emergency $0 / $68,985 incompleteAssumes 3.5% down, 7.000% rate, closing 3%, 6 mo taxes + 14 mo insurance prepaid, 2 mo reserves ($6,264/mo), concessions $0, lender credit $0, upfront fee $11,821 financed. Emergency funds stay untouched; lender reserves above are not the six-month full-budget emergency target.
  4. #4 Conventional$80,028= due $67,760 + earnest $0 + reserves $12,268 · $35,239 more than #1$67,760 purchase funds short · protected emergency $0 / $68,202 incompleteAssumes 5% down, 7.125% rate, closing 3%, 6 mo taxes + 14 mo insurance prepaid, 2 mo reserves ($6,134/mo), concessions $0, lender credit $0. Emergency funds stay untouched; lender reserves above are not the six-month full-budget emergency target.

FHA

Down payment
$24,500
Closing costs
$21,000
Prepaid taxes
$5,635
Prepaid insurance
$6,125
Gross cash to close
$57,260
Less: earnest money (paid earlier)
−$0
Less: seller concessions
−$0
Less: lender credits
−$0
Cash due at closing
$57,260
Lender reserves · not emergency target
$12,529
Total cash needed (incl. earnest + reserves)
$69,789
Upfront fee (financed)
$11,821
Loan amount
$687,321
Principal & interest
$4,573
Taxes + insurance
$1,377
Mortgage insurance
$315
HOA
$0
Maintenance + utilities
$833
All-in monthly
$7,097
Rate · lifetime interest
7.000% · $958,874

Review budget and protected savings · monthly remainder $2,566 · emergency target $68,985

✓ Lender DTI · gross income ≈ 56.4% (limit ≈ 56.9%)

How this total is calculated
  1. Down payment = price $700,000 × 3.5% = $24,500.
  2. Closing costs = price × 3% = $21,000 (lender, title, appraisal, recording).
  3. Prepaid taxes = $939/mo × 6 mo = $5,635.
  4. Prepaid insurance = $438/mo × 14 mo = $6,125.
  5. Gross cash to close = sum of 1–4 = $57,260.
  6. Seller concessions −$0 — limited to closing costs + prepaids ($32,760).
  7. Lender credits −$0 — limited to whatever closing costs remain after concessions.
  8. Earnest money −$0 — already paid when your offer was accepted, so it counts toward the total.
  9. Cash due at closing = $57,260 − $0 = $57,260.
  10. Reserves = monthly payment $6,264 × 2 mo = $12,529 (stays in your account).
  11. Total cash needed = due at closing + earnest + reserves = $69,789.
  12. Upfront fee $11,821 is added to the loan, not paid in cash.

1.75% upfront MIP added to loan + 0.55%/yr MIP; lasts the life of the loan when under 10% down.

Conventional

Down payment
$35,000
Closing costs
$21,000
Prepaid taxes
$5,635
Prepaid insurance
$6,125
Gross cash to close
$67,760
Less: earnest money (paid earlier)
−$0
Less: seller concessions
−$0
Less: lender credits
−$0
Cash due at closing
$67,760
Lender reserves · not emergency target
$12,268
Total cash needed (incl. earnest + reserves)
$80,028
Upfront fee (financed)
$0
Loan amount
$665,000
Principal & interest
$4,480
Taxes + insurance
$1,377
Mortgage insurance
$277
HOA
$0
Maintenance + utilities
$833
All-in monthly
$6,967
Rate · lifetime interest
7.125% · $947,882

Review budget and protected savings · monthly remainder $2,697 · emergency target $68,202

✗ Lender DTI · gross income ≈ 55.3% (limit ≈ 45%)

How this total is calculated
  1. Down payment = price $700,000 × 5% = $35,000.
  2. Closing costs = price × 3% = $21,000 (lender, title, appraisal, recording).
  3. Prepaid taxes = $939/mo × 6 mo = $5,635.
  4. Prepaid insurance = $438/mo × 14 mo = $6,125.
  5. Gross cash to close = sum of 1–4 = $67,760.
  6. Seller concessions −$0 — limited to closing costs + prepaids ($32,760).
  7. Lender credits −$0 — limited to whatever closing costs remain after concessions.
  8. Earnest money −$0 — already paid when your offer was accepted, so it counts toward the total.
  9. Cash due at closing = $67,760 − $0 = $67,760.
  10. Reserves = monthly payment $6,134 × 2 mo = $12,268 (stays in your account).
  11. Total cash needed = due at closing + earnest + reserves = $80,028.

PMI ~0.5%/yr while loan is above 80% of value; drops off at 78%. 2–4 units usually need 15–25% down.

VA

Down payment
$0
Closing costs
$21,000
Prepaid taxes
$5,635
Prepaid insurance
$6,125
Gross cash to close
$32,760
Less: earnest money (paid earlier)
−$0
Less: seller concessions
−$0
Less: lender credits
−$0
Cash due at closing
$32,760
Lender reserves · not emergency target
$12,029
Total cash needed (incl. earnest + reserves)
$44,789
Upfront fee (financed)
$15,050
Loan amount
$715,050
Principal & interest
$4,638
Taxes + insurance
$1,377
Mortgage insurance
$0
HOA
$0
Maintenance + utilities
$833
All-in monthly
$6,847
Rate · lifetime interest
6.750% · $954,558

Review budget and protected savings · monthly remainder $2,816 · emergency target $67,485

✗ Lender DTI · gross income ≈ 54.3% (limit ≈ 45%)

How this total is calculated
  1. Down payment = price $700,000 × 0% = $0.
  2. Closing costs = price × 3% = $21,000 (lender, title, appraisal, recording).
  3. Prepaid taxes = $939/mo × 6 mo = $5,635.
  4. Prepaid insurance = $438/mo × 14 mo = $6,125.
  5. Gross cash to close = sum of 1–4 = $32,760.
  6. Seller concessions −$0 — limited to closing costs + prepaids ($32,760).
  7. Lender credits −$0 — limited to whatever closing costs remain after concessions.
  8. Earnest money −$0 — already paid when your offer was accepted, so it counts toward the total.
  9. Cash due at closing = $32,760 − $0 = $32,760.
  10. Reserves = monthly payment $6,014 × 2 mo = $12,029 (stays in your account).
  11. Total cash needed = due at closing + earnest + reserves = $44,789.
  12. Upfront fee $15,050 is added to the loan, not paid in cash.

No monthly mortgage insurance. 2.15% funding fee (first use, 0% down) added to loan; waived for many disabled veterans. Eligible service members/veterans only.

USDA

Not eligible for this occupancy or unit count. USDA requires a primary-residence single-family home.

Down payment
$0
Closing costs
$21,000
Prepaid taxes
$5,635
Prepaid insurance
$6,125
Gross cash to close
$32,760
Less: earnest money (paid earlier)
−$0
Less: seller concessions
−$0
Less: lender credits
−$0
Cash due at closing
$32,760
Lender reserves · not emergency target
$12,573
Total cash needed (incl. earnest + reserves)
$45,333
Upfront fee (financed)
$7,000
Loan amount
$707,000
Principal & interest
$4,704
Taxes + insurance
$1,377
Mortgage insurance
$206
HOA
$0
Maintenance + utilities
$833
All-in monthly
$7,120
Rate · lifetime interest
7.000% · $986,328

Review budget and protected savings · monthly remainder $2,544 · emergency target $69,117

✗ Lender DTI · gross income ≈ 56.6% (limit ≈ 45%)

How this total is calculated
  1. Down payment = price $700,000 × 0% = $0.
  2. Closing costs = price × 3% = $21,000 (lender, title, appraisal, recording).
  3. Prepaid taxes = $939/mo × 6 mo = $5,635.
  4. Prepaid insurance = $438/mo × 14 mo = $6,125.
  5. Gross cash to close = sum of 1–4 = $32,760.
  6. Seller concessions −$0 — limited to closing costs + prepaids ($32,760).
  7. Lender credits −$0 — limited to whatever closing costs remain after concessions.
  8. Earnest money −$0 — already paid when your offer was accepted, so it counts toward the total.
  9. Cash due at closing = $32,760 − $0 = $32,760.
  10. Reserves = monthly payment $6,287 × 2 mo = $12,573 (stays in your account).
  11. Total cash needed = due at closing + earnest + reserves = $45,333.
  12. Upfront fee $7,000 is added to the loan, not paid in cash.

USDA Guaranteed: 0% down, illustrative 1% financed upfront guarantee fee + 0.35% annual fee. Primary-residence single-family homes only; eligible rural address and household income limits must be verified by the lender. No investment or 2–4 unit properties.

Save this buyer scenario

FHA loan over time

Early payments are mostly interest; over time more goes to principal. Equity = estimated home value (growing at CPI + appreciation spread) minus what you still owe.

YearPrincipal paidInterest paidBalance leftEst. valueYour equity
1$6,982$47,891$680,339$724,500$44,161
5$9,230$45,643$646,986$831,380$184,394
10$13,085$41,788$589,807$987,419$397,612
15$18,550$36,323$508,747$1,172,744$663,997
20$26,297$28,576$393,836$1,392,852$999,017
25$37,279$17,594$230,934$1,654,271$1,423,338
30$52,848$2,025$0$1,964,756$1,964,756

Loan program screening

Each scenario is checked against its program's rules. Edit the rules below to match your lender — limits shown are 2025 national baselines; high-cost counties are higher.

3% owner-occ.
Not yet
  • Credit score: 700 vs. minimum 620
  • Down payment: 3% vs. minimum 5% (3% conventional is 1-unit only)
    → Increase down payment to at least 5% (35,000 dollars) or switch program.
  • Debt-to-income: 16.9% vs. max 50%
  • Cash to close + reserves: Have $40,000, need $106,820 (6 mo. full-budget emergency savings)
    → Save another $66,820, negotiate seller credits, or use gift funds where allowed.
  • Loan limit: Loan $679,000 vs. 4-unit limit $1,551,250
3.5% FHA
Not yet
  • Credit score: 700 vs. minimum 580
  • Down payment: 3.5% vs. minimum 3.5%
  • Debt-to-income: 14.8% vs. max 56.9%
  • Cash to close + reserves: Have $40,000, need $112,298 (6 mo. full-budget emergency savings)
    → Save another $72,298, negotiate seller credits, or use gift funds where allowed.
  • Loan limit: Loan $675,500 vs. 4-unit limit $1,008,300
  • FHA self-sufficiency: 75% of rents ÷ PITI = 0.79 (need ≥ 1.00)
    → Need $700/mo more total rent, or a lower price/payment.
5% owner-occ.
Not yet
  • Credit score: 700 vs. minimum 620
  • Down payment: 5% vs. minimum 5% (3% conventional is 1-unit only)
  • Debt-to-income: 16.0% vs. max 50%
  • Cash to close + reserves: Have $40,000, need $120,198 (6 mo. full-budget emergency savings)
    → Save another $80,198, negotiate seller credits, or use gift funds where allowed.
  • Loan limit: Loan $665,000 vs. 4-unit limit $1,551,250
10% owner-occ.
Not yet
  • Credit score: 700 vs. minimum 620
  • Down payment: 10% vs. minimum 5% (3% conventional is 1-unit only)
  • Debt-to-income: 12.6% vs. max 50%
  • Cash to close + reserves: Have $40,000, need $152,698 (6 mo. full-budget emergency savings)
    → Save another $112,698, negotiate seller credits, or use gift funds where allowed.
  • Loan limit: Loan $630,000 vs. 4-unit limit $1,551,250
20% investor
Not yet
  • Credit score: 700 vs. minimum 680
  • Down payment: 20% vs. minimum 20%
  • Debt-to-income: 4.2% vs. max 45%
  • Cash to close + reserves: Have $40,000, need $187,400 (6 mo. full-budget emergency savings)
    → Save another $147,400, negotiate seller credits, or use gift funds where allowed.
  • Loan limit: Loan $560,000 vs. 4-unit limit $1,551,250
  • Rent coverage (DSCR): Rent ÷ PITI = 1.39 (need ≥ 1)
25% investor
Not yet
  • Credit score: 700 vs. minimum 680
  • Down payment: 25% vs. minimum 20%
  • Debt-to-income: 4.2% vs. max 45%
  • Cash to close + reserves: Have $40,000, need $222,400 (6 mo. full-budget emergency savings)
    → Save another $182,400, negotiate seller credits, or use gift funds where allowed.
  • Loan limit: Loan $525,000 vs. 4-unit limit $1,551,250
  • Rent coverage (DSCR): Rent ÷ PITI = 1.46 (need ≥ 1)
ProgramMin down %Min creditMax DTI %Reserves (mo)Upfront MI %MI <10% downMI 10–19%Closing %Rate adj.Min DSCRLimit (your units)
FHA (owner-occupied)
Conventional (owner-occupied)
Investor (non-owner-occupied)

Sensitivity analysis

Rental cash flow and returns under stress.

Stress3% owner-occ.3.5% FHA5% owner-occ.10% owner-occ.20% investor25% investor
Base case
-$1,511/mo
IRR 11.5%
-$1,257/mo
IRR 12.6%
-$1,407/mo
IRR 11.1%
-$991/mo
IRR 11.5%
$454/mo
IRR 15.4%
$705/mo
IRR 14.4%
Rate +1%
-$1,976/mo
IRR 7.0%
-$1,723/mo
IRR 8.1%
-$1,862/mo
IRR 7.2%
-$1,422/mo
IRR 8.4%
$60/mo
IRR 13.2%
$336/mo
IRR 12.6%
Rate +2%
-$2,457/mo
IRR 2.8%
-$2,206/mo
IRR 3.8%
-$2,334/mo
IRR 3.3%
-$1,868/mo
IRR 5.3%
-$345/mo
IRR 11.0%
-$45/mo
IRR 10.8%
Vacancy 10%
-$1,768/mo
IRR 9.0%
-$1,515/mo
IRR 10.1%
-$1,665/mo
IRR 8.9%
-$1,248/mo
IRR 9.7%
$146/mo
IRR 13.7%
$397/mo
IRR 12.9%
Maintenance +5 pts
-$1,867/mo
IRR 8.1%
-$1,613/mo
IRR 9.2%
-$1,763/mo
IRR 8.1%
-$1,347/mo
IRR 9.0%
$98/mo
IRR 13.4%
$348/mo
IRR 12.7%
Rent growth −2 pts
-$1,511/mo
IRR 8.0%
-$1,257/mo
IRR 9.2%
-$1,407/mo
IRR 8.0%
-$991/mo
IRR 8.9%
$454/mo
IRR 13.1%
$705/mo
IRR 12.4%
All stresses
-$2,571/mo
IRR -0.9%
-$2,318/mo
IRR 0.2%
-$2,457/mo
IRR -0.2%
-$2,017/mo
IRR 2.0%
-$585/mo
IRR 7.6%
-$309/mo
IRR 7.8%

Amortization schedule

How each payment splits between interest and principal, and how equity builds as the loan shrinks and the property appreciates.

YearPaymentsPrincipalInterestBalanceValueEquityEquity %
1$53,495$7,325$46,170$679,996$724,500$44,5046.1%
2$53,495$7,835$45,660$672,161$749,857$77,69710.4%
3$53,495$8,381$45,115$663,780$776,103$112,32214.5%
4$53,495$8,964$44,531$654,816$803,266$148,45018.5%
5$53,495$9,588$43,907$645,228$831,380$186,15322.4%
6$53,495$10,256$43,239$634,972$860,479$225,50726.2%
7$53,495$10,970$42,525$624,002$890,595$266,59429.9%
8$53,495$11,734$41,762$612,268$921,766$309,49933.6%
9$53,495$12,551$40,944$599,717$954,028$354,31137.1%
10$53,495$13,425$40,071$586,292$987,419$401,12740.6%
11$53,495$14,360$39,136$571,932$1,021,979$450,04644.0%
12$53,495$15,359$38,136$556,573$1,057,748$501,17547.4%
13$53,495$16,429$37,067$540,144$1,094,769$554,62550.7%
14$53,495$17,573$35,923$522,571$1,133,086$610,51553.9%
15$53,495$18,796$34,699$503,775$1,172,744$668,96957.0%
16$53,495$20,105$33,390$483,670$1,213,790$730,12060.2%
17$53,495$21,505$31,990$462,165$1,256,273$794,10863.2%
18$53,495$23,002$30,493$439,163$1,300,242$861,08066.2%
19$53,495$24,604$28,892$414,559$1,345,751$931,19269.2%
20$53,495$26,317$27,178$388,242$1,392,852$1,004,61072.1%
21$53,495$28,149$25,346$360,092$1,441,602$1,081,51075.0%
22$53,495$30,109$23,386$329,983$1,492,058$1,162,07577.9%
23$53,495$32,206$21,290$297,777$1,544,280$1,246,50380.7%
24$53,495$34,448$19,047$263,329$1,598,330$1,335,00183.5%
25$53,495$36,847$16,649$226,482$1,654,271$1,427,78986.3%
26$53,495$39,412$14,083$187,070$1,712,171$1,525,10189.1%
27$53,495$42,157$11,339$144,913$1,772,097$1,627,18491.8%
28$53,495$45,092$8,404$99,821$1,834,120$1,734,29994.6%
29$53,495$48,232$5,264$51,590$1,898,315$1,846,72597.3%
30$53,495$51,590$1,906$0$1,964,756$1,964,756100.0%

Year-by-year exit analysis

If you sold at the end of each year: sale price minus selling costs and loan payoff, plus cash flow collected along the way.

Sell in yearSale priceSelling costsLoan payoffNet proceedsEquityCum. cash flowTotal profitMultipleAnnualized
1$724,500($43,470)($520,392)$160,638$204,108$8,456-$26,9060.86x-13.7%
2$749,857($44,991)($515,414)$189,452$234,443$18,520$11,9721.06x3.0%
3$776,103($46,566)($510,036)$219,500$266,066$30,239$53,7391.27x8.4%
4$803,266($48,196)($504,227)$250,843$299,039$43,665$98,5081.50x10.7%
5$831,380($49,883)($497,951)$283,547$333,430$58,847$146,3941.75x11.8%
6$860,479($51,629)($491,170)$317,680$369,308$75,838$197,5182.01x12.3%
7$890,595($53,436)($483,846)$353,314$406,750$94,694$252,0082.29x12.5%
8$921,766($55,306)($475,932)$390,528$445,834$115,469$309,9962.58x12.6%
9$954,028($57,242)($467,384)$429,403$486,644$138,221$371,6232.90x12.5%
10$987,419($59,245)($458,149)$470,025$529,271$163,010$437,0353.23x12.4%

Change the projection length with “Hold period” on the Inputs page (10 years now).

Refinance analyzer

Compare keeping each scenario's original loan with refinancing later. New loan = remaining balance + refinance costs. Mortgage insurance drops if the new loan is 80% of value or less.

Metric3% owner-occ.3.5% FHA5% owner-occ.10% owner-occ.20% investor25% investor
Current rate7.000%6.750%7.000%7.000%7.750%7.750%
Balance at refinance$656,776$663,780$643,234$609,380$544,039$510,036
Est. value then$776,103$776,103$776,103$776,103$776,103$776,103
Loan-to-value84.6%85.5%82.9%78.5%70.1%65.7%
Refinance costs$16,419$16,595$16,081$15,234$13,601$12,751
Current P&I + MI /mo$5,027$4,773$4,923$4,506$4,012$3,761
New P&I + MI /mo$4,545$4,394$4,452$4,060$3,343$3,134
Monthly savings$481$379$471$447$669$627
Break-even35 mo44 mo35 mo35 mo21 mo21 mo
Remaining payments: keep$1,628,636$1,546,444$1,595,056$1,460,075$1,299,858$1,218,617
Total payments: refinance$1,636,343$1,581,917$1,602,604$1,461,556$1,203,600$1,128,375
Long-term savings-$7,707-$35,473-$7,548-$1,481$96,259$90,242

Restarting a 30-year term can lower payments but raise total interest — compare the long-term line, not just the monthly one.

Tax-impact estimate (optional)

A rough year-1 estimate. Rental units can deduct expenses, interest and depreciation; your own unit's mortgage interest and property tax only help if you itemize above the standard deduction.

Year 13% owner-occ.3.5% FHA5% owner-occ.10% owner-occ.20% investor25% investor
Rental share of building75%75%75%75%100%100%
Rental income$74,100$74,100$74,100$74,100$85,500$85,500
Rental expenses($23,933)($23,933)($23,933)($23,933)($31,910)($31,910)
Mortgage interest (rental share)($35,484)($34,628)($34,752)($32,923)($43,228)($40,526)
Depreciation (27.5 yr)($15,845)($15,941)($15,845)($15,845)($21,127)($21,127)
Taxable rental income-$5,745-$3,236-$4,919-$1,436-$10,765-$8,063
Tax on rental (− = savings)-$1,264-$712-$1,082-$316-$2,368-$1,774
Personal itemized deductions$14,645$14,360$14,402$13,792$0$0
Benefit from itemizing$0$0$0$0$0$0
Net tax effect$1,264$712$1,082$316$2,368$1,774
After-tax cash flow /mo-$1,405-$1,198-$1,317-$964$651$852
  • Not tax advice. Uses one flat marginal rate and ignores state tax, AMT, and the 3.8% NIIT.
  • Rental losses are usually “passive”: up to $25,000 may offset wages if income is under $100k (phased out by $150k); otherwise losses carry forward.
  • Depreciation is recaptured (up to 25%) when you sell; this estimate does not include sale-year taxes or capital gains.
  • Owner-occupants may exclude gain on their own unit's share if they meet the 2-of-5-year rule.
Real Estate CompassEric Lawrence Frazier Advisory Services · Financial ToolsEducational estimate only — not a loan approval, tax, legal or financial advice.