In the coming year, Concord, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive motion injuries. The brace will be sold for $16.00 to retailers throughout the country. All sales will be made on account. An expected 65% of sales will be collected within the quarter of the sale, and another 30% in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The sales budget for the coming year is as follows: 1st Quarter 27,000 2nd Quarter 3rd Quarter 4th Quarter 45,000 60,000 80,000 Budgeted sales units Prepare Concord, Inc.'s cash receipts budget for the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0. Round "Budgeted sale price" and "Cash Receipts Budgets" answers to 2 decimal places, eg. 52.75 and all other answers to decimal places, eg. 5,275.) Sales Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted units sold Budgeted sales price $ $ $ Budgeted sales revenue $ $ $ $ $ Cash Receipts Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 1st quarter sales $ $ $ $ 2nd quarter sales 3rd quarter sales 4th quarter sales Totals $ $ $ $ Determine the Net Accounts Receivable at the end of the year. Net Accounts Receivable $ 4th Quarter Annual $ $ $ $ $ 4th Quarter Bad Debts $ $ $ $