A pair of securitization services companies collaborated on the creation of a tool for commercial real estate investors that utilizes Microsoft (MSFT) Excel spreadsheets to analyze a variety of real estate performance metrics. Rockport Group software firm created the tool for customers of commercial mortgage-backed securitization (CMBS) data, analytics and software provider Trepp LLC to provide greater transparency to the commercial real estate debt markets, the companies said. The Excel spreadsheets are available through a subscription to Trepp’s data and analytics services, and allows clients to review property cash flows, calculate year-over-year trends and perform discounted cash flow analysis on investments and prospective transactions. “Trepp LLC and Rockport are committed to providing CMBS and distressed debt investors with a robust tool to help further their investment diligence. We are proud to announce that not only can the loans now be analyzed quickly and thoroughly in Excel, but that the detailed financial statements will also be available,” said Rockport managing director Will Trepp. Write to Austin Kilgore.