How to calculate CAGR in Excel? A How to calculate CAGR in Excel? Category: Others Use formula: (Ending Value/Beginning Value)^(1/Years) – 1 or XIRR for multiple cash flows. Tags: finance faqs, investment faqs, trading faqs Permalink Back to Top