D
dexoey
Hi to all
I am new user, have an urgent question and I wonder if you help me by
I am going to convert different costs during life time of a product t
Net Present Worth (NPW), consisting Maintenance and Rehabilitation cost
(M&Rj) and Salvage Value (SV), according to the following formula
https://www.dropbox.com/s/38aeqvrz0wrm9xc/NPW Formula.jp
SV occurs only once at the end of life time, it´s NPW in Excel can b
calculated as following
=PV(i discount, AP,0, SV,1
but M&Rj costs occurs J time during life cycle, and formulatin
manually their mathematical formula most times takes much time. Exactl
what should I write in the cell to get their total NPW? In other words
how can I get the following formula by Excel functions
https://www.dropbox.com/s/nrcgo41j0bg8sai/NPW Formula 2.jp
--------------------------------------------------------------------------------
Reminder: NPW= FV( 1/(1+i Discount))^
FV: future valu
i Discount: discount rat
n: numbers of years (periods)
Thanks in advanc
I am new user, have an urgent question and I wonder if you help me by
I am going to convert different costs during life time of a product t
Net Present Worth (NPW), consisting Maintenance and Rehabilitation cost
(M&Rj) and Salvage Value (SV), according to the following formula
https://www.dropbox.com/s/38aeqvrz0wrm9xc/NPW Formula.jp
SV occurs only once at the end of life time, it´s NPW in Excel can b
calculated as following
=PV(i discount, AP,0, SV,1
but M&Rj costs occurs J time during life cycle, and formulatin
manually their mathematical formula most times takes much time. Exactl
what should I write in the cell to get their total NPW? In other words
how can I get the following formula by Excel functions
https://www.dropbox.com/s/nrcgo41j0bg8sai/NPW Formula 2.jp
--------------------------------------------------------------------------------
Reminder: NPW= FV( 1/(1+i Discount))^
FV: future valu
i Discount: discount rat
n: numbers of years (periods)
Thanks in advanc