i need excel formula to solve it

DSC | A1 Problem 5-30 Value of mixed streams. Find the present value of the streams of cash flows shown in the following table. Assume that the firm's opportunity cost is 12% Year 1 Year 1 25 1 Cash flow S 10,000 15,000 yr 7,000 Year IS 6-10 | Cash flow S -2,000 3,000 14,0000 16,000 8,000 Cash flow S10,000/yr 18,000 yr Solution Project A Opportunity cost S 1256 -2,000 3,000) 14,000) 16.000 6,000 Net present value Project B Opportunity coat 1 1706 10,0000 5,000) 15,000) 15,000 IS 5,000 IS 17,0000 Project 1106 IS 10,000 110,0001 10.0001 10,0000 1110.0000 18,0000 18,0000 18,0001 18,000) 5,000 Net present value 49 Requirements | Problem 5-30 1