Cash Programming When the NTA Is Delayed and Funds Are Earmarked
In the Municipality of San Isidro, the treasurer is preparing the April–June cash program. On March 31 the consolidated cash balance is ₱18.6 million, but ₱4.2 million is the unexpended 20% Development Fund with ongoing project obligations and ₱2.8 million is a trust fund held for a barangay water project. Outstanding checks total ₱3.1 million. April obligations include payroll of ₱5.4 million due on the 15th, loan amortization of ₱2.0 million due on the 20th, and a contractor's progress billing of ₱4.5 million for a road project. The National Tax Allotment for April, usually ₱12.0 million, has been delayed and is now expected three weeks late. A supplier offers a 2% discount if its ₱4.5 million billing is paid by April 10. The mayor wants to 'use whatever cash is available' to capture the discount and avoid work delays.
1. Determine the cash genuinely available for discretionary April disbursements and rank the obligations. Show the computation and explain how the restricted balances and outstanding checks affect the decision.
Read the worked answer
Start with total cash of ₱18.6 million. Subtract the ₱2.8 million trust fund and the ₱4.2 million 20% Development Fund because both are restricted or earmarked. Also subtract the ₱3.1 million in outstanding checks because those checks may clear at any time; the bank balance overstates free cash. Free cash is therefore about ₱8.5 million, not ₱18.6 million.
The near-term mandatory calls are payroll of ₱5.4 million and loan amortization of ₱2.0 million, totaling ₱7.4 million. That leaves roughly ₱1.1 million before any NTA arrives. The ₱4.5 million progress billing cannot be paid in full from free cash in early April without risking payroll or debt service.
Rank the obligations: payroll first, debt service second, then contractual progress payments after NTA confirmation or on a pro-rata basis. The cash program should show weekly inflows and outflows, a minimum operating balance, and a contingency. Do not use trust or development funds to cover the gap; that is a legal and accountability problem even if the cash sits in the same bank account. The treasurer should also confirm the NTA release date in writing and report the projected gap to the local finance committee.
2. The supplier's 2% discount is worth ₱90,000. Should the treasurer recommend paying by April 10? Frame the decision as a cash-programming and control question, not just a savings question.
Read the worked answer
The discount is real but not decisive. Paying ₱4.5 million by April 10 would consume almost all free cash and jeopardize the ₱5.4 million payroll and ₱2.0 million loan amortization if the NTA slips further. The treasurer should compare the ₱90,000 saving with the cost and risk of a payroll delay, penalties on debt service, and possible temporary borrowing.
A defensible recommendation is to decline the early-payment discount unless the NTA arrival is confirmed in writing and a minimum cash buffer remains after payroll and debt service. If the mayor insists, require a written cash-flow certification, a signed commitment that payroll and debt service are protected, and disclosure to the local finance committee. The treasurer should not sign checks ahead of available funds or reclassify restricted cash to create apparent liquidity.
The control answer is to make the decision on documented weekly cash forecasts and approvals, not on the lure of a discount. If the discount is still attractive, ask the supplier to hold it open until the NTA is confirmed and then pay only if the forecast shows a safe margin.
3. What monitoring and reporting controls should accompany the three-month cash program?
Read the worked answer
The program should be a rolling forecast, updated at least weekly with actual collections, NTA releases, checks cleared, and new obligations. Set a minimum cash floor and flag any week projected below it. Separate the cash program from the budget and from the books: it is a management tool, not authority to spend. Require commitments to be recorded before purchase orders or contracts are signed so the treasurer can see the full obligation.
The forecast should be reconciled to the bank reconciliation, the cashbook, and the ledger; differences should be investigated, not plugged. Report variance explanations to the mayor and local finance committee monthly. Restrict access to the forecast, keep supporting documents for assumptions, and require approval for changes in payment priorities. These controls make the cash program a decision document rather than a post-hoc justification.