Prepare a 12-month cash flow budget based on the data given in Figure 6.15 (page 122), Grant Funding Conditions. Assume that the fiscal year is from July 1 to June 30 and that each grant will begin in the fiscal year. For example, the $140,000 grant for homeless youth will begin October 1, months after the fiscal year has begun.

 

EXHIBIT 6.15 Grant-Funding Conditions Grant Federal Grants Homeless Youth Independent Living HUD Street Outreach State Grants Governor's Crime Commission Juvenile Justice Local Grants City of Raleigh Wake County Fee for Service Medicaid" Other Funding United Way Duke Endowment Fiscal Length Year Amount (years) Start $140,000 3 199,963 5 60,506 2 100,000 3 90,000 2 857,299 1 28,000 1 63,138 1 100,400 1 263,524 1 55,535 2 Oct. 1 Oct. 1 Mar. 1 Oct. 1 June 1 July 1 July 1 July 1 July 1 Jan. 1 Mar. 1 Payment Interval Monthly Monthly Monthly Monthly Monthly Monthly in advance Quarterly Monthly Monthly in advance Whole Reimbursement amount in Advance Time Within 72 hours Within 72 hours Within 72 hours Within 72 hours 2 weeks Upon being 1 to 6 months billed Within 1 month Within 3 to 4 weeks