{"id":11196,"date":"2020-01-30T21:11:12","date_gmt":"2020-01-30T21:11:12","guid":{"rendered":"https:\/\/margill.com\/?p=11196"},"modified":"2025-10-10T09:36:30","modified_gmt":"2025-10-10T13:36:30","slug":"calculating-interest-distribution-to-investors-in-complex-participation-loans-pools-funds","status":"publish","type":"post","link":"https:\/\/margill.com\/en\/calculating-interest-distribution-to-investors-in-complex-participation-loans-pools-funds\/","title":{"rendered":"Calculating Interest Distribution to Investors in Complex Participation\/Syndicated Loans, Pools or Funds"},"content":{"rendered":"

Maximizing Investor Returns \/ Reducing Risk through Participation\/Syndicated Loans<\/h3>\n

Investors are constantly looking for new ways to maximize their returns. Investing in higher risk private loans is a method to generate 10 to 20% + annual returns. Of course, one of the objectives is to reduce risk and this can be achieved when multiple investors participate in a loan.<\/p>\n

In higher-value commercial loans,\u00a0bridge loans, loans for entrepreneurs (for starting or expanding a business) and short-term tax credit loans, many investors can participate or pool their investments to finance larger projects. Funds based on industry or loan product or investor pools are often created to reduce the risk of each investor while offering maximum flexibility.<\/p>\n

Some loan funds and loan pools allow the investor to invest into or divest from a fund\/pool\/loan before the loan comes to maturity. An investor can decide for example to invest<\/em> in a loan when the real-estate project reaches a specific milestone or divest when he\/she feels there is a better opportunity elsewhere (usually divest to another fund within the same finance company as opposed to a complete withdrawal).<\/p>\n

Again, to minimize risk and reduce cost to the borrower, in some loans, notably, construction loans, principal is extended progressively to the borrower only as required and contingent on achieving project milestones. These new principal advances are financed by existing or new investors that can join a loan or fund.\u00a0This obviously adds to the complexity of calculating the distribution of income to investors.<\/p>\n

Revenue models for the investor vary greatly: some Fund Administrators will pay the investor no matter if the borrower pays or does not pay the accrued interest every month (revenue based on accrued interest) and others will only pay the revenue portion to the investors if the borrower pays at least the accrued interest (revenue based on cash received). Whether based on accrued interest or cash paid, the revenue must be\u00a0redistributed to each investor on a pro-rated basis of his investment amount and participation time (number of days or months of participation).<\/p>\n

The Impossible Job of Interest Distribution to Investors<\/h3>\n

With this flexibility though, comes a major headache for Fund Administrators who must manage the revenue (interest revenue) for each investor based on the amount invested and on the time period this investor was involved in the loan.<\/p>\n

Not many software tools can deal with such complexity, and although spreadsheets can be created to solve part of the problem, the time required to compute accrued or paid interest and investor distribution can take days, not to mention the great chance of error.<\/p>\n

Calculating the interest in participation or syndicated loans is one piece of the equation, preparing statements is the next phase, a long and arduous process without the proper tools.<\/p>\n

Investor management software to the rescue!<\/strong><\/h3>\n

Yes there are solutions out there!\u00a0Margill Loan Manager<\/strong><\/a>, a world-class software product, sold in over 40 countries, offers a highly sophisticated Investor module specifically created to manage irregular investments, divestments, payments and of course calculate revenue distribution by investor.<\/p>\n

Let’s do a example and throw in a few curve balls…<\/strong><\/p>\n

Borrower ABC Inc. is given a credit facility of 1,250,000 (could be $, \u00a3, \u20ac, no matter) at a rate of 12% annually for 12 months. Investors in the participation\/syndicated loan receive this return too.<\/p>\n