Start with a property identity page
Write the exact address, municipality, listing date, property type, unit description, current occupancy if known, and the source of each detail. Keep the marketing description beside, not instead of, the official property records. Note differences between the listing, assessor entry, plans, leases, and what you observed. Ask your Massachusetts attorney and town office which records can resolve each discrepancy.
Add the purchase assumptions separately: expected role, financing conversation, price range, move or vacancy timing, and the people involved. Mark a value as confirmed, estimated, projected, or unknown. This prevents a neat spreadsheet from making an assumption look like a fact.
Create a unit and system map
For each unit, note the rooms, entry, occupancy documents, utilities, appliances, storage, and parking. Then make a shared-area list for stairs, basement, heating, hot water, roof, laundry, exterior, and common spaces. Record which equipment serves which area and what maintenance history is available.
Ask an independent inspector to evaluate the property and identify where specialty review may be needed. Keep report dates and scopes visible. Do not infer current condition from a permit, invoice, or photograph. If a water, septic, well, boundary, or structural question matters, identify the licensed professional or official record that can answer it.
Track legal and municipal records
List the deed, title documents, leases, permits, plans, inspection records, tax information, and association agreements that apply. Note who requested each item and whether a current version is available. Have your attorney review legal instruments, rental agreements, disclosure questions, and proposed contract terms.
Town procedures vary across Boston, Natick, Framingham, and other MetroWest communities. Use the official municipality source for records and inspection processes; do not assume a rule or form from one city applies elsewhere. A town contact can direct you to records but may not interpret a purchase contract or guarantee a use.
Build an operating summary from evidence
Record rent only from signed agreements and verified payment history, with its period and source. List taxes, insurance, utilities, service contracts, repair invoices, management fees, and recurring work. Mark the difference between actual expense, current quote, future estimate, and seller projection. Ask your lender what income or expense documentation it will accept.
Do not use a generic rent or maintenance estimate as a return promise. Make a separate scenario for a vacancy, a repair, and a cost change, then ask a qualified financial professional to review your assumptions. The worksheet is an organizer; it does not forecast profitability or substitute for tax, legal, insurance, or financing advice.
Name the next question and the person responsible
For every open item, write the question, why it matters, the person who can answer, and the date needed. An attorney addresses legal records and leases; a lender financing; an inspector or contractor condition; an insurer coverage; a town office municipal records; a manager operational services. Some issues require more than one advisor.
Use the field notes below to mark each question once its answer has a current source. Talk with Rita about a Boston MetroWest investment search and share the address and your intended use. Rita can help coordinate property conversations; your qualified professionals should verify legal, financial, technical, and operational claims.
Apply the worksheet to a real alternative
Compare the multi-family property with another property type or a decision to wait. Use the same financing assumptions, your available time, and the same standard for documentation. If a property only appears to fit under a best-case projection, revisit the inputs before making an offer.
The worksheet should leave some entries blank until verified. That is useful information: it shows where the next call, document, inspection, or professional review belongs. A clear unknown is safer to reason about than a number invented to complete a table.
Save the completed file with its sources
Keep copies of records and notes in a secure folder labeled by address and date. Protect tenant information and share only what is necessary through an appropriate channel. Update the worksheet if the offer, occupancy, condition, or service arrangements change.
This process cannot remove investment risk, but it can make the property and its responsibilities easier to understand. Use the documented facts, professional advice, and your own capacity to decide whether to proceed.
