{"id":3740,"date":"2024-03-04T00:00:00","date_gmt":"2024-03-04T00:00:00","guid":{"rendered":"https:\/\/www.educa.pro\/calcular-tasa-interna-de-retorno"},"modified":"2026-06-10T12:40:15","modified_gmt":"2026-06-10T12:40:15","slug":"calculate-the-internal-rate-of-return","status":"publish","type":"post","link":"https:\/\/educa.pro\/en\/articulos\/calcular-tasa-interna-de-retorno\/","title":{"rendered":"Calculate the IRR: a guide to evaluating investments"},"content":{"rendered":"<p>The<strong> internal rate of return <\/strong>(TIR) is one of the indicators <a href=\"https:\/\/educa.pro\/en\/articles\/mercados-financieros\/\" rel=\"noopener noreferrer\" target=\"_blank\">financial <\/a>most commonly used to assess the <strong>return on investment<\/strong>. In practice, this is the interest rate at which the net present value of a project\u2019s cash flows equals zero. In other words: it is the return offered by an investment, expressed as a percentage. Now, <strong>How do you calculate the internal rate of return?<\/strong><\/p><p>Here\u2019s a heads-up: performing the calculation isn\u2019t easy, but in this post we\u2019ll help you with some tips and practical examples. We\u2019ll also explain the limitations of the IRR and how to interpret the result. Read on! <\/p><h2>What is needed to calculate the internal rate of return? <\/h2><p>Before we get started with the calculation steps, it\u2019s important to know that the IRR is very useful for determining the minimum return you should require for an investment to be profitable. Furthermore, if you\u2019re unsure whether or not to accept a project, the IRR can help you <strong>make decisions<\/strong> depending on whether it is greater than or less than <a href=\"https:\/\/educa.pro\/en\/articles\/plan-economico-financiero-de-una-empresa\/\" rel=\"noopener noreferrer\" target=\"_blank\">cost <\/a>the opportunity cost or the discount rate. <\/p><p>As for the calculation, we have some good news for you: there are software tools that make it easier to calculate the IRR, such as Excel, <strong>financial calculators<\/strong> or spreadsheet programmes. These tools usually have a specific function for calculating the IRR, which typically requires the following data: <\/p><ul><li>The<strong> initial investment amount<\/strong>, which is entered as a negative number, as it represents an outlay or expenditure. <\/li><li>The <strong>cash flows<\/strong> expected returns on the investment, which are entered as positive figures, as they represent income or cash inflows. <\/li><li>The <strong>number of periods over which the investment runs<\/strong>, which may be annual, monthly or quarterly. <\/li><\/ul><p>In the following section, we explain the concept of the IRR and how to calculate it in more detail, using an example. <\/p><h2>Example of calculating the internal rate of return <\/h2><p>Let\u2019s suppose we want to invest in a <a href=\"https:\/\/educa.pro\/en\/articles\/forma-juridica-de-una-empresa\/\"><strong>company<\/strong><\/a> which requires a <strong>initial investment<\/strong> of \u20ac50,000, which is expected to generate net profits of \u20ac15,000, \u20ac20,000, \u20ac25,000 and \u20ac30,000 over the next four years. What is the IRR of this investment? Let\u2019s use the <strong>Excel IRR function<\/strong> To find out: <\/p><ol><li>In cell A1, enter the initial investment amount. Remember that it must be a negative number: -\u20ac50,000. <\/li><\/ol><ol start=\"2\"><li>In cells A2, A3, A4 and A5, we enter the net profits. <\/li><\/ol><ol start=\"3\"><li>The formula =IRR(A1:A5) is then entered into cell A6 <\/li><\/ol><p>The result Excel will give us for this formula is 0.2874. This is expressed as a percentage, that is to say, the <strong>The IRR for this investment would be 28.741%<\/strong>. <\/p><p>Below, we explain in more detail how to determine whether or not the investment is profitable. <\/p><h2>Interpreting the internal rate of return <\/h2><p>Once a project\u2019s IRR has been calculated, the result must be interpreted to determine whether to accept or reject the project. To do this, the IRR must be compared with the opportunity cost or the discount rate, which is the minimum return expected from an investment. <\/p><p>In general: <\/p><ul><li>If the<strong> The IRR is greater than the opportunity cost<\/strong>, the investment is <strong>cost-effective<\/strong> and the project must be approved. <\/li><li>If the <strong>The IRR is lower than the opportunity cost<\/strong>, the investment <strong>it isn't cost-effective<\/strong> and the proposal must be rejected. <\/li><li>If the <strong>IRR is equal to the opportunity cost<\/strong>, the investment is <strong>indifferent<\/strong> and the project can be accepted or rejected. <\/li><\/ul><p>To continue with the previous example, if the opportunity cost of this investment is 101, then the IRR is 28.741, meaning the project is profitable and should be accepted. <\/p><h2>Drawbacks of the internal rate of return <\/h2><p>Finally, we would like to point out that although the IRR is a widely used indicator, it does have some drawbacks that you should bear in mind: <\/p><ul><li>It may produce incorrect or misleading results when a project\u2019s cash flows change sign more than once, i.e. when there are alternating inflows and outflows of cash. <\/li><li>If projects of different durations or with different investment sizes are compared, the net present value results may be inconsistent or contradictory. <\/li><li>The IRR assumes that the cash flows generated by a project are reinvested at the same interest rate as the IRR, which may not be realistic or optimal. <\/li><\/ul><p>Did you find this post on how to calculate the internal rate of return interesting? Would you like to know how to take your project or business to the next level? Subscribe to Educa.Pro and discover all the latest updates! <\/p>","protected":false},"excerpt":{"rendered":"<p id=\"\">Find out how to calculate the internal rate of return to assess the profitability of your investments and make successful decisions<\/p>","protected":false},"author":3,"featured_media":3741,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3740","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/educa.pro\/en\/wp-json\/wp\/v2\/posts\/3740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/educa.pro\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/educa.pro\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/educa.pro\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/educa.pro\/en\/wp-json\/wp\/v2\/comments?post=3740"}],"version-history":[{"count":1,"href":"https:\/\/educa.pro\/en\/wp-json\/wp\/v2\/posts\/3740\/revisions"}],"predecessor-version":[{"id":10315,"href":"https:\/\/educa.pro\/en\/wp-json\/wp\/v2\/posts\/3740\/revisions\/10315"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/educa.pro\/en\/wp-json\/wp\/v2\/media\/3741"}],"wp:attachment":[{"href":"https:\/\/educa.pro\/en\/wp-json\/wp\/v2\/media?parent=3740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/educa.pro\/en\/wp-json\/wp\/v2\/categories?post=3740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/educa.pro\/en\/wp-json\/wp\/v2\/tags?post=3740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}