5 . HOME Calculating NPV and IRR - Excel FORMULAS DATA REVIEW FILE INSERT PAGE LAYOUT VIEW Sign In Calibri A A - A Paste B I 11 BP - Font U Alignment Number Editing Conditional Format as Cell Formatting* Table Styles Styles Clipboard A 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 $ 15,400 Annual cash flows # of years Costs Required Return Required Return 67,000 8% 20% 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