Can Margill software be used for HOA (Home Owners Association) collections along with the interest calculation?

Q: Can Margill software be used for HOA (Home Owners Association) collections along with the interest calculation?

A: Yes, very easily without needing an agency to do these calculations.

Many law firms and accountants are tasked with collecting HOA assessments and find it time consuming with a risk or error when this is done by hand or in a spreadsheet.

Option 1 – Low volume

Margill Law Interest Calculator can be used to do these calculations when there is a low volume (less than 20-25). You can even import the assessment amounts and dates as well as the payments made with a very simple 2-3 column Excel sheet.

Example of a HOA collection table where assessments are included as well as payments and attorney fees:

Nice need reports can also be produced in PDF formats that show how payments are applied.

Option 2 – Higher volume 

If your volume if greater than twenty or so cases (and can go to the hundreds or thousands), then Margill Loan Manager would be a better solution since all data is stored in a nice-neat database in which assessments, payments, attorney fees and costs can be added in bulk though a spreadsheet. You can also manage payments and collect through ACH payments – so you can actually service the HOA assessments. Furthermore, you can instantly provide your client with balances for all outstanding assessments.

For more information, please contact us at 1-877-683-1815 or by email support@margill.com

 

How to change the Windows Short date format

Margill prefers a date format that contains 4 digits for the year. This is especially important for calculations that may (if these still are out there!) predate the year 2000.

How to change the Windows Short date format:

Windows 10 gives you various ways to change the short date format (Control Panel or Settings)

1) With Control Panel

Type a few letters of the word “Control Panel” in Cortana (bottom left):

Go to Clock and Region and click on “Change date, time or number formats”

Then change your Short date format to the format you want that contains yyyy, MM and dd. You decide on the order these appear in. If none of the choices match, click on “Additional settings” on the bottom right in this window.

You can then type in the missing year digits (y – total 4), month digits (M – total 2)  or day digits (d – total 2)

2) You can also use the Windows key  on your keyboard and X and go to “Settings”:

Click on Time & Language

Find “Related Settings” and click on “Date, time & regional formatting”

Click on “Additional date, time & regional settings”

Click on  “Change date, time or number formats”

Now see the instruction in 1) above to enter the proper “Short date format”.

Margill Law/Standard Edition – Regular and Irregular payment schedule

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.

How to do erratic payments in Margill Standard/Law Edition

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 more options!

It is also possible to add or remove lines.

The totals will then be recalculated with the new schedule.

The Margill Team

Margill Standard/Law versions: How to do an irregular payments scedule

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 at 5 percent.

Can did this be calculated in one calculation?

Answer:

Yes. Pretty easy to do in fact.

Go to “Recurring Payments” caclulation.

I will suppose compounding is Monthy.

Enter this preliminary data

Compute or F5 to get these preliminary results:

You can totally adapt this to your needs.

We know payments of 50,000 are to be paid on 05/01/2017 and 05/01/2018. Change these directly in the schedule.

As for the payments in between, they must be recomputed so as to reach a balance of 0.00 at the end.

Select all lines (Ctrl A) then exclude the 50,000 lines (Ctrl click on lines 2 and 14) and right click with the mouse. I want my balance to be 0.00.

And here you have it. My last payment if off by a few cents so I checked “Balance = 0.00” on the bottom right.

Save that calculation and you can then adapt to what happens for real over time.

Took less than a minute….


Client comment after post:

Marc, I just checked it. You made four people very happy today. One client, two attorneys, and me.

 I really appreciate your availability, patience, and instruction.

Mortgages

Asset finance / Leasing

Loans

Judgments

Collection