answer this wuestion wirh excel functions let your andwers be in excel formualar thanks

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 5 6 Annual cash flows 15,400 # of years 7 8 9 Costs Required Return Required Retum 67,000 8% 20% 10 11 12 What is the IRR of the following set of cash flows? Annual cash flows: Year o Year 1 Year 2 Year 3 | $ (13,900) $ 6,400 $ 8,700 $ 5,900 Complete the following analysis. Do not hard code values in your calculations. IRR What is the NPV of the following cash flows at a discount rate of zero percent? What if the discount rate is 10 percent? If it is 20 percent? If it is 30 percent? Year 0 Year 1 Year 2 Year 3 $ $ $ (13,900) 6,400 8,700 5,900 Discount rate Discount rate Discount rate Discount rate 0% 10% 20% 30% Garage, Inc., has identified the following two mutually exclusive projects. a. What is the IRR for each project? b. If the required return is 11 percent, what is the NPV for each project? c. What is the crossover rate between these two projects? Year 0 Year 1 Year 2 Year 3 Year 4 $ $ $ (43,500) $ 21,400 18,500 + $ 13,800 $ 7,600 B (43,500) 6,400 14,700 22,800 25,200 11% Required return Drou Afg Neyt Cash flow A IRR Cash flow B IRR Cash flow A NPV Cash flow B NPV Difference in cash flows Year 0 Year 1 Year 2 Year 3 Year 4 Crossover rate