Rework Problem 15-10 using a spreadsheet model. After completing Parts a through d, respond to the following: If Bowers' customers began to pay late, collections would slow down, thus increasing the required loan amount. If sales declined, this also would have an effect on the required loan. Do a sensitivity analysis that shows the effects of these two factors on the maximum loan requirement.