Albany Deal Analysis

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

Typical Albany, New York Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$229,745
Purchase Price		$229,745
Seller Concessions	—	$0
Down Payment	5.000%	$11,487
Closing Costs	1.000%	$2,297
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$20,979
Total Invested		$34,764
Mortgage
Mortgage Amount		$218,257.75
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$154.60
Drop PMI LTV	80.000%
Income
Monthly Rent		$2,010 $2009.70
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$723
Property Taxes	3.023%	$6,945
Property Insurance	0.344%	$790
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%	$34,462
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	$236,637	$243,736	$251,049	$258,580	$266,337
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$6,892	$7,099	$7,312	$7,531	$7,757
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$2,010	$2,070	$2,132	$2,196	$2,262
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	$2,010	$2,070	$2,132	$2,196	$2,262
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$60	$62	$64	$66	$68
Monthly Gross Operating Income	$1,949	$2,008	$2,068	$2,130	$2,194
Annual Income	1	2	3	4	5
Annual Rent	$24,116	$24,840	$25,585	$26,353	$27,143
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$24,116	$24,840	$25,585	$26,353	$27,143
Annual Vacancy Dollar	$723	$745	$768	$791	$814
Annual Gross Operating Income	$23,393	$24,095	$24,818	$25,562	$26,329
Annual Expenses	1	2	3	4	5
Property Taxes Percent	3.023%	3.023%	3.023%	3.023%	3.023%
Property Taxes Dollar	$6,945	$7,154	$7,368	$7,589	$7,817
Insurance Percent	0.344%	0.344%	0.344%	0.344%	0.344%
Insurance Dollar	$790	$814	$838	$864	$890
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,339	$2,409	$2,482	$2,556	$2,633
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	$10,075	$10,377	$10,688	$11,009	$11,339
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$13,318	$13,718	$14,129	$14,553	$14,990
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$16,554	$16,554	$16,554	$16,554	$16,554
Principal	$2,440	$2,603	$2,777	$2,963	$3,162
Interest	$14,115	$13,952	$13,777	$13,591	$13,393
Loan Balance at End of Year	$215,818	$213,215	$210,438	$207,475	$204,313
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,855	$1,855	$1,855	$1,855	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$20,819	$30,521	$40,611	$51,105	$62,024
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$5,092	-$4,692	-$4,280	-$3,857	-$1,565
Monhtly Cash Flow	-$424	-$391	-$357	-$321	-$130
Cash on Cash Return on Investment	-0.146%	-0.135%	-0.123%	-0.111%	-0.045%
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