Financial Modeling Workbook

Printer-friendly version

In an effort to help organizations understand the financial feasibility of implementing Collaborative Care, the AIMS Center recently updated the Financial Modeling Workbook, which was created with help from the Institute for Family Health and the American Psychiatric Association. The revised Workbook helps organizations more accurately model and estimate revenue and expenses for providing integrated behavioral health services by:

  • Modeling how much time staff engage in key integrated care tasks;
  • Estimating visit volume, provider capacity, and potential caseload size; and
  • Estimating fee-for-service and BHI/CoCM potential revenues

The Workbook also allows you to evaluate practice parameters to better understand their financial impact. For example, you can vary the length of appointment times, the amount of time staff spend on the different components of collaborative care work and many other factors to better understand how to build or revise clinical workflows.

The Workbook has been updated in 2020, and is now available in 2 versions (see below). Practices may download any versions that are applicable for their setting. 

  • Financial Modeling Workbook
    This version is for practices that plan to bill via psychotherapy codes only, or a combination of that and BHI/CoCM billing. Changes from the previous version include clarifying language around which activities are billable by each set of codes, simplification of how work activities are allocated (by hours rather than percentages), and by making mixed billing calculations more accurate (previously time could be double-counted, which is not allowable).
  • Financial Modeling Workbook for FQHC and RHC practices
    Same as above except figuring average reimbursement for BHI/CoCM codes is done with the G codes rather than the CPT codes because the rules are different.

Register online to download the free Financial Modeling Workbook and Instructions


Once monthly 9:00am PT / 12:00pm ET (dates below):

The AIMS Center and American Psychiatric Association will use this time to answer general questions about the Modeling Workbook as well as all other billing code and financial sustainability matters.

2020 dates: May 6, June 3, July 1, August 5, September 2, October 7, November 4, & December 2. 

Zoom Meeting Details:
Join from PC, Mac, Linux, iOS or Android:
Telephone: (646) 876 9923 or (408) 638 0968
Meeting ID: 760 751 576

If you notice errors in the Workbook, please contact