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

Exercise 2

You receive $50 at the end of Year 1 from an investment, $75 at the end of Year 2, and $100 at the end of Year 3. If the rate of return is 6 percent, what is the present value of this investment Show the formula and formula results you used to answer this question.