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

Exercise 6

Suppose that instead of spending $350 immediately on an investment, you spend $350 one year from now and then receive $75 per year for the next six years after that. What is the net present value assuming a 6 percent rate of return Show the formula and formula results you used to answer this question.