Lansing Deal Analysis

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

Typical Lansing, Michigan Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$123,953
Purchase Price		$123,953
Seller Concessions	—	$0
Down Payment	5.000%	$6,198
Closing Costs	1.000%	$1,240
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$0
Total Invested		$7,437
Mortgage
Mortgage Amount		$117,755.35
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$83.41
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,733 $1732.50
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$624
Property Taxes	2.576%	$3,193
Property Insurance	0.880%	$1,091
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%	$18,593
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	$127,672	$131,502	$135,447	$139,510	$143,695
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$3,719	$3,830	$3,945	$4,063	$4,185
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,733	$1,784	$1,838	$1,893	$1,950
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,733	$1,784	$1,838	$1,893	$1,950
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$52	$54	$55	$57	$58
Monthly Gross Operating Income	$1,681	$1,731	$1,783	$1,836	$1,891
Annual Income	1	2	3	4	5
Annual Rent	$20,790	$21,414	$22,056	$22,718	$23,399
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$20,790	$21,414	$22,056	$22,718	$23,399
Annual Vacancy Dollar	$624	$642	$662	$682	$702
Annual Gross Operating Income	$20,166	$20,771	$21,394	$22,036	$22,697
Annual Expenses	1	2	3	4	5
Property Taxes Percent	2.576%	2.576%	2.576%	2.576%	2.576%
Property Taxes Dollar	$3,193	$3,289	$3,387	$3,489	$3,594
Insurance Percent	0.880%	0.880%	0.880%	0.880%	0.880%
Insurance Dollar	$1,091	$1,124	$1,157	$1,192	$1,228
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	$2,017	$2,077	$2,139	$2,204	$2,270
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,300	$6,489	$6,684	$6,885	$7,091
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$13,866	$14,282	$14,710	$15,152	$15,606
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$8,931	$8,931	$8,931	$8,931	$8,931
Principal	$1,316	$1,404	$1,498	$1,599	$1,706
Interest	$7,615	$7,527	$7,433	$7,333	$7,226
Loan Balance at End of Year	$116,439	$115,035	$113,537	$111,938	$110,232
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,001	$1,001	$1,001	$1,001	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$11,232	$16,467	$21,910	$27,572	$33,463
Cash Flow	1	2	3	4	5
Annual Cash Flow	$3,933	$4,349	$4,778	$5,219	$6,675
Monhtly Cash Flow	$328	$362	$398	$435	$556
Cash on Cash Return on Investment	0.529%	0.585%	0.642%	0.702%	0.897%
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