Enter Values

$
Market value or purchase price
$
Annual NOI (before debt service)
$
Total mortgage balance
%
Annual note rate
years
Remaining loan amortization

Model Assumptions

  • Single-period (Year 1) income-return analysis
  • Fixed-rate fully amortizing mortgage
  • No appreciation or reversion modeled
  • Mortgage constant includes principal + interest
  • No taxes, depreciation, CapEx, or closing costs
  • Leverage test compares cap rate to mortgage constant (not interest rate)
  • This tests income leverage; total-return leverage (including appreciation) can differ

For educational purposes. Not financial advice. Market conventions simplified.

Ryan O'Connell, CFA
Calculator by Ryan O'Connell, CFA

Leverage Analysis

Negative Leverage
Cap Rate < Mortgage Constant — leverage reduces income return
Cap Rate (Property Yield) 7.00%
Mortgage Constant 7.58%
LTV Ratio 75.0%
Equity Invested $1,250,000
Annual Debt Service $284,431
Pre-Tax Cash Flow $65,569
Equity Dividend Rate 5.25%
Leverage Effect -175 bps

Formula Breakdown

Leverage Test: Cap Rate vs Mortgage Constant
Positive Leverage when Cap Rate > Mortgage Constant (ADS / Loan)

Key Insight: Mortgage Constant vs Interest Rate

The leverage test compares the cap rate to the mortgage constant, not the interest rate. For fully amortizing loans, the mortgage constant is always higher than the interest rate because it includes principal repayment.

Example: A 6.5% interest rate with 30-year amortization produces a 7.58% mortgage constant. A 7.00% cap rate exceeds the interest rate but falls below the mortgage constant, resulting in negative leverage. Cash flow can be positive while leverage is negative.

Understanding Real Estate Leverage

What is Leverage in Real Estate?

Leverage refers to the use of borrowed funds (debt) to finance a real estate investment. When an investor uses a mortgage to purchase a property, the returns on their equity are amplified — in both directions. Per Geltner Chapter 13, leverage affects both the expected return and the risk of the equity investment.

Core Formulas
Cap Rate = NOI / Property Value
Mortgage Constant = Annual Debt Service / Loan Amount
Equity Dividend Rate = Pre-Tax Cash Flow / Equity
Leverage Test: Cap Rate vs Mortgage Constant

Positive vs Negative Leverage

Positive Leverage

Occurs when cap rate > mortgage constant. The property earns more per dollar of value than the debt costs per dollar borrowed. Leverage amplifies the equity return above the unlevered cap rate.

Negative Leverage

Occurs when cap rate < mortgage constant. The debt costs more per dollar borrowed than the property earns per dollar of value. Leverage reduces the equity return below the unlevered cap rate.

Why Mortgage Constant, Not Interest Rate?

The mortgage constant includes both principal and interest payments. For amortizing loans, the mortgage constant always exceeds the interest rate. Comparing the cap rate to the interest rate alone can incorrectly classify negative leverage as positive.

Important: This calculator analyzes income (cash-flow) leverage. Total-return leverage, which includes property appreciation, can differ. A property with negative income leverage may still have positive total-return leverage if appreciation is sufficiently high.

Practical Applications

  • Financing Decisions: Compare leverage effects of different loan structures
  • Acquisition Analysis: Determine if debt improves or hurts equity returns
  • Sensitivity Analysis: Test how rate changes affect leverage type
  • Investor Communication: Explain why positive cash flow does not always mean positive leverage
Download This Calculator as an Excel Template Interactive model with editable formulas — customize, save, and share.
Get Excel Template

Frequently Asked Questions

Positive income leverage occurs when the property's cap rate (NOI / Property Value) exceeds the mortgage constant (Annual Debt Service / Loan Amount). In this case, the property earns more per dollar of asset value than the debt costs per dollar borrowed, so using debt amplifies the equity investor's income return above what an all-equity investment would yield. Per Geltner Chapter 13, the equity dividend rate exceeds the cap rate when leverage is positive. Note: this tests income leverage specifically; total-return leverage (including appreciation) can differ.

The mortgage constant is the annual debt service (both principal and interest) divided by the loan amount. For fully amortizing loans, it is always higher than the interest rate because it includes principal repayment. For example, a 6.5% interest rate on a 30-year amortizing loan produces a mortgage constant of approximately 7.58%. This distinction is critical: comparing the cap rate to the interest rate (rather than the mortgage constant) can lead to an incorrect assessment of leverage.

Yes. Negative leverage means that borrowing reduces the equity income return relative to an all-equity investment — it does not necessarily mean cash flow is negative. In the example above, pre-tax cash flow is +$65,569, but the equity dividend rate (5.25%) is below the cap rate (7.00%) because the mortgage constant (7.58%) exceeds the cap rate. The investor earns positive cash flow but would earn a higher income yield without debt.

The equity dividend rate, also called cash-on-cash return, is the annual pre-tax cash flow divided by the equity invested: EDR = PTCF / Equity. It measures the income return on the actual cash the investor has in the deal. Unlike cap rate, which ignores financing, EDR reflects the effect of leverage on the investor's income return. This calculator uses a simplified equity definition (Property Value minus Loan Amount), excluding closing costs and reserves.

A shorter amortization period increases the monthly payment (more principal repaid per month), which raises the mortgage constant. A higher mortgage constant makes negative leverage more likely because the total debt service cost per dollar of loan is higher. Conversely, a longer amortization period reduces the mortgage constant, making positive leverage more likely. Interest-only loans have the lowest possible mortgage constant (equal to the interest rate), but this calculator assumes fully amortizing loans.

When there is no debt, the equity dividend rate equals the cap rate, and there is no leverage effect. The investor receives the full property yield on their equity without amplification or dilution. This is the baseline against which levered returns are compared. Setting the loan amount to zero in this calculator shows the all-equity scenario.
Disclaimer

This calculator is for educational purposes only and analyzes single-period income leverage. Actual leverage effects depend on property appreciation, financing terms, tax treatment, and market conditions. This tool uses simplified assumptions and does not account for closing costs, reserves, capital expenditures, or income taxes. Consult a qualified real estate professional or financial advisor for investment decisions.

Related Calculators

Professional finance illustration representing Commercial Mortgage Calculator

Commercial Mortgage Calculator

Calculate commercial mortgage payments and amortization.

Try Calculator →
Professional finance illustration representing Effective Rent Calculator

Effective Rent Calculator

Calculate effective rent accounting for concessions and TI.

Try Calculator →
Professional finance illustration representing CRE Returns Calculator: Cash-on-Cash Return, Equity Multiple & IRR

CRE Returns Calculator: Cash-on-Cash Return, Equity Multiple & IRR

Analyze unlevered and levered returns for CRE investments.

Try Calculator →