MC04 7 - 8 I will upvote thank you

Question 7 If 20% of sales are cash, 50% of credit sales are collected during the month following the sale, and the remaining credit sales are collected two months after the sale, what is the formula in E6? none of the answers is correct. =B6C2=B6E2=C2E2=B5C2 Assume that the firm ABC Inc. has the following information provide Sales, the timing of cash COLLECTIONS (RECEIPTS) and cash DISBURSEMENTS. The sales of the firm for October, November, and December were $4,850,000,$3,750,000, and $4,573,000. The forecasted sales for January, February and March are $4,801,650, $4,041,733, and $5,293,820. And, the firm's collections (receipts) and disbursements are shown on the picture above. Also, the firm collects 20% of its revenues (sales) in cash (now), 30% in 1 month, 40% in 2 months, and 10% in 3 months. Additionally, the firm has additional $120,000 monthly rental income from its buildings. Which formula provides the correct value in G6 for February? =$B$6F3=$B$6G3 none of the answers is correct. =$B$6G3