K kmack1982 Oct 4, 2008 #1 What function in excel 07 should be used to calculate the present value of a loan or investment?