Homework?

Google Excel NPV Function.

http://www.techonthenet.com/excel/formulas/npv.php

http://office.microsoft.com/en-gb/ex...005209199.aspx

http://office.microsoft.com/en-gb/ex...010342728.aspx


You could, at least, make the effort to research the topic

Regards, TMS