2d:null 2e:["$","title",null,{"children":"The hidden impacts of rising interest rates | ONE Campaign | Observable"}] 33:T4be,- _Loan commitments (PPG)_: this data is in current dollars and reflects the total of all loans 'committed' by a given creditor to a given borrower in a given year. - _Average interest rate_: this data is a weighted average of the interest rates of loans for a given debtor based on all the loans 'committed' by a given creditor in a given year. The data is weighted by the amounts committed. - _Average grace period_: this data is a weighted average of the grace periods of loans for a given debtor based on all the loans 'committed' by a given creditor in a given year. The data is weighted by the amounts committed. For bonds, in most cases, the grace period is equal to the maturity of the bond (since the principal is only paid at maturity in most cases). We assume that interest payments are made during the grace period, and that principal payments are not. - _Average maturity_: this data is a weighted average of the length maturities of loans (in years) for a given debtor based on all the loans 'committed' by a given creditor in a given year. The data is weighted by the amounts committed. We use this data in order to calculate the expected time during which the loans will generate interest payments.34:T4cf,expectedPayments = Plot.plot({ marginLeft: 30, width: width > 880 ? 880 : width, aspectRatio: selectGroup === "Africa" ? 3.7 : 25, y: { ticks: false, grid: false, domain: [0, yMax > 10 ? yMax * 1.1 : 10], label: `Interest (US% billion)` }, x: { axis: null, paddingOuter: 0.2 }, color: { legend: true, domain: ["Expected Interest", "Expected Interest (at new rate)"], range: [ selectGroup === "Middle income countries" ? "#081248" : "#fe4f5e", "#3883e5" ] }, marks: [ Plot.barY(expectedPaymentsInteractive, { x: "indicator", y: "Interest", fill: "indicator", fx: (d) => d3.format(".0f")(d.year), tip: true, title: (d) => `${d.indicator}:\nUS$${d.Interest.toFixed(1)} billion` }), Plot.ruleY([0]), Plot.text(expectedPaymentsInteractive, { x: "indicator", y: "Interest", z: "indicator", fx: (d) => d3.format(".0f")(d.year), dy: -8, //fontSize: width < 1000 ? "0.75rem" : width < 1500 ? "1rem" : "3rem", text: (d) => `${d.Interest.toLocaleString("en-US", { minimumFractionDigits: 0, maximumFractionDigits: 1 })}` + "bn" }) ] })35:T922,health_debt = Plot.plot({ inset: 5, marginRight: 80, width: width > 880 ? 880 : width, aspectRatio: 2.5, x: { domain: [0, 30], ticks: 4, label: "Health spending (% of government expenditure)" }, y: { domain: [0, 55], ticks: 3, label: "External debt service (% of government expenditure)" }, marks: [ Plot.line( [ { x: 0, y: 0 }, { x: 30, y: 30 } ], { x: "x", y: "y", opacity: 0.33, strokeDasharray: "2,5" } ), Plot.ruleY([0], { stroke: "grey", strokeOpacity: 0.8 }), Plot.ruleX([0], { stroke: "grey", strokeOpacity: 0.8 }), Plot.dot(healthDebt2020, { anchor: "bottom", padding: 20, x: "value_health", y: "value_debt", fillOpacity: 0.7, strokeOpacity: 0.9, strokeWidth: 0.9, stroke: (d) => (d.colour = d.value_health > d.value_debt ? "grey" : "#7123f0"), fill: (d) => (d.colour = d.value_health > d.value_debt ? "grey" : "#7123f0"), tip: true, title: (d) => `${d.name}\nHealth spending: ${d.value_health.toFixed( 1 )}%\nExternal debt service spending: ${d.value_debt.toFixed(1)}%` }), Plot.text(healthDebt2020, { filter: (d) => [ "Congo Republic", "Senegal", "Dominican Republic", "Mauritania", "Mozambique", "Tanzania", "Uganda", "Guinea-Bissau", "Cameroon", "Angola", "Gabon" ].includes(d.name), x: "value_health", y: "value_debt", text: (d) => `${d.name}`, paintOrder: 1, dy: +8, lineAnchor: "middle", lineWidth: 10 }), Plot.text( [ { x: width > 550 ? 25.2 : 20.5, y: 28.7, text: "Higher debt payments ↑" } ], { x: "x", y: "y", text: "text", dy: "-0.5em", fill: "#7123f0", fontSize: 9.5 } ), Plot.text( [ { x: width > 550 ? 29.5 : 31, y: width > 550 ? 26.25 : 23, text: "↓ Higher health spending" } ], { x: "x", y: "y", text: "text", dy: "-0.5em", fill: "DimGray", fontSize: 9.5 } ) ] })36:T69f,function discountedPayments({ maturityYears, graceYears, commitmentAmount, interestRate, discountRate }) { // Calculate the number of years in which principal will be paid let paymentYears = maturityYears - graceYears < 0.1 ? 0 : maturityYears - graceYears; // Calculate the principal payment per year let principalPaymentPerYear = paymentYears <= 0 ? 0 : commitmentAmount / paymentYears; // Since the rate is given in percentage points, we need to divide by 100 let iRate = interestRate != 0 ? interestRate / 100 : 0; // Since the discountRate is given in percentage points, we need to divide by 100 let dRate = discountRate != 0 ? discountRate / 100 : 0; // Calculate interests during grace period. Discount them to present value. let gracePeriodInterest = 0; _.range(1, Math.floor(graceYears) + 1).forEach((year) => { let paymentAmountGrace = commitmentAmount * iRate; let discountFactorGrace = Math.pow(1 + dRate, year); gracePeriodInterest += paymentAmountGrace / discountFactorGrace; }); // Calculate the interest payments for each year after grace let loanInterestsAfterGrace = 0; _.range(1, Math.ceil(paymentYears)).forEach((year) => { let paymentAmountAfter = (commitmentAmount - year * principalPaymentPerYear) * iRate; let discountFactor = Math.pow(1 + dRate, year + graceYears); loanInterestsAfterGrace += paymentAmountAfter / discountFactor; }); //Safety check on payments during grace loanInterestsAfterGrace = paymentYears < 0.1 ? 0 : loanInterestsAfterGrace; // Put everything together let totalInterest = gracePeriodInterest + loanInterestsAfterGrace; return totalInterest; }37:T4e8,expectedPaymentsInteractive = countryAndGroupTable .params({ group: selectGroup, counterpart: selectCounterpart, discount: discountRate, newRate: newInterest }) .filter( (d, $) => d.group_name == $.group && d.counterpart_area == $.counterpart ) .derive({ expectedPayments: aq.escape((d, $) => discountedPayments({ maturityYears: d.value_maturities, graceYears: d.value_grace, commitmentAmount: d.value_commitments, interestRate: d.value_rate, discountRate: $.discount }) ), expectedPaymentsNew: aq.escape((d, $) => discountedPayments({ maturityYears: d.value_maturities, graceYears: d.value_grace, commitmentAmount: d.value_commitments, interestRate: $.newRate, discountRate: $.discount }) ) }) .groupby("year", "group_name", "counterpart_area") .rollup({ //weight: (d) => op.sum(d.weight), "Expected Interest": (d) => op.sum(d.expectedPayments) / 1e9, "Expected Interest (at new rate)": (d) => op.sum(d.expectedPaymentsNew) / 1e9, avgRate: (d) => op.sum(d.avg_rate) }) .fold(["Expected Interest", "Expected Interest (at new rate)"], { as: ["indicator", "Interest"] })38:[{"id":"603700960428632a20350623743033373385c1acc9961af1acc2b7647a064fc75b319b6dbc17ff238cebba3973b84ce5020c4244912e9702b48c89bc0705b0f1","href":"https://static.observableusercontent.com/files/603700960428632a20350623743033373385c1acc9961af1acc2b7647a064fc75b319b6dbc17ff238cebba3973b84ce5020c4244912e9702b48c89bc0705b0f1","name":"country_counterpart_with_weights_2016-21.csv","type":"text/csv","lastModified":1691234827705.426,"size":181185},{"id":"7fb373b13b1dfda455da4f0ca924cd7081ff2e1f50a5762a994306401799d37d10c77d58ddae42a1e871f3b1a499a2415bc637dd6664807e952006cd10ee74bf","href":"https://static.observableusercontent.com/files/7fb373b13b1dfda455da4f0ca924cd7081ff2e1f50a5762a994306401799d37d10c77d58ddae42a1e871f3b1a499a2415bc637dd6664807e952006cd10ee74bf","name":"debt_health_2020.csv","type":"text/csv","lastModified":1691328972615.874,"size":3216}] 31:{"id":"b76efce2d3fd4126","slug":"hidden-impacts-of-rising-interest-rates","title":"The hidden impacts of rising interest rates","thumbnail":"1fba565a5b693650d5376f0c4378b3a139bc4b89413111f21366acc85e24cbce","access_level":"public","create_time":"$D2023-07-27T06:28:38.713Z","update_time":"$D2023-08-09T15:51:00.889Z","view_time":null,"first_public_time":"$D2023-07-27T06:28:38.713Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"13c6fc7ef7b09bba","login":"one-campaign","name":"ONE Campaign","avatar_url":"https://avatars-next.observableusercontent.com/c58192ca59b3a23066e98356418851adaed725e827bb52882301fc4fda17a8aa","tier":"starter_2024"},"version":1284,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"0004d5be12d25201","login":"jm-rivera","name":"Jorge Rivera","avatar_url":"https://avatars-next.observableusercontent.com/eb9ffa1c5d630f63517176ded24be11e0764d4d4e52d473aa882a19f73422911","tier":null}],"members":[{"type":"individual","id":"0004d5be12d25201","login":"jm-rivera","name":"Jorge Rivera","avatar_url":"https://avatars-next.observableusercontent.com/eb9ffa1c5d630f63517176ded24be11e0764d4d4e52d473aa882a19f73422911","tier":null,"role":"editor"},{"type":"team","id":"13c6fc7ef7b09bba","login":"one-campaign","name":"ONE Campaign","avatar_url":"https://avatars-next.observableusercontent.com/c58192ca59b3a23066e98356418851adaed725e827bb52882301fc4fda17a8aa","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"The hidden impacts of rising interest rates","cells":[{"id":0,"value":"# The hidden impacts of rising interest rates\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":664,"value":"This notebook contains an explanation of the different methodologies we use in our _Hidden impacts of rising interest rates_ report.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":666,"value":"The key research in the report uses data from the [World Bank's International Debt Statistics (IDS)](https://databank.worldbank.org/source/international-debt-statistics) database.\nWith this data, we attempt to answer the following question: **How much are countries expected to pay in interest on the money borrowed in a given year?**\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":768,"value":"ToC({\n title: \"Table of contents\",\n headers: [\"h1\", \"h2\"],\n filter: [\"The hidden impacts of rising interest rates\", \"Notebook tools\"],\n invalidation\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":679,"value":"## A note on the IDS data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":684,"value":"The IDS data contains a wealth of information on external public and publicly guaranteed (PPG) debt. The different indicators can be viewed from a debtor perspective, and are broken down by the 'counterpart-area' (i.e. the creditor) to which different types of debt are owed.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":682,"value":"The level of detail found in the data varies for each indicator. The IDS data is not presented on an individual loan basis. Instead, for _interest payments_ for example, the data is broken down by year, debtor, creditor and by type of debt. That means we cannot tell how much interest is being paid on specific loans, but we have a single number for each type of debt/creditor (bilateral, multilateral, private banks, bonds).\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":686,"value":"Data on the terms of individual loans is unavailable. But data on maturities, grace periods, and interest rates are provided as weighted averages for a given creditor-debtor in a given year. The data is weighted by the amount lent by a specific creditor to a debtor in a given year.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":690,"value":"## On interest payments","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":692,"value":"In a given year, interest payments reflect the composition of the outstanding debt. Given different interest rates, maturities, grace periods, and borrowed amounts, the relationship between the interest rates and the interest payments in a given year isn't that straightforward.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":694,"value":"However, we can use different data available through the IDS to estimate the expected interest payments for loans committed in a given year. For that, we use this data:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":696,"value":"$33","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":709,"value":"### A note on Net Present Value and our use of discount rates","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":707,"value":"Like the IMF in its [Debt Sustainability Assessments](https://www.imf.org/en/Topics/sovereign-debt/debt-limits-policy#:~:text=The%20discount%20rate%20used%20to,least%20equal%20to%2035%20percent), we use Net Present Value (NPV) in our calculations. This means we take each cash flow in the repayments and we discount it back to the 'present day' (the year of the loan commitment), using a discount rate.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":712,"value":"NPV better reflects the \"burden\" of debt than the face value. For example, US$100 million payable in 10 years is less burdensome than a debt of US$100 million payable tomorrow. The NPV takes this time factor into account. When looking at loans with maturities spanning decades this becomes especially significant.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":699,"value":"### Calculating expected interest payments","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":701,"value":"To calculate the expected interest payments over the lifetime of loans or bonds we:\n- Use the amount committed and the interest rate provided. We assume that interest rates are fixed for the duration of the loan/bond.\n- Assume Equal Principal Payments with a single annual payment.\n- Assume yearly interest payments. We assume interest is paid during grace periods (but not principal), and that both interest and principal are paid after the grace period.\n- Assume there will not be defaults, rescheduling, restructuring or refinancing over the lifetime of the loans.\n- Use a [discount rate of 5%](https://www.imf.org/en/Topics/sovereign-debt/debt-limits-policy#:~:text=The%20discount%20rate%20used%20to,least%20equal%20to%2035%20percent) to discount future cash flows. We do this to reflect the fact that money today (or at the time of commitment) is worth more than the same amount of money in the future.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":716,"value":"We calculate the total interest due over the lifetime of loans (in NPV) in the following way:\n\nWe denote:\n>- _C_ as the committed value or principal\n>- _rate_ as the interest rate\n>- _g_ as the grace period (if any)\n>- _m_ as the maturity of the loan\n>- _DiscountRate_ as the discount rate used\n>- _y_ as the year of the payment","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":719,"value":"First, the yearly principal payments (in nominal terms) are calculated as","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":726,"value":"YearlyPrincipal = \\frac{C}{m - g}","pinned":false,"hidden":false,"mode":"tex","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":731,"value":"For the NPV of total interest payments, we sum the interest paid during and after the grace period. Note that for bonds, the grace period may be equal to the bond maturity.\n\nThe interest due during the grace period (in NPV terms) is calculated as follows:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":753,"value":"Interest_{GracePeriod} = \\sum_{y=1}^{g} \\frac{C\\cdot rate}{(1 + DiscountRate)^{y}}","pinned":false,"hidden":false,"mode":"tex","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":735,"value":"The interest due after the grace period (in NPV terms), once principal payments are also being made, is calculated as:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":760,"value":"Interest_{AfterGrace} = \\sum_{y=1}^{m - g} \\frac{(C - y \\cdot YearlyPrincipal)\\cdot rate}{(1 + DiscountRate)^{y + g}}","pinned":false,"hidden":false,"mode":"tex","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":727,"value":"And, finally, the total expected interest payments (in NPV of the year of the commitment) are calculated as: ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":766,"value":"Interest_{Total} = Interest_{GracePeriod} + Interest_{AfterGrace}","pinned":false,"hidden":false,"mode":"tex","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":17,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":803,"value":"## Expected interest payments","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":805,"value":"The chart below shows how much a country/region is expected to pay in interest on the loans it agreed in a given year. **These amounts are for the lifetime of the loan.** You can also apply a discount rate—a rate of 0 means that the data stays in nominal terms.\n\nUse the controls below to select a group of countries, creditor, a discount rate, and a 'new' interest rate for comparison.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":611,"value":"controls = html`

\n ${viewof selectGroup}\n ${viewof selectCounterpart}\n ${viewof discountRate}\n ${viewof newInterest}\n

\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":385,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":817,"value":"To illustrate the point, ${selectCounterpart} lent US$${selectedCreditorLending.toFixed(1)} billion to ${selectGroup}${selectGroup === 'Africa'?'n countries':\"\"} at an average rate of **${selectedCreditorRate.toFixed(2)}%** in 2021. ${selectGroup}${selectGroup === 'Africa'?'n countries':\"\"} will owe **US$${selectedParametersDue2021.toFixed(1)} billion** in interest over the lifetime of those loans. If the interest rate were **${newInterest}%** instead, they would pay **US$${selectedParametersDue2021newRate.toFixed(1)} billion** .","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1065,"value":"## Comparing the World Bank IBRD interest rates to Bonds","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1066,"value":"The chart below looks at the weighted average interest rates for Africa (and for 'other' non-African countries as a dropdown option). To produce these aggregates, the rates are weighted by the total loans 'committed' to a given debtor in a given year.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":53,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":949,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":951,"value":"## Health versus external debt service spending","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":952,"value":"This chart plots government health spending (x-axis) against interest payments on external debt (y-axis), both as a share of total spending.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":955,"value":"The countries shown in purple, which are above the dotted line, spend more on debt service than they do on health.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":958,"value":"The data is for 2020, based on health spending data from the [WHO Global Health Expenditure](https://apps.who.int/nha/database) database, and GDP and government expenditure data from the [IMF World Economic Outlook](https://www.imf.org/en/Publications/WEO/weo-database/2023/April) database.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":966,"value":"health_chart_title = html`

Many countries spend more servicing debt than on health

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":890,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1062,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1057,"value":"## US Fed interest rate hikes by cycle ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1059,"value":"The chart below shows the pace at which the US has raised interest rates in the current cycle, and in other interest rate rising cycles in the past.\n\nThe lines track the amount by which the rate is changing, compared to the rate in place at the beginning of the cycle (in percentage points). The actual rate is shown on hover.\n\nThe x-axis tracks the number of weeks that have passed since the interest rate hiking cycle began.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":28,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1252,"value":"## Data sources\n
\n\n**Interest cost analysis** \n\nThe key research in the report uses data from the World Bank's [International Debt Statistics (IDS)](https://databank.worldbank.org/source/international-debt-statistics) database.\n\nWe use the following indicators:\n- Interest rates: `DT.INR.DPPG`\n- Maturities: `DT.MAT.DPPG`\n- Grace periods: `DT.GPA.DPPG`\n- New loan commitments:\n - `DT.COM.MLAT.CD` (multilateral)\n - `DT.COM.PRT.CD` (private)\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1261,"value":"**FED rates analysis**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1257,"value":"The US FED rates chart uses data from [The Federal Reserve Bank of Saint Louis,](https://fred.stlouisfed.org/) and is updated automatically as new data becomes available.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1271,"value":"**Health spending**\n\nThe health versus debt spending chart uses data from the [WHO Global Health Expenditure Database](https://apps.who.int/nha/database).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1276,"value":"**Additional data and replication code**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1279,"value":"For more information, as well as all code to replicate all of our analysis, please visit this report's [GitHub repository.](https://github.com/ONEcampaign/interest_rates)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":125,"value":"

\n\n---\n

\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1070,"value":"## Notebook tools","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1072,"value":"This section contains the functions, imports and data used to create the different visualisations in this notebook.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1074,"value":"### Required packages","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":135,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":770,"value":"import { ToC } from \"@rmw4269/contents\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1076,"value":"### Functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1079,"value":"The `discountedPayments` function calculates the total interest payments due over the lifetime of loans, based on the chosen parameters.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":123,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1081,"value":"### Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1083,"value":"_`dataArray` contains the 'raw' data imported as an array._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":129,"value":"dataArray = FileAttachment(\"country_counterpart_with_weights_2016-21.csv\").csv({\n typed: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1085,"value":"_`countryAndGroupTable` contains the data as an Arquero table._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":140,"value":"countryAndGroupTable = aq.from(dataArray)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1088,"value":"_`expectedPaymentsInteractive` is a version of the data which changes as the user plays with the different parameters. It uses the `countryAndGroupTable`, together with the `discountPayments` function._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":152,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1098,"value":"_`healthDebt2020` contains data on health spending and debt service spending as a share of government spending._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":886,"value":"healthDebt2020 = FileAttachment(\"debt_health_2020.csv\").csv({ typed: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1090,"value":"### Helper 'facts'","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1093,"value":"The following are calculations based on the selected parameters, written as separate cells for convenient access.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":400,"value":"avgIBRDRate = d3.sum(\n dataArray\n .filter(\n (d) =>\n d.year == 2021 &&\n d.group_name == selectGroup &&\n d.counterpart_area === \"World Bank-IBRD\"\n )\n .map((d) => d.avg_rate)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":819,"value":"selectedCreditorRate = d3.sum(\n dataArray\n .filter(\n (d) =>\n d.year == 2021 &&\n d.group_name == selectGroup &&\n d.counterpart_area === selectCounterpart\n )\n .map((d) => d.avg_rate)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":877,"value":"selectedCreditorLending = d3.sum(\n dataArray\n .filter(\n (d) =>\n d.year == 2021 &&\n d.group_name == selectGroup &&\n d.counterpart_area === selectCounterpart\n )\n .map((d) => d.value_commitments)\n) / 1e9","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":830,"value":"selectedParametersDue2021newRate = expectedPaymentsInteractive\n .filter(\n (d) => d.year == 2021 && d.indicator == \"Expected Interest (at new rate)\"\n )\n .get(\"Interest\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":870,"value":"selectedParametersDue2021 = expectedPaymentsInteractive\n .filter((d) => d.year == 2021 && d.indicator == \"Expected Interest\")\n .get(\"Interest\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":618,"value":"yMax = d3.max(expectedPaymentsInteractive.column(\"Interest\").data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1104,"value":"### Other","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1106,"value":"The `` cells here are the Observable inputs used for the interest payments chart. They are detached because they are also referenced above inside a response `div`.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":155,"value":"viewof selectGroup = Inputs.select(\n Array.from(new Set(dataArray.map((row) => row.group_name))).sort(\n d3.ascending\n ),\n {\n label: \"Select a grouping\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"viewof selectCounterpart = Inputs.select(\n Array.from(new Set(dataArray.map((row) => row.counterpart_area))).sort(\n d3.descending\n ),\n {\n label: \"Select a creditor\",\n value: \"Bondholders\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":186,"value":"viewof discountRate = Inputs.range([0, 10], {\n label: \"Discount Rate\",\n step: 0.1,\n value: 5\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":372,"value":"viewof newInterest = Inputs.range([0, 12], {\n label: \"Select new interest rate\",\n step: 0.01,\n value: avgIBRDRate\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W38","stdlib":"1","titling":"auto"}} 32:"$31:body"