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 comer of the data table below in order to copy its contents into a spreadsheet.) October ($000) November ($000) December ($000) Opti mistic Total cash receipts Total cash $344 $461 $367 $191 327 420 205 261 314 286 331 317 a. Prepare a scenario analysis of Trotter's cash budget using -$20,000 as the beginning cash balance for October and a minimum required cash balance of $17,000. a. Prepare a scenario analysis of Trotter's cash budget using-$20,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- mistio mistic Total cash receipts Total cash disbursements Net cash flow Add: Beginning cash Ending cash Financing Cash balance 260 $ 200 5 191 286 286 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 comer of the data table below in order to copy its contents into a spreadsheet.) October ($000) November ($000) December ($000) Opti mistic Total cash receipts Total cash $344 $461 $367 $191 327 420 205 261 314 286 331 317 a. Prepare a scenario analysis of Trotter's cash budget using -$20,000 as the beginning cash balance for October and a minimum required cash balance of $17,000. a. Prepare a scenario analysis of Trotter's cash budget using-$20,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- mistio mistic Total cash receipts Total cash disbursements Net cash flow Add: Beginning cash Ending cash Financing Cash balance 260 $ 200 5 191 286 286