Interest As A Percentage Of Invested Capital (Historical)
Returns the interest expense expressed as a percentage of total invested capital. This metric helps assess how much of the capital base is being consumed by debt servicing costs.
Understanding the Metric
This ratio is calculated as:
Interest % = (Interest Expense / Invested Capital) * 100Where invested capital typically = Debt + Equity
This shows:
- The cost burden of debt financing
- How much return must be earned just to cover interest
- The impact of leverage on returns
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker (e.g., AAPL, MSFT) |
| Year | Fiscal year or period code (lq, ly, lq-1, ly-1, lt, lt-1) |
| Quarter | Optional: 1, 2, 3, or 4 (default: 1) |
| TTM | Optional: "TTM" for trailing twelve months |
Interpretation
| Ratio | Interpretation |
|---|---|
| < 1% | Minimal interest burden |
| 1-3% | Moderate debt cost |
| 3-5% | Significant interest expense |
| > 5% | Heavy debt servicing burden |
Examples
=hf_Interest_as_a_percentage_of_invested_capital("AAPL", 2023, 4)=hf_Interest_as_a_percentage_of_invested_capital("T", "ly")=hf_Interest_as_a_percentage_of_invested_capital("MSFT", 2023, , "TTM")=hf_Interest_as_a_percentage_of_invested_capital(A1, B1, C1)=hf_Interest_as_a_percentage_of_invested_capital("VZ", "lq")When to Use
- Analyzing debt cost burden
- Comparing financing efficiency
- Understanding capital costs
- Evaluating leverage impact
- ROIC vs interest spread analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need interest coverage | hf_Interest_coverage_from_continuing_operations() |
| Need absolute interest expense | hf_Interest_Expense() |
| Need ROIC | Check return on invested capital functions |
| Company has no debt | Ratio will be zero |
Common Issues & FAQ
Q: How does this relate to ROIC? A: Compare this ratio to ROIC. If ROIC > Interest%, the company earns more than its debt costs. If Interest% > ROIC, leverage is destroying value.
Q: Why is this ratio low for tech companies? A: Tech companies often have minimal debt and large equity values, resulting in very low interest as a percentage of total invested capital.
Q: What causes this ratio to increase? A: Rising interest rates, increased debt levels, or declining equity value can all increase this ratio over time.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today