Please help me answer the following questions:1. What is the payback period of this project?2. What is the profitability index of this project?3. What is the IRR of this project?4. What is the NPV?

Equipment 10,500,000 Pretax salvage value 1,100,000 R&D 200,000 Marketing study 150,000 Year 1 Year 2 Year 3 Year 4 Year 5 Sales (units) 75,000 85,000 30,000 70,000 60,000 Sales of old product 45,000 25,000 Lost sales 10,000 10,000 Depreciation rate 14.29% 24.49% 17.49% 12.49% 8.93% Price 240 VC 140 FC 2,100,000 Price of old product 150 Product price after reduction 120 VC of old product 95 Tax rate 30% NWC percentage 22% Required return 10% Sales Year 1 Year 2 Year 3 Year 4 Year 5 New 18,000,000 20,400,000 19,200,000 16,800,000 14,400,000 Lost sales 1,500,000 1,500,000 Lost revenue 1,050,000 450,000 Net sales 15,450,000 18,450,000 19,200,000 16,800,000 14,400,000 VC New 10,500,000 11,900,000 11,200,000 9,800,000 8,400,000 Lost sales 950,000 950,000 Total VC 9,550,000 10,950,000 11,200,000 9,800,000 8,400,000 Sales 15,450,000 18,450,000 19,200,000 16,800,000 14,400,000 VC 9,550,000 10,950,000 11,200,000 9,800,000 8,400,000 Fixed costs 2,100,000 2,100,000 2,100,000 2,100,000 2,100,000 Dep 1,500,450 2,571,450 1,836,450 1,311,450 937,650 EBT 2,299,550 2,828,550 4,063,550 3,588,550 2,962,350 Tax 689,865 848,565 1,219,065 1,076,565 888,705 NI 1,609,685 1,979,985 2,844,485 2,511,985 2,073,645 +Dep 1,500,450 2,571,450 1,836,450 1,311,450 937,650 OCF 3,110,135 4,551,435 4,680,935 3,823,435 3,011,295 NWC Beg 0 3,399,000 4,059,000 4,224,000 3,696,000 End 3,399,000 4,059,000 4,224,000 3,696,000 NWC CF 3,399,000 (660,000 (165,000 528,000 3,696,000 Net CF (288,865) 3,891,435 4,515,935 4,351,435 6,707,295 BV of equipment 2,342,550 Salvage 1,100,000 Taxes on sale of equipment 372,765 Salvage CF 1,100,000 Cash flow on sale of equipment 1,472,765 Year 0 1 2 3 4 CF (10,500,000) (288,865) 3,891,435 4,515,935 4,351,435 8,180,060