All answers must be entered as a formula in excel

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

A project that provides annual cash flows of $15,400 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? 4 Annual cash flows # of years Costs Required Return Required Return S 15,400 67,000 5% 20% 10 12 Complete the following analysis. Do not hard code values in your calculations 13 You must use the built-in Excel function to answer this question NPV at 8 percent S 29,202.07 NPV at 20 percent 15 16 18