Using the @NPV function - unexpected results

@NPV

HI all,

I'm trying to calculate the NPV (Net Present Value) by using the @NPV function, but I get awful results. Have a look:

This is calculated using the following line:

NPV = @NPV(Contract_Payment, Dct, 0, @XRANGE("CY20"->"apr", "CY24"->"Mar"));

I'm using a bit of hardcode in my example just to simplify it. What could be wrong in that formula?

If I calculate the NPV using a more Financial Maths approach I get the correct values:

In the last image, I calculate the Capital column and I @SUMRANGE the values to get the NPV.

Any ideas? Also, why is it calculating a value for the BegBalance event thiugh I have declared apr:mar in my FIX?