Time value of money has to be done on excel by using the financial function on excel.