DYDealYields

Rental Property Analysis

4212 Crestline Avenue, Tampa, FL 33611

Buy & Hold Rental

Purchase Price
$249,900
ARV $335,000 after rehab
Monthly Cash Flow
$352/mo
before taxes, year 1
Cap Rate
7.53%
on purchase price
20-yr IRR
13.0%
incl. sale proceeds

Deal Structure

Total capital required and how it's financed. Adjust any input in the wizard and every figure updates instantly.

Capital Required
Purchase price$249,900
Closing costs$5,500
Rehab budget$24,000
Total project cost$279,400
Financed− $187,425
Total cash required$91,975
Financing — 30-yr Amortized, 75% LTV
Loan amount$187,425
Down payment (25%)$62,475
Interest rate6.75%
Monthly payment (P&I)$1,216
Debt coverage ratio1.29
Equity created by rehab$61,100

Year-1 Operating Analysis

Income, expenses, and debt service for the first stabilized year.

Income & Cash Flow
Gross scheduled rent$28,740
Vacancy (5%)− $1,437
Property tax− $2,990
Insurance− $1,720
Management (8%)− $2,184
Repairs & maintenance− $1,600
Net operating income$18,809
Debt service− $14,588
Cash flow before taxes$4,221
Where the Income Goes
GOI$27,303Cash flow$4,221 · 15%Debt service$14,588 · 53%Taxes & insurance$4,710 · 17%Mgmt & upkeep$3,784 · 14%

Return Metrics

Cash-on-Cash
4.59%
year-1 CFBT ÷ cash in
NPV @ 8%
$90,060
20-yr hold incl. sale
Gross Rent Multiplier
8.7
price ÷ annual rent
Operating Expense Ratio
31.1%
expenses ÷ GOI
Break-even Ratio
84.5%
(expenses + debt) ÷ GOI
Loan-to-Cost
67.1%
loan ÷ total project cost

Cash Flow Growth

Annual cash flow before taxes with rent growing 2% and expenses 2% annually. Hover any bar for the exact figure.

$8k$6k$4k$2k$0kY1Y2Y3Y4Y5Y6Y7Y8Y9Y10$7,891

Equity vs. Debt Over the Hold

Investor equity builds three ways — the rehab lift at purchase, principal paydown, and 3.5% annual appreciation — while the loan balance amortizes down.

$700k$525k$350k$175k$0kYr 0Yr 5Yr 10Yr 15Yr 20$560,710 equity
Investor equityLoan balance

10-Year Forecast

Yr 1Yr 2Yr 3Yr 4Yr 5Yr 6Yr 7Yr 8Yr 9Yr 10
Gross rent$28,740$29,315$29,901$30,499$31,109$31,731$32,366$33,013$33,673$34,347
Operating income$27,303$27,849$28,406$28,974$29,554$30,145$30,748$31,363$31,990$32,630
Expenses$8,494$8,664$8,837$9,014$9,194$9,378$9,566$9,757$9,952$10,151
NOI$18,809$19,185$19,569$19,960$20,359$20,766$21,182$21,605$22,037$22,478
Debt service$14,588$14,588$14,588$14,588$14,588$14,588$14,588$14,588$14,588$14,588
Cash flow$4,221$4,597$4,981$5,372$5,772$6,179$6,594$7,018$7,450$7,891
Loan balance$185,428$183,291$181,006$178,561$175,947$173,150$170,158$166,959$163,536$159,875
Property value$346,725$358,860$371,420$384,420$397,875$411,801$426,214$441,131$456,571$472,551