Markham Enterprises needs to plan its cash requirements and short-term investment opportunities for the months of June, July, and August. The following data are available. The beginning balance is –$28,000 for June and the minimum required cash balance is $30,000. All amounts are shown in thousands of dollars.

a. Prepare a scenario analysis of Markham Enterprises.
b. Identify the finance need/surplus for each month under the different scenarios. If needed, where could the funds be obtained? What should be done with a surplus of cash?

Transcribed Image Text:

Total cash receipts Total cash disbursements June Most Opti- Pessi- Pessi- mistic likely mistic mistic $250 $370 $430 $245 260 310 405 255 July Most Opti- Pessi- likely mistic mistic $305 $395 $265 285 375 280 August Most Opti- likely mistic $335 $412 300 396