Topeka Deal Analysis

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

Typical Topeka, Kansas Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$143,992
Purchase Price		$143,992
Seller Concessions	—	$0
Down Payment	5.000%	$7,200
Closing Costs	1.000%	$1,440
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$9,441
Total Invested		$18,081
Mortgage
Mortgage Amount		$136,792.40
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$96.89
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,386 $1386.00
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$499
Property Taxes	1.813%	$2,611
Property Insurance	2.127%	$3,063
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%	$21,599
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	$148,312	$152,761	$157,344	$162,064	$166,926
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$4,320	$4,449	$4,583	$4,720	$4,862
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,386	$1,428	$1,470	$1,515	$1,560
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,386	$1,428	$1,470	$1,515	$1,560
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$42	$43	$44	$45	$47
Monthly Gross Operating Income	$1,344	$1,385	$1,426	$1,469	$1,513
Annual Income	1	2	3	4	5
Annual Rent	$16,632	$17,131	$17,645	$18,174	$18,719
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$16,632	$17,131	$17,645	$18,174	$18,719
Annual Vacancy Dollar	$499	$514	$529	$545	$562
Annual Gross Operating Income	$16,133	$16,617	$17,116	$17,629	$18,158
Annual Expenses	1	2	3	4	5
Property Taxes Percent	1.813%	1.813%	1.813%	1.813%	1.813%
Property Taxes Dollar	$2,611	$2,689	$2,770	$2,853	$2,938
Insurance Percent	2.127%	2.127%	2.127%	2.127%	2.127%
Insurance Dollar	$3,063	$3,155	$3,249	$3,347	$3,447
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,613	$1,662	$1,712	$1,763	$1,816
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,287	$7,505	$7,730	$7,962	$8,201
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$8,846	$9,112	$9,385	$9,667	$9,957
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$10,375	$10,375	$10,375	$10,375	$10,375
Principal	$1,529	$1,631	$1,741	$1,857	$1,982
Interest	$8,846	$8,744	$8,635	$8,518	$8,394
Loan Balance at End of Year	$135,263	$133,632	$131,891	$130,034	$128,053
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,163	$1,163	$1,163	$1,163	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$13,048	$19,129	$25,452	$32,030	$38,873
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$2,692	-$2,426	-$2,153	-$1,871	-$419
Monhtly Cash Flow	-$224	-$202	-$179	-$156	-$35
Cash on Cash Return on Investment	-0.149%	-0.134%	-0.119%	-0.104%	-0.023%
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