Multifamily Deal Analyzer

Property: 3205 Briarcliff Rd NE, Atlanta, GA 30329

1) Investment

Home Price ($)

Downpayment (%)

Closing Costs (%)

Total Upfront Repairs & Updates ($)

Other Upfront (Inspection etc.) ($)

Downpayment $: Loan Amount: Closing Costs $: Total Upfront Investment:

2) Loan Terms

Interest Rate (APR %)

Term (years)

PMI Rate (annual % of loan)

PMI Months

Monthly Insurance Escrow ($)

Monthly Property Tax Escrow ($)

P&I Payment: Monthly w/o PMI: PMI $: Monthly w/ PMI:

3) Rents & Other Income

Unit #1

Unit #2

Unit #3

Unit #4

Other Income (w+d, parking) monthly

Gross Scheduled Rent: Total Monthly Revenue:

4) Operating Expenses (monthly)

Property Management ($ or % of rent)

CapEx Reserve ($ or % of rent)

Vacancy Reserve ($ or % of rent)

Repairs Reserve ($ or % of rent)

Other OpEx (utilities, lawn, etc.)

Total OpEx (monthly): OpEx as % of Revenue:

Tip: use % modes to mirror 5%, 10%, 5%, 5% reserves from your sheet.

5) Assumptions & Taxes

Annual Appreciation (%)

Rent Growth (%)

OpEx Growth (%)

Annual Depreciation (building yrs)

Building Value ($)

Tax Bracket (%)

Annual Depreciation $:

6) Your Finances

Monthly Gross Income ($)

Other Monthly Debts ($)

Current Cash Savings ($)

Reserve Requirement (months)

Bank Rent Credit (%)

6-mo Reserves Needed: Reserves After Close:

Results — Monthly Cash Flow & Returns

Monthly Revenue

Operating Expenses

Financing (P&I + Escrows + PMI)

Monthly Cash Flow

Cap Rate (NOI/Price)

Cash-on-Cash

Monthly Rents / Price

OpEx + T&I / Rent

CoC uses upfront cash outlay (down + closing + upfront repairs/inspections).

Affordability — DTI Tests

Use 75% of Rent for Bank Qual (multi‑family)

Front‑End DTI Target (%)

Back‑End DTI Target (%)

Front‑End DTI

Back‑End DTI

Max Monthly Mortgage (per target)

Max Purchase Price (3.5% down)

Decision Rules — Purchase or Pass

Can You Afford It? (Max Price vs Price)

—

CoC ≥ 10%?

—

Rent / Price ≥ 1%?

—

(OpEx + T&I) / Rent ≤ 50%?

—

Cap Rate ≥ 6%?

—

30‑Year Totals (Quick Model)

Total Revenues

Total Operating Expenses

Total Financing (P&I + T&I + PMI)

Total Cash Flow

Principal Paid

Interest Paid

Tax Savings (depreciation shield)

Appreciation Gain

Total Δ Net Worth

This section compounds rents & OpEx by your growth rates and taxes/insurance stay as entered. PMI stops after the chosen months.

Unlock Your Deal Results

1) Investment

2) Loan Terms

3) Rents & Other Income

4) Operating Expenses (monthly)

5) Assumptions & Taxes

6) Your Finances

Results — Monthly Cash Flow & Returns

Affordability — DTI Tests

Decision Rules — Purchase or Pass

30‑Year Totals (Quick Model)