The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Mechanical Investing


Subject:  Re: OT - Calculating CAGR in spreadsheet Date:  4/6/2019  2:10 PM
Author:  alevine001 Number:  273831 of 280223

Excel makes this very easy:

use either the function IRR or XIRR to calculate Internal Rate of Return.

XIRR has the flexibility of using irregular/incongruous time periods:

Copyright 1996-2021 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us