The spectrum auctions in India allows an operator to make payment a certain portion of the auction value in a deferred mode after a certain moratorium period spread over a fixed number of years as defined in the NIA. Currently, the moratorium period is 2 years and payment period is 10 years. These are now been changed by IMG (Inter-Ministerial Group) to 2 years and 16 years respectively. The problem is that formulae to calculate the Easy Yearly Installments (EYI) is a little involved and not available as a standard formula in tools we generally use like Microsoft Excel. I have derived this formula using the financial theory of DCF (Discounting Cash Flow) and summing the resulting geometric series using standard sum formula. This purpose of this note is to layout the formula used for calculation of EYI which readers can use to evaluate different scenarios of input parameters (interest rates, moratorium period, deferred payment period etc).
EYI Formula Derivation
The following provides the derivation of the calculation for the EYI formula. This is only for those readers who are interested in diving a little deeper into the mechanics which led to its derivation. Since Linkedin editor does not allow an easy way of displaying mathematical jargons, I have embedded the calculations in a handwritten note in the picture below.
