Brittania_9167
Jun 29, 2012, 09:59 PM
Hello - I am trying to find a formula to work out the Net Present Value for a comparison of old equipment versus new equipment. I would rather not give values as I would like to learn and work through it myself. However, in relation to the old equipment I know the following:
-current trade-in value
-annual maintenance cost
-if the old equipment remains, it will be in service for the next 5 years.
First things first. I am assuming that I need to work out the NPV for the old and new equipment separately and then do a comparison. I have researched how to do the comparison but haven't worked out how to get the NPV! The data given for the new equipment option varies quite significantly (reqd rate of rtn, initial cost etc).
I am after a formula to work out firstly the NPV for the old equipment using the data in the list above. I have searched for a formula but have only be able to find one that relates to discount values over a number of years and such. Do I use any of the data from the new equipment option? I wouldn't have thought so but I haven't got very far yet.
Any help is gladly accepted to get me started with this comparison.
Thank you,
Brit.
-current trade-in value
-annual maintenance cost
-if the old equipment remains, it will be in service for the next 5 years.
First things first. I am assuming that I need to work out the NPV for the old and new equipment separately and then do a comparison. I have researched how to do the comparison but haven't worked out how to get the NPV! The data given for the new equipment option varies quite significantly (reqd rate of rtn, initial cost etc).
I am after a formula to work out firstly the NPV for the old equipment using the data in the list above. I have searched for a formula but have only be able to find one that relates to discount values over a number of years and such. Do I use any of the data from the new equipment option? I wouldn't have thought so but I haven't got very far yet.
Any help is gladly accepted to get me started with this comparison.
Thank you,
Brit.