Valuation is like predicting the future potential of a stock and assigning a value. Whenever you are predicting future, there come lots of “if and else”. Manual intervention is must to handle such uncertainties. A single formula or a well formulated excel sheet is not sufficient enough to handle this.