Anchorage Deal Analysis

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

Typical Anchorage, Alaska Nomad™ Property with 10% Higher Rents
Purchase Inputs
Percents Dollars/#
ARV $361,732
Purchase Price $361,732
Seller Concessions $0
Down Payment 5.000% $18,087
Closing Costs 1.000% $3,617
Rent Ready Costs $0
Cumulative Negative Cash Flow $5,363
Total Invested $27,067
Mortgage
Mortgage Amount $343,645.40
Mortgage Interest Rate 6.500%
Loan Term 360
Private Mortgage Insurance 0.850% $243.42
Drop PMI LTV 80.000%
Income
Monthly Rent $3,119 $3118.50
Other Income $0
Annual Expenses
Vacancy Rate 3.000% $1,123
Property Taxes 1.369% $4,952
Property Insurance 0.388% $1,404
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% $54,260
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 $372,584 $383,761 $395,274 $407,133 $419,347
Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Appreciation Dollar $10,852 $11,178 $11,513 $11,858 $12,214
Monthly Income 1 2 3 4 5
Rent Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Rent $3,119 $3,212 $3,308 $3,408 $3,510
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 $3,119 $3,212 $3,308 $3,408 $3,510
Vacancy Percent 3.000% 3.000% 3.000% 3.000% 3.000%
Monthly Vacancy Dollar $94 $96 $99 $102 $105
Monthly Gross Operating Income $3,025 $3,116 $3,209 $3,305 $3,405
Annual Income 1 2 3 4 5
Annual Rent $37,422 $38,545 $39,701 $40,892 $42,119
Annual Other Income $0 $0 $0 $0 $0
Annual Gross Potential Income $37,422 $38,545 $39,701 $40,892 $42,119
Annual Vacancy Dollar $1,123 $1,156 $1,191 $1,227 $1,264
Annual Gross Operating Income $36,299 $37,388 $38,510 $39,665 $40,855
Annual Expenses 1 2 3 4 5
Property Taxes Percent 1.369% 1.369% 1.369% 1.369% 1.369%
Property Taxes Dollar $4,952 $5,101 $5,254 $5,411 $5,574
Insurance Percent 0.388% 0.388% 0.388% 0.388% 0.388%
Insurance Dollar $1,404 $1,446 $1,489 $1,534 $1,580
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,630 $3,739 $3,851 $3,967 $4,086
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 $9,986 $10,285 $10,594 $10,911 $11,239
Net Operating Income 1 2 3 4 5
Net Operating Income (NOI) $26,314 $27,103 $27,916 $28,754 $29,616
Mortgage 1 2 3 4 5
Total Annual P&I Payments $26,065 $26,065 $26,065 $26,065 $26,065
Principal $3,841 $4,098 $4,373 $4,666 $4,978
Interest $22,224 $21,967 $21,692 $21,399 $21,087
Loan Balance at End of Year $339,804 $335,706 $331,334 $326,668 $321,690
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 $2,921 $2,921 $2,921 $2,921 $0
Equity 1 2 3 4 5
ARV - Loan Balance at End of Year $32,780 $48,055 $63,941 $80,465 $97,657
Cash Flow 1 2 3 4 5
Annual Cash Flow -$2,672 -$1,883 -$1,070 -$232 $3,552
Monhtly Cash Flow -$223 -$157 -$89 -$19 $296
Cash on Cash Return on Investment -0.099% -0.070% -0.040% -0.009% 0.131%
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