Free Excel workbooks

Run the numbers, then send them over.

Free Excel files for apartment buildings and commercial property. Run the numbers the way underwriting does, then send them over.

Pick a question

Start with what you need to know.

01Excel · .xlsx · 19 KB

What does interest-only do to my loan?

Interest-only vs 30 year calculator

Shows the loan, payment, and cash out on interest-only and on a 30 year payment for the same apartment building, and what each one leaves you owing.

InputsSummaryCompareSchedule
Summary sheet of the interest-only vs 30 year calculator, with both loans, the cash out at closing, and both balances over ten years.
Example interest-only adds
$1,161,300
03Excel · .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
05Excel · .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
06Excel · .xlsx · 20 KB

What loan does my retail center or office building carry?

Commercial property loan calculator

Builds NOI from a tenant-by-tenant rent roll, shows the loan on an amortizing payment and on interest-only, and lays out every lease that ends during the loan.

InputsSummaryLoanRollover
Summary sheet of the commercial property loan calculator, with the loan on both payment structures and base rent ending by year.
Example interest-only adds
$1,062,000
07Excel · .xlsx · 25 KB

What does my shopping center really carry?

Retail center underwriting template

Underwrites a strip or shopping center suite by suite, with CAM recoveries, anchor and shop vacancy, the loan on two payments, and an anchor-dark stress test.

InputsRent RollSummaryUnderwritingAnchor Dark
Summary sheet of the retail center underwriting template, with NOI, the loan on both payments, and the DSCR if the anchor goes dark.
Example recovery ratio
92.7%
08Excel · .xlsx · 17 KB

What will my net lease property carry?

Net lease loan calculator

Shows the loan the value, the rent, and the lease term support on a single-tenant property, what a shorter lease does to it, and what each kind of prepayment penalty costs you to sell.

InputsSummaryLoanLease TermExit Cost
Summary sheet of the net lease loan calculator, with the loan, what sets it, and the cost of yield maintenance in year 3.
Example yield maintenance in year 3
$213,929