Carrollton Deal Analysis

Let's look at deal analysis for Carrollton, TX and for 32 10 20% Down Rental Properties (no Owner-Occupant).

The World's Greatest Real Estate Deal Analysis Spreadsheet™

The analysis is based on The World's Greatest Real Estate Deal Analysis Spreadsheet™ (shown above)... a free spreadsheet download you can use to analyze your own deals.

Typical 20% Down Payment Carrollton, Texas Rental Property

Typical 20% Down Payment Carrollton, Texas Rental Property
Purchase Inputs
Percents Dollars/#
ARV $372,700
Purchase Price $372,700
Seller Concessions $0
Down Payment 20.000% $74,540
Closing Costs 1.000% $3,727
Rent Ready Costs $0
Cumulative Negative Cash Flow $35,960
Total Invested $114,227
Mortgage
Mortgage Amount $298,160
Mortgage Interest Rate 7.000%
Loan Term 360
Private Mortgage Insurance 0% $0
Drop PMI LTV 0.000%
Income
Monthly Rent $2,846 $2845.50
Other Income $0
Annual Expenses
Vacancy Rate 3.000% $1,024
Property Taxes 1.858% $6,925
Property Insurance 1.419% $5,289
HOA Dues $0
Utilities $0
Other Expenses 1 $0
Other Expenses 2 $0
Maintenance 10.000%
CapEx $0
Management 0.000%
Depreciation Details
Land Value 15.000% $55,905
Property Type (C or R) R 27.5
Effective Income Tax Rate 15.000%
Property Value 1 2 3 4 5
ARV at End of Year $383,881 $395,397 $407,259 $419,477 $432,061
Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Appreciation Dollar $11,181 $11,516 $11,862 $12,218 $12,584
Monthly Income 1 2 3 4 5
Rent Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Rent $2,846 $2,931 $3,019 $3,109 $3,203
Monthly Other Income Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Other Income $0 $0 $0 $0 $0
Monthly Gross Potential Income $2,846 $2,931 $3,019 $3,109 $3,203
Vacancy Percent 3.000% 3.000% 3.000% 3.000% 3.000%
Monthly Vacancy Dollar $85 $88 $91 $93 $96
Monthly Gross Operating Income $2,760 $2,843 $2,928 $3,016 $3,107
Annual Income 1 2 3 4 5
Annual Rent $34,146 $35,170 $36,225 $37,312 $38,432
Annual Other Income $0 $0 $0 $0 $0
Annual Gross Potential Income $34,146 $35,170 $36,225 $37,312 $38,432
Annual Vacancy Dollar $1,024 $1,055 $1,087 $1,119 $1,153
Annual Gross Operating Income $33,122 $34,115 $35,139 $36,193 $37,279
Annual Expenses 1 2 3 4 5
Property Taxes Percent 1.858% 1.858% 1.858% 1.858% 1.858%
Property Taxes Dollar $6,925 $7,133 $7,346 $7,567 $7,794
Insurance Percent 1.419% 1.419% 1.419% 1.419% 1.419%
Insurance Dollar $5,289 $5,447 $5,611 $5,779 $5,952
HOA Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
HOA Dues Dollar $0 $0 $0 $0 $0
Utilities Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Utilities Dollar $0 $0 $0 $0 $0
Other Expense 1 Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Other Expense 1 Dollar $0 $0 $0 $0 $0
Other Expense 2 Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Other Expense 2 Dollar $0 $0 $0 $0 $0
Maintenance Percent 10.000% 10.000% 10.000% 10.000% 10.000%
Maintenance Dollar $3,312 $3,412 $3,514 $3,619 $3,728
CapEx Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
CapEx Dollar $0 $0 $0 $0 $0
Property Management Percent 0.000% 0.000% 0.000% 0.000% 0.000%
Property Management Dollar $0 $0 $0 $0 $0
Annual Operating Expenses $15,526 $15,991 $16,471 $16,965 $17,474
Net Operating Income 1 2 3 4 5
Net Operating Income (NOI) $17,596 $18,124 $18,668 $19,228 $19,805
Mortgage 1 2 3 4 5
Total Annual P&I Payments $23,804 $23,804 $23,804 $23,804 $23,804
Principal $3,029 $3,248 $3,483 $3,734 $4,004
Interest $20,775 $20,556 $20,322 $20,070 $19,800
Loan Balance at End of Year $295,131 $291,883 $288,401 $284,667 $280,662
Loan-To-Value 76.881% 73.820% 70.815% 67.862% 64.959%
Private Mortgage Insurance (PMI) Rate 0.000% 0.000% 0.000% 0.000% 0.000%
Private Mortgage Insurance Dollar $0 $0 $0 $0 $0
Equity 1 2 3 4 5
ARV - Loan Balance at End of Year $88,750 $103,514 $118,858 $134,810 $151,399
Cash Flow 1 2 3 4 5
Annual Cash Flow -$6,208 -$5,680 -$5,136 -$4,576 -$3,999
Monhtly Cash Flow -$517 -$473 -$428 -$381 -$333
Cash on Cash Return on Investment -0.054% -0.050% -0.045% -0.040% -0.035%
Cap Rate
DSCR 0.00 0.00 0.00 0.00 0.00
Negative Cash Flow $0 $0 $0 $0 $0
Cumulative Negative Cash Flow $0 $0 $0 $0 $0