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 these 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 on 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 […]
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 we have the […]
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 trialing your software 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? and if […]
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, setup 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?