|
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 | ||