Assistance with the development of a long range Financial Planning Model

Seeking qualified and experienced bidder(s) for assistance with the development of a long range Financial Planning Model

Friendship PCS is seeking a vendor to assist with the development of a long range Financial Planning Model.

Scope of services required:

Long Range Financial Planning Model

• Build a long-range financial projection model, with dynamic scenario capabilities; this will include:
  1. Clear and adjustable inputs for financial drivers, such as enrollment, revenue assumptions, program expenses, administrative expenses, and facility costs.
  2. Minimum viable enrollment analysis; sustainability requirements for strong program
  3. Dynamic functionality to test out changes to variables and scenarios.
  4. Staffing ratio analyses
  5. Greenlighting analyses for new school acquisitions and new school starts.
  6. Dashboard to inform financial sustainability, operational metrics, risks, and opportunities.
  7. Required philanthropic need.

• Vet key assumptions for revenues, expenses, facility scenarios and growth plans. This will include:
  1. Facility modules for lease and permanent acquisition scenarios, funding sources, long-term facility payments, and facility affordability.
  2. Enrollment and school start-up details by grade-level and sections
  3. Capacity of seats at existing schools and strategic opportunities for growth and change
  4. Revenue drivers for recurring and non-recurring funding for Federal, State, and Local sources
  5. Expense details for personnel and non-personnel cost drivers
  6. Simplified staffing for instructional and non-institutional positions
  7. Cash flow assumptions as necessary.
  8. Additional components and break-out calculations as necessary