help part 2A

re-calculate NPV, IRR etc

PART 2A: Do a 5 imilar analysis as in Part 1 to analyze a now scenario where the equipment is fully depreciated in the first year. All other inputs remain the same. Re-caleulate NPV, IRR and Payback period of the preject. HINT: negative EBIT creates a tax crediti PART 1A: Use the Excel ceEs below to caleulate alf estimated project cash flows for the BASE CASE revenue growth. Depreciation is straight line over the useful life of the equipment. Solve for the NPY, IRR snd Payback period. Round off NPV o the nearest dollar, IRR to 1 decimal place and Payback to 2 decimals. In this assignment, you are evaluating a potential capital investment project that has a 4 year life. The financial details are as follows: PART 1A: Use the Excel cells below to calculate all estimated project cash flows for the BASE CASE revenue growth. Depreclation is straight line over the useful life of the equipment. Solve for the NPV, IRR and Payback period. Round off NPV to the nearest dollar, IRR to 1 decimal piace and Payback to 2 decimals