Toledo Deal Analysis

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

Typical Toledo, Ohio Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$94,403
Purchase Price		$94,403
Seller Concessions	—	$0
Down Payment	5.000%	$4,720
Closing Costs	1.000%	$944
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$0
Total Invested		$5,664
Mortgage
Mortgage Amount		$89,682.85
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$63.53
Drop PMI LTV	80.000%
Income
Monthly Rent		$982 $981.75
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$353
Property Taxes	2.181%	$2,059
Property Insurance	0.693%	$654
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%	$14,160
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	$97,235	$100,152	$103,157	$106,251	$109,439
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$2,832	$2,917	$3,005	$3,095	$3,188
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$982	$1,011	$1,042	$1,073	$1,105
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	$982	$1,011	$1,042	$1,073	$1,105
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$29	$30	$31	$32	$33
Monthly Gross Operating Income	$952	$981	$1,010	$1,041	$1,072
Annual Income	1	2	3	4	5
Annual Rent	$11,781	$12,134	$12,498	$12,873	$13,260
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$11,781	$12,134	$12,498	$12,873	$13,260
Annual Vacancy Dollar	$353	$364	$375	$386	$398
Annual Gross Operating Income	$11,428	$11,770	$12,124	$12,487	$12,862
Annual Expenses	1	2	3	4	5
Property Taxes Percent	2.181%	2.181%	2.181%	2.181%	2.181%
Property Taxes Dollar	$2,059	$2,121	$2,184	$2,250	$2,317
Insurance Percent	0.693%	0.693%	0.693%	0.693%	0.693%
Insurance Dollar	$654	$674	$694	$715	$736
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,143	$1,177	$1,212	$1,249	$1,286
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,856	$3,972	$4,091	$4,213	$4,340
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$7,572	$7,799	$8,033	$8,274	$8,522
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$6,802	$6,802	$6,802	$6,802	$6,802
Principal	$1,002	$1,070	$1,141	$1,218	$1,299
Interest	$5,800	$5,733	$5,661	$5,585	$5,503
Loan Balance at End of Year	$88,680	$87,611	$86,470	$85,252	$83,953
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	$762	$762	$762	$762	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$8,555	$12,541	$16,687	$20,999	$25,486
Cash Flow	1	2	3	4	5
Annual Cash Flow	$7	$234	$468	$709	$1,720
Monhtly Cash Flow	$1	$20	$39	$59	$143
Cash on Cash Return on Investment	0.001%	0.041%	0.083%	0.125%	0.304%
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