I am attempting to understand an NPV/IRR calculation using nested Offset from 2017 to 2027. The formulae are as follows:
NPV(C15,OFFSET(D39,0,0,1,C16-1))+C39
Where C15 = WACC, D39 = 2018 net annual benefits, C39 = 2017 net annual benefits & C16 = valuation years
IRR(OFFSET(C39,0,0,1,C16))...