際際滷

際際滷Share a Scribd company logo
? 2017 NTLA and VADAR? Systems 1
From Spreadsheets
to Systems C Lab 2
VADAR? Systems
Jed Reitler, VP Business Development
10:30am Studio 1 Mar 2, 2017
Challenges
Spreadsheets
Systems
Solutions
Q & A
ntla.com | vadarsystems.com
From Spreadsheets to Systems
^He's a genius
investor, but God
help his staff and his
management skills. ̄
3ntla.com | vadarsystems.com
4
Costly Office Practices
Email
Excel
Laptops
ntla.com | vadarsystems.com
Challenges
Challenges
theNTLA.com | vadarsystems.com 5
How efficient is your office?
Parcel Research
Field Inspection
Parcel
Analysis
LoC Payment
Raise Capital
Auction Bid Court
Filing Fees
Lender
Reporting
Load Acquisition
Portfolio
Organization
Flags and Holds
Owner Notices Court
Notices
Hold Notices
Payment Plans
Collections
Cash Flow
Analysis
Assess
Subsequents
Load and
Integrate
Subsequents
Integration
and Valuation
Analysis
Audit
Discrepancies
Report
Transactions to
Auditor
Rectify Lender
Reporting
Load
Redemptions
Review and Post
Payments
Report Cash
Flow Analysis
Report
Redemption
Curve
Bankruptcy
Foreclosure
Title Clearing Legal Notices
Court
Filing
Borrowing
Base Reports
Operational
Review and Audit
Bottom-Line Profit
Analysis
Adjust Investment
Strategies
6ntla.com | vadarsystems.com
Challenges
7
Various Statute Compliances
Tracking and Reconciliation
Parcel Data Management
Collections and Notices
Foreclosure and REO
Legal Filing and Fees
Custodial Services
ntla.com | vadarsystems.com
Challenges
Spreadsheets
theNTLA.com | vadarsystems.com 8
10 Spreadsheet Sinkholes
Cost Vulnerability
Constrictive Dependence on a few constricts your flexibility
Doesn¨t Scale Disproportionate overhead increases with your growth
Slow Decisions Your financial decisions require instant information
Prone to Error Common and costly errors with entry and formulas
Prone to Fraud No controls of user roles and permissions
Not Compliant Dodd-Frank and SoX require more
Not Collaborative Budget, forecast, plan in silos
Not Recoverable Lost when devices and networks fail
Not Consolidated Different analyses, reports, versions, by many users
Hard to Test Tracing formula logic takes thousands of manhours
theNTLA.com | vadarsystems.com 9
Spreadsheets ★ Systems
ntla.com | vadarsystems.com
Systems
Systems
? System: ^formulated, regular plan of procedure ̄
? Repeatable processes in your organization?
? Do you have data in silos or a shared system?
? Minimize your overhead costs of´
theNTLA.com | vadarsystems.com 12
Error
Loss
Turnover
Training
Reporting
Analysis
Analysis Rework Audit
13
Due
Diligence
Acquisition
Subsequents
Legal and
FeesNoticing
Disposition
Analytics
Analyze
Manage
Report
ntla.com | vadarsystems.com
Systems
Systems
ntla.com | vadarsystems.com
Systems
Solutions
5 solutions to improve your system
1. Identify key stakeholders and unify their focus
2. Record operational challenges to identify the easiest
and costliest to remedy
3. Know your vital data elements, where they are
stored, and who controls them
4. Reduce redundancy by improving communications
and interfaces between systems
5. Identify resources to leverage to implement new
solutions (e.g. IT staff, software vendor, law firm)
Solutions
?Enhanced cash flow
?Higher portfolio returns
?Increased revenue recovery
?Lower overhead costs of audits,
information, and operations staff
Out-Compete with real-time analytics
and decision making leadership
Question &
Answer
Session
LienApp.com
877.823.2300
VADARsystems.com
ntla.com | vadarsystems.com
Thank You
3 Choices
Build BuyServicer
Their Strategy
Less Control
Basis Points
Cost Over-Runs
Never Finished
IT Experts
Your Strategy
Configurable
Scalable
Servicer
theNTLA.com | vadarsystems.com 20
Build
Build costs 180% more
for 1/3 of the planned design.
Acquisition Custodian Redemption Subsequents Enforcement
Search Audit
Instant
Analysis
Export Interface
Dashboard
Buy
Dashboard
1-Click Reports
vadarsystems.com 25
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
IRR and xIRR in Excel
vadarsystems.com 26
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 27

More Related Content

From Spreadsheets to Systems

  • 1. ? 2017 NTLA and VADAR? Systems 1 From Spreadsheets to Systems C Lab 2 VADAR? Systems Jed Reitler, VP Business Development 10:30am Studio 1 Mar 2, 2017
  • 2. Challenges Spreadsheets Systems Solutions Q & A ntla.com | vadarsystems.com From Spreadsheets to Systems
  • 3. ^He's a genius investor, but God help his staff and his management skills. ̄ 3ntla.com | vadarsystems.com
  • 5. Challenges theNTLA.com | vadarsystems.com 5 How efficient is your office?
  • 6. Parcel Research Field Inspection Parcel Analysis LoC Payment Raise Capital Auction Bid Court Filing Fees Lender Reporting Load Acquisition Portfolio Organization Flags and Holds Owner Notices Court Notices Hold Notices Payment Plans Collections Cash Flow Analysis Assess Subsequents Load and Integrate Subsequents Integration and Valuation Analysis Audit Discrepancies Report Transactions to Auditor Rectify Lender Reporting Load Redemptions Review and Post Payments Report Cash Flow Analysis Report Redemption Curve Bankruptcy Foreclosure Title Clearing Legal Notices Court Filing Borrowing Base Reports Operational Review and Audit Bottom-Line Profit Analysis Adjust Investment Strategies 6ntla.com | vadarsystems.com Challenges
  • 7. 7 Various Statute Compliances Tracking and Reconciliation Parcel Data Management Collections and Notices Foreclosure and REO Legal Filing and Fees Custodial Services ntla.com | vadarsystems.com Challenges
  • 9. 10 Spreadsheet Sinkholes Cost Vulnerability Constrictive Dependence on a few constricts your flexibility Doesn¨t Scale Disproportionate overhead increases with your growth Slow Decisions Your financial decisions require instant information Prone to Error Common and costly errors with entry and formulas Prone to Fraud No controls of user roles and permissions Not Compliant Dodd-Frank and SoX require more Not Collaborative Budget, forecast, plan in silos Not Recoverable Lost when devices and networks fail Not Consolidated Different analyses, reports, versions, by many users Hard to Test Tracing formula logic takes thousands of manhours theNTLA.com | vadarsystems.com 9
  • 10. Spreadsheets ★ Systems ntla.com | vadarsystems.com
  • 12. Systems ? System: ^formulated, regular plan of procedure ̄ ? Repeatable processes in your organization? ? Do you have data in silos or a shared system? ? Minimize your overhead costs of´ theNTLA.com | vadarsystems.com 12 Error Loss Turnover Training Reporting Analysis Analysis Rework Audit
  • 16. Solutions 5 solutions to improve your system 1. Identify key stakeholders and unify their focus 2. Record operational challenges to identify the easiest and costliest to remedy 3. Know your vital data elements, where they are stored, and who controls them 4. Reduce redundancy by improving communications and interfaces between systems 5. Identify resources to leverage to implement new solutions (e.g. IT staff, software vendor, law firm)
  • 17. Solutions ?Enhanced cash flow ?Higher portfolio returns ?Increased revenue recovery ?Lower overhead costs of audits, information, and operations staff Out-Compete with real-time analytics and decision making leadership
  • 19. 3 Choices Build BuyServicer Their Strategy Less Control Basis Points Cost Over-Runs Never Finished IT Experts Your Strategy Configurable Scalable
  • 21. Build Build costs 180% more for 1/3 of the planned design.
  • 22. Acquisition Custodian Redemption Subsequents Enforcement Search Audit Instant Analysis Export Interface Dashboard Buy
  • 25. vadarsystems.com 25 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
  • 26. IRR and xIRR in Excel vadarsystems.com 26 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%
  • 27. 1-Year Return The Same Lien Feb 27, 2014 and Today 6.72% Rate of Return 2.83% Rate of Return vadarsystems.com 27

Editor's Notes

  • #2: Thank you. ? 30 minute conversation and 15 minutes of questions VADAR background: 20 years, $2B A.U.M., 100 clients. Jed background: Technology Business Development w/Northrop, Linksys, Cisco Systems We're here to talk Profit from Efficiency
  • #4: Investing and Business Management 2 different things
  • #5: Cost=Risk?and Slow Email isn't free. ?Risk of attachment errors and data loss. Excel isn't free. ?10 Spreadsheet Sinkholes. Laptop and PC storage risks losing it all. Worst of all are inefficient processes that add up exponentially faster than investment growth.
  • #6: What is your office¨s readiness? Time efficiency? Profitability?
  • #7: Does your back office look something like this? ?Common Characteristics 1. Compartmentalized or 1 person 2.Series and sequential vs. Parallel and real time 3.Audits require going over everything all over again 4. Slower analysis and decision making than the competitor
  • #8: Case by case and 1-person knowledge are costly, slow, risky Need to plan a central, cohesive process to scale efficiently, profitably Slow grooves become trenches and hard to change
  • #9: How much would one breach cost you?
  • #10: Vulnerable to Fraud. Over $1 Billion in fraud has been lost to date. Spreadsheets are vulnerable from a lack of controls. Common, easy formula/value alterations without detection. Susceptible to Human Error. Trivial human error (e.g. missed negative signs, misaligned rows) can not only cost $ in losses, but entire credibility with lenders. Difficult to Test. Almost impossible to test tables against the above. Worse, inter-related spreadsheets spread across folders and workstations. Worse still, tracing formula logic from one related cell to another can take thousands of man-hours. Non-Compliance. Financial regulations such as SoX, Dodd-Frank, and others affect spreadsheet systems. Databases to meet deadlines. Inflexible for Business. Competition requires agility, and adapting to change requires more than spreadsheets. Most spreadsheets are highly personalized and thus dependent on one person. What happens when they move on? Not Collaborative. Do you forecast, plan, or budget? All are collaborative and require different pieces of information from different sources. Multiple locations require even greater collaboration. Exchanging information by spreadsheet results in duplicated data and errors. Difficult to Consolidate. Analysis and reports are cumbersome, time-consuming, and prone to error because spreadsheets get used by different users in different ways. Consolidation requires reconfiguration C multiple times as information moves up the decision path. Slow Decision Making. Financial investments and auction acquisitions require fast decision making. Culling information from disparate spreadsheets, reconfiguring data sets, checking for errors, and translating for different groups slows decision making and gives the advantage to faster competitors. Financial models require system complexity and adaptability. No Data Recovery. When devices and networks fail C and they do C spreadsheets are often in the hands of non-IT personnel and have no data recovery when disaster strikes. Not Scalable. As investments grow and the business expands, spreadsheets are like molasses that spread and slow the organization, compounding the issues above.
  • #11: From 2D tables to 3D databases to 4D systems
  • #12: All in One SYstem Let visuals speak for themselves C represent wishes.
  • #14: 30,000 foot view of Tax Lien Servicing process. Plan an ideal process. Inefficiencies, redundancies, retraining, legal compliance, paperwork. Deming Plan/Check/Act. Feedback loop and improvements.
  • #16: PAR C Barrage of email attachments,Google Apps let them collaborate in real time on shared docs, Result of less email, less errors, better audit Share in Real Time, Increase Security, Reduce Errors, Save Time and Money
  • #17: 5-Step Office Improvement Unify focus of key stakeholders Identify easily corrected ops challenges Know your vital data owners and locations Integrate systems and limit redundant data Leverage solutions: collaboration, doc mgmt, workflow, etc.
  • #20: 3 Servicing Choices Serviders C beholden to their investment philosophy, with classic fee structure punitive to growth Build - $250,000 and 3 years earlier´ Buy C Take advantage of 20 years experience in 5 years of development. Scalable from institutions to individuals
  • #21: Their fee structure, their investment philosophy, their servicing systems
  • #22: Dire decision to do it all. Maybe lucky on scope and on budget. But then: IT costs, obsolescence, lose compatibility with other systems
  • #23: Home screen with powerful dashboard Instant overview of portfolio return, value, and status by fund
  • #26: 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
  • #27: Walk through the BIG differences between IRR and xIRR The reality is Tax Lien Investments have IRREGULAR time periods of cash flow. If you¨re not accounting for more than simple annualized IRR, you¨re imprecise and less than credible.
  • #28: A Year Before Today and Today Instant Return analysis