Q: On a $1000 loan at 20% interest, why is my interest not $200 for one year? A: This is a common question that we often get and some information is missing to answer the question so we’ll analyse this, taking into account various scenarios and how to manage this in Margill Loan Manager. There is […]
Question: I am often faced with paying late alimony, and I want to be sure that the interest calculations they are hitting me with are correct. I pay 4% simple interest only on late or fractional payments. I am testing your software right now, and if I am say $500 short but pay it within […]
Question: How can I mass import “Unpaid” payments with an Excel sheet in Margill Loan Manager? I need to obtain the Outstanding payment amount too. Answer: Usually, when payments are NOT made (so were skipped or the payments returned for non sufficient funds (NSF), on a historical basis, these would simply be ignored and only […]
Q: Is Margill Interest calculator or Margill Law calculator able to create a compound interest calculation with irregular payments and interest rates that change over time? So is my understanding correct that your software will be able to work out the balance owing in terms of an overdue loan with compounded interest based on the following […]
Q: In the Loan Manager, is it possible to change a payment date for all loans at the same time? For example, I want to change the date from March 26 to March 27? A: This can be done in batch but each date will have to be modified. You can do this for “Due […]
Question: I would like to convert 7500 of accrued interest to principal. Can this be done in Margill Loan Manager? Answer: Certainly with special Line statuses. First, go to Tools > Settings: Make sure “Interest paid” is available (not checked to Hide from menu) as well as an “Add. Principal X” Line status. We will […]
Q: My law firm must calculate the interest from June 30, 2019 to May 28, 2020 on an amount due by an insurance company. I must be able to see the interest that accrues every day. Interest rate is 4% annually and amount is 150,250.33. A: In Margill Law Edition, you would usually use the […]
Federal, state and provincial governments, townships, cities and towns all over the world have created very generous loan programs to help businesses as they struggle with the global pandemic and the effect of confinement. These loans can take many shapes and finding the right software to properly create and manage these is not always easy. […]
I love spreadsheets, they are absolutely amazing for doing so many things. They are hugely flexible, powerful and allow you do to just about anything (almost). However, as we all know, they are also very dangerous because of human error! I recently implemented Margill Loan Manager with a new client who had been using spreadsheets […]
Q: How can I provide my borrowers a temporary payment and interest break in Margill Loan Manager? A: With normal loans, those with regular payments, at regular intervals, and no regular fees or taxes (the case with leases), this can easily be done in Margill and in bulk. So you need not do this individually, […]