irr

  1. Q

    IRR Help

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

    Private Equity IRR Calc

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

    Determining Purchase Price on Real Estate Transaction using Goal Seek, NPV, and IRR

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

    Irr strange result

    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)...
  5. E

    Why IRR returns #NUM! ?

    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?
  6. D

    FV, IRR, XIRR Return Differing Investment Results - Why?

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

    IRR - Calcullating IRR interngeably between Annually and Monthly

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

    Problem in working with Data tables in Excel 2016

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

    Solving For IRR Based On Irregular Cash Flows

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

    Predicting an IRR

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

    Predicting an IRR

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

    Urgent: Irr help

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

    IRR vba vs. worksheet function

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

    Help with XIRR - Something it's wrong

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

    NPV & IRR with nested Offset Function help required

    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))...
  16. M

    skip if error application.irr

    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)
  17. C

    Data table applying macro button

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

    How do I create an XIRR function based on unique names and between certain dates?

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

    Data table applying macro button

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

    Iteration for Valuation Purposes

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top