This document summarizes a presentation about moving from using spreadsheets to systems. It discusses the challenges of spreadsheets, including errors, lack of controls, inability to collaborate, and inability to scale. It then discusses how systems can provide solutions like standardized processes, shared data, real-time analytics, and reduced costs. Specific solutions proposed include identifying stakeholders, recording challenges, understanding key data, reducing redundancy, and identifying implementation resources. The presentation concludes by comparing building a custom system, buying an existing system, or using a third-party servicer.
1 of 27
Download to read offline
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
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
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
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
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
#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.
#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