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

Restructuring data (for IRR-analysis)

I have the following data-frame df (fictitious data) with several variables var1, var2, ..., var_n: var1<-c("A","A","A","B","A","C","C","A", "A", "E", "E", "B") var2<-c(NA,"1","1","5","6","2","3","1", "1", "3", "3",…
D. Studer
  • 1,711
  • 1
  • 16
  • 35
0
votes
1 answer

IRR calcluation : ValueError: invalid literal for float():

I am trying to calculate IRR and its giving me result in command line but whenever I am trying to pass the values as a parameter its failing with below error Code import numpy import sys def irrYearly(array): array = [array] irr =…
Abhis
  • 585
  • 9
  • 25
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
1 answer

How to calculate required cash flow for XIRR to get target return rate

I have the following dates and numbers: 1/1/2015, 6/1/2015, 12/1/2015, and 3/1/2016 with respective numbers -$1M, $100K, $100K, and X. I'm using the XIRR function. How do I solve for X so that I can get an XIRR for whichever target rate (let's say…
lostinOracle
  • 408
  • 1
  • 4
  • 14
0
votes
1 answer

How do I get R to calculate a negative IRR scenario?

I have been doing stochastic cash flow modeling. In some of these scenarios, IRR is negative (cash flows out exceed cash flows in over time). R seems to hate this. I get a uniroot error. I have used the FinCal package irr function, and I even tried…
James
  • 341
  • 3
  • 6
0
votes
1 answer

Objective C IRR calculation compared to Excel IRR function

The discussion below provides codes in Objective C IRR calculation that is consistently incorrect when compared to Excel IRR function. Does anyone know why there is such a difference? The code used is offered in this previous…
MikeLondonUK
  • 140
  • 1
  • 8
0
votes
1 answer

Finding root using finmath library in java

I am trying to implement the Internal Rate Of Return of some cashflows. 0 = (c1/(1+r)) + (c2/(1+r)^2) + (c3/(1+r)^3) .... like formula and we will be finding the root r. At this point I am end up with a java library called finmath. It has a…
gurkan
  • 3,457
  • 4
  • 25
  • 38
-1
votes
1 answer

How to calculate a rolling IRR in python pandas

I have dataframe with two columns: CFs and NAV,(cashflows and net asset valuation) now want to calculate the rolling IRR. Any suggestions are welcome. Example: CFs NAV -100 100 1 101 2 103 3 106 2 108 110 0
Song Zhibo
  • 39
  • 1
  • 4
-1
votes
1 answer

SQL Floating Point Error with IRR Calculation

I had a coworker that wrote an IRR calculation function. You supply what seems to be set of cash flows, and it returns the IRR. It works 99% of the time but sometimes I get a floating point error. I am trying to figure out where in the code that…
Mwspencer
  • 1,142
  • 3
  • 18
  • 35
-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

Calculate the future value for only one category using the IRR (Python)

import xlrd import numpy fileWorkspace = 'C://Users/jod/Desktop/' wb1 = xlrd.open_workbook(fileWorkspace + 'assign2.xls') sh1 = wb1.sheet_by_index(0) time,amount,category = [],[],[] for a in range(2,sh1.nrows): …
Jod doj
  • 11
  • 4
-1
votes
2 answers

IRR Function to return also negative values

GO /****** Object: UserDefinedFunction [dbo].[fn_IRR] Script Date: 7/28/2014 11:43:40 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[fn_IRR] ( @str varchar(max), …
CiucaS
  • 2,010
  • 5
  • 36
  • 63
-2
votes
1 answer

Modelling Loan Payments - Calculate IRR

Working with loan data. I have a dataframe with the columns: df_irr = df1[['id', 'funded_amnt_t', 'Expect_NoPayments','installment']] ID of the Loan | Funded Amount | Expected Number of Payments | fixed instalment of the annuity. I have estimated…
Wisdom Analytics
  • 5
  • 2
1 2 3 4 5
6