<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Arinze Anyaeche on Medium]]></title>
        <description><![CDATA[Stories by Arinze Anyaeche on Medium]]></description>
        <link>https://medium.com/@arinzeanyaeche?source=rss-eb6f00eeb3e------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*-QxWpBGVgGKCriqr.</url>
            <title>Stories by Arinze Anyaeche on Medium</title>
            <link>https://medium.com/@arinzeanyaeche?source=rss-eb6f00eeb3e------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Mon, 16 Nov 2026 22:36:16 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@arinzeanyaeche/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Evaluating Banks Using Discounted Cash Flow Model- Part 1]]></title>
            <link>https://medium.com/@arinzeanyaeche/evaluating-banks-using-discounted-cash-flow-model-part-1-12f22f20d004?source=rss-eb6f00eeb3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/12f22f20d004</guid>
            <category><![CDATA[value-investing]]></category>
            <category><![CDATA[economics]]></category>
            <category><![CDATA[analysis]]></category>
            <category><![CDATA[banking]]></category>
            <category><![CDATA[valuation]]></category>
            <dc:creator><![CDATA[Arinze Anyaeche]]></dc:creator>
            <pubDate>Fri, 05 Jul 2024 08:42:39 GMT</pubDate>
            <atom:updated>2024-07-05T08:42:39.702Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*2U1StvlH3i_GBw9S" /><figcaption>Photo by <a href="https://unsplash.com/@eduschadesoares?utm_source=medium&amp;utm_medium=referral">Eduardo Soares</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>This exploratory essay will be in two parts. This first part discusses the challenges of valuing a bank using the discounted cash flow model. This process is a bit different for valuing regular companies. This is because we have to consider leverage within a regular company. For banks, leverage is raw material so we have to overcome this challenge in the valuation. You are assumed to have a basic understanding of valuing companies using discounted cash flow models. If not, you can catch up via this excellent primer from Aswath Damodaran on YouTube (See Reference section). The second part uses an African Bank, United Bank of Africa Plc, as a case study to evaluate the model. We would also compare it to the market price to obtain critical insights to guide a potential investor.</p><p>Valuing banks has always been difficult for two key reasons. First, banks’ cash flows cannot be as quickly estimated as regular companies since capital expenditures, working capital and debt are not easily defined. Second, banks operate under a regulatory framework that governs how they are capitalized, where they invest and how fast they can grow. However, these restrictions do not make it impossible to do a discounted cash flow on banks. This essay describes the process of using the discounted cash flow model to value a bank.</p><p>The discounted cash flow model requires estimations of cash flows, growth and risk to arrive at a company’s estimated value per share. The standard definitions of a regular company and a bank are different, and they have to be adjusted accordingly.</p><p><strong>1. Risk</strong></p><p>In a regular company, you ascertain risk by calculating a weighted average cost of capital. However, for a bank, equity is the only capital that should be assessed. Debt is raw material, not a source of capital. Thus, including debt in figuring out the cost of capital would not make sense.</p><p>You can assess the cost of equity as your benchmark for risk in two ways.</p><p><strong>A. Implied cost of equity</strong></p><p>Implied cost of equity = Return of Equity — Growth rate/ Price to Book Value of Equity+growth rate</p><p>You would use this method to assess risk if you have decided to buy a bank and want to find the most undervalued one.</p><p><strong>B. Capital Asset Pricing Model (CAPM)</strong></p><p>Cost of Equity = Risk-free rate (typically long-term government bond rate)+Beta(Market Risk Premium)</p><p>CAPM is the preferred model if you are sector-agnostic in your analysis and open to investing in any company.</p><p><strong>2. Cash Flows</strong></p><p>Cash Flows are Net Income minus Net Investments. For a bank, you ascertain Net investments by estimating the change in investment in regulatory capital. Change in investment in regulatory capital is total qualifying capital at the end of the year minus total qualifying capital at the beginning of the year. The next question would be, how do you determine the total qualifying capital? Total qualifying capital is the adequacy ratio multiplied by total risk-weighted assets.</p><p>Adequacy ratio = Total qualifying capital / Total risk-weighted assets</p><p>These are usually reported in the bank’s annual report. In summary, the risk-weighted asset is calculated based on Basel III and the central bank’s regulation divided by the qualifying capital given you the bank adequacy ratio set by the central bank regulation. For “Too big to fail” banks, central banks typically expect a more substantial adequacy ratio so they can absolve shocks better and not lead to a collapse of the financial system. The higher the risk-weighted asset, which is required for higher net income on average, the more investments the bank makes to meet qualifying capital requirements. The increase in qualifying capital in the year forms the basis of net investments.</p><p><strong>3. Growth</strong></p><p>You need growth to ascertain the company’s terminal value at a steady state. At a steady state, you typically assume that the company will grow at the expected long-term growth rate of the economy. If it grows faster than that rate, the company will be larger than the economy, which would not make sense.</p><p>Once you ascertain these key elements, the process remains the same as that of a regular company. Part two, which follows, uses a case study to show how these mechanisms work in context to arrive at a value per share for an African bank. Such evaluation can help create a more robust analysis together with the dividend discount model.</p><p><strong>Reference</strong></p><p>Damodaran, A. (2015). Valuation [Online playlist]. Youtube. <a href="https://www.youtube.com/playlist?list=PLUkh9m2BorqnKWu0g5ZUps_CbQ-JGtbI9%5B1">https://www.youtube.com/playlist?list=PLUkh9m2BorqnKWu0g5ZUps_CbQ-JGtbI9[1</a>]</p><p>Damodaran, A. (2016, October 4). Deutsche Bank: A Greek Tragedy at a German Institution? [Video]. YouTube. <a href="https://www.youtube.com/watch?v=dXhAGTSMlF0&amp;t=813s&amp;pp=ygUXZGFtb2RhcmFuIGRldXRzY2hlIGJhbms%3D%5B1">https://www.youtube.com/watch?v=dXhAGTSMlF0&amp;t=813s&amp;pp=ygUXZGFtb2RhcmFuIGRldXRzY2hlIGJhbms%3D[1</a>]</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=12f22f20d004" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Evaluating a Bank Using Discounted Cash Flow Model- Part 2]]></title>
            <link>https://medium.com/@arinzeanyaeche/evaluating-a-bank-using-discounted-cash-flow-model-part-2-87ad9d58c748?source=rss-eb6f00eeb3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/87ad9d58c748</guid>
            <category><![CDATA[valuation]]></category>
            <category><![CDATA[analysis]]></category>
            <category><![CDATA[africa]]></category>
            <category><![CDATA[banking]]></category>
            <category><![CDATA[economy]]></category>
            <dc:creator><![CDATA[Arinze Anyaeche]]></dc:creator>
            <pubDate>Wed, 03 Jul 2024 05:14:02 GMT</pubDate>
            <atom:updated>2024-07-05T16:29:04.984Z</atom:updated>
            <content:encoded><![CDATA[<p>United Bank of Africa Plc: A DCF-Based Valuation Study as at 12 April 2024</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/290/1*9JV0AP1HtULaHGgOGVkSqw.png" /></figure><p><strong>1. Executive Summary</strong></p><p><strong>Purpose of the Analysis</strong>: This discounted cash flow analysis aims to estimate the true value of United Bank of Africa Plc. It will determine if the stock is fairly valued, overvalued, or undervalued.</p><p>- <strong>Company Overview</strong>: United Bank for Africa Plc (UBAP) provides banking and related financial solutions. The bank’s main activities include corporate, commercial, and retail banking. They also include SME, consumer, and personal banking.</p><p><strong>Key Findings</strong>: United of Africa Plc’s intrinsic value is 29.24 naira per share based on the discounted cash flow model. This is above its market value of 26.30 naira per share on 12 April 2024. This indicates that the company is undervalued by about 10%.</p><p><strong>2. Introduction</strong></p><p>- <strong>Scope of the Analysis</strong>: This analysis covers a ten-year forecast period of 2024 to 2033. Central Bank of Nigeria (CBN) policy would require all banks in Nigeria to recapitalise by 2026.</p><p><strong>Methodology:</strong> The DCF method involves projecting free cash flows for ten years. You then discount them to present value using the cost of equity. Finally, you add a terminal value to find the cost of equity.</p><p><strong>3. Financial Overview</strong></p><p>- <strong>Historical Financial Performance</strong>: UBA’s gross revenue hit 1.78 trillion Naira, with a profit after tax of 609.7 billion Naira. Deposits grew by 95%, from 9 trillion to 18 trillion Naira in just one year. Their loan book expanded by 74%, reaching about 6 trillion Naira.</p><p>The bank’s total assets have grown to 20.65 trillion Naira, and shareholders’ funds have increased to 2.03 trillion Naira. However, it’s not all smooth sailing. The non-performing loans (NPL) ratio rose to 5.8%, and the bank made a provision for credit losses of over 144 billion Naira. UBA plans to raise more capital through rights issues, private placements, and public offerings. They want to ensure future growth despite these challenges.</p><p><strong>Future Plans: </strong>UBA continues its strong performance. It will do this by focusing on customer service, investing in youth, and growing strategically in many places. Deposits and loan books grew a lot. This shows strong customer trust and business growth. UBA’s proactive approach to cybersecurity is crucial in protecting against increasing digital threats. The bank focuses on critical sectors. These include agro-processing and pharmaceuticals. This focus aligns with Africa’s economic needs. UBA’s international presence strengthens its position as a leading financial institution in Africa. The planned capital raise through various methods ensures the bank’s readiness for future growth.</p><p><strong>4. Total Risk-weighted Assets</strong></p><p>Total Risk-weighted assets were 5.4 trillion in 2023 (see Appendix 1 and appendix 3). We assume UBA is a mature business. It will continue to grow its risk-weighted assets at 22.74% (see appendix 3). This rate is the average of the last seven years.</p><p><strong>5. Total Qualifying Capital</strong></p><p>Total qualifying capital is the product of Total Risk-weighted assets and Regulatory Capital adequacy Ratio. We assume that because of the capital required to be raised by the CBN, UBA would have an elevated capital adequacy ratio in 2024 and 2025. After the raise has been concluded, the ratio would normalise back to the average rate of 25%.</p><p><strong>6. Book equity and Return of Equity</strong></p><p>We expect book equity to keep rising. First, it will rise to meet the new capital requirement in 2024 and 2025. Then, it will rise to meet the capital adequacy ratio from 2026 on.</p><p>As a mature company, we expect United Bank for Africa Plc to continue to earn a very strong 25% return on equity. However, we think the 2023 return on equity of 29.93% is not sustainable. It mostly came as a result of gains in mark-to-market revaluations. This likely resulted from a very rapid currency depreciation in 2023.</p><p><strong>7. Free Cash Flow Projections</strong></p><p>A bank’s free cash flows are defined as Net Income — net Investments. Net Income is the Return on Equity divided by Book Equity.</p><p>Net Investment = Investment in Regulatory Capital</p><p>See Appendix 1 for the detailed free cash flow projection for the ten years.</p><p><strong>8. Discount Rate</strong></p><p>We used the Capital Asset Pricing Model to ascertain the cost of equity of 30.6%.</p><p>Risk-free rate — Yield on long-term government bond = 19.55%</p><p>Beta — 0.7125</p><p>Market Risk Premium — 15.57%</p><p><strong>9. Terminal Value</strong></p><p>- <strong>Terminal Growth Rate</strong>: The terminal growth rate is assumed to be 3.32%, reflecting the Nigerian economy’s long-term growth prospects.</p><p>- <strong>Calculation of Terminal Value</strong>: See Appendix 1</p><p><strong>10. Valuation</strong></p><p>- <strong>Present Value of Cash Flows</strong>:</p><p>Present Value of Free Cash Flows: 885 billion Naira</p><p>Present Value of Terminal Value: 114 billion Naira</p><p>The sum of present value of Cash Flows: 1 trillion Naira</p><p>Number of outstanding shares: 34.2billion</p><p>Value per share- 29.24 naira</p><p>- <strong>Sensitivity Analysis</strong>:</p><p>Sensitivity Analysis is based on the growth rate of the total risk-adjusted assets, which drives the whole valuation.</p><p>The base case used an average rate of growth based on the past seven years, which gives us a value of 29.24 naira per share.</p><p>Another scenario uses the median rate of growth for the past seven years, which is 9.03%. By growing its risk-adjusted weighted assets by 9.03%, the value increases to 35.82 naira per share (See appendix 2). The analysis shows that UBA can raise its equity value in the future by managing risk better.</p><p>- <strong>Valuation Range</strong>: We expect the intrinsic value to range from 29.24 naira per share to 35.82 naira per share.</p><p><strong>11. Limitations of this analysis</strong></p><ol><li>A better understanding of the company’s strategy plans and expected industry growth would have made this analysis more robust.</li><li>This analysis is based on the date the 2023 results were published. This report has not considered any additional information in the market after 12 April 2024.</li></ol><p><strong>12. Conclusion</strong></p><p>- <strong>Summary of Valuation</strong>: United Bank of Africa Plc’s intrinsic value is estimated to be 29.24 naira per share, which is 10% above the market value on 12 April 2024.</p><ul><li><strong>Investment Recommendation</strong>: Based on this analysis, the United Bank of Africa is undervalued by 10%, suggesting a potential investment opportunity.</li></ul><p><strong>13. Appendix</strong></p><ol><li>Base case DCF Analysis</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IXp0Cj2LgFRxWsZ0tVJbtg.png" /></figure><p>2. Scenario case DCF Analysis</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fBCDoaw_uRhD3Ra4DM1D3A.png" /></figure><p>3. REGULATORY CAPTIAL ADEQUACY RATIO FROM 2017–2023</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*iYExQlb_Ov8AB-C-PMdnpA.png" /></figure><p>4. INFORMATION ON DIVIDEND, RECURRING INCOME AND RETURN ON EQUITY 2017 TO 2023</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FmiiUgUGcTZvBLIC5F64iw.png" /></figure><p>14. References</p><p>UBA Annual Reports from 2017 to 2023 available at <a href="https://www.ubagroup.com/investor-relations/financial-results/annual-report/">https://www.ubagroup.com/investor-relations/financial-results/annual-report/</a></p><p>UBA Beta available at <a href="https://markets.ft.com/data/equities/tearsheet/summary?s=UBA:LAG">https://markets.ft.com/data/equities/tearsheet/summary?s=UBA:LAG</a></p><p>Market Risk Premium available at <a href="https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datacurrent.html">https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datacurrent.html</a></p><p>Nigerian 10 year government bond yield at <a href="https://www.worldgovernmentbonds.com/bond-historical-data/nigeria/10-years/">https://www.worldgovernmentbonds.com/bond-historical-data/nigeria/10-years/</a></p><p>Nigeria long term growth rate at <a href="https://www.statista.com/statistics/382360/gross-domestic-product-gdp-growth-rate-in-nigeria/">https://www.statista.com/statistics/382360/gross-domestic-product-gdp-growth-rate-in-nigeria/</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=87ad9d58c748" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Why Every Reader Should Also Be a Writer]]></title>
            <link>https://medium.com/@arinzeanyaeche/why-every-reader-should-also-be-a-writer-bf095d8d7497?source=rss-eb6f00eeb3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/bf095d8d7497</guid>
            <category><![CDATA[read]]></category>
            <category><![CDATA[writing]]></category>
            <category><![CDATA[storytelling]]></category>
            <category><![CDATA[learning]]></category>
            <dc:creator><![CDATA[Arinze Anyaeche]]></dc:creator>
            <pubDate>Sat, 29 Jun 2024 22:01:09 GMT</pubDate>
            <atom:updated>2024-06-29T22:01:09.840Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*osWptoRh9pV5NVTM" /><figcaption>Photo by <a href="https://unsplash.com/@nickmorrison?utm_source=medium&amp;utm_medium=referral">Nick Morrison</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Have you ever wondered why writing feels like a chore? What if I told you it’s the key to unlocking more profound understanding and fixing knowledge gaps? Writing is more than a skill for passing exams or completing work tasks. It’s crucial for learning and creating new knowledge. I am not a natural writer. I prefer reading and learning. Writing has always seemed too tedious. But, I have had to rethink the purpose of writing in my learning journey.</p><p><strong>The Yin and Yang of Reading and Writing</strong></p><p>Reading and writing are complementary skills that enhance our comprehension and critical thinking. Writing is the yin to reading’s yang. Several academic studies have shown that writing is as much a thinking tool as reading. You can see a few of these studies in the reference section. Also, writing should test your logic and reasoning. For instance, instead of summarizing a book’s plot, an essay or mini-essay can encourage us to reflect on the book. Such reflection challenges us to explore the book’s themes. In addition, we are more thoughtful of the main character’s motivations and the broader implications of the ideas explored. This process encourages more profound engagement with the material. Readers who write think more about what they are reading and focus on the value of the writing they consume. For instance, a reader who writes about climate change might evaluate the arguments presented on both sides. Then, compare the arguments to other sources and form a well-rounded opinion on climate change.</p><p><strong>The Responsibility of Readers to Write</strong></p><p>Thus, as readers, we are responsible for preserving ideas for our future selves or others to gain value in creating their ideas. For example, Charles Darwin meticulously documented his observations and thoughts in his notebooks. These later formed the foundation for his theory of evolution. This process enhances our understanding of both ourselves and others.</p><p><strong>Creating New Knowledge</strong></p><p>Furthermore, new knowledge is created at the intersection of old ideas. Many breakthroughs result from combining existing ideas in novel ways. For instance, the development of the Internet involved various preexisting technologies such as telecommunications, computing, and hypertext systems. You see this in all areas of knowledge, from mathematics to artificial intelligence.</p><p><strong>Active Reading</strong></p><p>Finally, as an active reader who writes, you always consider why any writing you read is valuable to you. What other ideas have you come across in the past that connect to that piece of writing? What personal experience supports or opposes the key takeaway of the writing you are reading? What are your opinions? For example, a reader who writes an essay on overcoming adversity could reflect on their challenges. How have they overcome or planned to overcome the challenges? What are their insights on the subject? The process of writing can be priceless to the reader. Everyone has a unique skill set and experiences that make up their unique voice. Actively writing helps you think critically about your reading instead of mindlessly consuming useless content.</p><p><strong>Conclusion</strong></p><p>Writing is thinking, forcing you to move from spark to remark consistently and effectively. Just write about 500 words on any subject that interests you. What are you waiting for? Pick up your pen or open your laptop today. Share your thoughts, pen your understanding for your benefit, and contribute to the world’s knowledge.</p><p><strong>Further Reading</strong></p><p>Zinsser, W. (1993). Writing to Learn. New York: Harper &amp; Row, Publishers. Chicago: Bank Marketing Association, Homewood, IL: Dow Jones-Irwin.</p><p><a href="https://www.msudenver.edu/writing-center/faculty-resources/writing-as-a-thinking-tool/">https://www.msudenver.edu/writing-center/faculty-resources/writing-as-a-thinking-tool/</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=bf095d8d7497" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Marrakesh Unveiled: A Comprehensive Guide to the Enchanting Red City]]></title>
            <link>https://medium.com/@arinzeanyaeche/marrakesh-unveiled-a-comprehensive-guide-to-the-enchanting-red-city-94e00388ae41?source=rss-eb6f00eeb3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/94e00388ae41</guid>
            <category><![CDATA[travel]]></category>
            <category><![CDATA[travel-tips]]></category>
            <category><![CDATA[money]]></category>
            <category><![CDATA[africa]]></category>
            <category><![CDATA[self]]></category>
            <dc:creator><![CDATA[Arinze Anyaeche]]></dc:creator>
            <pubDate>Thu, 11 May 2023 04:15:13 GMT</pubDate>
            <atom:updated>2023-05-11T04:15:13.524Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bs-uhLWu0DiPCT3ANoU7ow@2x.jpeg" /></figure><p>I recently returned from an absolutely unforgettable journey to Marrakesh, and I’m beyond excited to share my experiences and insights with you. If you haven’t considered visiting this gem of a city, I’m about to give you a plethora of reasons to add it to your must-visit list.</p><p>First, let’s talk about the ideal time to explore Marrakesh. Spring (March-May) and fall (September-November) are perfect, offering comfortable temperatures between 70°F and 85°F (21°C to 29°C) and fewer tourists crowding the attractions. While you can still visit during the hotter summer or cooler winter months, be prepared for more extreme temperatures and adjust your plans accordingly.</p><p>So, what makes Marrakesh so enchanting? Let me dive into some highlights from my trip:</p><p>1. Timeless Charm: Marrakesh is steeped in history, culture, and tradition. The stunning architecture and vibrant mix of Berber, Arab, and French influences create an atmosphere that’s truly one-of-a-kind. Did you know that the city’s name is linguistically connected to the name of the country, Morocco? Marrakesh played a significant role in shaping the country’s identity and even influenced how Europeans referred to the region.</p><p>2. Architectural Marvels: I was continually awestruck by the city’s gorgeous buildings, like the Bahia Palace, Koutoubia Mosque, and Ben Youssef Madrasa. The attention to detail in the intricate tile work, stucco, and wood carvings is absolutely breathtaking.</p><p>3. Culinary Delights: Marrakesh is a food lover’s dream, boasting a variety of delectable traditional dishes like tagines, couscous, and pastilla. I savored every meal, whether it was in a local riad or a bustling street-side café.</p><p>4. Day Trip Adventures: The city’s prime location serves as an excellent base for exploring nearby attractions. Personally, I visited the beachside city of Essaouira, which is a popular surfing spot. However, you can also venture to the Atlas Mountains, Agafay Desert, or the ancient city of Ait Benhaddou for a memorable excursion.</p><p>5. The Red City’s Beauty: Marrakesh is not only bustling and vibrant but also boasts red-colored buildings, lush gardens, and vibrant flowers that create a picturesque backdrop for your adventures. The city takes great pride in its natural beauty, and it’s illegal to cut down trees within its boundaries.</p><p>Now that I’ve painted a picture of Marrakesh’s charm, let’s discuss how to make your trip authentic and unforgettable:</p><p>1. Hire a Licensed Tour Guide: A local guide will truly elevate your experience. My guide charged 60 euros per day, but their insider knowledge, advice, and personalized touch were worth every penny. They can help with everything from monument visits, shopping tips, avoiding tourist traps, or advising on day trips tailored to your interests and so much more. Mine organised a french class for me.</p><p>2. Choose Central Accommodations: Opt for lodging near the Medina to easily access the city’s vibrant heart. I stayed at Hotel Jaladi and loved it, but there are plenty of options for all budgets and preferences.</p><p>3. Embrace Haggling: Bargaining is part of the Marrakesh experience, so enjoy it! Aim for around 20% off the initial asking price, but don’t be afraid to negotiate even further. I managed to score a beautiful rug for my home at 50% off!</p><p>4. Budget for Surprises: You never know what amazing deals you might find, so make sure to have some extra funds on hand for unexpected treasures. Trust me; you don’t want to miss out on a fantastic find just because you didn’t plan for it.</p><p>5. Experience a Moroccan Hammam: This soothing body treatment is an absolute must-try. I enjoyed mine at the Mandarin Oriental, but there are plenty of options to choose from. It’s a luxurious way to unwind and immerse yourself in Moroccan culture.</p><p>6. Learn Some Basic Phrases: Knowing a few words and phrases in Arabic or French can go a long way in enhancing your experience. Locals will appreciate your effort, and it’ll make navigating the city even more enjoyable.</p><p>7. Get a Local Outfit: Embrace the local fashion by purchasing a traditional Moroccan outfit. This is not only a fun way to immerse yourself in the culture but also a unique souvenir to bring back home. I wasn’t able to get exactly what I wanted in the shop my tour guide took me to but they were able to get one ready for me in four days so if you are very tall like me or you have a unique request, you would want to plan ahead of time so its ready before you leave. However, this should not prevent you from haggling.</p><p>8. Explore Unique Activities: With so much to see and do around Marrakesh, make sure to venture out and try something new. From quad biking in the palmeraie of Marrakesh and paragliding to surfing in Essaouira or experiencing Berber life in the Atlas Mountains, there’s an adventure for everyone.</p><p>9. Indulge in a Night at Mandarin Oriental: Although it’s on the pricier side, the Mandarin Oriental Marrakesh is an experience like no other in Africa. With breathtaking views, stunning architecture, and exceptional service, it’s well worth splurging for at least one night. Plus, the hotel offers complimentary pick-up and drop-off services, making your stay even more hassle-free.</p><p>Marrakesh is a magical destination that should be on every traveller’s radar. With its rich history, stunning architecture, delicious cuisine, and the multitude of experiences it offers, there’s no doubt that you’ll fall in love with the enchanting Red City. So pack your bags, and get ready for the adventure of a lifetime.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=94e00388ae41" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[ The Ultimate Guide to Launching Your Own Viral Blogging Website ]]></title>
            <link>https://medium.com/@arinzeanyaeche/the-ultimate-guide-to-launching-your-own-viral-blogging-website-f442e98c208d?source=rss-eb6f00eeb3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/f442e98c208d</guid>
            <category><![CDATA[writing]]></category>
            <category><![CDATA[website]]></category>
            <category><![CDATA[business]]></category>
            <category><![CDATA[blog]]></category>
            <category><![CDATA[self]]></category>
            <dc:creator><![CDATA[Arinze Anyaeche]]></dc:creator>
            <pubDate>Wed, 03 May 2023 06:09:12 GMT</pubDate>
            <atom:updated>2024-06-29T22:09:32.735Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mKMOdrjgbDcbMLrBjidIDw.jpeg" /></figure><p>Ever dreamt of having your own blogging website? A space where you have complete control over your content, monetization, and professional online presence? Look no further! Follow these five simple steps to create a jaw-dropping website that’ll turn heads and keep readers coming back for more.</p><p><strong>Claim Your Digital Real Estate 🌐</strong></p><p>Start by purchasing a unique domain name from a registrar like Namecheap, GoDaddy, or Porkbun, usually for less than $10. But don’t forget to consider long-term costs! Up your professional game with a free email account from Zoho Mail, offering up to five free emails with 5GB per user. Setup is a breeze with this fantastic walkthrough</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FxdGG-9aKq74%3Fstart%3D1225%26feature%3Doembed%26start%3D1225&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DxdGG-9aKq74&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FxdGG-9aKq74%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/19191bfd435a4cb75a617da3c7aa90a7/href">https://medium.com/media/19191bfd435a4cb75a617da3c7aa90a7/href</a></iframe><p><strong>Pick the Perfect Platform 🖥️</strong></p><p>WordPress might be a popular choice, but why not try Ghost? This open-source, professional publishing platform is built on modern Node.js technology, specifically designed for bloggers and newsletter enthusiasts. Enjoy more control, a cheaper path to monetization, and an easier setup experience with the $9 per month plan. Say goodbye to plugin complexity and malware concerns!</p><p><strong>Dress Your Website to Impress 👗</strong></p><p>Now that you’ve chosen Ghost, select a stunning theme from the Ghost marketplace, Github, or Themeforest. Make sure it’s optimized for speed, SEO, and aligns with your brand. Psst… some hidden gems on Github include Biron</p><pre>https://github.com/bironthemes/biron-ghost-theme</pre><p>and Massively</p><pre>https://github.com/TryGhost/Massively</pre><p>Not a techie? Check out this excellent walkthrough on setting up for the first time on Ghost</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FYVakhK8UOWs%3Fstart%3D1641%26feature%3Doembed%26start%3D1641&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DYVakhK8UOWs&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FYVakhK8UOWs%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/42698a0dc6a3a54a3afb4a4a8ecba746/href">https://medium.com/media/42698a0dc6a3a54a3afb4a4a8ecba746/href</a></iframe><p><strong>Migrate Your Masterpieces 📚</strong></p><p>Already on Medium? No worries! Ghost has a built-in importer tool that makes content transfer a breeze. You can also install Python and Pip then use the Medium-to-Ghost importer tool.</p><pre>https://github.com/ageitgey/medium_to_ghost</pre><p>Just ensure your content is formatted perfectly for the new platform and read the easy-to-follow ReadMe.</p><p><strong>Shout It from the Rooftops 📣</strong></p><p>Get your website noticed with social media and email marketing. Engage with readers, build a loyal community, and optimize your site for SEO by focusing on keyword research, descriptive titles, meta descriptions, quality backlinks, alt tags, and regularly publishing top-notch content.</p><p>🌟 Voila! 🌟 Your jaw-dropping website is ready to take the world by storm! Use Medium and Ghost together as part of a fantastic business plan to grow and nurture your audience. Embrace the rewarding experience of creating your own blogging website and elevate your writing game today!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f442e98c208d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[HISTORY OF MONEY IN NIGERIA]]></title>
            <link>https://medium.com/@arinzeanyaeche/history-of-money-in-nigeria-515f536e1868?source=rss-eb6f00eeb3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/515f536e1868</guid>
            <category><![CDATA[fiat]]></category>
            <category><![CDATA[nigeria]]></category>
            <category><![CDATA[money]]></category>
            <category><![CDATA[history]]></category>
            <category><![CDATA[nigerian-economy]]></category>
            <dc:creator><![CDATA[Arinze Anyaeche]]></dc:creator>
            <pubDate>Sat, 05 Nov 2022 08:07:00 GMT</pubDate>
            <atom:updated>2022-11-05T08:07:00.250Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Silver Shillings from British West Africa" src="https://cdn-images-1.medium.com/max/1024/1*8PWehOIOewSudb1PNHp9nA.jpeg" /><figcaption>Silver shilling coins were minted for British West Africa in the second decade of the 20th century. By the third decade, the shilling coins were made of brass.</figcaption></figure><p><strong>Introduction</strong></p><p>Before the colonisation of the area referred to as Nigeria, the means of exchange in Nigeria were cowries, beads, bottles, farm produce, and so on. Up until 1958, Nigeria used the British West African pound along with Ghana, Sierra Leone and the Gambia. After the establishment of the Central Bank of Nigeria (CBN) in 1958, the CBN started issuing Nigeria’s currency. First, the Nigerian pound, shillings and penny from 1958 to 1972 and then the Nigerian Naira and Kobo from 1973 onwards. The pound was divided into 20 shillings, each shilling made of 12 pence. The Nigerian pound (at parity with the British pound sterling with free convertibility) was replaced with the Nigerian Naira on 1st January 1973 at a rate of £1 = ₦2. This made Nigeria the last country to abandon the £sd currency system while also introducing a currency that started life with devaluation.</p><p>On 1st January 1973, the Nigerian Naira was introduced. The new currency replaced the Nigerian pound with an exchange rate of 2 Naira to 1 pound in the United Kingdom and 1 Naira to 60 cents in the United States of America. However, as of today (31st October 2022), 1 British pound exchanges for 865 Naira while 1 US dollar exchanges for 807 at the parallel market. As Nigeria’s Federal Commissioner of Finance, Chief Obafemi Awolowo coined the name Naira by collapsing the word Nigeria. In contrast, Kobo arose from the word copper because Nigeria’s coins were then made of copper. Awolowo’s portrait adorns the 100 Naira notes. This article serves as a brief history of Nigeria through its money.</p><p><strong>Colonial Nigeria as a part of British West Africa</strong></p><p>Before decimalisation day- 15th February 1971, the British were not on a base ten currency system as it is today, whereby 100 pence make a pound). Before that date, the British followed a medieval currency system that revolved around a pound, shilling and penny. A pound sterling represented a pound of sterling or silver. A shilling (meaning the shaving off of bits of silver to make it easier to carry) with 20 shillings making a pound. Finally, a penny with 12 pence making a shilling or 240 pence making a pound. So for hundreds of years, people living in Britain and its territories had to work with this convoluted system of base 12 for pence, then base 20 for shillings, then base 10 for pounds to handle money. Nigeria was no different.</p><p>The first significant currency issued in Nigeria was undertaken sequel to the colonial ordinance of 1880, which introduced the Shillings and Pence as the legal tender currency in British West Africa. The units of coins managed by the Bank of England were one shilling, one penny, 1/2 penny and 1/10 penny. They were distributed by a private bank, the Bank for British West Africa, till 1912.</p><p>In 1912, the authorities in London set up the West African Currency Board (WACB). They issued a distinctive set of sterling coinage for British West Africa. The reason was a tendency for standard sterling coins shipped to the West African territories to leave the region and return to circulation in the UK. This caused a local shortage of coinage in British West Africa. Thus, the unique British West African variety of sterling coinage would not be accepted in the shops of Britain and so would remain in circulation locally.</p><p><strong>Independence wave across Africa</strong></p><p>In 1958, local national currencies began to replace the British West African pound in the individual territories.</p><p>On 1st July 1959, the Central Bank of Nigeria (CBN) issued Nigerian currency banknotes, while the WACB-issued banknotes and coins were withdrawn. It was not until 1st July 1962 that the currency was changed to reflect the country’s republican status. The banknotes which bore the inscription,’ FEDERATION OF NIGERIA ‘, now had, ‘FEDERAL REPUBLIC OF NIGERIA’, inscribed at the top. The notes were again changed in 1968 following the misuse of currency banknotes during the Nigerian civil war.</p><p><strong>Republic of Biafra</strong></p><p>The republic of Biafra was a state in West Africa that existed from May 1967 to January 1970. It was made up of the states in the eastern region of Nigeria. The population of Biafra was estimated in 1967 to be 13.5 million. The capital city of Biafra was Enugu in 1967, Umuahia from 1967 to 1969, Owerri from 1969 to 1970 and Awka in 1970. The Biafran pound was the currency of the breakaway republic of Biafra between 1968 and 1970.</p><p>The country coins were in 3 pence, 6 pence, 1 shilling, 2 ½ Shilling, 1 Crown and 1 pound. It also had notes in 1 pound, 5 shillings, 10 shillings, 5 pounds and 10 pounds.</p><p><strong>Post War Nigeria</strong></p><p>The government decided to change to a decimal system (decimalisation), of which Nigeria was the last former British colony to do so. The name of the Nigerian currency was changed on 1st January 1973. The major units of currency which used to be one pound, ceased to exist. 1 Naira, equal to 10 shillings or half a pound, became the major currency unit. While the Kobo became the minor units with a hundred Kobo making one Naira. As stated earlier, the name Naira was coined from the name Nigeria by the then Federal Commissioner of Finance, Chief Obafemi Awolowo. In contrast, Kobo was born from the English word copper because Nigerian coins were made of copper. At the introduction of the Naira, the coins were ½ Kobo, one Kobo, five Kobo, ten Kobo and 20 Kobo, while the notes were 50 Kobo, 1 naira, 5 naira and ten Naira.</p><p>On 11th February 1977, the new 20 naira banknote was issued. This was the highest denomination then. It was introduced according to the CBN due to the economic growth and the need for cash transactions. The 20 Naira was also the first banknote to have the portraits of a prominent Nigerian citizen on it — the murdered head of state, General Murtala Ramat Muhammad who led the 1966 Nigerian counter-coup in overthrowing the Johnson Aguiyi- Ironsi military regime. The 20 Naira notes were issued on the first anniversary of his assassination as a tribute to him and he was declared a national hero on 1st October, 1978. Interestingly, the 20 Naira notes remain the only Naira notes to have the portraits of a military man. The rest of the Naira notes bear the portrait of civilians.</p><p>Thereafter, new currency banknotes of three denominations, one Naira, five Naira, and ten Naira were introduced on 2nd July 1979. They were of the same size as the 20 Naira notes. To differentiate the denominations, different colours were used to identify them. These new notes also bore the portraits of prominent men. The one Naira notes featured the prominent politician Herbert Macaulay. The five Naira notes had Nigeria’s first and only prime minister, Sir Abubakar Tafawa Balewa portraits on them, and the ten Naira notes have the portraits of Nigerian statesman Alvan Ikoku. They were all declared national heroes on 1st October 1978. For easy identification, different colors were used for the various denominations. Also, distinct cultural aspects of the country were engraved at the back of the notes.</p><p>However, in April 1984, during the regime of Major General Muhammadu Buhari, all but the 50 kobo banknotes were changed in order to curb currency trafficking, which was rampant at the time. The same military leader now Nigeria’s president from 2015 to 2023 has decided again to change the bank notes for basically the same reasons. In 1991, the 50 Kobo and one Naira were changed to coins and the 50 naira note was introduced.</p><p>Due to expansion in the money supply, the 100 Naira note was released in December 1999 with a portrait of Chief Obafemi Awolowo, the 200 Naira in November 2000 with a portrait of Alhaji Sir Ahmadu Bello, the 500 Naira in April 2001 with a portrait of Dr Nnamdi Azikiwe, and the 1000 Naira in October 2005 with the portrait of the first two Nigerian head of the CBN (Alhaji Aliyu Mai Bornu and Dr Clement Isong) were introduced as banknotes.</p><p>As part of economic reforms on 28th February 2007, the 20 naira banknotes were issued for the first time in a polymer substrate. This note is more durable than paper by not becoming soaked in liquids and is harder to counterfeit. Also, the 50 Naira, 10 Naira and 5 Naira banknotes, along with the 1 Naira, 50 Kobo coins, were re-issued in new designs along with the introduction of the 2 Naira coin. Following the successful performance of the 20 naira banknotes, 50 Naira, 10 Naira and 5 Naira banknotes were converted to polymer substrate on 30th September 2009. As part of its contribution towards Nigeria’s 50th-anniversary independence celebration and the country’s 100 years of existence, the CBN issued a 50-Naira commemorative polymer substrate banknotes on 29th September 2010, and the 100-Naira commemorative banknotes on 19th December 2014, respectively.</p><p>On 26th October 2022, the Central Bank Governor called for a special briefing to inform the nation that in largest three denominations- 200 naira, 500 naira and 1000 naira notes will be redesigned in December of the same year with the plan to demonetise the old notes by the end of January 2023. Within days of the announcement, the naira fell sharply against the dollar.</p><p><strong>Conclusion</strong></p><p>In 1973, at the introduction of the Naira, one could sell 6 million Naira in exchange for $10 million. Then, a US dollar was equivalent to 60 Kobo. The same cannot be said in less than five decades as the Naira by 2022 has lost more than 99.8% of its value against the dollar by 2022. Note that the dollar in 2022 is much less valuable than the dollar in 1973. For context, the US dollar has lost 95% of its value by 2022 since the US Federal Reserve (CBN equivalent) was created in 1913. At the end of October 2022 (49 years later), $10 million could be exchanged for 8 billion Naira. The Naira has witnessed dozens of devaluations from its date of inception when it immediately became equal to half of a Nigerian pound. Most of these devaluations were implemented to achieve fair value for the currency. As Voltaire once said, paper money eventually returns to its intrinsic value- zero.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=515f536e1868" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Humans Have Never Had It So Good]]></title>
            <link>https://medium.com/@arinzeanyaeche/better-world-22878015a546?source=rss-eb6f00eeb3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/22878015a546</guid>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[life]]></category>
            <category><![CDATA[motivation]]></category>
            <category><![CDATA[africa]]></category>
            <category><![CDATA[inspiration]]></category>
            <dc:creator><![CDATA[Arinze Anyaeche]]></dc:creator>
            <pubDate>Tue, 30 Jun 2020 02:51:16 GMT</pubDate>
            <atom:updated>2020-07-01T11:44:10.809Z</atom:updated>
            <content:encoded><![CDATA[<h4>So much good is going on in the world and you can easily contribute</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*q_QDjtTadV7KuEHy" /><figcaption>Photo by <a href="https://unsplash.com/@douglinstedt?utm_source=medium&amp;utm_medium=referral">Doug Linstedt</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>There are a lot of terrible events happening in the world now and the last decade. This much is clear. Whenever you follow global events, you are much more likely to run into bad news than pleasant news. Take this year for instance- we are barely halfway into 2020 and significant events in the press among others have been-</p><p>1. The threat of a global war(first between the <a href="https://www.bbc.com/news/world-middle-east-52399283">US and Iran</a> and then between <a href="https://www.express.co.uk/news/world/1299518/world-war-3-china-news-india-latest-conflict-border-LAC-Galwan-Valley-xi-jinping-modi">China and India</a>) and the possibility of use of nuclear weapons.</p><p>2. The <a href="https://www.china-briefing.com/news/the-us-china-trade-war-a-timeline/">trade war between US and China</a>.</p><p>3. A global health pandemic is underway that is likely to redefine the way humans will live and work in years to come.</p><p>4. Diseases in Sub-Saharan Africa from the outbreak of <a href="http://outbreaknewstoday.com/nigeria-5-lassa-fever-cases-reported-last-week-41058/">Lassa Fever</a>, <a href="https://africa.cgtn.com/2020/06/06/women-hit-as-congo-faces-triple-threat-of-coronavirus-ebola-and-measles/https:/africa.cgtn.com/2020/06/06/women-hit-as-congo-faces-triple-threat-of-coronavirus-ebola-and-measles/">Ebola and Measles.</a></p><p>5. Ongoing humanitarian crises in the <a href="https://www.aft.org/our-community/immigration/humanitarian-crisis-us-border">Southern border of the United State</a>s, <a href="https://www.bbc.com/news/world-middle-east-53129564">Yemen</a>, <a href="https://www.economist.com/middle-east-and-africa/2020/06/20/bashar-al-assad-has-no-solutions-to-syrias-crisis">Syria</a> and <a href="https://www.bbc.com/news/world-latin-america-36319877">Venezuela</a>.</p><p>6. Natural disasters such as the Australian bush fires and earthquake in Puerto Rico.</p><p>7. Protests by large parts of the US and in the developed world on the way minorities, especially people of African descent, are treated by society.</p><p>In Nigeria where I live, there is an ongoing outcry this month on social media led by victims of<a href="https://twitter.com/seyitannn_/status/1268220336342020097"> rape</a> and <a href="https://twitter.com/anti_ratrace/status/1267920657557393417">sexual harassment</a>. The outrage has brought the rape and sexual harassment issues to the centre stage as there have been cases involving high profile Nigerians from music to business among others. Unfortunately, these are just a few of the <a href="https://qz.com/africa/1871793/nigerians-confront-rape-culture-crisis-after-dbanj-allegations/">thousands that go on in Nigeria</a> and around the world daily.</p><p>From the above, it seems clear that the world is going to shit and things are only getting worse. The media tends to focus on the adverse events going on which we can expect future generations to be ashamed of and rightly so. Some common issues would be-</p><p>1. Our treatment of animals(wild and domestic)</p><p>2. The millions of species that go extinct because of us</p><p>3. Income inequality</p><p>4.Geopolitical conflicts</p><p>5. Extreme poverty</p><p>6. Deforestation</p><p>7.<a href="https://allafrica.com/stories/202005150692.html">Xenophobia</a></p><p>8.The way we use energy and its effects on the climate</p><p>The issues seem to roll off the tongue and you could certainly come up with many more. The media has missed communicating the positives, probably terming them as mundane in the scheme of things. It’s easier for us to consume the sensational and the unusual rather than the mundane and regular.</p><p>Progress is usually a process and on some key issues facing humanity, we are on the right track. We have to own the good and the bad in the world we live in for ourselves and future generations.</p><p>We can choose to educate ourselves on a balanced world view. We can help balance the scales by reducing the problems in the world through a focus on activism. We can also help to increase the good mundane things by contributing to causes that reduce inequality and makes the world a better place for everyone.</p><p>This post focuses first on the progress in recent decades via three pillars- Our fight against extreme poverty, improvements in global health and our adoption of technology. Second, it suggests actions that we can take to push long term progress.</p><h3>The Fight Against Extreme Poverty</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*jyiNFqD6Vg9bD9JO" /><figcaption>Photo by <a href="https://unsplash.com/@hcmorr?utm_source=medium&amp;utm_medium=referral">Hanna Morris</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><blockquote>Extreme poverty has nearly halved in just 20 years. Most experts believe that we can eradicate extreme poverty completely by 2030.</blockquote><p>Let’s start with the chart below. Extreme poverty had declined significantly from around 2 billion in 1990 to about 800m in 2015 and it is still falling.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*y6bVNJCW-I5rwS3X_xo-kw.png" /></figure><p>The world bank defines extreme poverty as survival on less than $1.90 a day. Admittedly a lot of remains to be done as the chart above shows. However, current levels of extreme poverty as a proportion of the global population are unprecedented in human history. We have clearly made a lot of strides in eliminating extreme poverty from the world. The improve in global living standards is self-evident in <a href="https://ourworldindata.org/a-history-of-global-living-conditions-in-5-charts">many statistics that are not well known</a>. The number of children (5years and below) that die annually has halved from <a href="https://data.unicef.org/topic/child-survival/under-five-mortality/">10m in 2000 to around 5m today</a>. Child mortality alone has tremendously changed most of the developing world as a result of improved access to necessary immunizations. In most of the developing world, the number of children per household has reduced in a generation.</p><p>Based on my personal experience as a Nigerian growing up in Lagos, 4–7 children per household used to be the norm. However, in current times, 2–3 children per household is the new normal. The survival rate of children has increased dramatically over the years. The rise of smaller families in developing countries could be attributed to a reduction in gender inequality as more women marry later in life in the quest for academic pursuit and a stable income source to support their families. This, in turn, allows low-income families a better chance to move up the economic ladder.</p><p>Also, much more research has focused on tackling extreme poverty in recent decades. This new focus of economic research is exemplified by Abhijit Banerjee, Esther Duflo and Michael Kremer, the 2019 Nobel Peace Prize winners in Economics. Their work has focused on the use of randomised control trials as a scientific method to tackle global poverty. Randomised control trials allow a researcher to test in the field the intuitions of experts on the most effective ways to help the poor. This scientific approach to tackling poverty has allowed for more money into the most effective methods of tackling systematic problems in developing countries as the risk of adverse outcomes are reduced.</p><h3>Improvements In Global Health</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*h6J9l3Ys1LxFchwt" /><figcaption>Photo by <a href="https://unsplash.com/@cdc?utm_source=medium&amp;utm_medium=referral">CDC</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><blockquote>The number of children under five years old that die mostly from preventable diseases has halved in the last 20 years.</blockquote><p>Let’s start with the bad news. Fifty-six million people died in 2017. Below is a chart that shows how old they were when their lives ended.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/786/1*Tyjp9X4-ZtPEK-qgMkYpeA.png" /></figure><p>The chart above shows all deaths by five year age groups. Child mortality (death of children before the age of five) is a disaster of pandemic proportions that rarely make the headline because it happens so frequently.</p><p>On average, that’s 15,000 young children per day. The number of suffering children remains immense. Yet these daily tragedies continue without receiving the attention this injustice deserves. A comparison of the tragedy of daily infant mortality with those tragedies that do receive public attention puts it in perspective. A passenger jet probably carries about 600 people. The number of child deaths is that of 25 jumbo jet crashes, with only children on board daily. Sadly, most of these deaths can be prevented. At this point, you are probably thinking “I thought this was supposed to be a positive post. Why are we talking about jet crashes and children on board?”.</p><p>Well, now for the good news. The chart below shows the number of child deaths under the age of five each year from 1990 to 2017.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*D958CygLChNsFfdwsxumXg.png" /></figure><p>The development of vaccines has been a miracle for global health. It has proven to be the most cost-effective investment in global health and human development in the history of our planet. It allows kids that have been adequately vaccinated to avoid certain deadly diseases. These diseases would have cost the parent a lot more to cure and some parents would not be able to afford the cost. However, vaccines have existed since the 18th century. Therefore, vaccines alone cannot account for the decline in child mortality (death of children before the age of five) from 9% in 1990 to 4% now.</p><p>The main innovation in global health has been alliances. The alliances between donors agencies, government and foundations such as the Gates Foundation ensures vaccines and drugs are not only made available in more cost-effective ways but also appropriately administered. Two alliances that have been instrumental in global health outcomes in the last decade have been the <a href="https://www.gavi.org/">Global Alliance on Vaccines and Immunisations</a> (GAVI) and the <a href="http://www.theglobalfund.org/">Global Fund to Fight AIDS, Tuberculosis, and Malaria</a> (The Global Fund).</p><p>GAVI was created in 2000 to get vaccines to all the kids in the world. Over the past two decades, Gavi has helped vaccinate more than <a href="https://www.gavi.org/sites/default/files/document/2020/Gavi-Facts-and-figures.pdf">760 million children with 66 million children immunised by GAVI sponsored vaccines in 2018</a> alone. As a result, <a href="https://www.gatesnotes.com/Health/Gavi-has-helped-prevent-13-million-deaths">GAVI has prevented more than 13 million deaths</a>. Today, 86% of children around the world receive primary immunisation containing the <a href="https://www.who.int/immunization/policy/Immunization_routine_table1.pdf?ua=1">11 WHO-recommended childhood</a> vaccines at the <a href="https://www.gavi.org/our-alliance/about">cost of $28 in GAVI-supported countries</a> compared to the US cost of $1,100 for these vaccinations.</p><p>In June 2020, world leaders made a historic commitment to providing equal access to vaccines to all children by pledging a further $8.8bn. This amount far exceeds the target of $7.4bn. The funding will help to immunise <a href="https://www.gavi.org/news/media-room/world-leaders-make-historic-commitments-provide-equal-access-vaccines-all">300 million more children</a> in the world’s poorest countries against diseases like measles, polio and diphtheria by the end of 2025. Gavi was also able to raise over <a href="https://uk.reuters.com/article/uk-health-coronavirus-vaccines-advance/gavi-raises-567-million-of-2-billion-goal-to-buy-covid-19-vaccines-for-poor-idUKKBN23B2JG">$2bn for developing countries to get COVID-19 vaccines.</a></p><p>The Global Fund is another organisation achieving fantastic results. The Global fund was created in 2002. It raises and invests more than <a href="https://www.theglobalfund.org/en/overview/">US$4 billion a year to support programs to fight AIDS, TB and malaria in more than 100 countries</a>. Health programs supported by the Global Fund partnership have saved <a href="https://www.theglobalfund.org/en/impact/">32 million lives</a> as of the end of 2018. The number of deaths caused by <a href="https://www.theglobalfund.org/en/impact/">AIDS, TB and malaria each year has reduced by 40% since 2002</a> in countries where the Global Fund invests. Both organisations have similar goals of delivering medicines, technologies, and programs that save lives in low-income countries.</p><p>There are other improvements in global health from maternal mortality to lifespan across the developing world. However, let’s focus on child mortality because of its knock-on effects on reducing poverty.</p><h3>Adoption of technology that improves the lives of all</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*_2AzXDpZeNWEpuK0" /><figcaption>Photo by <a href="https://unsplash.com/@nesabymakers?utm_source=medium&amp;utm_medium=referral">NESA by Makers</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><blockquote>Increased proliferation of technology allows more people closer to the bottom of the pyramid including those that might face discrimination to participate in the economy and improve their outcomes and that of future generations.</blockquote><p>I remember when mobile phones became a thing in the middle 2000s in Nigeria. It was a luxury item which very few people could afford. The sim cards were costly and phones at the time were short of being smart. They were mostly for making calls and sending SMSs. Both of which were very expensive at the time. Very few people had access to a personal computer including myself. I had to go to places with clusters of computers called internet cafes to check my email and use the internet even while I was at the University.</p><p>Fast forward 15 years later, computers and smartphones are everywhere in Nigeria and the developing world. Phones have become so widespread that impoverished small scale farmers in Nigeria and the rest of the developing world use them to get information on the best agricultural practices or obtain funds for inputs. Startups have grown around that ecosystem in much of the developing world with the likes of <a href="https://babbangona.com/">Babana Gona</a> and <a href="https://medium.com/thrive-agric/thrive-agric-now-part-of-y-combinator-fd22872cea">Thrive Agric </a>being popular in Nigeria.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OTgP5amEmWyOvxJKxAr4UQ.png" /></figure><p>The chart above shows the rapid adoption of mobile money in globally from 2006 when mobile telephony started to rapidly expand beyond the upper class to 2018 with close to 900 million users.</p><p>The effect of this is that e-commerce has begun to thrive in developing countries. It is easier for people struggling to get on the prosperity ladder to join the formal economy and gain access to microcredit. It has also helped to improve gender equality.</p><p>Women can more easily take care of their families and join the marketplace by conducting their business through mobile money. Phones are especially important when you recognise that gender inequality is a significant cause of poverty. <a href="http://news.mit.edu/2016/mobile-money-kenyans-out-poverty-1208">Studies </a>show that mobile money not only reduced poverty in developing countries but also has helped more women<a href="https://www.unwomen.org/en/news/in-focus/commission-on-the-status-of-women-2012/facts-and-figures">. The UN estimates that 60 per cent of chronically hungry people are women and girls.</a></p><p>For middle-class Africans, access to global events and information as a result of technology and easy access to a smartphone has greatly improved lives. A lot of Africans consistently engage in social media, shop and offer services online through global tech giants such as <a href="https://nairametrics.com/2020/06/12/netflix-signs-multi-title-deal-with-mo-abudu/">Netflix</a>, Amazon, Ebay, Aliexpress and apps like Uber and Airbnb.</p><p>Technology Startups are also getting created across Africa and the rest of the developing world by young and talented people. These startups get into global accelerator programs run by Y combinator, Merck and Airbus.</p><p>There is a growing ecosystem in the developing world to solving its specific problems by leveraging technology. For example, Nigerians couldn’t invest in US stocks, bond and ETFs just a few years ago. However, companies like <a href="https://troveapp.co/">Trove</a> which started operation last year, allows Nigerians to buy fractional shares of stocks, bonds and ETFs of the largest US companies from the comfort of their homes with as little as $10.</p><p>The technology ecosystem is building solutions all over Africa and the developing world from financials services, <a href="https://twiga.ke/twiga-story/">agriculture</a>,<a href="https://techcrunch.com/2019/08/14/nigerian-logistics-startup-kobo360-raises-30m-backed-by-goldman-sachs/"> logistics</a> and many other areas that directly impact the lives of everyone and grows prosperity.</p><p>Hopefully, you are still reading and there are a few facts you were not previously aware of such as the funds pledged to GAVI in June 2020. Perhaps you haven’t even heard of GAVI. It all seems like a lot of statistics though so let me share a personal story.</p><p>Nigeria was in a terrible civil war that ended in 1970. My tribe was on the losing side and the conflict caused so much destruction. Everyone from my tribe in Nigeria was in extreme poverty in 1970. Neither of my parents went to University and they ran a small business in Lagos, Nigeria. I was born in one of the slums of Lagos in the late 1980s. Perhaps someone just like you donated money that made it easier for my parents to get me the vaccines I needed as a child which allowed me to get to my fifth birthday. I will never know.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UyAQRVTt04bMsP62vZvy2g.png" /></figure><p>Fast forward thirty years. My country has enjoyed democratic rule consistently since 1999 after decades of coups and counter-coups (see chart above to see that democracy is now the norm in the world). My three siblings have a post-graduate degree from either Europe or the United States. I even have post-graduate degrees from both continents. I now run the business which has grown significantly from its humble beginnings and currently employs about 60% women.</p><p>In addition, I am a member of the <a href="https://lagosangelnetwork.net/">Lagos Angel Network</a> which focuses on mentoring and investing in young people that build amazing startups that are solving problems across Nigeria and in Africa. My story is not that unusual in developing countries. Many people my age and younger in developing countries owe their lives to the good graces of strangers just like you which they probably would never get to meet.</p><p>There are so many ways to impact the world positively. However, you don’t need to run a Foundation, become a health worker in Tanzania or an agricultural expert in Ethiopia to save lives. You could easily impact people’s lives directly via effective altruism.</p><p>Effective altruism is “<a href="http://socialgoodstuff.com/2016/02/effective-altruism-arguments-for-and-against/">a philosophy and social movement which applies evidence and reason to working out the most effective ways to improve the world”. It builds upon a simple but profound idea: that living a fully ethical life means using your spare resources for the “most good you can do</a>”.</p><p>Peter Singer has been one of its most prominent advocates and you can learn much more about how it works <a href="https://www.thelifeyoucansave.org/">here</a> and <a href="https://www.givewell.org/charities/top-charities">here</a></p><p>You can also see the TED talk below where he describes in details how to give effectively and make the world an even better place.</p><h3>Conclusion</h3><blockquote>The fact that the world is much better for most humans compared to anytime in the past does not mean that it is perfect.</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/750/1*90EKha0ZTaMq7fVp-7KA9w.png" /></figure><p>Given all the negative news stories and sensationalism that exists in the media, it may be hard to believe things are improving. The chart above shows that people in most countries think that extreme global poverty has gotten worse in the last 20 years.</p><p>However, I provided evidence on three key areas that show clear and consistent improvements even though the positive news rarely ever get reported by the media. The rate of population growth is decreasing as more people earn more income, get better access to healthcare, technology and education compared to the previous generation. Population growth naturally controls itself by reducing the levels of extreme poverty in the world.</p><p>Statistics such as <a href="https://www.goodreads.com/book/show/4722934-the-life-you-can-save">the average 30-year-old women in the world today has spent one year less in school on average compared to 30-year-old man</a> or <a href="https://www.youtube.com/watch?v=FRilssF4pBM">the life expectancy of the average African has increased by a decade over the last 15 years</a> does not make sense to us but it is true. Such statistics exist in a variety of areas from gender equality outcomes, life expectancy outcomes and many others.</p><p>People generalise African countries and talk about African problems as if all 54 countries in Africa are the same. Yet all African countries are not at the same level. This misconception can have enormous consequences such as the <a href="https://www.dw.com/en/ebola-threatens-africas-tourism-industry/a-18033375">Ebola pandemic in Liberia affecting tourism in Kenya</a> which is over 7000 miles away.</p><p>Most children get vaccinated. For vaccines to get to these kids, infrastructure for transportation, storage, electricity, healthcare and education are required. These are the same infrastructure that is necessary for the establishment of factories and supply chains in a global economy.</p><p>As the late <a href="https://www.gatesnotes.com/About-Bill-Gates/Remembering-Hans-Rosling">Hans Rosling</a> once said;</p><p><strong><em>The fact that the world is getting better does not mean that it is perfect or that we can lean back and watch the show. However, it does mean that we are probably doing some things right and it is essential to identify those things so that we can keep doing them.</em></strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=22878015a546" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Programming for Accountants]]></title>
            <link>https://medium.com/swlh/programming-for-accountants-27f4d48d722d?source=rss-eb6f00eeb3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/27f4d48d722d</guid>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[accounting]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[productivity]]></category>
            <dc:creator><![CDATA[Arinze Anyaeche]]></dc:creator>
            <pubDate>Tue, 02 Jun 2020 14:04:32 GMT</pubDate>
            <atom:updated>2020-06-05T00:59:51.608Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Accountants need to learn Python" src="https://cdn-images-1.medium.com/max/1024/0*hbQJH0cUBbmT8xBK" /><figcaption>Photo by <a href="https://unsplash.com/@hiteshchoudhary?utm_source=medium&amp;utm_medium=referral">Hitesh Choudhary</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>A large part of both management accounting and financial accounting is the patterns involved in the capturing, manipulating and interpreting of data. Accountants from all over the world disagree on the pattern recognition for treating different types of transactions. That’s basically what accounting standards are meant to address. To give clarity of the treatment of these patterns within transactions. In almost every country in the world, professional qualifications are issued to accountants every year for years of study on these pattern recognition.</p><p>The capturing of transactions to a large extent has been automated already as the rise of Enterprise Resource Planning such as SAP and SAGE are now in the hands of SMEs and they don’t need a qualified accountant to capture transactions or post those transactions directly to general ledger accounts unlike in the past.</p><p>For data manipulation, Excel has stood as a great tool for accountants. To a large extent, this has served accountants well in the past decades but in the coming decades of big data analytics, data science, machine learning and artificial intelligence, this knowledge will not suffice. Accountants need not fear the automation revolution underway but rather they should embrace it as a survival mechanism. One key way that accountants should embrace automation is by learning to code. To a lot of accountants this would be a ridiculous idea but please hear me out before you bring out the pitch forks.</p><p>Covid 19 eventually came to Nigeria in February 2020 as it spread very quick around the world. Around when the lockdown became imminent in Lagos,Nigeria, I had conversations with several professional colleagues who are accountants. Eventually, these conversations usually went towards what we will spend the lockdown doing. Some could work from home and as such would be busy with work. Each person I told I was going to use the lockdown period to learn a programming language laughed in disbelief. The question was usually “why should an accountant bother to learn something so far afield?”.</p><h3>Why Python?</h3><p>My response was usually that I plan to learn just Python and the next question was usually “why are you doing this to yourself?why Python?”</p><p>My response was usually along the lines of-</p><p>A. Python has simple syntax and it is easy to learn compared to other programming languages including VBA for Excel which I have tried to learn before but failed.</p><p>B. Python is a free open source program with fantastic resources and libraries all available online for free.</p><p>C. It’s a very versatile language that is huge not only in data science and analytics but also in machine learning, robotics, artificial intelligence and web development.</p><p>D. It has a huge and very helpful online community. Almost any specific problem you can encounter while using the program has been asked and answered comprehensively on websites like <a href="https://stackoverflow.com/">StackOverflow</a>. Solutions are all a Google search away.</p><p>E. Most importantly. It can help accountant automate recurring task. The more often the data manipulation is required, the more value Python automation will provide.</p><p>I know accountants are still not convinced. They are thinking “these are challenges of the future and those benefits are very general. How can learning Python help me now?”</p><h3>Speed that leaves an audit trail behind</h3><p>As accountants, we tend to underestimate the amount of time we take to do some routine data manipulation tasks on Excel. Perhaps one V-lookup or Index Match function here and a few text-to columns there and 30 mins has passed. 1–2 hours a week can quickly add up in the year. The time taken to manipulate the data can also be distracting thus preventing us from looking at the data with fresh eyes. This takes us away from the real value of interpreting data where judgement is involved and an accountant’s brilliance can shine. The speed benefits are exponential the larger your data set. With more digitalization, data sets are becoming even more robust and testing Excel’s limits. This makes the benefits of programming become more obvious.</p><p>In addition,program results have easy reproducibility due to the fact that coding automatically provides an audit trail in the code. Anyone that can read your program can understand exactly what you did to the underlying data to manipulate it even if some data has been deleted.</p><h3>Data integrity</h3><p>Perhaps you are working on some one else’s or even your own Excel file and there are numerous formulas in the workbook. Rather than copy it to your computer or somewhere else in your directory before doing your manipulation for fear of changing the original file due to error in the process of data manipulation, won’t it be nice to work on the file without manually opening it? Manual processes can lead to errors so where possible you want to avoid it.</p><h3>Delegation powers</h3><p>Once upon a time, an accountant was required at the data entry stage of every transaction process. The person had to manually determine the General Ledger to pass double entry for each invoice. Now, even an SMEs no longer requires a qualified accountant for data entry with the arrival of SAP Business One, SAGE and other online accounting software. They can get a non-accountant to do data entry while the accountant focuses on manipulating and interpreting data. In the future, I expect this change to move higher as non-accountants can focus on data entry and more manipulation while accountants do less manipulation with a focus on interpretation of data. With Python, this can be deployed already at accounting departments. The non-accountant just has to run a few programs periodically and the accountant can take it from there.</p><h3>Upskill</h3><p>As accountants begin to interface more with coding and programming, they are better able to interface with the IT department with respect to challenges and come up with joint solution on IT in order to improve organisational effectiveness. I am not expecting an accountant to become a full-fledged programmer but, accountants can have IT requirements like requiring a member the IT department to also know coding not just database administration in order to assist the accountant with writing useful code that can save valuable time.</p><h3>Practical Use Cases of Python for Accountants</h3><p>As discussed above, Python really shines for an accountant when the task is recurring, when he/she is concerned about the integrity of the data during the manipulation process or he/she simply wants to delegate data manipulation task to a less skilled individual after writing and setting up on person’s computer. However, sometimes Python beats Excel even in some basic one-off processes.</p><p>I would like to show 3 practical use cases for Python that shows examples of easy tasks where Python could be a preferred option. Of course these are by no means exhaustive but rather just for illustrative purposes. I will explain the scenario, present the codes which you can tailor for your purpose and hopefully you can understand my appreciation of this wonderful program.</p><h3>Scenario 1- Splitting files</h3><p>I have a huge Excel file showing organisational sales data for a period and I need to split the file by regions, (it could be by category. The same logic works for splitting cost data by cost center for example). Different people need the different regional data for their analysis and they only care about their region. I created a sample Excel file for illustration purpose. Your file would probably by more detailed with a larger number of rows and columns. That will not affect the result-</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/585/1*bbVyIpbm32qt9Gr5xHwU5g.png" /></figure><p>Below is 8 lines of code and comments on the code</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/624/1*nZ_S9NhDqspLNmP83Q5VJg.png" /></figure><p>Everyday I can run the code for a few seconds and it outputs the result below with separate files for the regions. Lagos, Kano and Abuja (the category or regions can be much larger and the same code would do the work). The 4th item in the directory is where I stored the Python code and split.xlsx is source file.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/217/1*futgt1mMaJ0JuJ5eJ3Tecw.png" /></figure><p>Below is the output of the Lagos file. I can now send each file to their file owners for further analysis and each file would only contain data that the file owner cares about.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/442/1*QTdooLmQ8vj9S1ADhwqJ2w.png" /></figure><p>I can even add more code to the script to allow Python to send the files directly via email to the file owner. Its easy to see how that can allow for more data integrity and a fast manipulation even by someone that is not familiar with Excel. The code can easily be copied to his/her system and he/she can run the commands and also send out manipulated files.</p><h3>Scenario 2 — Combining files</h3><p>I usually receive periodic report of some transactions. Perhaps the reports are from different subsidiaries, business units or branches. I now have about 100 such reports which I need to combine in order to prepare consolidated analysis. We will use the output from scenario one as the input for scenario two for illustration purpose. The number of files does not matter to the program. It will all be combined perfectly in a new file in my desired directory on my computer. The program can even email the file to the file owner with a customized email message and subject.</p><p>I have created a new directory and put the files I want to combine in the directory.</p><p>Below are 10 lines of code and comments on each line about what’s going on in the program</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/624/1*HKsQls-DnYY-SSDtF6yfVA.png" /></figure><p>Below is the combine Excel file called combine.xlsx added to the directory by Python after running the program</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/261/1*J3lyouGesq8QXcEYLeuwtA.png" /></figure><p>And below is the output of combine.xlsx which only gets the columns I need for each record in the files in the directory. As you can see, I skipped the Unit Cost column because I don’t need it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/394/1*YFe_wno5IJYOxOlK8RRclw.png" /></figure><p>You can also merge the files if the column header in the files in the directory are different.</p><h3>Scenario 3- Removing unwanted characters</h3><p>I have data from a data source that does not work very well with Excel. I need to remove all special characters from the data before I can work with it. I can’t use text to column because the unwanted characters have been fixed in seeming random parts of the data set and they are different. If only there is an easy way to remove all the special characters without having to do it manually. Well there is an easy way with Python.</p><p>For illustrative purposes, below is the unclean data from a data source that’s not very compatible with Excel. The data source could be a database, a website or a pdf file.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/411/1*n6cL_A4NccnKQPWNftrVyQ.png" /></figure><p>Below is the code and accompanying comments. Its just 7 lines of code</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/961/1*8tDQ6QxEgs2utQTJOPb6yA.png" /></figure><p>Below is the final output</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/406/1*32xzCSfIywJLpYa2mJeneA.png" /></figure><p>This operation was done using <a href="https://en.wikipedia.org/wiki/Regular_expression">regular expression</a> which can be used to match any type of pattern in your Excel file and either replace or remove them. Regular expression can be used to do much more.</p><p>I have chosen very simple instances to show the power of Python. Each of the scenarios above have at most 10 lines of code and could be written in a few minutes and executed in even less time.</p><p>Hopefully you are now thinking “I can see how this might be of use to me but how can I get started?”</p><p>Well, “Automate the boring stuff with Python” seems like a highly regarded book and popular place to start. The book is freely available <a href="https://automatetheboringstuff.com/">here</a></p><p>If you are like me and prefer watching videos to reading books then I would suggest you check out YouTube. There are a lot of very good educators there. Python is a very versatile program and it is used to do a lot of other things. For an accountant I will suggest you just learn the basics of Python to understand the syntax, Pandas for data manipulation and MatPlotLib for charts and graphs.</p><p>Resources I personally used for learning the basis of Python are<a href="https://www.youtube.com/watch?v=_uQrJ0TkZlc"> here</a>.I did Pandas series <a href="https://www.youtube.com/watch?v=ZyhVh-qRZPA&amp;list=PL-osiE80TeTsWmV9i9c58mdDCSskIFdDS">here</a> and I would recommend MatPlotLib <a href="https://www.youtube.com/watch?v=UO98lJQ3QGI&amp;list=PL-osiE80TeTvipOqomVEeZ1HRrcEvtZB_">here</a>. As you learn, you can easily google or search on YouTube for any concept that you may be struggling with as there are so much online awesome resources on YouTube <a href="https://realpython.com/python-youtube-channels/">here</a></p><h3>Conclusion</h3><p>The workflow of an accounting role is evolving. In order for accountants to remain valuable in the future, they must not only be able to understand the output of analysed data but also understand the Data Science tools used to produce the information and work with IT to create value for the organisations that they serve. In order to gain an appreciation of these tools, knowledge of at least the basics of a programming language such as Python or R would be required. This clear knowledge gap in accounting training has recently come in the limelight not only as an area of <a href="http://www.aejournal.com/ojs/index.php/aej/article/download/565/209">academic accounting research</a> but also as an <a href="https://www.icaew.com/insights/features/2020/mar-2020/why-is-coding-useful-for-accountants">area of interest to accounting institutes</a>. I expect accountants to embrace the data revolution as the <a href="https://www.aicpa.org/interestareas/accountingeducation/newsandpublications/should-accounting-students-code.html">value of the profession would be significantly reduced if accountants allows themselves to be left behind</a>.</p><p><em>Do you agree that programming can make you a better accountant? I would like to hear from you so kindly leave a comment.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=27f4d48d722d" width="1" height="1" alt=""><hr><p><a href="https://medium.com/swlh/programming-for-accountants-27f4d48d722d">Programming for Accountants</a> was originally published in <a href="https://medium.com/swlh">The Startup</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>