Calculate the payback period, Discounted payback period, NPV$,$ IRR and the Modified IRR using the information below.

Explain for each criterion, whether the project should be accepted or not.

Year $0$

$$$$95,000$

Year $1$

$$136,000$

Year $2$

$$105,000$

Year $3$

$$$$145,000$

The required rate of return is $15\%.$

Note: The rate for investment cash flow is the same as the rate for financing cash flow. Using excel only