MIRR (PQL - xl)

This function returns the modified internal rate of return for a series of periodic cash flows

  • Library: PQL \ Spreadsheet \ Financial
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

MIRR(values, finance rate, reinvest rate)

Function Arguments

Name

Description

Type

Optional

values

An array of numbers for which you want to estimate the internal rate of return representing payments and income occurring at regular intervals (and use positive for income and negative for payment)

Number

finance rate

Interest rate on money in cash flows

Number

reinvest rate

Interest rate on money invested from cash flows

Number

Comments

This function is the same as the Microsoft Excel 'MIRR' function - using the same inputs, logic and outputs.