Get documents about "Blank Addendum Template
W
Description
Blank Addendum Template document sample
Document Sample
Freddie Mac Capital Markets Execution (CME) - Data Update Template
Instructions
INSTRUCTIONS:
1) Update information in the "Input Sheet" tab.
2) Refer to the "Data Definitions" tab for information on the data elements.
3) All fields must be populated with a value or N/A. Blank fields will not be accepted.
N/A indicates not applicable.
4) All dollar fields should have a comma and two decimal places.
5) All date fields should be entered with the format: mm/dd/yyyy. Slashes must be included.
6) Save the file using the following naming convention and format: cme_update_SSName_Date. The SSName
should be abbreviated to 4 letters. The date should be in the format of MMDDYYYY.
7) Once the file has been saved, e-mail the file to the following e-mail address:
"MF OPS Loan Accounting" mfla@freddiemac.com
This template is intended to be used strictly in connection with communication between Freddie Mac
and its registered Multifamily Seller/Servicers. Any other use is prohibited.
1/7/2011
f07e1413-313e-46ec-88cd-f31873556772.xls Instructions 1
Freddie Mac Capital Markets Execution (CME) - Data Update Template
Data Definitions
1/7/2011
# Data Element Definition Sample Value
1 Freddie Mac Loan Number Freddie Mac loan number 123456789
2 Mortgage Loan Servicer Name of mortgage loan seller Seller ABC
3 Property Name Name of mortgaged property Property DEF
4 City City of mortgaged property New York
5 State State of mortgaged property NY
6 Current Balance (current Current UPB of loan after the scheduled $$
monthly payment has been payment has been received.
received)
7 Current Balance +1 (Projected The UPB of loan projected one month $$
One Month Forward) forward. Assumes the scheduled payment
for the next month has been received.
8 Current Balance +2 (Projected The UPB of loan projected two months $$
Two Months Forward) forward. Assumes the scheduled payment
for the next two months have been received.
9 Indicate # of times the loan has been more 0
# of Times 30+ days Delinquent than 30 days delinquent
10 Note Rate (%) Current note rate 6.150%
11 Loan Term (months) Total loan term 360
12 Amortization Term (months) Total amortization term 360
13 Interest Only Period (months) Total interest only period 24
14 Monthly Debt Service Payment - Monthly debt service on an amortizing basis, $$
AMORTIZING ($) as follows:
For amortizing loans, use current monthly
debt service.
For partial interest only loans, assume 30-
year amortization to calculate monthly
payment.
For full interest only loans, show interest only
payment.
15 Interest Method Actual/360 or 30/360 Actual/360
16 Servicing Fee (as a %) Amount of servicing fee 0.050%
17 Tax Escrow - Up Front Amount of initial deposit into tax escrow at $$ or N/A
Payment closing
($ or N/A)
18 Tax Escrow - Monthly Recurring Monthly payment of tax escrow $$ or N/A
Payment ($ or N/A)
19 Tax Escrow - Current Balance Current balance of tax escrow $$ or N/A
($ or N/A)
20 Insurance Escrow - Up Front Amount of initial deposit into insurance $$ or N/A
Payment reserve at closing
($ or N/A)
21 Insurance Escrow - Monthly Monthly payment of insurance reserve $$ or N/A
Recurring Payment
($ or N/A)
22 Insurance Escrow - Current Current balance of insurance escrow reserve $$ or N/A
Balance ($ or N/A)
1/7/2011
f07e1413-313e-46ec-88cd-f31873556772.xls Data Definitions Page 2 of 7
Freddie Mac Capital Markets Execution (CME) - Data Update Template
Data Definitions
1/7/2011
# Data Element Definition Sample Value
23 Repair/Deferred Maintenance Amount of initial deposit into engineering, $$ or N/A
Reserve - Up Front Payment deferred maint, or repair reserve at closing
($ or N/A)
24 Repair/Deferred Maintenance Monthly payment of engineering reserve $$ or N/A
Reserve - Monthly Recurring
Payment
($ or N/A)
25 Repair/Deferred Maintenance Current balance of engineering, deferred $$ or N/A
Reserve - Current Balance maint, or repair, reserve
($ or N/A)
26 Replacement Reserve - Up Amount of initial deposit into replacement $$ or N/A
Front Payment reserve at closing
($ or N/A)
27 Replacement Reserve - Amount of monthly payment into $$ or N/A
Monthly Recurring Payment replacement reserve
($ or N/A)
28 Replacement Reserve - Current Current balance of replacement reserve $$ or N/A
Balance
($ or N/A)
29 Replacement Reserve - Amount of cap on replacement reserve $$ or N/A
Contractual Cap contractual payment.
($ or N/A)
30 Other Reserve 1 - Up Front Amount of initial deposit into other reserve $$ or N/A
Payment ($ or N/A) account at closing
31 Other Reserve 1 - Monthly Monthly payment of other reserve $$ or N/A
Payment ($ or N/A)
32 Other Reserve 1 - Current Current balance of other reserve account $$ or N/A
Balance
($ or N/A)
33 Other Reserve 1 - Contractual Amount of cap on other reserve contractual $$ or N/A
Cap payment
($ or N/A)
34 Other Reserve 1 Description Description of other reserve purpose. An Description or N/A
"Other Reserve" would be used for reserves
other than the standard escrows of taxes,
insurance, and replacement reserves
35 Other Reserve 2 - Up Front Amount of initial deposit into other reserve $$ or N/A
Payment ($ or N/A) account at closing
36 Other Reserve 2 - Monthly Monthly payment of other reserve $$ or N/A
Payment ($ or N/A)
37 Other Reserve 2 - Current Current balance of other reserve account $$ or N/A
Balance
($ or N/A)
38 Other Reserve 2 - Contractual Amount of cap on other reserve contractual $$ or N/A
Cap payment
($ or N/A)
1/7/2011
f07e1413-313e-46ec-88cd-f31873556772.xls Data Definitions Page 3 of 7
Freddie Mac Capital Markets Execution (CME) - Data Update Template
Data Definitions
1/7/2011
# Data Element Definition Sample Value
39 Other Reserve 2 Description Description of other reserve purpose. An Description or N/A
"Other Reserve" would be used for reserves
other than the standard escrows of taxes,
insurance, and replacement reserves
40 Springing Reserve Name An escrow presently not funded but required Name or N/A
to be funded by borrower upon triggering
event such as default. Applicable to
replacement reserves and tax and insurance
escrows
41 Springing Reserve Amount Designated amount of reserve account that $$ or N/A
($ or N/A) is required to be funded by borrower upon
triggering event such as default
42 Springing Reserve Description Description of escrow account to be funded Description or N/A
by borrower upon triggering event such as
default
43 Beneficiary of Escrow & Entity earning interest on Escrow & Reserve Lender or
Reserve Interest Earnings Accounts (Excluding Side Letter Borrower
(Excluding Side Letters) Agreements)
44 Earnout Reserve Amount Amount of earnout reserve (a loan amount $$ or N/A
($ or N/A) funded but withheld by the lender until a
certain occupancy is attained, usually has
release tests)
45 Earnout Reserve Description Description of earnout reserve tests Description or N/A
46 Letter of Credit Amount Dollar amount of letter of credit $$ or N/A
47 Letter of Credit Description Description of Letter of Credit Purpose Description or N/A
1/7/2011
f07e1413-313e-46ec-88cd-f31873556772.xls Data Definitions Page 4 of 7
Freddie Mac Capital Markets Execution (CME) - Data Update Template
1/7/2011
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Current Balance Current Balance
(current monthly +1 (Projected Current Balance Monthly Debt Tax Escrow - Up
Freddie Mac payment has been One Month +2 (Projected Two # of Times 30+ Note Rate Loan Term Amortization Interest Only Service Payment - Interest Servicing Front Payment
Loan Number Mortgage Loan Servicer Property Name City State received) Forward) Months Forward) days Delinquent (%) (months) Term (months) Period (months) AMORTIZING ($) Method Fee (as a %) ($ or N/A)
1/7/2011
CME Data Update
Page 5 of 7
18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
Repair/Deferred
Repair/Deferred Maintenance Repair/Deferred Replacement
Tax Escrow - Insurance Escrow - Maintenance Reserve - Monthly Maintenance Replacement Reserve - Monthly Replacement Replacement
Monthly Recurring Tax Escrow - Insurance Escrow - Monthly Recurring Insurance Escrow - Reserve - Up Recurring Reserve - Current Reserve - Up Recurring Reserve - Current Reserve - Other Reserve 1 - Other Reserve 1 - Other Reserve 1 - Other Reserve 1 - Other Reserve 2 -
Payment ($ or Current Balance Up Front Payment Payment Current Balance ($ Front Payment Payment Balance Front Payment Payment Balance Contractual Cap Up Front Payment Monthly Payment Current Balance Contractual Cap Other Reserve 1 Up Front Payment
N/A) ($ or N/A) ($ or N/A) ($ or N/A) or N/A) ($ or N/A) ($ or N/A) ($ or N/A) ($ or N/A) ($ or N/A) ($ or N/A) ($ or N/A) ($ or N/A) ($ or N/A) ($ or N/A) ($ or N/A) Description ($ or N/A)
1/7/2011
CME Data Update
Page 6 of 7
36 37 38 39 40 41 42 43
Other Reserve 2 - Other Reserve 2 - Other Reserve 2 - Springing Reserve
Monthly Payment Current Balance Contractual Cap Other Reserve 2 Springing Reserve Amount Springing Reserve Beneficiary of Escrow & Reserve Interest Earnings (Excluding Side
($ or N/A) ($ or N/A) ($ or N/A) Description Name ($ or N/A) Description Letters)
1/7/2011
CME Data Update
Page 7 of 7
Related docs
Other docs by zhm37566
