Excel calculate annual rate of return
How to calculate return on investment (ROI) for a company in Microsoft Excel. What is the formula for calculating compound annual growth rate (CAGR) in Excel? The annual return is the Example 4. Calculate compound annual growth rate (CAGR) Though the IRR function in Excel is designed for calculating the internal return rate, it can also be used for computing the compound growth rate. You will just have to reorganize your original data in this way: