Paf budgeting
To present your agency’s cash position over the year with a Cashflow Analysis.
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)
Daycare services for infants & toddlers
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:
Calculate your agency’s BURN RATE
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
Budget presentation & Cashflow Projection
Your specific answers to the additional questions asked