Question $6$

Cepeda Manufacturing Company is considering three new projects, each requiring an equipment investment of $$22,000.$

Each project will last for $3$ years and produce the following cash inflows.

The equipment's salvage value is zero. Cepeda uses straight$-$line depreciation. Cepeda will not accept any project with a

payback period over $2$ years. Cepeda's minimum required rate of return is $12\%.$ Calculate NPV for each project using excel.

DO NOT USE the EXCEL NPV function. Upload your excel file showing your calculations and answers to this question.