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

IRR excel function with dynamic non contiguous cells

I am trying to calculate the IRR where the cells are not adjacent - Please see below. I have attempted to use Offset function and have had no success. Is there a way to calculate IRR for the below format? NSW | VIC | 2018 NSW | …
macv74
  • 11
  • 2
1
vote
2 answers

XIRR Calculation in Excel

I am trying to do an IRR formula by group. However my formula keeps giving an error. =IF(A2=A1," ",+XIRR(G:G,D:D,-0.1)) Can you please assist?
James
  • 489
  • 4
  • 13
  • 33
1
vote
1 answer

Krippendorff's Alpha using R - Error in sort.list(y) : 'x' must be atomic for 'sort.list' Have you called 'sort' on a list?

I'm trying to compute the inter-rater reliability between 3 raters and I have 7100 rows of data. So for example each row is like this: 5,4,3 > data <- read.csv("/home/xyz/Desktop/tc.csv", header=TRUE) > library(irr) Loading required package:…
Kvothe
  • 19
  • 3
1
vote
0 answers

Warning: Division by zero in php IRR Class

My screen shot on my project result I have a working IRR class but when i try using loop to create an array there is something different. when i input array manualy everything looks fine but when i use my while code Warning: Division by zero show…
Dicky Alfians
  • 21
  • 3
1
vote
2 answers

IRR library is only good if the pay period and compound period is in years (Engineering Economy)

http://docs.scipy.org/doc/numpy-1.10.0/reference/generated/numpy.irr.html The link above works for me only when the pay period and compound period are in years. If they in months or quarters, I don't know how to use it. You will understand what I am…
Jod doj
  • 11
  • 4
1
vote
1 answer

Calculate the percentage internal rate of return

Following is the code I am trying to use to get my result, and I am getting an error: import numpy array = [-1000,0,0,1094.60,0,0,1094.60] for b in array: a = round(numpy.irr(array), b-1) * 100 print (round(a,2)) Error: TypeError: 'float'…
Master
  • 59
  • 1
  • 2
  • 10
1
vote
2 answers

How to use IRR() function in VBA

I am trying to use the IRR function in VBA. IRR() works well in Excel. As I scripted it in VBA as follows, a = Array(3, 4, 5) b = IRR(a, 0.1) it complained of "Compile error: Type mismatch: array or user-defined type expected". What dumbfounds me…
Hans
  • 1,269
  • 3
  • 19
  • 38
1
vote
1 answer

How to Calculate IRR in SSRS reports dynamically

Can you please let me know that how we can write code for irr calculation in SSRS Reports. IRR basically requires two parameters i.e. Payments array and guess value. But i don't know how to build array dynamically in SSRS reports.
user1969110
  • 11
  • 1
1
vote
2 answers

Computing IRR using optim

I want to find the internal rate of return (IRR), basically the 'rate' that makes my NPV function go to zero, using the optim function. My current code for the NPV function (which works) is: npv <- function(rate, cf){ r_v <- rep (rate,length…
dhhs91
  • 11
  • 3
1
vote
1 answer

Combining ranges/arrays to feed into IRR

I want to use the IRR function in Excel; however, my inputs exists in a non-contiguous range. For example, I want to know the return of an asset over time (each row is a time period). Column A has the cost (cash outflow) of owning the asset/…
Agrim Pathak
  • 3,047
  • 4
  • 27
  • 43
1
vote
2 answers

Different results for IRR computation between R and MS Excel

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. I wrote some R code to calculate the internal rate of return (IRR) like…
showkey
  • 482
  • 42
  • 140
  • 295
0
votes
1 answer

Calculate IRR using custom functions with monthly payment

How should I modify the code to calculate the IRR based on the monthly payment? Because the value I obtained from the code does not match with the value I calculated manually via XIRR. I would like to calculate the IRR of my savings insurance based…
ErnestHub
  • 3
  • 2
0
votes
1 answer

Calculate IRR using custom functions in Excel VBA

I would like to calculate the IRR of my savings insurance based on the total premium paid, years of payment, policy years, and the value received at the end of policies. For example: total premium paid = 50,000 years of premium payment = 5 policy…
ErnestHub
  • 3
  • 2
0
votes
0 answers

How(what) to plot (for) results of negative binomial glmm with categorical variables against counts?

I have count data for an ungulate species from two sites (here made up for the question). I want to know how to showcase results of categorical variable in this analysis. I first thought the graph I am getting have incidence rate ratios, but then…
Zaara Kidwai
  • 13
  • 3
0
votes
1 answer

Big Difference in XIRR vs IRR calculation

Background I am getting substantially large variation in XIRR vs IRR calculations. Problem & Help requested Can someone please explain why I get two very different outcomes, and which method is more accurate? I've provided an example of cashflows…
Bobby Heyer
  • 531
  • 5
  • 18
1 2
3
4 5 6