Joliet Deal Analysis

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

Typical Joliet, Illinois Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$179,462
Purchase Price		$179,462
Seller Concessions	—	$0
Down Payment	5.000%	$8,973
Closing Costs	1.000%	$1,795
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$35,771
Total Invested		$46,539
Mortgage
Mortgage Amount		$170,488.90
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$120.76
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,438 $1437.98
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$518
Property Taxes	2.697%	$4,840
Property Insurance	0.786%	$1,411
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%	$26,919
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	$184,846	$190,391	$196,103	$201,986	$208,046
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$5,384	$5,545	$5,712	$5,883	$6,060
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,438	$1,481	$1,526	$1,571	$1,618
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,438	$1,481	$1,526	$1,571	$1,618
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$43	$44	$46	$47	$49
Monthly Gross Operating Income	$1,395	$1,437	$1,480	$1,524	$1,570
Annual Income	1	2	3	4	5
Annual Rent	$17,256	$17,773	$18,307	$18,856	$19,422
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$17,256	$17,773	$18,307	$18,856	$19,422
Annual Vacancy Dollar	$518	$533	$549	$566	$583
Annual Gross Operating Income	$16,738	$17,240	$17,757	$18,290	$18,839
Annual Expenses	1	2	3	4	5
Property Taxes Percent	2.697%	2.697%	2.697%	2.697%	2.697%
Property Taxes Dollar	$4,840	$4,985	$5,135	$5,289	$5,448
Insurance Percent	0.786%	0.786%	0.786%	0.786%	0.786%
Insurance Dollar	$1,411	$1,453	$1,496	$1,541	$1,588
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,674	$1,724	$1,776	$1,829	$1,884
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,924	$8,162	$8,407	$8,659	$8,919
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$8,814	$9,078	$9,350	$9,631	$9,920
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$12,931	$12,931	$12,931	$12,931	$12,931
Principal	$1,906	$2,033	$2,169	$2,315	$2,470
Interest	$11,026	$10,898	$10,762	$10,617	$10,462
Loan Balance at End of Year	$168,583	$166,550	$164,381	$162,066	$159,596
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,449	$1,449	$1,449	$1,449	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$16,263	$23,841	$31,722	$39,920	$48,450
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$5,567	-$5,302	-$5,030	-$4,750	-$3,012
Monhtly Cash Flow	-$464	-$442	-$419	-$396	-$251
Cash on Cash Return on Investment	-0.120%	-0.114%	-0.108%	-0.102%	-0.065%
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