Flint Deal Analysis

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

Typical Flint, Michigan Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$38,748
Purchase Price		$38,748
Seller Concessions	—	$0
Down Payment	5.000%	$1,937
Closing Costs	1.000%	$387
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$0
Total Invested		$2,325
Mortgage
Mortgage Amount		$36,810.60
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$26.07
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,097 $1097.25
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$395
Property Taxes	3.798%	$1,472
Property Insurance	0.880%	$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%	$5,812
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	$39,910	$41,108	$42,341	$43,611	$44,920
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$1,162	$1,197	$1,233	$1,270	$1,308
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,097	$1,130	$1,164	$1,199	$1,235
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,097	$1,130	$1,164	$1,199	$1,235
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$33	$34	$35	$36	$37
Monthly Gross Operating Income	$1,064	$1,096	$1,129	$1,163	$1,198
Annual Income	1	2	3	4	5
Annual Rent	$13,167	$13,562	$13,969	$14,388	$14,820
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$13,167	$13,562	$13,969	$14,388	$14,820
Annual Vacancy Dollar	$395	$407	$419	$432	$445
Annual Gross Operating Income	$12,772	$13,155	$13,550	$13,956	$14,375
Annual Expenses	1	2	3	4	5
Property Taxes Percent	3.798%	3.798%	3.798%	3.798%	3.798%
Property Taxes Dollar	$1,472	$1,516	$1,561	$1,608	$1,656
Insurance Percent	0.880%	0.880%	0.880%	0.880%	0.880%
Insurance Dollar	$341	$351	$362	$373	$384
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,277	$1,316	$1,355	$1,396	$1,437
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	$3,090	$3,183	$3,278	$3,376	$3,478
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$9,682	$9,973	$10,272	$10,580	$10,897
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$2,792	$2,792	$2,792	$2,792	$2,792
Principal	$411	$439	$468	$500	$533
Interest	$2,381	$2,353	$2,324	$2,292	$2,259
Loan Balance at End of Year	$36,399	$35,960	$35,492	$34,992	$34,459
Loan-To-Value	91.202%	87.478%	83.823%	80.236%	76.712%
Private Mortgage Insurance (PMI) Rate	0.850%	0.850%	0.850%	0.850%
Private Mortgage Insurance Dollar	$313	$313	$313	$313	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$3,511	$5,148	$6,849	$8,619	$10,461
Cash Flow	1	2	3	4	5
Annual Cash Flow	$6,577	$6,868	$7,167	$7,475	$8,105
Monhtly Cash Flow	$548	$572	$597	$623	$675
Cash on Cash Return on Investment	2.829%	2.954%	3.083%	3.215%	3.486%
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