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

How to use it
- Submit your email to unlock the workbook or tool. Any PDFs below download directly without an email.
- Save a working copy, review the instructions and replace the example with your records.
- 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.