Margill Law/Standard Edition – Regular and Irregular payment schedule

/in /by

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 of $500,000 was made on 9/25/2017
  • Additional loan amount of $150,000 was made on 12/8/2017

Answer:

Actually quite simple:

Go to “Recurring Payments” calculation. We will suppose this is compound interest, compounded monthly and monthly payments since it is a loan.

Let’s suppose 20 payments of $3000 each (if payments are missing or if there are too many, you can add or delete after).

Enter the data below:

Then Compute or F5.

This is our preliminary schedule:

 

You can now edit the schedule by adding the lump sum payment and extra principal.

The payment and extra principal were made in 2017 so I should add three lines above my payment date of 2018-01-01

I can do this with this icon or the right mouse click:

Then change the dates – start with Line 3 since you must follow the chronological order:

And finally change the amounts (1 payment and 2 loans). Notice lines 2 and 3 are negative since we are adding principal.

Now of course, with a balance of 934,064.93 after 20 payments, we would need to add a bunch of payments to fully pay back. You could add these lines with this icon (we would need to add hundreds of payment since payments are quite low):

My guess is you are looking for a balance at a specific date (let’s say today, start of day). Insert a line with a 0.00 payment:

And there you have it.

New Margill Loan Manager client: Nevada Western Interstate Commission for Higher Education

/in /by


We would like to welcome the Nevada Western Interstate Commission for Higher Education (WICHE) as a new user of our Margill Loan Manager software.

The Western Interstate Commission for Higher Education is a regional organization created by the Western Regional Education Compact and adopted in the 1950s by Western states. WICH was created to facilitate resource sharing among the higher education systems of the West.

You can visit their website here.

The Margill Team

Margill at the LendIt Fintech

/in /by

The Margill team will exhibit at the LendIt Fintech USA 2018 Conference at the Moscone West in San Francisco, California.  Come visit us at booth number 1649 from April 9 to the 11th, 2018.

Bank of Canada rate

/in /by

The Bank of Canada raises its base rate by 0.25% effective January 18, 2018.

Can Margill Loan Manager be used to manage rentals (rent)?

/in /by

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 usually will decrease as payments are made for the interest and principal portions. Rent on the other hand, is due (accrued), and payable every month. So rent accrues usually on the first of the month and then is paid, hopefully, on the same day. Usually, interest is not charged on rent.

First, in Tools > Settings > Custom Column Titles, change the Column “Fees” title to “Rent”.

Create a new Record. Under Data enter the date at which the first rent is due. The same date should be entered in both Origination Date and First Payment Date. The rents are payable monthly. Principal (Original) should be 0.00 and since there is no interest on the rent, Annual Nominal Rate (%) should also be 0.00%. This is a three year rental for 575 per month. Press on “Add Fees” and a window will allow you to enter the monthly rent amount.

Then press on Compute and answer No to this pop-up. We do not want Margill to compute the Principal (remains 0.00).

The rental payment schedule then appears. I moved my column called “Rent – Accrued” to the left to see it readily without needing to scroll to the right. The rent is “charged” with the “Rent – Accrued” and paid with the “Payment” column.

Notice on line 3 that my rent is a few days late. This does not change anything mathematically since interest is not charged, but this allows you to balance with your banking transactions. A partial rent amount could also have been entered and the schedule then changed based on what was agreed for later repayment between the “landlord” (or equipment rental) and the person who rents.

To be fancy, I renamed a Paid Pmt (x) Line status to “Paid Rent”. Go to Tools > Settings > Line status.

A little banking humor! His name was Boudreaux…

/in /by

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 depositor  of the bank. 

The bank officer told him that the bank would need some form of security for the loan, so Boudreaux handed over the keys to a new Ferrari. The car was parked on the street in front of the bank. 

Boudreaux produced the title and everything checked out. The loan officer agreed to hold the car as collateral for the loan and apologized for having to charge 12% interest. 

Later, the bank’s president and its officers all enjoyed a good laugh at the Cajun from Louisiana for using a $250,000 Ferrari as collateral for a $5,000 loan. An employee of the bank then drove the Ferrari into the bank’s private underground garage and parked  it. 

Two weeks later, Boudreaux returned, repaid the $5,000 and the interest of $23.01. The loan officer said, “Sir, we are very happy to have had your business, and this transaction has worked out very nicely, but we are a little puzzled.” 

 “While you were away, we checked you out on Dunn & Bradstreet and found that you are a distinguished alumni from LSU, a highly sophisticated investor and multi-millionaire with real estate and financial interests all over the world. Your investments include a large number of oil rigs around south Louisiana. What puzzles us is, why would you bother to borrow $5,000?” 

The good ‘ole boy replied, “Where else in New York City can I park my car for two weeks for less than $25.00 and expect it to be there when I return?” 

His name was Boudreaux…. Keep an eye on those Louisiana boys! 

Just!! cuz we talk funny doesn’t mean we’re stupid ! 

 

Importing batch payments in Margill Loan Manager (CSV, Excel)

/1 Comment/in /by

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, Margill does this no problem.

Each and every line of a payment schedule includes a unique line identifier. If this line identifier can be sent back to Margill from your processor (or accounting or ERP system), the software will automatically change a “Due payment” to a Paid, Late or Partial payment or even an Unpaid payment if your system can send back the Line ID with a payment of 0.00 (most systems don’t actually, so a human may have to decide when this payment eventually is considered Unpaid).

To send the transactions to the bank or to the payroll deduction processor, use the Transaction report with any data you want. Let’s keep it simple by supplying the Name, Transaction date, Transaction amount and Unique Line ID.

This report can then be sent to the processor in Excel, CSV or Text format.

Please note. The file created by Margill is not in NACHA format. We work with third party processors Intrix (US) and Perceptech (Acceo)(Canada) for electronic funds transfers to debit your borrower accounts.

Notice the “Line Unique ID” above – your provider must be able to accept this data and return it with the paid payments in the format below. We highlighted special payments (need not for real…):

  • In C2  we have a Partial payment
  • C4 – Unpaid payment
  • B7 – Late payment
  • B15 – Partial Late
  • C23- Unpaid payment
  • The rest are all normal Paid payments – on time, right amount…

This Excel file is imported to Margill and all payments will be updated in seconds… Errors will be flagged the case being.

See also: How can I enter multiple payments and advances in a loan without having to enter them one by one? I have over 100 in one loan. I have the data in Excel.

Margill Loan Manager: Is there a way for me to see if users are logged on to the system?

/in /by

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:

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!

/in /by

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 so this is why you are not back to the same end balance (0.00).

To get the exact payment that should have been paid to compensate, he will have to pay the outstanding interest. An easy way to get the exact payment is to highlight that payment line,  right click and do this: