Buffalo Deal Analysis

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

Typical Buffalo, New York Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$183,328
Purchase Price		$183,328
Seller Concessions	—	$0
Down Payment	5.000%	$9,166
Closing Costs	1.000%	$1,833
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$1,893
Total Invested		$12,893
Mortgage
Mortgage Amount		$174,161.60
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$123.36
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,701 $1701.32
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$612
Property Taxes	1.964%	$3,601
Property Insurance	0.344%	$631
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%	$27,499
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	$188,828	$194,493	$200,327	$206,337	$212,527
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$5,500	$5,665	$5,835	$6,010	$6,190
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,701	$1,752	$1,805	$1,859	$1,915
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,701	$1,752	$1,805	$1,859	$1,915
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$51	$53	$54	$56	$57
Monthly Gross Operating Income	$1,650	$1,700	$1,751	$1,803	$1,857
Annual Income	1	2	3	4	5
Annual Rent	$20,416	$21,028	$21,659	$22,309	$22,978
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$20,416	$21,028	$21,659	$22,309	$22,978
Annual Vacancy Dollar	$612	$631	$650	$669	$689
Annual Gross Operating Income	$19,803	$20,397	$21,009	$21,640	$22,289
Annual Expenses	1	2	3	4	5
Property Taxes Percent	1.964%	1.964%	1.964%	1.964%	1.964%
Property Taxes Dollar	$3,601	$3,709	$3,820	$3,934	$4,052
Insurance Percent	0.344%	0.344%	0.344%	0.344%	0.344%
Insurance Dollar	$631	$650	$669	$689	$710
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,980	$2,040	$2,101	$2,164	$2,229
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,212	$6,398	$6,590	$6,788	$6,991
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$13,592	$14,000	$14,420	$14,852	$15,298
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$13,210	$13,210	$13,210	$13,210	$13,210
Principal	$1,947	$2,077	$2,216	$2,365	$2,523
Interest	$11,263	$11,133	$10,994	$10,845	$10,687
Loan Balance at End of Year	$172,215	$170,138	$167,922	$165,557	$163,034
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,480	$1,480	$1,480	$1,480	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$16,613	$24,355	$32,406	$40,780	$49,493
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$1,098	-$691	-$271	$162	$2,088
Monhtly Cash Flow	-$92	-$58	-$23	$13	$174
Cash on Cash Return on Investment	-0.085%	-0.054%	-0.021%	0.013%	0.162%
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