Calculation guide
Use annual operating income before debt service, depreciation and income taxes.
yield_pct = (income-opex)/loan*100; noi = income-opex
Inputs
Effective annual income
Example entry 162000 (in the selected currency).
Operating expenses
Example entry 62000 (in the selected currency).
Loan amount tested
Example entry 1250000 (in the selected currency). Minimum 0.01.
Worked example
| Input | Value |
|---|---|
| Effective annual income | 162,000 |
| Operating expenses | 62,000 |
| Loan amount tested | 1,250,000 |
| Result | Value |
|---|---|
| Debt yield | 8% |
| Net operating income | 100,000 |
Calculation steps
Debt yield = (((Effective annual income − Operating expenses) ÷ Loan amount tested) × 100)
(((162,000 − 62,000) ÷ 1,250,000) × 100) = 8%
Net operating income = (Effective annual income − Operating expenses)
(162,000 − 62,000) = 100,000
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Effective annual income | 162,000 | 178,200 | Debt yield | 8% | 9.296% |
| Operating expenses | 62,000 | 68,200 | Debt yield | 8% | 7.504% |
| Loan amount tested | 1,250,000 | 1,375,000 | Debt yield | 8% | 7.272727% |
