Financials Plaza Del Prado
Financials Plaza Del Prado
Financials Plaza Del Prado
TOTAL CASH
4,690,121
12 MONTH CASH TREND
OPERATING CASH $6,000,000.00
Beginning Cash 2,034,525 $5,000,000.00
Change in Cash (202,511)
Ending Cash 1,832,014 $4,000,000.00
Less: Accruals 329,277 $3,000,000.00
Less: Current Accounts Payable 67,484 $2,000,000.00
Adjusted Cash 1,435,253
$1,000,000.00
Due (To)/From Reserves 29,182 $-
Due (To)/From Special Assessment 98,414 APR MAY JUN JUL AUG SEP OCT NOV DEC JAN FEB MAR APR
EXPENSE SUMMARY
Account Apr Actual Apr Budget Apr Variance YTD Actual YTD YTD Variance Annual Budget Annual Variance
**TOTAL ADMINISTRATIVE 29,755 18,275 (11,480) 112,238 73,100 (39,138) 219,300 107,062
**TOTAL PROPERTY INSURANCE 58,725 64,250 5,525 236,933 257,000 20,067 771,000 534,067
**TOTAL UTILITIES 78,114 69,292 (8,822) 281,590 277,168 (4,422) 831,500 549,910
**TOTAL CONTRACTS 164,076 153,066 (11,010) 610,796 612,264 1,468 1,836,805 1,226,009
**TOTAL REPAIRS/MAINTENANCE 11,532 24,333 12,801 129,104 97,332 (31,772) 292,000 162,896
**TOTAL SPECIAL PROJECTS 24,014 22,417 (1,597) 93,947 89,668 (4,279) 269,000 175,053
CASH SUMMARY
Account Description Bank Code Beginning Balance Increases Descreases Ending Balance
Cash-Operating-Popular Community
Bank OPR1 (28,328) 455,363 (454,489) (27,454)
Cash-Operating- US Bank OPR2 1,448,273 326,365 (389,896) 1,384,743
Cash-Operating- Popular Community
Bank OPR3 2,175,660 - (190,314) 1,985,346
Cash-Operating- Popular Community
Bank OPR4 391,355 468,359 (613,661) 246,053
Cash-Reserves- US Bank RSV1 33,231 0 - 33,232
ASSETS
**CURRENT ASSETS
10010 168 Cash-Operating - US Bank 1,384,743 1,448,273 (63,530)
10010 47 Cash-Operating - Popular Community Bank 246,053 391,355 (145,302)
10010 69 Cash-Operating - Popular Community Bank (27,454) (28,328) 874
10010 69a Cash-Operating - Popular Community Bank 1,985,346 2,175,660 (190,314)
10200 Due (To)/From Reserves 29,182 29,182 0
10202 Due (To)/From Special Assessment 98,414 97,088 1,326
10300 Accounts Receivable 302,989 295,209 7,779
10310 Special Assessment Receivable 141,152 135,423 5,729
10330 00 Other Receivables 75,145 49,275 25,869
10330 27 Other Receivables - Investigated Claims 3,058 3,907 (849)
10390 00 Allowance/Bad Debts (274,150) (269,983) (4,167)
10391 AR - S/A Allowance (28,582) (28,582) 0
10500 Prepaid Insurance 247,572 304,435 (56,863)
10505 Prepaid Expenses 37,600 7,339 30,261
10534 Special Assess Escrow 133,500 90,000 43,500
10549 A/P Clearing 24,325 24,570 (245)
10550 A/R Clearing 473 2,080 (1,607)
10560 NSF in Transit 4,685 4,685 0
10005 Petty Cash 500 500 0
12090 00 Cash-Deposits Security 235,460 228,360 7,100
12090 168 Cash-Deposits - US Bank 15,843 15,843 0
12091 Due To/(From) Security (15,887) (15,887) 0
**TOTAL CURRENT ASSETS $4,619,966 $4,960,404 ($340,438)
**RESTRICTED FUNDS
12010 00 Cash-Reserves 49,952 49,950 2
12010 168 Cash-Reserves - US Bank 33,232 33,231 0
12045 Due (To)/From Operating (29,182) (29,182) 0
12048 Due To/(From) Reserves (50,297) (50,297) 0
12049 Due To/(From) Special Assessment (32,231) (30,904) (1,326)
12050 168 Cash-Spec Assess - US Bank 729,689 628,777 100,912
12050 69 Cash-Spec Assess - Popular Community Bank 37,259 43,873 (6,614)
**OTHER ASSETS
19010 Utility Deposits 305 305 0
**TOTAL OTHER ASSETS $305 $305 $0
LIABILITIES
**CURRENT LIABILITIES
20000 Accounts Payable 67,484 7,329 60,155
20010 Accrued Expenses 329,277 445,110 (115,833)
20012 Accrued Expense S/A 15,145 9,583 5,563
20030 Insurance Payable 238,832 297,533 (58,700)
20080 Security Deposits 220,460 213,360 7,100
20081 Security Deposits - Other liability 17,100 17,100 0
**RESERVE LIABILITIES
30000 00 Reserves 24,006 24,006 0
30000 001 Reserves Pooled (31,531) (31,531) 0
30000 29 Reserves Lighting (5,907) (5,907) 0
30080 Reserve-Interest 17,136 17,134 2
**TOTAL RESERVE LIABILITIES $3,704 $3,702 $2
EQUITY
**MEMBERS EQUITY
38020 00 Prior Year Adjustment (83,005) (62,254) (20,751)
38020 15 Prior Year Adjustment Expense (12,714) (12,714) 0
38880 Fund Balance 1,177,597 1,177,597 0
Current Year Net Income/(Loss) ($33,590) ($25,508) ($8,082)
Account Description Apr Actual Apr Budget Apr Variance YTD Actual YTD YTD Variance Annual Budget Annual Variance
Budget
REVENUE
40000 Owner Assessments 320,140 320,139 1 1,280,561 1,280,556 5 3,841,665 (2,561,104)
40004 Special Assess Fees 111,547 112,142 (595) 446,189 448,568 (2,379) 1,345,704 (899,515)
40011 Late Fee Income 5,140 0 5,140 15,400 0 15,400 0 15,400
40014 Legal Fee Income 208 0 208 4,193 0 4,193 0 4,193
40025 Returned Check Fees 240 131 109 995 524 471 1,575 (580)
40050 Laundry Income 6,187 5,833 354 24,485 23,332 1,153 70,000 (45,515)
40051 Dumpster Fees 0 0 0 380 0 380 0 380
40068 Key Income 720 542 178 3,520 2,168 1,352 6,500 (2,980)
40078 Late Fee Interest 1,685 0 1,685 2,022 0 2,022 0 2,022
40079 Clubhouse Fee 0 50 (50) 0 200 (200) 600 (600)
40081 Reserve Interest 2 0 2 25 0 25 0 25
40090 Miscellaneous Income 0 0 0 200 0 200 0 200
40095 Prior Yrs Srpl/(Def) 20,751 20,751 0 83,005 83,004 1 249,015 (166,010)
40115 Administrative Fee 475 0 475 570 0 570 0 570
40125 Facility Rent 0 300 (300) 0 1,200 (1,200) 3,600 (3,600)
41000 Rental Income 0 500 (500) 450 2,000 (1,550) 6,000 (5,550)
41049 Application Income 0 800 (800) 4,888 3,200 1,688 9,600 (4,712)
42020 Cable Income 2,588 2,588 (1) 10,350 10,352 (2) 31,050 (20,700)
**TOTAL REVENUE $469,683 $463,776 $5,907 $1,877,232 $1,855,104 $22,128 $5,565,309 ($3,688,077)
Account Description Apr Actual Apr Budget Apr Variance YTD Actual YTD YTD Variance Annual Budget Annual Variance
Budget
EXPENSES
**ADMINISTRATIVE
50005 Accounting Fees 542 542 0 2,167 2,168 1 6,500 4,333
50012 00 Bad Debts 4,167 4,167 0 14,342 16,668 2,326 50,000 35,658
50015 Bank Charges 32 167 135 972 668 (304) 2,000 1,028
50024 Computer Maintenance 0 167 167 77 668 591 2,000 1,923
50045 00 Legal Fees 18,276 7,500 (10,776) 60,021 30,000 (30,021) 90,000 29,979
50048 Annual Condo Fees 207 208 1 828 832 4 2,500 1,672
50050 00 License,Taxes,Permit 816 667 (149) 2,369 2,668 299 8,000 5,631
50050 80 License,Taxes,Permit - 0 833 833 156 3,332 3,176 10,000 9,844
Violations
50053 Corporate Annual Rep 5 0 (5) 20 0 (20) 0 (20)
50054 Management Collected Fees 20 575 555 25 2,300 2,275 6,900 6,875
50065 Office Equipment 317 250 (67) 1,284 1,000 (284) 3,000 1,716
50075 Office Supplies 1,001 833 (168) 5,366 3,332 (2,034) 10,000 4,634
50080 Postage & Delivery 2,147 500 (1,647) 9,703 2,000 (7,703) 6,000 (3,703)
50090 10 Professional Fees - Consultants 0 500 500 0 2,000 2,000 6,000 6,000
50100 Screening Fees 700 408 (292) 2,941 1,632 (1,309) 4,900 1,960
50109 Expense-Association Property 260 0 (260) 6,063 0 (6,063) 0 (6,063)
**TOTAL ADMINISTRATIVE $29,755 $18,275 ($11,480) $112,238 $73,100 ($39,138) $219,300 $107,062
Account Description Apr Actual Apr Budget Apr Variance YTD Actual YTD YTD Variance Annual Budget Annual Variance
Budget
**PROPERTY INSURANCE
52030 Multiperil Insurance 58,725 63,750 5,025 236,933 255,000 18,067 765,000 528,067
52039 Insurance Deductible 0 500 500 0 2,000 2,000 6,000 6,000
**TOTAL PROPERTY INSURANCE $58,725 $64,250 $5,525 $236,933 $257,000 $20,067 $771,000 $534,067
**UTILITIES
54050 00 Electricity 25,116 25,000 (116) 90,970 100,000 9,030 300,000 209,030
54070 00 Water & Sewer 47,209 37,500 (9,709) 164,399 150,000 (14,399) 450,000 285,601
54080 Gas/Fuel Oil 3,294 4,167 873 13,113 16,668 3,555 50,000 36,887
54081 Gasoline 220 125 (95) 220 500 280 1,500 1,280
54095 Trash Pickup 744 1,333 589 6,065 5,332 (733) 16,000 9,935
54100 00 Telephone 1,531 1,167 (364) 6,824 4,668 (2,156) 14,000 7,176
**TOTAL UTILITIES $78,114 $69,292 ($8,822) $281,590 $277,168 ($4,422) $831,500 $549,910
**CONTRACTS
60013 Cable Television 25,512 26,000 488 102,047 104,000 1,953 312,000 209,953
60023 Carpet Contract 213 250 37 843 1,000 157 3,000 2,157
60035 Elevator Contract 8,791 4,000 (4,791) 19,831 16,000 (3,831) 48,000 28,169
60037 08 Equipment Lease - Copier 0 334 334 0 1,336 1,336 4,005 4,005
60040 Elevator Inspection 56 208 152 225 832 607 2,500 2,275
60046 25 Equip Contract - Health Club 130 135 5 520 540 20 1,620 1,100
60050 Fire Alarm System 812 833 21 3,221 3,332 111 10,000 6,779
60063 Gen'l Salary Service 64,457 60,083 (4,374) 243,003 240,332 (2,671) 721,000 477,997
60066 Health Benefits 5,621 8,176 2,555 22,995 32,704 9,709 98,112 75,117
60070 Generator 54 125 71 216 500 284 1,500 1,284
60074 Hvac System 600 600 0 2,400 2,400 0 7,200 4,800
Account Description Apr Actual Apr Budget Apr Variance YTD Actual YTD YTD Variance Annual Budget Annual Variance
Budget
60090 Lawn Maintenance 2,370 2,000 (370) 9,480 8,000 (1,480) 24,000 14,520
61000 Management Services 9,779 9,583 (196) 39,540 38,332 (1,208) 115,000 75,460
61001 Maintenance Service 9,280 9,280 0 37,120 37,120 0 111,360 74,240
61010 Pest Control 1,370 1,370 0 5,480 5,480 0 16,440 10,960
61015 Plumbing Contract 800 800 0 3,200 3,200 0 9,600 6,400
61020 Pool/Spa Contract 890 1,000 110 3,560 4,000 440 12,000 8,440
61036 Roof Contract 533 533 0 2,133 2,132 (1) 6,400 4,267
61045 00 Security Services 29,426 24,631 (4,795) 102,420 98,524 (3,896) 295,572 193,152
61055 Trash Removal 2,385 2,125 (260) 8,578 8,500 (78) 25,496 16,918
61064 Termite Treatment 375 375 0 1,500 1,500 0 4,500 3,000
61070 Water Treatment 621 625 4 2,482 2,500 18 7,500 5,018
**TOTAL CONTRACTS $164,076 $153,066 ($11,010) $610,796 $612,264 $1,468 $1,836,805 $1,226,009
**REPAIRS/MAINTENANCE
70005 R&M-Air Conditioning 1,162 4,167 3,005 9,221 16,668 7,447 50,000 40,779
70012 R&M- Tools and Equip 409 333 (76) 573 1,332 759 4,000 3,427
70015 R&M-Sprinklers 0 417 417 0 1,668 1,668 5,000 5,000
70020 R&M-Boiler 0 417 417 13,321 1,668 (11,653) 5,000 (8,321)
70025 R&M-Building 2,744 5,000 2,256 29,963 20,000 (9,963) 60,000 30,037
70028 R&M- Fitness Center 114 83 (31) 228 332 104 1,000 772
70041 Elevator Maintenance 0 1,833 1,833 568 7,332 6,764 22,000 21,432
70045 R&M-Electrical 507 833 326 13,715 3,332 (10,383) 10,000 (3,715)
70054 R&M-Gate 90 208 118 3,897 832 (3,065) 2,500 (1,397)
70063 R&M-Generator 843 417 (426) 4,561 1,668 (2,893) 5,000 439
70065 R&M-Golf Cart 0 208 208 0 832 832 2,500 2,500
70068 R&M-Lighting 2,378 583 (1,795) 4,378 2,332 (2,046) 7,000 2,622
70084 R&M- Fire Equip 0 833 833 5,317 3,332 (1,985) 10,000 4,683
Account Description Apr Actual Apr Budget Apr Variance YTD Actual YTD YTD Variance Annual Budget Annual Variance
Budget
70090 R&M-Plumbing 0 2,500 2,500 12,996 10,000 (2,996) 30,000 17,004
70095 R&M-Pool 0 333 333 4,804 1,332 (3,472) 4,000 (804)
70098 00 R&M - Mold Remediation 0 417 417 0 1,668 1,668 5,000 5,000
**TOTAL REPAIRS/MAINTENANCE $11,532 $24,333 $12,801 $129,104 $97,332 ($31,772) $292,000 $162,896
**SPECIAL PROJECTS
74005 00 Special Projects 22,417 22,417 0 89,667 89,668 1 269,000 179,333
74005 400 Special Projects Catastrophic 1,597 0 (1,597) 4,280 0 (4,280) 0 (4,280)
Events
**TOTAL SPECIAL PROJECTS $24,014 $22,417 ($1,597) $93,947 $89,668 ($4,279) $269,000 $175,053
Account Description Apr Actual Apr Budget Apr Variance YTD Actual YTD YTD Variance Annual Budget Annual Variance
Budget
**SPECIAL ASSESSMENT
73000 Special Assess Transfer 111,547 112,142 595 446,189 448,568 2,379 1,345,704 899,515
**TOTAL SPECIAL ASSESSMENT $111,547 $112,142 $595 $446,189 $448,568 $2,379 $1,345,704 $899,515
**RESERVE TRANSFERS
80001 Reserve Interest 2 0 (2) 25 0 (25) 0 (25)
**TOTAL RESERVE TRANSFERS $2 $0 ($2) $25 $0 ($25) $0 ($25)
**TOTAL EXPENSES $477,765 $463,775 ($13,990) $1,910,822 $1,855,100 ($55,722) $5,565,309 $3,654,487