Hi Srini,
I took even distribution for cost plans in my earlier calculations, that is why it is slightly off from the system NPV. But now that I see your data, the calculation is matching perfectly. Here is how it is done.
FY19 License cost planned cost = 4285. FY20 License cost planned cost = 5714
FY19 Resource cost plan planned cost = 5760. FY20 Resource cost plan planned cost = 6240
Total FY19 Planned cost = 10045
Total FY20 Planned cost = 11954. After applying discount rate, FY20 planned cost = 11954/1.1 = 10867
Total Planned cost = 10045 + 10867 = 20912
FY19 Benefit cost = 8823
FY20 Benefit cost = 21176. After applying discount rate, FY20 benefit cost = 21176/1.1 = 19250
Total Benefit cost = 19251 + 8823 = 28073
NPV = 28073 - 20912 = 7161
Let me know if this helps.
