xirr

Hi All, I'm getting #Num error on using XIRR. My cash-flows are both +ve and -ve with the first period having +ve cash-flow. when I'm making 1st period cash-flow as -ve, I'm getting the result. Is it possible to compute XIRR with the original cash-flows having +ve cah-flow in 1st period? TIA :)

Hello all, I have a situation where I want to be able to calculate the XIRR of given distributions, combined with proceeds of a potential sale. In order to correctly calculate the XIRR, I have to create a new row that has all distributions to date and also the proceeds dictated by that given...

Hi, clever people. I am building a financial table to find the payoff value for a financial instrument that solves for the cash flow needed in each future period, on a discrete basis, such that an XIRR target is satisfied. Basically, I want to know what the dollar hurdle is to fully pay-off...

Hello, I am trying to write one XIRR formula that will calculate IRR for several loans (with different start dates). <tbody> Loans/Dates 15.01.2014 15.02.2014 15.03.2014 15.04.2014 15.05.2014 15.06.2014 15.07.2014 15.08.2014 15.09.2014 15.10.2014 15.11.2014 15.12.2014 XIRR Correct XIRR...

I've Googled and I've searched this site and I haven't found an answer that fully explains it to me. I was hoping somebody here could. (I'm waiting for the ah-hah! moment.) I have a series of cash flows related to tax credits. You can 'buy' tax credits at $0.75 on the dollar, then receive the...

Hello, I am having issues with the excel IRR function. My current cashflows are currently returning "#NUM!". I have tried adjusting the iterations and maximum change and my guess. Currently my formula looks like "=IRR(B4:B87,-0.3)" and my cashflows are the following: <colgroup><col...

I'm trying to calculate XIRR with various initial dates and an end dates. This is what I have now Date Column(monthly) Investment #1 Investment #2.... etc. 5/30/2014 xxxx(values) xxxx(values) . . . ...

Hi all, I've been trying to calculate the overall investment performance of my investment portfolio over a given time period. The portfolio has been funded via regular monthly amounts. My ultimate aim is to be able to compare the investment performance of any given portfolio over a set period...

Hello all, I would like to use the XIRR formula however not all my data start on the same date <tbody> 2006-06-30 2006-09-30 2006-12-31 2007-03-31 XIRR -200 10 205 16% -300 15 15 350 39% -100 105 22% </tbody> To sum up, I would like to be able to start a formula (XIRR) on th first...

Hello, I have used the function below to get the IRR on a chased project. For some reason it works only for the project on the first line (A in this case). If I would switch A and B on the first 2 lines then I would get only the IRR for B and zero for A. Any idea why it does not work for all...

Hi, Apologies if this has been asked previosuly. I have an XIRR formula running but the model i have set up can shift cashflows depending on the start date. Therefore i think i need the range for XIRR formula to shift in occordance with movement of the first negative cashflow. thanks, colin

I am trying to automate calculation of IRR for a range of scenarios. I have a bunch of problems with this: 1. On a full cycle basis, the project start dates are not equal which means that in certain scenarios I get 0% return as the first cash flow is zero. 2. On a point forward basis...

I use the XIRR function / formula a lot when I research stocks and mutual funds to get a feel for how the investments are doing over time. I don't just accept the printed return; I do my own research. I don't use the FV function a lot, but today as I was looking at the difference in the...

Hi all, stuck on a problem and haven't been able to find an answer elsewhere. I'm using excel 2007 on Windows 7. I'm trying to use XIRR on a non-continguous list of dates and values to get returns on a stock portfolio. A simplified version of my sheet is as follows. In A1:A20, I have dates...

Hi - I have a series of cashflows & dates going out to 2050. I have a target IRR of 10%. Going out to 2050 with my casfhlows definitely covers the 10% and more. I am trying to find a formula, or a way to be able to solve for how far out I need to go to hit my target IRR of 10%. Any thoughts...

I am working on calculating IRR for a project we are considering. Here is the projected cash flow: <colgroup><col span="12"><col><col span="26"><col><col><col><col><col span="10"></colgroup><tbody> ($1,354,953) ($989,464) ($462,155) ($462,155) $2,474,935 ($462,155) ($657,155) ($1,104,155)...

Haven't worked with XIRR before and couldn't find much help online, so thanks to anyone with the know how... Boss is writing a proposition: If purchase a new $76k piece of equipment, will save $16k/mo in labor costs. So I have: 01/01/01 -$76,000 XIRR in Cell C2 = XIRR($B$1:$B2,$A$1:$A2)...

Long time reader, first time poster :) I need to calculate gross xIRR for several companies in one fund. Each company has two columns (one for values and one for dates) How do I write the XIRR formula to combine multiple sets of columns? EX:Company A (Column A Values, Column B Investment...

I have a set of monthly cash flows that are distributed between investors based on IRR hurdles. The first hurdle is that the Primary Investor receives 100% of the Cash Flow until they have received a 20% return on their $80 Million investment. In the past, I have used interest as a way to...

Hello, I have read several threads on the difference between IRR and XIRR however I can not figure out why XIRR and IRR return (slightly) different results. For example: Assume I buy a 1 year, $100 bond with an 8% coupon. The payments would be as follows: <TABLE style="WIDTH: 265pt...