Function Type: Financial
Description:
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
Function Structure:
=XIRR(values, date, [guess]).
Argument Breakdown:
values – This is the array of values that represent the series of cash flows. Instead of an array, it can be a reference to a range of cells containing values.
date – This is a series of dates that correspond to the given values. Subsequent dates should be later than the first date, as the first date is the start date and subsequent dates are future dates of outgoing payments or income.
guess – This is an initial guess – or estimate – of what the IRR will be. If omitted, Excel takes the default value of 10%.
Example:
Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.
We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.
or you can help me through https://www.buymeacoffee.com/cashheaven š
One thought on “XIRR”