Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[REBOL] Re: financial functions

From: brett:codeconscious at: 21-Apr-2002 21:12

> << Does anyone have an internal rate of return function? >>
I use financial functions off and on - mostly in Excel, but I aim to reduce my use of that tool if I can. So I went a bit wild and created some functions too. NPV - Net present value of periodic cash flows. DCF - Discounted cash flow where the cash flows are on specific dates. IRR - Internal Rate of Return using NPV or a DCF function. SOLVE - The thing that IRR uses. Performs secant iteration to solve a function. Could potentially be used for Goal Seek functionality. Regards, Brett.