I would like to add to the wish list a function for calculating the internal rate of return. This function is found in Excel and Apple Numbers.

Thank you.

I would like to add to the wish list a function for calculating the internal rate of return. This function is found in Excel and Apple Numbers.

Thank you.

I’ve just done some research into this and this is not a trivial task, though probably not a massive one either. I’ve added it to the issue tracker for possible future inclusion.

If I can get the IRR function included in Panorama, I may be able to shift my analytical work from Excel and Numbers to Panorama. The build-in charting, summary tables, and pivot tables are a big plus for PanoramaX

James

I’m on holidays at the moment but when I get home (next Wednesday), I’ll look into whipping up a procedure for you.

Jim, your BitBucket entry implies that there is not yet a Panorama X function for calculating Net Present Value. There is - the `pv(`

function, carried over from P6.

The Bitbucket entry is regarding Net Present Value which is different from Present Value. Don’t ask me to explain it all until someone explains it to me.

The internal rate of return is the value of r so that the summation below equals zero. Or to put it another way, the value of r for which the initial investment equals the sum of the present value of the payments received as a result of the investment.

For more information, see IRR.

I’ve written three procedures:

NPV with a constant cash flow

NPV with a variable cash flow

IRR with a constant cash flow

When I get home from holidays I’ll send these to James for his comments and then post them on Dropbox or the Database Exchange.

Hey guys, thanks for giving some thought to the IRR function. For it to be useful, we need to evaluation uneven cashflows. Thanks in advance for putting your genius brains to work on this.