Excel for Begginers

Thiago has a degree in Production Engineering, a graduate course in statistics and a degree in administration from the Federal University of Juiz de Fora (UFJF). Black Belt in Lean Six Sigma, worked with methodologies for cost reduction and process optimization at Votorantim Metais, subsequently joining MRS Logística as a trainee, where he held positions of manager and specialist in continuous improvement. With Microsoft Office Specialist (MOS) certification and ISO 9001 Auditor Lead Advisor, attended several companies in consulting projects, in addition to training and lectures related to Lean Six Sigma, Career Entrepreneurship in nationally renowned congresses such as ENEGEP (National Meeting of Production Engineering) and international as International Six Sigma Brazil congress. In the academic environment, he works as a professor of undergraduate and graduate courses in the areas of management and entrepreneurship. Thiago had the opportunity to participate in projects of several segments. Founder of the Voitto Group, he was selected in the Promessas Endeavor Program, having the opportunity to receive valuable mentoring to accelerate his business. He is currently a business mentor and dedicates himself to the executive front of Voitto, carrying with his team the vision of being the best online school of management in Brazil.

Founder of Voitto Group, currently a business mentor and dedicated to the executive front of Voitto, carrying with his team the vision of being the best online business school in Brazil.

Learn how the Profitability Index formula can help you measure the operational efficiency of your business.

What is the Profitability Index formula? Learn how to calculate!

Are you sure that your business is actually generating profit? Want to know what your profitability is in front of your competitors?For this, there is the Profitability Index! Have you ever heard of this indicator? If you have not heard, do not worry, I&#39;ll teach you everything you need to know!The secret to these and other issues you discover here, just keep reading! Ready to start?<h2></h2><h2>What is the Profitability Index Formula?</h2>The Profitability Index (PI) is the perfect indicator for you who wants to know your company&#39;s ability to generate profits from the project. This indicator will show you whether the project is feasible and / or needs to be improved, and in the worst case, discarded.So, to avoid investing in a business that does not return the <a target="_blank" rel="dofollow" href="https://www.voitto.com.br/blog/artigo/padroes-de-candlestick">desirable profit</a>, learn to calculate this rate of profitability and how to interpret it.First, it is necessary to know that this indicator is fundamental for a business since it allows an entrepreneur to know the efficiency of the company in generating a profit. This index can be broadly calculated covering all sectors of the company, as well as individually, to measure the profitability of a specific industry.You may be wondering if the utility of this indicator is limited only to measuring profit generation, right? The answer to this question is no since this indicator is also an important tool for decision making by managers of a company. From it, it is possible to evaluate if the adopted strategies are working well and what changes are necessary. Profitability Index = PV of future cash flows / Initial investmentIt can be further expanded as below,Profitability Index = (Net Present value + Initial investment) / Initial investmentProfitability Index = 1 + (Net Present value / Initial investment)Profitability Index Formula= PV of Future Cash Flows/Initial InvestmentAre you tired of missing out on incredible career opportunities because you don&#39;t know about the main Excel tools?So you are in the right place! In the<a target="_blank" rel="nofollow" href="https://thinkleansixsigma.thinkific.com/courses/excel-for-beginners"> Excel for Beginners</a> course, you will learn to work with data in an agile way.In addition, the course is available for FREE, just click on the banner button below and embark on this journey of knowledge!<a target="_blank" rel="nofollow" href="https://thinkleansixsigma.thinkific.com/courses/excel-for-beginners"> <Image quality="95" src="https://images.prismic.io/voitto-blog/45fd4463-eb50-470d-a2e2-1a98155e7fdc_Bot%C3%A3o++Banner+-+Cursos+TLSS+%282%29.png" width="980" height="180" alt="Excel for Beginners" title="Excel for Beginners"/></a><h2>How to calculate the Profitability Index?</h2><h3>Simple Calculation</h3>Are you with your calculator at hand? It is important to be because I am going to teach you how to calculate the Profitability Index. If necessary, take a quick pause in the reading to get your calculator.The PI is the abbreviation for this indicator and can be found by the ratio of total revenue to net income, as you can see below: <Image quality="95" width="250" height="68" src="https://images.prismic.io/voitto-blog/NzZmOTMxMzgtZjE0NS00YTlkLWFhNTEtMjJmOTdjZWMyMDBj_tmxbyzfqitqhbno0pq_u_ow-g-p-bjuaj0ljtlh9yvr6w8rdiyb0kutgzqp8-sutukku2teocwqp6fsxxk85wjqmu9lrwipdza0eaw3qfx7zcfin9aak-lao0pxklj3ykv1kkwne" alt="simple calculation" title="simple calculation" /> Before you start calculating, it is important for you to know what revenues are the amounts from payments received for the products and/or services offered and the net profit is the value obtained after the discount of all costs, expenses and taxes.So we can see these values from the following Profit and Loss Statement: <Image quality="95" width="435" height="358" src="https://images.prismic.io/voitto-blog/YzJhNjAxYzYtZTU4Yy00MmZkLTk1MDktNmE4OTU1ZjgzY2I3_5hj_nroxhfvdckohvlcipap2m7zmjfaedfr7gzj4wg81qjjar7odfcpkjwm5sb9rtn7v0ian3y3gzdmnfzbcsqtecsp9jzwzai1mbwamv6lwsmhi7exqimqja0bkdj6wo_8uc8jn" alt="" title="" /> Now that we already know what the revenues and net income are and we identify these values in the above Profit and Loss Statement, we can start with our calculation. Let&#39;s see: <Image quality="95" width="206" height="62" src="https://images.prismic.io/voitto-blog/NWRmZTdjYjktZGIzOS00ODA3LWI0YTMtYzY3MGJkN2I4OTUy_c7vhzo3uxygx7k2djusqc0ulrawrrmp2vikhm0kyg8ngpja8ojzhr_a0wxcgpgklyl08pkyveyyd9l8ho3hdpufgjfredg1xhuuoqel2gajpnlhimdd_0zuzvwanzrsgbjgb-d48" alt="" title="" /> <Image quality="95" width="165" height="37" src="https://images.prismic.io/voitto-blog/NDc2YzI3MWItMThiNy00YWI4LThmYTUtMTVjNTRhMzU0YmYx_jjuk-sfqcjpmhw5516poz-b-yd9wim6uviwtiyqjvgj15hcrcfnbh-asl-dgmzhfxyu2sf0f4_ssdarcwnygjdqszs3fadyzwlwzbzcfql0irjv_p8i-afeokbq9fclo2fx0o2fv" alt="" title="" /> <Image quality="95" width="133" height="29" src="https://images.prismic.io/voitto-blog/ZGEwYzZhMDEtNTI2MC00OTBjLThkYWItOWUxZjUzNTA4ZGUz_pmitd-3sguuq3zk-1gkhxsbotrantlukzpoxvebck-yheukfew6uesj77fl1jwxlqgtphdesaarp47f1kdegzx7hs8dba4ubomdjqxk_bq4hqmtx1raqs1yaxk7t3mr6fc1wdear" alt="" title="" /> In this way, we see that the example given has a profitability of 169.68%, that is, this is the company&#39;s ability to generate profit from its operating activities.You must be wondering why I multiplied the IL result by x 100, right? You will end up realizing that this is very common when using financial indicators because it facilitates the interpretation of the result and helps in the decision making by bringing the result in percentage.<h3>Detailed Calculation</h3>You can see that from the previous calculation, it was very simple to find the Profitability Index. However, this formula is not enough when we want a more precise value, that is, when we want to evaluate in a more detailed way the gain that a company can generate from its activities.Therefore, large companies and financial professionals use the following formula: <Image quality="95" width="193" height="85" src="https://images.prismic.io/voitto-blog/ODg1NGIxZjItNzg3Ny00MTBkLWIzZDQtN2E1ODQ1NGJkYTU5_5mqigdlbxqwbf6jd9w9nc8h1xkqf2kosdvsdlw8f4xtvh8_squou2zwaticr_h6q5ru1vbtc21owhf1gm8t2v0oqz7rtjjkxukt33v6mumng0vuz5it8o7esujagbabqwq9jsxg2" alt="" title="" /> The formula above considers as the numerator the cash flow added to the residual value of the investment, while the denominator is the investment itself.To facilitate this calculation, you should ideally use a financial calculator. I bet you&#39;re asking yourself: What now? I do not have a financial calculator! Stay calm, there are applications with the financial calculator that you can download easily on your mobile.But even without a financial calculator, you can develop the calculation, it will only take a little longer! Another way is to use Excel and if you are not aware of this software, you can start learning by doing our Introductory Excel.Now let&#39;s take a practical example, imagine the following situation: A project will require an investment of $ 80,000.00, occurring on date zero. Considering an analysis period of 3 years and a rate of 8% per year. The estimated cash flow will be shown below: <Image quality="95" width="167" height="122" src="https://images.prismic.io/voitto-blog/ZTg1YTc2MmItNTJiZC00NWRjLTg1ZTUtNjU5N2M5MjJjOTA4_xl-5ezvxwaihy7inq4p3xfm9ojypcdlzfezrezgujfpfydibqk8rp7ixhqd0i_ormk_mmfeh6fp59jt_wjh6g99-mwai2tm3cca3nfbp-wsxqmtqk4_arr_z_-io7qbpp9gsqzrx" alt="" title="" /> Is this project advisable or not?From the data provided in this example, we first calculate the Net Present Value (NPV). To do this, you need to pick up the cash flows that are projected and bring them to the year zero, this being known as discounted cash flow. <Image quality="95" width="254" height="145" src="https://images.prismic.io/voitto-blog/MjYwYzA1MjYtYThkNi00ODYyLWJlM2UtYjhlMzE1YzM3N2Fl_lrksmmq1ycpd3sfrolwluk1i4idxenzvl8my7w4cy-rg_1eqjjc2-87ua8u8k0qhycczys2yqc_r9qpdzihmpqfmpzrehzx8dm9p5ocqj_9ru4hedsw3gsin07o53aotmggnm3ff" alt="" title="" /> In this way, we have highlighted in red the calculation of the discounted cash flow. Did you look at the picture and still could not understand how I got these values? Calm! I will do the calculation in a more detailed way so you can understand and reach the same values. Let&#39;s see: <Image quality="95" width="358" height="118" src="https://images.prismic.io/voitto-blog/YjczNDYxYzMtZmUwYS00NDYzLThhZmYtNGQ5YjczMWY5MTMz_7rg1eyz_v9lld-0bx6pca3qqef6sw0xeadmvoiacnxajmsd8h8lc6govhjdps02ms3yr5tkox0ikju-crushvieqi0ieyrc0jj3yvsml9lvlnqbdtbjx2esgumdufrrw7ir139ki" alt="" title="" /> Now that you have really understood how to calculate the discounted cash flow, you can get the Present Value, which is nothing more than the sum of the values found previously: <Image quality="95" width="194" height="40" src="https://images.prismic.io/voitto-blog/MjY0Nzc0NDgtYzdmYS00NjE2LWJkNzAtNjVlOTM1YjZiNDBj_5bcy_auy3njmdl4we2-rrgggotw_vmqwxtaaoin4agpxaaxj0cztgvrvtkv3tsmiwuauzf9j7ydzmwvp2sxe3gy44fsl9ttpxwyayoaqp0mdiv7cze9erl6kilangwib45hxoefd" alt="" title="" /> With all the information at hand, you are able to easily calculate the IL and To know whether or not to recommend the project, note: <Image quality="95" width="192" height="56" src="https://images.prismic.io/voitto-blog/Yzg5ODNmYmYtYzhiYi00MDNlLTk2OGUtMmQzNjY1ZTFkOTYw_tjx6sftisdeyvmnr3abnd2b1gm0-divlofdllwd7kqzxpzugnwguspz6r6yvtrt9e2atgfn3bcb__qmomzjb9ywteeod81inb7ltyigyluzhxz5akwaf5hry-nqpp1u2eyqxd1wp" alt="" title="" /> <Image quality="95" width="124" height="34" src="https://images.prismic.io/voitto-blog/OTJjN2FhNzItYWNjZS00OTAyLWFjMGItNTIyN2RlODFlYTk3_vp5rp_e4hvk6ad9pi_t_l43lwkjr6pl8rvnlmbydzyzpcpqvgwg1p9x_sz7jb5xxlkdn_k0vo30xuqwg2vnn8us9bneybi1vowkq3rnmx6kk3ex1bty8h72qrp9wy7maaut_sqzs" alt="" title="" /> Thus, we can see that we have a Profitability Index of 171.96% when we multiply by 100 to obtain the percentage and we can say that it is a recommendable project for having IL &gt; 1.<h2>Interpretation of IL</h2>Now that you know how this profitability ratio is calculated and how important it is, let&#39;s learn how to interpret that result.The interpretation of this indicator is very simple. As we have seen, when IL &gt; 1, the project is recommended because for every $ 1.00 invested you will get a higher return than your investment. In the case where IL &lt; 1, the opposite happens, you will have a lower return on your investment, so a project is not recommended in this condition.Thus, we can conclude that the larger the IL, the better your return on investment will be.<h2>Advantages and disadvantages of the Profitability Index</h2>Now that you know almost everything about this indicator, it is important to highlight its advantages and disadvantages.Among its advantages we can highlight that this indicator considers the value of money in time, that is, this indicator takes into account that the value of something today will not have the same value in the future and, therefore, the IL considers interest and time.Another advantage of IL is that it analyzes projects with constant disbursements well because in a project it is usually necessary to carry out more than one disbursement and all of them are considered in this calculation.As a disadvantage, we can talk about how much the calculation can turn out to be laborious because in the most detailed way we have to make use of the financial calculator or software like Excel. However, it is important to note that although it is more complex, it is not difficult, and with a little more time you can even do it on the scientific calculator.In addition, another disadvantage to be highlighted is that all inputs are remunerated from the same rate, as we saw in the example with the more detailed calculation, where a rate of 8% per year was adopted for the three years of the problem. But in other cases, these rates may vary.<h2>Understanding what is Profitability Index and how to calculate it?</h2>I hope you have understood everything about the Profitability Index. As you have seen, although it is a little hard work, it is not difficult to calculate and can help you a lot to see how efficient your company is in converting revenue into profit.If you liked this reading, keep following our blog, as we have many other articles on Financial Management and other areas that will assist you in your projects.<h2>If you made it this far, I have a question for you...</h2>Several times we get lost in so many Excel functions, and we don&#39;t know where to start and what to learn. To help you, we created the <a target="_blank" rel="nofollow" href="https://conteudo.voitto.com.br/ebook-primeiros-passos-no-excel">First Steps eBook in Excel</a> to guide your practice with the tool, as well as how and where to learn about its most complex resources. Learn how to solve everyday problems quickly and efficiently in Excel.By downloading our eBook, you will learn the first steps to create your spreadsheets and use their basic and essential functions.Let&#39;s get started?<a target="_blank" rel="nofollow" href="https://conteudo.pocketbook4you.com/ebook-fist-steps-in-excel"> <Image quality="95" src="https://images.prismic.io/voitto-blog/5ad839f3-56eb-4c5b-a198-380f5e858ce8_Bot%C3%A3o+Banner+Cursos+-+TLSS+%2817%29.png" width="1025" height="205" alt="[EBOOK] Fisrt Steps in Excel" title="[EBOOK] Fisrt Steps in Excel"/></a>