Question: how to calculate compound percentage increase in excel?
Answer: To calculate the Compound Annual Growth Rate in Excel, there is a basic formula =((End Value/Start Value)^(1/Periods) -1. ...  Actually, the XIRR function can help us calculate the Compound Annual Growth Rate in Excel easily, but it requires you to create a new table with the start value and end value.