Local Return on Investment Calculator
The OLC is currently updating the Return on Investment (ROI) Calculator so that libraries can enter their data and calculate their ROI for their communities and legislators. The 2025 template will include updates for the costs for books, reference, computer use, Wi-Fi use, hotspot lending and outreach. The template will also account for homework help sessions and Summer Food Service Programs in libraries.
You can start entering your data now by downloading the current ROI calculator below or wait until the 2025 version is available. This tool was created to help libraries quantify the benefits provided to their communities in a simple and understandable fashion.
Local ROI Calculator (download Excel spreadsheet)
As a reminder, there are four tabs/worksheets within the Local ROI Calculator Excel Spreadsheet:
- Instructions on how to complete the calculator;
- Actual ROI Calculator;
- Explanation of what the ROI figures mean and how to utilize them
- Notes on the pricing and cost assumptions.
NOTE: It is helpful to print the “Instructions” worksheet first and gather your information before entering the data in the worksheet.
If you have further questions, please contact Jay Smith, OLC’s Director of Government and Legal Services, at jsmith@olc.org.