MC04 1 - 3 I will upvote thank you

Question 1 1pts Assume that the firm XYZ has the following information provide Sales, the timing of cash COLLECTIONS (RECEIPTS) and cash DISBURSEMENTS. Based on the given information, establish a Cash Budget: Sales of the firm for October, November, and December were $340,000,$180,000, and $160,000. The forecasted sales for January, February and March are $200,000,$140,000, and $260,000. And, the firm always pays for 80% of its sales value as disbursements. Of the 80% of disbursements, the firm pays 50% right away in cash (now). And, of the disbursements, 30% is paid in 2 months, and 20% is paid in 3 months. Which formula provides the correct value in F13 ? =$B$12D10=$B$13E10 none of the answers is correct. =$B$13C10 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 F10 for January? =SUM(F5:F9)=SUM(G3:G9)=SUM(F3:F9) none of the answers is correct. Question 3 1 pts 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,000,000,$4,500,000, and $5,000;000. The forecasted sales for January, February and March are $5,500,000, $6,000,000, and $6,500,000. And, the firm's collections (receipts) and disbursements are shown on the picture above. Which formula provides the correct value in F21 for February? none of the answers is correct. =IF($C$23G20>0,$C$23G$20,0)=IF($C$22H20>0,$C$22H$20,0)=IF($C$23F20>0,$C$23F$20,0)=IF($C$23H20>0,$C$23H$20,0)