Data Input

Inputs

1. Annual Interest Rate

2. Term of Loan (Years)

3. Payment Schedule

Annual Quarterly Monthly

4. Payment Due

Beginning of Period End of Period

5. Loan Amount

6. Net Operating Income (NOI)

7. Debt Service Coverage (DSC)

Results

Debt Service Constant

Debt Service Constant (PMT)

Debt Service Constant

Annual Debt Service

Annual Debt Service

Maximum Term Debt

DSC Net Operating Income (NOI)

Maximum Term Debt

Interest rate for the loan, e.g., 3.5%.
The term of the loan expressed in years, e.g., 25.
Payment frequency, i.e., Annually, Quarterly, or Monthly.
Payment due at the beginning, or end of the payment intervals.
Proposed loan amount.
Net Operating Income for this transaction.
Debt Service Coverage required by the lender.
Unique number for a ) loan term, b) interest rate, and c) payment frequency.
Annual debt service determined by the debt constant and loan amount.
Net Operating Income available to service debt given the required debt service coverage.
The maximum loan amount that can be financed given the proposed financing terms, NOI, and required DSC.