Can we email an amortization report to each borrower when interest rates change?

/in /by

Margill Loan Manager – Can we email an amortization report to each borrower when interest rates change?

Yes this can be done.

First, I guess you updated the interest rates though the Main window with Ctrl Alt Shift i. Ideally you have a custom field that identifies the loans that are tied to the specific index (Prime, LIBOR, etc.). With this field you can easily select the proper loans to 1) change the interest rates quickly and 2) send the amortization schedule by email.

You could have the scroll menu with “Prime” or to be more precise “Prime +”

To create the statement to send out, go to Reports > Mail/Email Template > New and create a DocX that offers many more options than the older RTF.

You can then structure the template and enter your logo and add the Merge codes to identify the Borrower, etc. You could also create your statement in Word and copy it here afterwards.

Here is what this could look like (the |105| for example, are Merge fields)…

The merge codes to enter the amortization schedule per se are under the General theme. You can try each to see which is best for you. There are 10 templates and we can program others to meet you exact needs (columns included, titles, etc.).

 

Now that your template is created, test to see if all is good (numbers, names, etc.).

Go to Reports > Document Merge.

You will need to select a date range or show the entire schedule (past, present and future payments). I would opt for a date range to see up to the rate change, not the future.

See the circled red settings below. |991| will be the schedule…

Then press on “Save – Print -Send by Email”.

Here are the options:

You can also add an email  Subject and Message when sending the email.

Email sending must be configured in Tools > Settings > Email Connection. Your IT person will usually set this up properly for each Margill user.

The selected Records will all be sent out by email in a batch. Each takes about 10 seconds to create and send out.

Replacing LIBOR – Are you Thinking About This $200 Trillion Dollar Problem With Your Contracts?

/in /by

Darren Gold, VP at UnitedLex Corp., wrote an interesting article about the London Interbank Offer Rate (LIBOR) which is used all over the world as the reference for a great number of loan contracts.  The UK’s Financial Conduct Authority recently declared that it would no longer require banks to submit the data that enabled LIBOR to be calculated after the beginning of 2021.

Although there will be alternatives such as Secured Overnight Financing Rate (SOFR) in the USA and Sterling Overnight Index Average (SONIA) in the UK, this change does come with significant uncertainty and we must wonder what this will mean for current contracts and how they will be dealt with in the future.

Replacing LIBOR – Are you Thinking About This $200 Trillion Dollar Problem With Your Contracts?

Margill Webinar

/in /by

The Margill Team is proud to formally announce the release of Margill Loan Manager 4.4. It is a really impressive version with a host of new features.

Here are the six most important improvements:

  1. Blocking historical transactions
  2. Alerts: Use templates with merged data to send automatic emails and Mail to SMS to borrowers (example: upcoming payment alert and bounced payment alert)
  3. Great enhancement of the Document Merge tool to create contract templates, invoices and statements
  4. New Line Statuses: Interest Charged and Interest Paid
  5. Compulsory fields
  6. Pre-Authorized Payments (Perceptech-Acceo): Direct Management of Rejected Payments and Addition of Automatic Fees

A Webinar will be held Wednesday, December 19 at 11:00 AM Eastern time (North America).  You can join by following this link :  Margill Webinar

If you cannot attend or have missed it, you can still follow the same link and watch it.

See you there!

Margill Solutions – Top 10 Retail Banking Solution Providers of 2018 in Banking CIO Outlook

/in /by

The Margill team is proud to be one of the Top 10 Retail Banking Solution Providers of 2018 in Banking CIO Outlook magazine.

To help CIOs, CFOs, and CEOs find the right solutions for their retail banking initiatives, a distinguished panel comprising CEOs, CFOs, analysts, and Banking CIO Outlook’s editorial board has selected the top players of this select group.

Click here to access web site

You will also find, on page 28, an article about the company and its software.

Click here to access article

Source: Banking CIO Outlook, November 21, 2018 issue.

Predatory Lending Practices: How “Confession of judgment” documents turned New York’s court system into a debt-collection machine…

/in /by

How an obscure legal document called a “Confession of judgment” turned New York’s court system into a debt-collection machine that’s chewing up small businesses across America.

Source: Bloomberg, November 20, 2018
Story by Zachary R. Mider and Zeke Faux

Although not allowed in most states, a “confession of judgment” signed by the borrower allows a creditor, without proof, to accuse a borrower of not paying the expected monthly payment for example and then to legally seize their assets.

Read the full article at : www.bloomberg.com/graphics/2018-confessions-of-judgment

Margill wins the MercadOr Export Award

/in /by

Every year since 1999, the MercadOr award is presented to exporting companies in every region of the province of Quebec.  Six companies were awarded a MercadOr for the region of the Laurentians last October 11th (See article in French here). Among them, our company Jurismedia / Margill software was one of the finalists.  Marc Gélinas, president, accepted the award that highlights Margill’s international influence through digital strategies and also for its contribution to the economic development of the Laurentians.

On November 7th, 2018, the first provincial gala, named “Gala MercadOr Québec“, will be held.  Jurismedia / Margill is nominated for the award in the same category but at the provincial level.

We would like to take this opportunity to than Laurentides International for this recognition and also our loyal customers and collaborators, without whom, this would not have been possible.  This award is a result of the collective work of the whole Jurismedia / Margill team and we are very proud of it!

Jurismedia / Margill team

Early payoff – How to do this in Margill Loan Manager

/in /by

Q: How to do an early payoff in Margill Loan Manager

A: For example, the loan term was originally for 5 years or 60 months (so end date was in June 2020). The borrower calls you, the creditor, and wishes to payoff his/her loan early, on October 12, 2018.

Original payment schedule:

 

I first recommend to take a snapshot of the full 60 month payment schedule – this was we have an easy to consult original payment schedule. Click on “Attach”. A PDF will be attached to the Record.

Next change the date to October 12, change the payment to 0.00 so the payoff balance is now shown (64,297.75 in this case). Notice I also changed the 2018-11-01 payment date to 2018-10-13 to see my daily interest on the balance (4.92 per day).

Change the Payment to 64,297.75 (for Oct 12).

You can then delete the next lines that are no longer required (right mouse click).

You could also decide to add extra fees for an early payoff if the contract included this (use Column fees or Line status fees). This will increase the balance of course.

Also, you could create a special payment-type Line status to identify all your early payoffs. Could be interesting for your reports.

If the final payment is late, nothing stops you from changing this final date to enter the true payment date. Extra interest will accrue.

Welcome to our new clients!

/in /by

The Margill Team is proud to announce the addition of 2 new customers, one in the US and one in UK.  Please take a minute to visit their websites.

and