Freddie Mac · OTC:FMCC
Freddie Mac — Investor Presentation (2012)
16 slides from Freddie Mac's investor presentation, 2012
Slide 1: AIE Template Overview
AIE Template Overview mie We make home possible®
Slide 2: Agenda
Agenda Identify the updates to the AIE template Describe how the updates to the template work Identify the required fields to be completed Recognize the supplemental forms to be completed 2
Slide 3: Overview
Overview In March 2012, we are launching the Freddie Mac Property Reporting System (PRS) to replace MultiSuite for Assessments. With the launch of PRS, we are introducing updated templates reflecting key activities related to the assessment, inspection and quarterly reporting processes. This trainin
Slide 4: Overview cont’d
Overview cont’d AIE Template Updates: Ability to download Blank or Pre-populated forms Updated Property and Loan Overview section Additional reporting requirements based on Loan Characteristics Three-column format for Income and Expense Analysis Completeness verification 4
Slide 5: Download Blank or Pre-populated AIE Form: Blank Form
Download Blank or Pre-populated AIE Form Blank Form Freddie Mac Loan Number Servicer Loan Number Characteristics Property Name Servicer Name City Name of Analyst State Contact Phone 5 Contact email
Slide 6: Download Blank or Pre-populated AIE Form: Pre-populated Form
Download Blank or Pre-populated AIE Form Pre-populated Form Name of Analyst Contact email Contact Phone Characteristics 6
Slide 7: Property and Loan Overview: Loan Characteristics
Property and Loan Overview Loan Characteristics Senior Housing Unstabilized Bonds Coop 7
Slide 8: Property and Loan Overview: Loan Characteristics
Property and Loan Overview Loan Characteristics 8
Slide 9: Property and Loan Overview Section: Loan Characteristics
Property and Loan Overview Section Loan Characteristics For applicable Characteristics, Bonds—complete the Freddie Bonds ADS Form complete the AIE form along with Unstabilized—complete the Unstabilized related supplements contained Comments Form within the workbook. Coop—complete the Coop Asse
Slide 10: Property and Loan Overview
Property and Loan Overview FRE Loan Number Statement Beginning/Ending Dates UPB Number of Months Reported Annual Debt Service Occupancy Rate Annual Replacement Reserves Occupancy – Rent Roll Date 10
Slide 11: Income and Expense
Income and Expense Freddi ny reddie Mac Statement Ending Date INCOME: Residential Rent Residential Concession Short Term Premiums Cooperative Maintenance Fee [Adjusted Commercial Income Enter Endi Laundry Parking Miscellaneous Income O©oOrtran eR wn = Gross Potential Income = S Residential Vacancy =
Slide 12: Income and Expense
Freddie Income and Expense Bcd OPERATING EXPENSES: 16 0.00 17] 0.00 49|Fuel 19|Gas 20|Electric 21|Water/Sewer Total Utilities 27 28 | Statement Ending Date inter Ending Date above 29 | Borrower Adjustment YE Normalized/ 30 INCOME: Actual YTD Annualized 31 1|Residential Rent Enter # of Months above|
Slide 13: AIE Comment Form
PR Freddie AIE Comment Form Mac’ Comments | Risk Trend Update Describe Noteworthy Changes
Slide 14: Data Validation Process
Data Validation Process The AIE template has a series of validation points to assist in completing the form. Validation Application Completion Status “Complete” or “Incomplete” Required Fields • Fields that require user input will include a red border around them • Once a required field has been com
Slide 15: Data Validation Process
Data Validation Process Validation Application Valid Data Range(s) Ranges of data can be controlled via a drop-down list or validation rules on a given data point. For example, “Yes/No” fields will be handled via a drop-down list, preventing users from entering something other than Yes or No in the
Slide 16: Next Steps
Next Steps March 1 – Loan Management Template webinar Late March – PRS System training We will be sending out a blank AIE template and a new AIE Reference Guide in the next few days to all webinar attendees You will be able to begin using the template to complete your analysis Submit quest