News
Margill wins the MercadOr Export Award
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, […]
Early payoff – How to do this in Margill Loan Manager
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 […]
Welcome to our new clients!
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
The Sun Shines for Lenders – Solar Power in the Court of Appeal
Summary: Canada Interest Act. This decision from the Ontario Court of Appeal shows the importance for lenders to state in their loan and promissory note documents, interest rates and even penalties on a annual basis, as opposed to daily or other equivalent interest rate. Find out more here
Loan Servicing with Excel? Pitfalls and alternatives
Loan Servicing with Excel? Pitfalls and Alternatives I’m a great fan of Excel. I think it is the most important and useful software ever developed. I first started using spreadsheets many years ago with Lotus 123 which was a great tool that lost the spreadsheet war to Microsoft. Excel can be used in so many […]
Welcome to our new clients
The Margill Team would like to welcome new users of Margill Loan Manager: The Government of the Turks & Caicos Islands May Coalition Prairieland FS Harvest Royal American Management Ethos Group Nation Hurone – Wendat Stanislaus Farm Supply
Margill Loan Manager: Is there an audit trail that can be printed to show transactions / changes to records on a daily basis?
Q: Is there an audit trail that can be printed to show transactions / changes to records on a daily basis? A: Yes very easily. Go to the Main Margill window, select all the loans (probably only Active loans) , Tools > Various > Display the history of changes for selected Records. You can then […]
How to obtain the daily interest amount (per diem) in Margill Loan Manager
Q: How to obtain the daily interest amount (per diem) in Margill Loan Manager? A: This can be added very easily through a simple Mathematical Equation. Go to Reports > Equation Management and click on Name the Equation Select the two required fields (balance and interest rate) from the various themes on the left Add […]
Interest-only: Regular monthly interest vs. Exact day interest
Question: My company does interest-only 12 month bridge loans calculated in two ways. Payments are based on the number of days in a month with a balloon payment at the end (so payments change depending on the month) Each of the 12 payments is equal with a balloon payment at the end. Can these two […]