Solved

# IRR / NPV Calculations - T-SQL functionality for equivalent VBA functions?

Posted on 2004-09-23

Hi All - My first ever post!

I have a client who wants a stored procedure to return a dataset that includes calculated NPV and IRR values.

Office components *cannot* be installed on the server, so I can't do the obvious and pull the VBA functions in.

Has anybody seen sprocs or user-defined functions that correlate to the equivalent IRR and NPV functions (and return the same results, of course? ;-)

Thanks in advance...