VB.NET Language Pocket Reference

Name

IRR Function — Microsoft.VisualBasic.Financial

Synopsis

IRR(valuearray(  )[, guess])

valuearray( ) required; array of Double

An array of cash flow values

guess optional; Double

Estimated value to be returned by the function

Return Value

A Double representing the internal rate of return

Description

Calculates the internal rate of return for a series of periodic cash flows (payments and receipts).

The internal rate of return is the interest rate generated by an investment consisting of payments and receipts that occur at regular intervals. It is generally compared to a “hurdle rate,” or a minimum return, to determine whether a particular investment should be made.