GIVE PROPER EXCEL FORMULAS FOR EVERYTHING PLS!!

A project that provides annual cash flows of $15,300 for nine years costs $74,000 today. Is this a good project 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? Input area: Annual cash flows Years Costs Required Return Required Return (Use cells A6 to B10 from the given information to complete this question. Excel function to answer this question.) Output area: $15,300 9 $74,000 8% 20% NPV at 8% SNPV at 20% IRR

A project that provides annual cash flows of $15,300 for nine years costs $74,000 today. Is this a good project 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