Hello,
I have encountered with a problem that I couldn't resolve.
My goal is to calculate CAGR based on Daily data for the defined period.
The formula for the CAGR is = (Ending equity/Starting Equity)^(1/number of years) -1.
Because I calculate CAGR using daily data I assumed 250 days (work days) in a year and converted the days to years by changing formula to
(Ending equity/Starting Equity)^(1/(number of days/250) -1.
Here is the code
=POWER(VLOOKUP(L4,B3:C45,2,FALSE)/VLOOKUP(L3,B3:C45,2,FALSE);1/(DAYS360(L3,L4)/250))-1
(see attached file)
The main problem is that Days360 calculate calendar days between dates, but I need to find the real dates between my Start and End period.
Can somebody help me to find CAGR for the defined period.
Thanks in advance.
Bookmarks