In: Finance
|
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: |
| Q1 | Q2 | Q3 | Q4 | |||||||||
| Sales | $ | 750 | $ | 780 | $ | 860 | $ | 940 | ||||
| a. |
Accounts receivable at the beginning of the year are $340. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places, e.g., 32.16.): |
| Q1 | Q2 | Q3 | Q4 | |||||
| Beginning receivables | $ | $ | $ | $ | ||||
| Sales | 750.00 | 780.00 | 860.00 | 940.00 | ||||
| Cash collections | ||||||||
| Ending receivables | $ | $ | $ | $ | ||||
| b. |
Recalculate the cash collections with a collection period of 60 days. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places, e.g., 32.16.) |
| Q1 | Q2 | Q3 | Q4 | |||||
| Beginning receivables | $ | $ | $ | $ | ||||
| Sales | 750.00 | 780.00 | 860.00 | 940.00 | ||||
| Cash collections | ||||||||
| Ending receivables | $ | $ | $ | $ | ||||
| c. |
Recalculate the cash collections with a collection period of 30 days. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places, e.g., 32.16.) |
| Q1 | Q2 | Q3 | Q4 | |||||
| Beginning receivables | $ | $ | $ | $ | ||||
| Sales | 750.00 | 780.00 | 860.00 | 940.00 | ||||
| Cash collections | ||||||||
| Ending receivables | $ | $ | $ | $ | ||||