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 (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] A database called “Sample Base” is attached where the fields to be used to calculate the IRR for each record are: Base Muestra.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

Calculo TIR (IRR)

paolotamag December 21, 2022, 3:42pm 4

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

1 Like