irr

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...

Please help. So I assign a macro button to solve the circular reference in calculating IRR in a real estate financial model. Next, I have a data table to analyze different scenarios regarding my IRR. The problem here is the data table will only calculate the IRR without applying my macro...

I was hoping that someone here could help explain to me what is exactly going on in the attached formula. It is a circular exercise where the IRR is based on the entire cash flow stream, and the capitalization rate is...the same IRR. I am really just asking for an explanation of what the IRR...

Hi, I have an IRR related query, which I am struggling to resolve, any advice would be most appreciated. <tbody> 30/04/2018 0 31/05/2018 0 30/06/2018 -100 31/07/2018 0 31/08/2018 200 30/09/2018 20 31/10/2018 20 30/11/2018 10 </tbody> I am trying to calculate the IRR of the...

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...

I have determined an IRR of a commercial property from its cash flows after a sale in year 10. How do i go about figuring out what portion of my IRR comes from cash flows and what portion comes from the sale of the property?

I am building a cash flow model to determine my IRR depending on when I sell the investment. The logic I am trying to follow for the equation is: If current period is equal to harvest period, then populate the cell with the sell price minus the cash outflow for that period. If current period...

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...

I have a problem where I am looking to calculate the Initial Outlay required to meet a given IRR with 10 periods of the same payments. Desired IRR = 15% Periods= 10 Payments= $219,174.93 Initial Outlay = x Is there a function or formula that will calculate this for me in Excel? Thank you!

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...

Hello all. Here I am again in the need of your help. I have a VBA that I use to set values in my excel model. Each of those values are linked to a cash-flow schedule that I use to calculate IRR (using XIRR). The same VBA that set the values of the cash-flows also writes the resulting IRR in one...

Hi Guys, I'm having an odd result in excel. I have a project with a positive NPV but the IRR excel is giving me (both IRR and XIRR formulas) is LESS than the WACC. It does not make sense, if NPV > 0 then IRR should also be > WACC. The CF's in the project do change signs in between and go from...

Hi there, I'm trying to simplify how I use the IRR formula when calculating the IRR of a fixed income investment over a given term. Rather than listing out each years cashflow in cells A1:A5 and then using =IRR(A1:A5), I'd like to be able to create a formula along the lines of =IRR((annual...

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...

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...

I have an entity in a project that receives quarterly but inconsistent cashflows until the entity's IRR = 10%. The distribution amount is subject to available cash so one quarter's distribution could be as low as 200k or as high as whatever is available subject to 10% irr cap. Entity will...

Hello, I need help with IRR formula. I have several loan ID-s and for cash flows and date of payment for each loan ID. I want to calculate IRR for every Loan ID. I need formula sort of SUMIF, but for IRR calculation.

Hi all, I need an IRR of 1% and use this formula in cell B1: =IF(A1<1%;"x";0) Now I need to figure out what amount to add in cell B1 to get the IRR up to 1%. Assume the IRR data is in cells C1 to C10 (dates) and D1 to D10 (amounts). Does anyone know how to put this in the formula? Thanks! Rob

Hi, imagine I have a project that lasts for 20 years that has a beginning outflow of $10 and in the first 10 years there are additional outflows of $2. Assume that the inflows are constant and they last from year 3 up until year 20. Is there a formulaic way (i.e. not using VBA, goal seek, etc)...

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...