Debt Service Coverage & Leverage Analysis Prompt

Prompt

Analyze DSCR and leverage to ensure borrowing capacity.

[PASTE: Property NOI, proposed loan, lender requirements, borrower info]

Steps: 1) Calculate annual debt service 2) Calculate DSCR 3) Compare to lender minimum 4) Calculate LTV 5) Model stress scenarios 6) Assess refinance risk 7) Recommend debt strategy

Output: DSCR calculation summary, leverage analysis, stressed DSCR scenarios, approval probability, recommendation.

Why it works

DSCR analysis ensures debt service sustainability. Lender alignment prevents financing surprises.

Watch out for

Tight DSCR leaves no margin for error. Conservative leverage protects against rate shocks.

Used by

Finance TeamsData Analysts

Browse all prompts →