Check the attached.

Question 7 You are asked to compare the following investment alternatives using the NPV with a return rate 15% & the IRR criteria Option 1 Option 2 YEAR Outflows Inflows Outflows Inflows S(5,000) S- S(5,000) S(1,000) S(1,000) S(1,000) S(500) S(500) S(500) S5,000 S15,000 $16,500 $8,000 S8,000 S8,000 $8,000 S8,000 S8,000 S8,000 S8,000 S8,000 S8,000 s18,150 $19,965 S21,962 S24,158 S26,573 S29,281 S82,154 S85,869 S38,906 S42,797 S47,076 S51,784 Provide your work in EXCEL and generate all appropriate graphs. Discuss your work and your 4 S(500) S(1,000) S(500) S(1,000) S(1,000) S(1,000) S1,000) S(1,000) S(1,000) S(1,000) 5 6 S(500) 7 S(500) S(500) 10 S(2,000) S(500) 11 12 S(500) S(500) 13 14 S(500) S(500) 15 suggestions in detail