## Figure 1.10. Debt Service, Interest Coverage Ratios, and Vulnerability to Higher Interest Rates (dataset overview)

## Source details

**Canonical URL:** [Figure 1.10. Debt Service, Interest Coverage Ratios, and Vulnerability to Higher Interest Rates (dataset overview)](https://www.imf.org/-/media/files/publications/gfsr/2017/april/chapter-1/figure1-10d-v2.csv)

## Other formats

- [Markdown version](/-/media/files/publications/gfsr/2017/april/chapter-1/figure1-10d-v2.csv.md)
- [Structured JSON version](/-/media/files/publications/gfsr/2017/april/chapter-1/figure1-10d-v2.csv.json)

---

### Dataset description
- Worksheet name: csv
- Row count: 78
- Column count: 29
- Title and panel layout preserved from file: "1. Corporate Debt Service and Interest Rates", "2. Evolution of the Distribution of ICRs across Firms by Size", "4. Average Interest Corverage Ratio", "5. Percent of \"Challenged\" Firms", "6. Evolution of �Challenged� Firms, by Sector"
- Units and measures used in the dataset (as labeled): "Debt service ratio (percent of income)"; "Prime lending rate  (percent)"; "Ratio of EBIT to interest payments" (Interest Coverage Ratio, ICR); "Percent of total assets"; "Share of total firms with ICR < 2"

### Key variables (column headers and labels preserved)
- Date (e.g., "3/31/1999", "6/30/1999", "9/30/1999")
- Debt service ratio (percent of income)
- Prime lending rate  (percent)
- Year labels for panels (e.g., "1996", "1997", "1998")
- ICR measures:
  - "Average" (Ratio of EBIT to interest payments)
  - "Smallest 25 percent by assets"
  - "Smallest 5 percent by assets"
- Average Interest Coverage Ratio (panel 4)
- Percent of "Challenged" Firms (panel 5):
  - "Weak (ICR < 1)"
  - "Vulnerable (1 < ICR < 2)"
- Sector shares for "Challenged" firms (panel 6) (Percent of total assets):
  - "Energy"
  - "Real estate"
  - "Utilities"
  - "Consumer discretionary"
  - "Industrials"
  - "Materials"
  - "Information technology"
  - "Others"

### Sample observations (exact values preserved from sample rows)
- 3/31/1999:
  - Debt service ratio (percent of income): "42.3"
  - Prime lending rate  (percent): "7.75"
  - Panel-year label: "1996"
  - ICR Average (1996): "6.19"
  - ICR Smallest 25 percent by assets (1996): "5.46"
  - ICR Smallest 5 percent by assets (1996): "5.18"
  - Average Interest Coverage Ratio (1996): "6.19"
  - Percent of total assets — Weak (ICR < 1) (1996): "2.6"
  - Percent of total assets — Vulnerable (1 < ICR < 2) (1996): "4.95"
  - Share of total firms with ICR < 2 (1996): "1.81"
  - Sector shares of "Challenged" firms (1996):
    - Energy: "10.53"
    - Real estate: "12.34"
    - Utilities: "34.28"
    - Consumer discretionary: "10.22"
    - Industrials: "8.7"
    - Materials: "15.6"
    - Information technology: "6.52"
    - Others: (no value in sample row)

- 6/30/1999:
  - Debt service ratio (percent of income): "42.6"
  - Prime lending rate  (percent): "7.75"
  - Panel-year label: "1997"
  - ICR Average (1997): "6.24"
  - ICR Smallest 25 percent by assets (1997): "5.15"
  - ICR Smallest 5 percent by assets (1997): "5.33"
  - Average Interest Coverage Ratio (1997): "6.24"
  - Percent of total assets — Weak (ICR < 1) (1997): "3.92"
  - Percent of total assets — Vulnerable (1 < ICR < 2) (1997): "4.79"
  - Share of total firms with ICR < 2 (1997): "5.71"
  - Sector shares of "Challenged" firms (1997):
    - Energy: "10.44"
    - Real estate: "14.43"
    - Utilities: "17.88"
    - Consumer discretionary: "25.85"
    - Industrials: "11.93"
    - Materials: "6.74"
    - Information technology: "7.02"
    - Others: (no value in sample row)

- 9/30/1999:
  - Debt service ratio (percent of income): "43.4"
  - Prime lending rate  (percent): "8.1"
  - Panel-year label: "1998"
  - ICR Average (1998): "5.59"
  - ICR Smallest 25 percent by assets (1998): "4.17"
  - ICR Smallest 5 percent by assets (1998): "4.2"
  - Average Interest Coverage Ratio (1998): "5.59"
  - Percent of total assets — Weak (ICR < 1) (1998): "4.91"
  - Percent of total assets — Vulnerable (1 < ICR < 2) (1998): "8.43"
  - Share of total firms with ICR < 2 (1998): "13.89"
  - Sector shares of "Challenged" firms (1998):
    - Energy: "10.42"
    - Real estate: "21.63"
    - Utilities: "19.01"
    - Consumer discretionary: "12.33"
    - Industrials: "10.26"
    - Materials: "5.09"
    - Information technology: "7.37"
    - Others: (no value in sample row)

### Data structure and analytical scope (as implied by labels)
- Time series frequency: quarterly dates listed in sample rows (e.g., "3/31/1999", "6/30/1999", "9/30/1999")
- Cross-sectional breakdowns by firm size (average, smallest 25 percent, smallest 5 percent) for ICRs
- Aggregation of "Challenged" firms both as percent of total assets (Weak and Vulnerable) and as share of total firms with ICR < 2
- Sectoral composition of "Challenged" firms provided as percent shares across listed sectors

*Source: Figure 1.10. Debt Service, Interest Coverage Ratios, and Vulnerability to Higher Interest Rates (csv worksheet)*

---


_Source: https://www.imf.org/-/media/files/publications/gfsr/2017/april/chapter-1/figure1-10d-v2.csv_