IMCSCH Function Explained
The IMCSCH Function in Microsoft Excel calculates the Internal Rate of Return (IRR) for a series of cash flows that occur at regular intervals. It takes two arguments: an array of cash flows that occur at regular intervals, and an optional guess value. It returns the IRR for the cash flows, which is the interest rate that makes the present value of the cash flows equal to zero.
IMCSCH Function Syntax
The syntax for the IMCSCH function in Microsoft Excel is:
IMCSCH(inumber)
The function takes one argument:
inumber: This is the complex number for which the hyperbolic cosecant is calculated. The argument can be provided as a complex number or a reference to a cell containing a complex number. The argument can also be provided using theIMAGINARYandREALfunctions, or as text in the form of"x+yi"or"x+yj", where x is the real part and y is the imaginary part of the complex number.
The IMCSCH function returns the hyperbolic cosecant of a complex number. The hyperbolic cosecant of a complex number z is defined as 1/sinh(z), where sinh is the hyperbolic sine function.