Attached is a spreadsheet which calculates a rate based on the same cash flows using IRR and RATE.
In Excel, both functions return the same result.
In Google Apps spreadhseet, both functions return the same result.
In LibreOffice Calc, the RATE function returns a different number!!!
Attached is a spreadsheet which calculates a rate based on the same cash flows using IRR and RATE.
In Excel, both functions return the same result.
In Google Apps spreadhseet, both functions return the same result.
In LibreOffice Calc, the RATE function returns a different number!!!