Project Name: Date:
ANNUAL CASH FLOW ANALYSIS - Tenant Occupied Property
A. Income Summary
Net Rentable Sq. Ft. 0 0 0 0 0 0 0 0 Estimated Resident Paid Utilities 0 0 0 0 0 0 0 0 Unit Rent $/sf #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Tenant Type % AMI 100% @ 50% 100% @ 50%
No. of Units 0 0 0 0 0 0 0 0
No. of BR/BA/Den 2 BR/2 BA 3 BR/2 BA
Rent/Month $0 $0 $0 $0 $0 $0 $0 $0
Annual Income $0 $0
11
Total Units Rental Income Other Income Laundry 0 Other 0 units @ $0.00 per month $0 units @ $0.00 per month $0 $0
Total Other Gross Income Less: Vacancy @ Credit Loss @ Total Vacancy & Credit Loss Effective Gross Income:
$0 $0
5% 0
$0 $0 $0 $0
Comments: Total net rentable area: Gross Area: Rent limits: Rent includes: Type Heat: Type A/C: Type H2O:
0 s.f. 0 s.f. 100%@ 50%of median income water, sewer and trash Electric Electric Electric
cedarforestAHPP19.xls 11/16/2008
B. Expense Summary
Per Unit ADMINISTRATIVE Advertising Office Salaries Office Supplies Office/Model Apartment (type ____) Management Fee 8.80% EGI Managers Salaries Staff Units (type ____) Legal Auditing Bookkeeping/Accounting Fees Telephone & Answering Service Tax Credit Monitoring fee Miscellaneous Administrative Total Administrative UTILITIES Fuel Oil Electric(clubhse,site,vacant) Water & Sewer Gas Total Utility OPERATING & MAINTENANCE Janitor/Cleaning Payroll Janitor/Cleaning Supplies Janitor/Cleaning Contract Exterminating Trash Removal Security Payroll/Contract Grounds Payroll Grounds Supplies Grounds Contract Maintenance/Repairs Payroll Repairs/Material Repairs Contract Elevator Maintenance/Contract Heating/Cooling Repairs & Maint. Pool Maintenance/Contract Snow Removal Decorating Payroll/Contract Carpet Supplies & Replacement Miscellaneous Operating & Maintenance Totals TAXES & INSURANCE Real Estate Taxes Other Payroll Taxes Misc. Taxes/Licenses/Per Property & Liability Insurance Fidelity Bond Workman's Compensation Health Insurance & Employee Benefits Other Insurance Total Taxes & Insurance Total Operating Expenses REPLACEMENT RESERVES TOTAL EXPENSES 727 0 0 0 0 0 0 0 0 0 0 0 0 Annual 8,000 0 0 0 0 0 0 0 0 0 0 0 0 8,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $8,000 $0 $8,000 Comments
0
0
cedarforestAHPP19.xls 11/16/2008
C. Cash Flow Summary
Rent Income Other Income GROSS INCOME Vacancy/Credit Loss EFFECTIVE GROSS INCOME Operating Expenses NET OPERATING INCOME Debt Service Cash for Distribution 0 0 $0 0 $0 8,000 ($8,000) 0 (8,000)
CASH FLOW SUMMARY - Homeownership Projects Income # of Units 0 0 0 # of BR/BA 0 0-Jan 0-Jan Square Feet 0 0 0 Sales Price $0.00 $0.00 $0.00 0 Gross Income $0.00 $0.00 $0.00
TOTAL GROSS INCOME TOTAL UNITS Expenses TOTAL Development Cost Cost of Sales Realtor Fee Seller Points Legal Fees Insurance Interest Other (describe)
0
$0.00
TOTAL Cost of Sales TOTAL EXPENSES NET INCOME
cedarforestAHPP19.xls 11/16/2008
cedarforestAHPP19.xls 11/16/2008