Complex formulas in excel

[Kmahraz]

Hi:
Looking for some help to create these 3 formulas in excel and have it calculate automatically whenever I change the value of T.
Any help will be much appreciated.
Thanks,
K

Expected result

 

[Luke M]

Using table references:

NPV1
=0.74*65000*1.03^[@[T Value]]/0.035*(1-(1.03/1.065)^(40-[@[T Value]]))

NPV2
=0.69*((110000/0.025)*(1-(1.04/1.065)^(38-[@[T Value]]))/1.065^2)+20000/1.065^2-78000/1.065-78000

NPV3
=0.71*((92000/0.03*(1-(1.035/1.065)^(39-[@[T Value]])))/1.065)+18000/1.065-94500

 

[David Evans]

Using table references:

NPV1
=0.74*65000*1.03^[@[T Value]]/0.035*(1-(1.03/1.065)^(40-[@[T Value]]))

NPV2
=0.69*((110000/0.025)*(1-(1.04/1.065)^(38-[@[T Value]]))/1.065^2)+20000/1.065^2-78000/1.065-78000

NPV3
=0.71*((92000/0.03*(1-(1.035/1.065)^(39-[@[T Value]])))/1.065)+18000/1.065-94500

Luke M hits it out of the park, again, on opening day.
@Kmahraz - if these are formulas you use a lot, you can think about creating User Defined Functions to represent each one ...

 

[Kmahraz]

@Luke M thank you so very much for this. It does exactly what I am looking for.
@David Evans thank you for the feedback, can you please elaborate more how I can use the user defined functions ... I never had a chance to use it before

Thanks,
K

 

[Chihiro]

Something like below in standard module.

Function NETPV(tvalue As Double) As Double

    NETPV = 0.74 * 65000 * 1.03 ^ tvalue / 0.035 * (1 - (1.03 / 1.065) ^ (40 - tvalue))

End Function

 

[Eloise T]

Does this add further insight?
https://support.office.com/en-us/article/NPV-function-8672CB67-2576-4D07-B67B-AC28ACF2A568