In the ever-evolving landscape of lending, a transformation has taken place. Lenders have transitioned from traditional approaches to embrace rule-based lending systems, or more specifically, parameterized lending. This shift signifies structured credit policies with well-defined norms and criteria, a paradigm shift from the conventional methods. However, every innovation comes with its set of challenges, and this transition was no exception.

Challenges Faced

Limited Incentive for Borrowers

Lending is a two-way street, and in the past, borrowers often found little incentive when presented with a lender’s expression of interest. The system needed a breath of fresh air to make this journey more enticing for borrowers.

Better Price Discovery and Comparison

Another hurdle was the lack of efficient tools for price discovery and comparison across multiple lenders. Borrowers lacked the means to make informed choices, and lenders needed a solution to address this market inefficiency.

Quality Over Quantity

Borrower eligibility is a critical factor for lenders. However, ensuring visibility into a borrower’s eligibility proved challenging. Many lenders were caught up in a quantity-focused approach, whereas the need of the hour was to shift their focus towards quality. Different lenders can focus on different criteria of a borrower for eligibility.

Fast-Tracking Eligible Applications

Efficiency was the call of the day. The lending process needed acceleration, particularly for eligible applications. With numerous applicants in the queue, it was crucial to fast-track the deserving ones to make the most of this transition. This process of calculating the eligibility is done manually and takes around 3-5 mins for each calculation.

Yubi’s Innovation: Eligibility Calculator

To overcome these challenges, Yubi introduced the ‘Eligibility Calculator.’ This revolutionary tool calculates the loan amount and other attributes a borrower is eligible for based on their financials, bridging the gap between traditional lending norms and modern borrower expectations. Lenders can define their personalized criteria, configuring the tool to assess borrower eligibility according to their specific parameters and formulas.

Impact and Automation

Previously manual, these calculations consumed extensive human hours. Transformed into an automated system, this shift from minutes to seconds has notably reduced efforts and errors, expediting lending processes and freeing lenders for strategic enhancements.

End-to-End Automation Potential

Beyond fast-tracking sanctions, the Calculator enables full lending process automation, significantly reducing the time from loan discovery to sanction and enhancing overall efficiency.

Scalability and Integration

This innovation’s scalability permits seamless integration across multiple financial entities, ensuring adaptability to diverse lending products and dynamic landscape demands.

Expanding Customer Reach

The Calculator acts as a gateway to a broader customer base, offering an efficient lending experience while providing lenders insights into new customer segments.

Customization and Data Points

With over 100 data points for borrower eligibility, the Calculator offers robust customization, ensuring precise configuration aligned with each bank’s unique requirements.


Building a new service is one thing; doing it efficiently, at scale, and catering to diverse product requirements is quite another. The prerequisites were clear:

  1.  Accuracy and Speed

The service needed to be not just accurate but fast in performing complex calculations. Borrower eligibility doesn’t wait; it’s needed in real-time.

2. User-Friendly UI with Excel Templates

The ability to render an Excel template in the UI was non-negotiable. Users needed a familiar interface to work with, and Excel was the industry standard.

Building Blocks

Yubi opted for a combination of robust technologies to create the Eligibility Calculator:

Java – The Backend Powerhouse

Java, known for its robustness and speed, became the primary choice for building the backend.

Syncfusion Library – Excel in the UI

After extensive research, Syncfusion emerged as the ideal tool for rendering Excel components in the user interface. It not only facilitated importing and exporting Excel files but also accommodated custom Excel formulas, a necessity for complex calculations.

MS Graph APIs – Powering the Engine

To ensure precision in calculations, Yubi turned to Microsoft’s Graph APIs. These APIs leverage the same MS Office Engine available on the cloud, guaranteeing highly accurate results. However, Yubi encountered certain challenges:

  • Frequent API calls increased the time taken for results.
  • Only one calculation could be performed at a time on a single Excel file.
  • Dependency on a third-party service raised concerns about unforeseen errors and downtimes.

Apache POI – The Fail-Safe

To address all these challenges, Yubi also integrated Apache POI, an open-source library for Java. This library not only delivered high-speed, in-memory Excel file operations but also supported numerous Excel formulas, making it a reliable fallback option.


Yubi embraced a dual approach to exploit the strengths of both technologies:

MS Graph Implementation

MS Graph APIs, though highly precise, presented certain challenges. Yubi implemented a Redis Cache to streamline the token refresh process and improve efficiency. They ensured that borrower data remained non-persistent in the MS OneDrive, preserving data privacy. However, limitations such as the time needed for multiple API calls and the inability to perform simultaneous operations on a single Excel file raised concerns.

Apache POI Implementation

Apache POI provided a robust alternative. It processed entire Excel files efficiently and supported a wide range of calculations. If any issues arose with MS Graph APIs, Apache POI was ready to take over. Moreover, being a Java library, it could be seamlessly implemented on on-premise servers, a crucial feature for banks and financial institutions with specific requirements.  It can handle multiple calculations for a single file and provides users the option to download their financial insights, enhancing the overall experience.

So, while MS Graph APIs handle the main workload, Apache POI takes care of the multitasking and downloading aspects, creating a comprehensive solution.

Apache POI
MS Graph APIs
High-speed, in-memory Excel operations
Leverages MS Office Engine for precise results
Supports various Excel formulas
Cloud-based, facilitating accessibility
Reliable fallback option
Ensures data privacy through cloud operations
Suitable for on-premise server implementation
Integrates with MS OneDrive for file operations
Limited simultaneous operations on a single file
Multiple API calls can increase processing time
Doesn't provide real-time cloud-based operations
Limited simultaneous operations on Excel files
Dependency on Java, requires server-side execution
Dependency on third-party service
Less precise compared to MS Graph APIs
Potential unforeseen errors or downtimes


Yubi’s Eligibility Calculator is a testament to the synergy of speed and accuracy. It adapts to various requirements, allowing users to choose between MS Graph APIs and Apache POI. Whether it’s accuracy for one product or speed for another, Yubi ensures that the Eligibility Calculator aligns with each lender’s unique needs with 100+ data points of a borrower. From request-level flexibility to product-level customization and infrastructure-level adaptability, Yubi has left no stone unturned in creating a versatile tool that enhances lending efficiency.

In this blog, we’ve delved into the intricacies of Yubi’s Eligibility Calculator, uncovering the technology stack that powers this innovation, reducing the time from minutes of manual efforts to automated seconds. With a commitment to both speed and accuracy, Yubi is driving the lending industry forward, one calculation at a time.