Download as:
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Language:EN
Pages: 5
Words: 911

Paf budgeting

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

  2. 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)

  1. Daycare services for infants & toddlers

  2. 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:

  1. Calculate your agency’s BURN RATE

  2. 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

  1. Budget presentation & Cashflow Projection

  2. Your specific answers to the additional questions asked

Copyright © 2009-2023 UrgentHomework.com, All right reserved.