Fragen ID: 1550 17/19
PREVIOUS QUESTION NEXT QUESTION

Insert the appropriate function in the cell G5 that returns the net present value of an investment based on an annual discount rate and a series of future payments (negative values) and incomes (positive values). Necessary data are provided in the cell range B5:F10.

 

 

Other versions
Microsoft Excel 2003Microsoft Excel 2007Microsoft Excel 2010Microsoft Excel 2013Microsoft Excel 2016Microsoft Excel 365

 

 

 


Insert the appropriate function in the cell G5 that returns the net present value of an investment based on an annual discount rate and a series of future payments (negative values) and incomes (positive values). Necessary data are provided in the cell range B5:F10.