189-191 Hamilton St — Rental Hold

Cambridgeport, Cambridge MA 02139 · 3-unit triple-decker · 3,940 SF · Built 1903

Affordable housing preservation · Perpetual hold

← Home · Condo Sale Model · Decision Report

Unit 1 — Owner's home
2BR/1BA · 1,313sf
Floor 1 · Not rented
Unit 2 — Affordable rental
2BR/1BA · 1,313sf
Floor 2
Unit 3 — Affordable rental
2BR/1BA · 1,313sf
Floor 3
Does the owner occupy any of the units?

This one choice drives the care budget, the owner's expense share, and rental income: each owner-occupied unit is one fewer income-generating unit. Turn it on to model the original plan, or off when every unit is simply a rental.

Green (+) = money in. Red (−) = money out. Slide controls to test scenarios.

Renovation capital

Acquisition cost is what the incoming owner pays for the building itself. In this scenario that money goes to settle the owner's liabilities — medical bills, and the share for the owner's sister under the will — not to a seller. The construction, soft, and financing costs below are project costs, separate from the acquisition.

Acquisition cost$0
Construction cost per sq ft$175
Hard cost = $/sf × 3,940 sf. A higher construction cost also raises soft costs and financing — both are percentages of it — so the total capital rises faster than the $/sf alone.
Soft costs (% of construction)15%
Financing costs (% of construction + acquisition)10%
A one-time financing allowance — not an interest rate. Borrowing principal and the cost of borrowing are separate concepts; open Financing detail below to model an actual loan instead.
Financing detail
Construction time (months)12 mo

Rental income

Two units rented at AMI-capped rates. The tier sets the max rent.

Affordability level (AMI)
The tier sets the maximum rent from published affordability tables (MHP 2025, 2BR), minus a $385/mo utility allowance because tenants pay their own utilities. It is not a percentage of market rent.
Post-renovation market rent$3,100

The affordability impact — what you're choosing to give back

Building expenses & care

Operating expenses
Annual operating expenses$24,368
Owner's annual care budget$20K
Owner helps with expenses?
The care budget applies only while the owner occupies, and assumes one owner. It is drawn from building income as an expense — occupancy alone does not guarantee the income covers it.
Rent increase per year2.5%
Expense increase per year4.0%
Both on the same 0–8% scale — see the gap:
Rent: 2.5%/yr
Expenses: 4.0%/yr
0%2%4%6%8%

Timeline

The owner lives in Unit 1 during this period. When Unit 1 becomes available, it goes back online as a third affordable rental — increasing the building's income by roughly 50%.

Owner's residency7 yrs
Total projection15 yrs
A longer hold accumulates more years of rental income, expenses, and care costs. Cash flows are never extended past the period you select.

Key results

Year-by-year cash flow

All AMI tiers

Every tier from 50%–200%, with the market crossover flagged.

Important considerations

Conventional developer vs. this project

What the terms mean

189-191 Hamilton St. Appraisal: Beyond Appraisals Inc, 3/20/2025, as-is value $1,610,000. Rents: MHP 2025 Boston-Cambridge-Quincy. Utility allowance: BHA Aug 2025, $385/mo (2BR, gas heat, tenant-paid). Taxes: Cambridge FY26 $12,184. For planning purposes only — not financial, legal, or tax advice.