In Mutual Funds, investments are done by Fund Managers. Their job is to invest the retail investors’ money in different securities and increase the value of the fund while maintaining the objective of the mutual fund schemes.
When a mutual fund scheme is launched (known as New Fund Offer [NFO]), it provides a document, called Offer Document (OD), it contains the profile of the fund and limits on various investments.
These objectives not only help the investors to choose the fund which aligns with their goals and risk profile but also for fund managers to keep their investment harmonized with the decided profile.
The above restrictions/limits must be maintained by the Fund Manager; they are called OD Limits.
The other restrictions are imposed by SEBI, to avoid any large concentration of a security/industry/company in the fund, and hence, any major risk. These are known as Regulatory Limits.
Internal Limits are similar to regulatory but are setup by the AMC for their internal use or as an alert system for the regulatory limits.
The last kind of limit is called Credit Limit. MF’s Analyst studies the companies’ profile and based on their ratings [Given by Credit Rating Agencies] they assign an investment limit based on the time-period. Higher the time-period, lower will be the investment limit because risk increase with time. SheetKraft maintains a separate module for Credit Limit.
These limits are managed by the Risk Management Department in an AMC. It is usually managed in two ways, manually in excel or some external automation platform.
Let us see the issues faced in the above two scenarios:
SheetKraft, a rapid application platform for all kind and nature of calculations and logics, was used to solve the above problems and to create a stand-alone application for all Passive Breach purposes, from uploading data to generating reports.
The above flowchart is for an AMC having 150+ Mutual Funds and 150+ Limits.
Let us go through an actual limit imposed by SEBI onto the mutual funds.
12.4.1 Mutual Funds/AMCs shall ensure that total exposure of debt schemes of mutual funds in a particular sector (excluding investments in Bank CDs, CBLO, G-Secs, TBills, short term deposits of Scheduled Commercial Banks and AAA rated securities issued by Public Financial Institutions and Public Sector Banks) shall not exceed 25% of the net assets of the scheme.
Provided that an additional exposure to financial services sector (over and above the limit of 25%) not exceeding 15% of the net assets of the scheme shall be allowed only by way of increase in exposure to Housing Finance Companies (HFCs).
Provided further that the additional exposure to such securities issued by HFCs are rated AA and above and these HFCs are registered with National Housing Bank (NHB) and the total investment/ exposure in HFCs shall not exceed 25% of the net assets of the scheme.
The above draft from the SEBI circular can be divided in 4 simple parts:
The below filter is for the first limit, Investment in debt scheme and non-financial services should be less than 25%.
Using the above filter, we will get the SUM(Market Value) [Variable 1] and divide that with the AUM [Variable 2] at Scheme and Sector level. And this ratio [Aggregate Variable] should be less than 25% [Parameter Value] according to the limit.
Similarly, other 150+ limits are structured and stored in different database tables. The calculation is done for each limit over the standardized portfolio data and reports are generated.
The two-step process has substituted the earlier rigid system. The flexibility to add multiple and nested logic has helped to incorporate all the limits including the ones that were maintained separately on excel and were prone to error.
One of the clients have currently used SheetKraft’s PBR module to run the backdated calculation starting from 2018 to 2020 for audit check.
Elimination of all the manual errors with automation and with multiple validation checks, sanity check of all the different masters is possible and can be rectified in case of any error.
In short, SheetKraft’ stand-alone application for PBR has provided a simpler tool at the hand of the client and have pushed the time-consuming processes onto the server.