Skip to main content
JFG

Search

    SEE YOUR RATE

    More than $535 million in real estate loans.

    Rental & DSCR · Excel

    First and Second Mortgage Underwriting Workbook

    Model two separate structures: a commercial second lien behind an existing first, or a DSCR first mortgage allowing a second. Compare coverage, cash flow and leverage.

    What you enter

    • Property value and first / second loan terms
    • Commercial NOI or residential rent and PITIA
    • Operating costs, reserves, maturities and downside assumptions

    What you get

    • First-only and combined coverage
    • Cash flow, CLTV, net proceeds and maturity balances
    • Editable Base and Stress assumptions
    First and Second Mortgage Underwriting Workbook: example results and editable workbook inputs
    Workbook preview with hypothetical example values. Download the Excel file to edit the assumptions.

    How to use it

    1. Submit your email to unlock the workbook or tool. Any PDFs below download directly without an email.
    2. Save a working copy, review the instructions and replace the example with your records.
    3. Check the results against your lender’s terms and retain a dated copy for the property.

    Excel workbooks contain editable inputs and formulas. Example assumptions are illustrative; they are not current market quotes or financing commitments.

    FREE INVESTOR RESOURCE

    Unlock your download

    Submit your email to download your results. Your deal inputs stay in this browser.

    Submit your email to access this free resource. Privacy policy.