b$.$ If the firm's 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.

Use the Data Table function to vary the sales adjustment factor and collections in the second month to determine the resulting changes in the maximum loans required.

$***$Cash Budget results$***$

During second month after sale: July: $$27,000$; August: $54,000$; September: $81,000$; October: $108,000$; November: $54,000$; December: $54,000$