March April May ant Supplies expects its cash receipts and cash payments for the part of the year to be Receipts Payments 19,280 19100 22,280 22,400 22.480 14700 Eddie's had a cash balance of $2,000 on March 1, which is also its minimum required cash balance. The company invests any cash in excess of $3,000 into marketable securities. Marketable securities are sold before funds are borrowed when a cash shortage occurs There is an outstanding loan of $2,000 on March 1. The opening balance of the Marketable Securities on Mar 1 was $0. Prepare a cash budget for March, April, and May by completing the following tables, (hil in every cell, even if the number is zero) April May Monthly Cash Flow March Cash Receipts Cash Payments (enter as positive number) INet Cash Flow fremember the negative sion. If Cash Budget March April May $ 2,000 Net Cash Flow Beginning Cash Bal Cumulative cash balance Borrowing and repayments Center repayments as negatives) Marketable securities (enter purchasing investments as negatives) Ending cash balance Cumulative Balances March April May $ 2,000 Bank Loan Beginning Loan Balance Borrow in the month Repay in the month (enter repayments as negatives) Ending Loan Balance I Marketable Securities Beginning Securities Balance Bought in the month $ 0 (enter repayments as negatives) Marketable securities (enter purchasing investments as negatives) Ending cash balance Cumulative Balances March April May $ 2,000 Bank Loan Beginning Loan Balance Borrow in the month Repay in the month (enter repayments as negatives) Ending Loan Balance $ 0 Marketable Securities Beginning Securities Balance Bought in the month Sold in the month Kenter sold as negatives) Ending Securities Balance