= Homework: Homework Set 4 Question 6, P4-13 (simil... Par 1 of 4 HW Score: 19.17%, 9.58 of 50 points O Points: 0 of 2 Save Cash budget scenario analysis Trotter Enterprises, Inc. has gathered the following data in order to plan for its cash recuirements and short-term investment opportunities for October November, and December. All amounts are shown in thousands of dollars. Click on the loon located on the top-right corner of the data table below in bruer o copy its contents into a spreadsheel.) Opel mistic October (8000 November (5000) December (5000) Passi- Most Opti Pessi Most Opti Pess! Most mistic likely mistic mistic likely mistic mistic likely Total cash receipts 5281 5310 5462 $198 3287 5367 $192 S292 Total cash disbursements 287 324 421 201 315 287 334 a. Prepare a scenario ralysis of Troller's cash budget using -S20,000 as the begirning cash balarice for October and a minimum required cash balance of $18,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 sid the planning process. $855 S15 a. Prepare a scenario analysis of Troller's cash budget using - 520.000 as the beginning cash balarice for October and a minimum required cash Lalance of $18,000. Complete the cash budget for the pessimistic scenario balow (Round to the nearest doiler) Trotter Enterprises, Inc. Multiple Cash Budgets ($000) October November Pessl. Passi- mistic mletic December Pessi mistic S 261 S 1939 192 Total cash recaints Total cash dishurs monts 287 204 287 S S S $ Net cash flow Add: Reginning cash Ending cash Financing S S $ S Cash balance $