Analysis of Hillsboro Street
Acquisition
Purchase Price
$45,000
Closing Costs (%)
$450 (1.0%)
Credits
(0.0%)
Reno Budget
$80,000
Reno Holding Costs
$250
1st Loan Points (%)
$900 (2.0%)
1st Loan Rate (%)
10.00%
1st Loan Amount
$45,000
2nd Loan Points (%)
N/A
2nd Loan Rate (%)
N/A
2nd Loan Amount
N/A
Refi Date (months)
3
ARV (at refi)
$180,000
LTV (% based on ARV)
75% ($135,000)
Interest Rate (%)
5.00%
Lender Fees/Costs
$2,000
Amortization (years)
30
# of Units
1
Avg. Rent of All Units
$850
Other Monthly Income
Annual Vacancy (%)
Annual Property Taxes
$500.00
Annual Insurance Cost
$750.00
Property Mgmt. Fee (%)
Monthly Utilities
$150.00
Monthly Maint./Repairs
Other Expenses (ie. HOA)
YOY Rent Growth (%)
3.00%
YOY Expense Growth (%)
2.00%
YOY Appreciation (%)
3.00%
Selling Costs (%)
7.00%
Cash Needed at Purchase
$82,725.00
Cash Back After Refi
$88,000.00
Cash Remaining in Deal After Refi
$(5,275.00)
Mortgage Payment (P&I Only)
$724.71
5 Year CoC (Cash on Cash)
Infinite
5 Year AAR (Avg. Annualized Return)
Infinite
5 Year Equity Multiple
Infinite
Rental Income
$10,200.00
$10,506.00
$10,821.18
$11,145.82
$11,480.19
Other Income
$0.00
$0.00
$0.00
$0.00
$0.00
Vacancy/Loss
$0.00
$0.00
$0.00
$0.00
$0.00
Gross Income
$10,200.00
$10,506.00
$10,821.18
$11,145.82
$11,480.19
Property Taxes
$(500.00)
$(510.00)
$(520.20)
$(530.60)
$(541.22)
Insurance
$(750.00)
$(765.00)
$(780.30)
$(795.91)
$(811.82)
Mgmt. Fee
$0.00
$0.00
$0.00
$0.00
$0.00
Utilities
$(1,800.00)
$(1,836.00)
$(1,872.72)
$(1,910.17)
$(1,948.38)
Maint. & Repairs
$0.00
$0.00
$0.00
$0.00
$0.00
Other Expenses
$0.00
$0.00
$0.00
$0.00
$0.00
Total Expenses
$(3,050.00)
$(3,111.00)
$(3,173.22)
$(3,236.68)
$(3,301.42)
Net Operating Income (NOI)
$7,150.00
$7,395.00
$7,647.96
$7,909.13
$8,178.77
Principal
$1,991.74
$2,093.64
$2,200.76
$2,313.35
$2,431.71
Interest
$6,704.77
$6,602.87
$6,495.75
$6,383.16
$6,264.80
Total Debt Service (P&I)
$8,696.51
$8,696.51
$8,696.51
$8,696.51
$8,696.51
Total Annual Cash Flow
$(1,546.51)
$(1,301.51)
$(1,048.55)
$(787.38)
$(517.74)
Est. Property Value
$185,400.00
$190,962.00
$196,690.86
$202,591.59
$208,669.33
Est. Equity
$52,391.74
$60,047.39
$67,977.01
$76,191.09
$84,700.55
Loan Balance
$133,008.26
$130,914.61
$128,713.85
$126,400.50
$123,968.79
Total Proceeds if Sold
$39,413.74
$46,680.05
$54,208.65
$62,009.68
$70,093.69
DealSimple logo