please give answer using excel formula

Chapter 08 Excel Problems 8 1 0 oints eBook 0 References FILE Paste Clipboard G Al A 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 X Saved Calculating NPV and IRR - Excel FORMULAS DATA REVIEW VIEW Calibri -11 -A M BIU- 6 Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles V 1 fe B C D E F G H 1 K 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? 15,400 Annual cash flows $ # of years Costs 67,000 Required Return 8% Required Return 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 HOME INSERT Font PAGE LAYOUT 9 Styles ? 20 Sign In