Please help with a-e

You have joined a team that is assessing the viability of a new project, code-named Cranberry". You need to assess the potential financial return. The company seeks a return of 15% (per year)- Refer to the partially completed table showing the cash flows and a portion of the analysis (this table is also on a tab of the provided Excel file): Project Cranberry Reg'd Interest Rate 15.0% Values in $ THOUSANDS Net Cash Cumul Cash Yr Out In (undisc) (undisc) DF Disc Net Disc Cumul 0 300 S (300) S (300) 1.000 (300) $ (300) 200 S 100 100) S (400) 0.870 (87) (387) 200 (200 0.756 151 $ (236) S 250 0.658 164 S (71) 100 Questions / tasks Answer the following: a) (1 ptea * 5 items = 5 pt) Complete the highlighted table data entries for Year 4 (Net Cash-undiscounted, Cumulative Cash-undiscounted, DF, Discounted Net and Discounted Cumulative). Note: there are 5 input questions for these data. b) (2 pt) What is the total undiscounted investment amount required to complete project Cranberry? c) (2 pt) What is the undiscounted Payback Period for Project Cranberry? AND - state what you are looking for to determine this point (be specific). d) (2 pt) What is the discounted Payback Period for Project Cranberry? AND - state what you are looking for to determine this point (be specific). e) (2 pt) Based on Net Present Value criterion, do you recommend doing Project Cranberry? How did you decide that it has or has not met requirements