Davenport Deal Analysis

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

Typical Davenport, Iowa Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$147,939
Purchase Price		$147,939
Seller Concessions	—	$0
Down Payment	5.000%	$7,397
Closing Costs	1.000%	$1,479
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$4,253
Total Invested		$13,129
Mortgage
Mortgage Amount		$140,542.05
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$99.55
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,415 $1414.88
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$509
Property Taxes	1.926%	$2,849
Property Insurance	1.155%	$1,709
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%	$22,191
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	$152,377	$156,948	$161,657	$166,507	$171,502
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$4,438	$4,571	$4,708	$4,850	$4,995
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,415	$1,457	$1,501	$1,546	$1,592
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,415	$1,457	$1,501	$1,546	$1,592
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$42	$44	$45	$46	$48
Monthly Gross Operating Income	$1,372	$1,414	$1,456	$1,500	$1,545
Annual Income	1	2	3	4	5
Annual Rent	$16,979	$17,488	$18,013	$18,553	$19,110
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$16,979	$17,488	$18,013	$18,553	$19,110
Annual Vacancy Dollar	$509	$525	$540	$557	$573
Annual Gross Operating Income	$16,469	$16,963	$17,472	$17,996	$18,536
Annual Expenses	1	2	3	4	5
Property Taxes Percent	1.926%	1.926%	1.926%	1.926%	1.926%
Property Taxes Dollar	$2,849	$2,935	$3,023	$3,114	$3,207
Insurance Percent	1.155%	1.155%	1.155%	1.155%	1.155%
Insurance Dollar	$1,709	$1,760	$1,813	$1,867	$1,923
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,647	$1,696	$1,747	$1,800	$1,854
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	$6,205	$6,391	$6,583	$6,780	$6,984
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$10,264	$10,572	$10,889	$11,216	$11,553
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$10,660	$10,660	$10,660	$10,660	$10,660
Principal	$1,571	$1,676	$1,788	$1,908	$2,036
Interest	$9,089	$8,984	$8,872	$8,752	$8,624
Loan Balance at End of Year	$138,971	$137,295	$135,507	$133,599	$131,563
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,195	$1,195	$1,195	$1,195	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$13,406	$19,653	$26,150	$32,908	$39,939
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$1,590	-$1,282	-$965	-$638	$893
Monhtly Cash Flow	-$133	-$107	-$80	-$53	$74
Cash on Cash Return on Investment	-0.121%	-0.098%	-0.074%	-0.049%	0.068%
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