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
0
votes
1 answer

Dynamic IRR calculation. Is there a way to add zeros after the terminal amount is added?

I am building out a dashboard that allows you to add in a disposal date and amount which will add the data to the current modelled cashflows and recalculate the IRR. The issue I am having is trouble zeroing all of the cells after the new disposal…
Myles Collier
  • 23
  • 1
  • 6
0
votes
1 answer

Calculating multiple IRRs from a panda dataframe

I have a Panadas dataframe which encompasses 4 columns (company, price today, cash flow y1, cash flow y2, cash flow y3 (i.e. a terminal…
Teddy P
  • 1
  • 1
0
votes
1 answer

IRR double type array conversion from a variant type

Sorry if the question is stupid since I'm new to VBA. The problem arises in the beginning since an excel IRR cannot calculate a changing column in a simulation(only calculates the initial values not the values in the following loops). So I went for…
Mic432412e
  • 51
  • 3
0
votes
1 answer

Is there a way to implement the IRR algorithm in PuLP?

Numpy has a function which allows me to calculate the IRR of an array of floats. My problem is that I am trying to use it within a PuLP problem, and the array that I want to pass to the function is compossed of the variables of the problem. Here i …
theMan
  • 23
  • 5
0
votes
0 answers

Implementing Brent's method in Clojure to find IRR

I'm trying to use brents method for calculating the internal rate of return. Using this as a template Brent's Method I currently have this code: (defn discount-factor [discount-rate n] (/ 1 (utils/exponent (+ 1 (/ discount-rate 100))…
Peder.August
  • 19
  • 8
0
votes
1 answer

argument must be a string or a number, not 'LpAffineExpression'

I am trying to use python IRR function with PULP maximisation but i am getting the following error TypeError: float() argument must be a string or a number, not 'LpAffineExpression' TypeError Traceback (most recent…
Shobhit Mishra
  • 1
0
votes
2 answers

How to add additional rows to an imported csv?

I am currently loading multiple csv-files into R in the following form: read.csv("Cashflows2.csv", header = F, ) V1 V2 1 Date Payments 2 18/08/2017 -20495* 3 18/04/2018 639.76* 4 18/05/2018 639.76 5 18/06/2018 639.76 6…
Ringo145
  • 7
  • 6
0
votes
1 answer

Calculating the annualized internal rate of return

How would i write a simple function to calculate the annualized internal rate of return for the below dates and payments in csv form: 19/10/2003 -13275 19/11/2003 940.49 19/12/2003 884.71 19/01/2004 832.11 19/02/2004 782.49 19/03/2004 …
Ringo145
  • 7
  • 6
0
votes
0 answers

Small difference between discount rates, big difference between PV?

I calculated the following in Matlab 2019a, see code below. I was surprised about the big difference in present values (DiffPV, DiffPVpercentage) for only a small difference (DiffIRR, DiffIRRpercentage) in discount rates. Is there a coding error…
LenaH
  • 313
  • 2
  • 14
0
votes
1 answer

Remove all rows for a key with no sign change in a specific variable

I am trying to run an xirr function on several ID's but I get an error message saying: Error in uniroot(xnpv, interval = interval, cf = cf, d = d, tau = tau, : no sign change found in 1000 iterations Is there any way to remove all rows for…
Amanda Johansson
  • 15
  • 2
0
votes
0 answers

How to get formula value from workbook cell without using apache poi

I am applying IRR formula in workbook using apache poi and able to see the value in excel sheet. But am getting the value as #NUM! when I tried to retrieve the value using FormulaEvaluator. Example Cell cell = contentRow.createCell(3); …
Prem Kumar
  • 9
  • 3
0
votes
2 answers

Excel IRR: can I use it referencing a combination of cells and fixed numbers? IRR({-10,11+A2})

Most Excel users are probably familiar with the syntax of Excel's IRR formula: https://support.office.com/en-us/article/irr-function-64925eaa-9988-495b-b290-3ad0c163c1bc I can use IRR using only fixed numbers, and without referencing cells,…
Pythonista anonymous
  • 8,140
  • 20
  • 70
  • 112
0
votes
1 answer

calcualte numpy IRR with inconsistent frequencies across pandas data frame

My questions is not around how to calculate IRR (internal rate of return) but rather given a data set similar to the below, how to best calculate IRR without waiting months for the result when the sample size dramatically increases. I am using the…
RK1
  • 2,384
  • 1
  • 19
  • 36
0
votes
0 answers

"Argument is not valid" error Financial.IRR C#

I am having trouble resolving the Financial.IRR function in C#. I know I have to provide a good guess value so that that error doesn't come, but the problem is that I don't know the inputs. They are generated based on different inputs and added to a…
laskdjf
  • 1,166
  • 1
  • 11
  • 28
0
votes
0 answers

Trying to calulate irr using sql stored procedure, help needed

CREATE procedure testXIRR ( @AmountEstimate as float = 0, @AmountGoal as float = 0, @AmountPrecision as float = 1e-7 , @AmountPrevious as float = 0, @EndDate as date = null, @FlagError as bit = 0, @FlagLoop as bit = 1, @Rate as float =…
aakash singh
  • 63
  • 8
1 2 3 4
5
6