Cima C03 Exam Question No 23

Question No 23:

Below is an extract from an Excel spreadsheet?

For the given data, give the Excel formulae that would be required in Excel to calculate the ROI and NPV in cells B10 and B11 respectively.

Answer: ROI= Average(B2:B5)/B1 NPV= NPV(B7,B2:B5)-B1