Rental & DSCR · Excel
DSCR Loan Sizing Workbook
Size residential rental financing using rent-to-PITIA coverage and an assumed LTV limit.
What you enter
- Monthly qualifying rent
- Taxes, insurance and HOA
- Rate, amortization, coverage target and LTV
What you get
- Coverage-limited and LTV-limited loan amounts
- Minimum rent for your requested loan
- Down payment and requested-loan coverage
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.