The Geller Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $510 $540 $600 $750 a. Accounts receivable at the beginning of the year are $270. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to the nearest whole number, e. g., 32.)

The correct answer are $525, $525, $570 and $675 respectively.

Explanation:

According to the scenario, the computation of the given data are as follows:

Collection period = 45 days

Days in one quarter = 90 days

So, Amount collected during the quarter = (90 - 45) / 90 = 1/2 of current sales + Beginning Accounts receivables

So, we can calculated the cash collection as follows:

Q1 Q2 Q3 Q4

Beginning A/c. receivables $270 $255 $270 $300

Sales $510 $540 $600 $750

Cash Collections $525 $525 $570 $675

Ending A/c Balance $255 $270 $300 $375

Note: Ending balance is the beginning balance for next quarter.