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 […]
Question: I was wondering who I could contact at Margill for help on calculating a rather complex amortization table. Beginning on 6/25/17 – the principal loan amount was $640,000 at an interest rate of 3% – payments of $3,000 to begin on 1/1/2018. However, a payment of $350,000 was made on 7/12/2017 Additional loan amount […]
Question: Our company does loans and rentals. Can Margill Loan Manager be used to manage rentals (monthly rents)? Answer: As strange as this may sound for a loan servicing software, yes Margill Loan Manager can manage rentals. The difference between a loan and a rental is that loans begin with a principal amount borrowed that […]
His name was Boudreaux. He was from Cutoff, Louisiana … and he needed a loan, So…….. He walked into a bank in New York City and asked for the loan officer. He told the loan officer that he was going to Paris for an International Cajun festival for two weeks and needed to borrow $5,000, and that he was not a […]
Question: Our company collects weekly (bi-weekly or monthly – no matter) payments drawn directly from their bank accounts in some cases and in others as payroll deductions. We receive CSV files from the bank and processors. Can these transactions then be imported back to Margill Loan Manager? Answer: As you guessed, since I blogged this, […]
Question: Is there a way for me to see if users are logged on to the system? Answer: Go to Tools > Users and see this:
Question: A borrower missed a payment last month. This month he doubles up his payment to compensate. Doubling should get him back on track but I get a higher balance at the end of the loan? Help! Answer: Your borrower will be CLOSE to back on track but there was accrued interest for the month he missed […]
Question: Can I apply a payment only to principal even if there is outstanding interest? Answer: Yes when this advanced feature is activated. In the Trial version, this is not activated by default since a more advanced feature. To activate, go to Tools > Settings > User Settings > “Options: Interest-only and Fixed Principal” (blue link). […]
Q: Can Loan Manager be used to collect invoices with payments here an there? Each invoice only starts accruing interest after 30 days. We are a medium-sized law firm and send out invoices to our clients irregularly. Many of our clients do not pay within the 30 days allotted (invoices are Net 30 days otherwise the […]
Is there a limit on the number of notes that can be tracked at one time? Not really. The number of loans you can enter in the system is based on your license package. Our largest users have 30,000 loans, our smallest maybe 5? Price is based on number of loans and users. Can the […]
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, […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
Question: Hi – I’ve been giving your software a trial, and really like it. The only thing I haven’t been able to do is feed information into the ledger. For example, if a client makes a payment, how do I feed that into the program? How does it know when a payment hasn’t been made? […]
Questions: 1. In terms of the accounting report and accounting identifiers, are these captured at the borrower level, or the record level? How is this selection made and where is it used/displayed on the accounting report? 2. In our accounts we split interest accrued and other fees by product type, i.e. a separate GL account […]
Question: How to setup weekly or biweekly payments in Margill Loan Manager? Answer: When creating a new record, set up the Period of Payments at ”By day(s)” and input 7 for weekly or 14 for biweekly payments. We also suggest that you setup the Compounding Period to match the Period of Payments.
Questions: We are a secured lender, our loans are secured against properties. Does the system allow us to input details of the property and loan to value against each loan? How do I do this? Will the system give me an overview of our loan book as a whole? Some clients pay monthly, some clients we […]
Question: I have a principal of $200,000 starting 03/01/2017 (over 24 months) and the last payment to be made on March 1, 2019. First payment is on 4/1/2017 at unknown amount. Two $50,000 lump sum payments to be made on 05/01/2017 and 05/01/2018. I must also compute the payments in between the $50,000 payments. Interest […]
Question: Why are there two sets of Custom fields in Margill Loan Manager?
Question How can we obtain the loan-to-value (LTV) in Margill Loan Manager?
Question: How to set Global Initial Fees which are a) a flat $100, b) a Dealer Fee of 7% of the loan amount and c) an Admin one time initial fee of 7% of the loan amount. These fees are financed, not paid up front… How and where do I set the Initial 3 fees […]
Question: Why am I not getting the right amount of interest for a month? I’ve created a payment schedule for my client for a $250,000 loan with these dates (my date format is Day/Month/Year, so the first payment is one month after May 5).
Question: The Prime rate changed. How do we update the interest rates for multiple records at once?
Question: How to add late fees automatically?
Question: How do you enter the record to write off a loan in the MLM?
- Contact Us
Head office Canada:
75, des Chateaux Boulevard, Suite 102
Blainville, Quebec, Canada
(Greater Montreal region)
2915 Ogletown Road
Newark, Delaware, USA
- Interest-only: Regular monthly interest vs. Exact day interestApril 23, 2018 - 3:01 pm
- Texas Mortgage FinanceMarch 29, 2018 - 12:57 pm
- Margill Law/Standard Edition – Regular and Irregular payment scheduleMarch 20, 2018 - 9:09 pm
- New Margill Loan Manager client: Nevada Western Interstate Commission for Higher EducationMarch 16, 2018 - 2:31 pm