Assume the following information for Royal:

BB of cash on April 1 is $40,000.

Purchases an asset for $75,500 in April; paid in cash.

Monthly payments for S&A expenses is 10,000 per month.

Maintains a 12% open line of credit for $100,000.

Maintains a minimum cash balance of $40,000.

Borrows on the first day of the month and repays loans on the last day of the month.

Question: Complete the table with the above information.

April May June Quarter BB of Cash 40,000 Sec. 1 170,000 400,000 335,000 905,000 Add: Cash Collection from Cust Cash inflows from other sources 210,000 440,000 Total Cash Available Sec.2 Less: Cash Disbursements DM 40,000 72,300 72,700 DL 65,000 115,000 725,000 MOH 21,500 26,500 22,250 S&A expenses 10,000 10,000 10,000 Purchases of a new asset Total Cash Disbursements Sec.3 Excess (Deficiency) Sec.4 Financing: Borrowing Payment Interest Total Financing EB of Cash