2. Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) NPVS NPVL Year (t) 0 Discount Rate (%) 0% 5 $800 $1100 554.32 1 2. Projects $(3000) 1500 1200 800 300 Project L $(3000) 400 900 1300 1500 10 15 161.33 (90.74) (309.03) 3 (259.24) (565.97) 20 4 a) Calculate the payback period in years for the Projects and Project L (10 points) i) Payback for Projects: ii) Payback for Project L: c) Calculate NPV for 5% and NPV for 10%. Fill the table (10 points) i) NPV at 5% ii) NPV at 10% d) What is the IRR for S? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR (5 points) e) What is the IRR for S? (Write down the equation for IRR and then Use an excel worksheetto calculate IRR (5 points) Equation: Answer: f) What is the cross-over rate? (Write down the equation for IRR and then Use an excel worksheetto calculate IRR (5 points) Equation: Answer: g) if projects are mutually exclusive, which project would you accept? (5 points) D) at 52