際際滷

際際滷Share a Scribd company logo
Tax Lien Mathematics
How Do You Calculate Success?
VADAR Systems
Rob Natale, COO
Jed Reitler, VP Sales
Feb 27, 2015
theNTLA.com | vadarsystems.com 1
#NTLAANNUAL15
WI-FI Password: NTLA213
Lien Math Principles
1. Foundation
Collecting Metrics
2. Framing
Factoring State Regulations
3. Development
Systemize Calculations and Processes
vadarsystems.com 2
Yield Calculations
Business Rules Factored Into Algorithms
 Interest and Accrual
 Penalties and Fees
 Premiums
 Redemption Periods
Each State is
Its Own Market
vadarsystems.com 3
vadarsystems.com 4
Continued from NTLA 2014
CO Investment Strategy
 Suggested Slow Play
 Accruing interest needs
time to offset costs of lost
premiums
NJ Investment Strategy
 Suggested Quick Play
 Longer redemption periods
decrease the return offsets of
the fixed penalties
Based on analysis of anonymous sales data from LienSource, SRI, and TSR
Market Factors
 What is the Bid System?
 What are the Interest Rates?
 What is the Redemption Term?
 What is the Accrual Term?
 Do Penalties Exist?
 Are Premiums Allowed? Recoverable?
 What are the Rules for Subsequents?
vadarsystems.com 5
State Sampling
theNTLA.com | vadarsystems.com 6
CO FL IN NJ
Bid System Premium Bid Bid Down Premium Bid Bid Down w/
Premium
Interest Rate Fed disc. + 9 pts 18% 18%
Redemption Term 36 months 24 months 12 months 24 months
Accrual Term Monthly Monthly Every 6 Months Daily
Penalty 5% Minimum 10% then 15% Fixed
Premium Allowed Yes No Yes Yes
Premium
Recoverable
No No Yes Yes
Premium Interest No No 10% No
Pay Subsequents Yes No Yes Yes
Subsequent Interest Fed disc. + 9 pts N/A 8% - 18%
Fees  Fed disc + 9  Property Search
 Tax Deed App
 Property Search
 Recording
 Tax Sale
 Property Search
 Recording
 Penalty 2%-6%
Calculation Factors
 Bid-Down and Overbid
 Cash Flow and NPV
 Interest Rate
 LTV, IRR, xIRR
 Penalties & Fees
 Premiums
 Redemption Period
 Subsequents
 State-Specific Process
 Operating Expense
 Opportunity Cost
vadarsystems.com 7
Real World Complexity
Are You Making Money?
vadarsystems.com 8
Receipt  Purchase Price
Purchase Price
Time Value of Money
For Cash Flows with Fixed Time Intervals
For Cash Flows with Variable Intervals
Reflects the Real World of Lien Portfolios
vadarsystems.com 9
Today 1 Year 2 Years 3 Years
Value
$1,000 Over Time
IRR and xIRR in Excel
vadarsystems.com 10
Date Cash Date Cash Date Cash Date Cash
1-Jan $ (100.00) 1-Jan $ (100.00) 1-Jan $ (100.00) 1-Jan $ (100.00)
2-Jan $ 101.00 31-Jan $ 101.00 31-Jan $ 101.00 1-Jun $ 105.14
IRR 1.00% IRR 1.00% IRR 1.00% IRR 5.14%
xIRR 3678.34% xIRR 12.87% xIRR 12.87% xIRR 12.88%
Date Cash Date Cash Date Cash Date Cash
01/01/13 $ (2,800.00) 01/01/13 $ (2,800.00) 01/01/13 $ (2,800.00) 01/01/13 $ (2,800.00)
02/01/13 $ 35.00 02/01/13 $ 35.00 02/01/13 $ (150.00) 02/01/13 $ (150.00)
06/30/13 $ 500.00 06/30/13 $ 500.00 06/30/13 $ 50.00 06/30/13 $ 50.00
01/31/14 $ 1,200.00 01/31/14 $ 1,200.00 01/31/14 $ 750.00 01/31/14 $ 750.00
12/01/14 $ 750.00 12/01/14 $ 750.00 12/01/14 $ 750.00 12/01/14 $ 750.00
01/31/15 $ 800.00 02/27/15 $ 800.00 01/31/15 $ 1,750.00 2/27/15 $ 1,750.00
IRR 4.65% IRR 4.65% IRR 2.70% IRR 2.70%
xIRR 12.13% xIRR 11.98% xIRR 6.49% xIRR 6.35%
1-Year Return
The Same Lien Feb 27, 2014 and Today
6.72% Rate of Return
2.83% Rate of Return
vadarsystems.com 11
Business Intelligence
vadarsystems.com 12
When you buy your
first lien, you enter the
lien servicing business.
vadarsystems.com 13
Learn More
vadarsystems.com
sales@vadarsystems.com
(978) 461-5855
vadarsystems.com 14
Ad

Recommended

PDF
Argie bond quant track record
Francisco Prack
PDF
Argie bond quant track record
Francisco Prack
PDF
Argie bond quant track record
Francisco Prack
PDF
CENTRAL BANKERS: IF YOU CANT BEAT BITCOIN, PRINT IT AND CONTROL IT
Steven Rhyner
PPT
Wgr ks mkt_stdypres_060308r
krgc
PPT
Csfme Sl1 Q09 Trends B
EdBlount
PDF
Bit Gold Investor Presentation
BitGold Inc
PDF
Argie bond quant track record
Francisco Prack
PDF
Argie bond quant track record
Francisco Prack
PDF
Argie bond quant track record
Francisco Prack
PDF
Job Summit
Bryan Spondre
PDF
1403 monthly snapshot
Joe Van Hecke
PDF
3 q12 conference call presentation
BancoABCRI
PDF
Argie bond quant track record
Francisco Prack
DOCX
HOW TO CALCULATE SALES TAX, POSTAGE, + FINAL PRICE OF FACTORY OUTLET BAGS THA...
Homeskanstore lay khoo/Angie
PPT
8 5 Sales Tax And Discount
rlowery
PPT
Calculating sales tax
Genny Phillips
PPTX
Give Your Business a 2017 Sales Tax Checkup
TaxJar
PPT
Sales tax and_discounts
Brenda Obando
PPTX
Sales tax examples presentation
Debra Hoagland
PPTX
Sales Tax Presentation
krishnavfx
PPT
Social arithmetic
Dalubhasaan ng Lungsod ng Lucena
PPT
Mark Up And Discount
Jessca Lundin
PPTX
Central sales tax
Pallavi Yadav
PPT
Sales tax and tip powerpoint
tigergirl823
PPT
Income from business
Augustin Bangalore
PPT
Clinical Anatomy Circle Of Willis & Cavernous Sinus
Ankit Punjabi
PPTX
From Spreadsheets to Systems for Tax Liens
VADAR Systems
PPTX
From Spreadsheets to Systems
Jed Reitler
PDF
Lecture 3
Farzad Javidanrad

More Related Content

What's hot (6)

PDF
Argie bond quant track record
Francisco Prack
PDF
Argie bond quant track record
Francisco Prack
PDF
Job Summit
Bryan Spondre
PDF
1403 monthly snapshot
Joe Van Hecke
PDF
3 q12 conference call presentation
BancoABCRI
PDF
Argie bond quant track record
Francisco Prack
Argie bond quant track record
Francisco Prack
Argie bond quant track record
Francisco Prack
Job Summit
Bryan Spondre
1403 monthly snapshot
Joe Van Hecke
3 q12 conference call presentation
BancoABCRI
Argie bond quant track record
Francisco Prack

Viewers also liked (13)

DOCX
HOW TO CALCULATE SALES TAX, POSTAGE, + FINAL PRICE OF FACTORY OUTLET BAGS THA...
Homeskanstore lay khoo/Angie
PPT
8 5 Sales Tax And Discount
rlowery
PPT
Calculating sales tax
Genny Phillips
PPTX
Give Your Business a 2017 Sales Tax Checkup
TaxJar
PPT
Sales tax and_discounts
Brenda Obando
PPTX
Sales tax examples presentation
Debra Hoagland
PPTX
Sales Tax Presentation
krishnavfx
PPT
Social arithmetic
Dalubhasaan ng Lungsod ng Lucena
PPT
Mark Up And Discount
Jessca Lundin
PPTX
Central sales tax
Pallavi Yadav
PPT
Sales tax and tip powerpoint
tigergirl823
PPT
Income from business
Augustin Bangalore
PPT
Clinical Anatomy Circle Of Willis & Cavernous Sinus
Ankit Punjabi
HOW TO CALCULATE SALES TAX, POSTAGE, + FINAL PRICE OF FACTORY OUTLET BAGS THA...
Homeskanstore lay khoo/Angie
8 5 Sales Tax And Discount
rlowery
Calculating sales tax
Genny Phillips
Give Your Business a 2017 Sales Tax Checkup
TaxJar
Sales tax and_discounts
Brenda Obando
Sales tax examples presentation
Debra Hoagland
Sales Tax Presentation
krishnavfx
Mark Up And Discount
Jessca Lundin
Central sales tax
Pallavi Yadav
Sales tax and tip powerpoint
tigergirl823
Income from business
Augustin Bangalore
Clinical Anatomy Circle Of Willis & Cavernous Sinus
Ankit Punjabi
Ad

Similar to How Do You Calculate Success? (20)

PPTX
From Spreadsheets to Systems for Tax Liens
VADAR Systems
PPTX
From Spreadsheets to Systems
Jed Reitler
PDF
Lecture 3
Farzad Javidanrad
PDF
Fundamentals of Corporate Finance 8th Edition Brealey Solutions Manual
rmbasaowan
PPTX
Npv n other invest cri lec 4
University of Balochistan
DOCX
Question 1. You can earn $40 in interest on a $1,000 deposit for.docx
makdul
DOCX
Compute IRR and NPV in Microsoft Excel 1.IRR Function .docx
patricke8
DOCX
Compute IRR and NPV in Microsoft Excel 1.IRR Function .docx
mccormicknadine86
PPTX
Corporate Finance Case Study : Bullock Gold Mining
Uun Ainurrofiq (Fiq)
DOCX
Math 034 First Letter of Last Name Homework #7 .docx
andreecapon
PPTX
Financial concepts
cebrandt
PPT
NonCurrent_Laccounting h viabilities.ppt
bemni1212
PPT
Capital Budgeting I Principles and Techniques_MODIFIED.ppt
KrithikK11
PPTX
BAHAN NGAJAR BAB 7 INTERNAL RATE OF RETURENT.pptx
bangometv
PPTX
Capital Budgeting & Capital Rationing.pptx
devinepasi4l
PPT
13. NPV rule, cash flow calculations, discount rates in Capital budgeting.ppt
Otabek Kurbonov
PPTX
Time value of money
ASAD ALI
PDF
Introduction to Financial Management
Ardiaz Ajie Aryandika
PPT
Topic 1 Npv And Other Investment Creteria
shengvn
PPT
Capital budgeting
DR.MAHESH KUMAR K.R.
From Spreadsheets to Systems for Tax Liens
VADAR Systems
From Spreadsheets to Systems
Jed Reitler
Lecture 3
Farzad Javidanrad
Fundamentals of Corporate Finance 8th Edition Brealey Solutions Manual
rmbasaowan
Npv n other invest cri lec 4
University of Balochistan
Question 1. You can earn $40 in interest on a $1,000 deposit for.docx
makdul
Compute IRR and NPV in Microsoft Excel 1.IRR Function .docx
patricke8
Compute IRR and NPV in Microsoft Excel 1.IRR Function .docx
mccormicknadine86
Corporate Finance Case Study : Bullock Gold Mining
Uun Ainurrofiq (Fiq)
Math 034 First Letter of Last Name Homework #7 .docx
andreecapon
Financial concepts
cebrandt
NonCurrent_Laccounting h viabilities.ppt
bemni1212
Capital Budgeting I Principles and Techniques_MODIFIED.ppt
KrithikK11
BAHAN NGAJAR BAB 7 INTERNAL RATE OF RETURENT.pptx
bangometv
Capital Budgeting & Capital Rationing.pptx
devinepasi4l
13. NPV rule, cash flow calculations, discount rates in Capital budgeting.ppt
Otabek Kurbonov
Time value of money
ASAD ALI
Introduction to Financial Management
Ardiaz Ajie Aryandika
Topic 1 Npv And Other Investment Creteria
shengvn
Capital budgeting
DR.MAHESH KUMAR K.R.
Ad

Recently uploaded (15)

PPTX
Heating_Effect_of_Solar_Corona_Presentation.pptx
Hanumamshukla
PPTX
Itinerary ROHIS SMUNIC diperlukan untuk acara.pptx
lukmanjavalatte
PPTX
Bob Stewart Acts 18 06 18 2025.pptx
FamilyWorshipCenterD
PPTX
2025-06-22 Abraham 04 (shared slides).pptx
Dale Wells
PPTX
Political Polarization And Government Accountability.pptx
EverlyseLumantas
PPTX
Pitch deck for any business presentation.pptx
mukeshpurohit991
PPTX
PEN TO PODIUM powerpoint presentation.pptx
Vanessa accad
PPTX
Section 4 - Islamic Civilization & Culture.pptx
MianMuhammadUbaidUll
PPTX
Briefing on the upcoming UNFSS +4 Stocktake
Francois Stepman
PDF
Japan's Media and Telecom Markets: Evolution, Global Competition, and NTT Law...
Toshiya Jitsuzumi
PPTX
AC_Manufacturer_Strategy_Commercial_Government.pptx
ajajsain
PPTX
FL Studio Crack Full Version [Latest 2025]
Jackson lithms
PPTX
Joy In The Journey 06 22 2025.pptx
FamilyWorshipCenterD
PDF
Josaya - Abstract for the research of the youth development.pdf
Josaya Injesi
PDF
Google Algorithm Updates A Complete Guide for Digital Marketing Students.pdf
Nithinks37
Heating_Effect_of_Solar_Corona_Presentation.pptx
Hanumamshukla
Itinerary ROHIS SMUNIC diperlukan untuk acara.pptx
lukmanjavalatte
Bob Stewart Acts 18 06 18 2025.pptx
FamilyWorshipCenterD
2025-06-22 Abraham 04 (shared slides).pptx
Dale Wells
Political Polarization And Government Accountability.pptx
EverlyseLumantas
Pitch deck for any business presentation.pptx
mukeshpurohit991
PEN TO PODIUM powerpoint presentation.pptx
Vanessa accad
Section 4 - Islamic Civilization & Culture.pptx
MianMuhammadUbaidUll
Briefing on the upcoming UNFSS +4 Stocktake
Francois Stepman
Japan's Media and Telecom Markets: Evolution, Global Competition, and NTT Law...
Toshiya Jitsuzumi
AC_Manufacturer_Strategy_Commercial_Government.pptx
ajajsain
FL Studio Crack Full Version [Latest 2025]
Jackson lithms
Joy In The Journey 06 22 2025.pptx
FamilyWorshipCenterD
Josaya - Abstract for the research of the youth development.pdf
Josaya Injesi
Google Algorithm Updates A Complete Guide for Digital Marketing Students.pdf
Nithinks37

How Do You Calculate Success?

  • 1. Tax Lien Mathematics How Do You Calculate Success? VADAR Systems Rob Natale, COO Jed Reitler, VP Sales Feb 27, 2015 theNTLA.com | vadarsystems.com 1 #NTLAANNUAL15 WI-FI Password: NTLA213
  • 2. Lien Math Principles 1. Foundation Collecting Metrics 2. Framing Factoring State Regulations 3. Development Systemize Calculations and Processes vadarsystems.com 2
  • 3. Yield Calculations Business Rules Factored Into Algorithms Interest and Accrual Penalties and Fees Premiums Redemption Periods Each State is Its Own Market vadarsystems.com 3
  • 4. vadarsystems.com 4 Continued from NTLA 2014 CO Investment Strategy Suggested Slow Play Accruing interest needs time to offset costs of lost premiums NJ Investment Strategy Suggested Quick Play Longer redemption periods decrease the return offsets of the fixed penalties Based on analysis of anonymous sales data from LienSource, SRI, and TSR
  • 5. Market Factors What is the Bid System? What are the Interest Rates? What is the Redemption Term? What is the Accrual Term? Do Penalties Exist? Are Premiums Allowed? Recoverable? What are the Rules for Subsequents? vadarsystems.com 5
  • 6. State Sampling theNTLA.com | vadarsystems.com 6 CO FL IN NJ Bid System Premium Bid Bid Down Premium Bid Bid Down w/ Premium Interest Rate Fed disc. + 9 pts 18% 18% Redemption Term 36 months 24 months 12 months 24 months Accrual Term Monthly Monthly Every 6 Months Daily Penalty 5% Minimum 10% then 15% Fixed Premium Allowed Yes No Yes Yes Premium Recoverable No No Yes Yes Premium Interest No No 10% No Pay Subsequents Yes No Yes Yes Subsequent Interest Fed disc. + 9 pts N/A 8% - 18% Fees Fed disc + 9 Property Search Tax Deed App Property Search Recording Tax Sale Property Search Recording Penalty 2%-6%
  • 7. Calculation Factors Bid-Down and Overbid Cash Flow and NPV Interest Rate LTV, IRR, xIRR Penalties & Fees Premiums Redemption Period Subsequents State-Specific Process Operating Expense Opportunity Cost vadarsystems.com 7 Real World Complexity
  • 8. Are You Making Money? vadarsystems.com 8 Receipt Purchase Price Purchase Price
  • 9. Time Value of Money For Cash Flows with Fixed Time Intervals For Cash Flows with Variable Intervals Reflects the Real World of Lien Portfolios vadarsystems.com 9 Today 1 Year 2 Years 3 Years Value $1,000 Over Time
  • 10. IRR and xIRR in Excel vadarsystems.com 10 Date Cash Date Cash Date Cash Date Cash 1-Jan $ (100.00) 1-Jan $ (100.00) 1-Jan $ (100.00) 1-Jan $ (100.00) 2-Jan $ 101.00 31-Jan $ 101.00 31-Jan $ 101.00 1-Jun $ 105.14 IRR 1.00% IRR 1.00% IRR 1.00% IRR 5.14% xIRR 3678.34% xIRR 12.87% xIRR 12.87% xIRR 12.88% Date Cash Date Cash Date Cash Date Cash 01/01/13 $ (2,800.00) 01/01/13 $ (2,800.00) 01/01/13 $ (2,800.00) 01/01/13 $ (2,800.00) 02/01/13 $ 35.00 02/01/13 $ 35.00 02/01/13 $ (150.00) 02/01/13 $ (150.00) 06/30/13 $ 500.00 06/30/13 $ 500.00 06/30/13 $ 50.00 06/30/13 $ 50.00 01/31/14 $ 1,200.00 01/31/14 $ 1,200.00 01/31/14 $ 750.00 01/31/14 $ 750.00 12/01/14 $ 750.00 12/01/14 $ 750.00 12/01/14 $ 750.00 12/01/14 $ 750.00 01/31/15 $ 800.00 02/27/15 $ 800.00 01/31/15 $ 1,750.00 2/27/15 $ 1,750.00 IRR 4.65% IRR 4.65% IRR 2.70% IRR 2.70% xIRR 12.13% xIRR 11.98% xIRR 6.49% xIRR 6.35%
  • 11. 1-Year Return The Same Lien Feb 27, 2014 and Today 6.72% Rate of Return 2.83% Rate of Return vadarsystems.com 11
  • 13. When you buy your first lien, you enter the lien servicing business. vadarsystems.com 13

Editor's Notes

  • #2: Agenda NOT a boring list of 29 states to list all calculations 3 Principles of Lien Mathematics State Market Factors and State Sampling Revenue is Wonderful, but Cash Flow is King (xIRR) Optimizing Your Business Intelligence
  • #3: Data and Metrics: redemption AND payment 1st dollar AND final dollar State Regulations: factoring the nuances of premiums, penalties, accruals, subsequents, etc. Systemization: consistent, repeatable, efficient methodologies and processes
  • #4: Interest Fixed vs. Variable (Bid Down) Accrual Monthly vs. Per Diem Penalties & Fees Recoverable or Non-Recoverable Premiums Recoverable or Non-Recoverable How do you currently account for ______? [Fee mix of recoverable and non-recoverable, different accrual rates, etc.]
  • #5: Review of sale lists and assumption of redeeming full portfolios @ 1 Year, 2 Years, or Partial every 6 months for 2 Years Frank Natale, panelist and speaker
  • #6: Quickly demonstrate factors and their impact on Yield calculations for every variable Set up the State Sampling of these factors and calculations
  • #7: 29 States each with different calculations Sampling 6 states to represent and encompass all variables and rules in the industry CO Lost premiums need time for interest to accrue FL 0.25% interest is very common NJ Majority with 0% interest 1-time flat rate penalties change the game
  • #8: Framing the Valuation House considers nuances of State Lien regulations Doing more than a simple calculation of (all the money out all the money in)
  • #9: Asset Performance Are You Making Money? Example: $100 lien and $112 redemption = 12% ROI Time Value of Money Factoring in the Time Element and Cash Flow is crucial How close are your time-factored returns to state Interest Rates?
  • #10: [Choose an image to convey TVM, variable payment, free cash flow] Lack of bias If your Return/Yield doesnt factor for irregular payment intervals, your valuation may not be accurate. xIRR annualized yield for cash flows occurring with irregular time periods; iterative technique of cycling through changing rates
  • #11: Walk through the BIG differences between IRR and xIRR The reality is Tax Lien Investments have IRREGULAR time periods of cash flow. If youre not accounting for more than simple annualized IRR, youre imprecise and less than credible.
  • #12: A Year Before Today and Today Instant Return analysis
  • #13: How Would Your Investment Strategy Change If Your Business Intelligence: Could Calculate xIRR from Any Time Past, Present, or Even into the Future Spent Less Time Tracking Liens and More Time Perfecting Your Investment Strategy Factored In State-Specific Processes In Addition to Business Rules Factored Your Redemption Payment Float by County or Parcel Type
  • #14: Do you measure your costs of servicing? Man-hours of entry, error checking, and analysis Man-hours of notices and other paperwork Opportunity cost of servicing vs. due diligence
  • #15: Thank you for your time, and we look forward to answering any questions you may have.