Shreveport Deal Analysis

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

Typical Shreveport, Louisiana Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$116,070
Purchase Price		$116,070
Seller Concessions	—	$0
Down Payment	5.000%	$5,804
Closing Costs	1.000%	$1,161
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$0
Total Invested		$6,964
Mortgage
Mortgage Amount		$110,266.50
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$78.11
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,672 $1672.44
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$602
Property Taxes	0.816%	$947
Property Insurance	2.398%	$2,783
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%	$17,411
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	$119,552	$123,139	$126,833	$130,638	$134,557
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$3,482	$3,587	$3,694	$3,805	$3,919
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,672	$1,723	$1,774	$1,828	$1,882
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,672	$1,723	$1,774	$1,828	$1,882
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$50	$52	$53	$55	$56
Monthly Gross Operating Income	$1,622	$1,671	$1,721	$1,773	$1,826
Annual Income	1	2	3	4	5
Annual Rent	$20,069	$20,671	$21,291	$21,930	$22,588
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$20,069	$20,671	$21,291	$21,930	$22,588
Annual Vacancy Dollar	$602	$620	$639	$658	$678
Annual Gross Operating Income	$19,467	$20,051	$20,653	$21,272	$21,911
Annual Expenses	1	2	3	4	5
Property Taxes Percent	0.816%	0.816%	0.816%	0.816%	0.816%
Property Taxes Dollar	$947	$976	$1,005	$1,035	$1,066
Insurance Percent	2.398%	2.398%	2.398%	2.398%	2.398%
Insurance Dollar	$2,783	$2,867	$2,953	$3,041	$3,133
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,947	$2,005	$2,065	$2,127	$2,191
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	$5,677	$5,848	$6,023	$6,204	$6,390
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$13,790	$14,204	$14,630	$15,069	$15,521
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$8,364	$8,364	$8,364	$8,364	$8,364
Principal	$1,232	$1,315	$1,403	$1,497	$1,597
Interest	$7,131	$7,048	$6,960	$6,866	$6,766
Loan Balance at End of Year	$109,034	$107,719	$106,316	$104,819	$103,221
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	$937	$937	$937	$937	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$10,518	$15,420	$20,517	$25,819	$31,335
Cash Flow	1	2	3	4	5
Annual Cash Flow	$4,489	$4,903	$5,329	$5,768	$7,157
Monhtly Cash Flow	$374	$409	$444	$481	$596
Cash on Cash Return on Investment	0.645%	0.704%	0.765%	0.828%	1.028%
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