Data Visualization

Blog of the Data Visualization & Communication Course at OSB-AUB

This is my favorite part about analytics: Taking boring flat data and bringing it to life through visualization” John Tukey

Navigating the Storm: A Data-Driven Look at the 2007 Financial Crisis and Recovery Efforts

Navigating the Storm: A Data-Driven Look at the 2007 Financial Crisis and Recovery Efforts

 

Introduction:

In 2007, the world experienced a financial shockwave that originated from the U.S. housing market downturn. The crisis quickly rippled across global economies, with significant impacts felt in the U.S., U.K., and China. In this post, we’ll explore a comprehensive analysis of the crisis and the concerted policy responses that helped navigate these turbulent economic waters. Accompanied by insightful Tableau visualizations, we delve into the monetary and fiscal adjustments that shaped the path to recovery.

The Epicenter of the Crisis:

The 2007 financial crisis is a stark reminder of the interconnectedness of global markets. Starting in the U.S., the collapse of the housing bubble sent shockwaves that were felt in the U.K., a major financial hub, and China, the burgeoning economic powerhouse. The crisis highlighted vulnerabilities and sparked a global debate on economic safeguards. Our Tableau visualizations, which I’ll share throughout this post, bring to life the data behind these seismic economic shifts.

Economic Indicators in Turmoil:

GDP Growth Rate: The severe downturn in the U.S. and UK economies in 2009, with GDP growth plummeting to -2.60% and -4.51%, respectively, signified deep recessions. China’s maintenance of a 9.40% growth rate, despite a global slowdown, demonstrated the effectiveness of its economic policies and a less interconnected reliance on global financial systems.

Unemployment: The dramatic rise in U.S. unemployment to 9.25% in 2009 mirrored the harsh reality of the economic crisis’s impact on the labor market. The UK’s unemployment rate’s more moderate increase to 7.54% indicated a resilient but strained job market. China’s steady unemployment rate suggested a controlled labor environment, possibly cushioned by government-led initiatives.

Inflation and Deflation: The pivot to deflation in the U.S. and China in 2009 highlighted the breadth of the economic contraction, marked by plummeting consumer demand. The UK’s decreasing inflation rate, from its 2008 peak, nonetheless remained positive, reflecting persistent cost pressures despite a contracting economy.

Investor Sentiment and Market Response:

FDI: The UK’s steep decline in FDI following the crisis suggested capital flight and a significant erosion of economic confidence, a contrast to the U.S.’s more stable investment climate. China’s gradual FDI decline mirrored the broader cautious stance of global investors during the period of uncertainty.

Equity Markets: The UK and U.S. equity markets’ deep dives of -49.5% and -38.5% in 2008, along with China’s -52.7% plunge, captured the panic and rapid revaluation of future earnings potential, significantly affecting wealth and spending.

Monetary & Fiscal Adjustments: Navigating Through Economic Turbulence

The global financial crisis of 2007-2008 forced countries to reevaluate their monetary and fiscal strategies. Central banks across the world slashed interest rates, while governments ramped up borrowing to inject liquidity and stimulate economic activity. The graphs provided offer a glimpse into how China, the United Kingdom, and the United States adjusted their policies in the face of economic headwinds.

Monetary Policy Adjustments: A Dive into Negative Real Interest Rates
In response to the financial crisis, China, the UK, and the US adopted aggressive monetary policies, including steering real interest rates into negative territory to encourage borrowing and investment. This is particularly evident in 2009’s negative real interest rates.

China responded to the crisis by lowering its real interest rates from -0.260 in 2007 to -2.306 in 2008, indicating a decisive move to encourage spending and investment.
The UK followed a similar path, with real interest rates dropping from 3.106 in 2007 to -1.241 in 2009, reflecting a substantial monetary stimulus.
The US saw its real interest rates decrease from 5.207% in 2007 to 2.592 in 2009, as part of its strategy to revive the economy.

Fiscal Stimulus: The Path of Increased Government Debt
The fiscal response to the crisis was marked by an increase in government debt, as seen in the upward trend of central government debt relative to GDP. This increase is indicative of a commitment to boost economic activity through government spending.

The UK’s central government debt rose sharply from 93.63% in 2007 to 130.69% in 2010, a clear sign of significant fiscal intervention.
The US also saw its government debt climb from 63.82% in 2007 to 84.96% in 2010, as it took on more debt to stabilize the economy.
For China, although not displayed on the graph, the World Bank and IMF data show an increase in central government debt from 16.4% in 2007 to 33.5% in 2010, demonstrating China’s use of fiscal policy to maintain economic momentum.

Analyzing the Impact of Policy Adjustments on Economic Indicators:
Following these adjustments, we look at how they influenced key economic indicators. The equity markets in all three countries showed signs of recovery in 2010, with China’s market increasing by 8.2%, the UK’s by 12.8%, and the US’s by 13.6%. Such improvements in the equity markets typically reflect greater investor confidence, potentially buoyed by lower interest rates making equities more attractive compared to fixed-income assets.

In terms of foreign direct investment (FDI), there was a noticeable uptick in all three countries. China’s FDI as a percentage of GDP went up by 55.9%, the UK’s by an impressive 345.2%, and the US’s by 57.7%. The growth in FDI highlights the global improvement in investor sentiment and market confidence, likely influenced by the monetary easing and fiscal stimulus measures.

As for GDP growth, all three countries experienced positive changes. China continued its robust growth; the UK and the US both rebounded from negative growth rates in 2009 to positive rates in 2010. These changes underscore the effectiveness of the stimulus efforts, which aimed to encourage borrowing, spending, and overall economic activity.

Findings and Recommendations:

The economic data from the 2007-2008 financial crisis reveal that while aggressive monetary easing and fiscal stimulus were critical in mitigating the downturn, the recovery trajectory varied significantly across nations. The U.S. and the UK, with deep contractions in GDP and spiking unemployment, required robust policy responses to revive consumer confidence and stabilize financial markets. On the other hand, China’s proactive fiscal measures, particularly in infrastructure, helped sustain its economic momentum. Our findings suggest that future crises may demand even more nuanced and sector-specific policy interventions. For instance, targeted support for small businesses and industries most affected by a downturn could provide a more efficient path to recovery. Additionally, policies aimed directly at consumers, such as mortgage relief programs, could prevent a cascade of defaults and stabilize the housing market more rapidly. A collaborative international response, leveraging the strengths of interdependent global economies, could amplify the efficacy of such measures. Therefore, we recommend a framework for economic policy that emphasizes flexibility, targeted support, and global coordination to not only cushion against immediate shocks but also to lay the groundwork for sustainable, long-term growth.

Conclusion: Steering Through Economic Adversity

The financial crisis that shook the foundations of global economies in 2007-2008 also brought to light the critical role of proactive monetary and fiscal policies in navigating economic adversity. The United States, the United Kingdom, and China each faced unique challenges and responded with tailored strategies that reflected their economic philosophies and priorities. Despite the varied approaches, the shared objective was clear: to stabilize the financial system, stimulate growth, and restore confidence. The recovery of equity markets, the resurgence of foreign direct investment, and the gradual uptick in GDP growth by 2010 are a testament to the effectiveness of these interventions. This period of economic recalibration provided valuable insights into the intricate dance between government policy and economic health, insights that continue to shape economic strategies in our increasingly interconnected world.

 

 

The Lebanese Crisis: The Deterioration of the Lebanese Pound

The Lebanese Crisis: The Deterioration of the Lebanese Pound

Contributors: Haidar Noureddine, Christy BouMansour, Haya Mouakeh, Jennifer Sabra, Hanine Charanek, Mohamad Kanj

The Downfall of the Lebanese Lira

Abu Ali, a farmer living in Beqaa valley in Lebanon was facing problems with his apples crops after he was forced to cut the pesticides used because of the price increase after the Lebanese crisis.
He wasn’t sure how to protect his crops after he put a lot of effort during the year and now he is worried because he doesn’t have any source of income anymore.
Ibrahim Tarshishy, who is also a farmer in Beqaa valley, was not able to sell all his apple crops where half of them got moldy. “To be honest, I don’t expect the days ahead to be good. I see before us more depression, sadness and poverty”, said Ibrahim Tarshishy, a farmer in Riyak region, Lebanon”
Like these two cases, lot of farmers were facing like these problems, and no one was able to help them, and as we reach the conclusion of 2022, Lebanon’s financial woes are rapidly approaching the critical stage, and the Lira exchange rate is reaching a breaking record.

The Lebanese Lira exchange rate decreased because the supply for dollar was not enough to match the demand, and the central bank did not have enough reserves to interfere and match it with the demand. The demand for dollars was mainly driven by the aim to complete imports transactions. Since 2002, the net trade balance was negative, and the deficit was growing, reaching very high levels to around $14 Billion in 2014. This means that imports were higher than exports, and so the dollars outflow was bigger than the inflow.

To maintain the exchange rate fixed, as it was the case earlier, Lebanon used to depend on two main sources for dollars inflow, net transfers sources, and financial account source. First, Lebanon used to depend on transfers which includes grants, loans, and personal remittances. The graph below shows that net transfers were bringing a significant amount of dollars. However, this source is very unstable. It is very fluctuating, and it depends highly on uncontrolled factors like the help from other countries that we can not control as shown in the graph.

The financial account consists mainly of Eurobonds, and investments in companies, and currency & deposits coming from abroad into the Lebanese banks. As shown, this account was a huge source for dollar inflow. However, again, it is very unstable, and very fluctuating. There are almost no two similar points that are equal. Further, it depends highly on uncontrolled factors. For example, after Iraq invasion, so many Iraqis transferred their money into the Lebanese banks, and so the dollar inflow increased, but this happened because an event that we do not have control over it.

These two accounts together were balancing the dollar demand needed from the imports. In cases of mismatch between dollar supply and demand, the central bank used to interfere by buying or selling dollars in the market to keep the exchange rate fixed. However, in 2018, we had the second largest BOP deficit as shown below, which means the second largest dollar shortage, but the central bank did not have enough reserves which caused the current crisis.


In summary, the crisis started mainly in 2018. However, the root reason behind it is not the absence of reserves, but that Lebanon was depending mainly on unstable sources of inflow for foreign currencies, which was very risky, and unstable to maintain because of the fluctuations.

Solution


To further enrich Lebanon’s economy, we introduce our project that aims on focusing on sustainable economic development that relies on an integrated export system, naturally creating tons of job opportunities by enhancing Lebanon’s agricultural sector due to the presence of fertile land, abundant water resources, good weather conditions .
The project will control the process from harvesting to exporting, and starting with enforcing regulations that benefit the farmers instead of making it harder for them to export their goods, implementing technical guides that monitors farmers’ techniques into adopting good agricultural transactions, as well as adopting training workshops administered agricultural engineers also supplying them with the latest and greatest equipment that regulate water usage while limiting their use of unsustainable substances, such as harmful pesticides, and providing alternatives that are viable.

Saudi Arabia

Now, since Saudi Arabia is infamous for its totally dry lands and a central region that is characterized by extremely hot and dry summers, it harbors a very limited agricultural sector and thus heavily relies on importing olive oil as well as basic produce. We should make use of the current improving relationship between Saudi Arabia and Lebanon and prioritize exportation to this country due to the low and reasonable shipping fees.

1-Olive oil

The olive oil market in Saudi Arabia needs a lot of importation as a change in dietary habits throughout the entire country has spurred the consumption of it. Saudi Arabia started importing about 30,000 tons annually while only producing 20% of its own olive oil, but that’s slowly changing as it’s heading towards an independent olive oil market realm that’ll eventually decrease the exports. We won’t focus on increasing the imports from Lebanon but on decreasing the shipping and customs fees that were introduced in June of 2020.

2-Apples

As we mentioned above, a huge change in dietary habits and healthy eating have welcomed Saudi lifestyles, thus making produce, especially apples, way higher in demand. Lebanon exports apples to Saudi Arabia in relatively low quantities as opposed to other countries because of strict pesticide regulations. To increase the exports, we should introduce strict laws that modulate their usage.

3-Avocados

Lebanon’s avocado exports were totally banned in Saudi Arabia because of drug smuggling fiascos, which led the Saudi government to enforce harsh consequences that will only be salvageable by an examining process that helps avoid any trials of smuggling drugs.

Cyprus

Cyprus makes a great exporter as well, as it only holds 14.52% of agricultural land that is extremely affected by small temperature inconsistencies. Our focus on Cyprus is mainly due to the distance from Lebanon, which is only 26 kilometers, making it extremely easy for shipments to move within those countries.

1-Olive oil

The olive oil market in Cyprus is in a desperately high demand since the consumption of olive oil is three times greater than what the country produces. Because of this, we should encourage exports from Lebanon in a way that competes with both Germany and Spain, since they’re offering their olive oil at similar and lower prices.

2-Apples

Considering Cyprus is one of the most countries with apple shortage, it exports most of its apple supply excluding Lebanon from its exportations because of a heavily regulated pesticide system, solving that issue requires us introducing strict pesticide laws, after that we can start exporting to Cyprus at the same rate and price that we export to Turkey.

3-Avocados

Because of the free trade agreement between European countries, Lebanon is unable to compete equally with European countries at exporting avocados, yet we are able to compete with Egypt, which offers a lower price. To solve this, we can try and export at a lower price than Egypt.