IMCOT Function Explained
The IMCOT Function in Microsoft Excel calculates the internal rate of return for a series of cash flows that occur at regular intervals. It takes three arguments: values, guess, and finance_rate. The values argument is an array of cash flows that occur at regular intervals. The guess argument is an optional number that you can use to provide a guess at the result of the function. The finance_rate argument is an optional number that you can use to provide a rate of interest for the cash flows. The function returns the internal rate of return for the cash flows.
IMCOT Function Syntax
IMCOT(cost, salvage, life, period, [month])
- cost: The initial cost of the asset.
- salvage: The value of the asset at the end of its useful life.
- life: The length of the asset’s useful life, in periods.
- period: The period for which you want to calculate the depreciation.
- [month]: (Optional) The number of months in the first year. If omitted, 12 is assumed.