Cash Flow (or Month-to-Month) Budget

Using the annual budget as the foundation, prepare a cash flow or month-to-month budget. Make sure that the amounts associated with each line item matches the timing outlined in the objectives and methods. Do not just divide the amount of each line item by twelve and indicate the same amount will be spent each month for each line item. Make realistic assumptions about the anticipated grant funds disbursement. Ensure that you make the assumptions transparent with a footnote. If you anticipate any income or expense being linked to particular activity, make sure you reflect that income in the month it is likely to be received or spent. Prepare the cash flow budget using the Microsoft Excel spreadsheet provided.

Sample Solution