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 the concept of Payback, its advantages and how to calculate this financial indicator easily.

What is Payback? Here's how to calculate!

Do you know what Payback is? This is a concept widely used in the investment world, and let&#39;s learn a little more about it in this article!Have you ever wondered how investors find out how long they will get a return on investment? After all, no money is applied to something without knowing how long the results will appear, right? And that&#39;s exactly why the payback period is used. Let’s learn how to calculate Payback Period?This concept is very used in economic engineering and allows easy and simple visualization of the investment made. Like any method, it has advantages and disadvantages in its application, and that is exactly what we are going to talk about in this article.In order for you to stay even more on top of all the news about the world of investments, learn how to differentiate simple payback from discounted payback, and also how to calculate each of them easily we have separated in this article several topics full of information! Check it out!<ul><li>What is Payback?</li><li>Advantages and disadvantages of Payback</li><li>Main differences between Simple Payback and Discounted Payback</li><li>How to calculate Simple Payback</li><li>How to calculate Discounted Payback</li><li>Don&#39;t stop here!</li></ul><h2>What is the Payback?</h2>The Payback period is a term used within the <a target="_blank" rel="dofollow" href="https://www.voitto.com.br/blog/artigo/livros-de-gestao-financeira">financial management</a> to indicate the time elapsed from the time of initial investment to the time when the net profit equals the amount invested.The calculation of the payback period of an investment is quite simple, and gives the manager a quick view of the project, allowing a decision on whether to move forward or not, based on the verified risk.Payback Period time does not follow a pre-established pattern, as it depends on factors such as the value of the initial investment and type of business. It can range from a few months to years, after all, a very high investment will probably require a longer time to be returned.Payback is linked to some other indicators, which are:<ul><li><a target="_blank" rel="noopener" href="https://www.thinkleansixsigma.com/article/what-is-npv">NPV (Net Present Value)</a>: is the accumulated value of all the cash flow brought to the present value. It serves to analyze whether an investment is feasible or not, and also for the exact calculation of the payback.</li><li>ROI (Return on Investment): Evaluates the return on own and third-party investments in the company</li><li>Internal Rate of Return (IRR): a discount rate that must have a cash flow so that its NPV is zero</li></ul><h2></h2>Are 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>Advantages and disadvantages of Payback</h2>Just like every mathematical method, there are good points and bad points of using Payback Period to analyze the feasibility of an investment. And what are they?<h3>Advantages of Payback</h3><ul><li>Easy to calculate and be learned.</li><li>Provides an idea of the level of project liquidity and risk</li><li>It increases the level of security of investments made by a company in times of financial market instability, due to the advantage presented above.</li><li>Extremely useful when the project risk is very high or when the project has a limited life.</li></ul><h3>Payback Disadvantages</h3><ul><li>Do not consider cash flow after the year of recovery, ie, long projects are not very recommended.</li><li>It does not present a very clear analysis. </li></ul> <Image quality="95" width="4000" height="4000" src="https://images.prismic.io/voitto-blog/0ad7fd2c-1bb2-4e40-aa31-3a9382044447_payback+2.jpg" alt="Payback" title="Payback" /><h2>Main Difference between Simple Payback and Discounted Payback</h2>As you read at the beginning of this article, there are two types of payback period: payback period and discounted payback period.The Payback Period is calculated directly. It is the number of months or years required to recover an investment made.It does not consider the value of money over time and is also limited to the time when profit covers the investment.Because of this, some mathematical experts consider this method to be incorrect because it does not respect the principles of equivalence between rates, a concept derived from financial mathematics.Discounted payback period exists precisely to fill the gaps that occur in the calculation of the payback period. But how?It uses a discount rate that can be annual or monthly, according to investor interest. Generally, the rate used is the Hurdle Rate, that is, the minimum rate of attractiveness.This rate can be stipulated by the company itself, which determines how many percents it wants to gain on a given investment.In the discounted payback period all portions of the cash flow will have the discount of that determined rate in relation to a specified period.Now that you have understood the theoretical concept, it is time to apply it in practice. Let&amp;rsquos go?<h2>How to Calculate the Payback Period?</h2>Let&#39;s begin with the easiest method, and then make it difficult. To calculate the payback period, use the following formula: <Image quality="95" width="494" height="84" src="https://images.prismic.io/voitto-blog/MDdjMDBjZjktMmI4MC00ZTE0LWFlZTEtMzJhYjcxOGI1NTk0_lozzzhbw3hancm85ls2q5-hdgsec9-_-gv3n5v1t0dpisgzwgn9tjxfntxr6_nwf2hksunbqdbxf3_3cnw8_3zkfpiueyf-os5r_8594vdtcy32gvjfpgtou6zkcrhufpbo5yhx1" alt="How to calculate payback period" title="How to calculate payback period" /> When you know the initial investment, we just calculate the gain obtained with the investment to find out the value of our cash flow, and then we find out the period needed to cover the amount invested.To better understand, let&#39;s take a look at the following example: &quot;An automaker wants to reduce costs in the manufacture of &quot;steel boobs&quot;, a part installed under the engine to protect it from impacts. The engineering department found a press that can reduce the cost of production by 12% with an investment of R$ 1.7 million. Knowing that each piece has a cost of R$123.00, that 21,000 pieces are produced in the month, and that the company wants to return in 3 months, decide whether the project should be accepted or not &quot; It is clear from the reading that the investment to be made is 1,7 million to acquire the press. Considering this you already have the numerator of your formula, and to find the denominator, we just need to make a simple account.If the press will reduce the cost of manufacturing by 12%, we can subtract this percentage from the current cost to manufacture a part, which is $ 123.00. So, it is found that the new cost per piece will be R$ 108.24.To find the profit obtained per piece, simply subtract these two values. So, we find that by purchasing the press, R$ 14.76 per piece will be saved. To find out your cash flow, simply multiply this amount by the number of pieces produced per month.After all, we arrive at the following calculation: <Image quality="95" width="519" height="69" src="https://images.prismic.io/voitto-blog/NzJlYWZkNmEtZTM3ZS00YTA0LTlhYWUtNjRlOWEyZjkxYjQ1_cga1pgdvjlkx3nzz3rvmels8fz7x9bckh6xxwvz93frlw9rbw0fbq0-kdwkojcgara1vmuntb5vhscx-ml_qn--ahlzan0aulcbirumbuiz90a3xdzrgvqrfr_q4paenfbvf5-ye" alt="calculating payback period" title="calculating payback period" /> Therefore, 5.48 months is the necessary time for the investment made to obtain a return. As the company wanted to get a return in 3 months, in this case, the project will be refused because it did not meet this requirement.<h2>How to calculate discounted Payback?</h2><h2></h2>Using the same example above we can demonstrate how to calculate the discounted payback period.As seen in the theoretical part, the difference from one to another is the fact that the discounted payback period takes into consideration a discount rate defined by the investors.We will then consider the hurdle rate to be set at 10% for this investment. So, just do the following calculation to find out the value of the discounted payback period: <Image quality="95" width="435" height="91" src="https://images.prismic.io/voitto-blog/NzNjZDM2ODctODc4ZC00MTMyLTkzZDgtZTgyZjJiODQyM2Q4_lnrr7hr714mmadf_fjydxrolngvcdotd1p4jhuyidfpjfzopigrtynz9q7bzxt-6q5vp7zgx5wl3d5rsvupgsqlsrb3g881xoi2cnoeqbte49ezd_r8yplliccmlqa0oou6kup6j" alt="calculating payback period" title="calculating payback period" /> In this way you take into consideration the monthly discount rate established. Therefore, it is clear that by using discounted payback period, the investment takes even longer to achieve the desired return, making it even more unfeasible.<h2>Did you understand what Payback Period is and how to calculate it?</h2><h2></h2>As you can see, calculating the payback period and the discounted payback period is not hard to do. Just find out your cash flow, that is, how much that investment will give you return per month and apply on the type of payback period you want to calculate.Quickly you will be able to visualize the investment risk as well as analyze if it will bring the desired return within the established time frame.<h2>Don&#39;t stop here!</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>

Learn here what Payback is, how it works and the best way to calculate it!

Check out what Payback is, what is the difference between simple Payback and discounted Payback and its main advantages