NEED HELP IN THIS ASAP *excel solution if possible

ferent Lives) 1. Bulaklak Oil Company must install anti-pollution equipment in a new refinery in Bataan to meet clean air legislation. It is considering five types of equipment, and the following data are available (5 year study period): Kampupot Kalatsutsi Katuray Investment P1,500,000 P1,000,000 P1,400,000 Revenue yr. 594,210 480,000 590,433 Disbursementyr. Power 24,000 16,000 18,000 Labor 63,000 53,328 56,000 Maintenance 20,000 15,000 16,000 Estimated Life, yr. 8 5 6 Salvage Value 1) 10 12 15 Method of Depreciation SL SYD DDB If MARR is 20%, use IRR method to determine which proposal to accept. 2. MARR - 20%. Use PW method. Study period of 7 years. A D Initial Cost P190.000 P130,000 P100,000 P50.000 Life (n.) 4 6 7 5 Salvage Value 10% of initial cost Net Cash Flows 75,000 50.000 40,000 40,000 2 75.000 60,000 50,000 40,000 80,000 70,000 60,000 40,000 4 80,000 80,000 50.000 30,000 5 70,000 60.000 40,000 6 70,000 60,000 60,000 Depreciation Method DDB SL SYD DB B 3 7