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