Login     Register

        Contact Us     Search

National Cooperative Bank

National Cooperative Bank needed an easy solution to scale up generating loan amortization schedules without totally changing their models – XLeratorDB was the answer

National Cooperative Bank

National Cooperative Bank (NCB, https://www.ncb.coop) is a unique bank that addresses the financial needs of cooperatives and socially responsible organizations nationwide especially in low-income communities. To better facilitate the loan pricing analysis, NCB needed a way to do a loan-by-loan analysis of their loan portfolio, which at the end of 2015 was $1.6B. This process would have been impossible to achieve using spreadsheets. They needed to take the models that they had built in Excel and convert them to run in SQL Server helping them to satisfy their reporting requirements and eliminating the spreadsheet risk.

As Tao Yang, Data Analytics Manager, VP for NCB described it: his group was comfortable with the loan schedule generation process using the financial functions in Excel, but they needed a way to support huge increases in data volume (including many years of historical cash flow data) that Excel couldn’t manage. NCB already had powerful Microsoft SQL Server database servers and Tao wanted a way to use those with the familiar financial functions like XIRR, PMT and IPMT.

Tao did some quick online searches and found XLeratorDB from Westclintech. XLeratorDB provides in-database analytics for SQL Server and includes all the familiar financial functions from Excel that Tao and his team are comfortable with. Tao asked NCB’s IT team for help and they downloaded, installed, and did some quick tests. Because the XLeratorDB functions work just like the equivalent Excel functions Tao’s group was able to get started right away. Tao’s group then did more in-depth testing of their existing models to confirm the results from Excel matched those generated in SQL Server using the XLeratorDB financial functions: the results matched perfectly!

Once NCB had confirmed the testing results, they quickly modified their process to use SQL Server instead of Excel. They also realized that in moving out of the spreadsheet environment that there was an opportunity to improve some of the processes so he approached the Westclintech team about making the necessary changes. Tao was impressed about how professionally Westclintech managed the changes which they delivered in less than a month.

With the final changes in place, NCB was ready to start using XLeratorDB in production soon after. Tao said that since XLeratorDB has all the familiar Excel financial functions natively in SQL Server it was a very easy transition: “XLeratorDB was easy to adopt.” Additionally, NCB was very happy with XLeratorDB since it was reasonably priced for the functions it provided. As Tao said, “it was a very reasonable solution.”

Faced with the challenges of scaling up their business to meet changing regulatory and business requirements, NCB was very happy with the XLeratorDB solution. NCB got the best of both worlds: they could continue to use the financial functions and models they were comfortable with and they could harness the power of SQL Server to crunch large volumes of data quickly. XLeratorDB and the team at Westclintech provided an easy to implement and reasonably priced solution. This enabled the NCB business to help its client cooperatives and the communities they serve.

  • Download Case Study as PDF: [ NCBCaseStudy] (.pdf, 212.1 KB)

Featured Client List

XLeratorDB has rapidly built a broad global customer base spanning more than 40 countries and 30 US states, including innovation leaders such as:

Financial Services



3Point Asset Management
Access Capital Advisors
Alchemy Capital Management Pvt. Ltd.
AlixPartners LLP
Ally Bank
Alphametric Research, LLC
AEW Capital Management
Alpha Card Services
AMBIT Capital Pvt. Ltd.
American Capital
AnaCap Financial Partners LLP
Annaly Capital Management
Apollo Global Management
AutoCont SK
Avenue Capital
Axis Bank
Babson Capital Management LLC
Bain Capital
Bankers Healthcare Group, Inc.
Barclays Securities India Pvt. Ltd.
BBR Partners
Bessemer Ventures
Birla Sun Life Asset Management
Black Diamond Capital Management
California Republic Bank
Centerbridge Partners LP
Citigroup (IND)
Cliffwater LLC
Convergence Investment Partners
Crews & Associates, Inc.
DBI Capital Market Services Ltd
Desjardins (CAN)
Eastwood Bank
EBS Asset Management
Ellington Management
Emirates Investment Bank
Enam Securities
Entente Fund Accounting Services
Eton Advisors, LP
Fir Tree
First Gulf Bank
Fred Alger
Fusion Ventures  (case study)
GEPL Capital Pvt. Ltd.
Gimv (BEL)
Golden Tree Asset Management LP
Goldman Sachs Securities India Pvt Ltd.
Hamilton Lane
Harbourvest Partners, LLC
Harvest Investments
Henderson Global Investors
Henninger Investments
Highland Capital
HighVista Strategies LLC
Horizon Credit Union
Hudson Advisors
Hyuandai Securities
IndexUniverse, LLC
Infoweaver Services AB
ING Vysya bank
Jasper Ridge Partners
Javlin Capital
JM Financial Pvt. Ltd.
Karma Capital Advisor Pvt. Ltd.
Keytrade Bank
Killik & Co
Kotak Mahindra Bank Ltd.
L&T Capital Company Ltd.
Landmark Dividend LLC
Landsdowne Partners
Liberties Investments Limited
LPL Financial
Mariner Investment Group
M. B. Commercial Company Limited
Mid Atlantic Capital Group
MidAtlantic Trust
Moneta Group
Morgan Stanley
Morgan Stanley (I) Financial Services
Neue Aargauer Bank
Nilta Corp
Nordea Investment Funds S.A.
North American Savings Bank
Notz & Stucki (CHE)
Prescott Securities
Prime Broking Company Ltd.(IND)
Principal PNB Asset Management
Principal Retirement Advisor Pvt.Ltd
Professional Capital Services
Profidebopt, s.r.o.
PT Otto Multiartha
MTAG Services LLC
Oak Hill Investments
Oaktree Capital
Prescott Securities (AUS)
Qatar Development Bank
RDV Corp
Republic Mortgage Home Loans
Samuel E Ramirez & Co.
Santandar (BEL)
Santandar Consumer Finance Benelux B.V.
SAR Capital Pvt. Ltd.
Sarasin-Alpen (India) Private Limited
Saunderson House Ltd
Savant Capital
The Sentient Group (AUS)  (case study)
Sequoia Heritage
Sontag Advisory
Sprism Investment Services Pvt. Ltd.
Standard Chartered (IND)
Sunrise Capital Partners
Taom Capial UK Ltd.
Titan Advisors
TPG Credit Management, LP
T. Rowe Price Associates, Inc.
Trustline Holdings
Tufton Oceanic
Turner Acceptance Corp
United Acceptance
Value Prolific Investment and Consulting
Vericrest Financial Inc
Von Braun&Schreiber (DEU)
Watts and Associates
Wedbush Securites
Westdale Capital
Central Bank of Iceland
City of Toronto (CAN)
DBC Onderhoud (NLD)
Lee County Schools
NSW Cancer Institute (AUS)
PSP Investments (CAN)
Reserve Bank of Fiji
State Teachers Retirement System - Ohio
SPAWAR System Center Atlantic
US Department of the Interior
US Navy


Advisory Board Company
Aegis London (GBR)
Aeolus Re (BMU)
Alterra Capital Services
Arch Reinsurance Ltd.
Capital & Coast District Health Board
Cathedral Underwriting Ltd
Child Health Corporation of America
Dr.Foster Intelligence
Goss Re
Oil Insurance Ltd (BMU)
Oil Management Services
Starr Companies
XL Group
XL Insurance


Consolidatd Edison
SPARQ Solutions Pty Ltd (AUS)
Unit Corporation

Real Estate

CapMan Oyj (FIN)
Helios AMC
iStar Financial  (case study)
Landmark Partners
London & Quadrant (GBR)
Newland Communities  (case study)
Northstar Realty Finance Corp
Townsend Group
Alpha Kinetic (GBR)
Autocont SK
Bits Software
Cadis EDM (GBR)
Derive Technologoes
Enerpact LLC
EvalSolutions  (case study)
Farsight Consultancy Services
Ferman Automotive Management Services
Hewlett Packard India Sales Pvt. Ltd.
Ingram Micro
Milessoft (IND)
Netage Solutions
Pangea3 Legal Database Systems Pvt. Ltd.
Paylink Payment Plans
Portfolio Pathway
PSD Solutions
Rehfeld Partners A/S
Software Guru
Sterknetwerk BV (NLD)
Supply Chain Strategy Services
Tata Consultancy (IND)
Venture Allies
Verde International  (case study)
Via Binary


BlueSun Inc.
CreditMax Auto Group
Firebrand Technologies
HarperCollins Publishers
Houghton Mifflin Harcourt
The High Companies
Kemper Valve & Fittings Corp
LeahMaya Limited
right stuff detailing
West Pak Avocado
West Valley Construction

Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service