loan-sizing-engine

Normalize trailing-12 cash flow to lender NCF and size CRE loans against DSCR, LTV, and debt yield constraints.

43|13|Updated Mar 17, 2026
One-click install
npx skills add https://github.com/mariourquia/cre-skills-plugin --skill loan-sizing-engine
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: loan-sizing-engine
Source: https://github.com/mariourquia/cre-skills-plugin/tree/main/skills/loan-sizing-engine
Command: npx skills add https://github.com/mariourquia/cre-skills-plugin --skill loan-sizing-engine

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Automates CRE loan sizing by converting trailing-12 month cash flow into lender-underwritten NCF and applying DSCR, LTV, and debt yield constraints to determine max proceeds.

Core Features & Use Cases

  • NCF normalization: convert NOI to NCF by deducting reserves and floors required by lenders.
  • Multi-constraint sizing: simultaneously apply DSCR, LTV, and debt yield to identify the binding constraint and dynamic sizing scenarios.
  • Rate sensitivity & risk management: generate scenario analyses, reserve schedules, and risk flags for underwriting decisions.

Quick Start

Provide the property financials and let the engine size the loan under DSCR/LTV/DY constraints.

Frequently Asked Questions about loan-sizing-engine

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate the maximum CRE loan amount from trailing-12 month financials?

To calculate the maximum CRE loan amount, normalize trailing-12 month cash flow into lender-underwritten NCF and size the loan against DSCR, LTV, and debt yield constraints. The engine identifies the binding constraint to deliver the final maximum proceeds.

How does DSCR, LTV, and debt yield multi-constraint sizing work?

Multi-constraint sizing simultaneously applies DSCR, LTV, and debt yield limits to determine maximum loan proceeds. The engine calculates proceeds under each constraint, identifies the binding constraint yielding the lowest value, and reports all three values for underwriting transparency.

What is NCF normalization in commercial real estate underwriting?

NCF normalization converts NOI into lender-underwritten Net Cash Flow by deducting required reserves and applying floors. This adjusts trailing-12 month cash flow to match lender standards before applying DSCR, LTV, and debt yield constraints for loan sizing.

Can I size CRE loans for different execution types like agency MF, CMBS, and bridge?

Yes, the engine sizes CRE loans across common execution types including agency MF, CMBS, bank, bridge, and life company. It applies the appropriate DSCR, LTV, and debt yield constraints for each execution type and reports the binding constraint.

How do I generate rate sensitivity scenarios for CRE loan underwriting?

The engine generates rate sensitivity scenarios by testing loan sizing against varying interest rates. It reports debt service constants, dynamic sizing scenarios, and risk flags so underwriters can assess how rate changes impact maximum proceeds and the binding constraint.

What risk indicators are reported during the CRE loan sizing process?

The engine reports risk indicators including the binding constraint, rate sensitivity, reserve schedules, and debt service constants. These analytics are delivered in a reproducible, auditable format to support underwriting decisions and risk management.