irr

I understand XIRR handles irregular cash flows while IRR assumes periodic cash flows, but why would XIRR return 10.5%/yr. vs IRR's 10%/yr. on the periodic cash flow involving monthly repayment of a 10%/yr. loan over 10 yrs. Is there a way to upload a spreadsheet to w/ this question?

Hello Friends, I want to calculate the IRR of an Insurance policy where you pay the premium in the initial years & then wait for some years & then you will start getting regular cash flow for a certain number of years with your initial premiums also returned back to you with last cash flow. So...

Hello, all. I'm trying to calculate the IRR (Internal Rate of Return) of a stock portfolio but my cash flow data is monthly. I used both IRR and XIRR but it seems like the way I'm calculating them is wrong. How should I go about calculating the monthly IRR accurately? Since I can't attached...

I am getting different returns when calculating for IRR. The far right is the "desired" ending return that should be populating in the IRR column as well (I pasted these numbers in the desired column and am using the formula below for the IRR column). I was able to get the first year to match...

Hey All, Quick question, I'm trying to calculate an ongoing IRR calc for a Private Equity Investment. For every period, I want to have an IRR calc up to that point. I need to somehow bring in the Fair Value of the fund on that date into the last cash flow of the IRR calc, otherwise the Cash...

I work in commercial real estate and we are trying to back into a purchase price by determining what initial outlay gets our NPV to 0 and IRR to 30%. Essentially, what acquisition price gets us to a 30% IRR. We're looking at this over a three year period. For purposes of simplicity, say I can...

Hi, I am trying to work out the IRR of the below set of cash flows, with the formula being =(1+IRR(A94:AJ94))^12-1 <tbody> </tbody> <tbody> 660,512 660,512 (3,672,280)...

Hello I select a range of cells for the IRR formula and it returns #NUM ! I formatted the range to be Numbers but nothing changed. Any idea?

I need to present to others a proposal on investing in some equities and bond funds and discovered that different functions return different results using the same parameters. FV, XIRR, and IRR, and the differences are not small. Here's a test spreadsheet I made that demonstrates the problem...

Does anyone have an idea how one can calculate IRR interchangeably between annually and monthly without redoing the cashflows to suite. Say if you have already done the annual cashflows for a 25 year period, now one wants to quickly test the irr on a monthly basis while keeping the same parameters.

Hello, i am facing a peculiar problem. I was doing a sensitivity analysis through data table and putting the IRR value as a reference for the data table to calculate values. For this I am using the cell reference of the cell in which I have calculated the IRR value of the project. And...

Hi guys, I'm trying to solve for <abbr title="internal rate of return" style="box-sizing: border-box; border-bottom: none transparent; cursor: pointer; text-decoration-line: none; text-decoration-style: initial;">IRR</abbr> (let's say 20%) based irregular cash flows - essentially trying to find...

I am trying to solve for IRR. If I want to achieve an IRR in any year of 9% and I have my cash flows but need to solve for sale equity, what should I use? So if in year 4 of owning a property, I want to sell it to achieve a 9% IRR and I have my original equity number and my cash flows, how do...

I am trying to solve for IRR. If I want to achieve an IRR in any year of 9% and I have my cash flows but need to solve for sale equity, what should I use? So if in year 4 of owning a property, I want to sell it to achieve a 9% IRR and I have my original equity number and my cash flows, how do...

I am trying to calculate the IRR of the below cash flows. The result seems weird, I think it is because the first cash flow is not zero and the in the second set of cash flows, the third cash flows is negative. Any ideas would be most appreciated. <tbody> 31/10/2018 30/11/2018 31/12/2018...

Hi, I updated a macro so that it uses the IRR within vba rather than the IRR worksheet function. To test this compared the worksheet function vs. IRR function & notice that the vba function is erroring out & the worksheet function returns a real value. Why is this...

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

I am attempting to understand an NPV/IRR calculation using nested Offset from 2017 to 2027. The formulae are as follows: NPV(C15,OFFSET(D39,0,0,1,C16-1))+C39 Where C15 = WACC, D39 = 2018 net annual benefits, C39 = 2017 net annual benefits & C16 = valuation years IRR(OFFSET(C39,0,0,1,C16))...

Hi, I am using the application.irr function in VBA code, and in some cases the array values produce an error. I believe this is if the IRR returns "#NUM!". So I want to to return "0" if this is the case x = Application.IRR(RAtTT)

Hi guys I posted this problem before but no one seems to reply but I hope it captures someone's attention this time. 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...