Demonstated the problem using excel.

Given the following project cash flows answer the questions below.

a$.$ Calculate the payback period to one decimal place. If the minimum acceptable

payback period is $6$ years should the project be accepted or rejected?

b$.$ Calculate the discounted payback period to one decimal place. Assume that the

appropriate discount rate is $9$ percent. If the minimum acceptable discounted payback

period is $7\mathrm{.}5$ years should the project be accepted or rejected?

c$.$ Calculate the NPV of the project. Assume that the appropriate discount rate is $9$

percent. Based on this NPV should the project be accepted or rejected?

d$.$ What is the internal rate of return? Given the appropriate discount rate is $9$ percent

should the project be accepted or rejected based on this IRR?

e$.$ Using a data table construct, an NPV profile for discount rates ranging from zero to

$30$ percent at $1$ percent increments. Make sure you label both the $x-$ and $y-$axes.