Basically, we have data from B2 to B17, and we have to complete Capital Budgeting and find NVP and IRR.

Please provide formula!

B D E E F G H 50,000,000 Pesos 4,000,000 Pesos 600,000 Units 5 Pesos 1.8 Pesos 180,000 Pesos 50,000 Pesos 1% 300,000 Years 60,000 Pesos 45 Days 36 Days 5 Years 18.20% 30% 800,000 Pesos A 1 Capital Budgeting Analysis of Hola-Kola 2 Cost of new equipment 3 Resale value of equipment 4 Monthly sales (units) 5 Unit sale price 6 Unit raw material cost 7 Monthlylabor costs 8 monthly energy costs 9 % overhead to sales 10 GAS 11 Building rental 12 Average collection period (Days) 13 Average payment period (Days) 14 Years of straight line depreciation 15 Cost of capital 16 Tax rate 17 Erosion 18 19 Year 20 Cost of new equipment 21 Resale value of equipment 22 Less taxes 23 After-tax resale value 24 25 Annual sales (units) 26 Annual sales revenue 27 28 Operating expenses 29 Total Raw material costs 30 Total Direct labor costs 31 Total Energy costs 32 Building rental (opportunity costs) 33 Depreciation 34 GAS 35 Overhead expenses 36 Operating income 37 Operating income after tax 0 1 2 N 3 4 5 A B D E F 39 Project's OCF 40 Add back depreciation 41 Erosion of existing sales 42 Total OCF 43 44 45 Working capital requirements 46 Receivables ((Sales/365)*avg collection period) 47 Inventories (One month material costs) 48 Payables (Material costs/365)*avg pmt period) 49 50 Investment in NWC 51 Total cash flows 52 53 NPV 54 IRR 55 B D E E F G H 50,000,000 Pesos 4,000,000 Pesos 600,000 Units 5 Pesos 1.8 Pesos 180,000 Pesos 50,000 Pesos 1% 300,000 Years 60,000 Pesos 45 Days 36 Days 5 Years 18.20% 30% 800,000 Pesos A 1 Capital Budgeting Analysis of Hola-Kola 2 Cost of new equipment 3 Resale value of equipment 4 Monthly sales (units) 5 Unit sale price 6 Unit raw material cost 7 Monthlylabor costs 8 monthly energy costs 9 % overhead to sales 10 GAS 11 Building rental 12 Average collection period (Days) 13 Average payment period (Days) 14 Years of straight line depreciation 15 Cost of capital 16 Tax rate 17 Erosion 18 19 Year 20 Cost of new equipment 21 Resale value of equipment 22 Less taxes 23 After-tax resale value 24 25 Annual sales (units) 26 Annual sales revenue 27 28 Operating expenses 29 Total Raw material costs 30 Total Direct labor costs 31 Total Energy costs 32 Building rental (opportunity costs) 33 Depreciation 34 GAS 35 Overhead expenses 36 Operating income 37 Operating income after tax 0 1 2 N 3 4 5 A B D E F 39 Project's OCF 40 Add back depreciation 41 Erosion of existing sales 42 Total OCF 43 44 45 Working capital requirements 46 Receivables ((Sales/365)*avg collection period) 47 Inventories (One month material costs) 48 Payables (Material costs/365)*avg pmt period) 49 50 Investment in NWC 51 Total cash flows 52 53 NPV 54 IRR 55