The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Mechanical Investing

URL:  https://boards.fool.com/excel-makes-this-very-easy-use-either-the-34175034.aspx

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:

https://corporatefinanceinstitute.com/resources/knowledge/mo...


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