USING Excel solve

Problem-4 For a stream having composition as shown in Table-2. Solve the Rachford-Rice equation to find out the v, and then find out the vapor and liquid composition. + NCOMP (Ki - 1) 1 +(K-1) = 0 Rachford-Rice equation, zi is mole fraction; i=1 Xi = Zi 1 +(K-1)v Liquid composition if y is known. Yi = KX Vapor composition Table 2 Stream data Chemical Propane n-Butane n-Pentane lbmol/hr 20 30 50 Ki 3.7 1.4 0.6 Hint: First find out (Ki-1) z for each component assuming a value for v; then set the sum of 1+(Ki-1)vi this to zero by varying v? Once the value for v is found, xi and yi can be calculated by using equations given above