Answered step by step
Verified Expert Solution
Question
1 Approved Answer
MC04 7 - 8 I will upvote thank you Question 7 If 20% of sales are cash, 50% of credit sales are collected during the
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$6G3Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started