The Chicago-based Institute of Real Estate Management (IREM) has recently released a new Financial Analysis Spreadsheet to help real estate and asset managers evaluate the performance of their properties. According to IREM, “Once performance data is input into the appropriate cells of the spreadsheet, it automatically amoritizes and analyzes property loans; arrives at net operating income (NOI) based on property income and expenses; calculates cash-on-cash return, value enhancement, net present value (NPV), and internal rate of return; creates T-bars to visualize income stream; and establishes market rental rates using a comparison grid.”
The IREM Financial Analysis Spreadsheet enables users to determine property performance based on owners’ goals and objectives, and is available free to IREM members and for $19.95 for non-members. The spreadsheet is accompanied by a “Spreadsheet Essentials” document detailing the technical requirements and instructions for usage. To find out more or purchase the Financial Analysis Spreadsheet, visit (www.irem.org) or call (800) 837-0706.