CAGR by using the XIRR Function in MS Excel. 1 of 4 Excel CAGR methods (links in description)

Follow Along File- https://auditexcel.co.za/product-down... 00:00 Introduction 00:06 Set up the model for XIRR use 00:49 Create the XIRR function 01:09 Why the XIRR CAGR differs from the other CAGR methods CAGR using Goalseek-    • CAGR explanation and calculation in MS Exc...   CAGR with the RATE function-    • CAGR (Compound Annual Growth Rate) using M...   CAGR with the IRR function-    • CAGR using MS Excel's IRR Function. This i...   As we can use IRR, we can also use XIRR and in some ways this is easier. To follow along go to 17.14 In this case you need to create only 4 cells and specify the start and end date on one row and the start and end amount on another row (the start amount must be negative). Then you can create the XIRR and Excel will work out what percentage growth will get you from the one number to the other number in the time period specified from the start date to the end date.