i will upvote if you give me the answer in excel formula! please and thank you

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 Year Year 1 1 Cash flow $10,000/yr 8,000/yr B Cash flow $ 10,000 5,000/yr 7,000 Cash flow $ -2,000 3,000 4,000 6,000 8,000 1-5 6-10 2-5 6 3 4 5 Solution Project A Opportunity cost CF CF CF CF4 S s S $ S 12% -2,000 3,000 4,000 6,000 8,000 CFS Net present value Project B Opportunity cost CF CF2 CF3 12% $ 10,000 $ 5,000 5,000 5,000 5,000 $ 7,000 CF4 llll CFS CF Net present value Project C Opportunity cost CF CF2 CF3 CF4 CFS CF CF- CFS CFO 12% 's 10,000 $ 10,000 S 10,000 $ 10,000 S 10,000 S 8.000 S 8,000 S 8,000 8.000 S 8.000 ll CF 10 Net present value