Complete the below Cash Flow Problem:

Cash Budget Problem

1. Unified Path gives a $93,000 grant to Care for the Homeless (CH) at the start of CH's year in January. To expand its activities, Care for the Homeless has convinced the city, state, and county governments to give them additional funds for this year. The city will give them $24,000, the state will give them $88,000, and the county will give them $50,000. The city will pay its share in equal monthly installments; after the month has ended (the payment for January arrives in February and so on). The state will pay60%in the first month of the year, and the balance equally over the remaining months. The county will pay20%of its outstanding balance each month, with any balance unpaid in the last month. Prepare a cash budget for January, February, and March, showing just the cash inflows for each month. (HINT: fill in the table below)
2. Cash ReceiptsJanuaryFebruaryMarchUnified PathCity (1/12th each mo; starting in Feb)State (60%in Jan; 1/11th each mo. after)County (20%of the outstanding balance each mo)
3. Care for the Homeless (CH) expenses are projected to be $20,000 per month. Will the projected income cover expenses? If there is excess cash available in some months, what would you recommend that CH do with the excess?