xirr

Hello! My name is Cristian and I'm from Ushuaia, Argentina, so, my apologies if I write it incorrectly. I have a problem using XIRR in Excel (and Openoffice Calc) When I use this cashflow feb-07-2014 -20000 mar-12-2014 73375.05 sep-10-2014 4400 oct-10-2014 4400 nov-10-2014 4400 dic-10-2014...

Hi there, hope someone can help me with this. I've searched previous posts and can find loads of really useful information, but I can;t seem to find a solution to this one :-( Basically I have data in a sheet that is based on dates across the columns and then rows with values that correspond...

I'm trying to create an XIRR function that will calculate the return based on an unique investment names and corresponding cash flows between certain dates. For example, I want to calculate the IRR for Investment A between 01/16/2018 to 5/20/2018 with the following cash flows...

Hello, I have a series of cash outflows and inflows over 144 months. The first 24 months are cash outflows - the next 120 month cash inflows. My sheet is set up as follows Row 1 - Numbered 1-144 Row 2 - Months (Beginning 8/1/18 thru 144 months) Row 3 - Cash flows Currently my sheet calculates...

Hi, I'm trying to figure out why XIRR and IRR are showing different returns in this case (simple bond math). These are the cash flows: 4/30/2018: -1,000 5/1/2018: 100 5/1/2019: 100 5/1/2020: 100 5/1/2021: 100 5/1/2022: 100+1,000 IRR returns 10%, which makes sense. XIRR returns 13%. Could...

Hi everyone, I am trying to create a dynamic XIRR formula as I am working on a case study that involves a sensitivity analysis to see changes exit years. How could I go about writing an XIRR formula that ignores 0's while still calculating the correct XIRR? Below is a cut out from my file. There...

I have a stream of cash flows for a financial model that I am building (pasted below). I am trying to calculate the IRR of the Gross and Net lines. For the Gross line, I entered the following formula =XIRR(G19:AD19,G17:AD17,0.5) and I get the result of 47.16%. I then try to verify that XIRR...

Although there have been helpful discussions about Excel 2013's XIRR function using non-contiguous cells, I can't get any suggestions to work in my particular situation. Below is an excerpt from a large spreadsheet covering a number of years. It shows some formulas that work and some that don't...

So I work for a hedge fund/private equity administrator. We have a client that provided us with a loan portfolio and asked us to provide a spreadsheet showing the IRR for each deal. Simple enough. But all his loans are paid back, with interest, in a single payment within weeks to months. I...

Hi, I have a target goal of getting a 20% XIRR return on 3/31/2018. As you can see. My current IRR is -97%. What formula would tell me that I need X amount for 3/31/2018 to reach my goal of getting a exact 20% XIRR? <colgroup><col span="11"><col><col span="4"><col><col...

Hello, I am using a XIRR formula to calculate cash flows at different dates for multiple investments but for a reason that I ignore, the last investment (the 50th of many) I entered returned me a #NUM error as the IRR will be negative. But the same exact formula was used to calculate negative...

I am trying to create an XIRR table that can give me a returns on a certain number of periods (months). The IRR works 12 months at a time. For example if I did a $1,333,500 investment and over 3 years (table on the right) I would get a IRR of 20.4% But what I am trying to figure out if the 3...

Hi there, I have a long XIRR calculation that keeps returning 0.00% even though the negatives are significantly outweighed by the positives (-2,607,471 and +4,661,616). I tried pasting the calculation below but it just came out as text and isn't formatted correctly. I think there may be...

Hi, I'm running a savings scenario where the ending value of my investment ends up being less than the total contributions based on monthly returns during a down market period, but the XIRR is returning a 0.00% instead of a negative percentage. In other periods, when the ending value is...

Hi, I work in the investment industry and am trying to calculate the XIRR of our various mutual funds using the dates and the monthly withdrawal amounts that change over time, with the ending amount being the last number from the post-withdrawal column. The issue is that I have to manually...

Hello, I'm getting an XIRR of 0 for an investment that is at a complete loss (so instead of getting the correct answer of -100%). My formula is simply =XIRR($D$31:BB31,$D$26:BB26), which refers to the relevant dates and cashflows (about a 6 year period,with an aggregate of $6.5m invested at...

Hello all. I've been wrestling with this spreadsheet for a while now. I am trying to take a series of interest payments and loan receipts/repayments on varying dates and a rate based on Libor and calculate the XIRR. The loan is received net of financing fees. I need to amortise the net loan at...

I've built a dynamic model where the dates between an acquisition and the revenue producing go live change (acquisition date D58, go live E58). I am attempting to summarize the XIRR for every year for 5 years on another tab, so I know the XIRR range must start at D58 and go to wherever 12...

I want to use XIRR to calculate return on investment where there's been a series of payments into the investment, but the investment is still held. In many cases there have been no payments out. I can easily do that by notionally adding a line as if the investment was cashed in, based on the...

Hi all, This is my first thread and a query which I hope you can assist me with. I am trying to calculate the exact point in monetary terms that my IRR becomes a certain percentage%. So for example see below, on the 31/10/2016, the payment of 5,000,000 gives me an IRR of 65%, I want to...