underwriting and offer workspaces · Intermediate

Binding-constraint loan sizer

Identify the binding loan constraint under stated assumptions. Includes interactive DSCR LTV debt-yield and optional LTC sizing calculation.

Your assumptions

Illustrative starting values. Replace them with your own evidence. Inputs stay in this browser.

Annual underwritten net cash flowUSD/year
Assumed property valueUSD
Annual note rate%
Amortizationyears
Assumed minimum DSCRx
Assumed maximum LTV%
Assumed minimum debt yield%
Eligible total project costUSD
Assumed maximum LTC%

Your scenario, explained

Results

    Calculation assumptions

      Version 1.0.0 · Educational scenario, subject to the stated assumptions.

      How this calculation works

      Method and assumptions

      DSCR capacity = nonnegative underwritten cash flow ÷ minimum DSCR ÷ annual mortgage constant. Compare with value × LTV, eligible cost × LTC and nonnegative cash flow ÷ debt-yield requirement. The minimum binds.

      Worked example

      With $300,000 annual underwritten cash flow, a 6.5% rate, 30-year amortization and 1.25x required DSCR, the DSCR loan limit is $3,164,216.39. The other entered limits are $3,500,000 at 70% of $5 million value; $3,975,000 at 75% of $5.3 million cost; and $3,529,411.76 at 8.5% debt yield. DSCR is the binding constraint.

      Before using the result

      Know the boundaries

      • Educational scenario, not a quote, commitment, approval, appraisal or payoff statement.
      • Defaults and thresholds are editable illustrations; the executed documents and lender underwriting control.
      Calculation standards →

      Method references

      1. OCC: Commercial Real Estate Lending handbook
      2. Fannie Mae: Underwritten debt service coverage ratio
      Discuss your financing with Jaken Finance Group ↗

      Your path from education to financing

      Put the research to work.

      Follow the steps in order, or jump to the help you need.

      1. Learn

        Choose your asset class to find its underwriting guidance and lender requirements.

      2. Model

        Use a calculator to test your assumptions, then explore a full asset model.

      3. Prepare

        Organize the property, sponsor and transaction information for a financing discussion.

      4. Finance

        Ready to discuss a property or transaction? Bring your questions to Jaken Finance Group.

      Keep working through the decision

      Related resources