Stack Overflow
Stack Overflow

Questions tagged [xirr]

Excel formula which returns the internal rate of return for a schedule of cash flows

44 questions
0
votes
0 answers

XIRR function with extremely low ending value

I have a macro that calculates XIRR; used to tell me the rate of return on an investment. The relevant code is: Dim CFArray() As Variant CFArray = Range("Q22:Q24").Value Dim DateArray() As Variant DateArray = Range("L22:L24").Value ROR =…
0tts
  • 1
  • 1
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
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
1 answer

Can I apply the XIRR function from tvm library for each row in my table, where the cash flows already on that row?

This is my first question, so I apologize in advance if it's not a perfectly asked question. I already searched all over Stack Overflow (& Google), but was unable to find what I am looking for. Also, I'm new to R and am learning it on my own as I…
russianin
  • 13
  • 3
0
votes
1 answer

Calculating XIRR in SQL

I have been trying to find a solution to calculate XIRR in SQL (TSQL). Ideally, the values would match the values that Excel calculates using the same input data. I have found several suggested solutions around the web but all seem to be flawed in…
cbrawl
  • 875
  • 1
  • 9
  • 24
0
votes
1 answer

Calculate Year-on-Year Return using XIRR function and non-contiguous data

I have input data as below wherein "Investment" was made on "Date" in Column-A and "Return" (Column-C) is as of today. Date Investment Return 03-Jan-2011 -2000.00 5467.78 03-Oct-2011 -2000.00 6021.89 01-Nov-2011 -2000.00 …
Kingshuk Roy
  • 1
0
votes
0 answers

XIRR function from TVM package in R

I am trying to leverage the tvm package in R to calculate XIRR for a set of cash flows and dates. I have a moving window, where I start off with i = 1 , CF = CF[1], d = d[1] and as I progress forward , the rest of the cash flow gets involved. I…
UGuntupalli
  • 769
  • 1
  • 9
  • 22
0
votes
2 answers

XIRR Formulae For each investment

I am trying to apply an XIRR Formulae so that the percentage of each investment is calculated separately. I attempted an IF formulea an was not successful. I need to amend the below formulae. This will be useful as i am trying to apply it to 200…
James
  • 489
  • 4
  • 13
  • 33
0
votes
2 answers

Why am I getting NaN from this XIRR function?

This one is driving me up the wall. UPDATE: Assembled in a jsfiddle that yields NaN: https://jsfiddle.net/eqcww2y7/6/ I'm using this XIRR function: https://gist.github.com/ghalimi/4669712 And into that function, I'm sending a simple pair of arrays -…
Wogan
  • 1,335
  • 12
  • 17
0
votes
0 answers

XIRR Formula - Summing Total in alternate column

Struggling to think my way through this. Have borrowed the formula from another on the forum. The Formula works fine if the current value of the stock, marked orange, is in the same Column as the purchases, but I have my current values in an…
Domaldhino
  • 1
  • 2
0
votes
3 answers

Php financial XIRR not giving strange results

I'm using the XIRR function from the php financial library (http://www.phpclasses.org/package/892-PHP-Financial-functions-with-the-Excel-function-names-.html) but I get strange results with these values (dates are d/m/y): (01/01/2014, -400) ,…
gonel
  • 1
  • 2
-1
votes
0 answers

Calculation of XIRR against multiple users and multiple fund investments in Excel

The objective of the question is to calculate XIRR values for multiple users who have invested in multiple funds irregularly over the years and may have redeemed few values as well. The data storage format is shown as under: The Stamp duty (are…
Ankit Sharma
  • 11
  • 4
-1
votes
1 answer

How to run a function on multiple csv's at the same time

I have a set of 3 csv's which are all saved in the below directory: setwd("~/R/CashFlows") The csv's are named: "Cashflows1.csv" "Cashflows2.csv" "Cashflows3.csv" And are all in a form similar to the below (the below example is…
Ringo145
  • 7
  • 6
-1
votes
1 answer

Excel XIRR information without additional columns

I have an Excel sheet such that each row contains A date The total amount of money used to purchase stock up to that date The current value of the stock on that date What is the most efficient way to use xirr to compute the return on each row as…
BaronFiner
  • 154
  • 5
1 2
3