# Calculo TIR (IRR)

**URL:** <https://forum.knime.com/t/calculo-tir-irr/47445>\
**Category:** KNIME Analytics Platform\
**Created:** [September 21, 2022, 5:41pm UTC](https://forum.knime.com/t/calculo-tir-irr/47445 "2022-09-21T17:41:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pedro87](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/ebca7d/32.png) [@Pedro87](https://forum.knime.com/u/Pedro87)\
**Post date:** [September 21, 2022, 5:41pm UTC](https://forum.knime.com/t/calculo-tir-irr/47445/1 "2022-09-21T17:41:34Z")

</div>

Hello, good afternoon, I present the following query on how to calculate the IRR for my workflow, look for information in the forum and find material, but I think it does not suit my needs or functionality. I explain in detail the requirement:

I present a database with 10 thousand credit records which I need to calculate the IRR for each record. Currently I calculate them manually using the following attached file called (CAEV revision) which I only have to manually enter the data in the following fields:  
[Revisión CAEV.xlsx](https://forum.knime.com/uploads/short-url/w0bEtOtUUOUE4Z6YxEnqeoZl1fO.xlsx) (12.6 KB)

Total prepaid cost  
Pending deadline  
Quota value  
Capital credit balance

Then automatically the excel called (CAEV review) generates the IRR (screen print is attached)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/3/031bd74fa9e9cc1721aaa3d663c381ab9db6f15a.png)

A database called “Sample Base” is attached where the fields to be used to calculate the IRR for each record are:  
[Base Muestra.xlsx](https://forum.knime.com/uploads/short-url/fXNdLErz94V0QXYOyJSustzvTrE.xlsx) (1.7 MB)

TERM\_OF\_CREDIT\_PENDING\_MONTHS  
TOTAL\_COST\_OF\_PREPAYMENT\_CLP  
QUOTA\_VALUE\_CLP  
CLP\_CREDIT\_BALANCE

Thank you very much for the support and help in my query

---

<div class="post-metadata">

**Author:** ![gonhaddock](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gonhaddock/32/35425_2.png) [@gonhaddock](https://forum.knime.com/u/gonhaddock)\
**Post date:** [September 22, 2022, 7:34am UTC](https://forum.knime.com/t/calculo-tir-irr/47445/2 "2022-09-22T07:34:10Z")

</div>

Hello @Pedro87  
There are a couple of solutions already discussed and shared in the Forum:

1. the KNIME component by @Residentstiefel  
[IRR Calculation with KNIME - #11 by Residentstiefel](https://forum.knime.com/t/irr-calculation-with-knime/36981/11)

2. The R script solution that I shared:  
[R Script \_ Calculate NPV - IRR and XNPV - XIRR workflows](https://forum.knime.com/t/r-script-calculate-npv-irr-and-xnpv-xirr-workflows/37634)

BR

PS.- The file that you shared is showing own names, and if no mock names it would be breaching some data protection regulations.  
I would suggest to use encrypting techniques for the private data and rewrite the post again. This one could be kindly removed by the admin team if you will.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [December 21, 2022, 7:34am UTC](https://forum.knime.com/t/calculo-tir-irr/47445/3 "2022-12-21T07:34:18Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

---

<div class="post-metadata">

**Author:** ![paolotamag](https://forum-cdn.knime.com/user_avatar/forum.knime.com/paolotamag/32/1061_2.png) [@paolotamag](https://forum.knime.com/u/paolotamag)\
**Post date:** [December 21, 2022, 3:42pm UTC](https://forum.knime.com/t/calculo-tir-irr/47445/4 "2022-12-21T15:42:31Z")

</div>

Hi there, new verified components came out this month.  
Take a look at this message from a similar thread.

> [@IRR Calculation with KNIME](https://forum.knime.com/t/irr-calculation-with-knime/36981/15):
>
> Hi there, 5 new verified components came out this month. One of these can compute IRR. Take a look at this message from a similar thread: [https://forum.knime.com/t/how-to-calculate-irr-in-knime/40900/20?u=paolotamag](https://forum.knime.com/t/how-to-calculate-irr-in-knime/40900/20)
