CAGR using RATE, IRR and XIRR- No need to remember the formula

Follow Along File- https://auditexcel.co.za/product-down... 00:00 Use RATE to create CAGR (be careful about number of periods, and signs on PV/ FV) 01:36 Use IRR to create the CAGR 02:18 Use XIRR to create the CAGR Lecture Examples 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...   CAGR with the XIRR function-    • CAGR by using the XIRR Function in MS Exce...   We need to determine the Cumulative Annual Growth Rate in Cash Generated over 5 years. The cash flows are shown in E10 to I10. In row 25 to 27 we have created a check bucket to see if your calculation correctly grows to the required number. Calculate the CAGR in 3 different ways: 1. In B13 use the Rate function 2. In B15 use the IRR function (use E15 to I15 as helper cells if you want) 3. In B19 use the XIRR function (use E19 to F19 as helper cells- we have entered the dates for you).