Long-Range Financial Modeling

The NBOA Long-Range Financial Model is an easy-to-use, customized ten-year budget model, created as an Excel spreadsheet. The model generates charts and graphs which can easily be dropped into dashboards or other presentations. It also creates real-time forecasts for tuition, enrollment, FTEs, plant replacement and more.

In this class, business officers will:

  • Learn the benefits of long-range financial modeling and how it may be used to guide decisions as part of long-range planning at independent schools.
  • Experiment with the modeling tool and receive instructions on loading the model and the assumptions users will need to make to use the tool effectively.
  • Receive coaching on the model and practice using the reporting and graphing tools to make presentations to the head of school, finance committee and other trustees.

This course is being offered in partnership between NBOA and One Schoolhouse.

Course Schedule

Week 1

Introduction to Long-Range Financial Modeling

Learn about the benefits of financial modeling and the genesis of NBOA's tool. Participants will be introduced to and given NBOA's Long-Range Financial Model. Participants are required to load their school's data into the model and upload a copy for the facilitators to review.

Week 2

Loading and Testing the Model

Participants will learn how the parameters for the model's assumptions were developed. Participants will then use their school's data to see how changes to those assumptions impact their school's long-term budget planning. Participants must complete this exercise before moving on to Week 3.

Week 3

Reporting from the Model

Participants will learn how to use the reporting tools in the model and receive tips on how to enhance their reporting to their head, finance committee and trustees, using the data generated. To earn the badge for the week, participants must either demonstrate the model to someone at their school and post a short synopsis of the meeting, or schedule a half hour meeting with one of the instructors to have their questions answered and get assistance with customizing their model to meet their school's needs.

 
SHRM

SHRM Information

Credit Hours: 6

Category: Business Acumen

NBOA is recognized by SHRM to offer SHRM-CP or SHRM-SCP professional development credits (PDCs). For more information about certification or recertification, please visit www.shrmcertification.org.

HRCI

HRCI Information

Credit Hours: 6

Category: HR (Business)

NBOA is a recognized provider of recertification credits. HR Certification Institute® pre-approved this program for credits towards aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification.

Questions?

Email programs@nboa.org or call 202-407-7140

Dates

Sep 30 - Oct 18, 2019  Closed

Jan 21 - Feb 7, 2020  Register

Jun 8 - Jun 26, 2020  Register

Cancellation and refund policies

Pricing

Members:
$445

Nonmembers:
$635

Group rebate available

Time Commitment

3-5 hours per week for 3 weeks

Learn more about the platform and coursework

Class Size

Up to 35 participants

Recommended Audience

  • Business officers
  • Controllers
  • Business office staff