Free Excel workbooks

Run the numbers, then send them over.

Four workbooks for apartment buildings. Size a cash-out refinance, test a loan's DSCR, compare refinancing against holding, or run a value-add deal from the bridge loan through the permanent loan. All are free, and the example buildings are fictional.

Pick a question

Start with what you need to know.

02Excel · .xlsx · 16 KB

Will this loan clear the lender's minimum?

Apartment DSCR calculator

Builds NOI the way an apartment lender does, tests the loan you want against the minimum coverage, and shows the loan the income actually supports.

InputsSummaryDSCR
Summary sheet of the apartment DSCR calculator, with coverage on the requested loan and the shortfall.
Example DSCR
1.16x
04Excel · .xlsx · 21 KB

Does the refinance pay off the bridge?

Bridge to permanent calculator

Sizes the bridge on cost, carries the interest through renovation and lease-up, and shows how much cash comes back when the permanent loan pays it off.

InputsSummaryTakeoutTimeline
Summary sheet of the bridge to permanent calculator, with cash back at the refinance and months left on the bridge.
Example cash back
$606,380