Docstoc

Partnership Agreement and Template - Excel

Document Sample
Partnership Agreement and Template - Excel Powered By Docstoc
					     A                           B              C       D   E
 1         5   Assets
 2        10   Cash
 3        15   General Operating Cash               0
 4        20   Security Deposit Cash                0
 5        25   MSHDA-Held Oper Reserve Cash         0
 6        30   Other Non-Restr Cash Reserve         0
 7        35   Partnership Cash                     0
 8        40
 9        45   Escrows
10        50   MSHDA-Held Replcmt Reserve           0
11        55   MSDHA-Held Tax Escrow                0
12        60   MSHDA-Held Insurance Escrow          0
13        65   DCE Principal                        0
14        70   Development Cost Escrow Int          0
15        75   Operating Assurance                  0
16        80   Sinking Fund                         0
17        85   Operating Reserve                    0
18        90   Other                                0
19        95
20       100   Accounts Receivable
21       105   Resident Rent Receivable             0
22       110   Other Resident Charges               0
23       115   Non-Resident Receivable              0
24       120   HUD Subsidy Receivable               0
25       125   MSHDA Subsidy Rec -Tenant Base       0
26       130   MSHDA Subsidy Rec -Devlpmt Bas       0
27       132   Other Subsidy Receivables            0
28       135   Related Party Receivable             0
29       140   Owner Receivable                     0
30       145   Partnership                          0
31       150
32       155   Other Current Asset
33       160   Prepaid Expenses-Partnership         0
34       165   Prepaid Expenses-Operating           0
35       170
36       175   Investment in Rental Property
37       180   Land                                 0
38       185   Building                             0
39       190   Building Improvements                0
40       195   Land Improvements                    0
41       197   Furniture & Fixtures                 0
42       200   Equipment and Vehicles               0
43       205   Accumulated Depreciation             0
44       210
45       215   Other Assets
46       220   Deferred Mortgage Costs,             0
47       225   (net of amortization)
48       230   Organizational Costs,                0
49       235   (net of amortization)
50       240   Syndication Costs,                   0
51       245   (net of amortization)
      A                            B             C       D   E
 52       250   Monitoring Fees,                     0
 53       255   (net of amortization)
 54       260   Deposits                             0
 55       265
 56       270   TOTAL ASSETS                         0
 57       275
 58       280   Liabilities & Owner's Equity
 59       285   Accounts Payable & Accrued Exp
 60       290   General Trade Payables               0
 61       295   Constuction Payables                 0
 62       300   Partnership Payables                 0
 63       305   Payroll Payable                      0
 64       310   Management Fees Payable              0
 65       315   Utilities Payable                    0
 66       320   Auditing Fees Payable                0
 67       325   Short-term Notes Payable-oper        0
 68       330   Short-term Notes Payable-prtnr       0
 69       335   Owner Adv. - operating               0
 70       337   Owner Adv. - oper. - Non-Repay       0
 71       340   Owner Adv. - partnership             0
 72       345   Surcharges Payable                   0
 73       350   Related Party Payable                0
 74       355   HUD Subsidy Payable                  0
 75       357   Repayable Subsidy                    0
 76       360   MSHDA Resident-Basd Subs Paybl       0
 77       365   Other Subsidy Payable                0
 78       370   Unearnd Rntl Inc -Operating          0
 79       372   Unearnd Rntl Inc -Congreg Care       0
 80       375   Current Mortgage Int - MSHDA         0
 81       380   Current Mortgage Int - HOME          0
 82       385   Current Mortgage Int - Other         0
 83       387   Delinquent Mortgage Interest         0
 84       389   Delnqunt or Defrd Mort Prn Pmt       0
 85       390   as a result of mortg wrkout
 86       392   Real Estate Taxes                    0
 87       395   Security Deposit Liability           0
 88       400   Current Portion of 1st Mortg         0
 89       405   Current Portion of Other Mrtgs       0
 90       410   Developers Fees Payable              0
 91       415   Other-Accrued Liab-Operating         0
 92       420   Other-Accrued Liab-Partnership       0
 93       430
 94       432   Mortgages Payable
 95       435   1st Mortgage Payable                 0
 96       445   Defrd Int on Addtn'l Mrtgs           0
 97       450   Acrd Prin on Addtn'l Mrtgs           0
 98       455   MSHDA HOME Loan                      0
 99       457   Home Presrv Initv Loan               0
100       460   Amenity Impvt/Defrd Maint Loan       0
101       465   Small Size Loan                      0
102       470   Security Loan                        0
      A                          B             C       D   E
103       475   Other                              0
104       480
105       485   Owner's Equity                     0
106       490
107       495   TOTAL LIAB & OWNERS' EQUITY        0
108       550
109       555   INCOME:
110       560   RENTAL INCOME
111       565   Apartments                         0
112       570   MSHDA Subsidy Income               0
113       575   HAP Subsidy Income                 0
114       580   Other Subsidy Income               0
115       585   Total Rent Potential               0
116       590   Vacancy Loss                       0
117       595   Net Rental Revenue                 0
118       600   OTHER INCOME
119       605   Carport Income                     0
120       607   Sec 236 Interest Subsidy           0
121       610   Interest Income                    0
122       615   Laundry Income                     0
123       620   Tenant Charges                     0
124       625   Congregate Services Income         0
125       630   Commercial Income                  0
126       635   Other                              0
127       640   Total Other Income                 0
128       645   TOTAL INCOME                       0
129       650
130       655   EXPENSES
131       660   Management Fees                    0
132       665   (Development's Oper. Acct.)
133       670   Managements Fees                   0
134       675   (Partnership's Oper. Acct.)
135       680   Premium Managements Fees           0
136       685   Salaries & Wages                   0
137       690   Payroll Taxes                      0
138       695   COE Salaries & Travel              0
139       700   Rent Fee Units                     0
140       705   Audit Fees                         0
141       710   Bad Debt                           0
142       715   Congregate Services Expenses       0
143       720   Administrative                     0
144       725   Operating & Maintenance            0
145       730   Utilities                          0
146       735   Depreciation & Amortization        0
147       740   Property Taxes                     0
148       745   Insurance                          0
149       750   Interest                           0
150       755   Partnership Expenses               0
151       760   Other                              0
152       765   Total Expenses                     0
153       770   NET INCOME/LOSS                    0
      A                         B                   C        D   E
154       780   Subsidy mshda credited to mort          0
155       790   Subsidy development entitiled           0
156       800   Subsidy Receivable/Payable              0
157       805   SECTION 236 EXCESS INCOME
158       810   Unused Auth Sec 236 Exces Inc           0
159       815   Unapprv Sect 236 Exces Inc HUD          0
160       820   Auth Sec 236 Exces Inc Pay HUD          0
161       825
162       830   TAX & INS ESCROW ANALYSIS INFO
163       832   Tax/Insur Surplus or Deficit            0
164       835
165       840   SCHEDULE UNADJUSTED ITEMS
166       845   Unadj Item - Acct Receivable            0
167       850   Unadj Item - Liabilities                0
168       855
169       860   SCHEDULE I-B INFORMATION
170       865   Max Allowable Distribution               0
171       870   Pd/Accrued Overhd Reimbursmnt            0
172             If Cash Flow Requrd, complete: Yes/No
173       880   Investment Income -Reserve Fnd           0
174       885   Other Add Reqrd -Loan Agrmnt             0
175       890   Other Subtrct Requrd-Loan Agrm           0
176       895   Max Annl Debt Service %               0.00
177       900   Cash Flow Trap Reqrd-Loan Agrm           0
178       905   Regulatory Fee                           0
179       910   Surplus Funds Used -Pymt Debt            0
180       915   SMALL SIZE & SECURTY LOAN INFO
181       920   Small Size Loan
182       925   Bal @ begin of year                      0
183       930   Current year repayments                  0
184       935   Current year draws                       0
185       937   End of year balance                      0
186       940   Amt proceeds against mort pymt           0
187       945   Security Loan
188       950   Bal @ begin of year                      0
189       955   Current year repayments                  0
190       960   Current year draws                       0
191       962   End of year balance                      0
192       965   Amt proceeds against mort pymt           0
193             Development recieved security  Yes/No
194             Security Exp on Mort Commitmnt Yes/No
195    968      Total Sec Exp Rpt on MLC Rpt             0
196    970      Class of Sec Expenditures
197    975      Equipment                                0
198    980      Payroll & Payroll Taxes                  0
199    985      Contractual Services                     0
200    990      Other                                    0
201    995      MISCELLANEOUS INFO
202   1000      Escrow Draws Receivable                  0
203   1005      Approved Undisbursed LD Pymts            0
204   1010      RR Defrls, Dlnqut MSHDA ln/grt           0
      A                         B                  C         D         E
205    1015   1 mnth's gross rent potential            0
206    1020   Replacement Reserve Needs                0
207    1025   Amt Wrkout Repymt Obligations            0
208    1040   Delinq or Defer P from workout           0
209    1055   Restricted DCE Intert-prior yr           0
210    1060   Restricted DCE Intert-crnt yr            0
211    1065   Prior yr Cum L.D. Pymt                   0
212           Surplus funds allocation         Comm Dev Fund or 2nd Mortgage
213   1070    SCHEDULE II INPUT INFO
214   1085    Owner's Initial Equity                     0
215   1090    Sect 8/236 Trns Recomp Equity              0
216   1095    Cum LD Percentage -OR-                  0.00
217   1100    fixed amt for Reg Agreement                0
218   1110    Non-Cum LD Percentage -OR-              0.00
219   1115    fixed amt from Reg Agreement               0
220           Cutoff date                         01/00/00
221           Sale or preservation date           01/00/00
222   1120    Surplus Fnds Avail for Distrib             0
223   1125    Prior Year Cum Carry Forward               0
224   1130    Potential LD                               0
225   1135    L.D. Pymt made Current Year                0
226   1140    Cumulative Carry Forward                   0
227   1145    PAYMENT SUMMARY
228   1150    Tax & Insurance Escrow Deficit            0
229   1155    Amenity Imprvmt/Dfrd Maint Ln             0
230   1160    Workout Repayment Obligations             0
231   1165    HOME Loan                                 0
232   1170    Home Preservtn Initiative Loan            0
233   1175    Repayable Subsidy Payable                 0
234   1180    Small Size/Security Loan                  0
235   1185    Operating Reserve Cash                    0
236   1190    Replacement Reserve Needs                 0
237   1195    Deferred Mortgage Interest                0
238   1200    Deferred Mortgage Principal               0
239   1205    Second or Third Mortgage                  0
240   1210    Community Development Fund                0
241           Source of Payment                         0
242   1220    Operating Cash                            0
243   1230    Operating Reserve Cash                    0
244   1235    DCE Interest                              0
      A                                                C              D      E
1 SCHEDULE I - INPUT

2 NAME:                1117 HASLETT ROAD
3 NO:                  1036
     PARTNERSHIP
4 NAME:
5 YE:                  December 31, 2009
6 Schedule 1           0

7    CONTACT INFORMATION
8                     ACCOUNTING FIRM
 9 Firm Name
10 Contact Name
11 Phone Number
12 Email Address
13                    MANAGEMENT AGENT
14   Name
15   Contact Name
16   Phone Number
17   Email Address
18                    OWNER
19   Name
20   Contact Name
21   Phone Number
22   Email Address
23
24
     Line # From
25 Sch 1and/or 2                          BALANCE SHEET             Amount
26
27                                            Assets
28
29                 Cash
30               0 General Operating Cash
31                    Security Deposit Cash
32                   0 MSHDA-Held Operating Reserve Cash
33                   0 Other Non-Restricted Cash Reserve Accounts
34                    Partnership Cash
35
36                    Escrows
37                    MSHDA-Held Replacement Reserve
38                    MSHDA-Held Tax Escrow
39                    MSHDA-Held Insurance Escrow
40                    DCE Principal
41                   0 Development Cost Escrow Interest
42                    Operating Assurance
43                    Sinking Fund
44                    Operating Reserve
45                    Other
46
     A                                         C                 D       E
47         Accounts Receivable
48       0 Resident Rent Receivable
49       0 Other Resident Charges
50       0 Escrow Draws Receivable
51       0 Non-Resident Receivable
52       0 HUD Subsidy Receivable
53       0 MSHDA Subsidy Receivable - Tenant Based
54       0 MSHDA Subsidy Receivable - Development Based
55       0 Other Subsidy Receivable
56       0 Related Party Receivable
57         Owner Receivable
58         Partnership
59
60         Other Current Asset
61         Prepaid Expenses - Partnership
62         Prepaid Expenses - Operating
63
64         Investment in Rental Property
65         Land
66         Building
67         Building Improvements
68         Land Improvements
69         Furniture & Fixtures
70         Equipment & Vehicles
71         Accumulated Depreciation


72
73         Other Assets
74         Deferred Mortgage Costs, net of amortization
75         Organizational Costs, net of amortization
76         Syndication Costs, net of amortization
77         Monitoring Fees, net of amortization
78         Deposits
79
80         TOTAL ASSETS                                              0
81
82                                Liabilities & Owner's Equity
83
84         Accounts Payable & Accrued Expenses
85       0 General Trade Payables
86         Construction Payables
87         Partnership Payables
88       0 Payroll Payable
89       0 Management Fees Payable
90       0 Utilities Payable
91       0 Auditing Fees Payable
92       0 Short-term Notes Payable - operating
93         Short-term Notes Payable - partnership
94       0 Owner Advances - operating
95         Owner Advances - operating - Non-repayable
96         Owner Advances - partnership
      A                                         C                                D       E
 97       0 Surcharges Payable
 98       0 Related Party Payable
 99       0 HUD Subsidy Payable
100       0 Repayable Subsidy
101       0 MSHDA Resident-Based Subsidy Payable
102       0 Other Subsidy Payable
103       0 Unearned Rental Income - operating
104         Unearned Rental Income - congregate care
105         Current Mortgage Interest - MSHDA
106         Current Mortgage Interest - HOME
107         Current Mortgage Interest - Other
108       0 Delinquent Mortgage Interest Payments
109       0 Delinquent Mortgage Principal Payments
          0 Deferred Mortgage Interest Payments Due to Mortgage Workout
110         (or if Sch 1-J, deferred HOME interest)
          0 Deferred Mortgage Principal Payments Due to Mortgage Workout
111         (or if Sch 1-J, deferred HOME interest)
112         Real Estate Taxes
113         Security Deposit Liability
114         Current Portion of Mortgages
115         Developer Fees Payable
116         Other Accrued Liabilities - operating (not included on Schedule 1)
117       0 Other Accrued Liabilities - operating
118         Other Accrued Liabilities - partnership
119
120         Long-term Liabilities
121         Long-term Portion of First Mortgage
122         Deferred Interest on Second and/or Third Mortgage
123         Accrued Principal on Second and/or Third Mortgage
124       0 Outstanding Balance of MSHDA HOME Loan
125       0 Outstanding Balance of HOME Perservation Initiative Loan
126       0 Amenity Improvement/Deferred Maintenance Loan
127       0 Small Size Loan
128       0 Security Loan
129         Outstanding Balance of Preservation Fund Loan
130         Other
131
132         Owners' Equity
133
134         TOTAL LIABILITIES & OWNERS' EQUITY                                       0
135
136
137
138                          INCOME STATEMENT INFORMATION
139         INCOME:
140         RENTAL INCOME
141           Apartments
142           MSHDA Subsidy Income
143           HAP Subsidy Income
144           Other Subsidy Income
145             Total Rent Potential                                                 0
146           Vacancy Loss
      A                                       C                             D       E
147            Net Rental Revenue                                               0
148         OTHER INCOME
149           Carport Income
150           Sec 236 Interest Subsidy
151           Interest Income
152           Laundry Income
153           Tenant Charges
154           Congregate Services Income
155           Commercial Income
156           Other
157              Total Other Income                                             0
158         TOTAL INCOME                                                        0
159
160         EXPENSES:
161         Management Fees (Development's Operating Account)
162         Management Fees (Partnership's Operating Account)
163         Premium Management Fees
164         Salaries & Wages
165         Payroll Taxes
166         COE Salaries & Travel
167         Rent Free Units
168         Audit Fees
169         Bad Debt
170         Congregate Services Expense
171         Administrative
172         Operating & Maintenance
173         Utilities
174         Depreciation & Amortization
175         Property Taxes
176         Insurance
177         Interest
178         Partnership Expenses
179         Other
180           Total Expenses                                                    0
181         NET INCOME/LOSS                                                     0
182
183                 Developer Fees Info (Only Applicable to Schedule 1-J)
184         Prior Year Deferred Developer Fees
185       0 Developer Fees Paid in Current Year
186       0 Developer Fees Waived in Current Year
187       0 Current Year Deferred Developer Fees                                0
188       0 CARRINGTON PLACE only: Amount to amortize principal balance
189
190                             SECTION 236 EXCESS INCOME
191       0 Unused Authorized Section 236 Excess Income
192       0 Unapproved Section 236 Excess Income Payable to HUD
193       0 Authorized Section 236 Excess Income Payable to HUD
194
195                 TAX & INSURANCE ESCROW ANALYSIS INFORMATION
196       0 Tax/Insurance Escrow Surplus (Deficit)
197
      A                                         C                                   D       E
198                          SCHEDULE OF UNADJUSTED ITEMS
199       0 Unadjusted Items-Accounts Receivable
200       0 Unadjusted Items-Liabilities
201
202         REGULATORY AGREEMENT & LOAN AGREEMENT INFORMATION
203             (only Applicable to Developments using Schedule 1-B)
204       0 Maximum Allowable Distribution
205       0 Paid/Accrued Overhead Reimbursement
206         Is the development subject to a cash flow acct requirement?
207         If subject to the cash flow requirement, complete the following items
208       0 Investment Income from the Reserve Fund
209       0 Other Additions Required by the Loan Agreement
210       0 Other Subtractions Required by the Loan Agreement
211       0 Maximum Annual Debt Service Percentage
212       0 Cash Flow Trap Requirement Per Loan Agreement
213       0 Regulatory Fee
214       0 Surplus Funds Used for Payment of Debt Services on Seller Notes
215
216                    SMALL SIZE & SECURITY LOAN INFORMATION
217         Small Size Loan
218       0 Beginning of Year Balance                                                   0
219       0 Current Year Repayments
220       0 Current Year Draws
221       0 End of Year Balance                                                         0
          0 Amount of Small Size Loan proceeds applied against mortgage
222         payments during current year
223         Security Loan
224       0 Beginning of Year Balance                                                   0
225       0 Current Year Repayments
226       0 Current Year Draws
227       0 End of Year Balance                                                         0
228       0 Security loan proceeds applied agains current year's mortgage payment
229       0 Did the development receive security loan proceeds during year?
          0 Is the Security Revenue reported on the mortgage loan commitment
230         report (Developmental Rental Schedule)?
          0 Total Security Expenditures reported on the mortgage loan
231         commitment report (Total Development Expenditures)?
232         Classification of Security Expenditures
233       0 Equipment
234       0 Payroll & Payroll Taxes
235       0 Contractual Services
236       0 Other
237
238                         MISCELLANEOUS INFORMATION
240       0 Approved Undisbursed Limited Dividend (L.D.) Payments
241       0 R/R Deferrals, Delinquent MSHDA Loans/ Grants
242       0 Security Deposit Under (Over) Funded                                        0
243       0 One Month’s Gross Rent Potential
244       0 Replacement Reserve Needs
245       0 Amount of Workout Repayment Obligations
246       0 MSHDA Subsidy portion payable to MSHDA
           A                                        C                                            D             E
247              Deferred Mortgage Principal (Applicable only to 1-H)
248              Deferred Mortgage Interest (Applicable only to 1-H)
251            0 Prior Year’s Cumulative L.D. Payment
252
253                                SURPLUS CASH ALLOCATIONS
                 Schedule 1-B and 1-D - If surplus funds are available, are they to be
                 transferred to MSHDA's Community Development Fund, or to a second Comm Dev
254              mortgage?                                                             Fund
255
256
257
258                             SCHEDULE II INPUT INFORMATION
259              Development does not complete a Schedule 2
260   1          Owner's Initial Equity
261   1A         Section 8/236 Preservation Transaction Recomputed Initial Equity
262
263
264   3          Cumulative LD Payment Percentage -OR-                                                      You must enter LD % -OR
265                   fixed amount from regulatory agreement
266   4          Non-Cumulative LD Payment Percentage -OR-                                                  You must enter LD % -OR
267                   fixed amount from regulatory agreement
268              Cut-off Date                                                                               ** If the cut-off date is the c
269              Sale/Preservation Transaction Closing Date
270              Prior Year Cumulative Carryforward L.D.
271   IV         L.D. Payments Made in Current Year
272
273              Starting Year of Schedule II                                                        1973


                  THE PRIOR YEAR SCHEDULE 2 INFORMATION IS NOT REQUIRED. IF YOU ENTER THE
274                       INFORMATION IT WILL PREPARE THE SCHEDULE 2 THAT IS REQUIRED IN TH
275

                                                                                           Surplus Funds
                                                                                            Available for
276                                                     Schedule II Prior Year Information   Distribution
277                                                                                 1973
278                                                                                 1974
279                                                                                 1975
280                                                                                 1976
281                                                                                 1977
282                                                                                 1978
283                                                                                 1979
284                                                                                 1980
285                                                                                 1981
286                                                                                 1982
287                                                                                 1983
288                                                                                 1984
289                                                                                 1985
290                                                                                 1986
291                                                                                 1987
292                                                                                 1988
293                                                                                 1989
      A   C          D   E
294           1990
295           1991
296           1992
297           1993
298           1994
299           1995
300           1996
301           1997
302           1998
303           1999
304           2000
305           2001
306           2002
307           2003
308           2004
309           2005
310           2006
                F                  G        H       K        L        M   N                O           P   R
1

2

3

4
5
6

7
8 Accrual Basis                        Basis of Accounting
 9 YES                                 Was a management letter issued?
10                                     Compliance Report
11 NO                    Were any material weaknesses noted in internal control?
12 InternalControlWeakness yes, click cell to left to provide explanation that is noted in report.
                         If
13 YES                                 If material weaknesses were noted, was explanation provided?
14   YES                               Were noncompliance issues noted?
15   Account Bal Variance(s)           If yes, what type of issues?
16   AcctBalVariances   Select cell to left to enter Account Balance Variances
17   OtherNonCompliance Select cell to left to enter Account Balance Variances
18   YES                               If noncompliance issues were noted, was explanation provided?
19
20
21
22
23
24
   **** If you have a line item that is not included on the balance sheet, but
25 you need to enter it to have the schedule 1 calculate correctly, select an
26 "X" in column E next to the applicable line item. If you have the "X"
27 selected, the total will not be included in the total assets or liabilities.
28
29
30                             PAYMENT SUMMARY
31                             0       Tax & Insurance Escrow Deficit
32                             0       Amenity Improvement/Deferred Maintenance Loan
33                             0       Workout Repayment Obligations
34                             0       HOME Loan
35                             0       HOME Preservation Initiative Loan or Preservation Loan
36                             0       Repayable Subsidy Payable
37                             0       Small Size/Security Loan
38                             0       Operating Reserve Cash
39                             0       Replacement Reserve Needs/Replacement Reserve
40                             0       MSHDA Subsidy Repayment Obligation
41                             0       Deferred Mortgage Interest
42                             0       Deferred Mortgage Principal
43                             0       Second or Third Mortgage
44                             0       Community Development Fund
45                                       Source of Payment (only applicable to Schedule 1-D & 1-G
46                             0           Operating Cash
                F              G       H     K       L      M       N                O           P   R
47                         0          Operating Reserve Cash
48                         0          DCE Interest
49
50
51
52   INSTRUCTIONS:
53
     All yellow shaded cells are entry fields.
54   All blue shaded cells are accounts that are used in the Schedule 1.
55   The numbers in Column A are the corresponding line numbers from the Schedule 1.
56   All bolded accounts are to be separated and not grouped with others.

57
58   Select the developments in the pull down list in cell "C2". When you have the
59   development name selected, the corresponding MSHDA Number and Schedule 1 will be
     automatically filled in cells "C3" and "C6".
60   Enter the applicable year end in cell "C5".
61   Enter the applicable contact information, and accounting basis and internal control and
62   compliance information in the yellow cells.
     The Schedules will automatically calculate on the Schedule 1, Schedule 2, and Schedule
63   3 tabs.
64   The prior year Schedule 2 information will automatically fill if you enter the prior year
65   detail in the bottom section of the Input tab.
66
   After you have completed the worksheet verify there are no "Not Acceptable" errors in the
67 following section.
68 NOTE: This is not all of the items that will be checked by the asset manager.
69
70
71
     Following are checks that the worksheet is entered correctly. If an item
72   shows "Not Acceptable", view comment on cell for an explanation of the
73   error.
74   Not Acceptable        Partnership Name, Year End & Contact Information
75   Acceptable            Internal Control and Compliance Letter Detail
76   Acceptable            Assets = Liabilities & Owner's Equity
77   Acceptable            Rent Potential
78   Acceptable            Repayable Subsidy
79   Acceptable                    Small Size Loan
80   Acceptable                    Security Loan
81   Acceptable                    HOME Preservation Loan
82   Acceptable                    Schedule 1-B Information (Cash Flow Question)
83   Acceptable                    Schedule 1-B & 1-D Surplus Cash Allocation
84   Acceptable                    Schedule 2 Cut-off Date
85   Acceptable                    Schedule 2 Owner's Equity
86   Acceptable                    Schedule 2 Cumulative LD
87   Acceptable                    Schedule 2 Non-Cumulative LD
88   Acceptable                    Current Year Cumulative Carryforward
89
90
91
92
93
94
95
96
             F       G    H    K    L    M     N          O        P   R
 97
 98
 99
100
101
102
103
104
105
106
107
108
109

110

111
112
113
114
115
116
117
118
119
120
121
122
123
124   *** Only include HOME loans that were processed through MHSDA.
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
      F   G   H   K   L   M   N   O   P   R
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
      F   G   H   K   L   M   N   O   P   R
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221

222
223
224
225
226
227
228
229

230

231
232
233
234
235
236
237
238
240
241
242
243
244
245
246
                             F               G       H        K         L          M       N           O   P   R
           247
           248
           251
           252
           253


           254
           255
           256
           257
            258                       Current Year Schedule 2 Summary
            259         Suplus Funds                 Potential          LD/HOME          Cumulative
            260       Available for Dist                 LD                 Paid        Carryforward
            261                              0                  0                  0               0
            262
            263
        You must enter LD % -OR- the fixed amount. Do NOT enter numbers in both fields.
            264
            265
        You must enter LD % -OR- the fixed amount. Do NOT enter numbers in both fields.
            266
            267
            268
        ** If the cut-off date is the current year, it will calculate the prorated amount for you.
            269
            270
            271
            272
           273

QUIRED. IF YOU ENTER THE FOLLOWING PRIOR YEAR
            REQUIRED IN THE AUDIT REPORT.
E 2 THAT IS 274
           275

                                                                  Cumulative
                                                 LD/HOME          Carryfwd of
           276         Potential LD                Paid              L.D.
           277                                                                 0
           278                                                                 0
           279                                                                 0
           280                                                                 0
           281                                                                 0
           282                                                                 0
           283                                                                 0
           284                                                                 0
           285                                                                 0
           286                                                                 0
           287                                                                 0
           288                                                                 0
           289                                                                 0
           290                                                                 0
           291                                                                 0
           292                                                                 0
           293                                                                 0
      F   G   H   K   L       M   N   O   P   R
294                       0
295                       0
296                       0
297                       0
298                       0
299                       0
300                       0
301                       0
302                       0
303                       0
304                       0
305                       0
306                       0
307                       0
308                       0
309                       0
310                       0
                                                 SCHEDULE I
                                  FUNDS AVAILABLE FOR DISTRIBUTION
                                                December 31, 2009



SECTION 1
1      Operating Cash                                                      $   -0-
2      MSHDA-Held Operating Reserve Account                                    -0-
3      Other Non-Restricted Cash Reserve Accounts                              -0-
4      TOTAL AVAILABLE CASH (PER AUDIT)                                              $     -

SECTION 2
ADD:
5      Resident Rent Receivable                                            $   -0-
6      Other Resident Charges                                                  -0-
7      Non-Resident Receivable                                                 -0-
8      Unadjusted Items-Accounts Receivable                                    -0-
9      Subsidy Receivable                                                      -0-
10     Development Cost Escrow Interest                                        -0-
11     Tax/Insurance Escrow Surplus (Deficit)                                  -0-
12     Escrow Draws Receivable                                                 -0-
13     TOTAL ADDITIONS                                                               $   -0-
14     TOTAL CASH AND ADDITIONS                                                          -0-

SECTION 3
DEDUCT:
15   Trade Accounts And Surcharges Payable, Accrued Expenses
     Liabilities And Other Short-term Operating Liabilities                $   -0-
16     Subsidy Payable                                                         -0-
17     Unadjusted Items-Liabilities                                            -0-
18     Unused Authorized Section 236 Excess Income                             -0-
19     Unapproved Section 236 Excess Income Payable to HUD                     -0-
20     Authorized Section 236 Excess Income Payable to HUD                     -0-
21     Approved Undisbursed Limited Dividend (L.D.) Payments                   -0-
22     Prepaid Rent/Unearned Rental Income                                     -0-
23     Delinquent Mortgage Principal Payments or Deferred Mortgage
       Principle Payment as a Result of Mortgage Workout                       -0-
24     Delinquent Interest Payment or Deferred Mortgage Interest Payment
       as a Result of Mortgage Workout                                         -0-
25     R/R Deferrals, Delinquent MSHDA Loans/ Grants                           -0-
26     Security Deposit Not Funded (Over Funded)                               -0-
27     One Month’s Gross Rent Potential                                        -0-
28     TOTAL DEDUCTIONS                                                              $   -0-
29    SURPLUS FUNDS (LINE 14 MINUS LINE 28). Insert the actual
      amount even if it is negative.                                                      $    -

SECTION 4
30   Replacement Reserve Needs                                                  $   -0-
31    Subtotal (Line 29 minus Line 30)                                              -0-
32    Amenity Improvement/Deferred Maintenance Loan                                 -0-
33    Subtotal (Line 31 Minus Line 32)                                              -0-
34    Amount of Workout Repayment Obligations                                       -0-
35    Subtotal (Line 33 Minus Line 34)                                              -0-
36    Amount of MSHDA Subsidy Repayment Obligations                                 -0-
37    Subtotal (Line 35 Minus Line 36)                                              -0-

NOTE: Complete Line 38 for Duvernay Park #1039; Line 39 for The Depot
#971; Line 40 for Maplewood Manor #3180; all others go to Line 42.

38    DUVERNAY PARK - Surplus cash to be distributed to replacement
      reserve. (Line 37 if positive, if negative enter -0-)                         -0-
39    THE DEPOT - Surplus cash to be distributed to deferred interest (25%
      of Line 37, if negative enter -0-)                                            -0-
40    MAPLEWOOD MANOR - 25% of Outstanding Balance of Preservation
      Fund Loan                                                                     -0-
41    MAPLEWOOD MANOR - Surplus cash to be distributed to
      Preservation Fund Loan (Less of Line 37 or Line 40, if Line 37 negative
      enter -0-)                                                                    -0-
42    SURPLUS FUNDS AVAILABLE FOR DISTRIBUTION (LINE 37
      MINUS LINES 38, 39 AND 41)                                                          $   -0-
43     Current Years Maximum Potential L.D. Payment                                       $    -
NOTE: Complete Lines 44 through 48 only for developments with
MSHDA HOME Loans; all others go to Line 49.
Excluding Orianna Ridge #1074, Research Park #300 and Rosewood Park
#1022, which have no HOME loans due from surplus cash.

SECTION 5
44    HOME Loan Repayment – Step 1                                              $   -0-
45    HOME Loan Repayment – Step 2                                                  -0-
46    Outstanding Balance of MSHDA HOME Loan                                        -0-
47    Amount to Be Repaid on MSHDA HOME Loan, if negative enter -0-                 -0-
48    Net Potential L.D. Payment (Line 44 Minus Line 47)                            -0-
49    Subtotal (Line 42 minus Line 43; or Line 42 minus the Sum of Line 47
      and Line 48 for HOME loan recipiants)                                               $     -


50    Sum of Lines 2 and 10                                                     $   -0-
51    OPERATING RESERVE CASH TO BE SUBMITTED TO MSHDA:
      DEDUCT LINE 50 FROM LINE 49. If LINE 49 is negative, insert “0”.                    $   -0-
SECTION 6

              SUMMARY OF CHECKS AND/OR MSHDA-HELD RESERVE TRANSFERS DUE:


A SEPARATE CHECK AND/OR MSHDA-HELD RESERVE TRANSFER REQUEST MUST BE SUBMITTED FOR
EACH AMOUNT REPORTED ON LINES 52 THROUGH 61 WITHIN 120 DAYS AFTER THE DEVELOPMENT’S
YEAR-END. PLEASE INDICATE THE PURPOSE ON EACH CHECK OR MSHDA-HELD RESERVE TRANSFER
   REQUEST. FAILURE TO COMPLY WITH THIS REQUEST WILL AFFECT THE MANAGEMENT AGENT’S
                        ELIGIBILIGY FOR PREMIUM MANAGEMENT FEES.


52   The amount from Line 11, if a deficit (Tax/Insurance Escrow)          $   -0-
53   The lesser of Line 31 or Line 32-Amenity Improvement/Deferred
     Maintenance Loan (If Line 31 is negative, insert "0")                 $   -0-
54   The lesser of Line 33 or Line 34-Workout Repayment Obligations (If
     Line 33 is negative, insert "0")                                      $   -0-
55   The lesser of Line 35 or Line 36-MSHDA Subsidy Repayment
     Obligations (If Line 35 is negative, insert "0")                      $   -0-
56   The amount from Line 47 (MSHDA HOME Loan)                             $   -0-
57   The amount from Line 51 (Operating Reserve Cash)                      $   -0-
58   The lesser or Line 29 or Line 30-Replacement Reserve Needs (If Line
     29 is negative, insert “0”).                                          $   -0-
59   The amount from Line 38 (Replacement Reserve)                         $   -0-
60   The amount from Line 39 (Deferred Interest)                           $   -0-
61   The amount from Line 41 (Preservation Fund Loan)                      $   -0-
       1117 HASLETT ROAD                                                  MSHDA NO.1036
                                         SCHEDULE II
                              FUNDS AVAILABLE FOR DISTRIBUTION
                                      December 31, 2009

1.    OWNER INITIAL EQUITY                            $           -0-
1a.   SECTION 8/236 PRESERVATION                      $           -0-

2.    MAXIMUM L.D. PAYMENT:                           $           -0-
3.    CUMULATIVE %                          0%        $           -0-
4.    NON-CUMULATIVE %                      0%        $           -0-
      CUT-OFF DATE:


5.    SALE/PRESERVATION TRANSACTION
      CLOSING DATE:


       I.                             II.                  III.              IV.               V.
                              SURPLUS FUNDS
              YEAR OF         AVAILABLE FOR                               L.D./HOME     CUMULATIVE L.D.
          OPERATION            DISTRIBUTION          POTENTIAL L.D.       LOAN PAID     CARRY FORWARD
       1973                                      0                    0               0                 0
       1974                                      0                    0               0                 0
       1975                                      0                    0               0                 0
       1976                                      0                    0               0                 0
       1977                                      0                    0               0                 0
       1978                                      0                    0               0                 0
       1979                                      0                    0               0                 0
       1980                                      0                    0               0                 0
       1981                                      0                    0               0                 0
       1982                                      0                    0               0                 0
       1983                                      0                    0               0                 0
       1984                                      0                    0               0                 0
       1985                                      0                    0               0                 0
       1986                                      0                    0               0                 0
       1987                                      0                    0               0                 0
       1988                                      0                    0               0                 0
       1989                                      0                    0               0                 0
       1990                                      0                    0               0                 0
       1991                                      0                    0               0                 0
       1992                                      0                    0               0                 0
       1993                                      0                    0               0                 0
       1994                                      0                    0               0                 0
       1995                                      0                    0               0                 0
       1996                                      0                    0               0                 0
       1997                                      0                    0               0                 0
       1998                                      0                    0               0                 0
       1999                                      0                    0               0                 0
       2000                                      0                    0               0                 0
       2001                                      0                    0               0                 0
       2002                                      0                    0               0                 0
2003   0   0   0   0
2004   0   0   0   0
2005   0   0   0   0
2006   0   0   0   0
2009   0   0   0   0
                    COMPLIANCE REPORT/INTERNAL CONTROL
Internal Control Weaknesses




Compliance Variance Notes

Account Balance Variances

Account
If "Other" selected above, provide name of account

           RECONCILIATION
                                              Balance per MIE:
                                    Balance per Balance Sheet:
                                                      Variance           0
                                          Variance Percentage        0.00%
           Variance Doesn't Require Reconciliation

                                                 Balance per MIE:            0
                                                Reconciling Items:
                                                         Amounts




                                                Total Adjustments:           0

                                      Balance Per Balance Sheet:             0
           Explanation:
Account
If "Other" selected above, provide name of account

           RECONCILIATION
                                              Balance per MIE:
                                    Balance per Balance Sheet:
                                                      Variance           0
                                          Variance Percentage        0.00%
           Variance Doesn't Require Reconciliation

                                                 Balance per MIE:            0
                                                Reconciling Items:
                                                         Amounts




                                                Total Adjustments:           0

                                      Balance Per Balance Sheet:             0
           Explanation:




Account
If "Other" selected above, provide name of account

           RECONCILIATION
                                              Balance per MIE:
                                    Balance per Balance Sheet:
                                                      Variance           0
                                          Variance Percentage        0.00%
           Variance Doesn't Require Reconciliation

                                                 Balance per MIE:            0
                                                Reconciling Items:
                                                         Amounts
                                                Total Adjustments:           0

                                      Balance Per Balance Sheet:             0
           Explanation:




Account
If "Other" selected above, provide name of account

           RECONCILIATION
                                              Balance per MIE:
                                    Balance per Balance Sheet:
                                                      Variance           0
                                          Variance Percentage        0.00%
           Variance Doesn't Require Reconciliation

                                                 Balance per MIE:            0
                                                Reconciling Items:
                                                         Amounts




                                                Total Adjustments:           0

                                      Balance Per Balance Sheet:             0
           Explanation:




Account
If "Other" selected above, provide name of account

           RECONCILIATION
                                                Balance per MIE:
                                       Balance per Balance Sheet:
                                                  Variance        0
                                       Variance Percentage    0.00%
         Variance Doesn't Require Reconciliation

                                          Balance per MIE:            0
                                         Reconciling Items:
                                                  Amounts




                                         Total Adjustments:           0

                                 Balance Per Balance Sheet:           0
         Explanation:




Other Non-compliance Issues
Descrition of Variance   Amount of Over/Under Statement
ASSETS
NONE




LIABILITIES
NONE

				
DOCUMENT INFO
Description: Partnership Agreement and Template document sample