New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey

Exercise 4

You spend $350 on an investment that pays $75 per year for the next six years. If you make the investment immediately, what is the net present value of the investment Assume a 6 percent rate of return. Show the formula and formula results you used to answer this question.