Real Estate Firms IT Systems Study - Pwc

Transcription InsightsPwC’s asset management perspectives and analysisReal Estate FirmsIT Systems StudyFebruary 2014

Table of ContentsReal Estate Firms: IT Systems Study ResultsPwCPageOrganizational Overview3General Ledger Systems Overview8Accounts Payable Systems Overview14Business Intelligence Overview182

Organizational OverviewPwC3

Organizational OverviewData from 42 real estate firms is included in this study.Property Sectors of ParticipantsMarket Cap Range of Participants50%Healthcare7%Mortgage 7%15%10%5%0%Less than 1BnPwC 1 to 5 Bn 5 to 10 BnGreater than 10 Bn4

Organizational Overview, cont’d# of People in IT Organization, by Sector# of IT Personnel100%90%Greater than 3010 to 30Less than 10100%% of IT ctorsHealthcare(3)Mortgage REIT(2)5

Organizational Overview, cont’d# of People in IT Organization, by Market Cap# of IT PersonnelGreater than 3060%56%10 to 30% of IT PersonnelLess than 1050%50%43%40%38%36% 36%30%29% 29%27%22% 22%20%13%10%0%Less than 1 Bn(13) 1 to 5 Bn(14) 5 to 10 Bn(8)Greater than 10 Bn(7)Market Cap RangePwC6

Organizational Overview, cont’dTitle for Head of IT Department45%Reporting Line %11%5%0%PwC11%8%10%3%3%15% 15%9%10%5%6%3%3%3%3%0%7

General Ledger Systems OverviewPwC8

General Ledger Systems OverviewGeneral Ledger Systems UsedOther*12%PeopleSoft5%MRI23%MS GreatPlains5%Lawson5%Solomon7%CTI9%PwCJD Edwards23%YardiVoyager12%* “Other” includes the following systems: Geneva, Hyperion, IBS, Oracle Financials, Timberline9

General Ledger Systems Overview, cont’dGL Systems - Internally Hosted vs.Outsourced, by Public vs. PrivateAre GL Systems Internally Hostedor Outsourced?InternallyHosted79%100%Internally Hosted90%80%Application Service vider21%PwC22%20%20%10%0%PublicPrivate10

General Ledger Systems, by ntial40%39%29%17%13% e REIT67%50%33%PwC33%33%50%33%11

General Ledger Systems, Public vs. PrivateGL Systems - Public vs. 15%12%10%9%10%6%10%10%6%5%3%3%0%JD sonMS GreatPlains12PwC

General Ledger Systems Overview, cont’dOut of the 42 real estate firms, 14 use a property managementsystem separate from their general ledger systemSector BreakdownMarket Cap BreakdownGreater than 10 29%Lodging/Resorts29%PwCLess than 1Bn36% 5 to 10 Bn14% 1 to 5 Bn36%13

Accounts Payable Systems OverviewPwC14

Accounts Payable Systems OverviewAccounts Payable Systems UsedOther37%Yardi PayPlus19%AVID Exchange14%OpsTechnology5%Nexus Payables5%PwCMRI7%JD Edwards14%* “Other” includes the following systems: AMSI ePO, Counselink, CTI, DocuSphere, Great Plains, Lawson,Market Basket, MCAP, Oracle Financials, Oracle IPM, PeopleSoft, Salesforce, VIP-II, PayScan, Solomon15

Accounts Payable Systems Overview, cont’dAP Systems - Internally Hosted vs.Outsourced, by Market CapAre AP Systems Internally Hostedor Outsourced?Internally 60%50% 50%50%40%33%30%InternallyHosted68%Application Service Provider25%29%20%10%0%Less than 1 BnPwC 1 to 5 Bn 5 to 10 BnGreater than 10Bn16

Accounts Payable Systems, by 17%4%HealthcareMortgage REIT100%40%20%PwC20%20%33%33%33%17

Business Intelligence OverviewPwC18

Business Intelligence Systems Overview40% of the real estate firms have a data warehouse and a businessintelligence tool for operational and financial reporting50%40%30%20%10%0%General Ledger Systems Used by Clientswith Data Warehouse46%MortgageREIT8%23%15%JD EdwardsMRICTI8%8%OracleFinancialsGenevaBusiness Intelligence Tools Usedby Clients with Data WarehouseInsight17%Other*53%PwCSector BreakdownSQLReportingServices18%Crystal12%*Other includes the following tools: Discoverer, GLI Reporting, .NET,FASTR, WorldWriter, Hyperion, TM1, BI-Informatica, ial15%Retail23%Market Cap BreakdownLess than 1 Bn23%Greater than 10Bn15% 1 to 5 Bn15% 5 to 10 Bn46%19

PwC ContactsScott

This publication has been prepared for general guidance on matters of interest only, and doesnot constitute professional advice. You should not act upon the information contained in thispublication without obtaining specific professional advice. No representation or warranty(express or implied) is given as to the accuracy or completeness of the information containedin this publication, and, to the extent permitted by law, PricewaterhouseCoopers LLP, itsmembers, employees and agents do not accept or assume any liability, responsibility or duty ofcare for any consequences of you or anyone else acting, or refraining to act, in reliance on theinformation contained in this publication or for any decision based on it. 2014 PricewaterhouseCoopers LLP. All rights reserved. In this document, “PwC” refers toPricewaterhouseCoopers LLP which is a member firm of PricewaterhouseCoopersInternational Limited, each member firm of which is a separate legal entity.PwC21

Accounts Payable Systems Overview 15 Yardi PayPlus 19% AVID Exchange 14% JD Edwards 14% MRI Nexus Payables 7% 5% OpsTechnology 5% Other 37% Accounts Payable Systems Used * “Other” includes the following systems: AMSI ePO, Counselink, CTI, DocuSphere, Great Plains, Lawson,