Cash budget-Scenario analysis Trotter Enterprises, Inc., has gathered the following data in order to plan for its cash requirements and short-term investment opportunities for October, November, and December. All amounts are shown in thousands of dollars. (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) October (5000) Pessi- Most mistic likely $261 $342 284 324 Opti mistic $460 421 November (5000) Pessi Most mistic likely $198 $289 202 261 Opti mistic $368 311 December (5000) Pessi Most mistic likely $189 $295 287 Opti mistic $355 313 Total cash receipts Total cash disbursements 331 a. Prepare a scenario analysis of Trotter's cash budget using - $21,000 as the beginning cash balance for October and a minimum required cash balance of $17,000. b. Use the analysis prepared in part a to predict Trotter's financing needs and investment opportunities over the months of October, November, and December. Discuss how knowledge of the timing and amounts involved can aid the planning process. a. Prepare a scenario analysis of Trotter's cash budget using - $21,000 as the beginning cash balance for October and a minimum required cash balance of $17,000. Complete the cash budget for the pessimistic scenario below: (Round to the nearest dollar.) Trotter Enterprises, Inc. Multiple Cash Budgets ($000) October November December Pessi- Pessi Pessi- mistic mistic mistic Total cash receipts $ 261 $ 198 $ 189 Total cash disbursements 284202287 Net cash flow $ $ Add: Beginning cash Ending cash Financing Cash balance $ $ $