Back to the free tools

04  A free tool

Loan sizer

Every loan has three ceilings. Only one of them binds.

In place or stabilized. Just be consistent about which.

Leave blank to skip the LTV test entirely.

All in.

The coverage the lender underwrites to. Blank skips it.

NOI over loan amount. Blank skips it.

Blank skips it.

Maximum loan

 

The constraint that binds

 

At that loan

 

How it works

Annual debt service per dollar borrowed: 12 × pmt(rate ÷ 12, years × 12, 1)

The three ceilings: NOI ÷ (DSCR × debt service per dollar)   NOI ÷ debt yield   value × LTV

The loan is the smallest of the three, and the smallest one is the quote you will actually get.

The trap is sizing proceeds off LTV alone. At today's rates the coverage test binds long before the value test on most stabilized deals, and the difference is not small.

It computes in your browser. Nothing is uploaded and there is no account. Built by Justin Zakariaie. The other tools