KVP - Kisan Vikas Patra - Interest Calculation per year

Hello,

How to calculate interest for Kisan Vikas Patra (KVP) - for each year? 

Is the compounded interest calculated every 6 months or every year? 

There is an old excel sheet in this forum somewhere, but it is password protected and also does not show the calculation part.

Thanks