IRRT function
| Discounted Cash Flow category | - DCF Specific Times family | Home |
| What the name means | "Internal Rate of Return of cashflows at specific times" |
| Syntax | IRRT ( Dates, Cashflows, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt], [DayCountDisc], [PrdsDisc], [PVTOptions] ) |
| Description | Returns the IRR (internal rate of return) of the cashflow represented by Dates and the corresponding Amounts |
| See Also | IRRTIC (Dates, Cashflows, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt], [DayCountDisc], [PrdsDisc], [InvDate], [InvAmt], [CapRateAER], [StartDCF], [FinishDCF], [CapOption], [PVTOptions]) |
| IRRTX (Dates, Cashflows, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [PVTOptions], [Dates2], [Cashflows2], [Dates3], [Cashflows3], [Dates4], [Cashflows4]) |
| Variable | Type or Value | Description | |
|---|---|---|---|
Inputs: (8) | |||
| Dates | Range Of Dates | A range of dates. | |
| Cashflows | Range of Floats (numbers) | A range of cash flows. | |
| 3 | IRRMinOpt | Float (Optional) | A maximum acceptable IRR (Optional) |
| 4 | IRRMaxOpt | Float (Optional) | A maximum acceptable IRR (Optional) |
| 5 | IRRAccOpt | Float (Optional) | Accuracy to which the IRR should be determined (Optional) |
| 6 | DayCountDisc | Float (Optional) | For use in discounting or compounding. Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. (Optional) |
| 7 | PrdsDisc | Annual Sequence (Optional) | Discount Periods for use with DayCountDisc Annual Sequence or preset sequence option (Optional) |
| 8 | PVTOptions | Integer (Optional) | A set of additive options governing how the DCF calculation is to be performed (Optional) |
Output: | |||
| Return Value | IRRAER | Float | The IRR (internal rate of return) expressed as an AER (Annual Equivalent Rate). |
Defaults and Values
The variable(s) of this function have certain defaults and/or switch values associated with them. Click here to see more.
Features
This function has a few features that help explain its name. Click here to see more.
Range Handling and Constraints
This function has range inputs that are subject to range handling procedures to help reduce input errors and increase flexibility and speed. Click here to see more.
Examples | |||
|
Published Edition Changes in Behaviour
This function has experienced some changes in its behaviour over its history. Click here to see more.