Based on the data below

What is the Net Present Value using an 8% cost of capital?

What is the Profitability Index?

What is the internal rate of return?

What is the payback period?

What is the present value payback using the 8% cost of capital?

YEAR 1 2 3 4 5 6 7 Acquisition Stage Assumptions: Research & Development Costs $ 160.000,0001 Initial Promotion (24.000.0001 Expenses related to new supply network [2.000.0001 Employee Training (72.000.0001 Vendor Testing (1.500,0001 Additional investment in working capital ($ of sales: 92] 9.007 9.003 9.003 9.003 9.003 9.003 9.003 9.003 9.003 Working Capital Balance 18.000 000 18.820.000 19.500.000 $9.820.000 $10.628.000 $10.959.999 $11.420.000 $11.780.000 $12.199.000 Incremental investment in working capital $ (8 000.000) $ [820.000) $ [680 000) $ (320.000] $ (808 000) $ (371.999) $ (420.0011 $ (360 0001 $ [419.0001 Operating Stage Assumption 3 Additional sales of new product growth in 2-8 years $450.000.000 52 52 42 42 42 Lost sales of existing products growth in 2-8 pears $10.000,000 $10.000,000 $10.000 000 $10.000.000 $10.000,000 $10.000.000 $10.000,000 $10.000.000 Variable cost of new product (593] 592 592 592 592 592 592 593 Additional fixed cost associated with new products 1,000 000 1.000.000 1.000.000 1,000 00 0 1.000.000 1.000.000 1.000,00 0 1.000.000 Tax rate 242 242 243 242 242 242 242 242 Continuing stage cash flows Aquisition Stage Cash Flows 0 2 3 5 6 8 Research and Development cost (60.000 0001 Initial Promotion (24.000.0001 Expenses related to the new supply network (2.000,0001 Employee Training (72.000.0001 Vendor Testing (1.500.0001 Additional Investement in working Capital 18.000 0001 820.000 680.000 320.000 808,000 307.000 185.000 360.000 419.000 Total Aquisition Stage of Cash Flows [167.500.0001 [820.0001 [680.0001 (320.0001 (808 0001 (307.0001 (185.0001 (360.0001 (419.0001 Operating Stage Cash Flows Additional sales in new products $450.000.000 $450.786.005 $450.790.870 $450.795.735 $450.800.600 $450.805.465 $450.810.330 $450.815.195 Lost sales of existing product (10.000.000) $ (10.000,0001 $ (10.000,0001 (10.000 000) $ (10.000 000) $ (10.000,000) $ (10 000 000) $ [10.000,0001 Variable cost of new product 265.500.000 $265.825.870 $266.151.740 $266.477.610 1266.803.480 $267.129.350 1267.455.220 $267.781.090 Additional fixed cost associated with new products (1.000 0001 $ (1.000 0001 $ (1.000 0001 $ (1.000 000) $ (1,000.000) $ (1,000,000) $ (1,000,0001 $ (1.000 00 01 Tax Income $704.500.000 $705.611.875 $705.942.610 $706.273.345 $706.604.080 $706.934.815 $707,265.550 $707.596,285 Taxes (169 080 000) 1 (169, 346 850] 4 (169 426,226) 1 (169 505,603) $ 169 584,979] $169.664,356) $ 169.743,732] (169 823.108] After Tax Income $ 873.580.000 $ 874.958.725 875.368.836 $ 875.778,948 $ 876.189.059 1 876.599.171 $ 877.009 282 877.419.393 Continuing Stage 2 3 6 Continuing Value 14.387.096.967 Total Cash Flows $ (167.500.000) $ 872,760,000 $ 874.278.725 $ 875.048.836 $ 874.970,948 $ 875.882.059 $ 876.414.171 $ 876.649.282 $ 5.264.097.360