Very good attempt. A Quick observation for calculation of CAGR for 3 year/5 years/ 10 years. The model Freefincal-stock analyser CAGR is taking only two years data for 3 year CAGR, 4 years data for 5 year CAGR and 9 year data for 10 year CAGR.
For instance in in valuation 2 sheet Cell B21, 5 year CAGR is calculated as =IF(ISERROR((B17/B13)^(1/5)-1),””,(B17/B13)^(1/5)-1)
In my view you should change either base year to B12 or number of years to 4, so that we get correct CAGR.
No way this dilute usefulness of model but just thought to contribute something from my side in your great efforts. This error is repeated across all the work sheet.
Thanks
| Subscribe To Our Free Newsletter |
