The Litzenberger Company has projected the following quarterly sales amounts for the coming year: |
Q1 | Q2 | Q3 | Q4 | |||||||||
Sales | $ | 690 | $ | 720 | $ | 800 | $ | 870 | ||||
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 2 decimal places, e.g., 32.16. A negative answer should be indicated by a minus sign.) |
Q1 | Q2 | Q3 | Q4 | |||||
Beginning receivables | $ | $ | $ | $ | ||||
Sales | 690.00 | 720.00 | 800.00 | 870.00 | ||||
Cash collections | ||||||||
Ending receivables | $ | $ | $ | $ | ||||
b. |
Recalculate the cash collections with a collection period of 60 days. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. A negative answer should be indicated by a minus sign.) |
Q1 | Q2 | Q3 | Q4 | |||||
Beginning receivables | $ | $ | $ | $ | ||||
Sales | 690.00 | 720.00 | 800.00 | 870.00 | ||||
Cash collections | ||||||||
Ending receivables | $ | $ | $ | $ | ||||
c. |
Recalculate the cash collections with a collection period of 30 days. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. A negative answer should be indicated by a minus sign.) |
Q1 | Q2 | Q3 | Q4 | |||||
Beginning receivables | $ | $ | $ | $ | ||||
Sales | 690.00 | 720.00 | 800.00 | 870.00 | ||||
Cash collections | ||||||||
Ending receivables | $ | $ | $ | $ | ||||
A | 45Days (It means cash will be collected opening receivable plus half of current quarter) | |||||||
Q1 | Q2 | Q3 | Q4 | |||||
Beginning receivables | $270.00 | $345.00 | $360.00 | $400.00 | ||||
Sales | $690.00 | $720.00 | $800.00 | $870.00 | ||||
Cash collections | $615.00 | $705.00 | $760.00 | $835.00 | ||||
Ending receivables | $345.00 | $360.00 | $400.00 | $435.00 | ||||
B | 60 Days (It means cash will be collected opening receivable plus 1/3rd of current quarter) | |||||||
Q1 | Q2 | Q3 | Q4 | |||||
Beginning receivables | $270.00 | $460.00 | $480.00 | $533.33 | ||||
Sales | $690.00 | $720.00 | $800.00 | $870.00 | ||||
Cash collections | $500.00 | $700.00 | $746.67 | $823.33 | ||||
Ending receivables | $460.00 | $480.00 | $533.33 | $580.00 | ||||
C | 30 Days (It means cash will be collected opening receivable plus 2/3rd of current quarter) | |||||||
Q1 | Q2 | Q3 | Q4 | |||||
Beginning receivables | $270.00 | $230.00 | $240.00 | $266.67 | ||||
Sales | $690.00 | $720.00 | $800.00 | $870.00 | ||||
Cash collections | $730.00 | $710.00 | $773.33 | $846.67 | ||||
Ending receivables | $230.00 | $240.00 | $266.67 | $290.00 |
I hope this clear your doubt.
Feel free to comment if you still have any query or need something else. I'll help asap.
Do give Thumbs up if you find this helpful.
The Litzenberger Company has projected the following quarterly sales amounts for the coming year: Q1 Q2...
The Litzenberger Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $ 790 $ 820 $ 900 $ 980 a. Accounts receivable at the beginning of the year are $380. 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 2 decimal places, e.g., 32.16. A negative answer should be indicated by...
The Gruber Company has projected the following quarterly sales amounts for the coming year. Q1 Sales $670 Q2 Q3 $700 $780 Q4 $850 a. Accounts receivable at the beginning of the year are 5290. 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 2 decimal places, e.g., 32.16. A negative answer should be indicated by a minus sign.)...
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: 01 02 03 04 Sales $830 $860 $940 $970 a. Accounts receivable at the beginning of the year are $420. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following (A negative answer should be Indicated by a minus sign. Round your answers to 2 decimal places, e.g. 32.16.) Q2 Q3 Q4 $ T...
The Bass Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $540 $630 $590 $840 Required: (a) Accounts receivable at the beginning of the year are $295. Bass has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following (Do not round intermediate calculations. Round your answers to the nearest dollar amount (e.g., 32)): Q1 Q2 Q3 Q4 Beginning receivables $ $ $ $ Sales...
The Litzenberger Company has projected the following quarterly sales amounts for the coming year: The Litzenberger Company has projected the following quarterly sales amounts for the coming year: Sales 01 $800 02 $830 03 $910 04 $990 a. Accounts receivable at the beginning of the year are $390. 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 2 decimal...
The Doak Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $7,950 $9,750 $9,150 $7,650 a. Accounts receivable at the beginning of the year are $3,750. 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.) b. Accounts receivable at the beginning of the year...
King Fisher Aviation has projected the following quarterly sales amounts for the coming year: Quarter 1 $750 Quarter 2 $820 Quarter 3 $790 Quarter 4 $950 Accounts Receivable at the beginning of the year are $350. King Fisher has a 30-day collection period. Calculate the cash collections in each of the four quarters by completing the following for each quarter Beginning receivables Sales Cash Collections Ending Receivables Rework the Ending Receivables calculation using 45 and 60 days What do you...
The Geller Company has projected the following quarterly sales amounts for the coming year: Q1Q2Q3Q4 Sales$630$660$720$870 a.Accounts receivable at the beginning of the year are $390. 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.) b.Accounts receivable at the beginning of the year are $390. The company has a 60-day collection period. Calculate cash collections in each of...
The Geller Company has projected the following quarterly sales amounts for the coming year: Q1Q2Q3Q4 Sales$630$660$720$870 a.Accounts receivable at the beginning of the year are $390. 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.)b.Accounts receivable at the beginning of the year are $390. The company has a 60-day collection period. Calculate cash collections in each of...
Lewellen Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales $ 840 $ 920 $ 880 $ 980 Sales in the year following this one are projected to be 10 percent greater in each quarter. a. Calculate payments to suppliers assuming that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assume that the company pays immediately. (Do not round intermediate calculations and round your...