Need to understand what functions to use in excel and how to solve this problem.
An investment is expected to yield $300 in three years, $500 in five years, and $300 in seven years. What is the present value of this investment if our opportunity rate is 5%?