The MISMO rent roll and operating statement committee which I co-chair finished its work on the XML schema today (thanks to all committee members!).
The schema we propose is capable of handling all common data templates for both Rent Rolls and Operating Statements. The schema will be made public around the first of the year for its 30 day Intellectual Property Review period and then, hopefully, be ready for finalization by the MBA CREF Conference in early February.
MISMO’s goals for 2010 include promoting the adoption of these standards as an essential part of improving risk management, investor reporting, and compliance with the new transparency requirements of the pending financial reform legislation.
Some color on the two schemas:
The biggest concept of the rent roll schema is Rent Roll Template Type. We came up with four templates that are commonly used to handle commercial properties, multi-unit properties (in both summary and detail mode), hotel properties and healthcare. The data schema will support all the essential data elements for the major property types. Specifically: retail, office, industrial, apartments, mobile homes, self storage, hotels, assisted living and skilled nursing properties are covered.
The biggest concept in the Operating Statements schema is also the concept of template types. Unlike the four templates that were needed for rent rolls, we have already needed 10 templates for op statements. The goal is to have an all-encompassing list of NOI categories (the current list has 234 items) and then provide templates that can roll up by user group. Of the 10 we have already planned for, we have eight to support the CMSA’s IRP templates, and we plan to have one each for Freddie Mac and Fannie Mae. Unlike the data for rent rolls, the list of NOI categories is endless so we went with a roll up approach with easy template expansion capabilities.
I’ll post the final package on this site when it is ready.
— — —
Jim Flaherty is CEO of CMBS.com and the creator of the Backshop loan origination system. He is a trained credit professional with experience installing enterprise underwriting systems for commercial real estate lenders, rating agencies and investors.