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.

The formula for NPV at 8 percent is =-D8+PV(D9,D7,-D6)

What is the formula for NPV at 20 percent?

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 15 16 17 18 19 20 You must use the built-in Excel function to answer this question NPV at 8 percentS 29,202.07 NPV at 20 percent IRR 17.67%