Login     Register

        Contact Us     Search


iStar Financial

iStar Financial uses XLeratorDB to move its internal analytics from Excel to XLeratorDB

iStar Financial

When senior executives at iStar Financial meet for strategic planning, their focus almost always includes a review of numbers. A leader in commercial real estate investments, it has completed more than $35 billion of commercial real estate investments over the last two decades to become one of the most experienced companies in the U.S. commercial real estate finance markets.

iStar says it provides a Return on Ideas.

“We believe that great ideas, developed by great people, generate great returns.”

Reporting – transforming data into usable information – is key to increasing our effectiveness, said Philip Burke, iStar’s CIO. One of IT's consistent goals is to streamline processes while producing clean data that executives can rely on for decision-making without wondering where it came from, or how accurate it is.

“When you contrast today against the go-go-go days like 2007, back then it was just trying to get out of the way. Now we have created a number of systems to automate our processes. It is tough to be under that pressure and given that opportunity in IT, but it is interesting to be part of the company's productivity story.”

While Excel can be an essential tool for many internal analytics and projections, iStar realized that for its most sophisticated and critical models it needed something more robust. As firms across multiple industries from manufacturing and retail to financial services have learned, heavy reliance on Excel can lead to 'multiple versions of the truth'. One common result is business meetings that often start with dueling spreadsheets to decide who has the most useful numbers.

With $6 billion of commercial real estate assets to manage, iStar’s senior management team has better uses of their time than debating figures in multiple spreadsheets. The company invests across its four business lines: real estate finance, net leasing, operating properties and land.

For each project iStar creates an extensive asset summary that is part of its risk rating process.

“We rate our assets’ risk parameters every quarter on a scale of 1 to 5 based on our assessment of potential risk,” he explained. “Part of that process involves projecting total returns (IRRs) based on actual results to date and projected performance.”

“Before we acquired XLeratorDB, that component of our analyses was done offline on Excel,” says Burke.

The models were distributed throughout the company, and each asset manager in each region had different ways of using the models.

“It was impossible to really confirm that numbers had been updated and reflected the most current projections, because all you would see was the resultant number.

The metrics -- projected IRRs, projected multiples and earnings multiples -- were for internal purposes, he added. The shortcomings of Excel led to an internal managerial push to improve.

“The process was inconsistent, there was no visibility,” he added. If quarterly projections were not updated in Excel, that would not necessarily be apparent to headquarters which simply took the regional numbers and plugged them in to the database.

“We needed to correct this without implementing a quality control process that would eat up time.”

The company looked at two solutions before selecting XLeratorDB.

“It has been very useful in ensuring that our projections are more accurate because now we can dovetail our historical and projected performance and you can see any disconnect quite quickly.”

With XLeratorDB, cash flows are pulled from historical transaction systems and projections into the database and from there they stream into the report seamlessly. The combined cash flows are auditable and available online, and they are consumed by senior managers, the CEO and the executive committee.

“The process is faster, more accurate and we have control of the data from start to finish,” Burke added.

It is also much more efficient, important in a time when companies face pressures on margins.

“Every dollar counts now, and clean and accurate information in the hands of management is incredibly critical,” said Burke. “This management team needs to understand the risk/reward of every opportunity and structure in order to capture the best risk-adjusted returns. Being able to run many scenarios efficiently has increased our computational horsepower. It is all about how to invest that next dollar, what is our real return going forward, is it better to invest in project A or look at other projects with a higher rate of return.”

“Further it’s helped productivity as well. Now all of our reporting groups across the company are working from the same set of numbers in real time, cutting down on countless hours spent reconciling.”

With current reporting running smoothly, the next project using XLeratorDB is to create a historical asset return database, said Burke.

“We have purchased and managed hundreds of loans and assets for which all the asset cash flows and return data are stored separately in a spreadsheet somewhere. Now we are converting all the data into SQL and calculating the metrics.”

The first step is collecting cash flows into a single system for a single version of the truth, he added. Then iStar will provide the ability to slice and dice those historical cash flows and any other attributes such as region, property type, asset manager, and asset type such as senior debt, mezzanine debt or equity.

“It will be unbelievably powerful in understanding our historical performance. And with that, we can make better decisions going forward -- why were certain regions better performing than others, which borrowers stood behind the projects and which walked away? Which strategies proved most efficient for selling condominiums?

Internally, he has received positive feedback over XLeratorDB from people in operations. The company has reduced staff but still maintains strong demand for information, so technology has to take on the extra work.

“Information is more critical than ever. Through projects like these we are able to automate a lot of processes and give people back their time so they can do work that provides a higher rate of return.”



Featured Client List

XLeratorDB has rapidly built a broad global customer base spanning more than 40 countries and 30 US states, including innovation leaders such as:


Financial Services

Government

Software/Consulting

3Point Asset Management
Access Capital Advisors
Alchemy Capital Management Pvt. Ltd.
AlixPartners LLP
Ally Bank
Alphametric Research, LLC
AEW Capital Management
Alpha Card Services
AMBIT Capital Pvt. Ltd.
American Capital
AnaCap Financial Partners LLP
Annaly Capital Management
Apollo Global Management
AutoCont SK
Avenue Capital
Axis Bank
Babson Capital Management LLC
Bain Capital
Bankers Healthcare Group, Inc.
Barclays Securities India Pvt. Ltd.
BBR Partners
Bessemer Ventures
Birla Sun Life Asset Management
Black Diamond Capital Management
BOCI-Prudential
California Republic Bank
Centerbridge Partners LP
Citigroup (IND)
Cliffwater LLC
Convergence Investment Partners
Crews & Associates, Inc.
DBI Capital Market Services Ltd
Desjardins (CAN)
Eastwood Bank
EBS Asset Management
Ellington Management
Emirates Investment Bank
Enam Securities
Entente Fund Accounting Services
Eton Advisors, LP
Fir Tree
First Gulf Bank
Fred Alger
Fusion Ventures  (case study)
GARANTI BANK SA
GEPL Capital Pvt. Ltd.
Gimv (BEL)
Golden Tree Asset Management LP
Goldman Sachs Securities India Pvt Ltd.
GRAMIT S.A.
Hamilton Lane
Harbourvest Partners, LLC
Harvest Investments
Henderson Global Investors
Henninger Investments
Highland Capital
HighVista Strategies LLC
Horizon Credit Union
Hudson Advisors
Hyuandai Securities
ICICI Bank
IIFL (IND)
IndexUniverse, LLC
Infoweaver Services AB
ING Vysya bank
Jasper Ridge Partners
Javlin Capital
JM Financial Pvt. Ltd.
Karma Capital Advisor Pvt. Ltd.
Keytrade Bank
Killik & Co
Kotak Mahindra Bank Ltd.
L&T Capital Company Ltd.
Landmark Dividend LLC
Landsdowne Partners
Liberties Investments Limited
LPL Financial
Mariner Investment Group
M. B. Commercial Company Limited
Mid Atlantic Capital Group
MidAtlantic Trust
Moneta Group
Morgan Stanley
Morgan Stanley (I) Financial Services
Neue Aargauer Bank
Nilta Corp
Nordea Investment Funds S.A.
North American Savings Bank
Notz & Stucki (CHE)
PanAgora
Postbank
Prescott Securities
Prime Broking Company Ltd.(IND)
Principal PNB Asset Management
Principal Retirement Advisor Pvt.Ltd
Professional Capital Services
Profidebopt, s.r.o.
PT Otto Multiartha
MTAG Services LLC
Oak Hill Investments
Oaktree Capital
Prescott Securities (AUS)
Qatar Development Bank
RDV Corp
Republic Mortgage Home Loans
RMB (ZAF)
Samuel E Ramirez & Co.
Santandar (BEL)
Santandar Consumer Finance Benelux B.V.
SAR Capital Pvt. Ltd.
Sarasin-Alpen (India) Private Limited
Saunderson House Ltd
Savant Capital
SBAB (SWE)
The Sentient Group (AUS)  (case study)
Sequoia Heritage
Sontag Advisory
Sprism Investment Services Pvt. Ltd.
Standard Chartered (IND)
Sunrise Capital Partners
Taom Capial UK Ltd.
Titan Advisors
TPG Credit Management, LP
T. Rowe Price Associates, Inc.
Trustline Holdings
Tufton Oceanic
Turner Acceptance Corp
United Acceptance
Value Prolific Investment and Consulting
Vericrest Financial Inc
Von Braun&Schreiber (DEU)
Watts and Associates
WealthTouch
Wedbush Securites
Westdale Capital
Central Bank of Iceland
City of Toronto (CAN)
DBC Onderhoud (NLD)
Lee County Schools
NSW Cancer Institute (AUS)
PSP Investments (CAN)
Reserve Bank of Fiji
State Teachers Retirement System - Ohio
SPAWAR System Center Atlantic
US Department of the Interior
US Navy

Insurance/Healthcare

Advisory Board Company
Aegis London (GBR)
Aeolus Re (BMU)
Alterra Capital Services
Ameritas
Arch Reinsurance Ltd.
Capital & Coast District Health Board
Cathedral Underwriting Ltd
Child Health Corporation of America
Dr.Foster Intelligence
Goss Re
KaufmanHall
MetLife
Oil Insurance Ltd (BMU)
Oil Management Services
Starr Companies
XL Group
XL Insurance

Energy

Chevron
Consolidatd Edison
SPARQ Solutions Pty Ltd (AUS)
Unit Corporation

Real Estate

CapMan Oyj (FIN)
Helios AMC
iStar Financial  (case study)
Landmark Partners
London & Quadrant (GBR)
Newland Communities  (case study)
Northstar Realty Finance Corp
Townsend Group
Alpha Kinetic (GBR)
AssetLabs
Autocont SK
Bits Software
Cadis EDM (GBR)
CPACINC
Cybercom
DataAgent
Derive Technologoes
Enerpact LLC
EvalSolutions  (case study)
Farsight Consultancy Services
Ferman Automotive Management Services
Fortigent
Genpact
Hewlett Packard India Sales Pvt. Ltd.
Ingram Micro
Kenexa
Milessoft (IND)
ModelLogic
Netage Solutions
Pangea3 Legal Database Systems Pvt. Ltd.
Paylink Payment Plans
Portfolio Pathway
PSD Solutions
Rehfeld Partners A/S
Respec
SAIC
Software Guru
Sterknetwerk BV (NLD)
Supply Chain Strategy Services
Surehits
Tata Consultancy (IND)
Venture Allies
Verde International  (case study)
Via Binary

Other

BlueSun Inc.
CreditMax Auto Group
Firebrand Technologies
GRAINGER
HarperCollins Publishers
Houghton Mifflin Harcourt
The High Companies
Kemper Valve & Fittings Corp
LeahMaya Limited
Optionline
right stuff detailing
West Pak Avocado
West Valley Construction
Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service