Yonkers Deal Analysis

Let's look at deal analysis for Yonkers, NY and for 15 Buy 10 Nomads™ with 10% Higher Rents.

The World's Greatest Real Estate Deal Analysis Spreadsheet™

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 Yonkers, New York Nomad™ Property with 10% Higher Rents

Typical Yonkers, New York Nomad™ Property with 10% Higher Rents
Purchase Inputs
Percents Dollars/#
ARV $587,570
Purchase Price $587,570
Seller Concessions $0
Down Payment 5.000% $29,379
Closing Costs 1.000% $5,876
Rent Ready Costs $0
Cumulative Negative Cash Flow $598,103
Total Invested $633,358
Mortgage
Mortgage Amount $558,191.50
Mortgage Interest Rate 6.500%
Loan Term 360
Private Mortgage Insurance 0.850% $395.39
Drop PMI LTV 80.000%
Income
Monthly Rent $2,772 $2772.00
Other Income $0
Annual Expenses
Vacancy Rate 3.000% $998
Property Taxes 2.132% $12,527
Property Insurance 0.344% $2,021
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% $88,136
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 $605,197 $623,353 $642,054 $661,315 $681,155
Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Appreciation Dollar $17,627 $18,156 $18,701 $19,262 $19,839
Monthly Income 1 2 3 4 5
Rent Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Rent $2,772 $2,855 $2,941 $3,029 $3,120
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,772 $2,855 $2,941 $3,029 $3,120
Vacancy Percent 3.000% 3.000% 3.000% 3.000% 3.000%
Monthly Vacancy Dollar $83 $86 $88 $91 $94
Monthly Gross Operating Income $2,689 $2,770 $2,853 $2,938 $3,026
Annual Income 1 2 3 4 5
Annual Rent $33,264 $34,262 $35,290 $36,348 $37,439
Annual Other Income $0 $0 $0 $0 $0
Annual Gross Potential Income $33,264 $34,262 $35,290 $36,348 $37,439
Annual Vacancy Dollar $998 $1,028 $1,059 $1,090 $1,123
Annual Gross Operating Income $32,266 $33,234 $34,231 $35,258 $36,316
Annual Expenses 1 2 3 4 5
Property Taxes Percent 2.132% 2.132% 2.132% 2.132% 2.132%
Property Taxes Dollar $12,527 $12,903 $13,290 $13,689 $14,099
Insurance Percent 0.344% 0.344% 0.344% 0.344% 0.344%
Insurance Dollar $2,021 $2,082 $2,144 $2,209 $2,275
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 $3,227 $3,323 $3,423 $3,526 $3,632
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 $17,775 $18,308 $18,857 $19,423 $20,006
Net Operating Income 1 2 3 4 5
Net Operating Income (NOI) $14,491 $14,926 $15,374 $15,835 $16,310
Mortgage 1 2 3 4 5
Total Annual P&I Payments $42,338 $42,338 $42,338 $42,338 $42,338
Principal $6,239 $6,657 $7,103 $7,578 $8,086
Interest $36,099 $35,681 $35,235 $34,759 $34,252
Loan Balance at End of Year $551,952 $545,296 $538,193 $530,614 $522,529
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 $4,745 $4,745 $4,745 $4,745 $0
Equity 1 2 3 4 5
ARV - Loan Balance at End of Year $53,245 $78,057 $103,861 $130,701 $158,626
Cash Flow 1 2 3 4 5
Annual Cash Flow -$32,591 -$32,156 -$31,709 -$31,247 -$26,028
Monhtly Cash Flow -$2,716 -$2,680 -$2,642 -$2,604 -$2,169
Cash on Cash Return on Investment -0.051% -0.051% -0.050% -0.049% -0.041%
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