Des Moines Deal Analysis

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

Typical Des Moines, Iowa Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$166,872
Purchase Price		$166,872
Seller Concessions	—	$0
Down Payment	5.000%	$8,344
Closing Costs	1.000%	$1,669
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$11,474
Total Invested		$21,486
Mortgage
Mortgage Amount		$158,528.40
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$112.29
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,499 $1499.19
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$540
Property Taxes	2.163%	$3,609
Property Insurance	1.155%	$1,927
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%	$25,031
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	$171,878	$177,035	$182,346	$187,816	$193,450
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$5,006	$5,156	$5,311	$5,470	$5,634
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,499	$1,544	$1,590	$1,638	$1,687
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,499	$1,544	$1,590	$1,638	$1,687
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$45	$46	$48	$49	$51
Monthly Gross Operating Income	$1,454	$1,498	$1,543	$1,589	$1,637
Annual Income	1	2	3	4	5
Annual Rent	$17,990	$18,530	$19,086	$19,658	$20,248
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$17,990	$18,530	$19,086	$19,658	$20,248
Annual Vacancy Dollar	$540	$556	$573	$590	$607
Annual Gross Operating Income	$17,451	$17,974	$18,513	$19,069	$19,641
Annual Expenses	1	2	3	4	5
Property Taxes Percent	2.163%	2.163%	2.163%	2.163%	2.163%
Property Taxes Dollar	$3,609	$3,718	$3,829	$3,944	$4,062
Insurance Percent	1.155%	1.155%	1.155%	1.155%	1.155%
Insurance Dollar	$1,927	$1,985	$2,045	$2,106	$2,169
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,745	$1,797	$1,851	$1,907	$1,964
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	$7,282	$7,500	$7,725	$7,957	$8,196
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$10,169	$10,474	$10,788	$11,112	$11,445
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$12,024	$12,024	$12,024	$12,024	$12,024
Principal	$1,772	$1,891	$2,017	$2,152	$2,296
Interest	$10,252	$10,134	$10,007	$9,872	$9,728
Loan Balance at End of Year	$156,756	$154,866	$152,849	$150,696	$148,400
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,347	$1,347	$1,347	$1,347	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$15,122	$22,169	$29,497	$37,120	$45,051
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$3,203	-$2,898	-$2,584	-$2,260	-$579
Monhtly Cash Flow	-$267	-$241	-$215	-$188	-$48
Cash on Cash Return on Investment	-0.149%	-0.135%	-0.120%	-0.105%	-0.027%
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