cs 336 week 5 assignment

\$10.00

cs 336 week 5 assignment

Category:

Description

cs 336 week 5 assignment,

How to Calculate NPV in Excel

First step is to select the excel option in your computer and then select save option to save it on the desktop. Second is to take the discount rate given to enable the calculation of the NPV (Winston, 2007).

Third is to enter labels in the cells A3 to A8. For example value of benefit, developmental cost, annual expenses etc. Forth is to enter the variables into the Excel function in the next columns according to the question given. For example value of benefit from first year to the sixth year.

Having completed the insertion of the values now it’s time to calculate the NPV. This is given by NPV(rate,value1,value2…..) (Winston, 2004).  Enter this in cell C8. For example year 1 = NPV(C7,C3,C5)+B4 and by pressing enter button NPV value is inserted automatically. It worth noting that NPV function assumes t

cs 336 week 5 assignment,

How to Calculate NPV in Excel

First step is to select the excel option in your computer and then select save option to save it on the desktop. Second is to take the discount rate given to enable the calculation of the NPV (Winston, 2007).

Third is to enter labels in the cells A3 to A8. For example value of benefit, developmental cost, annual expenses etc. Forth is to enter the variables into the Excel function in the next columns according to the question given. For example value of benefit from first year to the sixth year.

Having completed the insertion of the values now it’s time to calculate the NPV. This is given by NPV(rate,value1,value2…..) (Winston, 2004).  Enter this in cell C8. For example year 1 = NPV(C7,C3,C5)+B4 and by pressing enter button NPV value is inserted automatically. It worth noting that NPV function assumes t