Calculating cash collections - ABC Company has projected the following quarterly sales amounts for the coming year. Q1 $840 Q2 $910 Q3 $780 Sales 04 S840 1. Accounts receivable at the beginning of the year are S300. ABC has a 30 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 30 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. Q2 Q3 Q1 300 04 Beginning receivables Sales Cash Collections Ending Receivables