Exercise. Sensitivity Analysis: Analysis of the Coulson Industries cash budget prepared for each month in question using the worst case, most likely, and best estimate of total cash receipts and disbursements. The most likely calculation is based on the expected results presented above.  During October, Coulson will need, at worst, a maximum of $15,000 in financing and, at best, will have an excess cash balance of $62,000.  During November, your financing need will be between $0 and $185,000, or you could experience an excess cash balance of $5,000.  December projections indicate maximum funding of $190,000 with a possible excess cash balance of $107,000. Considering the extreme values of the pessimistic and optimistic results, Coulson Industries could better plan its cash needs. For the 3-month period, the worst-case maximum funding need would be $190,000, which is much higher than the most likely estimate of $76,000 for that period.