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 $$15,300$

Years $9$

Costs $$74,000$

Required Return $8\%$

Required Return $20\%$

$($Use cells A$6$ to B$10$ from the given information to complete this question. You must use the built$-$in Excel function to answer this question.$)$

Output area:

NPV at $8\%$

NPV at $20\%$

IRR

find the above using the information already given using the NPV formula