Paf budgeting

3. To present your agency’s cash position over the year with a Cashflow Analysis.

4. To provide a written synopsis of your assumptions (approximately 2 pages bullet point- Word document) OR you can incorporate all your assumptions into the Excel workbook

• Size of staff- 120 full time and 30 part-time (with no health benefits- they work less than 20 hours week)

• 3 program sites (locations where programs/classrooms are held)

2. Daycare services for infants & toddlers

3. Family case management services

• FY 2016 Annual Operating Budget is approximately $12,000,000 (BALANCED) was approved by board in May 2015.

• Your agency is projected to end FY 2016 (June 30, 2016) with an operating deficit ($400,475).

• The Board is considering undertaking a Feasibility Study (a plan to evaluate whether or not to move forward with a formal campaign) on a potential Capital Campaign to buy a building

  • ASSUMPTIONS

• ASSUME OCCUPANCY COSTS WILL INCREASE BY 5% FOR FY 2017

• YOU CANNOT ADD ANY REVENUE OR EXPENSE LINE ITEMS

Task 3:

• Produce a BALANCED FY 2017 OPERATING BUDGET, taking into account the budget cuts you will receive on the Revenue Side

TASK 4:

• With the following information you will also put together a Cash Flow Analysis for the year (FY 2017).

  • • $500,000 in Money market reserve account

    • DO NOT INCLUDE LINE OF CREDIT

TASK 5:

Answer these additional questions:

5. Calculate your agency’s BURN RATE

6. If your Cash Threshold is 3 months- When do you meet this threshold?

What will the assignment look like when completed?

EMAIL A COMPLETE VERSION BY MAY 24, 2016 AT MIDNIGHT

A 2 page (maximum) bullet point summary of your key assumptions or include your assumptions on the spread sheets

1-2 pages narrative answering the additional questions

4. Budget presentation & Cashflow Projection

5. Your specific answers to the additional questions asked