Waco Deal Analysis

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

Typical Waco, Texas Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$190,719
Purchase Price		$190,719
Seller Concessions	—	$0
Down Payment	5.000%	$9,536
Closing Costs	1.000%	$1,907
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$4,015
Total Invested		$15,458
Mortgage
Mortgage Amount		$181,183.05
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$128.34
Drop PMI LTV	80.000%
Income
Monthly Rent		$2,021 $2021.25
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$728
Property Taxes	2.561%	$4,884
Property Insurance	1.419%	$2,706
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%	$28,608
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	$196,441	$202,334	$208,404	$214,656	$221,096
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$5,722	$5,893	$6,070	$6,252	$6,440
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$2,021	$2,082	$2,144	$2,209	$2,275
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,021	$2,082	$2,144	$2,209	$2,275
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$61	$62	$64	$66	$68
Monthly Gross Operating Income	$1,961	$2,019	$2,080	$2,142	$2,207
Annual Income	1	2	3	4	5
Annual Rent	$24,255	$24,983	$25,732	$26,504	$27,299
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$24,255	$24,983	$25,732	$26,504	$27,299
Annual Vacancy Dollar	$728	$749	$772	$795	$819
Annual Gross Operating Income	$23,527	$24,233	$24,960	$25,709	$26,480
Annual Expenses	1	2	3	4	5
Property Taxes Percent	2.561%	2.561%	2.561%	2.561%	2.561%
Property Taxes Dollar	$4,884	$5,031	$5,182	$5,337	$5,497
Insurance Percent	1.419%	1.419%	1.419%	1.419%	1.419%
Insurance Dollar	$2,706	$2,787	$2,871	$2,957	$3,046
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,353	$2,423	$2,496	$2,571	$2,648
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	$9,943	$10,242	$10,549	$10,865	$11,191
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$13,584	$13,992	$14,411	$14,844	$15,289
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$13,742	$13,742	$13,742	$13,742	$13,742
Principal	$2,025	$2,161	$2,305	$2,460	$2,625
Interest	$11,717	$11,582	$11,437	$11,283	$11,118
Loan Balance at End of Year	$179,158	$176,997	$174,692	$172,232	$169,607
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,540	$1,540	$1,540	$1,540	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$17,283	$25,337	$33,712	$42,424	$51,488
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$1,698	-$1,291	-$871	-$439	$1,547
Monhtly Cash Flow	-$142	-$108	-$73	-$37	$129
Cash on Cash Return on Investment	-0.110%	-0.084%	-0.056%	-0.028%	0.100%
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