Attachment_1_OPIISReportsCatalog.pdf

OPIIS REPORTS TABLE OF CONTENTS

MULTIFAMILY

Wednesday, September 02, 2015 Page 1 of 29MULTIFAMILY

(1) CREDIT RISKRisk Category: Financial StatementsRisk Sub-Category:

This report series provides balance sheet analysis by year for a selected property, by aggregate and by supplemental accounts.

BALANCE SHEETReport Series:

Balance Sheet Aggregate Accounts - PropertyReport Name:

Balance Sheet Supplemental Accounts - PropertyReport Name:

Balance Sheet - PropertyReport Name:

This report series provides cash flow analysis by year for a selected property, by aggregate and by supplemental accounts.

CASH FLOW STATEMENTReport Series:

Cash Flow - PropertyReport Name:

Cash Flow Supplemental Accounts - PropertyReport Name:

This report provides key financial statistics by year for a selected property, which include net operating income, operating expenses, debt service coverage ratio, quick ratio. The report has been recently enhanced with the addition of actual rents versus market rents, economic vacancy rates versus market vacancy rates, and with the MROC score migration over time.

FINANCIAL STATISTICSReport Series:

Financial Statistics Summary - PropertyReport Name:

This report series provides a detailed breakdown of certain cash flows for a selected property (i.e. S1200 034: Entity/Construction Receipts, S1200 225: Entity/Construction Disbursements), by aggregate and supplemental accounts. An additional report can be found for cash flow analysis for all accounts.

OWNER'S EQUITYReport Series:

Owner Equity - PropertyReport Name:

Owner Equity Supplemental Accounts - PropertyReport Name:

This report series provides sub-account profit and loss (income statement) analysis by year for a selected property, by aggregate accounts, by supplemental accounts, and on a per unit basis.

PROFIT AND LOSSReport Series:

Profit and Loss Supplemental Accounts - PropertyReport Name:

Profit and Loss Unit - PropertyReport Name:

Profit and Loss Aggregate Accounts - PropertyReport Name:

Profit and Loss - PropertyReport Name:

This report series shows the opening and current balances, deposit/withdrawal activity, or existence of a waiver within a property's replacement reserve and residual receipts accounts.

RESERVESReport Series:

Reserve Aggregate Accounts - PropertyReport Name:

Reserve - PropertyReport Name:

Wednesday, September 02, 2015 Page 2 of 29MULTIFAMILY

This report series shows the cash balance, current liabilities, the amount(s) available for distribution, and additions/reductions in assets.

SURPLUS CASHReport Series:

Surplus Cash - PropertyReport Name:

Surplus Cash Aggregate Accounts - PropertyReport Name:

Wednesday, September 02, 2015 Page 3 of 29MULTIFAMILY

(1) CREDIT RISKRisk Category: Portfolio SummaryRisk Sub-Category:

The purpose of the report is to examine the health of recoveries on notes currently held in MF inventory. By assessing the ratio of net income to acquisition cost, HUD management is able to gauge the overall health of its note inventory before disposition. The data are grouped by claim type. Average holding periods (in years) and average recovery rates are also reported by risk category and cohort year.

ACTIVE NOTE INVENTORYReport Series:

MF Active Note InventoryReport Name:

This report series provides the distribution of insured apartment loans by loan program for the nation for selected date(s). The report displays average original loan balances, interest rates, and loan age, as well as proportions delinquent or in default within each loan program. There are various views of the report by Hub, by Office, by risk category, and endorsement year.

INSURED LOANSReport Series:

Active Insured Loans - Major ProgramReport Name:

Active Insured Loans - Major Program & HubReport Name:

Active Insured Loans - Risk Category & Endorse YearReport Name:

Active Insured Loans - Risk CategoryReport Name:

Active Insured Loans - Major Program & OfficeReport Name:

This report series provides the composition of the multifamily portfolio in terms of loan count and aggregated UPB with respect to the breakdown among insured loans, capital advances, HUD-held loans, and flexible subsidies. Views of the report include organization of the data by Hub, production office and by risk category.

PORTFOLIO SUMMARYReport Series:

MF Portfolio Summary - HubReport Name:

MF Portfolio SummaryReport Name:

MF Portfolio Summary - OfficeReport Name:

Wednesday, September 02, 2015 Page 4 of 29MULTIFAMILY

(1) CREDIT RISKRisk Category: Risk MetricsRisk Sub-Category:

This series of reports depicts cumulative and conditional claim rates for loans grouped by cohort year and, further, by select risk categories. The time series views are either by policy quarter or activity year, and are drillable to the HUB level. The reports show at a glance those cohorts that experienced high cumulative claim rates over time.

CLAIMSReport Series:

Claims - Loan ListReport Name:

Cumulative Claim Rates [Policy Quarter] - HUBReport Name:

Cumulative Claim Rates [Policy Quarter]Report Name:

Cumulative Claim Rates [Activity Year] - HUBReport Name:

Cumulative Claim Rates [Activity Year]Report Name:

Conditional Claim Rates [Activity Quarter]Report Name:

Conditional Claim Rates [Policy Quarter]Report Name:

This series of reports depicts the distribution of DQ1 (30-day), DQ2 (60-day), and DQ3 (90+-day) defaults between assisted and market-rate properties, among Hubs, risk categories, among Project Managers within Hubs.

DEFAULTSReport Series:

Default RatesReport Name:

MF Default Transitions and PrepaymentsReport Name:

Default Rates - Risk Category & Assistance StatusReport Name:

Defaulted Loans - Hub and Project ManagerReport Name:

Default Rates - Assistance StatusReport Name:

Default Rates - HubReport Name:

Default Rates - Risk CategoryReport Name:

The purpose of this report is to allow users to view active insured properties that have a Debt Service Coverage Ratio (DSCR) less than or equal to 1 as reported in their most recent Annual Financial Statement (AFS). The report also indicates whether a property has had a loan modification.

The report is generated based on a selection of Hub, Field Office, and Property Manager.

DSCRReport Series:

DSCR Less than 1 - Active Insured PropertiesReport Name:

DSCR - Active Properties - 5 Year TrendReport Name:

Wednesday, September 02, 2015 Page 5 of 29MULTIFAMILY

The purpose of this series of reports is to investigate underwriting quality by assessing loan performance within four years of final endorsement. The reports depict the incidence of early credit events such as early claims, early defaults, and early PPC’s occurring within four years of final endorsement as indicators of underwriting quality. The reports cover insured MAP and TAP loans with cohort year of 2005 and later. The data are aggregated by production office and by HUB.

EARLY CREDIT EVENTSReport Series:

TAP Early Credit EventsReport Name:

MAP Early Credit Events - Loan DetailsReport Name:

TAP Early Credit Events - Loan DetailsReport Name:

MAP Early Credit EventsReport Name:

These two reports show, logical inconsistencies between a project's risk rating (of 1-10) and certain project facts. The report may be generated for any single or multiple HUB(s), Field Office(s),or Project Manager(s). The report is available at the project level detail to show which particular logical exception was encountered, or summarized as counts across Project Managers, Field Offices, and/or HUBs.

The exceptions reported are as follows:

MOR less than satisfactory but rated 7-10 MROC is red but rated 10 Not Rated (Include all even if less than 90 days, so it will be a reminder to rate the loans) PASS score below 60 but rated 6-10 QAS score over 1 but rated 7-10 DEC referral, but rated 6-10 DSCR less than 1 (MROC) with initial endorsement or Modification/PPC date older than 2 years (d4-3 years) Loan is rated 1-5 and the comment justification is older than 3 months.

Loan is rated 6 or 7 and the comment is older than 6 months Loan is rated 8-10 and the comment is older than 1 year.

Troubled properties without an action plan (DEC and OAHP referrals count as an Action Plan for goals, but are not part of the drop down selection.)

There maybe very valid reasons for loans showing up as an exception, the reports are simply to have an additional set of eyes reviewing the rating and reason for the exception.

INSURED PORTFOLIO RATING EXCEPTIONSReport Series:

Insured Portfolio Rating Exceptions - SummaryReport Name:

Insured Portfolio Rating Exceptions - DetailReport Name:

The purpose of this report is show the history of loan modifications as reported by FHASL. The report includes fields such as loan modification date, interest rate before and after the modification, monthly payment before and after the modification, and DSCR, both before and after the modification.

LOAN MODIFICATIONSReport Series:

MF Loan Modification ReportsReport Name:

This report summarizes the number and type of waivers of MF credit policy requested by Lenders over time. The report shows the original loan amount requested and the Chapter of the MF MAP Guide under which the waiver was requested. The data is shown from 2010, which is when data collection was initiated, and is summarized by Lender.

MF UNDERWRITING WAIVER REPORTReport Series:

Multifamily Underwriting Waiver ReportReport Name:

Wednesday, September 02, 2015 Page 6 of 29MULTIFAMILY

This report shows, for the reporting month and HUB selected, the relative proportions of low (green MROC), medium (yellow MROC), and high (red MROC) risk loans for each Field Office (within the HUB).

MROC - CREDIT RISK SCOREReport Series:

MROC Sore - Field OfficeReport Name:

MROC Score - Property ListReport Name:

MROC Score - Historical Property DetailReport Name:

MROC Score - Current Property DetailReport Name:

MROC Score - Property DetailsReport Name:

MROC Score - Asset Manager Property ListReport Name:

MROC Score - HUBReport Name:

MROC Score - Asset ManagersReport Name:

The purpose of the report is to examine the recovery rate of MF note sales (for each claim type) by cohort year, year of note sale, holding period, or by risk category. Detailed information for each FHA number also provides financial information such as acquisition cost, net income and note sale amount. Note sales data are available from cohort year 1994.

NOTE SALESReport Series:

MF Note SalesReport Name:

The data utilized by this report covers PPC's on record from FY 1992 to the present. The first is a property level view that reports out on general information on the property securing the restructured first and soft second. Next, the report presents loan statistics pertaining to said mortgages. The property's loan performance utilizing traditional key performance indicators (DSCR, economic vacancy, surplus cash/unit, reserves/unit, quick ratio, and operating cost coverage) over time is then compared to a set of peer properties. Finally, the peer properties are displayed. Peers are generally properties within the same REIS submarket, of same building type, and of similar loan age. The second view within the report is a tabulation of PPC counts from FY 1992 to the present. This view also displays for each fiscal year, the counts of PPC that have since gone to claim, defaulted, or have been prepaid.

PPCReport Series:

PPC AssessmentReport Name:

The dashboard is a one-stop-shop of credit risk metrics for properties falling within any given portfolio as defined by HUB and by Project Manager. Inside the dashboard is a collection of 'objects', graphs, and data tables that show at a glance the portfolio's credit risk profile. These objects include: a pie-chart distribution of risk by MROC score within the portfolio; a bar graph comparing economic vacancy with market vacancy rates; a trend line showing the movement of market vacancy rates over time; tabulation of high and medium credit risk (red and yellow MROC scores, respectively) properties, defaulted loans, and claims in the past three years; dials depicting the default rate by loan count and by UPB for the portfolio, and, finally, a listing of properties with failing PASS Scores.

RISK DASHBOARDReport Series:

MF Risk Dashboard - Hub and Project ManagerReport Name:

Wednesday, September 02, 2015 Page 7 of 29MULTIFAMILY

This series of maps depicts (for HUD-insured mortgages secured by apartments) the distribution of (FHA) insurance-in-Force, high risk loans with red MROC scores, 60+ day defaults, and claims across the country. The maps are drillable from that national level, to HUB, to state, and to county. Maps may be cast for data as of any one month over the period March, 2003 to the present. Beyond county level, each map lands at a table of the properties comprising the population being mapped. Pointing the mouse to hover over any county displays data on the county, the number of properties located in it, aggregate UPB, economic vacancy, market vacancy, and the proportion of UPB at (credit) risk relative to total (FHA) insurance in force.

RISK MAPSReport Series:

MF Risk Metrics US Map - Insurance-in-Force, MROC, Claims, and 60+ Day Default Geographical Distributions

Report Name:

MF Pipeline US MapReport Name:

This series of reports shows the Troubled rating (Troubled, Potentially Troubled, Not Troubled) for properties from both the Insured and Uninsured portfolios. The data may be viewed at different levels of aggregation, i.e., by HUB, by Field Office, and by Asset Manager.

The current property detail report shows, in addition, the risk factor components as a series of binary indicators in support of the current Troubled rating.

The historical property detail report shows the migration of the Troubled Rating for each month within the reporting period.

The risk factor indicators and resultant Troubled rating are collected from the OPIIS risk rating sites on a monthly basis.

TROUBLED STATUSReport Series:

Troubled Status - Property DetailReport Name:

Troubled Status - HUBReport Name:

Troubled Status - Historical Property DetailReport Name:

Troubled Status - Current Property DetailReport Name:

Troubled Status - Asset Manager Property ListReport Name:

Troubled Status - HUB Property ListReport Name:

Troubled Status - Field OfficeReport Name:

Troubled Status - Asset ManagersReport Name:

Wednesday, September 02, 2015 Page 8 of 29MULTIFAMILY

(2) COUNTERPARTY RISKRisk Category: Counterparty RiskRisk Sub-Category:

The purpose of this series of reports is to investigate underwriting quality by assessing loan performance within four years of final endorsement. The reports depict the incidence of early credit events such as early claims, early defaults, and early PPC’s occurring within four years of final endorsement as indicators of underwriting quality. The reports cover insured MAP and TAP loans with cohort year of 2005 and later. The data are aggregated by loan originator.

EARLY CREDIT EVENTSReport Series:

TAP Early Credit Events - Loan Details by OriginatorReport Name:

TAP Early Credit Events - by OriginatorReport Name:

MAP Early Credit Events - Loan Details by OriginatorReport Name:

MAP Early Credit Events - by OriginatorReport Name:

This report series depicts the distribution of FHA's counterparty risk in terms of origination volumes, defaults, and claims as distributed among its lenders and servicers.

SERVICER REPORTSReport Series:

Defaulted Loans - ServicerReport Name:

MAP Originator Summary - Endorsements & Early Claims Report Name:

MAP Originator Summary - Active Property Details Report Name:

Defaulted Loans - Servicer DetailsReport Name:

MAP Originator Summary - Active Portfolio Performance Report Name:

Wednesday, September 02, 2015 Page 9 of 29MULTIFAMILY

(3) MARKET RISKRisk Category: Market RiskRisk Sub-Category:

This series of reports displays market data, which include:

Vacancy Rates Market Rents Market Rent Change Gross Revenue per Unit Effective Rent Effective Rent Change Completions Conversions Construction Absorption Ratio Occupied Stock Absorption Ratio Net Absorption Unit Inventory Occupied Stock Vacant Stock

Views of the data include organization by REIS markets, multifamily portfolio concentration within the REIS metro areas, and historical market data applying to any one property.

REISReport Series:

Insured Portfolio Concentration in REIS Metro AreasReport Name:

REIS Market Metrics - Vacancy & Market RentReport Name:

REIS Market Metrics - Last QuarterReport Name:

REIS Market Metrics - Property Report Name:

REIS Market MetricsReport Name:

Wednesday, September 02, 2015 Page 10 of 29MULTIFAMILY

(4) OPERATIONAL RISKRisk Category: Operational RiskRisk Sub-Category:

These two reports depict loan application, firm commitment, and initial endorsement volumes by HUB, Production Office, and as categorized by Section of the Act/Risk Category.

PIPELINE SUMMARYReport Series:

MF Pipeline Summary - Hub and Production OfficeReport Name:

MF Pipeline Summary - Risk CategoryReport Name:

This series of reports displays the current work load for the all multifamily production offices, selected Hub(s), or selected Field Office(s).

The report displays the number of asset managers, counts of active insured and uninsured properties, and the number of firm commitments in the pipeline not yet assigned to an asset manager.

RESOURCE ALLOCATIONReport Series:

Resource Allocation - HubReport Name:

Resource Allocation - Field OfficeReport Name:

Resource AllocationReport Name:

This report provides pipeline, productivity, and affordable housing information on applications processed by the various Mulitfamily HUBs under HUD's Tax Credit program. Statistics are presented by Multifamily HUB on the following:

*Active, Closed, Rejected/Withdrawn Applications *Housing Units covered by Applications and approved/closed transactions *Tenancy served/Project Type *Costs and Tax Proceeds *Pipeline status as to Concept Meeting Completed, Application Completed, Commitment Approved, Commitment Issued, Closed *Averages as to Days to Firm Commitment and Actual Days from Application to Approval *Closings expected in the next 60 days

TAX CREDIT PIPELINEReport Series:

Tax Credit ApplicationReport Name:

The purpose of this report series is to allow management to view workloads as they pertain to IRA risk scores. The report is organized with three levels: Hub, Field Office, and Asset Manager. At any level, a user can view aggregations of total Properties, high risk IRA properties, moderate risk IRA properties, and low risk IRA properties. This report is similar to the Resource Allocation series of reports, but uses IRA scores, thus providing relative indications of risk for all properties rather than just insured properties

WORKLOAD SHARINGReport Series:

Workload Sharing Reports (Summary and Detail)Report Name:

Wednesday, September 02, 2015 Page 11 of 29MULTIFAMILY

(5) MISSION RISKRisk Category: Mission RiskRisk Sub-Category:

The purpose of this report series is to provide detailed information on assistance contracts associated with properties that have been determined by the affordable housing risk model to have a high probablity of opting out from FHA's affordable housing programs. The report contains data on:

HUD Region City US State Property ID Latest Property FHA Number Total Units Total Assisted Units Total Unassisted Units Total Amortized Active UPB Total Active Contracts Total Budget Authority Total Contract Authority The report may be generated at the HUB, FIELD OFFICE, PROJECT MANAGER, and PROPERTY LEVELS.

AFFORDABLE HOUSING AT RISK DETAILSReport Series:

Affordable Housing Risk Metrics- HubReport Name:

Affordable Housing Risk Metrics- Field OfficeReport Name:

Affordable Housing Risk Metrics- Property DetailsReport Name:

Affordable Housing Risk Metrics- Contract DetailsReport Name:

This report series depicts the distribution of properties at risk of opting out of HUD's affordable housing rental assistance programs.

Views include organization of the data by HUB and Field Office.

AFFORDABLE HOUSING RISK METRICSReport Series:

Affordable Housing Risk Metrics - HubReport Name:

Affordable Housing Risk Metrics - OfficeReport Name:

Affordable Housing Risk Metrics - Loan DetailsReport Name:

The dashboard is a one-stop-shop of mission risk metrics for properties falling within any given portfolio as defined by HUB and by Project Manager. Inside the dashboard is a collection of 'objects', graphs, and data tables that show at a glance the portfolio's mission risk profile. These objects include: a pie-chart distribution of risk by IRA risk category, another pie-chart for PASS score category, various lists for properties with High and Moderate risk IRA scores, assistance contracts expiring in the next year, PASS score is less than 60, and properties with life-threatening deficiencies. There are also trend lines that compare overall HUD portfolio vacancy rates with market vacancy rates.

ASSISTED PROPERTY RISK DASHBOARDReport Series:

MF Assisted Properties - Mission Risk DashboardReport Name:

Wednesday, September 02, 2015 Page 12 of 29MULTIFAMILY

This report presents information pertinent to the 'assisted' portfolio, which are properties that may not be encumbered by an FHA-insured mortgage, but that are the recipient of some type of HUD subsidy, grant, or other project assistance. The information presented includes:

Occupancy Date Assistance Contract Effective and Expiration Dates Number of Assisted versus Total Units Use Restriction information Burn rate, budgeted authority, total disbursed amounts Rent to Fair Market Rent Ratio Management Review and Condition Status and date of status FASS compliance status and date of status OAHP Watch List Status and watch list effective date Default Status Last Payment due Datec REIS market and market vacancy rate

The report may be generated for one or many HUBs, field offices within those HUBs, and Project Managers within those field offices.

ASSISTED PROPERTY RISK METRICSReport Series:

MF Assisted Properties - Risk MetricsReport Name:

This report series depicts the distribution of properties at risk of opting out of HUD's affordable housing rental assistance programs.

Views include organization of the data by HUB and Field Office.

ENERGYReport Series:

Energy SummaryReport Name:

This series of reports provides data on rental assistance contracts by HUB, by Field Office, and by Project Manager. Data reported include property information, mortgage loan information (if applicable) contract type, budget authority, contract authority, and most recent renewal status.

PROJECT-BASED RENTAL ASSISTANCE CONTRACTSReport Series:

Active Project-Based Rental Assistance Contracts by HUBReport Name:

Active Project-Based Rental Assistance Contracts by Field OfficeReport Name:

Active Project-Based Rental Assistance Contracts by Project ManagerReport Name:

Active Project-Based Rental Assistance Contracts SummaryReport Name:

Active Project-Based Rental Assistance Contract DetailsReport Name:

This report series depicts the distribution of properties at risk of opting out of HUD's affordable housing rental assistance programs.

Views include organization of the data by HUB and Field Office.

RENTAL ASSISTANCE CONTRACTSReport Series:

Active Rental Assistance Contracts - OfficeReport Name:

Active Rental Assistance Contracts - HubReport Name:

Active Rental Assistance ContractsReport Name:

Wednesday, September 02, 2015 Page 13 of 29MULTIFAMILY

OHP: HOSPITALS

Wednesday, September 02, 2015 Page 14 of 29OHP: HOSPITALS

(1) CREDIT RISKRisk Category: Credit Risk MetricsRisk Sub-Category:

This series of reports depicts the distribution of DQ1 (30-day), DQ2 (60-day), and DQ3 (90+-day) defaults between assisted and market-rate properties, among Hubs and Project Managers within Hubs.

DEFAULTSReport Series:

Hospital Defaulted Loans - HUB and Project ManagerReport Name:

The purpose of this report is show the history of loan modifications as reported by FHASL. The report includes fields such as loan modification date, interest rate before and after the modification, monthly payment before and after the modification, and DSCR, both before and after the modification.

LOAN MODIFICATIONSReport Series:

Hospital Loan Modifications HistoryReport Name:

This report displays for Hospitals, the number of new applications received, firm commitments, and initial endorsements by date and risk category in both a list report with counts and as a time line chart in the right side of the list report. This allows the user:

• To view detailed count data in tabular list form and graphical form to identify trends across risk categories for the various metrics, and

• To drill down time periods by year, quarter and month.

PIPELINE SUMMARYReport Series:

MF Hospital Pipeline Summary By Risk CategoryReport Name:

Wednesday, September 02, 2015 Page 15 of 29OHP: HOSPITALS

This report presents credit risk management information for all HOSPITALS in OHF's portfolio in terms of:

LIQUIDITY RATIOS

1. Current Ratio

2. Cash Ratio

3. Days in Accts Receivable

4. Average Payment Period

5. Days Cash on Hand

6. Enhanced Days Cash on Hand

7. Working Cap to Tot Assets

CAPITAL STRUCTURE RATIOS

1. Debt Service Coverage

2. Long-Term Debt To Capitalization

3. Equity Financing

4. Long-Term Debt to Capital Assets

5. Cap Debt to Net Fxd Asset

6. Cash Flow to Total Debt

7. Debt Service as a Percent of Operating Revenue

PROFITABILITY RATIOS

1. Total Margin

2. Operating Margin

3. Return on Equity

FINANCIAL STRENGTH RATIOS

1. Debt Financing Percent

2. FSI (Financial Strength Index)

FINANCIAL RATIOSReport Series:

Hospital Financial Ratios ReportReport Name:

This report shows the assets and liabilities for hospitals in the FHA 242 portfolio. The data for this report is obtained from HMIMIS.

OHF BALANCE SHEETReport Series:

OHF Balance SheetReport Name:

The report shows how changes in balance sheet accounts and income affect cash and cash equivalents, and breaks the analysis down to operating, investing and financing activities.

OHF CASH FLOW STATEMENTReport Series:

OHF Statement of Cash FlowsReport Name:

This report shows income, expenses, and net profit for hospitals in the FHA 242 portfolio. The data for this report is obtained from

HMIMIS.

OHF INCOME STATEMENTReport Series:

OHF Income (or Profit and Loss) StatementReport Name:

Wednesday, September 02, 2015 Page 16 of 29OHP: HOSPITALS

This report series provides the distribution of insured hospital loans by loan program for the nation for selected date(s). The report displays average original loan balances, interest rates, and loan age, as well as proportions delinquent or in default within each loan program. There are various views of the report by Hub, by Office, by risk category, and endorsement year.

INSURED LOANSReport Series:

Active Insured Loans - Major ProgramReport Name:

Hospital Insured Loans by ServicerReport Name:

Active Insured Loans - Major Program & HubReport Name:

Wednesday, September 02, 2015 Page 17 of 29OHP: HOSPITALS

This series of reports depicts the distribution of DQ1 (30-day), DQ2 (60-day), and DQ3 (90+-day) defaults between assisted and market-rate properties, among Hubs, risk categories, among Project Managers within Hubs.

DEFAULTSReport Series:

Defaulted Loans - Hub and Project ManagerReport Name:

Default Rates - Risk CategoryReport Name:

This purpose of this report is to provide an early warning system for delinquent hospital loans that have not yet quite gone into a 30-day default. For any given month selected, the data reported include facility data, outstanding principal balance, and endorsement date.

HOSPITAL EARLY DELINQUENCY REPORTReport Series:

Hospital Early Delinquency ReportReport Name:

This series of maps depicts (for HUD-insured mortgages secured by HOSPITALS) the distribution of loan applications, commitment issuances, and endorsements across the country over the past twelve months. Maps may be cast for data as of any period of up to twelve months to the present. Beyond county level, each map lands at a table of the properties comprising the population being mapped. Pointing the mouse to hover over any county displays data on the county, the number of properties located in it, aggregate loan amounts under application, committed, or endorsed, and market vacancy rate.

RISK MAPSReport Series:

MF Pipeline US MapReport Name:

MF Risk Metrics US Map - Insurance-in-Force, MROC, Claims, and 60+ Day Default Geographical Distributions

Report Name:

Wednesday, September 02, 2015 Page 18 of 29OHP: HOSPITALS

(2) COUNTERPARTY RISKRisk Category: COUNTERPARTY RISKRisk Sub-Category:

This report provides the distribution of insured hospital loans by Servicer for the nation for selected date(s). The report displays average original loan balances, interest rates, and loan age, as well as proportions delinquent or in default within each loan program. There are various views of the report by Hub, by Office, by risk category, and endorsement year.

INSURED LOANS by SERVICERReport Series:

Active Insured Loans by Servicer- DetailReport Name:

Active Insured Loans by Servicer - SummaryReport Name:

Wednesday, September 02, 2015 Page 19 of 29OHP: HOSPITALS

(4) OPERATIONAL RISKRisk Category: Operational RiskRisk Sub-Category:

This report depicts healthcare loan application, firm commitment, and initial endorsement volumes.

PIPELINE SUMMARYReport Series:

HC Pipeline SummaryReport Name:

Wednesday, September 02, 2015 Page 20 of 29OHP: HOSPITALS

OHP: NURSING

HOMES

Wednesday, September 02, 2015 Page 21 of 29OHP: NURSING HOMES

(1) CREDIT RISKRisk Category: Credit Risk MetricsRisk Sub-Category:

This report displays for Nursing Homes, the number of new applications received, firm commitments, and initial endorsements by date and risk category in both a list report with counts and as a time line chart in the right side of the list report. This allows the user:

• To view detailed count data in tabular list form and graphical form to identify trends across risk categories for the various metrics, and

• To drill down time periods by year, quarter and month.

PIPELINE SUMMARYReport Series:

MF Nursing Pipeline Summary by Risk CategoryReport Name:

Wednesday, September 02, 2015 Page 22 of 29OHP: NURSING HOMES

This report series provides balance sheet analysis by year for a selected property, by aggregate and by supplemental accounts.

BALANCE SHEETReport Series:

Balance Sheet Aggregate Accounts - PropertyReport Name:

Balance Sheet - PropertyReport Name:

Balance Sheet Supplemental Accounts - PropertyReport Name:

This report series provides cash flow analysis by year for a selected property, by aggregate and by supplemental accounts.

CASH FLOW STATEMENTReport Series:

Cash Flow Supplemental Accounts - PropertyReport Name:

Cash Flow - PropertyReport Name:

This report provides key financial statistics by year for a selected property, which include net operating income, operating expenses, debt service coverage ratio, quick ratio. The report has been recently enhanced with the addition of actual rents versus market rents, economic vacancy rates versus market vacancy rates, and with the MROC score migration over time.

FINANCIAL STATISTICSReport Series:

Financial Statistics Summary - PropertyReport Name:

This report series provides a detailed breakdown of certain cash flows for a selected property (i.e. S1200 034: Entity/Construction Receipts, S1200 225: Entity/Construction Disbursements), by aggregate and supplemental accounts. An additional report can be found for cash flow analysis for all accounts.

OWNER'S EQUITYReport Series:

Owner Equity Supplemental Accounts - PropertyReport Name:

Owner Equity - PropertyReport Name:

This report series provides sub-account profit and loss (income statement) analysis by year for a selected property, by aggregate accounts, by supplemental accounts, and on a per unit basis.

PROFIT AND LOSSReport Series:

Profit and Loss Aggregate Accounts - PropertyReport Name:

Profit and Loss Supplemental Accounts - PropertyReport Name:

Profit and Loss Unit - PropertyReport Name:

Profit and Loss - PropertyReport Name:

This report series shows the opening and current balances, deposit/withdrawal activity, or existence of a waiver within a property's replacement reserve and residual receipts accounts.

RESERVESReport Series:

Reserve - PropertyReport Name:

Reserve Aggregate Accounts - PropertyReport Name:

Wednesday, September 02, 2015 Page 23 of 29OHP: NURSING HOMES

This report series shows the cash balance, current liabilities, the amount(s) available for distribution, and additions/reductions in assets.

SURPLUS CASHReport Series:

Surplus Cash Aggregate Accounts - PropertyReport Name:

Surplus Cash - PropertyReport Name:

Wednesday, September 02, 2015 Page 24 of 29OHP: NURSING HOMES

The purpose of the report is to examine the health of recoveries on notes currently held in MF inventory. By assessing the ratio of net income to acquisition cost, HUD management is able to gauge the overall health of its note inventory before disposition. The data are grouped by claim type. Average holding periods (in years) and average recovery rates are also reported by risk category and cohort year.

ACTIVE NOTE INVENTORYReport Series:

MF Active Note InventoryReport Name:

This report series provides the distribution of insured nursing home loans by loan program for the nation for selected date(s). The report displays average original loan balances, interest rates, and loan age, as well as proportions delinquent or in default within each loan program. There are various views of the report by Hub, by Office, by risk category, and endorsement year.

INSURED LOANSReport Series:

Active Insured Loans - Risk CategoryReport Name:

Active Insured Loans - Risk Category & Endorse YearReport Name:

Active Insured Loans - Major Program & HubReport Name:

Active Insured Loans - Major ProgramReport Name:

The purpose of this report is show the history of loan modifications as reported by FHASL. The report includes fields such as loan modification date, interest rate before and after the modification, monthly payment before and after the modification, and DSCR, both before and after the modification.

LOAN MODIFICATIONSReport Series:

MF Loan Modification ReportsReport Name:

Wednesday, September 02, 2015 Page 25 of 29OHP: NURSING HOMES

This series of reports depicts cumulative and conditional claim rates for loans grouped by cohort year and, further, by select risk categories. The time series views are either by policy quarter or activity year, and are drillable to the HUB level. The reports show at a glance those cohorts that experienced high cumulative claim rates over time.

CLAIMSReport Series:

Claims - Loan ListReport Name:

Cumulative Claim Rates [Policy Quarter]Report Name:

Conditional Claim Rates [Activity Quarter]Report Name:

Conditional Claim Rates [Policy Quarter]Report Name:

Cumulative Claim Rates [Activity Year] - HUBReport Name:

Cumulative Claim Rates [Policy Quarter] - HUBReport Name:

Cumulative Claim Rates [Activity Year]Report Name:

This series of reports depicts the distribution of DQ1 (30-day), DQ2 (60-day), and DQ3 (90+-day) defaults between assisted and market-rate properties, among Hubs, risk categories, among Project Managers within Hubs.

DEFAULTSReport Series:

Default Rates - OverallReport Name:

Default Rates - Risk CategoryReport Name:

MF Default Transitions and PrepaymentsReport Name:

Defaulted Loans - Hub and Project ManagerReport Name:

For any given reporting month, this report displays the following risk metrics for Assisted Living, Board & Care, and Nursing Home properties:

Active Property Count Amortized UPB Latest PASS < 60 % PASS Below 60 Currently Troubled % Troubled Currently in Default % In Default Has FASS Score % FASS Score

HC RISK METRICSReport Series:

HC Risk MetricsReport Name:

The purpose of the report is to examine the recovery rate of MF note sales (for each claim type) by cohort year, year of note sale, holding period, or by risk category. Detailed information for each FHA number also provides financial information such as acquisition cost, net income and note sale amount. Note sales data are available from cohort year 1994.

NOTE SALESReport Series:

MF Note SalesReport Name:

Wednesday, September 02, 2015 Page 26 of 29OHP: NURSING HOMES

This series of maps depicts (for HUD-insured mortgages secured by nursing homes) the distribution of (FHA) insurance-in-Force, high risk loans with red MROC scores, 60+ day defaults, and claims across the country. The maps are drillable from that national level, to HUB, to state, and to county. Maps may be cast for data as of any one month over the period March, 2003 to the present. Beyond county level, each map lands at a table of the properties comprising the population being mapped. Pointing the mouse to hover over any county displays data on the county, the number of properties located in it, aggregate UPB, economic vacancy, market vacancy, and the proportion of UPB at (credit) risk relative to total (FHA) insurance in force.

RISK MAPSReport Series:

MF Risk Metrics US Map - Insurance-in-Force, MROC, Claims, and 60+ Day Default Geographical Distributions

Report Name:

MF Pipeline US MapReport Name:

Wednesday, September 02, 2015 Page 27 of 29OHP: NURSING HOMES

(2) COUNTERPARTY RISKRisk Category: COUNTERPARTY RISKRisk Sub-Category:

This report provides the distribution of insured nursing home loans by Servicer for the nation for selected date(s). The report displays average original loan balances, interest rates, and loan age, as well as proportions delinquent or in default within each loan program.

There are various views of the report by Hub, by Office, by risk category, and endorsement year.

INSURED LOANS by SERVICERReport Series:

Active Insured Loans by Servicer - SummaryReport Name:

Active Insured Loans by Servicer- DetailReport Name:

Wednesday, September 02, 2015 Page 28 of 29OHP: NURSING HOMES

(4) OPERATIONAL RISKRisk Category: OPERATIONAL RISKRisk Sub-Category:

This report summarizes Project Manager progress reports (logs) on properties under default monitoring.

DEFAULT REPORTING PM LOGSReport Series:

OHP Default Reporting – Project Manager Monthly LogsReport Name:

This series of reports shows the volume of escrow releases processed by Account Executives for any given month(s) selected. The detailed report shows the amounts requested and approved for each draw, along with processing comments as to what items were reimbursed or denied.

ESCROW DRAW ACTIVITYReport Series:

Escrow Draw ActivityReport Name:

Escrow Draw Activity - DetailsReport Name:

This report depicts healthcare loan application, firm commitment, and initial endorsement volumes by HUB, Production Office, and as categorized by Section of the Act/Risk Category.

PIPELINE SUMMARYReport Series:

HC Pipeline SummaryReport Name:

The purpose of the report is to monitor the turnaround of health care related loans at risk of default or at the stage of initial default as managed by select OHP account executive(s). The report aggregates loan counts and amortized UPBs for each 'troubled' status and displays loan level details.

TURN-AROUNDReport Series:

OHP Turnaround ReportReport Name:

The purpose of the report is to monitor the workload of OHP account executives as individuals and as a group during any time since October 2005. Counts of open, closed, and overall asset management related activities are analyzed for the entire 232 portfolio.

Additionally, the report covers financial monitoring activities, TPA's, and other activities.

WORKLOADReport Series:

OHP Workload ReportReport Name:

Wednesday, September 02, 2015 Page 29 of 29OHP: NURSING HOMES