Brownsville Deal Analysis

Let's look at deal analysis for Brownsville, TX and for 15 Buy 10 Nomads™ with 10% Higher Rents.

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 Brownsville, Texas Nomad™ Property with 10% Higher Rents

Typical Brownsville, Texas Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$141,122
Purchase Price		$141,122
Seller Concessions	—	$0
Down Payment	5.000%	$7,056
Closing Costs	1.000%	$1,411
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$3,101
Total Invested		$11,568
Mortgage
Mortgage Amount		$134,065.90
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$94.96
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,493 $1493.42
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$538
Property Taxes	2.567%	$3,623
Property Insurance	1.419%	$2,003
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%	$21,168
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	$145,356	$149,716	$154,208	$158,834	$163,599
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$4,234	$4,361	$4,491	$4,626	$4,765
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,493	$1,538	$1,584	$1,632	$1,681
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	$1,493	$1,538	$1,584	$1,632	$1,681
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$45	$46	$48	$49	$50
Monthly Gross Operating Income	$1,449	$1,492	$1,537	$1,583	$1,630
Annual Income	1	2	3	4	5
Annual Rent	$17,921	$18,459	$19,012	$19,583	$20,170
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$17,921	$18,459	$19,012	$19,583	$20,170
Annual Vacancy Dollar	$538	$554	$570	$587	$605
Annual Gross Operating Income	$17,383	$17,905	$18,442	$18,995	$19,565
Annual Expenses	1	2	3	4	5
Property Taxes Percent	2.567%	2.567%	2.567%	2.567%	2.567%
Property Taxes Dollar	$3,623	$3,731	$3,843	$3,959	$4,077
Insurance Percent	1.419%	1.419%	1.419%	1.419%	1.419%
Insurance Dollar	$2,003	$2,063	$2,124	$2,188	$2,254
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	$1,738	$1,790	$1,844	$1,900	$1,957
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	$7,363	$7,584	$7,812	$8,046	$8,288
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$10,020	$10,321	$10,630	$10,949	$11,278
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$10,169	$10,169	$10,169	$10,169	$10,169
Principal	$1,499	$1,599	$1,706	$1,820	$1,942
Interest	$8,670	$8,570	$8,463	$8,348	$8,227
Loan Balance at End of Year	$132,567	$130,969	$129,263	$127,442	$125,500
Loan-To-Value	91.202%	87.478%	83.824%	80.236%	76.712%
Private Mortgage Insurance (PMI) Rate	0.850%	0.850%	0.850%	0.850%
Private Mortgage Insurance Dollar	$1,140	$1,140	$1,140	$1,140	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$12,788	$18,748	$24,945	$31,392	$38,099
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$1,288	-$988	-$678	-$359	$1,109
Monhtly Cash Flow	-$107	-$82	-$57	-$30	$92
Cash on Cash Return on Investment	-0.111%	-0.085%	-0.059%	-0.031%	0.096%
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