## Figure 2.3.1. Risk-Return Trade-off and Expected Times to Exit Underfunding

## Source details

**Canonical URL:** [Figure 2.3.1. Risk-Return Trade-off and Expected Times to Exit Underfunding](https://www.imf.org/-/media/files/publications/gfsr/2017/april/boxfigure2-3d.csv)

## Other formats

- [Markdown version](/-/media/files/publications/gfsr/2017/april/boxfigure2-3d.csv.md)
- [Structured JSON version](/-/media/files/publications/gfsr/2017/april/boxfigure2-3d.csv.json)

---

### Dataset overview
- Worksheet name: csv
- Row count: 104
- Column count: 13
- Primary column heading: "Figure 2.3.1. Risk-Return Trade-off and Expected Times to Exit Underfunding"
- Two principal panels indicated by column headings:
  - "1. Funding Ratio (Percent)"
  - "2. Value at Risk at 95 Percent Confidence Level (Percent of initial funding ratio)"

### Column structure (as presented)
- Column 1: (index)
- Columns 2–5: Funding Ratio (Percent) subcolumns
  - "High equity"
  - "Balanced"
  - "High bonds"
  - "Target (FR = 100)"
- Columns 8–9: Value at Risk at 95 Percent Confidence Level (Percent of initial funding ratio) labeled "Risk(%)" and "VaR(5%)"
- Columns 11–13: Additional labeling and numeric values that appear to repeat scenario labels and corresponding "Risk(%)" and "VaR(5%)" values (as present in the sample rows)

### Sample rows (preserving exact cell values)
- Row 1 (header / blank row): "", "", "", "", "", "", "", "", "", "", "", "", ""
- Row 2 (secondary header): "", "1. Funding Ratio (Percent)", "", "", "", "", "", "2. Value at Risk at 95 Percent Confidence Level (Percent of initial funding ratio)", "", "", "", "", ""
- Row 3 (subheaders): "", "High equity", "Balanced", "High bonds", "Target (FR = 100)", "", "", "Risk(%)", "VaR(5%)", "", "", "Risk(%)", "VaR(5%)"
- Row 4 (index "1"): "1", "80", "80", "80", "100", "", "", "11.81234488", "34.72377832", "", "High equity", "8.106475471", "24.41836558"
- Row 5 (index "2"): "2", "85.36", "84.09153846", "79.39076923", "100", "", "", "11.69279976", "34.39134409", "", "Balanced", "6.552433405", "20.09679385"
- Row 6 (index "3"): "3", "91.07911999", "88.39233551", "78.78617799", "100", "", "", "11.57325468", "34.05890994", "", "High bonds", "1.174535696", "5.1399393"
- Row 7 (index "4"): "4", "97.18142102", "92.91309352", "78.18619094", "100", "", "", "11.45370965", "33.72647586", "", "", "", ""
- Row 8 (index "5"): "5", "103.6925762", "97.66506221", "77.59077302", "100", "", "", "11.33416467", "33.39404186", "", "", "", ""
- Row 9 (index "6"): "6", "110.6399788", "102.6600667", "76.99988945", "100", "", "", "11.21461973", "33.06160794", "", "", "", ""
- Row 10 (index "7"): "7", "118.0528574", "107.9105368", "76.41350567", "100", "", "", "11.09507485", "32.7291741", "", "", "", ""

### Key numeric values (preserved exactly as in the dataset sample)
- Funding Ratio (High equity) sample values: "80", "85.36", "91.07911999", "97.18142102", "103.6925762", "110.6399788", "118.0528574"
- Funding Ratio (Balanced) sample values: "80", "84.09153846", "88.39233551", "92.91309352", "97.66506221", "102.6600667", "107.9105368"
- Funding Ratio (High bonds) sample values: "80", "79.39076923", "78.78617799", "78.18619094", "77.59077302", "76.99988945", "76.41350567"
- Target (FR = 100): repeated value "100" for sample rows 1 through 7
- Value at Risk panel (Risk(%)) sample values (first block): "11.81234488", "11.69279976", "11.57325468", "11.45370965", "11.33416467", "11.21461973", "11.09507485"
- Value at Risk panel (VaR(5%)) sample values (first block): "34.72377832", "34.39134409", "34.05890994", "33.72647586", "33.39404186", "33.06160794", "32.7291741"
- Secondary Risk/VaR numeric samples associated with scenario labels:
  - For "High equity": "8.106475471", "24.41836558"
  - For "Balanced": "6.552433405", "20.09679385"
  - For "High bonds": "1.174535696", "5.1399393"

*Dataset: boxfigure2-3d (csv worksheet sample rows as provided)*

---


_Source: https://www.imf.org/-/media/files/publications/gfsr/2017/april/boxfigure2-3d.csv_