irr

I have a standard template that has an IRR formula written as =IRR(A1:A63,.02). .02 is the guess because generally speaking it is close to the value the formula will return and usually prevents outliers. I am in the process of converting this template from Excel 2007 to Excel 2010 and when I...

I am looking for help with the following: Assume this example: Internal Rate of Return $-5,000, $2,000,$2,000,$2,000,$2,000,$2,000 using =IRR(above sequence) I get an IRR =29% What I am hoping for is to use "Solver / or a formula" to achieve the following. I would like to find out what % to be...

HI, I am trying to calculate the last value in an IRR casfhflow to make the total cash flow = 15% IRR I have a string of numbers, -100, -10 , 10, 10, 15, X. I am trying to find the value of X that makes the cashlow = 15% IRR Can anyone help with a formula? Thanks, Ryan

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

Hello, I am building a discounted cash flow model, which calculates my IRR at on a yearly stream of flows. I need a 25% IRR, so I have to manually change the purchase price until it hits. (Goal seek will not work on this model). Is it possible to create a circular reference so the purchase...

There are 2 parts to this question: 1. If you take the following set of cash flows below over, say, a 48 month period, and then calculate a simple IRR equation as =IRR(stream of cash flows), you get a #NUM error message. Why is that? It appears that once you hit month 28 with the example of...