All answers must be entered as a formula in excel

1.A project that provides annual cash flows of $15,000 for nine years costs $67,000 today. What is the NPV if the required return is 8 percent? What if it's 20 percent? At what discount rate would you be indifferent between accepting the project and rejecting it?

Annual cash flows$15,400

# of years9

Costs$67,000

Required Return8%

Required Return20%

Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question.

NPV at 8 percent

NPV at 20 percent

IRR