Irving Deal Analysis

Let's look at deal analysis for Irving, 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 Irving, Texas Nomad™ Property with 10% Higher Rents

Typical Irving, Texas Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$297,957
Purchase Price		$297,957
Seller Concessions	—	$0
Down Payment	5.000%	$14,898
Closing Costs	1.000%	$2,980
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$46,747
Total Invested		$64,624
Mortgage
Mortgage Amount		$283,059.15
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$200.50
Drop PMI LTV	80.000%
Income
Monthly Rent		$2,512 $2512.13
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$904
Property Taxes	2.216%	$6,603
Property Insurance	1.419%	$4,228
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%	$44,694
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	$306,896	$316,103	$325,586	$335,353	$345,414
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$8,939	$9,207	$9,483	$9,768	$10,061
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$2,512	$2,587	$2,665	$2,745	$2,827
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,512	$2,587	$2,665	$2,745	$2,827
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$75	$78	$80	$82	$85
Monthly Gross Operating Income	$2,437	$2,510	$2,585	$2,663	$2,743
Annual Income	1	2	3	4	5
Annual Rent	$30,146	$31,050	$31,981	$32,941	$33,929
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$30,146	$31,050	$31,981	$32,941	$33,929
Annual Vacancy Dollar	$904	$931	$959	$988	$1,018
Annual Gross Operating Income	$29,241	$30,118	$31,022	$31,953	$32,911
Annual Expenses	1	2	3	4	5
Property Taxes Percent	2.216%	2.216%	2.216%	2.216%	2.216%
Property Taxes Dollar	$6,603	$6,801	$7,005	$7,215	$7,431
Insurance Percent	1.419%	1.419%	1.419%	1.419%	1.419%
Insurance Dollar	$4,228	$4,355	$4,485	$4,620	$4,759
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	$2,924	$3,012	$3,102	$3,195	$3,291
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	$13,755	$14,168	$14,593	$15,030	$15,481
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$15,486	$15,951	$16,429	$16,922	$17,430
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$21,470	$21,470	$21,470	$21,470	$21,470
Principal	$3,164	$3,376	$3,602	$3,843	$4,100
Interest	$18,306	$18,094	$17,868	$17,626	$17,369
Loan Balance at End of Year	$279,895	$276,520	$272,918	$269,075	$264,974
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	$2,406	$2,406	$2,406	$2,406	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$27,000	$39,583	$52,668	$66,279	$80,440
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$8,389	-$7,925	-$7,446	-$6,953	-$4,040
Monhtly Cash Flow	-$699	-$660	-$621	-$579	-$337
Cash on Cash Return on Investment	-0.130%	-0.123%	-0.115%	-0.108%	-0.063%
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