Worksheet: Debt Service Constant

Sample Data:

Data Input

Inputs

1. Annual Interest Rate

2. Term of Loan (Years)

3. Payment Schedule

4. Payment Due

5. Loan Amount

6. Net Operating Income (NOI)

7. Debt Service Coverage (DSC)

Results

Debt Service Constant

Debt Service Constant

Annual Debt Service

Annual Debt Service

Maximum Term Debt

DSC Net Operating Income (NOI)

 Maximum Term Debt