How to enter loan number, Federal Tax ID, set up automatic late fees, create a line of credit, etc.?

Questions:

In Margill Loan Manager:

1) How/where do I enter my loan #? Can I change the identifier number automatically assigned by Margill?

2) Most of my clients are businesses, and I do not see a place to enter the Federal Tax ID number. I would also like to add fields for type of company, state of formation, year of formation.

3) When posting payments, most are not made on the exact due date, so I need to right click and post the payment into the schedule, is that correct?  Also, where can I enter the type of payment and identifier, like the check number?

4) How to set up a Line of Credit account where all the payments are interest-only except the last one

5) How to automatically set up Late Fees?

Answers:

1) How/where do I enter my loan #? Can I change the identifier number automatically assigned by Margill?

A unique identifier is created automatically for each loan. You an also enter your own under Data > General:

And your loan number can show up on top of the loan window (set this up under Tools > Settings):

 

2) Most of my clients are businesses, and I do not see a place to enter the Federal Tax ID number. I would also like to add fields for type of company, state of formation, year of formation.

You can create as many custom fields as you want. You would create these for the Borrower and others for the Loan – you tie the field to the closest – Borrower or Loan (and even Creditor but you may not need these custom fields).

Tools > Settings:

 

3) When posting payments, most payments are not made on the exact due date, so I need to right click and post the payment into the schedule, is that correct?  Also, where can I enter the type of payment and identifier, like check number?

You do not need to right click. You change you Line status column from a Due Pmt to a Paid Late Pmt. This small window will then appear to enter the true payment date – in this example Borrower was supposed to pay on the 1st but paid on the 22nd. The date can also be changed directly in the Pmt Date column.

The Post payment Tool (no screenshot below) allows you to post payments in batches as opposed to one by one. They can be Paid, Unpaid, Late, Partial and you can add the check number and add fees manually if you wish (or change the automatically added fees). Very flexible…

If you did not wish to charge extra interest if the payment was only a few days late, you could have entered the true payment date in the “True Pmt Date (Grace/EFT)” column without changing the “Pmt Date.” Transaction reports would pick up this special date.

You can also add a Comment to each payment line and multiple other elements that you customize.

4) How to set up a Line of Credit account where all the payments are interest-only except the last one

You would first create a Record type called Line of credit (Tools > Settings).

You then create a Record and in the Data tab enter this information. I advanced 50,000 on 9/5/17.

 

Notice “Irregular” payments (a screen will follow allowing you to enter advances and payments if this was an existing line of credit – ignore this window if this is a new line of credit – click on:

Once the payment schedule is calculated (one line schedule at first), you simply add lines at the end depending on whether they are Advances or Payments. Here there was a second $15,000 advance and a $3,000 payment. I also added an Information line in the year 2020 to keep the interest accruing.

You can add or insert line with the right mouse click or with these icons on the far right:

 

When a payment is made, column fees and then interest are paid first, then principal. In the example above, the $3,000 payment will pay principal. You could have had Margill compute the total interest to be paid (right mouse click).

If monthly payments MUST be made by the Borrower to pay interest, then you would have set up a line of credit with Monthly payments (not Irregular) and would have specified that these pay interest. This is a more advanced feature called “Line Behavior.” Let me know if this is what you want, and I can explain this in more detail.

5) How to automatically set up Late Fees?

You can create one or multiple Automatic fees.

Go to Tools > Settings > Column Fees: Automatic. You then select the Line status and create your own rules. You can charge an amount, a percentage of the balance, a percentage of the unpaid portion, etc.

 

Long first payment deferral versus normal one period (month) deferral

Question:

When we compare a loan using a normal amortization schedule (amortization book or calculation on an online website) we do not reach the same number of payments in Margill as in the on-line calculator. Why is this?

Here is an example:

Origination Date:  July 14, 2017.
Original Principal: $ 11,374.
10% interest rate
48 months
Deferred interest and payments until Feb. 15 2018.

Normal amortization tables show payment of approx. $288.00 @ 48 months.
Margill is showing us 51 + payments @ $288.00.

Answer:

This is a most common error because of the “Deferred payment.”

Amortization tables (static) and on-line calculators cannot include deferred payments. They are usually exactly one period (often one month) after the Origination date. You could not thus get the proper payment with a 7 month deferral.

If I do a 48-month loan, with first payment exactly one month after July 14, I thus get the $288 you are looking for ($288.86 to be precise). Leave the payment blank so it is calculated.

So this is not what you are looking for since my first payment date is not properly deferred.

Let’s say we really do want 48 payments with the February date.

Because of the deferred first payment (6 months after a normal 1 month deferral) I am now at a payment of 303.81. Much higher since more interest accrued before any principal gets repaid.

From the screenshots you sent me, you want a 288.00 payment (not 288.86):

So I leave the the Amortization and Term blank and the number of payments will be computed to 52 with a last payment of $82.76.

 

Follow up question:

When I wrote “Deferred interest and payments” I meant thee is no interest from July 2017 to February 2018.

Follow-up answer:

You can simply change the Rate column to 0.00%. Balance then becomes minus $1047.44.

Then delete the extra lines (for which the balance is now negative) by highlighting them > right click with the mouse.

 We are now at 47 payments of $288.00 and the last one at $204.61 (since no interest for 7 months).

 

Intercompany Loan Management with a Loan Servicing Software

intercompany loans

Intercompany loans

Very often, when a company has many subsidiaries, branches or franchises, the head office will afford loans to these other entities. These subsidiaries in turn can lend to other entities and so forth. These intercompany loans often represent quite a challenge to the accountants and controllers since the loans are not part of the company’s core business and are most often very different from run-of-the-mill personal loans and mortgages.

The challenge of intercompany loan administration stems from multiple factors:

  • These loans are often irregular with sporadic payments that are not due at set dates as in regular loans.
  • They can also be interest-only, fixed-principal, principal-only, and of course, principal and interest (P&I).
  • They often include irregular capital advances, so are somewhat like lines of credit adding yet another level of complexity that most loans servicing platforms cannot handle.
  • Changing or variable interest rates are another challenge faced by the parent company. Often the interest rate will be x basis points above or below central bank rates or LIBOR rates (Overnight, 1 week, 3 months, etc.). Updating loans as the rates change can be a time consuming task where errors are easily made.
  • In some situations, there are multiple entities involved in the same loan: multiple creditors (participating loans) and even multiple borrowers (co-borrowers) for these loans. Each has a stake as a percentage of the total loan amount or dollar amount.
  • We have seen many examples where the borrower pays back more than the principal, so the lender actually becomes the borrower. The lender now owes the borrower. So negative interest is actually calculated. The roles can change regularly as the lender provides new capital advances and as the borrower pays back…
  • Multinational organizations often have loans in multiple currencies.

If the people responsible for setting up loans and payment schedules are not from the banking sector, the calculation method specified in the loan agreement may not have been followed or is simply guessed based on the calculation and loan servicing tools available. This in turn may not correspond to the parties’ true contractual intent.

  • Some loans in a lender’s portfolio may use one method (Simple interest) while other loans use Compound interest. Even in Compound interest, two methods are commonly seen: the Banking or Effective Rate method that uses a special formula with an exponential component; and what we term Simple Interest Capitalized where simple interest is used to calculate interest on a daily basis. And if interest is not paid at the end of the month (for monthly compounding) then the new balance (taking into account the unpaid interest portion) now generates interest. The US government often uses this method.
  • The compounding frequency (annually, semi-annually, monthly, daily, etc.) must also be factored in.
  • Finally, the Day count (so number of days to be used in the calculation – 365, leap year 366 and 360) may vary from loan to loan or may not even have been considered.

Since these lenders and borrowers are not professional lenders, the companies are often ill equipped to deal with these loans. Spreadsheets are the most common solution. Excel does a great job for a few loans but when the volume increases, the spreadsheets become practically unmanageable! Exceptions are simply ignored, interest improperly calculated, etc.

Our Loan Servicing Software, Margill Loan Manager offers a solution for all these problems with the capacity to easily:

  • Create regular payment schedules
  • Create irregular payment schedules
  • Add principal advances (additional principal to a loan)
  • Compute interest-only payments
  • Compute principal-only payments
  • Compute fixed-principal payments
  • Add automatic fees for late or missed payments (although this is less common in intercompany loans)
  • Create schedules using historical variable interest rates
  • Increase or decrease the interest rates for one or multiple loans (in batches) based on the rate type and the new interest rate (LIBOR, Base rates, etc.)
  • Include multiple entities as creditors (holding  company, bank, subsidiary) and multiple entities as borrowers, co-borrowers and guarantors
  • Create Participation loans (percentage ownership for creditors and for co-borrowers)
  • Include not only intercompany and bank loans, but also distinguish these from unrelated third-party loans
  • Allow a loan to eventually yield a negative balance with interest computed on this negative balance. The rate could even be changed or set to 0.00% when the loan becomes negative
  • Create loans in various currencies, and then convert these currencies back to a unique currency based on the desired exchange rate
  • When monthly or even daily transaction volumes become important, a very simple Excel file can be used to enter new payments or advances or to post set due payments directly to Margill
  • Electronic Funds Transfers (EFT) (ACH) directly in Margill (US and Canada)
  • Extract, in seconds, borrowing activity, P&I balances, accrued interest, paid interest, etc., for the whole loan portfolio or a part of it
  • Produce the accounting Debit and Credit report which can then be imported to the company’s General Ledger (GL) in QuickBooks and Sage. The report can also be exported to generic formats: Excel, CSV and TXT

See also our White Paper on Interest calculations: https://www.margill.com/en/interest-calculation-white-paper/

 

Margill Loan Manager

You can also try our software for 30 days for free: https://www.margill.com/en/margill-loan-manager-free-trial/

Or Schedule a demo: https://www.margill.com/en/schedule-a-demo/

How to extend a loan once the loan has reached a maturity? Term is to be extended by 48 months.

Question:

How to extend a loan once the loan has reached a maturity? Term is to be extended by 48 months.

Answer:

As you may know, Margill Loan Manager is probably the most visual software on the market so this kind of change takes a second.
In the payment schedule, simply click on the icon to the right of the window or right click with the mouse > Add > Add Many Lines.

Then specify 48 Payments and the Payment Amount. Add other specifications such as the payment frequency (monthly or other) and when the next payment (after the initial loan end date) is to be paid.

You can also go one step more by selecting your 48 lines, right click and have the payment recomputed to give 0.00 as the final balance or another residual amount.

Even the interest rate could be changed for the next 48 payments (as always with the right mouse click):

How to do erratic payments in Margill Standard/Law Edition

Question:

How to do erratic payments in Margill Standard/Law Edition

Answer:

Pretty simple. Once you entered all your loan data. Click Compute, and you will get to the payment schedule:

From there, you can change the Pmt date, the Payment amount, and the Rate.

You can even use the right click button to get many more options!

It is also possible to add or remove lines.

The totals will then be recalculated with the new schedule.

The Margill Team

Can you walk me through how I would update MLM to the latest version on the Cloud?

Question:

My Margill Loan Manager is installed on a server on the Cloud.  It wants to have me input a path and so on, and I was not comfortable starting it. It also said to back up MLM data first, and I am not sure if that is necessary for me given that we have the server back-up every night.

Answer:

When all goes smoothly, an update should take 3-4 minutes.

If not already done, download the full update (for existing clients) at www.margill.com/get. Download from the remote server, not from your personal computer. This way, the installer will already be on the Cloud, as opposed to being on your PC.

Run the Margill Installer. It will ask for the path for the software installation. The default setting will usually be the last installation path or the C: drive which is where Margill is usually installed on the Cloud.

The Data (so where the database resides), when installed on C:\Program Files (x86) will usually be under C:\Program Data\MLM_Data.

If it is not there (as it usually should be), then an error will appear, and you will have to find the proper Data path. Search for the “DB” folder using the Windows search tool. Depending on who did the installation, data could be anywhere, so let’s hope the person who installed did a good, clean job!

ALWAYS do a backup. Everything should go smoothly with the update, but never take the chance; do a backup.

You will need basic knowledge of Windows to do this unless your paths are all properly configured.

Can Margill Loan Manager do progressive Advances to my clients?

Question:

Can Margill Loan Manager do progressive Advances to my clients?

For example, my borrower was authorized for a $100,000 loan but this will be disbursed in stages. So 15,000 one day, 10,000 another and so forth…

Answer:

Short answer… very easily…

You first create a new Record. In this case the first advance of 15k is on 06/06/2017 with regular payments on the first of each month starting July 1. To be repaid over 5 years (60 months).

You can Compute and the following preliminary schedule is created. If we were to leave it at that, we would have 60 payments of $305.59.

For information purposes, let’s enter that the loan is for a maximum of 100,000 (General tab):

Now for the next draws. Do you know when they are to be paid of not? If so, you can enter them on the set Advance dates as Additional Principal (Loan). Notice below there are 2 more Advances, the first for 10k and the second for 25k. We include these as negative amounts to increase the Balance.

I also used the right mouse click to recompute the payments to get 0.00 as my ending balance after 60 months.

So the new payments become 1099.54. You could recompute the payments to give 0.00 at any time or stretch out the loan (add more payment months). As you wish….

If you do not know when the money is to be advanced to your borrower, then you enter the Additional Principal as the information comes in and your recompute your payments (increase them) as more principal is advanced.

New Margill Loan Manager client: Strada Education Network

We would like to welcome Strada Education Network as a new user of our Loan Servicing Software, Margill Loan Manager.

Strada is a non-profit organization that works to help students through their education path. They offer many different types of solutions to improve student outcomes in higher education and facilitate successful career transitions.

More information on Strada Education Network website.

For more testimonials, please visit: Client Testimonials

The Margill Team.

Margill Loan Manager version 4.3 now available for download

Testing and tweaking is now a thing of the past. Version 4.3 of Margill Loan Manager is now available to download in our Download Center

To see the full list of new features, please visit our Release Notes.

We are already working on Version 4.4, which should be released in late October 2017.

The Margill Team.

Margill Loan Manager – Principal and Interest forecast

Question: 

I need to break down the due payment for the next fiscal into Due payment interest portion total and Due payment principal portion.

Answer:

If you are on version 4.3 and above (go to https://www.margill.com/get to download) go to Reports > Personalized Reports > Record List (Customized) with Period Breaks.

1) Report template

Click on New, name your report and select the fields from the left.

In the example below I selected the Borrower Business and Loan ID to identify each loan.

Then I selected, under the “Interest” theme, the “Interest Accrued (for period)”. We call it “Accrued” but in fact, for projections it is TO BE accrued. I will rename my column header to “Interest – Forecast” (see below).

Finally, select, under the “Principal’ theme “Principal Accrued (including any transaction on the report Start Date)(for period)” – renamed to “Principal – Forecast”.

Report template is now complete.

2) Actual report

First select the desired Records from the Main window and go to Reports > Personalized Reports > Record List (Customized) with Period Breaks.

This report will break down the principal and interest by month, quarter or year. So you can do short and long term projections – short term for 12 months broken down by month and short/medium/ long term over 5 years.

Now run the report which may take  few minutes (thousands of calculations are done!). You then get results that can be shown in a variety of ways (horizontal, vertical and summaries). You can even show Totals.

Summary view below: