[Filter: smut] Akshit_kumar's post body matched "*shit*", board "forumsmisc".

Akshit_kumar

[Filter: smut] Akshit_kumar's post body matched "*shit*", board "forumsmisc".

Post Subject: Re: Need Help Regarding NPV

Post Body:

Hi @einas.ibrahim . Thanks for reply. sure.

1)  Highlighted with marker like amount is cashflow & NPV line item is for NPV calculation.

 2) It is an user input. Below is the SS of Dashboard.

3) Yes, this is the setup but I only want NPV for Yearly level(FY20-FY24).

4) Sure. =IF(C7<>"Soft",NPV(Lookups!$F$37,T7,U7,V7,W7,X7),0)

C7 are the benefits. We only want hard benefits.

$F$37 - It is a fixed value for discount i.e, 15%.

T7,U7,V7,W7,X7 - these are the user input values from FY20 to FY24.

 

Requirement is to get this setup

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

Row having no. list

 

Hope this might help. Please let me if I answer you correctly?

 

Akshit

Body text "shit" matched filter pattern "*shit*".

Post by User[id=32236,login=Akshit_kumar] has message uid 75422.

Link to post: Re: Need Help Regarding NPV