Waldo is thinking about purchasing an investment that will provide him with cash flow of $2,500 each year for the first 4 years and
$4,700 in the 5th year. His required rate of return is 7%. What is the most he should pay for this investment?

Please solve with excel