You make an investment today (year 0), and you expect to receive cash flows of $1640, $1563, and $3178, in years 1, 2 and 3, respectively.
If the discount rate is 15%, what is the present value of this investment? Enter your answer in dollars, rounded to the nearest cent.
The answer is 4697.53. Just need help working it. Preferably, in EXCEL spreadsheet