Abstract:
Deployment of a computer program including a global NOI audit model together with standards, procedures, documentation, and reporting requirements in interactive, digital form to a plurality of audit firms operating independently of each other and having a reporting relationship with an investment entity. The program is adapted for receiving audit data from a respective audit firm in connection with an associated real estate property and for generating an associated respective Current NOI audit report. The specific fields and screen arrangements, together with interactive instructions and definitions of the program require that each audit firm identify a consistent set of input parameters and apply them in a consistent way, as driven by the global audit model, thereby assuring computation and transmission of structurally consistent Current NOI audit reports to the investment entity, wherein the Current NOI calculations have been developed by substantially identical audit practices, procedures and assumptions. Using the same program, the investment entity then calculates and stores an Underwriting NOI set of values corresponding to each Current NOI report for the purpose of investment evaluation. The program generates a consolidated report of both Current and Underwriting NOI values for all of the plurality of audit firms so that the investment entity can effect a uniform analysis of all investment properties under consideration.

Description:
BACKGROUND OF THE INVENTION 
       [0001]    1. Field of the Invention 
         [0002]    The present invention relates to real estate property investment techniques and more particularly, to the performance of audits for a plurality of real estate properties and in particular, to a method and computer program product for enabling substantially identical current net operating income audit practices among a plurality of audit firms so that resulting audits calculated by the firms can be efficiently evaluated by a common investment entity. 
         [0003]    2. Description of Related Art 
         [0004]    The determination of current net operating income (NOI) of a commercial property is a key factor in the underwriting process for new loans or modifications of existing loans. A general definition of the net operating income of a property is the income projected by the income-producing property after deducting losses for vacancy, collection and operating expenses. In more detail, net operating income for any period is the gross income less expenses, including property taxes, reasonable maintenance and operating expenses, and the amortized cost of capital improvements. Gross income is generally defined as the total of the gross rents lawfully collectible from a property, plus any other considerations received or receivable for, or in connection with, the use or occupancy of rental units and housing services (including other consideration such as, for example, from laundry, parking, or any other facilities or fees). 
         [0005]    Net Operating Income (NOI) audits are performed as part of the due diligence process for most new investment transactions and to audit on-going property performance. Although an NOI audit can involve a variety of processes, typically, the NOI audit involves: 1) a review of all or a significant sample of leases, 2) a revenue reconciliation, 3) cash receipts testing, and 4) operating income and expense analyses. The findings disclosed during the NOI audit enable the investment entity to make a reliable determination of in-place net operating income, which provides the basis for a sound investment decision. 
         [0006]    Usually, NOI audits are performed in connection with commercial properties such as, for example, office, industrial, retail properties and non-commercial properties, such as multifamily and self storage properties, although other types of properties can be involved. 
         [0007]    A procedure found to be generally acceptable by the industry calls for NOI audits to be conducted after receipt of a signed loan (or equity) application and good faith deposit, but before submission of a request for credit approval. In such a procedure, transactions which are approved subject to the completion of NOI audits must have NOI audits completed and approved prior to initial transaction funding. 
         [0008]    Depending on how the investment entity is organized, NOI audits may be performed by approved outside accounting firms, or audit firms, having a contractual relationship with the investment entity, so that the investment entity is able to meet its investment targets and cycle time objectives. In such instances, audit firms would be approved on the basis of, for example, staff size, qualifications of staff members, real estate experience, capabilities concerning turnaround time, and fees. Real estate deal leaders or due diligence coordinators of the investment entity typically provide the outside audit firms with all information and support which is necessary to conduct a complete and efficient audit. Conversely, the audit results delivered in return should conform to the investment entity&#39;s expectations and standards so that the results can be accepted with the presumption that all required parameters and assumptions are included in the underlying calculations. 
         [0009]    This becomes a serious problem in instances where numerous audit firms are involved, each performing one or more respective property audits, and especially where each firm is geographically separate from the investment entity location and possibly philosophically at odds with the prevailing philosophy of the investment entity. Inevitably, individual practices evolve, or creep into, the NOI audit procedure conducted by contractor audit firms, the effect of which, in some instances, may be difficult for the investment entity to initially recognize, and may contribute to errors in investment judgment, as defined by the policies and objectives of the investment entity. Such individual practices, if not explicitly indicated, may remain undetected, or be misunderstood, during review and comparative evaluation by the investment entity. For example, undetected assumptions made in the underwriting NOI calculation might include, but are not limited to, lower than current occupancy rates, changes in tax liability, or growth of capital reserves. Such assumptions might be incorporated into the NOI calculation, but not given an appropriate level of visibility or notice and go undetected by the reader. This can lead to disastrous consequences in terms of evaluating potential real estate investment. On a more prosaic level, the format, arrangement, and content of the audit reports can vary widely among audit firms, leading, at least, to difficulty of review by the investment entity and inconsistency in results. 
         [0010]    A primary object of the present invention is to provide a system and method for achieving uniform implementation of policy, procedure, current NOI calculation, and reporting among a plurality of audit firms having a reporting relationship with a common investment entity. 
         [0011]    Another object of the present invention is to provide an NOI audit model, which includes an interactive computer program that makes readily available to the user during the performance of an audit, an audit policy, guidelines, detailed instructions and definitions, together with an NOI calculating module and a reporting module, that are amenable to orderly extension to accommodate unique aspects of one or more investment properties. 
         [0012]    Still another object of the present invention is to provide in a single computer program a global audit model that includes a Current NOI calculation module and an Underwriter NOI calculation module which operate from a common data model. 
         [0013]    A further object is to provide the global audit model of the present invention in the form of a product to be distributed over a network such as the Internet or by a recording on stored data media. 
       SUMMARY OF THE INVENTION 
       [0014]    These and other objects of the present invention are provided by a method, a data processing system and a computer program product for enabling substantially identical current net operating income (NOI) audit practices employed by a plurality of audit firms operating independently of each other and having a reporting relationship with a common investment entity. A uniformity of procedure is accomplished, which combines audit procedures, required document checklists, data input, schedule output, and “helpful hints” and definitions, together with an interactive global NOI audit computation model in one integrated, interactive application. Advantageously, it is the integrated aspect of these components provided in an interactive, computer-based form, together with an NOI audit computation model, that enables a single investment entity to obtain uniform audit results from a plurality of audit firms, each performing audits of a respective commercial real estate property by using a deployed copy of the computer program. As a result of each respective audit firm having interactive access to all standards, procedures, and methodologies during the course of operating, and providing input to, the NOI audit model, the investment entity is able to obtain consistent audit results across all respective audits, with respect to data considered, underlying assumptions, accounting techniques, and report format, even though the audit firms function on an independent basis. 
         [0015]    The foregoing objects of the present invention are met by a method and product that identifies a specific set of information according to specified criteria and definitions. The information is inputted into a computer program for calculation and development of a Current NOI set of values. The same program is used to subject the Current NOI set of values to a second set of underwriter information for calculation of an Underwriter NOI set of values. 
         [0016]    According to the present invention, a standard, global NOI audit model is provided as part of each copy of a deployed computer program. The global NOI audit model is an analytical tool which has been designed to facilitate the process of auditing and audit reporting. As such, the model contains a listing of audit procedures, data input areas, standard reports and schedules including Current and Underwriting NOI summaries, and clarifying notes to schedules and input areas. 
         [0017]    The global model is not intended to replace the skilled auditor, and therefore, does not function as an expert system capable of operation by one not trained in the audit field. The global NOI audit model is used by the audit firm responsible for performance of the audit of a specific real estate property to determine a set of Current NOI values and to identify and communicate potential issues that may be of interest to the investment entity employer. The same global NOI audit model is also used by the investment entity to determine a corresponding set of Underwriting NOI values for that same real estate property. The set of Underwriting NOI values are calculated from quantitative departures from the set of Current NOI values, and both are expressed in terms of respective Current NOI reports and Underwriting NOI reports produced by the computer program of the present invention. 
         [0018]    Use of deployed copies of the same computer program, while possibly simplistic in itself, rises to a unique application in the commercial real estate investment industry, which is inherently subjective and replete with independent practices and procedures, and therefore, subject to subtle, but important, differences in the calculated results, depending on the choice of data, assumptions made, specific calculation model used, and a myriad of other options available to the audit firm performing the initial NOI audit. Advantageously, implementation of the specific NOI audit model of the present invention, which requires adherence to a set of standards, definitions, and procedures, together with common deployment of such a system to independent audit firms, enables the investment firm recipient of the results produced by those firms to perform a reasoned decisional analysis of several commercial properties to determine in which property an investment should be made or maintained. 
         [0019]    The system and method of the present invention may be used by a plurality of audit firms employed by a single investment entity, each performing respective audits of respective properties and completing summary reports and schedules as directed by the global NOI audit model. Notwithstanding the use of the global NOI audit model, however, it is understood that auditors are expected to use sound judgment and practices in conducting the NOI audit. The auditors are also expected to disclose, by way of audit documentation provided by the computer program, any deviations from the procedures outlined in the model. In addition, provision is made so that any further exhibits or schedules necessary to support or explain operating performance or deviations from the procedures outlined in the NOI model are disclosed and included with the final audit documentation. 
         [0020]    The method of the present invention includes the step of deploying a computer program that includes global NOI audit model, together with standards, procedures, documentation, and reporting requirements in interactive, digital form. The computer program is adapted for receiving a first respective input data in connection with the respective real estate property and generating an associated respective Current NOI audit report. To accomplish this, the respective audit firm using the deployed computer program enters data according to the prescribed procedures and documentation. The specific fields and screen arrangements of the program are such that all respective audit firms, although each individually auditing a relatively unique property, with potentially unique attributes, nevertheless, identify a consistent set of input parameters and apply them in a consistent way, as driven by the global audit model of the present invention. The system is flexible in that the report format can be extended in an orderly fashion to accommodate the peculiarities of any given audit situation. The investment entity is thus assured that each respective Current NOI audit report received in digital form is developed by substantially identical audit practices, procedures and assumptions. 
         [0021]    The method of the present invention further includes the step of generating a respective Underwriting NOI audit report for each received respective Current NOI audit report. This Underwriting audit report is calculated from a second respective input data applied to the global NOI audit program by the investment entity. This second respective input data includes assumed values corresponding to, and overriding, selected portions of the first respective input data. In other words, the assumed values are “what-if” values that take into consideration significant departures from the underlying data supporting the Current NOI audit calculation. Such departures include, for example, a lower, more conservative occupancy rate of a rental property, an increase in tax rates applicable to the property, or a sudden drop in capital reserves. The resulting NOI calculation, called the “Underwriting NOI” calculation, is inherently a conservative calculation due to the nature of the input, and may comprise a series of such calculations, each incorporating a different set of assumptions. Of course, an “optimistic” report may be derived by using an Underwriting NOI calculation with “what if” values reflecting maximum or high occupancy, lowering of tax rates, or an increase in capital reserves. 
         [0022]    The second respective input data is input by the investment entity to a copy of the global NOI audit computer program configured to be running a particular Current NOI audit report provided to the investment entity by an audit firm. The corresponding respective Underwriting NOI audit report is developed under the input and direction of the investment entity, and, taken together, all such respective Underwriting NOI audit reports share common auditing assumptions and data collection practices by virtue of software-driven common practices. This uniformity of audit practices is critical to the investment entity practice of comparing such reports to determine, or maintain, an investment strategy. 
         [0023]    The present invention further includes the method of use from the perspective of an audit firm using the present invention. In that context, the method of the present invention includes the step of inputting respective first input data by at least one of the plurality of audit firms to a respective deployed copy of the computer program, wherein the respective first input data is in connection with an associated real estate property. The method further includes the step of providing to the investment entity at least one respective generated Current NOI audit report generated by the respective copy of the deployed computer program used by the audit firm and reflecting the received respective first input data. 
         [0024]    The present invention also includes the interactive computer program configured to operate as above-described, and as a product including the program stored in memory or on data media, such as magnetic or optical data storage media, or alternatively, transmitted over a network, such as, for example, a closed network such as a local area network or an Intranet, or an open network such as the Internet. 
     
    
     
       BRIEF DESCRIPTION OF THE DRAWINGS 
         [0025]    The above and other features of the present invention and the attendant advantages will be readily apparent to those having ordinary skill in the art and the invention will be more easily understood from the following detailed description of the preferred embodiments of the present invention, taken in conjunction with the accompanying drawings. 
           [0026]      FIG. 1  is a simplified block diagram of a system configured to employ the present invention; 
           [0027]      FIG. 2  is a simplified flowchart of the method according to the present invention; 
           [0028]      FIG. 3  is a simplified flowchart of method  200  showing the method performed by each audit firm according to the present invention; 
           [0029]      FIG. 4  is a simplified schematic of the contents of storage media product including a stored interactive computer program according to the present invention; 
           [0030]      FIG. 5  is a simplified block diagram of the four major sections of the global audit program accessible by the user according to the present invention; 
           [0031]      FIG. 6  illustrates an example user-accessible menu of Data Input areas logically arranged in four Sections A-D according to the present invention; 
           [0032]      FIG. 7  illustrates an example user-accessible input screen according to the present invention; 
           [0033]      FIGS. 8A and 8B  illustrate an example Current NOI Audit Summary report showing example data associated with a commercial rental Office Building; 
           [0034]      FIGS. 9A and 9B  illustrate an example of an Underwriter NOI Audit Summary report corresponding to the report shown in  FIGS. 8A and 8B ; 
           [0035]      FIGS. 10A and 10B  illustrate an example Current NOI Audit Summary report showing example data associated with a non-commercial rental Apartment complex; 
           [0036]      FIGS. 11A and 11B  illustrate an example of an Underwriter NOI Audit Summary report corresponding to the report shown in  FIGS. 10A and 10B ; 
           [0037]      FIGS. 12A and 12B  illustrate an example Consolidation NOI Audit Summary report according to the present invention. 
       
    
    
     DESCRIPTION OF THE PREFERRED EMBODIMENTS 
       [0038]      FIG. 1  is a simplified block diagram of an environment configured to employ the present invention, showing investment entity  10  and a group of audit firms  12 , including firms  12 ( a , b, . . . n), each having a reporting relationship with investment entity  10  and being in data communication with entity  10 . The data communication can take any form, and preferably, is a digital communication including the Internet  14 , or alternatively, a portable data storage medium  16  such as, for example, a magnetic disk or CDROM. Investment entity  10  includes a computer  18  and each audit firm has a respective computer  20 ( a , b, . . . n), all computers  18  and  20 ( a , b, . . . n) running copies of the same global NOI audit program  22 . Alternatively, Internet  14  can be, for example, a closed network such as a local area network, a wide area private network. 
         [0039]      FIG. 2  is a simplified flowchart of method  100  according to the present invention, showing the method performed by the investment entity  10 . Method  100  enables an investment entity  10  to ensure that procedurally substantially identical current net operating income (NOI) audit practices are employed by the plurality of audit firms  12 ( a, b, n ) having an operating relationship with investment entity  10 . Each of the plurality of audit firms  12 ( a, b . . . n ) is arranged to conduct a respective audit of a respective real estate property for the purpose of generating an associated set of Current NOI values. 
         [0040]    The first step  102  is deploying respective copies of the global NOI audit computer program  22  to audit firms  12 ( a , b, . . . n). The deployed copies of the computer program  22  include an interactive global NOI audit model and digital standards, procedures, documentation, and reporting requirements. The deployed computer program  22  is adapted for receiving a respective first input data entered by an associated audit firm  12 ( a , b, . . . n) in connection with the respective real estate property. The computer program  22  is configured to generate a respective Current NOI audit report associated with the respective real estate property, based on the entered input data. 
         [0041]    The second step  104  is receiving by the investment entity  10  at least one respective Current NOI audit report generated by the global NOI audit computer program  22 , and third step  106  is generating a respective Underwriting NOI audit report based on a received respective Current NOI audit report. Preferably, the respective Underwriting NOI report is generated by investment entity  10 , using the global NOI audit computer program  22 . Another agency, such as a designated audit firm, could generate the respective Underwriting NOI report using the NOI audit computer program  22 , and then report the results to the investment entity. 
         [0042]      FIG. 3  is a simplified flowchart of method  200  according to the present invention, showing the method performed by each audit firm  12 ( a , b, . . . n) that has a relationship with investment entity  10 . Step  210  is inputting respective first input data by at least one of plurality of audit firms to a respective deployed copy of the computer program. Step  220  is providing to the investment entity  10  at least one respective generated Current NOI audit report. 
         [0043]    Upon receipt of Current NOI audit reports, each of which typically includes workpapers indicating the underlying data and commentary, deal leaders or due diligence coordinators of the investment entity thoroughly review the audit reports. The Current NOI audit reports (and particularly risks to a property&#39;s income and expenses) are discussed with underwriters to assist them in formulating an associated Underwriting NOI. The underwriters consider the Current NOI audit reports in structuring transactions and disclose results in credit requests for evaluation in the credit approval process. 
         [0044]      FIG. 4  is a simplified schematic of the contents of a storage media product  32  including a stored interactive computer program  22  for generating at least one underwriting net operating income (NOI) set of values based on a respective Current NOI set of values determined as part of a corresponding NOI audit of a real estate property. Program  22  includes a first input module  24  for receiving input of at least one first information and generating from that at least one first information a Current NOI set of values. Program  22  also includes a second input module  26  for receiving input of at least one second information and combining the at least one first and the second information to generate at least one calculated set of values. Program  22  further includes a calculating module  28  for calculating from the at least one calculated set of values an Underwriting NOI set of values. And lastly, program  22  includes an output module  30  for output of at least one of the Current NOI set of values and the Underwriting NOI set of values. In the preferred embodiment, modules  24 - 30  are embodied in a spreadsheet program, and as such, are an integrated function of the spreadsheet computation model. Other well known program models are envisioned, such as one or more data bases operating in conjunction with a commercially available programming language, such as, for example, Visual C++(TM of Microsoft Corporation). 
         [0045]    In the preferred embodiment, the first information provided by the audit firm includes, for example, static and historical information including deal data, general asset data, and prior data, as well as income information and expense information. The income information includes optional commercial rental income data and commercial lease testing data, optional non-commercial lease testing data, commercial recovery analysis data, percentage rent testing data, and non-commercial income data. Other income data can also be included. 
         [0046]    In the preferred embodiment, the expense information includes real estate tax bill data, tax bill data, insurance data, utilities data, repair and maintenance data, service contract testing data, management fee data, general and administrative data, advertising and promotion data, professional fees and services data, payroll expense data, payroll testing data, and non-operating expense data. Other expense data can be included. 
         [0047]    The second information includes at least one data value representing an adjusted value provided by the underwriter. The first and second information are automatically combined by application of the at least one data value to all pertinent stored values of the computer program for automatic generation of at least one Underwriting NOI set of values. 
         [0048]    In contrast to some traditional real estate property investment underwriting techniques, the method of the present invention is based on the premise that the due diligence responsibility is held by the underwriting organization, which preferably is a part of the investment entity. In contrast, certain underwriting aspects traditionally have been performed by the audit firm that performs the audit, thereby mixing the audit firm&#39;s responsibilities among Current NOI and Underwriting NOI calculations. In the present invention, the clear demarcation of responsibilities provides for clarity, accountability and consistency. In addition, the audit firms identify economic (e.g., rent increases) and non-economic (e.g., lease clause) “red flags” in conformance with data input areas of the Current NOI audit portion of the global NOI audit program. Where appropriate, the audit firm provides to the investment entity an advance notice of a critical finding in advance of final audit results. 
         [0049]    The auditor is responsible for obtaining a rent roll, for tying economic terms to leases, and documenting all “red flag” items in connection with all leases. Later, after the Current NOI audit report is delivered to the investment entity, the underwriter of the investment entity reviews all major leases plus any additional leases deemed appropriate and highlighted for review by the audit firm. 
         [0050]    In the preferred embodiment of the present invention, the global NOI audit program is obtained by programming a spreadsheet, such as, for example, Excel (Trademark of Microsoft Corporation). Sections of the model are organized by “worksheets”, which are identified by “worksheet tabs”, which are known navigation tools for access to the main sections of the program having the headings: Documentation, Data Input Area, Output Schedules, and Supplier Survey/Scorecard. The user is able to quickly navigate among the individual output schedules and their corresponding input areas, or to other main sections of the program, by clicking on a Navigation Menu, which is identified by any known graphic input, or by a specific keyboard entry. Clicking on the standard “magnifying glass” icon found in spreadsheets enables the user to “drill down” from a cell on the output schedule to the related input cell. 
         [0051]    Pop-up Notes are accessible by the user, wherever the known “?” icon is shown, to access clarifying notes. These notes are accessible in the input area (both section labels and specific cells), as well as the output schedules. These notes are detailed and comprehensive so that they provide the auditor with close guidance in connection with the data input cell associated with the corresponding note. Ready access to these notes facilitates the overall object of achieving consistent audit procedures across a plurality of audit firms having a relationship with a common investment entity, according to the present invention. 
         [0052]    Other features of the preferred embodiment include the known drop-down menu feature, which enables the user to perform additional functions, such as, for example, adding a column of data input on a new asset, selecting an asset for screen display or print, printing selected output schedules in known ways and consolidation of multiple assets. A known recalculate capability is also available under user control, which enables the user to cause the spreadsheet to recalculate all calculations. 
         [0053]    Preferably, the input screens are arranged for vertical data input, including one column per property. The preferred model includes a multi-property capability of up to 250 assets. The format of input is ordered to follow the order of the output schedules. There can be a varying number of detail lines and preferably, 100 commercial tenants, 50 non-commercial tenants, 14 lines for other income, advertising expense, and professional fees. Other alternative data entries and format arrangements suitable for audit program data input are envisioned. In addition to data, the auditor also has the capability of entering clarifying comments to be displayed on the applicable schedules. 
         [0054]      FIG. 5  is a simplified block diagram of the four major sections of the global audit program  22 , which are accessible on an interactive basis by the user through either the first input module  24  or the second input module  26 , shown in  FIG. 4 . Audit program  22  includes Documentation section  250 , Data Input Area  252 , Output Schedules  254 , Supplier Survey/Scorecard  256 , Current NOI Calculation Function  258 , and Underwriter NOI Calculation Function  260 . 
         [0055]    The Documentation section  250  includes procedures taking the form of outlines of the audit procedures to be performed. It includes a notes section which includes clarifying notes by schedule and by input cell. These notes are accessible from the input area, output schedules, or by a graphically displayed sheet tab, in conformance with known Windows (TM of Microsoft Corporation) techniques. The Documentation section  250  also includes a document checklist, which identifies data to be received from the borrower. 
         [0056]    The second major area, the Data Input Area  252 , includes all data and comment input, which preferably is entered in a single input area. Data is not directly entered in the output schedules, in order to preserve internal programming integrity. 
         [0057]    The third major area, the Output Schedules area  254 , includes twenty six output schedules for display of the audit results. These are tabulated as schedule numbers shown in Table 1. 
         [0000]    
       
         
               
               
             
               
               
             
           
               
                 TABLE 1 
               
               
                   
               
               
                 Schedule # 
                 Schedule Name 
               
               
                   
               
             
             
               
                   
               
             
          
           
               
                 1.0 
                 Commercial Rental Income/Lease Testing 
               
               
                 1.1 
                 Commercial Rental Income Potential Adjustments 
               
               
                 2.0 
                 Non-Commercial Lease testing 
               
               
                 3.0 
                 Cash Testing 
               
               
                 4.0 
                 Recovery Analysis - Rent Roll vs. Calculated 
               
               
                 4.1 
                 Recovery Analysis - Recovery Pool Calculation 
               
               
                 5.0 
                 Percentage Rent Testing 
               
               
                 6.0 
                 Non-Commercial Rental Income 
               
               
                 7.0 
                 Other Income 
               
               
                 8.0 
                 Real Estate Tax Bill Analysis 
               
               
                 8.1 
                 Real Estate Tax Expense Analysis 
               
               
                 9.0 
                 Insurance Expense Analysis 
               
               
                 10.0 
                 Utilities Expense Analysis 
               
               
                 11.0 
                 Repairs And Maintenance Expense Analysis 
               
               
                 11.1 
                 Service Contract Testing 
               
               
                 12.0 
                 Management Fees 
               
               
                 13.0 
                 General And Administrative Expense Analysis 
               
               
                 14.0 
                 Advertising And Promotion Expense Analysis 
               
               
                 15.0 
                 Professional Fees And Services Expense Analysis 
               
               
                 16.0 
                 Payroll Expense Analysis 
               
               
                 16.1 
                 Payroll Testing 
               
               
                 17.0 
                 Flexible #1 Expense Analysis 
               
               
                 17.1 
                 Flexible #2 Expense Analysis 
               
               
                 18.0 
                 Non-Operating Expenses 
               
               
                   
               
               
                 Summaries 
               
               
                 Current NOI Summary - By Property and By Multi-property Consolidation 
               
               
                 Underwriting NOI Summary - By Property and By Multi-Property Consolidation 
               
             
          
         
       
     
         [0058]    The fourth major area, Supplier Survey/Scorecard  256 , includes a supplier feedback on the audit process, including contact with the investment entity, contact with the borrower, and the global audit program. The Supplier Scorecard  256  captures metrics on price, timeliness, compliance and accuracy, which are input by the investment entity. 
         [0059]      FIG. 6  illustrates an example user-accessible menu of Data Input areas  300  logically arranged in four Sections A-D. Each input schedule, such as “Schedule 1.0 &amp; 1.1 Commercial Rental Income/Lease Testing”  302 , directly corresponds to an output screen of the same schedule number and title, described above. Clicking on the known “+/−” icon feature adjacent to any specific data input schedule title results in a “drill down” to the detailed entries, shown in  FIG. 7  (described below), corresponding to that schedule. Clicking again on that icon brings the user back to the listing of schedules shown in  FIG. 6 . 
         [0060]    Section A, titled Static and Historical Information, enables entry of information such as, for example, portfolio name, prepared by, audit date, asset name, reviewed by, and other similar information. Section A also enables input of general asset information such as address and other specifics identifying the asset to be audited. Section A further includes prior information, such as, for example, indication of whether the Current NOI calculation is based on YTD annualized data, and input of other prior period data such as prior period total rental income, prior period total tax recovery income, corresponding budgeted values and last 12 months data, such as rental income, tax recovery income, insurance recovery income, and total operating cost recover income, as well as other values, to be used in part as a basis for calculation of the Current NOI. 
         [0061]    Section B includes income related input schedules and Section C includes expense related input schedules. Section D includes input areas relating to NOI audit summary comments. 
         [0062]      FIG. 7  illustrates an example user-accessible “Schedule 1.0 &amp; 1.1, Commercial Rental Income/Lease Testing” input screen  310 . Screen  310  is obtained by clicking on the “+/−+” icon adjacent to the “Schedule 1.0 &amp;. 1.1” line  302  found in Section B of screen  300 . Screen  310  includes all items pertinent to Commercial Rental Income/Lease Testing, and provides data entry fields for multiple properties. As an example, “Property 1”,  312 , is shown. The specific entries for screen  310  are obtained according to traditional auditing methodologies, and the entries shown in  FIG. 7  are by way of example. 
         [0063]    All remaining schedules  1 - 18  are obtained in the same way as schedule 1.0 shown in  FIG. 7 . 
         [0064]      FIGS. 8-12  illustrate an example “Project Alpha” Portfolio consisting of commercial office rental space represented by an “XYZ Office Building” and a non-commercial residence rental space represented by an “ABC Apartment Complex”, illustrated in terms of NOI Audit Summary reports. The example data shown for the Current NOI Audit Summary report for each rental property provides the basis for the adjusted data shown for the corresponding Underwriter NOI Audit Summary report. The Consolidation Summary report reflects the information for the entire “Project Alpha”. 
         [0065]      FIGS. 8A and 8B  illustrate an example Current NOI Audit Summary report  400  showing example data associated with the commercial rental “XYZ Office Building”.  FIG. 8B  shows a continuation of Summary  400  shown in  FIG. 8A . The summary shown in  FIGS. 8A and 8B  summarizes the input, comments, and results calculated by the NOI audit computational model, and includes values for detail components of each of Income  410 , Operating Expenses  412 , Net Operating Income  414 , and Net Cash Flow  416 , corresponding to periods  418  including Prior Year Ending on a specific date, Budget, Last 12 Months, and Current NOI. Area  420  presents comments entered by the auditor. Area  422  includes occupancy summary in terms of square footage, which is used to calculate the per square foot value found in column  424 , for each line entry. 
         [0066]      FIGS. 9A and 9B  illustrate an example of a corresponding Underwriter NOI Audit Summary report  500  in connection with the same “XYZ Office Building” for which the Current NOI Audit Summary report is shown in  FIGS. 8A and 8B .  FIG. 9B  shows a continuation of Summary  500  shown in  FIG. 9A . The summary shown in  FIGS. 9A and 9B  summarizes amendments made by the Underwriter to the data shown in the corresponding Current NOI Audit Summary report shown in  FIGS. 8A and 8B . Adjusted values include values for the detail components of each of Income  510 , Operating Expenses  512 , Net Operating Income  514 , and Net Cash Flow  516 , corresponding to headings  518  including Current NOI, U/W Adjustments, U/W NOI and Per square Foot values. Area  520  presents comments entered by the auditor. Area  522  includes square footage summary which is used to calculate the Per Square Foot value found in column  524 , for each line entry. 
         [0067]    Values appearing in the Current NOI Summary report  400  of  FIG. 8A  are shown as adjusted by the Underwriter in Underwriter NOI Audit Summary report  500 , shown in  FIG. 9A . For example, in  FIG. 8A , the “Management Fees” having a value of $164,979 (reference numeral  426 ), are shown as a credit in the Underwriter Summary report shown in  FIG. 9A  (reference numeral  526 ). 
         [0068]      FIGS. 10A and 10B  illustrate an example Current NOI Audit Summary report  600  showing example data associated with the non-commercial rental “ABC Apartment Complex”.  FIG. 10B  shows a continuation of Summary  600  shown in  FIG. 10A . The summary shown in  FIGS. 10A and 10B  summarizes the input, comments, and results calculated by the NOI audit computational model, and includes values for detail components of each of Income  610 , Operating Expenses  612 , Net Operating Income  614 , and Net Cash Flow  616 , corresponding to periods  618  including Prior Year Ending on a specific date, Budget, Last 12 Months, and Current NOI. Area  620  presents comments entered by the auditor. Area  622  includes occupancy summary in terms of Per Unit data which is used to calculate the Per Unit value found in column  624 , for each line entry. 
         [0069]      FIGS. 11A and 118  illustrate an example of a corresponding Underwriter NOI Audit Summary report  700  in connection with the same “ABC Apartment Complex” for which the Current NOI Audit Summary report is shown in  FIGS. 10A and 10B .  FIG. 11B  shows a continuation of Summary  700  shown in  FIG. 11A . The summary shown in  FIGS. 11A and 11B  summarizes amendments made by the Underwriter to the data shown in the corresponding Current NOI Audit Summary report shown in  FIGS. 10A and 10B . Adjusted values include values for the detail components of each of Income  710 , Operating Expenses  712 , Net Operating Income  714 , and Net Cash Flow  716 , corresponding to headings  718  including Current NOI, U/W Adjustments, U/W NOI and Per Unit values. Area  720  presents comments entered by the auditor. Area  722  includes square footage summary which is used to calculate the Per Square Foot value found in column  724 , for each line entry. 
         [0070]      FIGS. 12A and 12B  illustrate an example Consolidation NOI Audit Summary report  800  showing example data associated with the example XYZ and ABC properties. Selected columns of data from the Current and Underwriter NOI Summary reports are listed to enable easy comparison and analysis.  FIG. 12B  shows a continuation of summary  800  shown in  FIG. 12A . The following rows of data are drawn from the two summary reports: Income  810 , Operating Expenses  812 , Net Operating Income  814 , and Net Cash Flow  816 , corresponding to periods  818  including Last 12 Months, Current NOI, U/W Adjustments, U/W NOI, Per Square Foot values and Per Unit values. Area  822  includes both the square footage and occupied unit summaries. 
         [0071]    While this invention has been described in conjunction with specific embodiments thereof, it is evident that many alternative modifications and variations will be apparent to those skilled in the art. Accordingly, the preferred embodiments of the invention as set forth herein are intended to be illustrative, not limiting. Various changes may be made without departing from the true spirit and scope of the invention as defined in the following claims.