Killeen Deal Analysis

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

Typical Killeen, Texas Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$187,445
Purchase Price		$187,445
Seller Concessions	—	$0
Down Payment	5.000%	$9,372
Closing Costs	1.000%	$1,874
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$26,198
Total Invested		$37,445
Mortgage
Mortgage Amount		$178,072.75
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$126.13
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,617 $1617.00
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$582
Property Taxes	2.287%	$4,287
Property Insurance	1.419%	$2,660
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,117
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	$193,068	$198,860	$204,826	$210,971	$217,300
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$5,623	$5,792	$5,966	$6,145	$6,329
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,617	$1,666	$1,715	$1,767	$1,820
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,617	$1,666	$1,715	$1,767	$1,820
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$49	$50	$51	$53	$55
Monthly Gross Operating Income	$1,568	$1,616	$1,664	$1,714	$1,765
Annual Income	1	2	3	4	5
Annual Rent	$19,404	$19,986	$20,586	$21,203	$21,839
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$19,404	$19,986	$20,586	$21,203	$21,839
Annual Vacancy Dollar	$582	$600	$618	$636	$655
Annual Gross Operating Income	$18,822	$19,387	$19,968	$20,567	$21,184
Annual Expenses	1	2	3	4	5
Property Taxes Percent	2.287%	2.287%	2.287%	2.287%	2.287%
Property Taxes Dollar	$4,287	$4,415	$4,548	$4,684	$4,825
Insurance Percent	1.419%	1.419%	1.419%	1.419%	1.419%
Insurance Dollar	$2,660	$2,740	$2,822	$2,906	$2,994
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,882	$1,939	$1,997	$2,057	$2,118
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	$8,829	$9,094	$9,367	$9,648	$9,937
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$9,993	$10,293	$10,602	$10,920	$11,247
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$13,506	$13,506	$13,506	$13,506	$13,506
Principal	$1,990	$2,124	$2,266	$2,418	$2,580
Interest	$11,516	$11,383	$11,241	$11,089	$10,927
Loan Balance at End of Year	$176,082	$173,959	$171,693	$169,275	$166,696
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,514	$1,514	$1,514	$1,514	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$16,986	$24,902	$33,133	$41,696	$50,604
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$5,027	-$4,727	-$4,419	-$4,100	-$2,259
Monhtly Cash Flow	-$419	-$394	-$368	-$342	-$188
Cash on Cash Return on Investment	-0.134%	-0.126%	-0.118%	-0.110%	-0.060%
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