{"id":267131,"date":"2024-03-13T20:09:09","date_gmt":"2024-03-13T19:09:09","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=267131"},"modified":"2026-11-16T15:16:08","modified_gmt":"2026-11-16T14:16:08","slug":"calcular-tir-excel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/excel-functions\/how-to-calculate-irr-in-excel-irr-function-formula\/","title":{"rendered":"\u00bfC\u00f3mo calcular la TIR en Excel? (Funci\u00f3n y f\u00f3rmula IRR)"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>The internal rate of return (IRR) is a concept in financial modeling commonly used in combination with net present value (NPV). The formula in Excel is used to estimate the rate of return an investment would give based on a series of cash flows, usually presented as a percentage (\u20183%\u2019). The NPV, on the other hand, is expressed as a cardinal number (\u20183\u2019). Both play a key role in making investment decisions when presented with more than one opportunity, as we will show here.<\/p>\n<p>This article will provide step-by-step guidance on how to use the IRR formula to effectively calculate the IRR for investment decisions. If you work in Google Sheets instead, see <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/irr-formula-in-google-sheets\/\">how to use the IRR formula in Google Sheets<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-use-the-irr-function-in-excel&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to use the IRR function in Excel?<\/h2>\n<p>We will first explain how to use the IRR function in Excel to calculate the rate of annual return for an initial investment. If you need to calculate return rates for different time periods or a future value, Excel also offers a variety of financial functions, such as XIRR or MIRR.<\/p>\n<h3>What is the formula for calculating IRR?<\/h3>\n<p>The syntax for the IRR formula is:<\/p>\n<p>=IRR(values,[guess])<\/p>\n<ul>\n<li><strong>values:<\/strong> This argument is required. It refers to the cash flows, the initial investment (as a negative figure), and net income (as a positive figure).<\/li>\n<\/ul>\n<p><strong>IMPORTANT:<\/strong> It is important that the initial investment and cash flows maintain the same sequence, as the IRR formula will interpret them in this very order. Moreover, for the IRR function to work properly, the argument should be a number. If it is a logical value, text, or an empty cell, it will be ignored.<\/p>\n<ul>\n<li><strong>[guess]:<\/strong> This argument is optional. It is an estimation of the number closest to the expected IRR (as there can be two). If not included, the argument will show the default value of 0.1 (=10%).<\/li>\n<\/ul>\n<p>Let\u2019s now apply the IRR formula, to the following scenario:<\/p>\n<p>You are a business owner and you are presented with two investment opportunities, A and B. The first has an initial investment of $2,500,000.00, whereas the second has one of $2,800,000.00. The net income for each is presented on a yearly basis. The IRR function can help you get an idea of what the return rate would be based on the initial investment and the yearly cash inflows:<\/p>\n<p><strong>1.<\/strong> Option A has an initial investment of $2,500,000.00 with the following yearly cash flows.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-formula-excel-option-a-cash-flows.webp&#8221; alt=&#8221;IRR formula Excel \u2014 initial investments of -$2,500,000 for A and -$2,800,000 for B with yearly income for years 1 to 10&#8243; title_text=&#8221;Initial investments of -$2,500,000 for A and -$2,800,000 for B with yearly income for years 1 to 10&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Type in \u2018IRR\u2019 in the cell you wish to showcase the IRR value.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-formula-excel-function-dropdown.webp&#8221; alt=&#8221;IRR formula Excel \u2014 =IRR typed in cell B12 with a functions drop-down listing IRR, MIRR, and XIRR&#8221; title_text=&#8221;=IRR typed in cell B12 with a functions drop-down listing IRR, MIRR, and XIRR&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> As soon as you select from the drop-down menu, you will automatically be prompted to select the cell range that you wish to perform the IRR calculation on.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-formula-excel-select-cell-range.webp&#8221; alt=&#8221;IRR formula Excel \u2014 =IRR(B1:B11) entered in cell B12 with the option A cash flows selected&#8221; title_text=&#8221;=IRR(B1:B11) entered in cell B12 with the option A cash flows selected&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> Once you press the Return key you will be shown the IRR percentage. Remember that IRR is represented as a percentage, whereas NPV is a cardinal number. Here, we get a return of 5%.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-formula-excel-option-a-result.webp&#8221; alt=&#8221;IRR formula Excel \u2014 cell B12 returns an IRR of 5% for option A&#8221; title_text=&#8221;Cell B12 returns an IRR of 5% for option A&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5.<\/strong> Now, let\u2019s calculate the IRR for Option B with an initial investment of $2,800,000.00 and the following yearly cash flows.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-formula-excel-option-b-cash-flows.webp&#8221; alt=&#8221;IRR formula Excel \u2014 option B column with -$2,800,000 initial investment and $425,000 yearly income, IRR cell D12 empty&#8221; title_text=&#8221;Option B column with -$2,800,000 initial investment and $425,000 yearly income, IRR cell D12 empty&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6.<\/strong> We would input the formula in the same way we did previously in steps 2-3.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-formula-excel-option-b-formula.webp&#8221; alt=&#8221;IRR formula Excel \u2014 =IRR(D1:D11) entered in cell D12 with the option B cash flows selected&#8221; title_text=&#8221;=IRR(D1:D11) entered in cell D12 with the option B cash flows selected&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>7.<\/strong> Here, we get an IRR of 8%.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-formula-excel-option-b-result.webp&#8221; alt=&#8221;IRR formula Excel \u2014 IRR row showing 5% for option A and 8% for option B&#8221; title_text=&#8221;IRR row showing 5% for option A and 8% for option B&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>The information obtained so far would help us decide solely based on the IRR; it is common practice to go for the higher percentage. Considering that Option A provides an IRR of 5% and B of 8%, we would opt for investing in project B. However, if the cash flows were on a monthly basis, our decision-making could be more precise. By following these steps, you can easily learn how to calculate IRR in Excel for monthly cash flow.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-calculate-irr-using-npv-in-excel&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to calculate IRR using NPV in Excel?<\/h2>\n<p>As mentioned in the Introduction, the NPV is expressed as a cardinal number, as opposed to the IRR which is expressed as a percentage. It is used to calculate the difference between current cash inflow and outflow over a period of time. Make note that the \u201crate\u201d referred to in the NPV formula is not the same as the rate obtained using the IRR formula shown previously:<\/p>\n<ul>\n<li><strong>rate:<\/strong> refers to the <strong>discount rate<\/strong> for the investment period. This discount rate is a generic term used to refer to any rate that is established, subjectively or objectively, to discount future cash flows with. Moreover, for more reliable decision-making, we should always apply a <strong>lower and a higher discount rate<\/strong> for all investment options.<\/li>\n<li><strong>values:<\/strong> refer to the <strong>initial investment<\/strong> (represented as a negative value) and the cash <strong>inflows<\/strong> over the given time periods.<\/li>\n<\/ul>\n<p>Let\u2019s say that we apply a 5% discount rate (this could represent the lower rate) to both investment opportunities.<\/p>\n<p><strong>1.<\/strong> Type in \u2018NPV\u2019 in the cell you want to obtain the NPV formula.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-excel-npv-function-dropdown.webp&#8221; alt=&#8221;IRR in Excel with NPV \u2014 =NPV typed in cell B14 below a 5% lower discount rate, with NPV and XNPV in the drop-down&#8221; title_text=&#8221;=NPV typed in cell B14 below a 5% lower discount rate, with NPV and XNPV in the drop-down&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> As the first parameter corresponds to the discount rate, we first need to add cell B13 followed by the sum of cash flows, and finally add all to the initial investment.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-excel-npv-full-formula.webp&#8221; alt=&#8221;IRR in Excel with NPV \u2014 =NPV(B13,B2:B11)+B1 entered for option A&#8221; title_text=&#8221;=NPV(B13,B2:B11)+B1 entered for option A&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> Press the Return key to obtain the NPV value ($50,196.47).<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-excel-npv-option-a-result.webp&#8221; alt=&#8221;IRR in Excel with NPV \u2014 option A NPV of $50,196.47 at the 5% lower discount rate&#8221; title_text=&#8221;Option A NPV of $50,196.47 at the 5% lower discount rate&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> To calculate the NPV for investment option B, follow steps 1-3.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-excel-npv-option-b-result.webp&#8221; alt=&#8221;IRR in Excel with NPV \u2014 option B NPV of $481,737.34 next to option A&#8217;s $50,196.47 at 5%&#8221; title_text=&#8221;Option B NPV of $481,737.34 next to option A&#8217;s $50,196.47 at 5%&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>As mentioned before, we would now need to calculate the NPV for a higher discount rate (8%) for both investment opportunities. Once again, let\u2019s start with option A.<\/p>\n<p><strong>5.<\/strong> We have included a second row where we will calculate the NPV applied to the same values as before, but this time include cell B15 as the discount rate.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-excel-npv-higher-discount-rate.webp&#8221; alt=&#8221;IRR in Excel with NPV \u2014 =NPV(B15 typed in cell B16 after an 8% higher discount rate row&#8221; title_text=&#8221;=NPV(B15 typed in cell B16 after an 8% higher discount rate row&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6.<\/strong> Proceed to apply values to the NPV formula and press the \u201creturn\u201d key to obtain the result:<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-excel-npv-higher-rate-option-a.webp&#8221; alt=&#8221;IRR in Excel with NPV \u2014 option A NPV of -$322,993.22 at the 8% higher discount rate&#8221; title_text=&#8221;Option A NPV of -$322,993.22 at the 8% higher discount rate&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>7.<\/strong> For investment option B, we have followed steps 5 and 6 and obtained the following:<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-excel-npv-higher-rate-option-b.webp&#8221; alt=&#8221;IRR in Excel with NPV \u2014 option B NPV of $51,784.59 at 8% next to option A&#8217;s -$322,993.22&#8243; title_text=&#8221;Option B NPV of $51,784.59 at 8% next to option A&#8217;s -$322,993.22&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Based on the obtained results, we decide on Option B. Why? Because both the NPV and IRR are higher in both discount rate scenarios:<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/irr-excel-npv-best-option-b.webp&#8221; alt=&#8221;IRR in Excel with NPV \u2014 option B&#8217;s IRR and NPV cells highlighted green and option A&#8217;s red at both discount rates&#8221; title_text=&#8221;Option B&#8217;s IRR and NPV cells highlighted green and option A&#8217;s red at both discount rates&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>The IRR formula can only be used in instances where the cash flow distribution occurs over the same time periods (yearly, monthly, etc.). If you want to calculate the rate of return for different time periods, use the <a href=\"https:\/\/www.sheetgo.com\/blog\/excel-functions\/xirr-function-excel\/\">XIRR formula in Excel<\/a>. This selects the cash flow range and then the range of dates on which the cash flows are made.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-do-you-calculate-irr-manually&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How do you calculate IRR manually?<\/h2>\n<p>If you are advanced in math or aren\u2019t interested in calculating IRR in Excel, this is what you would need to do to calculate IRR manually:<\/p>\n<p><strong>1.<\/strong> Estimate two discount rate values (i.e., 4% and 8%) to try and set the NPV to zero.<\/p>\n<p><strong>2.<\/strong> Calculate the NPVs using 4% and 8% and try to get as close to zero as you can.<\/p>\n<p><strong>3.<\/strong> Once you determine your two discount rate values and the two NPVs, you can use this formula to calculate the IRR:<\/p>\n<pre class=\"hljs language-ini\">IRR = R1 + ( (NPV1 * (R2 - R1)) \/ (NPV1 - NPV2) )<\/pre>\n<p><strong>4.<\/strong> R1 corresponds to the lower discount rate (4%) and R2 is the higher one (8%). NPV1, on the other hand, represents the higher NPV, and NPV2 the lower.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>This article has explained the concepts of IRR and NPV, followed by a step-by-step process showing how to calculate IRR in Excel, how to use the IRR function in Excel in combination with NPV function, and finally broken down the use of IRR by explaining how to calculate IRR manually.<\/p>\n<p>Whether you wish to explore further on financial functions or apply the functions seen in this post to real-time investments, you will find the article on <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/googlefinance-formula-google-sheets\/\">How to use the GOOGLEFINANCE Function in Google Sheets<\/a> very useful.<\/p>\n<p>To run the same check in Google Sheets, read <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/npv-formula-in-google-sheets\/\">how to use the NPV formula in Google Sheets<\/a>. For a full valuation built on discounted cash flows, start from our <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/dcf-model-google-sheets\/\">DCF template in Google Sheets<\/a>. If your cash flow figures live in several spreadsheets, <a href=\"https:\/\/www.sheetgo.com\/virtual-employees\/finance\/\">Sheetgo&#8217;s AI finance virtual employee<\/a> can pull them into one up-to-date file.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Usa la f\u00f3rmula IRR en Excel para hallar la tasa interna de retorno (TIR) de una inversi\u00f3n. Compara dos proyectos con la TIR y el VAN, y aprende a calcular la TIR a mano.<\/p>","protected":false},"author":2,"featured_media":267147,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[65],"tags":[],"class_list":["post-267131","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-functions"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/267131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=267131"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/267131\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/267147"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=267131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=267131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=267131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}