Follow Us on Social Media

email icon rss icon linked.in icon google plus icon twitter icon facebook icon

How to Filter Tax Liens and Other Real Estate Deals in 3 Easy Steps

by Ankit Duggal on February 11, 2014 · 2 comments

  
Filter Liens and Deals

Are you overwhelmed with all the deals and liens available in the market?

I know that I was when I started looking at deals and lien lists.

The sheer amount of data can be daunting.

I came up with a quick way to filter data to help decide if any of the deals/liens are investable!

I am going to write this article from the perspective of analyzing tax lien lists but the steps and tricks are applicable to filtering any major data set.

Related: BP Podcast 056: Syndicating Deals, Investing without Tenants, and Tax Liens with Ankit Duggal

Tax lien auctions are a time sensitive and intense process given that some counties and municipalities having lists of liens available are in the thousands or tens of thousands of liens available. You need a quick way to analyze these liens and filter down to manageable investment data set.

Here are three easy steps to help you wade through a list of thousands of liens:

Step 1: Know Your Investment Blocks/PIN (Parcel Identification Number)

I have a master list of Blocks within key investment markets that interest me for lien investing.  I utilize this list and the Sort Function in Excel to narrow down the list to only include the blocks that are within my investment zones.

A similar approach to this idea is something that Jerry K. of Aristo Associates, Inc. does for his online tax lien investing business model that I ran across in my readings and I will use his analysis as my example template for this article given that he has done a great job showing the use of the Auto Filter tool:

“Jerry goes to the the county GIS map website and determine the PIN (Parcel Identification Number) for the areas he likes. That creates a PIN list that he ranks in the order of his investment preference.”

Step 2: Inputting Data and Applying the Automatic Filter Function

Excel Steps

Input all of your data, or open the spreadsheet that contains all of your data. It is best that your data have column heading such as categories to specify the data below it.

Select all the data you wish to filter because the AutoFilter option is an automatic process that does not receive any specific inputs on how to filter, it is recommended that you choose ‘’all’’ of the data you have. This will avoid the possibility that you lose data associations across rows and/or columns.

Click “Data”, then select “Filter”.

Image 1

So going back to Jerry’s analysis example:

“By applying the Filters to each column at the top and then clicking on the filter icon (red arrow at top of column) the spreadsheet then opens a pop up to allow how you want to filter your list:”

Image 2

Step 3: Filtering the Data

Excel Steps

Once you click the Filter button you will notice that the categories have drop-down buttons. Using these buttons, you can set your filter options.

  • Sort Ascending: sorts data in ascending order based on the data in that column
  • Sort Descending: sorts data in descending order based on the data in that column; numbers are sorted in reverse order 5, 4, 3, 2, 1, etc. and words are sorted in reverse alphabetical order, e, d, c, b, a, etc.
  • Custom: You may customize how Excel sorts the data based on data ranges and information.

So going back to see how Jerry completed his sort analysis.

Image 3

“Jerry uses “Text Filters” (in yellow highlight) which then opens the next box and he choose “Begins With… (red arrow on right side above).This opens another box

wherein he fills in the beginning of the PIN number so that the spreadsheet filters the list that only contain the PIN that begin with the number for the area he likes:

Image 4

That results in a much narrower list that he can start to analyze:”

Image 5

I do pretty much the same thing as Jerry except I use Block data instead of PIN. Jerry is fellow Biggerpockets member as well and I want to thank him for sharing this information.

Happy Investing!

Images Location:

https://www.dropbox.com/sh/kefh9zpp2lgitn3/E5iessJ4Ts

Email *
  



{ 2 comments… read them below or add one }

Jerry K. February 12, 2014 at 5:21 am

Ankit,
Nice post on how to filter large lists – especially the lien lists. In Florida tax lien sales can be over 20,000 liens in just one single county! You need to use tools to narrow your list.

Your advice in your podcast about concentrating on a narrow list of types of properties/liens is spot on. Whether it be by block, parcel number or type of underlying property, spreadsheet filtering and sorting is relatively simple and fast.

I do the same with the results of online auctions so I can see how other investors bid and look for clues on finding better ways to invest for next year.

Reply

Ankit Duggal February 12, 2014 at 9:40 am

Thanks Jerry. Great point about analyzing historical trend data to become a better bidder.

Reply

Leave a Comment

Comment Policy:

• Use your real name and only your name in the field designated for your name.
• No keywords allowed as anchor text in the name or comment fields.
• No signature links allowed under your comments
• You may use links in the body of your comment, but it must be relevant to the discussion at hand, and not merely be some promotional link.
• We will have NO reservations about deleting your content if we feel you are posting merely to get a link without adding value to our discussion.
If you add value, but still post keywords, we'll use your comment, but remove your link and keywords.
• For more information about acceptable practice, see our site rules.

Want your photo to appear next to your comments? Set up your Gravatar today.

Previous post:

Next post: