Here's the updated question with the table.

If the image quality is poor, I found that right-clicking and opening in a new tab improves quality.

Accounts receivable as collateral Springer Products wishes to borrow $90,000 from a local bank using its accounts receivable to secure the loan. The bank's policy is to accept as collateral any accounts that are normally paid within 30 days of the end of the credit period, as long as the average age of the account is not greater than the customer's average payment period. Springer's accounts receivable, their average ages, and the average payment period for each customer are shown in the following table: The company extends terms of net 30 days. a. Calculate the dollar amount of acceptable accounts receivable collateral held by Springer Products. (reduces collateral by 15% for returns and allowances. What is the level of acceptable collateral under this condition? c. The bank will advance 85% against the firm's acceptable collateral (after adjusting for returns and allowances). What amount can Springer borrow against these accounts? a. Which accounts will be acceptable? (Select the best answer below.) Data Table O A. C, E, F, G, H O B. B, D, F, G, H O C. A, B, C, D, E OD. A, E, F, G, H in order to copy the contents of the data table below into a (Click on the icon here spreadsheet.) What is the total dollar amount of accounts receivable collateral? (Select the best answer below.) Accounts Customer O A. $88,000 O B. $89,000 OC. $118,000 OD. $90,000 IOTMOOD $11,000 $25,000 $10,000 $28,000 $14,000 $19,000 $30,000 $16,000 Average age of account 42 days 70 days 48 days 55 days 50 days 21 days 10 days 25 days Average payment period of customer 50 days 65 days 45 days 50 days 60 days 35 days 30 days 40 days b. If the bank reduces collateral by 15% for returns and allowances, what is the level of acceptable collateral under this condition? (Select the best answer below.) Print Done O A. $74,800 O B. $75,650 OC. $100,300 O D. $76,500 c. The bank will advance 85% against the firm's acceptable collateral (after adjusting for returns and allowances). What amount can Springer borrow against these accounts? (Select the best answer below.) O A. $64,303 O B. $65,025 OC. $63,580 O D. $85,255