St Louis Deal Analysis

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

Typical St Louis, Missouri Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$151,013
Purchase Price		$151,013
Seller Concessions	—	$0
Down Payment	5.000%	$7,551
Closing Costs	1.000%	$1,510
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$0
Total Invested		$9,061
Mortgage
Mortgage Amount		$143,462.35
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$101.62
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,617 $1617.00
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$582
Property Taxes	1.139%	$1,720
Property Insurance	1.550%	$2,341
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,652
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	$155,543	$160,210	$165,016	$169,966	$175,065
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$4,530	$4,666	$4,806	$4,950	$5,099
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	1.139%	1.139%	1.139%	1.139%	1.139%
Property Taxes Dollar	$1,720	$1,772	$1,825	$1,880	$1,936
Insurance Percent	1.550%	1.550%	1.550%	1.550%	1.550%
Insurance Dollar	$2,341	$2,411	$2,483	$2,558	$2,634
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	$5,943	$6,121	$6,305	$6,494	$6,689
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$12,879	$13,265	$13,663	$14,073	$14,495
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$10,881	$10,881	$10,881	$10,881	$10,881
Principal	$1,604	$1,711	$1,825	$1,948	$2,078
Interest	$9,278	$9,170	$9,056	$8,934	$8,803
Loan Balance at End of Year	$141,859	$140,148	$138,322	$136,375	$134,296
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,219	$1,219	$1,219	$1,219	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$13,685	$20,062	$26,694	$33,592	$40,769
Cash Flow	1	2	3	4	5
Annual Cash Flow	$778	$1,165	$1,562	$1,972	$3,614
Monhtly Cash Flow	$65	$97	$130	$164	$301
Cash on Cash Return on Investment	0.086%	0.129%	0.172%	0.218%	0.399%
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