FREE Excel Template for Screener.in

[Ansh_Gupta]

Hi, appreciate you taking the time to go through the excel.

@Amol2021

The FCF calculation in the ‘Cash Flow’ Tab fails to deduct Capital Expenditure and thereby HUGELY overestimates the FCF generated. Also it does not specify which FCF it is - FCFF or FCFE. In case of FCFE there are additional steps to calculate the same

Agreed, but in ‘VP type of businesses’, which are mostly small/midcap (which I’m more interested in), FCF is hardly useful.
Yes, for bluechip strong businesses, you need to see FCFF, FCFE especially for modelling which are missing in the excel I shared.

@Amol2021

The CAGR calculations displays 10 yrs, 5 years, 3 years but the formula calculates it for 9,4,2 years respectively.

Can you tell me which calculations are you referring to? Attaching the screenshot, with highlight on the 3 year sales growth, which seems to be correct.
Also, trends in OPM are simple averages, not CAGR.