Need Help Regarding NPV

Options
Akshit_kumar
Akshit_kumar Member, ALL USERS, Certified Model Builder Posts: 2 New Contributor
in Planning & Modeling

Hi all,

I need to replicate the formula from excel of NPV.

I've months of first year that sum up to a Year followed by 4 years.

Below is the structure of module.

 

Line items are in version dimension - That's a problem too.

                        col-     Jan 20...Dec 20 FY1 FY2 FY3 FY4 FY5     NPV

Row having no. list

 

I need to apply NPV on yearly level and show corresponding to  each member of Numbered list.

Like cashflow in FY1,FY2,FY3,FY4,FY5. 

Screenshot_1.png

 

I'm trying this

Screenshot_2.png

 Idk if this could work too - NPV= IF ITEM(Time) >= TIME.'FY20' THEN NPV(0.15, Amount) ELSE 0

 

Thanks in Advance

Tagged:

Categories