Calculating cash collections - ABC Company has projected the following quarterly sales amounts for the coming year. Q1 S840 Q2 $910 Sales Q3 $780 04 $840 1. Accounts receivable at the beginning of the year are $300. ABC has a 45 day collection period. Calculate the cash collections in each of the four quarters by completing the following: Write out the formula to calculate the percentage of sales collected in a quarter with the 45 day collection period and then populate the information below: You can recreate the chart below by highlighting it, copy with CTRL and C or left click and copy, then paste into the answer box below with a CTRL and V or left click and copy. 01 300 Q2 Q3 04 Beginning receivables Sales Cash Collections Ending Receivables