A project that provides annual cash flows of $$15,300$ for nine years

$2$

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$?$

$3$

$4$ Input area:

$5$

$\backslash$table$[[,$Annual cash flows,$],[7,$Years,$],[8,$Costs,$],[9,$Required Return,$],[10,$Required Return,$]]$

$11$

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

$14$

$15$ Output area:

$16$

$17$ NPV at $8\%$

$18$ NPV at $20\%$

$19$ IRR

$20$

$21$

$22$

$23$

$24$

Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used Nothing in this area will be graded, but it will be submitted with your assignment.