36 6 - = Calculating NPV and I RR - Excel ? [A]* E X HOME* INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 80 Calibri EE -\71 - | A" A ") 8 Paste B I U -| ^ _ _ _ _A _| Alignment Number\\ Conditional Format as* \Cell points Formatting *\ Table *\ Styles - Cells Clipboard\ Font Styles Skipped AL | X V fx A B C D E F G I J -BOOK 2 A project that provides annual cash flows of $15 , 400 for nine years costs $67 , 000 3 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 $ 15 , 400 # of years in 1 5 00 0 9. Costs 67, 000 Required Return 8% Required Return 20% 11 12 13 Complete the following analysis . Do not hard code values in your calculations . 14 You must use the built-in Excel function to answer this question . 15 NPV at 8 percent 16 17 NPV at 20 percent 18 19 IRR