Budgeting Cash Flows. Eagleview City prepares a quarterly forecast of cash flows for its water service department. Data for the upcoming quarter (in alphabetical order) measured on the cash basis are presented below.

The city maintains no more than the minimum cash balance of $100,000 on hand.
Required
a. What are the projected cash flows from operating activities, noncapital financing activities, capital and related financing activities, and investing activities? Indicate whether the balance is a positive cash flow or a negative cash flow.
b. What is the projected amount the city will have to borrow at the end of the quarter to maintain the minimum balance, or what is the amount the city has to invest that exceeds the minimum balance?
c. What steps can the city take to prevent being in a position where it will have to borrow at the end of thequarter?

Transcribed Image Text:

Bond interest expense Current month's collections on receivables Interest income on excess cash from previous months Investment income Materials and supplies disbursements Nonoperating revenue Other fees and services disbursements Previous months' collections on receivables Personal services disbursements Transfers in Transfers out $ 1,950,000 4,349,350 1,849 11,250 925,000 479,030 4,070,000 4,582,425 1,991,000 50,000 540,000