Stack Overflow
Stack Overflow

Questions tagged [irr]

The internal rate of return (IRR) or economic rate of return (ERR) is a rate of return used in capital budgeting to measure and compare the profitability of investments. It is also called the discounted cash flow rate of return (DCFROR) or the rate of return (ROR)

The internal rate of return (IRR) or economic rate of return (ERR) is a rate of return used in capital budgeting to measure and compare the profitability of investments. It is also called the discounted cash flow rate of return (DCFROR) or the rate of return (ROR)

88 questions
1
vote
0 answers

Package 'irr', function 'icc': Unrealistic p-values in output

I'm getting crazy over this issue: I'm computing (lots of) ICCs at the moment to assess the retest-reliability of brain-parameters using the function 'icc' in the package 'irr' by Matthias Gamer. However, I noticed several unrealistic p-values in…
Tobias
  • 11
  • 1
1
vote
0 answers

Dplyr calculation gives an error and stops running the calculations

I'm trying to calculate IRRs with cashflow datas that I have for my data's funds. I try this with following code: install.packages("tvm") library(dplyr) library(tvm) var1 <- my_data %>% group_by(Fund_name) %>% mutate(DATE = as.Date(DATE)) %>% …
Jaakko
  • 11
  • 1
1
vote
1 answer

Tidying data for calculation of ICC

I want to compute the IRR for a dataset with two raters (ICC2, Two-way-random-effects model). I wanted to use the ICC function from the psych-package but wonder how I need to restructure my data to have one row per participant and one column for…
joh_anna
  • 11
  • 2
1
vote
0 answers

Excel IRR: Can I use range reference inside IRR with math inside {}?

Good morning. In post "Excel IRR: can I use it referencing a combination of cells and fixed numbers? IRR({-10,11+A2})" is said we can math inside {} using CHOOSE function. But if I have first payment (investment) in B1, 100, and rest of income in a…
Rafael Rodriguez
  • 11
  • 1
1
vote
2 answers

Is weighted Kappa calculated by `irr` package in R wrong?

I found the irr package has 2 big bugs for the calculation of weighted kappa. Please tell me if the 2 bugs are really there or I misunderstood someting. You can replicate the bugs using the following examples. First bug: The sort of labels in…
Jingnan Jia
  • 1,108
  • 2
  • 12
  • 28
1
vote
1 answer

IRR calculation with Javascript

I have this code to calculate IRR (Internal Rate of Return) and it works like the IRR function in Excel (we have the cashflow values and the guess rate). This is working fine and I have the same results as the Excel function, but when the IRR tax is…
Caps Lock
  • 23
  • 4
1
vote
1 answer

Problem with loop to calculate IRR function in python

I have a problem with calculating a function in python. I want to calculate the IRR for a number of investment, all of which are described in their own dataframe. I have a dataframe for each investment up until a certain date, so I have a multiple…
user15730174
1
vote
1 answer

Need help calculating IRR for different investments at different dates for each investment, in python

I need help calculating IRR for different investments, and the IRR for those investments at different times. So a have one dataframe that looks like…
user15730174
1
vote
1 answer

How to generate a summary table (flextable) for r-markdown from irr output?

I have run 3 different Kappa2 analysis using the irr package. library(irr) data("diagnoses", package = "irr") # Analysis 1 kappa2(diagnoses[, c("rater1", "rater2")], weight = "unweighted") # Analysis 2 kappa2(diagnoses[, c("rater1", "rater3")],…
hato
  • 35
  • 4
1
vote
1 answer

Python IRR Function giving different result than Excel XIRR

I am using the following functions to perform IRR-Calculations with Python: from scipy.optimize import newton def xnpv(rate, values, dates): if rate <= -1.0: return float('inf') min_date = min(dates) return sum([ …
Daniel
  • 963
  • 1
  • 12
  • 29
1
vote
2 answers

How to calculate Internal Rate of Return (IRR) in .NET Core

I try to calculate an Internal Rate of Return (IRR) in a C# .NET Core 2.2 project. Is there any built in formula that I could use? From the MSDN documentation available here, you should be able to import the VisualBasic Namespace and its Financial…
XavierAM
  • 1,627
  • 1
  • 14
  • 30
1
vote
0 answers

Python - How evaluate Internal Rate of Return (IRR) trough interpolation for an array of generic dimension

Iìm working with Python and I would to define a function which allow to evaluate the internal rate of return (IRR) of a generic investment project trough the interpolation method. I know there are several module available which allow to evaluate it…
Giuseppe Vonella
  • 11
  • 2
1
vote
1 answer

What is the complexity of numpy's irr function?

Given an array of length n, assuming there is a solution for the internal rate of return, what is the complexity of the numpy irr() function? irr() source code I had a look at the code but wasn't able to calculate it myself.
Henry George
  • 504
  • 6
  • 19
1
vote
1 answer

How do I create an XIRR function based on unique names and between certain dates?

I'm trying to create an XIRR function that will calculate the return based on an unique investment names and corresponding cash flows between certain dates. For example, I want to calculate the IRR for Investment A between 01/16/2018 to 5/20/2018…
Shawn
  • 11
  • 2
1
vote
2 answers

numpy.irr Using Monthy Data

I am using a series of monthly data for my IRR calculation. It looks to me that this is set up to return the IRR based on annual data. Am I wrong? How does numpy.irr adjust for time periods? Thanks.
diogenes
  • 1,865
  • 3
  • 24
  • 51
1
2
3 4 5 6